| View | Description |
|---|---|
| AUTHORIZATIONS | orfe authorization ID |
| CHARACTER_SETS | orfe CCSID supported |
| CHECK_CONSTRAINTS | orfe check constraint |
| COLUMN_PRIVILEGES | orfe privilege granted on a column |
| COLUMNS | orfe column |
| INFORMATION_SCHEMA_CATALOG_NAME | one row for the relational database |
| PARAMET |
| Table/View | Description |
|---|---|
| SYSCATALOGS | orfe relational database that a user can connect to |
| SYSCHKCST | orfe check constraint in the SQL schema |
| SYSCOLAUTH | orfe privilege granted on a column |
| SYSCOLUMNS | orfe column of each table and view in the SQL schema |
| SYSCOLUMNS2 | orfe column of each table and view in the SQL schema |
ALCOBJ - to allocate object
DLCOBJ - to deallocate object
Valid lock states:
IPL SRC Function Performed C1xx 1xxx Service Processor ROS IPL in progress C1xx 1006 Service processor ROS loading RAM from MFIOP directed device C1xx 1007 Service Processor ROS retrying attempt to load RAM from MFIOP directed device C1xx 1008 Service Processor ROS attempting to load RAM from non-MFIOP directed device C1xx 1009 Service Processor ROS retrying attempt to load RAM from non-MFIOP directed device C1xx 1016 Service Processor ROS attempting to load RAM from MFIOP default device
// Definition of a constant
DCL-C max_size 100;
DCL-C max_size CONST(100);
DCL-C file_name 'example.txt';
// Variable definition
DCL-S file_name CHAR(10); CHAR(bytes) ... bytes count between 1 and 16,773,104
DCL-C msg_len 5000;
DCL-S message CHAR(msg_len); (5000 bytes)
DCL-S city VARCHAR(33); VARCHAR(bytes).. bytes count between 1 and 16,773,104
DCL-S cmdparm VARCHAR(10:4); :2 or 4 byte prfx stores the length of the item
DCL-S some_number INT(10); INT(digits) ...