| Keyword |
Description |
Choices |
Notes |
| SQLOBJ |
SQL Object name |
Qualified object name |
Required, Positional 1 |
| Qualifier 1: SQL Object name |
Name |
| Qualifier 2: Schema (library name) |
Name, *CURLIB, *LIBL |
| OBJTYPE |
SQL object type |
ALIAS, CONSTRAINT, FUNCTION, INDEX, MASK, PERMISSION, PROCEDURE, SCHEMA, SEQUENCE, TABLE, *TABLE, TRIGGER, TYPE, VARIABLE, VIEW, XSR |
Optional, Positional 2 |
| SRCFILE |
Source file name |
Qualified object name |
Optional, Positional 3 |
| Qualifier 1: Source file name |
Name, QSQLSRC |
| Qualifier 2: Library |
Name, *CURLIB, *LIBL |
| SRCMBR |
Source member |
Name, *FILE |
Optional, Positional 4 |
| REPLACE |
Replace source member |
Logical value, *YES, *NO, *ON, *OFF, *REPLACE, *NOREPLACE |
Optional, Positional 5 |
| NAMING |
Qualified name syntax |
*SYS, *SQL |
Optional, Positional 6 |
| QUAL |
Qualified naming |
*YES, *NO |
Optional, Positional 7 |
| SQLLVL |
SQL Standards compliance |
*SYS, *DB2SQL, *ANSISQL |
Optional, Positional 8 |
| DROP |
Generate DROP file statement |
*NO, *YES |
Optional, Positional 9 |
| CRTREPLACE |
Generate CREATE or REPLACE |
*NO, *YES |
Optional, Positional 10 |
| COMMENT |
Generate header comments |
*YES, *NO |
Optional, Positional 11 |
| MSGLVL |
Message generation level |
0-39, 30 |
Optional, Positional 12 |
| SEVLVL |
Error severity level to fail |
0, 10, 20, 30, 40 |
Optional, Positional 13 |