ORDBTB
Reserved for IBM internal use.
Column Descriptions:
Name Type Description ORBRFNBR INTEGER NOT NULL Reserved for IBM internal use. ORBUNBR VARCHAR (30) Reserved for IBM internal use. ORBUREQNBR VARCHAR (30) Reserved for IBM internal use. ORBVERNBR INTEGER Reserved for IBM internal use. ORBTYPE CHAR (2) Reserved for IBM internal use. ORBRLNBR VARCHAR (30) Reserved for IBM internal use. ORBNOTES1 VARCHAR (600) Reserved for IBM internal use. ORBNOTES2 VARCHAR (600) Reserved for IBM internal use. ORBSCOND CHAR (2) Reserved for IBM internal use. ORBRSDATE TIMESTAMP Reserved for IBM internal use. ORBSSDATE TIMESTAMP Reserved for IBM internal use. ORBASDATE TIMESTAMP Reserved for IBM internal use. ORBUPDATE TIMESTAMP Reserved for IBM internal use. ORBUAMDATE TIMESTAMP Reserved for IBM internal use. ORBFLAG CHAR (2) NOT NULL Reserved for IBM internal use. ORBFIELD1 VARCHAR (30) Reserved for IBM internal use. ORBFIELD2 VARCHAR (30) Reserved for IBM internal use. ORBFIELD3 VARCHAR (30) Reserved for IBM internal use. ORDERS_ID BIGINT Reserved for IBM internal use. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> ORBRFNBR Primary Key I0000636 ORDERS_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_493 ORDERS_ID ORDERS ORDERS_ID Cascade