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?
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.