TABLE = SRS.STRUCTURE *********COLUMNS********** Column Name Type Length Attributes ----------- ---- ------ ---------- STRUCTURE_NAME Character (Fixed) 8 Data required, Text DESCRIPTION Character (Fixed) 30 Text PREFIX ** Character (Fixed) 4 Text ** ex. (05 IN-Data-Record. The 'IN' is the prefix. Currently, a prefix can only be three characters plus a '-'. This will be changed in later implementations so the '-' will be added automatically.) *******INDEXES************ Index Name: Duplicates Allowed: Column Name Order ----------- ----- *******PRIMARY KEY ********* Index Name: SYSIBM.SQLxxxxxxxxxxx where xxxxxxx is a system generated name Column Name Order ----------- ----- STRUCTURE_NAME Ascending *******FOREIGN KEYS********** Foreign Key Name: Parent table name . . Delete Rule . . . . . Columns ______________________________________________________________________________________________________________ TABLE = SRS.ELEMENT_STRUCTURE *********COLUMNS********** Column Name Type Length Attributes ----------- ---- ------ ---------- ELEMENT_NAME* Character (Fixed) 25 Data required, Text STRUCTURE_NAME Character (Fixed) 8 Data required, Text ELEMENT_LENGTH Small Integer ELEMENT_POSITION** Small Integer Data required ELEMENT_LEVEL Character (Fixed) 2 Data required, Text ELEMENT_PICTURE*** Character (Fixed) 15 Text ELEMENT_VALUE**** Character (Fixed) 40(max for now) Text * ex. (05 IN01-Data-Record. The 'Data-Record' is the ELEMENT_NAME) ** This is the position of the element in the structure ex. 01 IN-Data-Record pos 1 05 IN-Record-Key. pos 2 *** This includes the word 'PIC' in the database **** Must begin and end with "'" single quotes. Do not code the word 'VALUE' at the beginning. *******INDEXES************ Index Name: Duplicates Allowed: Column Name Order ----------- ----- *******PRIMARY KEY ********* Index Name: SYSIBM.SQLxxxxxxxxxxx where xxxxxxx is a system generated name Column Name Order ----------- ----- ELEMENT_NAME Ascending STRUCTURE_NAME Ascending *******FOREIGN KEYS********** Foreign Key Name: ESTRUC1 Parent table name . . SRS.ELEMENT Delete Rule . . . . . Cascade deletes Columns ------- ELEMENT_NAME Foreign Key Name: ESTRUC2 Parent table name . . SRS.STRUCTURE Delete Rule . . . . . Cascade deletes COLUMNS ------- STRUCTURE_NAME