SQL/Pro - Version 5.0

Date: 03/04/2022

Type: Fix
Description: Running script in batch mode and wanting the results in an outfile was not producing the file.

Date: 04/19/2021

Type: Fix
Description: Fixed issue with database changes from RUNPDSQL not appearing in SQL Audit.

Type: Fix
Description: Fixed issue with some database changes from RUNPDSQL not appearing in SQL Audit.

Date: 03/19/2021

Type: Fix
Description: Fixed issue in UPDATE prompting with WHERE clause not being loaded properly.

Type: Fix
Description: Fixed issue in DELETE prompting with WHERE clause not being loaded properly.

Date: 09/29/2020

Type: Fix
Description: Corrected issue with undisplayable characters in fields causing the Results screen/program to crash.

Date: 05/27/2020

Type: Fix
Description: Fixed issue with substitution variables in SQL statements.

Date: 09/06/2019

Type: Fix
Description: Fixed issue with how NULLS were being displayed.

Date: 02/04/2019

Type: Fix
Description: Corrected issue with how formatted statements are displaying on 80 column screens.

Date: 01/28/2019

Type: Fix
Description: Fixed issue with using a 3rd member name in an INSERT statement.

Date: 04/26/2018

Type: Fix
Description: Fixed issue when running Saved Queries the run was looping.

Type: Fix
Description: Work with Queries screen was not displaying Queries that were missing *FORM objects.

Date: 08/10/2017

Type: Fix
Description: Corrected issue with message CPF2817 (Copy command ended because of error) in program SQLC0401 when using RUNPDSQL command and SQLPRO50 library is ahead of QTEMP in the library list.

Date: 03/03/2017

Type: Fix
Description: Fixed error when pressing F17 from main SQL/PRO screen and entering a generic library name.

Date: 02/27/2017

Type: Fix
Description: SELECT statements run against tables with BLOB type columns defined will no longer crash and the resulting column will contain "*POINTER".

Type: Fix
Description: F22=Toggle LineNo mode will be turned off and messages displayed when Position to Line (B)ottom is submitted due to inaccuracy in the LineNo's displayed.

Date: 06/08/2016

