Using the Run SQL Scripts dialog in IBM System i Navigator, the following error is produced;The SQL statement is valid and works from the green screen SQL dialog.Why does it fail in this case?
Using The Run S 1 (118.47 KiB) Viewed 89 times
A. Naming convention was set to SQL instead of SYSTEM.
B. SELECT must be entered lower case as select for SQL statements to work from IBM System i Navigator.
C. The default relational database name is not set to "LOCAL with a default SQL naming rule.
D. The library QSYS2 was set to only allow 'LOCAL access so the file is not in the library list.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!