Language commands

This table lists the specific authorities required for the language commands.

Command Referenced object Authority needed
For object For library
CLOSE Close command *USE *EXECUTE
CRTBNDC Source file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Directory specified in OUTPUT, PPSRCSTMF or MAKEDEP parameter *USE *EXECUTE
File specified in OUTPUT, PPSRCSTMF or MAKEDEP parameter Refer to the general rules. *READ, *ADD
CRTBNDCBL Source file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Binding directory *USE *EXECUTE
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTBNDCL Source file *USE *EXECUTE
Include file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. Refer to the general rules.
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTBNDCPP Source File *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Directory specified in OUTPUT, PPSRCSTMF, TEMPLATE or MAKEDEP parameter *USE *EXECUTE
File specified in OUTPUT, PPSRCSTMF, TEMPLATE or MAKEDEP parameter Refer to the general rules. *READ, *ADD
Headers generated by TEMPLATE parameter *USE *EXECUTE
CRTBNDRPG Source file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Binding directory *USE *EXECUTE
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTCBLMOD Source file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Module: REPLACE(*NO)   *READ, *ADD
Module: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTCLD Source file *USE *EXECUTE
Locale object - REPLACE(*NO)   *READ, *ADD
Locale object - REPLACE(*YES) Refer to the general rules. *READ, *ADD
CRTCLMOD Source file *USE *EXECUTE
Include file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. Refer to the general rules.
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTCLPGM Source file *USE *EXECUTE
Include file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. Refer to the general rules.
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTCBLPGM (COBOL/400* licensed program or S/38 environment) Source file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTCMOD Source file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Module: REPLACE(*NO)   *READ, *ADD
Module: REPLACE(*YES) Refer to the general rules. *READ, *ADD
File specified in OUTPUT, PPSRCSTMF or MAKEDEP parameter *USE *EXECUTE
File specified in OUTPUT, PPSRCSTMF or MAKEDEP parameter Refer to the general rules. *READ, *ADD
CRTCPPMOD Source file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Module: REPLACE(*NO)   *READ, *ADD
Module: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Directory specified in OUTPUT, PPSRCSTMF, TEMPLATE or MAKEDEP parameter *USE *EXECUTE
File specified in OUTPUT, PPSRCSTMF, TEMPLATE or MAKEDEP parameter Refer to the general rules. *READ, *ADD
Headers generated by TEMPLATE parameter *USE *EXECUTE
CRTRPGMOD Source file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Module: REPLACE(*NO)   *READ, *ADD
Module: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTRPGPGM (RPG/400* licensed program and S/38 environment) Source file *USE *EXECUTE
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTRPTPGM (RPG/400® licensed program and S/38 environment) Source file *USE *EXECUTE
Program - REPLACE(*NO)   *READ, *ADD
Program - REPLACE(*YES) Refer to the general rules. *READ, *ADD
Source file for generated RPG program Refer to the general rules. Refer to the general rules.
Externally described device files and database files referred to in source program *OBJOPR *EXECUTE
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTS36CBL (S/36 environment) Source file *USE *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
CRTS36RPG Source file *USE *READ, *ADD
Program: REPLACE(*NO)   *READ, *ADD
Program - REPLACE(*YES) Refer to the general rules. *READ, *ADD
CRTS36RPGR Source file *USE *READ, *ADD
Display file: REPLACE(*NO)   *READ, *ADD
Display file: REPLACE(*YES) Refer to the general rules. *READ, *ADD
CRTS36RPT Source file *USE *EXECUTE
Source file for generated RPG program Refer to the general rules. Refer to the general rules.
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
CRTSQLCI (DB2® Query Manager and SQL Development for IBM i licensed program) 1 Source file *OBJOPR, *READ *EXECUTE
To Source file *OBJOPR, *OBJMGT, *EXIST, *READ, *ADD, *UPDATE, *DELETE, *EXECUTE *ADD, *EXECUTE
Data description specifications *OBJOPR *EXECUTE
Object: REPLACE(*NO)   *READ, *ADD
Object: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTSQLCBL (DB2 Query Manager and SQL Development for IBM i licensed program) 1 Source file *OBJOPR, *READ *EXECUTE
To Source file *OBJOPR, *OBJMGT, *EXIST, *READ, *ADD, *UPDATE, *DELETE, *EXECUTE *ADD, *EXECUTE
Data description specifications *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTSQLCBLI (DB2 Query Manager and SQL Development for IBM i licensed program) 1 Source file *OBJOPR, *READ *EXECUTE
To Source file *OBJOPR, *OBJMGT, *EXIST, *READ, *ADD, *UPDATE, *DELETE, *EXECUTE *ADD, *EXECUTE
Data description specifications *OBJOPR *EXECUTE
Object: REPLACE(*NO)   *READ, *ADD
Object: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTSQLCPPI (DB2 Query Manager and SQL Development for IBM i licensed program) 1 Source file *OBJOPR, *READ *EXECUTE
To Source file *OBJOPR, *OBJMGT, *EXIST, *READ, *ADD, *UPDATE, *DELETE, *EXECUTE *ADD, *EXECUTE
Data description specifications *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTSQLFTN (DB2 Query Manager and SQL Development for IBM i licensed program) 1 Source file *OBJOPR, *READ *EXECUTE
To Source file *OBJOPR, *OBJMGT, *EXIST, *READ, *ADD, *UPDATE, *DELETE, *EXECUTE *ADD, *EXECUTE
Data description specifications *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTSQLPLI (DB2 Query Manager and SQL Development for IBM i licensed program) 1 Source file *OBJOPR, *READ *EXECUTE
To Source file *OBJOPR, *OBJMGT, *EXIST, *READ, *ADD, *UPDATE, *DELETE, *EXECUTE *ADD, *EXECUTE
Data description specifications *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTSQLRPG (DB2 Query Manager and SQL Development for IBM i licensed program) 1 Source file *OBJOPR, *READ *EXECUTE
To Source file *OBJOPR, *OBJMGT, *EXIST, *READ, *ADD, *UPDATE, *DELETE, *EXECUTE *ADD, *EXECUTE
Data description specifications *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CRTSQLRPGI (DB2 Query Manager and SQL Development for IBM i licensed program) 1 Source file *OBJOPR, *READ *EXECUTE
To Source file *OBJOPR, *OBJMGT, *EXIST, *READ, *ADD, *UPDATE, *DELETE, *EXECUTE *ADD, *EXECUTE
Data description specifications *OBJOPR *EXECUTE
Object: REPLACE(*NO)   *READ, *ADD
Object: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
CVTRPGSRC Source file *USE *EXECUTE
Output file *OBJOPR, *OBJMGT, *ADD *EXECUTE
Log file *OBJOPR, *OBJMGT, *ADD *EXECUTE
CVTSQLCPP 1 Source file *OBJOPR, *READ *EXECUTE
To Source file *OBJOPR, *OBJMGT, *EXIST, *READ, *ADD, *UPDATE, *DELETE, *EXECUTE *ADD, *EXECUTE
Data description specifications *OBJOPR *EXECUTE
Program: REPLACE(*NO)   *READ, *ADD
Program: REPLACE(*YES) Refer to the general rules. *READ, *ADD
Table specified in SRTSEQ parameter *USE *EXECUTE
DLTCLD Locale object *OBJEXIST, *OBJMGT *EXECUTE
ENDCBLDBG (COBOL/400 licensed program or S/38 environment) Program *CHANGE *EXECUTE
ENTCBLDBG (S/38 environment) Program *CHANGE *EXECUTE
INCLUDE Source file *USE *EXECUTE
RTVCLSRC Program *OBJMGT, *USE *EXECUTE
Service program *OBJMGT, *USE *EXECUTE
Module *OBJMGT, *USE *EXECUTE
Database source file *OBJOPR, *OBJMGT, *ADD, *DLT *EXECUTE
RTVCLDSRC Locale object *USE *EXECUTE
To-file Refer to the general rules. Refer to the general rules.
RUNSQLSTM1 Source file *OBJOPR, *READ *EXECUTE
STRCBLDBG Program *CHANGE *EXECUTE
STRREXPRC Source file *USE *EXECUTE
Exit program *USE *EXECUTE
STRSQL (DB2 Query Manager and SQL Development for IBM i licensed program) 1 Sort sequence table *USE *EXECUTE
Printer device description *USE *EXECUTE
Printer output queue *USE *EXECUTE
Printer file *USE *EXECUTE
1
See the Authorization, privileges and object ownership for more information about security requirements for structured query language (SQL) statements.