Liren Large Software Subsidy 5

home *** CD-ROM | disk | FTP | other *** search

/ Liren Large Software Subsidy 5 / 05.iso / a / a522 / 7.ddi / EXAMPLE.RE2 < prev next >

Wrap

Text File | 1990-12-05 | 28.1 KB | 2,880 lines

0 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 219 3 113 1 9 0 0 1 0 1 0 0 1 1 1 0 0 1 A 8 JSHERMAN 3 219 3 116 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 3 116 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 3 116 1 7 0 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 219 3 116 1 8 0 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 219 3 116 1 9 0 0 1 0 1 0 0 1 1 1 0 0 1 A 8 JSHERMAN 3 219 3 119 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 3 119 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 3 119 1 7 0 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 219 3 119 1 8 0 0 0 0 1 X 1 1 0 0 1 B 13 SRW_TEXT_LONG 1 6 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 4 TYPE 1 2 5 PANEL 1 2 4 TEXT 1 8 1 A 8 JSHERMAN 3 219 3 113 1 8 1 1 1 1 3 128 7 &DEPTNO 1 A 8 JSHERMAN 3 219 3 113 1 9 1 1 1 1 3 128 9 &sum_dept 1 A 8 JSHERMAN 3 219 3 116 1 8 1 1 1 1 3 128 6 &JOB 1 A 8 JSHERMAN 3 219 3 116 1 9 1 1 1 1 3 128 19 ---------- &sum_job 1 A 8 JSHERMAN 3 219 3 119 1 6 1 1 1 1 3 128 21 ---------- &sum_total 1 A 8 JSHERMAN 3 219 3 119 1 8 1 1 1 1 3 128 15 &SUM_SAL &Rank 1 C 13 Matrix_Report 7 SRW_STE 1 5 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 4 TYPE 1 2 4 NAME 1 1 1 A 8 JSHERMAN 3 215 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 215 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 215 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 215 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 215 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 215 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 215 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 215 3 103 1 4 6 DEPTNO 1 A 8 JSHERMAN 3 215 3 104 1 4 3 JOB 1 A 8 JSHERMAN 3 215 3 106 1 2 4 Down 1 A 8 JSHERMAN 3 215 3 107 1 3 6 G_Down 1 A 8 JSHERMAN 3 215 3 109 1 2 6 Across 1 A 8 JSHERMAN 3 215 3 110 1 3 8 G_Across 1 A 8 JSHERMAN 3 215 3 123 1 2 8 Crosstab 1 A 8 JSHERMAN 3 215 3 124 1 3 10 G_Crosstab 1 A 8 JSHERMAN 3 215 3 125 1 4 7 DEPTNO2 1 A 8 JSHERMAN 3 215 3 126 1 4 4 JOB2 1 A 8 JSHERMAN 3 215 3 127 1 4 7 SUM_SAL 1 A 8 JSHERMAN 3 215 3 128 1 5 8 SUM_DEPT 1 A 8 JSHERMAN 3 215 3 129 1 5 7 SUM_JOB 1 A 8 JSHERMAN 3 215 3 130 1 5 9 SUM_TOTAL 1 B 8 SRW_FKEY 1 6 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 8 PARENTID 1 2 11 LOCAL_TLPOS 1 2 13 FOREIGN_TLPOS 1 2 1 A 8 JSHERMAN 3 215 3 123 3 106 1 1 1 1 1 A 8 JSHERMAN 3 215 3 123 3 109 1 2 1 1 1 B 9 SRW_GROUP 2 18 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 7 QUERYID 1 2 10 PAGE_BREAK 1 2 11 GROUP_ORDER 1 2 10 REPETITION 1 2 12 LINES_BEFORE 1 2 13 SPACES_BEFORE 1 2 9 INTER_ROW 1 2 11 INTER_FIELD 1 2 12 FIELD_HILITE 1 2 12 LABEL_HILITE 1 2 12 RELATIVE_POS 1 2 13 FIELDS_ACROSS 1 2 11 MULTI_PANEL 1 1 11 MATRIX_FLAG 1 1 13 LOCATE_LABELS 1 2 1 A 8 JSHERMAN 3 215 3 107 3 106 0 1 1 1 1 0 0 0 0 0 0 0 0 0 1 X 0 1 A 8 JSHERMAN 3 215 3 110 3 109 0 1 2 1 2 0 0 0 0 0 0 0 0 0 1 X 0 1 A 8 JSHERMAN 3 215 3 124 3 123 0 1 3 1 5 0 0 0 0 0 0 0 0 0 1 X 0 1 B 9 SRW_PARAM 2 12 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 11 PARAM_ORDER 1 2 8 DATATYPE 1 2 5 WIDTH 1 2 13 DEFAULT_VALUE 1 1 5 LABEL 1 1 10 PARAM_TYPE 1 2 10 INPUT_MASK 1 1 11 OUTPUT_MASK 1 1 4 SKIP 1 1 1 A 8 JSHERMAN 3 215 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 215 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 215 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 215 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 215 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 215 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 215 2 93 3 999 1 2 1 1 0 17 Decimal Indicator 1 0 0 0 1 X 1 B 9 SRW_QUERY 1 7 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 8 PARENTID 1 2 15 MATRIX_PARENTID 1 2 11 QUERY_ORDER 1 2 5 QUERY 1 8 1 A 8 JSHERMAN 3 215 3 106 0 0 1 1 32 SELECT DISTINCT DEPTNO FROM EMP 1 A 8 JSHERMAN 3 215 3 109 0 0 1 2 29 SELECT DISTINCT JOB FROM EMP 1 A 8 JSHERMAN 3 215 3 123 3 106 3 109 1 3 79 SELECT DEPTNO, JOB, SUM(SAL) FROM EMP GROUP BY DEPTNO, JOB ORDER BY DEPTNO, JOB 1 E 31 SELECT DISTINCT DEPTNO FROM EMP 1 1 1 0 1 1 1 4 1 2 6 DEPTNO 1 E 28 SELECT DISTINCT JOB FROM EMP 1 1 1 0 1 2 1 9 1 1 3 JOB 1 E 79 SELECT DEPTNO, JOB, SUM(SAL) FROM EMP GROUP BY DEPTNO, JOB ORDER BY DEPTNO, JOB 1 3 1 0 1 1 1 2 1 1 1 4 1 9 2 40 1 2 1 1 1 2 6 DEPTNO 3 JOB 8 SUM(SAL) 1 B 10 SRW_REPORT 2 19 5 APPID 1 2 11 NEXT_ITEMID 1 2 11 REPORT_NAME 1 1 11 PAGE_HEIGHT 1 2 10 PAGE_WIDTH 1 2 11 LEFT_MARGIN 1 2 12 RIGHT_MARGIN 1 2 10 TOP_MARGIN 1 2 13 BOTTOM_MARGIN 1 2 7 VERSION 1 2 16 MODIFIED_VERSION 1 2 8 COMMENTS 1 8 5 OWNER 1 1 8 MODIFIER 1 1 11 CREATE_DATE 2 12 13 MODIFIED_DATE 2 12 11 PARAM_TITLE 1 1 10 PARAM_HINT 1 1 12 PARAM_STATUS 1 1 1 A 3 215 3 131 13 Matrix_Report 2 66 2 80 1 0 1 0 1 2 1 2 3 103 4 1110 0 8 JSHERMAN 8 JSHERMAN 14 19881212000000 14 19900821180120 0 0 0 1 B 9 SRW_FIELD 2 20 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 7 GROUPID 1 2 12 SOURCE_QUERY 1 2 15 TARGET_POSITION 1 2 7 COMPUTE 1 1 7 HEADING 1 1 4 SKIP 1 1 11 FIELD_ORDER 1 2 11 FORMAT_MASK 1 1 5 WIDTH 1 2 8 DATATYPE 1 2 8 OPERATOR 1 2 11 RESET_GROUP 1 2 7 REPRINT 1 1 12 RELATIVE_POS 1 2 12 LINES_BEFORE 1 2 13 SPACES_BEFORE 1 2 9 ALIGNMENT 1 2 1 A 8 JSHERMAN 3 215 3 103 3 107 3 106 1 1 0 0 0 1 1 0 1 2 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 215 3 104 3 110 3 109 1 1 0 0 0 1 2 0 1 9 1 2 0 0 0 0 0 0 1 2 1 A 8 JSHERMAN 3 215 3 125 3 124 3 123 1 1 0 0 1 X 1 3 0 1 4 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 215 3 126 3 124 3 123 1 2 0 0 1 X 1 4 0 1 9 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 215 3 127 3 124 3 123 1 3 0 0 0 1 5 0 2 10 1 1 0 0 0 0 0 0 0 1 B 11 SRW_SUMMARY 2 11 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 7 FIELDID 1 2 9 SUM_ORDER 1 2 8 OPERATOR 1 2 5 WIDTH 1 2 8 DATATYPE 1 2 11 FORMAT_MASK 1 1 8 PRINT_AT 1 2 8 RESET_AT 1 2 1 A 8 JSHERMAN 3 215 3 130 3 127 1 3 1 1 2 10 1 1 0 1 1 1 1 1 A 8 JSHERMAN 3 215 3 128 3 127 1 1 1 1 2 10 1 1 0 3 107 3 107 1 A 8 JSHERMAN 3 215 3 129 3 127 1 2 1 1 2 10 1 1 0 3 110 3 110 1 B 8 SRW_TEXT 2 12 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 4 TYPE 1 2 5 DIRTY 1 1 12 RELATIVE_POS 1 2 12 LINES_BEFORE 1 2 13 SPACES_BEFORE 1 2 6 REPEAT 1 1 13 JUSTIFICATION 1 2 9 FREQUENCY 1 2 5 WIDTH 1 2 1 A 8 JSHERMAN 3 215 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 3 107 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 3 107 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 3 107 1 7 0 0 0 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 215 3 107 1 8 0 0 0 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 215 3 107 1 9 0 0 0 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 215 3 110 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 3 110 1 6 0 0 0 0 0 1 3 0 0 1 A 8 JSHERMAN 3 215 3 110 1 7 0 0 0 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 215 3 110 1 8 0 0 0 0 1 X 1 3 1 0 0 1 A 8 JSHERMAN 3 215 3 110 1 9 0 0 0 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 215 3 124 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 3 124 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 215 3 124 1 7 0 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 215 3 124 1 8 0 0 0 0 1 X 1 1 0 0 1 B 13 SRW_TEXT_LONG 1 6 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 4 TYPE 1 2 5 PANEL 1 2 4 TEXT 1 8 1 A 8 JSHERMAN 3 215 3 107 1 8 1 1 1 1 3 128 7 &DEPTNO 1 A 8 JSHERMAN 3 215 3 107 1 9 1 1 1 1 3 128 9 &SUM_DEPT 1 A 8 JSHERMAN 3 215 3 110 1 9 1 1 1 1 3 128 19 ---------- &SUM_JOB 1 A 8 JSHERMAN 3 215 3 124 1 6 1 1 1 1 3 128 21 ---------- &SUM_TOTAL 1 A 8 JSHERMAN 3 215 3 124 1 8 1 1 1 1 3 128 8 &SUM_SAL 1 C 10 Sub_Report 7 SRW_STE 1 5 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 4 TYPE 1 2 4 NAME 1 1 1 A 8 JSHERMAN 3 216 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 216 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 216 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 216 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 216 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 216 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 216 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 216 3 101 1 2 5 Q_emp 1 A 8 JSHERMAN 3 216 3 102 1 3 6 G_dept 1 A 8 JSHERMAN 3 216 3 103 1 4 6 DEPTNO 1 A 8 JSHERMAN 3 216 3 104 1 4 5 EMPNO 1 A 8 JSHERMAN 3 216 3 105 1 4 5 ENAME 1 A 8 JSHERMAN 3 216 3 106 1 4 3 SAL 1 A 8 JSHERMAN 3 216 3 107 1 3 5 G_emp 1 A 8 JSHERMAN 3 216 3 108 1 5 8 Grandsal 1 A 8 JSHERMAN 3 216 3 109 1 5 6 Sumsal 1 B 8 SRW_FKEY 1 6 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 8 PARENTID 1 2 11 LOCAL_TLPOS 1 2 13 FOREIGN_TLPOS 1 2 1 B 9 SRW_GROUP 2 18 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 7 QUERYID 1 2 10 PAGE_BREAK 1 2 11 GROUP_ORDER 1 2 10 REPETITION 1 2 12 LINES_BEFORE 1 2 13 SPACES_BEFORE 1 2 9 INTER_ROW 1 2 11 INTER_FIELD 1 2 12 FIELD_HILITE 1 2 12 LABEL_HILITE 1 2 12 RELATIVE_POS 1 2 13 FIELDS_ACROSS 1 2 11 MULTI_PANEL 1 1 11 MATRIX_FLAG 1 1 13 LOCATE_LABELS 1 2 1 A 8 JSHERMAN 3 216 3 102 3 101 0 1 1 1 1 0 1 2 1 1 0 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 216 3 107 3 101 0 1 2 1 1 0 1 2 0 0 0 0 0 0 0 0 0 1 B 9 SRW_PARAM 2 12 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 11 PARAM_ORDER 1 2 8 DATATYPE 1 2 5 WIDTH 1 2 13 DEFAULT_VALUE 1 1 5 LABEL 1 1 10 PARAM_TYPE 1 2 10 INPUT_MASK 1 1 11 OUTPUT_MASK 1 1 4 SKIP 1 1 1 A 8 JSHERMAN 3 216 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 216 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 216 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 216 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 216 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 216 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 216 2 93 3 999 1 2 1 1 0 17 Decimal Indicator 1 0 0 0 1 X 1 B 9 SRW_QUERY 1 7 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 8 PARENTID 1 2 15 MATRIX_PARENTID 1 2 11 QUERY_ORDER 1 2 5 QUERY 1 8 1 A 8 JSHERMAN 3 216 3 101 0 0 0 57 Select deptno, empno, ename, sal from emp order by deptno 1 E 57 SELECT DEPTNO, EMPNO, ENAME, SAL FROM EMP ORDER BY DEPTNO 1 4 1 0 1 1 1 1 1 2 1 1 1 4 1 6 2 10 1 9 1 2 1 2 1 1 1 2 6 DEPTNO 5 EMPNO 5 ENAME 3 SAL 1 B 10 SRW_REPORT 2 19 5 APPID 1 2 11 NEXT_ITEMID 1 2 11 REPORT_NAME 1 1 11 PAGE_HEIGHT 1 2 10 PAGE_WIDTH 1 2 11 LEFT_MARGIN 1 2 12 RIGHT_MARGIN 1 2 10 TOP_MARGIN 1 2 13 BOTTOM_MARGIN 1 2 7 VERSION 1 2 16 MODIFIED_VERSION 1 2 8 COMMENTS 1 8 5 OWNER 1 1 8 MODIFIER 1 1 11 CREATE_DATE 2 12 13 MODIFIED_DATE 2 12 11 PARAM_TITLE 1 1 10 PARAM_HINT 1 1 12 PARAM_STATUS 1 1 1 A 3 216 3 110 10 Sub_Report 2 66 2 80 1 0 1 0 1 2 1 2 3 103 4 1104 0 8 JSHERMAN 7 EXAMPLE 14 19881212000000 14 19881212000000 0 0 0 1 B 9 SRW_FIELD 2 20 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 7 GROUPID 1 2 12 SOURCE_QUERY 1 2 15 TARGET_POSITION 1 2 7 COMPUTE 1 1 7 HEADING 1 1 4 SKIP 1 1 11 FIELD_ORDER 1 2 11 FORMAT_MASK 1 1 5 WIDTH 1 2 8 DATATYPE 1 2 8 OPERATOR 1 2 11 RESET_GROUP 1 2 7 REPRINT 1 1 12 RELATIVE_POS 1 2 12 LINES_BEFORE 1 2 13 SPACES_BEFORE 1 2 9 ALIGNMENT 1 2 1 A 8 JSHERMAN 3 216 3 103 3 102 3 101 1 1 0 6 Deptno 0 1 1 0 1 2 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 216 3 104 3 107 3 101 1 2 0 5 Empno 0 1 2 0 1 4 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 216 3 105 3 107 3 101 1 3 0 5 Ename 0 1 3 0 2 10 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 216 3 106 3 107 3 101 1 4 0 3 Sal 0 1 4 0 1 7 1 1 0 0 0 0 0 0 0 1 B 11 SRW_SUMMARY 2 11 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 7 FIELDID 1 2 9 SUM_ORDER 1 2 8 OPERATOR 1 2 5 WIDTH 1 2 8 DATATYPE 1 2 11 FORMAT_MASK 1 1 8 PRINT_AT 1 2 8 RESET_AT 1 2 1 A 8 JSHERMAN 3 216 3 108 3 106 1 1 1 1 1 7 1 1 0 1 1 1 1 1 A 8 JSHERMAN 3 216 3 109 3 106 1 2 1 1 1 7 1 1 0 3 102 3 102 1 B 8 SRW_TEXT 2 12 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 4 TYPE 1 2 5 DIRTY 1 1 12 RELATIVE_POS 1 2 12 LINES_BEFORE 1 2 13 SPACES_BEFORE 1 2 6 REPEAT 1 1 13 JUSTIFICATION 1 2 9 FREQUENCY 1 2 5 WIDTH 1 2 1 A 8 JSHERMAN 3 216 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 216 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 216 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 216 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 216 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 216 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 216 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 216 3 102 1 6 0 0 1 0 1 0 0 1 1 1 0 0 1 A 8 JSHERMAN 3 216 3 102 1 7 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 216 3 102 1 8 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 216 3 107 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 216 3 107 1 6 0 0 1 0 1 0 0 1 1 1 0 0 1 A 8 JSHERMAN 3 216 3 107 1 7 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 216 3 107 1 8 0 0 1 0 1 0 1 X 1 1 1 0 0 1 B 13 SRW_TEXT_LONG 1 6 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 4 TYPE 1 2 5 PANEL 1 2 4 TEXT 1 8 1 A 8 JSHERMAN 3 216 3 102 1 6 1 1 0 1 A 8 JSHERMAN 3 216 3 102 1 7 1 1 0 1 A 8 JSHERMAN 3 216 3 102 1 8 1 1 1 1 3 128 7 &DEPTNO 1 A 8 JSHERMAN 3 216 3 107 1 6 1 1 0 1 A 8 JSHERMAN 3 216 3 107 1 7 1 1 0 1 A 8 JSHERMAN 3 216 3 107 1 8 1 1 1 1 3 128 6 &EMPNO 1 C 10 Tab_Report 7 SRW_STE 1 5 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 4 TYPE 1 2 4 NAME 1 1 1 A 8 JSHERMAN 3 217 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 217 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 217 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 217 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 217 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 217 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 217 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 217 3 101 1 2 5 Q_emp 1 A 8 JSHERMAN 3 217 3 102 1 3 5 G_emp 1 A 8 JSHERMAN 3 217 3 103 1 4 6 DEPTNO 1 A 8 JSHERMAN 3 217 3 104 1 4 5 EMPNO 1 A 8 JSHERMAN 3 217 3 105 1 4 5 ENAME 1 A 8 JSHERMAN 3 217 3 106 1 4 3 SAL 1 B 8 SRW_FKEY 1 6 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 8 PARENTID 1 2 11 LOCAL_TLPOS 1 2 13 FOREIGN_TLPOS 1 2 1 B 9 SRW_GROUP 2 18 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 7 QUERYID 1 2 10 PAGE_BREAK 1 2 11 GROUP_ORDER 1 2 10 REPETITION 1 2 12 LINES_BEFORE 1 2 13 SPACES_BEFORE 1 2 9 INTER_ROW 1 2 11 INTER_FIELD 1 2 12 FIELD_HILITE 1 2 12 LABEL_HILITE 1 2 12 RELATIVE_POS 1 2 13 FIELDS_ACROSS 1 2 11 MULTI_PANEL 1 1 11 MATRIX_FLAG 1 1 13 LOCATE_LABELS 1 2 1 A 8 JSHERMAN 3 217 3 102 3 101 0 1 1 1 1 0 1 2 0 0 0 0 0 0 0 0 0 1 B 9 SRW_PARAM 2 12 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 11 PARAM_ORDER 1 2 8 DATATYPE 1 2 5 WIDTH 1 2 13 DEFAULT_VALUE 1 1 5 LABEL 1 1 10 PARAM_TYPE 1 2 10 INPUT_MASK 1 1 11 OUTPUT_MASK 1 1 4 SKIP 1 1 1 A 8 JSHERMAN 3 217 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 217 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 217 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 217 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 217 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 217 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 217 2 93 3 999 1 2 1 1 0 17 Decimal Indicator 1 0 0 0 1 X 1 B 9 SRW_QUERY 1 7 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 8 PARENTID 1 2 15 MATRIX_PARENTID 1 2 11 QUERY_ORDER 1 2 5 QUERY 1 8 1 A 8 JSHERMAN 3 217 3 101 0 0 0 42 Select deptno, empno, ename, sal from emp 1 E 41 SELECT DEPTNO, EMPNO, ENAME, SAL FROM EMP 1 4 1 0 1 1 1 1 1 2 1 1 1 4 1 6 2 10 1 9 1 2 1 2 1 1 1 2 6 DEPTNO 5 EMPNO 5 ENAME 3 SAL 1 B 10 SRW_REPORT 2 19 5 APPID 1 2 11 NEXT_ITEMID 1 2 11 REPORT_NAME 1 1 11 PAGE_HEIGHT 1 2 10 PAGE_WIDTH 1 2 11 LEFT_MARGIN 1 2 12 RIGHT_MARGIN 1 2 10 TOP_MARGIN 1 2 13 BOTTOM_MARGIN 1 2 7 VERSION 1 2 16 MODIFIED_VERSION 1 2 8 COMMENTS 1 8 5 OWNER 1 1 8 MODIFIER 1 1 11 CREATE_DATE 2 12 13 MODIFIED_DATE 2 12 11 PARAM_TITLE 1 1 10 PARAM_HINT 1 1 12 PARAM_STATUS 1 1 1 A 3 217 3 107 10 Tab_Report 2 66 2 80 1 0 1 0 1 2 1 2 3 103 4 1104 0 8 JSHERMAN 7 EXAMPLE 14 19881212000000 14 19881212000000 0 0 0 1 B 9 SRW_FIELD 2 20 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 7 GROUPID 1 2 12 SOURCE_QUERY 1 2 15 TARGET_POSITION 1 2 7 COMPUTE 1 1 7 HEADING 1 1 4 SKIP 1 1 11 FIELD_ORDER 1 2 11 FORMAT_MASK 1 1 5 WIDTH 1 2 8 DATATYPE 1 2 8 OPERATOR 1 2 11 RESET_GROUP 1 2 7 REPRINT 1 1 12 RELATIVE_POS 1 2 12 LINES_BEFORE 1 2 13 SPACES_BEFORE 1 2 9 ALIGNMENT 1 2 1 A 8 JSHERMAN 3 217 3 103 3 102 3 101 1 1 0 6 Deptno 0 1 1 0 1 2 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 217 3 104 3 102 3 101 1 2 0 5 Empno 0 1 2 0 1 4 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 217 3 105 3 102 3 101 1 3 0 5 Ename 0 1 3 0 2 10 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 217 3 106 3 102 3 101 1 4 0 3 Sal 0 1 4 0 1 7 1 1 0 0 0 0 0 0 0 1 B 11 SRW_SUMMARY 2 11 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 7 FIELDID 1 2 9 SUM_ORDER 1 2 8 OPERATOR 1 2 5 WIDTH 1 2 8 DATATYPE 1 2 11 FORMAT_MASK 1 1 8 PRINT_AT 1 2 8 RESET_AT 1 2 1 B 8 SRW_TEXT 2 12 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 4 TYPE 1 2 5 DIRTY 1 1 12 RELATIVE_POS 1 2 12 LINES_BEFORE 1 2 13 SPACES_BEFORE 1 2 6 REPEAT 1 1 13 JUSTIFICATION 1 2 9 FREQUENCY 1 2 5 WIDTH 1 2 1 A 8 JSHERMAN 3 217 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 217 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 217 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 217 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 217 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 217 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 217 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 217 3 102 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 217 3 102 1 7 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 217 3 102 1 8 0 0 1 0 1 0 1 X 1 1 1 0 0 1 B 13 SRW_TEXT_LONG 1 6 5 OWNER 1 1 5 APPID 1 2 6 ITEMID 1 2 4 TYPE 1 2 5 PANEL 1 2 4 TEXT 1 8 1 D