|
To reduce the amount of time it takes to find syntax errors OS/400 has long provided information on the exact location of the syntax errors on it's green screen interfaces. For instance, the RUNSQLSTM CL command produces a spool file that lists the line number and character position on the line causing the SQL error.
Until recently the SQL Scripts window in iSeries Navigator did not provide this level of error detection. If you were executing a script of SQL statements on this interface, the entire SQL statement would be highlighted instead of pointing to the single keyword in the SQL statement.
With V5R2 iSeries Navigator has been enhanced to point to the exact SQL keyword causing the SQL error to be signalled. See example below:
This example shows a CREATE PROCEDURE statement failing with an error. Instead of highlighting all of the SQL as it has done in the past, just the "SQLC" keyword is highlighted.
This enhancement is also now available for V5R1. The V5R1 enhancement can be obtained in two ways. One way is to download the enhancement. The alternative method is to wait for the iSeries Access (formerly Client Access) V5R1 Service Pack which is currently scheduled for Dec 6, 2002.
| 
