Liren Large Software Subsidy 5

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

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

Wrap

Text File | 1990-12-05 | 105.0 KB | 10,240 lines

16 SQL*ReportWriter5 1011012 Break_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 205 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 205 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 205 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 205 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 205 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 205 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 205 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 205 3 101 1 2 5 Q_emp 1 A 8 JSHERMAN 3 205 3 102 1 3 6 G_dept 1 A 8 JSHERMAN 3 205 3 103 1 4 6 DEPTNO 1 A 8 JSHERMAN 3 205 3 104 1 4 5 EMPNO 1 A 8 JSHERMAN 3 205 3 105 1 4 5 ENAME 1 A 8 JSHERMAN 3 205 3 106 1 4 3 SAL 1 A 8 JSHERMAN 3 205 3 107 1 3 5 G_emp 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 205 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 205 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 205 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 205 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 205 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 205 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 205 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 205 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 205 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 205 3 101 0 0 1 1 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 205 3 108 12 Break_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 19900821170235 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 205 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 205 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 205 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 205 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 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 205 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 3 102 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 3 102 1 7 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 3 102 1 8 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 3 107 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 3 107 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 3 107 1 7 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 205 3 107 1 8 0 0 0 0 0 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 C 11 Comp_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 206 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 206 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 206 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 206 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 206 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 206 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 206 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 206 3 101 1 2 7 Q_sales 1 A 8 JSHERMAN 3 206 3 102 1 3 7 G_sales 1 A 8 JSHERMAN 3 206 3 103 1 4 5 REPID 1 A 8 JSHERMAN 3 206 3 104 1 4 6 CUSTID 1 A 8 JSHERMAN 3 206 3 105 1 4 7 DOLLARS 1 A 8 JSHERMAN 3 206 3 106 1 4 4 RANK 1 A 8 JSHERMAN 3 206 3 107 1 4 7 PERCENT 1 A 8 JSHERMAN 3 206 3 108 1 5 9 Subdollar 1 A 8 JSHERMAN 3 206 3 110 1 5 10 Grandollar 1 A 8 JSHERMAN 3 206 3 111 1 3 5 G_rep 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 206 3 102 3 101 0 1 2 1 1 0 1 2 0 0 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 206 3 111 3 101 0 1 1 1 1 1 1 1 2 1 1 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 206 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 206 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 206 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 206 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 206 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 206 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 206 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 206 3 101 0 0 1 1 192 Select sales.repid, customer.custid, sum(amount) dollars from sales, customer where sales.custid = customer.custid group by sales.repid, customer.custid order by sales.repid, sum(amount) desc 1 E 191 SELECT SALES.REPID, CUSTOMER.CUSTID, SUM(AMOUNT) DOLLARS FROM SALES, CUSTOMER WHERE SALES.CUSTID = CUSTOMER.CUSTID GROUP BY SALES.REPID, CUSTOMER.CUSTID ORDER BY SALES.REPID, SUM(AMOUNT) DESC 1 3 1 0 1 1 1 1 1 1 1 6 1 8 2 40 1 2 1 2 1 2 5 REPID 6 CUSTID 7 DOLLARS 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 206 3 112 11 Comp_Report 2 66 2 80 1 0 1 0 1 2 1 2 3 103 4 1106 0 8 JSHERMAN 7 EXAMPLE 14 19881212000000 14 19890508110429 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 206 3 104 3 102 3 101 1 2 0 6 Custid 0 1 2 0 1 6 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 206 3 106 3 102 3 101 1 3 0 4 Rank 0 1 3 0 2 10 1 1 2 54 3 111 0 0 0 0 0 1 A 8 JSHERMAN 3 206 3 105 3 102 3 101 1 3 0 7 Dollars 0 1 4 9 ZZZZZZZ99 2 10 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 206 3 107 3 102 3 101 1 3 0 7 Percent 0 1 5 5 ZZZ99 2 10 1 1 1 6 3 111 0 0 0 0 0 1 A 8 JSHERMAN 3 206 3 103 3 111 3 101 1 1 0 5 Repid 0 1 1 0 1 4 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 206 3 110 3 105 1 2 1 1 2 10 1 1 6 Z99999 1 1 1 1 1 A 8 JSHERMAN 3 206 3 108 3 105 1 1 1 1 2 10 1 1 5 Z9999 3 111 3 111 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 206 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 206 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 206 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 206 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 206 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 206 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 206 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 206 3 102 1 6 1 X 0 1 0 1 0 0 1 1 1 0 0 1 A 8 JSHERMAN 3 206 3 102 1 7 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 206 3 102 1 8 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 206 3 111 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 206 3 111 1 6 1 X 0 1 0 1 0 0 1 1 1 0 0 1 A 8 JSHERMAN 3 206 3 111 1 7 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 206 3 111 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 206 3 102 1 6 1 1 1 1 3 128 61 ---------- Sum &Subdollar 1 A 8 JSHERMAN 3 206 3 102 1 7 1 1 0 1 A 8 JSHERMAN 3 206 3 102 1 8 1 1 1 1 3 128 7 &CUSTID 1 A 8 JSHERMAN 3 206 3 111 1 6 1 1 1 1 3 128 77 ---------- Sum &Grandollar 1 A 8 JSHERMAN 3 206 3 111 1 7 1 1 0 1 A 8 JSHERMAN 3 206 3 111 1 8 1 1 1 1 3 128 6 &REPID 1 C 14 Footing_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 207 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 207 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 207 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 207 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 207 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 207 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 207 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 207 3 101 1 2 5 Q_emp 1 A 8 JSHERMAN 3 207 3 102 1 3 5 G_emp 1 A 8 JSHERMAN 3 207 3 103 1 4 6 DEPTNO 1 A 8 JSHERMAN 3 207 3 104 1 4 5 EMPNO 1 A 8 JSHERMAN 3 207 3 105 1 4 5 ENAME 1 A 8 JSHERMAN 3 207 3 106 1 4 3 SAL 1 A 8 JSHERMAN 3 207 3 107 1 3 8 G_deptno 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 207 3 102 3 101 0 1 2 1 1 0 1 2 0 0 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 207 3 107 3 101 0 1 1 1 1 0 1 2 1 1 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 207 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 207 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 207 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 207 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 207 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 207 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 207 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 207 3 101 0 0 0 64 Select deptno, empno, ename, sal from emp order by deptno, empno 1 E 64 SELECT DEPTNO, EMPNO, ENAME, SAL FROM EMP ORDER BY DEPTNO, EMPNO 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 207 3 108 14 Footing_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 207 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 207 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 207 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 A 8 JSHERMAN 3 207 3 103 3 107 3 101 1 1 0 6 Deptno 0 1 1 0 1 2 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 207 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 207 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 207 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 207 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 207 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 207 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 207 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 207 3 102 1 6 1 X 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 207 3 102 1 7 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 207 3 102 1 8 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 207 3 107 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 207 3 107 1 6 1 X 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 207 3 107 1 7 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 207 3 107 1 8 1 X 0 1 1 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 207 3 102 1 6 1 1 1 1 3 128 36 ------- End of Dept &deptno ------- 1 A 8 JSHERMAN 3 207 3 102 1 7 1 1 0 1 A 8 JSHERMAN 3 207 3 102 1 8 1 1 1 1 3 128 6 &EMPNO 1 A 8 JSHERMAN 3 207 3 107 1 6 1 1 0 1 A 8 JSHERMAN 3 207 3 107 1 7 1 1 0 1 A 8 JSHERMAN 3 207 3 107 1 8 1 1 1 1 3 128 7 &DEPTNO 1 C 11 Form_Letter 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 208 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 208 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 208 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 208 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 208 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 208 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 208 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 208 3 101 1 2 5 Q_emp 1 A 8 JSHERMAN 3 208 3 102 1 3 5 G_emp 1 A 8 JSHERMAN 3 208 3 103 1 4 6 DEPTNO 1 A 8 JSHERMAN 3 208 3 104 1 4 5 EMPNO 1 A 8 JSHERMAN 3 208 3 105 1 4 5 ENAME 1 A 8 JSHERMAN 3 208 3 106 1 4 3 JOB 1 A 8 JSHERMAN 3 208 3 107 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 208 3 102 3 101 1 2 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 208 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 208 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 208 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 208 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 208 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 208 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 208 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 208 3 101 0 0 1 1 47 Select ename, empno, deptno, job, sal from emp 1 E 46 SELECT ENAME, EMPNO, DEPTNO, JOB, SAL FROM EMP 1 5 1 0 1 2 1 1 1 1 1 2 1 1 2 10 1 6 1 4 1 9 1 9 1 1 1 2 1 2 1 1 1 2 5 ENAME 5 EMPNO 6 DEPTNO 3 JOB 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 208 3 108 11 Form_Letter 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 208 3 105 3 102 3 101 1 1 0 5 Ename 0 1 1 0 2 10 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 208 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 208 3 103 3 102 3 101 1 3 0 6 Deptno 0 1 3 0 1 2 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 208 3 106 3 102 3 101 1 4 0 3 Job 0 1 4 0 1 9 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 208 3 107 3 102 3 101 1 5 0 3 Sal 0 1 5 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 208 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 208 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 208 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 208 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 208 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 208 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 208 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 208 3 102 1 6 1 X 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 208 3 102 1 7 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 208 3 102 1 8 1 X 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 208 3 102 1 7 1 1 0 1 A 8 JSHERMAN 3 208 3 102 1 8 1 1 1 1 3 128 308 Name: &ename Employee Number: &empno Department: &deptno Job: &job Salary: &sal In compliance with Federal Law, we are confirming your current salary. If this conflicts with your records, please notify your manager as soon as possible. The Audit Department 1 C 14 Heading_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 209 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 209 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 209 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 209 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 209 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 209 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 209 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 209 3 101 1 2 5 Q_emp 1 A 8 JSHERMAN 3 209 3 102 1 3 5 G_emp 1 A 8 JSHERMAN 3 209 3 103 1 4 6 DEPTNO 1 A 8 JSHERMAN 3 209 3 104 1 4 5 EMPNO 1 A 8 JSHERMAN 3 209 3 105 1 4 5 ENAME 1 A 8 JSHERMAN 3 209 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 209 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 209 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 209 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 209 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 209 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 209 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 209 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 209 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 209 3 101 0 0 0 41 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 209 3 107 14 Heading_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 209 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 209 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 209 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 209 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 209 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 209 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 209 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 209 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 209 1 2 1 5 1 X 0 0 0 0 1 3 0 0 1 A 8 JSHERMAN 3 209 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 209 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 209 3 102 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 209 3 102 1 7 0 0 1 1 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 209 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 A 8 JSHERMAN 3 209 1 2 1 5 1 1 1 1 3 128 16 Employee Summary 1 A 8 JSHERMAN 3 209 3 102 1 7 1 1 0 1 A 8 JSHERMAN 3 209 3 102 1 8 1 1 1 1 3 128 7 &DEPTNO 1 C 10 Mail_Label 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 210 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 210 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 210 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 210 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 210 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 210 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 210 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 210 3 101 1 2 6 Q_Cust 1 A 8 JSHERMAN 3 210 3 102 1 3 6 G_cust 1 A 8 JSHERMAN 3 210 3 104 1 4 4 NAME 1 A 8 JSHERMAN 3 210 3 105 1 4 7 ADDRESS 1 A 8 JSHERMAN 3 210 3 106 1 4 4 CITY 1 A 8 JSHERMAN 3 210 3 107 1 4 5 STATE 1 A 8 JSHERMAN 3 210 3 108 1 4 3 ZIP 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 210 3 102 3 101 0 1 1 1 4 1 0 1 2 1 3 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 210 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 210 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 210 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 210 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 210 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 210 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 210 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 210 3 101 0 0 1 1 66 SELECT NAME, ADDRESS, CITY, STATE, ZIP FROM CUSTOMER ORDER BY ZIP 1 E 65 SELECT NAME, ADDRESS, CITY, STATE, ZIP FROM CUSTOMER ORDER BY ZIP 1 5 1 0 1 2 1 2 1 2 1 2 1 2 2 45 2 40 2 30 1 2 1 9 1 1 1 1 1 1 1 1 1 1 4 NAME 7 ADDRESS 4 CITY 5 STATE 3 ZIP 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 210 3 113 10 Mail_Label 2 66 2 80 1 0 1 0 1 1 1 2 3 103 4 1110 0 8 JSHERMAN 8 JSHERMAN 14 19881212000000 14 19900821170320 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 210 3 104 3 102 3 101 1 1 0 0 0 1 1 0 2 30 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 210 3 105 3 102 3 101 1 2 0 0 0 1 2 0 2 30 1 2 0 0 0 1 1 0 0 0 1 A 8 JSHERMAN 3 210 3 106 3 102 3 101 1 3 0 0 0 1 3 0 2 12 1 2 0 0 0 1 1 0 0 0 1 A 8 JSHERMAN 3 210 3 107 3 102 3 101 1 4 0 0 0 1 4 0 1 2 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 210 3 108 3 102 3 101 1 5 0 0 0 1 5 0 1 5 1 2 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 210 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 210 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 210 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 210 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 210 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 210 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 210 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 210 3 102 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 210 3 102 1 7 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 210 3 102 1 8 1 X 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 210 3 102 1 7 1 1 0 1 A 8 JSHERMAN 3 210 3 102 1 8 1 1 1 1 3 128 33 &NAME &ADDRESS &CITY &STATE &ZIP 1 C 21 Master_Det_Sum_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 211 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 211 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 211 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 211 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 211 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 211 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 211 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 211 3 101 1 2 6 Q_CUST 1 A 8 JSHERMAN 3 211 3 102 1 3 6 G_CUST 1 A 8 JSHERMAN 3 211 3 103 1 4 6 CUSTID 1 A 8 JSHERMAN 3 211 3 104 1 4 4 NAME 1 A 8 JSHERMAN 3 211 3 105 1 2 6 Q_ITEM 1 A 8 JSHERMAN 3 211 3 106 1 3 6 G_ITEM 1 A 8 JSHERMAN 3 211 3 107 1 4 7 CUSTID2 1 A 8 JSHERMAN 3 211 3 109 1 4 7 DESCRIP 1 A 8 JSHERMAN 3 211 3 110 1 4 7 ITEMTOT 1 A 8 JSHERMAN 3 211 3 111 1 2 9 Q_SUMMARY 1 A 8 JSHERMAN 3 211 3 112 1 3 9 G_SUMMARY 1 A 8 JSHERMAN 3 211 3 113 1 4 7 CUSTID3 1 A 8 JSHERMAN 3 211 3 114 1 4 8 DESCRIP2 1 A 8 JSHERMAN 3 211 3 115 1 4 5 TOTAL 1 A 8 JSHERMAN 3 211 3 116 1 3 6 G_PROD 1 A 8 JSHERMAN 3 211 3 118 1 4 5 ORDID 1 A 8 JSHERMAN 3 211 3 119 1 4 8 SHIPDATE 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 211 3 105 3 101 1 1 1 1 1 A 8 JSHERMAN 3 211 3 111 3 101 1 1 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 211 3 102 3 101 1 1 1 1 1 1 0 1 2 1 2 0 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 106 3 105 1 1 1 3 1 1 0 1 2 0 0 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 112 3 111 1 1 1 4 1 1 1 1 1 0 0 0 0 0 1 1 0 0 0 0 1 A 8 JSHERMAN 3 211 3 116 3 105 1 1 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 211 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 211 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 211 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 211 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 211 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 211 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 211 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 211 3 101 0 0 1 1 53 select custid, name from customer where custid != 101 1 A 8 JSHERMAN 3 211 3 105 3 101 0 1 2 247 SELECT CUSTID, SHIPDATE, DESCRIP, ITEMTOT, ITEM.ORDID FROM ORD, PRODUCT, ITEM WHERE ITEM.ORDID = ORD.ORDID AND ITEM.PRODID = PRODUCT.PRODID AND ITEM.PRODID NOT IN (100861, 100871) ORDER BY CUSTID, DESCRIP, ORDERDATE 1 A 8 JSHERMAN 3 211 3 111 3 101 0 1 3 247 SELECT CUSTID, DESCRIP, SUM(ITEMTOT) TOTAL FROM ORD, PRODUCT, ITEM WHERE ITEM.ORDID = ORD.ORDID AND ITEM.PRODID = PRODUCT.PRODID AND ITEM.PRODID NOT IN (100861, 100871) GROUP BY CUSTID, DESCRIP ORDER BY CUSTID, DESCRIP 1 E 53 SELECT CUSTID, NAME FROM CUSTOMER WHERE CUSTID != 101 1 2 1 0 1 1 1 2 1 8 2 45 1 2 1 1 6 CUSTID 4 NAME 1 E 215 SELECT CUSTID, SHIPDATE, DESCRIP, ITEMTOT, ITEM.ORDID FROM ORD, PRODUCT, ITEM WHERE ITEM.ORDID = ORD.ORDID AND ITEM.PRODID = PRODUCT.PRODID AND ITEM.PRODID NOT IN (100861, 100871) ORDER BY CUSTID, DESCRIP, ORDERDATE 1 5 1 0 1 1 1 3 1 2 1 1 1 1 1 8 1 9 2 30 2 10 1 6 1 2 2 12 1 1 1 2 1 2 6 CUSTID 8 SHIPDATE 7 DESCRIP 7 ITEMTOT 5 ORDID 1 E 218 SELECT CUSTID, DESCRIP, SUM(ITEMTOT) TOTAL FROM ORD, PRODUCT, ITEM WHERE ITEM.ORDID = ORD.ORDID AND ITEM.PRODID = PRODUCT.PRODID AND ITEM.PRODID NOT IN (100861, 100871) GROUP BY CUSTID, DESCRIP ORDER BY CUSTID, DESCRIP 1 3 1 0 1 1 1 2 1 1 1 8 2 30 2 40 1 2 1 1 1 2 6 CUSTID 7 DESCRIP 5 TOTAL 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 211 3 120 21 Master_Det_Sum_Report 2 66 2 80 1 0 1 0 1 0 1 2 3 104 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 211 3 103 3 102 3 101 1 1 0 6 Custid 1 X 1 1 0 1 6 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 104 3 102 3 101 1 2 0 8 Customer 0 1 2 0 2 20 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 119 3 106 3 105 1 2 0 4 Date 0 1 5 0 1 9 1 3 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 110 3 106 3 105 1 4 0 4 Cost 0 1 6 9 ZZ,ZZ9.99 2 10 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 118 3 106 3 105 1 5 0 5 Ordid 1 X 1 7 0 1 4 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 113 3 112 3 111 1 1 0 6 Custid 1 X 1 8 0 1 6 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 114 3 112 3 111 1 2 0 7 Product 0 1 9 0 2 25 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 115 3 112 3 111 1 3 0 5 Total 0 2 10 9 ZZ,ZZ9.99 2 10 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 107 3 116 3 105 1 1 0 6 Custid 1 X 1 3 0 1 6 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 211 3 109 3 116 3 105 1 3 0 7 Product 0 1 4 0 2 25 1 2 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 211 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 3 102 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 3 102 1 7 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 211 3 102 1 8 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 211 3 106 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 3 106 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 3 106 1 7 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 211 3 106 1 8 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 211 3 112 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 3 112 1 6 1 X 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 3 112 1 7 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 211 3 112 1 8 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 211 3 116 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 3 116 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 211 3 116 1 7 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 211 3 116 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 211 3 102 1 7 1 1 0 1 A 8 JSHERMAN 3 211 3 102 1 8 1 1 1 1 3 128 5 &NAME 1 A 8 JSHERMAN 3 211 3 106 1 7 1 1 0 1 A 8 JSHERMAN 3 211 3 106 1 8 1 1 1 1 3 128 9 &SHIPDATE 1 A 8 JSHERMAN 3 211 3 112 1 7 1 1 1 1 3 128 80 Product Totals ------------------------------------------------ 1 A 8 JSHERMAN 3 211 3 112 1 8 1 1 1 1 3 128 28 &DESCRIP2 &TOTAL 1 A 8 JSHERMAN 3 211 3 116 1 7 1 1 0 1 A 8 JSHERMAN 3 211 3 116 1 8 1 1 1 1 3 128 8 &DESCRIP 1 C 20 Master_Detail_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 212 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 212 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 212 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 212 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 212 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 212 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 212 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 212 3 101 1 2 5 Q_rep 1 A 8 JSHERMAN 3 212 3 102 1 3 5 G_rep 1 A 8 JSHERMAN 3 212 3 103 1 4 5 ENAME 1 A 8 JSHERMAN 3 212 3 104 1 4 5 EMPNO 1 A 8 JSHERMAN 3 212 3 105 1 2 6 Q_prod 1 A 8 JSHERMAN 3 212 3 106 1 3 6 G_prod 1 A 8 JSHERMAN 3 212 3 108 1 4 8 PRODNAME 1 A 8 JSHERMAN 3 212 3 109 1 4 7 PRODSUM 1 A 8 JSHERMAN 3 212 3 110 1 2 6 Q_cust 1 A 8 JSHERMAN 3 212 3 111 1 3 6 G_cust 1 A 8 JSHERMAN 3 212 3 113 1 4 8 CUSTNAME 1 A 8 JSHERMAN 3 212 3 114 1 4 7 CUSTSUM 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 212 3 105 3 101 1 1 1 2 1 A 8 JSHERMAN 3 212 3 110 3 101 1 1 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 212 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 212 3 106 3 105 0 1 2 1 1 1 1 1 2 0 0 0 0 1 1 0 0 0 0 1 A 8 JSHERMAN 3 212 3 111 3 110 0 1 3 1 1 0 1 3 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 212 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 212 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 212 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 212 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 212 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 212 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 212 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 212 3 101 0 0 1 1 60 Select distinct ename, empno from emp where job = 'SALESMAN' 1 A 8 JSHERMAN 3 212 3 105 3 101 0 1 2 142 Select repid, prodname, sum(amount) prodsum from sales group by repid, custname, prodname order by repid, sum(amount) desc, prodname, custname 1 A 8 JSHERMAN 3 212 3 110 3 101 0 1 3 122 Select repid, custname, sum(amount) custsum from sales group by repid, custname order by repid, sum(amount) desc, custname 1 E 60 SELECT DISTINCT ENAME, EMPNO FROM EMP WHERE JOB = 'SALESMAN' 1 2 1 0 1 2 1 1 2 10 1 6 1 1 1 2 5 ENAME 5 EMPNO 1 E 142 SELECT REPID, PRODNAME, SUM(AMOUNT) PRODSUM FROM SALES GROUP BY REPID, CUSTNAME, PRODNAME ORDER BY REPID, SUM(AMOUNT) DESC, PRODNAME, CUSTNAME 1 3 1 0 1 1 1 2 1 1 1 6 2 30 2 40 1 2 1 1 1 2 5 REPID 8 PRODNAME 7 PRODSUM 1 E 122 SELECT REPID, CUSTNAME, SUM(AMOUNT) CUSTSUM FROM SALES GROUP BY REPID, CUSTNAME ORDER BY REPID, SUM(AMOUNT) DESC, CUSTNAME 1 3 1 0 1 1 1 2 1 1 1 6 2 45 2 40 1 2 1 1 1 2 5 REPID 8 CUSTNAME 7 CUSTSUM 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 212 3 115 20 Master_Detail_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 212 3 103 3 102 3 101 1 1 0 5 Ename 0 1 1 0 2 10 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 212 3 104 3 102 3 101 1 2 0 5 Empno 0 1 2 4 9999 1 4 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 212 3 108 3 106 3 105 1 2 0 8 Prodname 0 1 3 0 2 20 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 212 3 109 3 106 3 105 1 3 0 7 Prodsum 0 1 4 5 ZZZ99 1 5 1 1 0 0 0 0 0 1 8 1 2 1 A 8 JSHERMAN 3 212 3 113 3 111 3 110 1 2 0 8 Custname 0 1 5 0 2 20 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 212 3 114 3 111 3 110 1 3 0 7 Custsum 0 1 6 5 ZZZ99 1 5 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 212 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 3 102 1 6 1 X 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 3 102 1 7 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 212 3 102 1 8 1 X 0 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 212 3 106 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 3 106 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 3 106 1 7 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 212 3 106 1 8 0 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 212 3 111 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 3 111 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 212 3 111 1 7 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 212 3 111 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 212 3 102 1 7 1 1 1 1 3 128 33 Sales Rep # ---------- ----- 1 A 8 JSHERMAN 3 212 3 102 1 8 1 1 1 1 3 128 14 &ENAME &EMPNO 1 A 8 JSHERMAN 3 212 3 106 1 7 1 1 1 1 3 128 70 Product Total ------------------------- ---------- 1 A 8 JSHERMAN 3 212 3 106 1 8 1 1 1 1 3 128 9 &PRODNAME 1 A 8 JSHERMAN 3 212 3 111 1 7 1 1 1 1 3 128 61 Customer Total -------------------- ---------- 1 A 8 JSHERMAN 3 212 3 111 1 8 1 1 1 1 3 128 9 &CUSTNAME 1 C 13 Master_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 213 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 213 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 213 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 213 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 213 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 213 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 213 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 213 3 101 1 2 6 Q_cust 1 A 8 JSHERMAN 3 213 3 102 1 3 6 G_cust 1 A 8 JSHERMAN 3 213 3 104 1 2 5 Q_ord 1 A 8 JSHERMAN 3 213 3 105 1 3 5 G_ord 1 A 8 JSHERMAN 3 213 3 106 1 4 6 ORDCNT 1 A 8 JSHERMAN 3 213 3 109 1 4 7 CUSTCNT 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 213 3 102 3 101 0 1 1 1 1 0 1 2 0 0 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 213 3 105 3 104 0 1 2 1 1 1 1 1 2 0 0 0 0 1 1 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 213 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 213 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 213 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 213 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 213 2 95 3 997 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 213 2 94 3 998 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 213 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 213 3 101 0 0 1 1 47 Select count (distinct custid) custcnt from ord 1 A 8 JSHERMAN 3 213 3 104 0 0 1 2 31 Select count(*) ordcnt from ord 1 E 47 SELECT COUNT (DISTINCT CUSTID) CUSTCNT FROM ORD 1 1 1 0 1 1 2 40 1 2 7 CUSTCNT 1 E 31 SELECT COUNT(*) ORDCNT FROM ORD 1 1 1 0 1 1 2 40 1 2 6 ORDCNT 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 213 3 110 13 Master_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 213 3 109 3 102 3 101 1 1 0 0 0 1 1 0 2 10 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 213 3 106 3 105 3 104 1 1 0 0 0 1 2 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 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 213 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 213 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 213 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 213 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 213 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 213 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 213 3 102 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 213 3 102 1 6 1 X 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 213 3 102 1 7 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 213 3 102 1 8 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 213 3 105 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 213 3 105 1 6 1 X 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 213 3 105 1 7 1 X 0 1 0 1 0 1 X 1 1 1 0 0 1 A 8 JSHERMAN 3 213 3 105 1 8 1 X 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 213 3 102 1 8 1 1 1 1 3 128 36 Total number of customers: &custcnt 1 A 8 JSHERMAN 3 213 3 105 1 8 1 1 1 1 3 128 33 Total number of orders: &ordcnt 1 C 19 Matrix_Break_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 214 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 214 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 214 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 214 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 214 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 214 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 214 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 214 3 100 1 2 6 Q_CUST 1 A 8 JSHERMAN 3 214 3 101 1 3 6 G_CUST 1 A 8 JSHERMAN 3 214 3 102 1 4 6 CUSTID 1 A 8 JSHERMAN 3 214 3 103 1 4 4 NAME 1 A 8 JSHERMAN 3 214 3 104 1 4 8 ORDERTOT 1 A 8 JSHERMAN 3 214 3 105 1 6 7 CURDATE 1 A 8 JSHERMAN 3 214 3 106 1 2 8 Q_MONTHS 1 A 8 JSHERMAN 3 214 3 107 1 3 8 G_MONTHS 1 A 8 JSHERMAN 3 214 3 108 1 4 7 CUSTID2 1 A 8 JSHERMAN 3 214 3 109 1 4 10 MONTHNAME1 1 A 8 JSHERMAN 3 214 3 110 1 4 10 MONTHNAME2 1 A 8 JSHERMAN 3 214 3 111 1 4 10 MONTHNAME3 1 A 8 JSHERMAN 3 214 3 112 1 4 10 MONTHNAME4 1 A 8 JSHERMAN 3 214 3 113 1 4 10 MONTHNAME5 1 A 8 JSHERMAN 3 214 3 114 1 4 10 MONTHNAME6 1 A 8 JSHERMAN 3 214 3 115 1 2 8 Q_ORDERS 1 A 8 JSHERMAN 3 214 3 116 1 3 8 G_ORDERS 1 A 8 JSHERMAN 3 214 3 117 1 4 7 CUSTID3 1 A 8 JSHERMAN 3 214 3 118 1 4 6 PRODID 1 A 8 JSHERMAN 3 214 3 119 1 4 4 MON1 1 A 8 JSHERMAN 3 214 3 120 1 4 4 MON2 1 A 8 JSHERMAN 3 214 3 121 1 4 4 MON3 1 A 8 JSHERMAN 3 214 3 122 1 4 4 MON4 1 A 8 JSHERMAN 3 214 3 123 1 4 4 MON5 1 A 8 JSHERMAN 3 214 3 124 1 4 4 MON6 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 214 3 106 3 100 1 1 1 1 1 A 8 JSHERMAN 3 214 3 115 3 100 1 1 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 214 3 101 3 100 0 1 1 1 1 0 0 1 3 1 3 0 0 0 0 0 0 1 2 1 A 8 JSHERMAN 3 214 3 107 3 106 0 1 2 1 1 1 2 1 0 0 0 0 0 1 1 0 0 0 0 1 A 8 JSHERMAN 3 214 3 116 3 115 0 1 3 1 1 0 1 0 0 0 0 0 1 1 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 214 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 214 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 214 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 214 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 214 2 95 1 5 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 214 2 94 1 6 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 214 2 93 1 7 1 2 1 1 0 17 Decimal Indicator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 214 3 105 1 8 1 3 1 9 9 01-SEP-86 7 Curdate 1 1 0 0 0 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 214 3 100 0 0 1 1 222 select customer.custid, name, sum(total) ordertot from customer, ord where customer.custid = ord.custid and orderdate between add_months(:curdate, -5) and :curdate group by customer.custid, name order by sum(total) desc 1 A 8 JSHERMAN 3 214 3 106 3 100 0 1 2 400 select custid, to_char(add_months(:curdate, -5), 'MON YY') monthname1, to_char(add_months(:curdate, -4), 'MON YY') monthname2, to_char(add_months(:curdate, -3), 'MON YY') monthname3, to_char(add_months(:curdate, -2), 'MON YY') monthname4, to_char(add_months(:curdate, -1), 'MON YY') monthname5, to_char(to_date(:curdate), 'MON YY') monthname6 from customer 1 A 8 JSHERMAN 3 214 3 115 3 100 0 1 3 766 select custid, prodid, sum( decode( to_char( orderdate, 'MONYY'), to_char( add_months( :curdate, -5), 'MONYY'), itemtot, 0)) mon1, sum( decode( to_char( orderdate, 'MONYY'), to_char( add_months( :curdate, -4), 'MONYY'), itemtot, 0)) mon2, sum( decode( to_char( orderdate, 'MONYY'), to_char( add_months( :curdate, -3), 'MONYY'), itemtot, 0)) mon3, sum( decode( to_char( orderdate, 'MONYY'), to_char( add_months( :curdate, -2), 'MONYY'), itemtot, 0)) mon4, sum( decode( to_char( orderdate, 'MONYY'), to_char( add_months( :curdate, -1), 'MONYY'), itemtot, 0)) mon5, sum( decode( to_char( orderdate, 'MONYY'), to_char( to_date( :curdate), 'MONYY'), itemtot, 0)) mon6 from ord, item where ord.ordid = item.ordid group by custid, prodid order by custid, prodid 1 E 219 SELECT CUSTOMER.CUSTID, NAME, SUM(TOTAL) ORDERTOT FROM CUSTOMER, ORD WHERE CUSTOMER.CUSTID = ORD.CUSTID AND ORDERDATE BETWEEN ADD_MONTHS(:CURDATE, -5) AND :CURDATE GROUP BY CUSTOMER.CUSTID, NAME ORDER BY SUM(TOTAL) DESC 1 3 1 1 1 1 1 2 1 1 1 8 2 45 2 40 1 2 1 1 1 2 6 CUSTID 4 NAME 8 ORDERTOT 3 105 1 E 356 SELECT CUSTID, TO_CHAR(ADD_MONTHS(:CURDATE, -5), 'MON YY') MONTHNAME1, TO_CHAR(ADD_MONTHS(:CURDATE, -4), 'MON YY') MONTHNAME2, TO_CHAR(ADD_MONTHS(:CURDATE, -3), 'MON YY') MONTHNAME3, TO_CHAR(ADD_MONTHS(:CURDATE, -2), 'MON YY') MONTHNAME4, TO_CHAR(ADD_MONTHS(:CURDATE, -1), 'MON YY') MONTHNAME5, TO_CHAR(TO_DATE(:CURDATE), 'MON YY') MONTHNAME6 FROM CUSTOMER 1 7 1 1 1 1 1 2 1 2 1 2 1 2 1 2 1 2 1 8 2 75 2 75 2 75 2 75 2 75 2 75 1 2 1 1 1 1 1 1 1 1 1 1 1 1 6 CUSTID 10 MONTHNAME1 10 MONTHNAME2 10 MONTHNAME3 10 MONTHNAME4 10 MONTHNAME5 10 MONTHNAME6 3 105 1 E 754 SELECT CUSTID, PRODID, SUM( DECODE( TO_CHAR( ORDERDATE, 'MONYY'), TO_CHAR( ADD_MONTHS( :CURDATE, -5), 'MONYY'), ITEMTOT, 0)) MON1, SUM( DECODE( TO_CHAR( ORDERDATE, 'MONYY'), TO_CHAR( ADD_MONTHS( :CURDATE, -4), 'MONYY'), ITEMTOT, 0)) MON2, SUM( DECODE( TO_CHAR( ORDERDATE, 'MONYY'), TO_CHAR( ADD_MONTHS( :CURDATE, -3), 'MONYY'), ITEMTOT, 0)) MON3, SUM( DECODE( TO_CHAR( ORDERDATE, 'MONYY'), TO_CHAR( ADD_MONTHS( :CURDATE, -2), 'MONYY'), ITEMTOT, 0)) MON4, SUM( DECODE( TO_CHAR( ORDERDATE, 'MONYY'), TO_CHAR( ADD_MONTHS( :CURDATE, -1), 'MONYY'), ITEMTOT, 0)) MON5, SUM( DECODE( TO_CHAR( ORDERDATE, 'MONYY'), TO_CHAR( TO_DATE( :CURDATE), 'MONYY'), ITEMTOT, 0)) MON6 FROM ORD, ITEM WHERE ORD.ORDID = ITEM.ORDID GROUP BY CUSTID, PRODID ORDER BY CUSTID, PRODID 1 8 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 8 1 8 2 40 2 40 2 40 2 40 2 40 2 40 1 2 1 2 1 2 1 2 1 2 1 2 1 2 1 2 6 CUSTID 6 PRODID 4 MON1 4 MON2 4 MON3 4 MON4 4 MON5 4 MON6 3 105 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 214 3 125 19 Matrix_Break_Report 2 66 2 80 1 0 1 0 1 2 1 2 4 1108 4 1108 2 8 JSHERMAN 7 EXAMPLE 14 19890918203007 14 19891103092150 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 214 3 102 3 101 3 100 1 1 0 9 Customer: 1 X 1 1 0 1 8 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 103 3 101 3 100 1 2 0 0 0 1 2 0 2 45 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 104 3 101 3 100 1 3 0 15 Total Purchases 0 1 3 9 $BZZZ,ZZ9 1 9 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 108 3 107 3 106 1 1 0 6 Custid 1 X 1 4 0 1 8 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 109 3 107 3 106 1 2 0 0 0 1 5 0 1 6 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 110 3 107 3 106 1 3 0 0 0 1 6 0 1 6 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 111 3 107 3 106 1 4 0 0 0 1 7 0 1 6 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 112 3 107 3 106 1 5 0 0 0 1 8 0 1 6 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 113 3 107 3 106 1 6 0 0 0 1 9 0 1 6 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 114 3 107 3 106 1 7 0 0 0 2 10 0 1 6 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 117 3 116 3 115 1 1 0 6 Custid 1 X 2 11 0 1 8 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 118 3 116 3 115 1 2 0 0 0 2 12 0 1 8 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 119 3 116 3 115 1 3 0 0 0 2 13 6 ZZ,ZZZ 1 6 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 120 3 116 3 115 1 4 0 0 0 2 14 6 ZZ,ZZZ 1 6 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 121 3 116 3 115 1 5 0 0 0 2 15 6 ZZ,ZZZ 1 6 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 122 3 116 3 115 1 6 0 0 0 2 16 6 ZZ,ZZZ 1 6 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 123 3 116 3 115 1 7 0 0 0 2 17 6 ZZ,ZZZ 1 6 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 214 3 124 3 116 3 115 1 8 0 0 0 2 18 6 ZZ,ZZZ 1 6 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 214 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 1 2 1 5 1 X 0 0 0 0 1 3 0 0 1 A 8 JSHERMAN 3 214 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 3 101 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 3 101 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 3 101 1 7 0 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 214 3 101 1 8 0 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 214 3 107 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 3 107 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 3 107 1 7 0 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 214 3 107 1 8 1 X 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 214 3 116 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 3 116 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 214 3 116 1 7 0 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 214 3 116 1 8 0 1 4 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 214 1 2 1 5 1 1 1 1 3 128 68 Product Sales By Customer For Six Months Ending &Curdate Page &page 1 A 8 JSHERMAN 3 214 3 101 1 8 1 1 1 1 3 128 33 &NAME Total Purchases &ORDERTOT 1 A 8 JSHERMAN 3 214 3 107 1 8 1 1 1 1 3 128 144 Product &MONTHNAME1 &MONTHNAME2 &MONTHNAME3 &MONTHNAME4 &MONTHNAME5 &MONTHNAME6 -------- ------ ------ ------ ------ ------ ------ 1 A 8 JSHERMAN 3 214 3 116 1 8 1 1 1 1 3 128 49 &PRODID &MON1 &MON2 &MON3 &MON4 &MON5 &MON6 1 C 21 Matrix_Ranking_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 219 2 93 1 6 7 DECIMAL 1 A 8 JSHERMAN 3 219 2 94 1 6 9 THOUSANDS 1 A 8 JSHERMAN 3 219 2 95 1 6 8 CURRENCY 1 A 8 JSHERMAN 3 219 2 96 1 6 6 COPIES 1 A 8 JSHERMAN 3 219 2 97 1 6 9 DESFORMAT 1 A 8 JSHERMAN 3 219 2 98 1 6 7 DESNAME 1 A 8 JSHERMAN 3 219 2 99 1 6 7 DESTYPE 1 A 8 JSHERMAN 3 219 3 112 1 2 4 down 1 A 8 JSHERMAN 3 219 3 113 1 3 6 G_down 1 A 8 JSHERMAN 3 219 3 114 1 4 6 DEPTNO 1 A 8 JSHERMAN 3 219 3 115 1 2 6 across 1 A 8 JSHERMAN 3 219 3 116 1 3 8 G_across 1 A 8 JSHERMAN 3 219 3 117 1 4 3 JOB 1 A 8 JSHERMAN 3 219 3 118 1 2 8 crosstab 1 A 8 JSHERMAN 3 219 3 119 1 3 10 G_crosstab 1 A 8 JSHERMAN 3 219 3 120 1 4 7 DEPTNO2 1 A 8 JSHERMAN 3 219 3 121 1 4 4 JOB2 1 A 8 JSHERMAN 3 219 3 122 1 4 7 SUM_SAL 1 A 8 JSHERMAN 3 219 3 124 1 5 8 sum_dept 1 A 8 JSHERMAN 3 219 3 125 1 5 7 sum_job 1 A 8 JSHERMAN 3 219 3 126 1 5 9 sum_total 1 A 8 JSHERMAN 3 219 3 132 1 4 4 Rank 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 219 3 118 3 112 1 1 1 1 1 A 8 JSHERMAN 3 219 3 118 3 115 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 219 3 113 3 112 0 1 1 1 1 0 0 0 0 0 0 0 0 0 1 X 0 1 A 8 JSHERMAN 3 219 3 116 3 115 0 1 2 1 2 0 0 0 0 0 0 0 0 0 1 X 0 1 A 8 JSHERMAN 3 219 3 119 3 118 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 219 2 99 1 1 1 2 2 80 6 Screen 16 Destination Type 1 0 0 0 0 1 A 8 JSHERMAN 3 219 2 98 1 2 1 2 2 80 0 24 File Name / Spool Device 1 0 0 0 0 1 A 8 JSHERMAN 3 219 2 97 1 3 1 2 2 80 4 dflt 24 Printer Description File 1 0 0 0 0 1 A 8 JSHERMAN 3 219 2 96 1 4 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 0 1 A 8 JSHERMAN 3 219 2 95 1 5 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 8 JSHERMAN 3 219 2 94 1 6 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 8 JSHERMAN 3 219 2 93 1 7 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 219 3 112 0 0 1 1 31 select distinct deptno from emp 1 A 8 JSHERMAN 3 219 3 115 0 0 1 2 28 select distinct job from emp 1 A 8 JSHERMAN 3 219 3 118 3 112 3 115 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 219 3 133 21 Matrix_Ranking_Report 2 66 2 80 1 0 1 0 1 2 1 2 4 1110 4 1110 0 8 JSHERMAN 5 SCOTT 14 19900717180709 14 19900821181156 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 219 3 114 3 113 3 112 1 1 0 0 0 1 1 0 1 4 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 219 3 117 3 116 3 115 1 1 0 0 0 1 2 0 1 9 1 2 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 219 3 120 3 119 3 118 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 219 3 121 3 119 3 118 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 219 3 122 3 119 3 118 1 3 0 0 0 1 5 0 2 10 1 1 0 0 0 0 0 0 0 1 A 8 JSHERMAN 3 219 3 132 3 119 1 0 1 0 123 &SQL select sum(count(distinct deptno)) into :rank from emp group by deptno, job having job = :job and sum(sal) >= :sum_sal 0 0 1 6 0 1 1 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 219 3 126 3 122 1 3 1 1 2 10 1 1 0 1 1 1 1 1 A 8 JSHERMAN 3 219 3 124 3 122 1 1 1 1 2 10 1 1 0 3 113 3 113 1 A 8 JSHERMAN 3 219 3 125 3 122 1 2 1 1 2 10 1 1 0 3 116 3 116 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 219 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 1 1 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 1 2 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 3 113 1 5 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 3 113 1 6 0 0 0 0 0 1 1 0 0 1 A 8 JSHERMAN 3 219 3 113 1 7 0 0 0 0 1 X 1 1 0 0 1 A 8 JSHERMAN 3 219 3 113 1 8