Type: Fix
Description: Corrected to handle negative (-#) "Shift to column:" values.

Date: 03/01/2016

Type: Fix
Description: Not all of the SQL/PRO screens are handling the F3=Exit consistently. Many screens have been modified to return to the caller of SQL/PRO when F3=Exit is pressed.

Type: Fix
Description: F2=Run has been added to the SQL/PRO Report Designer screen. F3=Exit will now exit the screen without running the SQL statement.

Type: Fix
Description: The Work with Saved Queries screen has been modified to not show the Queries if they have been deleted or moved by the user.

Type: Fix
Description: When F12=Cancel is pressed in the Report Designer after pressing F6=Add the new line is not inserted.

Type: Customer Request
Description: Added ability to set the default Date Format for Date columns/fields. Date Format can be set in data area SQLPRODTFM as '*ISO', '*USA', '*EUR', '*JIS', '*MDY', '*DMY', '*YMD', '*JUL', or '*JOB'. The Date Separator character can be set in data area SQLPRODTSP to '/', '-', '.', ',', ' ', ':', or '*JOB'.

Type: Customer Request
Description: Retain File Field Selection screen values for the STRPDSQL session.

Date: 11/12/2015

Type: Fix
Description: Not all of the SQL/PRO screens were handling the F3=Exit consistently. Many screens have been modified to return to the caller of SQL/PRO when F3=Exit is pressed.

Date: 11/04/2015

Type: Fix
Description: Corrected issue with F4=Prompt on SELECT statements not displaying the FROM tables/views/files correctly.

Type: Fix
Description: Corrected issue with SQL/Pro Table (File) Selection not loading the Table/View/(File) list properly.

Type: Fix
Description: Added MemberName prompt to the SQL/Pro Table (File) Selection screen.

Date: 10/21/2015

Type: Fix
Description: Customer was receiving error "CPF6AC7 received by procedure SQLPROMNUC" when executing SQLPROMNU command.

Type: Fix
Description: Member support "{MemberName}" from the interactive SQL/PRO screen has been added. We are still researching some issues with Saved Queries.

Type: Fix
Description: When executing a SELECT against QSYS2.USER_INFO not all of the rows were being returned.

Type: Fix
Description: After executing an SQL statement from the full screen the split screen will be displayed to show any resulting errors or messages.

Date: 09/21/2015

Type: Fix
Description: Corrected an issue when user was trying to modify a Saved Query and the changes were not being saved.

Date: 09/11/2015

Type: Customer Request
Description: After executing a SELECT statement the Output will always be reset to "Display" to prevent the user from accidentally overwriting an output file or producing extra spool files inadvertently.

Date: 08/24/2015

Type: New
Description: A new function key F16=Join line has been added to the SQL statement screen to join the text following the cursor to the text preceding the cursor.

Type: Fix
Description: Command RUNPDSQL was not always returning an *ESCAPE error message when the SQL Statement failed to execute.

Type: Fix
Description: If F6=Insert line, F10=Copy line, F14=Delete line, or F15=Split line pressed when the cursor is placed in the SQL statement history part of the screen the program no longer crashes. No processing is performed when on a split screen and the function keys will not be allowed on a full History screen.

Type: Customer Request
Description: Allow INSERT & DELETE keys to function through out the entire portion of the SQL statement displayed on the SQL/PRO 5.0 screen.

Date: 07/16/2015

Type: Fix
Description: When Output is Outfile and the Option is 2=Replace the Table/File will be replaced if it exists.

Type: Customer Request
Description: The number of rows affected on INSERT, UPDATE, & DELETE statements will now be shown to the user on the history display.

Date: 07/10/2015

Type: Fix
Description: The Results screen will now display a reverse image rectangle in place of un-displayable character(s) and a message at the bottom of the screen.

Type: Fix
Description: Un-displayable data in a table was causing a crash. The Results screen will now display a reverse image rectangle in place of un-displayable character and a message at the bottom of the screen.

Date: 07/08/2015

Type: Fix
Description: A statement beginning with "delete * from" was responding with incorrect error message of "Not authorized to SQL DELETE * statement." rather than correct error message of "Token * was not valid. Valid tokens:".

Date: 06/25/2015

Type: New
Description: Added F16=Clear to Subset window to clear the subset prompts.

Type: New
Description: Added SQLAUDCFG command to configure SQL Audit for SQL/Pro.

Type: Fix
Description: Work with Saved Queries library change was not being retained for User.

Type: Fix
Description: F4=Prompt on SELECT tables was not displaying Schemas & Tables if customers system CCSID is 65535.

Date: 06/17/2015

Type: New
Description: DROP VIEW prompt screen changed to allow full Schema and Table names.

Type: New
Description: Allow double clicking on SQL History statement to function same as F9=Retrieve.

Type: Fix
Description: CREATE VIEW F20=Full Name prompt not keeping full name.

Type: Fix
Description: F4=Prompt on SELECT tables was not displaying Schemas and Tables if customers system CCSID is 65535.

Date: 06/12/2015

Type: Fix
Description: Correct issue with SELECT's using COUNT aggregate function.

Type: Fix
Description: F12 on CREATE VIEW prompt to keep previous statement.

Type: Customer Request
Description: Add F22=Toggle LineNo to Results display to toggle displaying of the results line number.

Date: 06/01/2015

Type: New
Description: Allow users with *SECADM authority to execute command SQLAUT.

Type: New
Description: Automatically insert quotes to values if needed by type and not already keyed on INSERT prompting.

Type: Fix
Description: Corrected issue with INSERT statement not wrapping on display properly.

Type: Fix
Description: Prompt of CREATE VIEW statement not always returning statement.

Date: 05/14/2015

Type: Fix
Description: F9=Retrieve was retrieving SQL statement error message.

Type: Fix
Description: User was receiving "Token / was not valid. Valid tokens: IDENTIFIER" error when outputting to a file.

Date: 05/05/2015

Type: Fix
Description: Allow data type of BIGINT on CREATE TABLE statement.

Type: Fix
Description: Column/Field Heading was carrying over from previous Column Field on SQL/PRO Report Designer screen.

Date: 04/21/2015

Type: Fix
Description: F13=Work with saved queries was returning only one line and not the complete statement.

Type: Fix
Description: Allow a WITH (CTE) statement to be executed.

Date: 04/17/2015

Type: Fix
Description: F9=Retrieve was not always retrieving selected statement.

Type: Fix
Description: Added environments where the command SQLSEC is allowed to run.

Date: 04/14/2015

Type: New
Description: Added prompting ability for CREATE ALIAS statement.

Type: New
Description: Added prompting ability for DROP ALIAS statement.

Date: 04/07/2015

Type: Fix
Description: SQLSEC was giving message of license permanently installed but was not creating an entry in license information.

Type: Fix
Description: Added environments where the command STRPDSQL is allowed to be executed from.

Date: 04/01/2015

Type: New
Description: Many of the SQL/PRO screens have been enhanced to display in 132 column mode if workstation default is set to 132 column mode.

Type: New
Description: Many of the screens now support the capability to display text in other languages in addition to English. The language can be specified by User. Currently only English and Spanish are provided but if you are able to assist us we can easily provide a version with your requested language.

Type: New
Description: The main SQL/PRO screen has been enhanced to display the current SQL statement and the users SQL statement history in a split screen format. The SQL statement history now displays multiple statements on the screen rather than a single statement.

Type: New
Description: An F2=Subset function key has been added to the main SQL/PRO screen to allow users to subset the displayed SQL statement history based on their keyed criteria.

Type: New
Description: SQL Audit is now included with SQL/PRO to allow users to track and monitor modifications made to the IBM i database using SQL/PRO. All data inserts, changes and/or deletes are tracked thru journals which are active only during the execution of each SQL statement or, if journaling is already activated, will use your current journals. SQL Audit also features an interface to display and report these changes for internal audits and compliance tracking.

Type: New
Description: SQL/PRO has been enhanced to use the latest IBM i SQL Query Engine resulting in improved SQL query performance.