The following example is the Output Panel received when executing the previous CREATE TABLE statement.
=> => => --------------------------------------------------------------------------- >>> Interactive SQL Service Facility SQLMAINT Output Panel S01O EDIT Member= DEPTTBL Description: CREATE TABLE DEPTTBL ------------------------------------------------------------------------------- ====== ========================== T O P ======================================= 000001 (OUTPUT CREATED FROM SOURCE MEMBER DEPTTBL ) 000002 create table depttbl 000003 (deptno char(2) not null, 000004 deptname char(24) not null, 000005 mgrnbr char(6) not null, 000006 unique (deptno, mgrnbr)); 000007 ---------+---------+---------+---------+---------+---------+---------+-- 000008 STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 000009 ---------+---------+---------+---------+---------+---------+---------+-- PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS MORE... PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
If the display is larger than your screen allows, use the PF keys to scroll to other portions of the display.
=> => => --------------------------------------------------------------------------- >>> Interactive SQL Service Facility SQLMAINT Output Panel S01O EDIT Member= DEPTTBL Description: CREATE TABLE DEPTTBL ------------------------------------------------------------------------------- 000009 ---------+---------+---------+---------+---------+---------+---------+-- 000010 SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72 000011 NUMBER OF INPUT RECORDS READ IS 0006 000012 NUMBER OF SQL STATEMENTS PROCESSED IS 0001 ====== ======================= B O T T O M ==================================== PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
In this example, a table is created with the full SQL name of JONES.DEPTTBL. The columns in the table are all character data type with lengths as specified. Since an area is not specified, the table is placed in the default area.
The combined values for the DEPTNO and MGRNBR columns must be unique for each row in the table.
Two KEY entity-occurrences are generated by CA Datacom Datadictionary during execution of the CREATE TABLE statement. The CA Datacom/DB Master and Native Key is the first column of the table, DEPTNO. The table-level UNIQUE constraint causes the generation of another KEY entity-occurrence, which contains both the DEPTNO and MGRNBR columns.
To exit from the Output Panel, you can perform one of the following.
|
Copyright © 2014 CA.
All rights reserved.
|
|