Liren Large Software Subsidy 5

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

/ Liren Large Software Subsidy 5 / 05.iso / a / a523 / 37.ddi / SRW175.REX < prev next >

Wrap

OS/2 REXX Batch file | 1990-12-05 | 65.7 KB | 5,529 lines

16 SQL*ReportWriter5 101106 srw175 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 5 SCOTT 3 121 2 93 1 6 7 DECIMAL 1 A 5 SCOTT 3 121 2 94 1 6 9 THOUSANDS 1 A 5 SCOTT 3 121 2 95 1 6 8 CURRENCY 1 A 5 SCOTT 3 121 2 96 1 6 6 COPIES 1 A 5 SCOTT 3 121 2 97 1 6 9 DESFORMAT 1 A 5 SCOTT 3 121 2 98 1 6 7 DESNAME 1 A 5 SCOTT 3 121 2 99 1 6 7 DESTYPE 1 A 5 SCOTT 3 121 3 103 1 2 8 Q_REPORT 1 A 5 SCOTT 3 121 3 104 1 3 8 G_REPORT 1 A 5 SCOTT 3 121 3 108 1 4 11 PAGE_HEIGHT 1 A 5 SCOTT 3 121 3 109 1 4 10 PAGE_WIDTH 1 A 5 SCOTT 3 121 3 110 1 4 11 LEFT_MARGIN 1 A 5 SCOTT 3 121 3 111 1 4 12 RIGHT_MARGIN 1 A 5 SCOTT 3 121 3 112 1 4 10 TOP_MARGIN 1 A 5 SCOTT 3 121 3 113 1 4 13 BOTTOM_MARGIN 1 A 5 SCOTT 3 121 3 116 1 4 8 COMMENTS 1 A 5 SCOTT 3 121 3 117 1 4 5 OWNER 1 A 5 SCOTT 3 121 3 118 1 4 8 MODIFIER 1 A 5 SCOTT 3 121 3 119 1 4 11 CREATE_DATE 1 A 5 SCOTT 3 121 3 120 1 4 13 MODIFIED_DATE 1 A 5 SCOTT 3 121 3 121 1 4 11 PARAM_TITLE 1 A 5 SCOTT 3 121 3 122 1 4 10 PARAM_HINT 1 A 5 SCOTT 3 121 3 123 1 4 12 PARAM_STATUS 1 A 5 SCOTT 3 121 3 124 1 6 12 WHICH_REPORT 1 A 5 SCOTT 3 121 3 125 1 2 9 Q_GRANTEE 1 A 5 SCOTT 3 121 3 126 1 3 9 G_GRANTEE 1 A 5 SCOTT 3 121 3 128 1 4 7 GRANTEE 1 A 5 SCOTT 3 121 3 129 1 2 7 Q_QUERY 1 A 5 SCOTT 3 121 3 130 1 3 7 G_QUERY 1 A 5 SCOTT 3 121 3 137 1 4 5 QUERY 1 A 5 SCOTT 3 121 3 138 1 2 12 Q_REPORTHEAD 1 A 5 SCOTT 3 121 3 139 1 3 12 G_REPORTHEAD 1 A 5 SCOTT 3 121 3 143 1 4 4 NAME 1 A 5 SCOTT 3 121 3 145 1 4 8 PARENT_1 1 A 5 SCOTT 3 121 3 152 1 2 7 Q_GROUP 1 A 5 SCOTT 3 121 3 153 1 3 7 G_GROUP 1 A 5 SCOTT 3 121 3 161 1 4 12 LINES_BEFORE 1 A 5 SCOTT 3 121 3 162 1 4 13 SPACES_BEFORE 1 A 5 SCOTT 3 121 3 163 1 4 9 INTER_ROW 1 A 5 SCOTT 3 121 3 164 1 4 11 INTER_FIELD 1 A 5 SCOTT 3 121 3 168 1 4 13 FIELDS_ACROSS 1 A 5 SCOTT 3 121 3 169 1 4 11 MULTI_PANEL 1 A 5 SCOTT 3 121 3 170 1 4 11 MATRIX_FLAG 1 A 5 SCOTT 3 121 3 172 1 4 10 GROUP_NAME 1 A 5 SCOTT 3 121 3 173 1 4 10 QUERY_NAME 1 A 5 SCOTT 3 121 3 177 1 3 9 G_QUERY_G 1 A 5 SCOTT 3 121 3 178 1 4 10 PAGE_BREAK 1 A 5 SCOTT 3 121 3 179 1 4 12 RELATIVE_POS 1 A 5 SCOTT 3 121 3 180 1 4 13 LOCATE_LABELS 1 A 5 SCOTT 3 121 3 181 1 4 12 FIELD_HILITE 1 A 5 SCOTT 3 121 3 182 1 4 12 LABEL_HILITE 1 A 5 SCOTT 3 121 3 183 1 2 7 Q_FIELD 1 A 5 SCOTT 3 121 3 184 1 3 7 G_FIELD 1 A 5 SCOTT 3 121 3 190 1 4 15 TARGET_POSITION 1 A 5 SCOTT 3 121 3 191 1 4 7 COMPUTE 1 A 5 SCOTT 3 121 3 192 1 4 7 HEADING 1 A 5 SCOTT 3 121 3 193 1 4 4 SKIP 1 A 5 SCOTT 3 121 3 195 1 4 11 FORMAT_MASK 1 A 5 SCOTT 3 121 3 196 1 4 5 WIDTH 1 A 5 SCOTT 3 121 3 200 1 4 7 REPRINT 1 A 5 SCOTT 3 121 3 202 1 4 13 LINES_BEFORE2 1 A 5 SCOTT 3 121 3 203 1 4 14 SPACES_BEFORE2 1 A 5 SCOTT 3 121 3 205 1 4 10 FIELD_NAME 1 A 5 SCOTT 3 121 3 206 1 4 11 GROUP_NAME2 1 A 5 SCOTT 3 121 3 207 1 4 11 QUERY_NAME2 1 A 5 SCOTT 3 121 3 208 1 4 11 RESET_GROUP 1 A 5 SCOTT 3 121 3 209 1 3 9 G_GROUP_F 1 A 5 SCOTT 3 121 3 210 1 4 9 DATATYPE2 1 A 5 SCOTT 3 121 3 211 1 4 8 FUNCTION 1 A 5 SCOTT 3 121 3 212 1 4 8 POSITION 1 A 5 SCOTT 3 121 3 213 1 4 9 ALIGNMENT 1 A 5 SCOTT 3 121 3 214 1 2 6 Q_LINK 1 A 5 SCOTT 3 121 3 215 1 3 6 G_LINK 1 A 5 SCOTT 3 121 3 219 1 4 11 LOCAL_TLPOS 1 A 5 SCOTT 3 121 3 224 1 4 9 PARENTC_1 1 A 5 SCOTT 3 121 3 225 1 4 9 PARENTC_2 1 A 5 SCOTT 3 121 3 231 1 2 9 Q_SUMMARY 1 A 5 SCOTT 3 121 3 232 1 3 9 G_SUMMARY 1 A 5 SCOTT 3 121 3 239 1 4 6 WIDTH2 1 A 5 SCOTT 3 121 3 241 1 4 12 FORMAT_MASK2 1 A 5 SCOTT 3 121 3 245 1 4 6 SOURCE 1 A 5 SCOTT 3 121 3 247 1 4 9 DATATYPE3 1 A 5 SCOTT 3 121 3 248 1 4 9 FUNCTION3 1 A 5 SCOTT 3 121 3 249 1 4 12 SUMMARY_NAME 1 A 5 SCOTT 3 121 3 250 1 2 6 Q_TEXT 1 A 5 SCOTT 3 121 3 251 1 3 6 G_TEXT 1 A 5 SCOTT 3 121 3 253 1 4 6 OBJECT 1 A 5 SCOTT 3 121 3 254 1 4 4 TYPE 1 A 5 SCOTT 3 121 3 255 1 4 6 EDITED 1 A 5 SCOTT 3 121 3 257 1 4 13 LINES_BEFORE3 1 A 5 SCOTT 3 121 3 258 1 4 14 SPACES_BEFORE3 1 A 5 SCOTT 3 121 3 259 1 4 6 WIDTH3 1 A 5 SCOTT 3 121 3 263 1 4 13 RELATIVE_POS3 1 A 5 SCOTT 3 121 3 264 1 3 9 G_GROUP_T 1 A 5 SCOTT 3 121 3 274 1 4 4 TEXT 1 A 5 SCOTT 3 121 3 275 1 3 7 G_PANEL 1 A 5 SCOTT 3 121 3 288 1 4 6 REPEAT 1 A 5 SCOTT 3 121 3 289 1 4 5 PANEL 1 A 5 SCOTT 3 121 3 290 1 4 5 ALIGN 1 A 5 SCOTT 3 121 3 291 1 4 8 PRINT_AT 1 A 5 SCOTT 3 121 3 297 1 4 9 FREQUENCY 1 A 5 SCOTT 3 121 3 303 1 5 2 s1 1 A 5 SCOTT 3 121 3 304 1 4 8 RESET_AT 1 A 5 SCOTT 3 121 3 306 1 2 7 Q_PARAM 1 A 5 SCOTT 3 121 3 307 1 3 7 G_PARAM 1 A 5 SCOTT 3 121 3 309 1 4 14 PARAMETER_NAME 1 A 5 SCOTT 3 121 3 311 1 4 6 WIDTH4 1 A 5 SCOTT 3 121 3 312 1 4 13 DEFAULT_VALUE 1 A 5 SCOTT 3 121 3 313 1 4 5 LABEL 1 A 5 SCOTT 3 121 3 314 1 4 10 PARAM_TYPE 1 A 5 SCOTT 3 121 3 315 1 4 10 INPUT_MASK 1 A 5 SCOTT 3 121 3 316 1 4 11 OUTPUT_MASK 1 A 5 SCOTT 3 121 3 317 1 4 5 SKIP2 1 A 5 SCOTT 3 121 3 318 1 4 9 DATATYPE4 1 A 5 SCOTT 3 121 3 325 1 4 7 VERSION 1 A 5 SCOTT 3 121 3 326 1 4 16 MODIFIED_VERSION 1 A 5 SCOTT 3 121 3 328 1 4 15 QUERY_NAME_SKIP 1 A 5 SCOTT 3 121 3 329 1 4 10 REPETITION 1 A 5 SCOTT 3 121 3 330 1 4 11 MATRIX_NAME 1 A 5 SCOTT 3 121 3 332 1 4 11 REPORT_NAME 1 A 5 SCOTT 3 121 3 336 1 3 8 G_HIDE_L 1 A 5 SCOTT 3 121 3 337 1 4 4 NULL 1 A 5 SCOTT 3 121 3 351 1 4 6 APPID6 1 A 5 SCOTT 3 121 3 355 1 4 8 UPMATCH2 1 A 5 SCOTT 3 121 3 382 1 4 5 NULL1 1 A 5 SCOTT 3 121 3 383 1 4 9 NOHL_TEXT 1 A 5 SCOTT 3 121 3 384 1 4 12 LOCAL_ITEMID 1 A 5 SCOTT 3 121 3 385 1 4 11 LOCAL_CNAME 1 A 5 SCOTT 3 121 3 386 1 4 5 APPID 1 A 5 SCOTT 3 121 3 387 1 4 7 QUERYID 1 A 5 SCOTT 3 121 3 388 1 4 8 PARENTID 1 A 5 SCOTT 3 121 3 389 1 4 13 PARENT_ITEMID 1 A 5 SCOTT 3 121 3 390 1 4 13 PARENT1_CNAME 1 A 5 SCOTT 3 121 3 391 1 4 13 PARENT2_CNAME 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 5 SCOTT 3 121 3 103 3 138 1 1 1 2 1 A 5 SCOTT 3 121 3 125 3 103 1 1 1 1 1 A 5 SCOTT 3 121 3 129 3 138 1 2 1 2 1 A 5 SCOTT 3 121 3 152 3 138 1 1 1 2 1 A 5 SCOTT 3 121 3 183 3 138 1 1 1 2 1 A 5 SCOTT 3 121 3 214 3 129 1 4 1 3 1 A 5 SCOTT 3 121 3 214 3 129 1 1 1 2 1 A 5 SCOTT 3 121 3 231 3 138 1 1 1 2 1 A 5 SCOTT 3 121 3 250 3 138 1 1 1 2 1 A 5 SCOTT 3 121 3 306 3 138 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 5 SCOTT 3 121 3 104 3 103 0 1 2 1 1 1 1 1 0 0 0 0 0 1 1 0 0 0 1 2 1 A 5 SCOTT 3 121 3 126 3 125 0 1 3 1 1 1 2 1 0 0 0 0 0 0 0 0 0 1 2 1 A 5 SCOTT 3 121 3 130 3 129 1 1 1 4 1 1 1 2 1 0 1 2 0 0 0 1 1 0 0 0 1 2 1 A 5 SCOTT 3 121 3 139 3 138 1 2 1 1 1 1 0 0 0 0 0 0 0 0 0 0 1 2 1 A 5 SCOTT 3 121 3 153 3 152 0 1 8 1 1 0 1 0 0 0 2 16 1 6 1 1 3 100 0 0 1 2 1 A 5 SCOTT 3 121 3 177 3 152 1 1 1 7 1 1 1 2 1 0 0 0 0 0 1 1 0 0 0 0 1 A 5 SCOTT 3 121 3 184 3 183 0 2 10 1 1 0 1 2 0 1 1 0 0 0 0 0 0 1 2 1 A 5 SCOTT 3 121 3 209 3 183 1 1 1 9 1 1 1 2 1 0 1 1 0 0 0 1 1 0 0 0 1 2 1 A 5 SCOTT 3 121 3 215 3 214 0 1 6 1 1 0 1 0 0 0 0 0 1 1 0 0 0 1 2 1 A 5 SCOTT 3 121 3 232 3 231 0 2 11 1 1 1 2 1 0 0 0 0 0 1 1 0 0 0 1 2 1 A 5 SCOTT 3 121 3 251 3 250 1 1 2 14 1 1 0 1 0 1 1 0 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 264 3 250 1 1 2 13 1 1 1 2 1 0 1 1 0 0 0 1 1 0 0 0 1 2 1 A 5 SCOTT 3 121 3 275 3 250 0 2 15 1 1 1 2 1 0 1 1 0 0 0 1 1 0 0 0 0 1 A 5 SCOTT 3 121 3 307 3 306 0 2 12 1 1 1 2 1 0 0 0 0 0 1 1 0 0 0 0 1 A 5 SCOTT 3 121 3 336 3 214 1 1 1 5 1 1 1 1 1 0 0 0 0 0 1 1 0 0 0 1 2 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 5 SCOTT 3 121 3 124 1 1 1 2 2 30 1 % 22 Which Report (or Wild) 1 1 0 0 0 1 A 5 SCOTT 3 121 2 99 1 2 1 2 2 80 6 Screen 26 Screen/Printer/File/Sysout 1 0 0 0 0 1 A 5 SCOTT 3 121 2 98 1 3 1 2 2 80 10 srw175.lis 24 File Name / Spool Device 1 0 0 0 1 X 1 A 5 SCOTT 3 121 2 97 1 4 1 2 2 80 6 dec180 24 Printer Description File 1 0 0 0 1 X 1 A 5 SCOTT 3 121 2 96 1 5 1 1 1 2 1 1 16 Number of Copies 1 0 0 0 1 X 1 A 5 SCOTT 3 121 2 95 1 6 1 2 1 4 0 15 Currency Symbol 1 0 0 0 1 X 1 A 5 SCOTT 3 121 2 94 1 7 1 2 1 1 0 19 Thousands Separator 1 0 0 0 1 X 1 A 5 SCOTT 3 121 2 93 1 8 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 5 SCOTT 3 121 3 103 3 138 0 1 2 368 select appid, page_height , page_width , left_margin , right_margin , top_margin , bottom_margin , version , modified_version , comments , owner , modifier , create_date , modified_date , param_title , param_hint , param_status from srw_report 1 A 5 SCOTT 3 121 3 125 3 103 0 1 3 37 select * from SRW_GRANTED order by 2 1 A 5 SCOTT 3 121 3 129 3 138 0 1 4 423 select s.name, s.appid upmatch, q.itemid, query, p.name parent_1, m.name matrix_name from srw_query q, srw_ste p, srw_ste s, srw_ste m where q.appid = s.appid and q.itemid = s.itemid and q.appid = p.appid (+) and q.parentid = p.itemid (+) and q.appid = m.appid (+) and q.matrix_parentid = m.itemid (+) order by query_order asc 1 A 5 SCOTT 3 121 3 138 0 0 1 1 113 select report_name, appid, next_itemid from srw_report where report_name like :which_report order by report_name 1 A 5 SCOTT 3 121 3 152 3 138 0 1 6 1222 select g.appid, s.name group_name, q.name query_name, matrix_flag, decode(repetition, 1, 'Down', 2, 'Across', 3, 'Down/Across', 4, 'Across/Down', 5, 'Crosstab', '') repetition, decode(page_break, 1, 'Conditional', 2, 'Always', '') page_break, decode(relative_pos,1,'Below', 2, 'Right', '') relative_pos, lines_before, spaces_before, inter_row, inter_field, fields_across, multi_panel, decode(locate_labels, 1, 'Above', 2, 'Left', '') locate_labels, decode(field_hilite, 0, 'Normal', 2, 'Underline', 4, 'Reverse', 16, 'Bold', 6, 'Und/Rev', 18, 'Und/Bold', 20, 'Rev/Bold', 22, 'Und/Rev/Bold', '') field_hilite, decode(label_hilite, 0, 'Normal', 2, 'Underline', 4, 'Reverse', 16, 'Bold', 6, 'Und/Rev', 18, 'Und/Bold', 20, 'Rev/Bold', 22, 'Und/Rev/Bold', '') label_hilite, Null NULL_G, queryid from srw_group g, srw_ste s, srw_ste q where g.appid = s.appid and g.itemid = s.itemid and g.appid = q.appid and g.queryid = q.itemid order by group_order 1 A 5 SCOTT 3 121 3 183 3 138 0 1 7 1435 select f.appid , s.name field_name, decode(f.groupid, 1, 'REPORT', decode (nvl(g.itemid,0), 0, '*Undefined*', g.name) ) group_name, q.name query_name, target_position , compute , heading , skip , format_mask , width , decode(datatype, 1, 'NUM', 2, 'CHAR', 3, 'DATE', 4, 'PRINTER', '') datatype, decode(operator, 1, 'Sum', 2, 'Min', 3, 'Max', 4, 'Count', 5, 'Avg', 6, '%Total', 7, 'First', 8, 'Last', 51, 'R_Sum', 52, 'R_Min', 53, 'R_Max', 54, 'R_Count', 55, 'R_Avg', 56, 'R_%Total', '') function, r.name reset_group , reprint , decode(relative_pos, 1, 'Below', 2, 'Right', 3, 'Panel', '') position, lines_before , spaces_before , decode(alignment, 1, 'Left', 2, 'Right', 3, 'Center', 4, 'Wrap', 5, 'Variable', '') alignment from srw_field f, srw_ste s, srw_ste q, srw_ste g, srw_ste r where f.appid = s.appid and f.itemid = s.itemid and f.appid = q.appid (+) and f.source_query = q.itemid (+) and f.appid = g.appid (+) and f.groupid = g.itemid (+) and f.appid = r.appid (+) and f.reset_group = r.itemid (+) order by field_order 1 A 5 SCOTT 3 121 3 214 3 129 0 1 5 301 select k.appid, decode(k.parentid, q.parentid, foreign_tlpos, null) parent_1, decode(k.parentid, q.matrix_parentid, foreign_tlpos, null) parent_2, k.itemid, k.parentid, local_tlpos, null from srw_fkey k, srw_query q where k.appid = q.appid and k.itemid = q.itemid 1 A 5 SCOTT 3 121 3 231 3 138 0 1 8 902 select s.appid, s.itemid, n.name summary_name, f.name source, decode(datatype, 1, 'NUM', 2, 'CHAR', 3, 'DATE', 4, 'PRINTER', '') datatype, decode(operator, 1, 'Sum', 2, 'Min', 3, 'Max', 4, 'Count', 5, 'Avg', 6, '%Total', 7, 'First', 8, 'Last', 51, 'R_Sum', 52, 'R_Min', 53, 'R_Max', 54, 'R_Count', 55, 'R_Avg', 56, 'R_%Total', '') function, format_mask, width, decode(print_at, 1, 'Report', 2, 'Page', p.name) print_at, decode(reset_at, 1, 'Report', 2, 'Page', r.name) reset_at from srw_summary s, srw_ste n, srw_ste f, srw_ste p, srw_ste r where s.appid = n.appid and s.itemid = n.itemid and s.appid = f.appid and s.fieldid = f.itemid and s.appid = p.appid (+) and s.print_at = p.itemid (+) and s.appid = r.appid (+) and s.reset_at = r.itemid (+) order by sum_order 1 A 5 SCOTT 3 121 3 250 3 138 0 2 10 1056 select t.appid, t.itemid, decode(t.itemid, 1, 'Report', 2, 'Page', s.name) object, decode(t.type, 3, 'Title Page', 4, 'Trailer Page', 5, 'Header', 6, 'Footer', 7, 'Column Heading', 8, 'Body', 9, 'Subfooter', 'Error') type, dirty edited, decode(t.relative_pos, 1, 'Below', 2, 'Right', 3, 'Panel', 4, 'Margin', '') relative_pos, t.lines_before, t.spaces_before, width, decode(justification, 1, 'Left', 2, 'Right', 3, 'Center', '') align, repeat, decode(frequency, 1, 'Report', 2, 'Page', f.name) frequency, panel, text from srw_text t, srw_group g, srw_text_long l, srw_ste s, srw_ste f where t.appid = g.appid (+) and t.itemid = g.itemid (+) and t.appid = s.appid (+) and t.itemid = s.itemid (+) and t.appid = l.appid and t.itemid = l.itemid and t.type = l.type and t.appid = f.appid (+) and t.frequency = f.itemid (+) and t.dirty = 'X' order by group_order, t.type, panel 1 A 5 SCOTT 3 121 3 306 3 138 0 1 9 431 select p.appid , name parameter_name, decode(datatype, 1, 'NUM', 2, 'CHAR', 3, 'DATE', 4, 'PRINTER', '') datatype, width , default_value , label , param_type , input_mask , output_mask , skip from srw_param p, srw_ste s where p.appid = s.appid and p.itemid = s.itemid order by param_order 1 E 243 SELECT APPID, PAGE_HEIGHT , PAGE_WIDTH , LEFT_MARGIN , RIGHT_MARGIN , TOP_MARGIN , BOTTOM_MARGIN , VERSION , MODIFIED_VERSION , COMMENTS , OWNER , MODIFIER , CREATE_DATE , MODIFIED_DATE , PARAM_TITLE , PARAM_HINT , PARAM_STATUS FROM SRW_REPORT 2 17 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 2 1 2 1 3 1 3 1 2 1 2 1 2 2 11 1 5 1 5 1 5 1 5 1 5 1 5 1 7 1 7 1 0 2 30 2 30 1 9 1 9 2 80 2 80 2 50 1 2 1 2 1 2 1 2 1 2 1 2 1 2 1 2 1 2 1 8 1 1 1 1 2 12 2 12 1 1 1 1 1 1 5 APPID 11 PAGE_HEIGHT 10 PAGE_WIDTH 11 LEFT_MARGIN 12 RIGHT_MARGIN 10 TOP_MARGIN 13 BOTTOM_MARGIN 7 VERSION 16 MODIFIED_VERSION 8 COMMENTS 5 OWNER 8 MODIFIER 11 CREATE_DATE 13 MODIFIED_DATE 11 PARAM_TITLE 10 PARAM_HINT 12 PARAM_STATUS 1 E 55 SELECT "APPID", "GRANTEE" FROM SRW_GRANTED ORDER BY 2 1 2 1 0 1 1 1 2 2 17 2 30 1 2 1 1 5 APPID 7 GRANTEE 1 E 326 SELECT S.NAME, S.APPID UPMATCH, Q.ITEMID, QUERY, P.NAME PARENT_1, M.NAME MATRIX_NAME FROM SRW_QUERY Q, SRW_STE P, SRW_STE S, SRW_STE M WHERE Q.APPID = S.APPID AND Q.ITEMID = S.ITEMID AND Q.APPID = P.APPID (+) AND Q.PARENTID = P.ITEMID (+) AND Q.APPID = M.APPID (+) AND Q.MATRIX_PARENTID = M.ITEMID (+) ORDER BY QUERY_ORDER ASC 1 6 1 0 1 2 1 1 1 1 1 2 1 2 1 2 2 80 2 11 2 11 1 0 2 80 2 80 1 1 1 2 1 2 1 8 1 1 1 1 4 NAME 7 UPMATCH 6 ITEMID 5 QUERY 8 PARENT_1 11 MATRIX_NAME 1 E 112 SELECT REPORT_NAME, APPID, NEXT_ITEMID FROM SRW_REPORT WHERE REPORT_NAME LIKE :WHICH_REPORT ORDER BY REPORT_NAME 1 3 1 1 1 2 1 1 1 1 2 80 2 11 2 11 1 1 1 2 1 2 11 REPORT_NAME 5 APPID 11 NEXT_ITEMID 3 124 1 E 944 SELECT G.APPID, S.NAME GROUP_NAME, Q.NAME QUERY_NAME, MATRIX_FLAG, DECODE(REPETITION, 1, 'Down', 2, 'Across', 3, 'Down/Across', 4, 'Across/Down', 5, 'Crosstab', '') REPETITION, DECODE(PAGE_BREAK, 1, 'Conditional', 2, 'Always', '') PAGE_BREAK, DECODE(RELATIVE_POS,1,'Below', 2, 'Right', '') RELATIVE_POS, LINES_BEFORE, SPACES_BEFORE, INTER_ROW, INTER_FIELD, FIELDS_ACROSS, MULTI_PANEL, DECODE(LOCATE_LABELS, 1, 'Above', 2, 'Left', '') LOCATE_LABELS, DECODE(FIELD_HILITE, 0, 'Normal', 2, 'Underline', 4, 'Reverse', 16, 'Bold', 6, 'Und/Rev', 18, 'Und/Bold', 20, 'Rev/Bold', 22, 'Und/Rev/Bold', '') FIELD_HILITE, DECODE(LABEL_HILITE, 0, 'Normal', 2, 'Underline', 4, 'Reverse', 16, 'Bold', 6, 'Und/Rev', 18, 'Und/Bold', 20, 'Rev/Bold', 22, 'Und/Rev/Bold', '') LABEL_HILITE, NULL NULL_G, QUERYID FROM SRW_GROUP G, SRW_STE S, SRW_STE Q WHERE G.APPID = S.APPID AND G.ITEMID = S.ITEMID AND G.APPID = Q.APPID AND G.QUERYID = Q.ITEMID ORDER BY GROUP_ORDER 2 18 1 0 1 1 1 2 1 2 1 2 1 2 1 2 1 2 1 1 1 1 1 1 1 1 1 1 1 2 1 2 1 2 1 2 1 2 1 1 2 11 2 80 2 80 1 1 2 11 2 11 1 5 1 5 1 5 1 5 1 5 1 5 1 1 1 5 2 12 2 12 1 0 2 11 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 2 1 2 1 2 1 2 1 1 1 1 1 1 1 1 1 1 1 2 5 APPID 10 GROUP_NAME 10 QUERY_NAME 11 MATRIX_FLAG 10 REPETITION 10 PAGE_BREAK 12 RELATIVE_POS 12 LINES_BEFORE 13 SPACES_BEFORE 9 INTER_ROW 11 INTER_FIELD 13 FIELDS_ACROSS 11 MULTI_PANEL 13 LOCATE_LABELS 12 FIELD_HILITE 12 LABEL_HILITE 6 NULL_G 7 QUERYID 1 E 1027 SELECT F.APPID , S.NAME FIELD_NAME, DECODE(F.GROUPID, 1, 'REPORT', DECODE (NVL(G.ITEMID,0), 0, '*Undefined*', G.NAME) ) GROUP_NAME, Q.NAME QUERY_NAME, TARGET_POSITION , COMPUTE , HEADING , SKIP , FORMAT_MASK , WIDTH , DECODE(DATATYPE, 1, 'NUM', 2, 'CHAR', 3, 'DATE', 4, 'PRINTER', '') DATATYPE, DECODE(OPERATOR, 1, 'Sum', 2, 'Min', 3, 'Max', 4, 'Count', 5, 'Avg', 6, '%Total', 7, 'First', 8, 'Last', 51, 'R_Sum', 52, 'R_Min', 53, 'R_Max', 54, 'R_Count', 55, 'R_Avg', 56, 'R_%Total', '') FUNCTION, R.NAME RESET_GROUP , REPRINT , DECODE(RELATIVE_POS, 1, 'Below', 2, 'Right', 3, 'Panel', '') POSITION, LINES_BEFORE , SPACES_BEFORE , DECODE(ALIGNMENT, 1, 'Left', 2, 'Right', 3, 'Center', 4, 'Wrap', 5, 'Variable', '') ALIGNMENT FROM SRW_FIELD F, SRW_STE S, SRW_STE Q, SRW_STE G, SRW_STE R WHERE F.APPID = S.APPID AND F.ITEMID = S.ITEMID AND F.APPID = Q.APPID (+) AND F.SOURCE_QUERY = Q.ITEMID (+) AND F.APPID = G.APPID (+) AND F.GROUPID = G.ITEMID (+) AND F.APPID = R.APPID (+) AND F.RESET_GROUP = R.ITEMID (+) ORDER BY FIELD_ORDER 2 18 1 0 1 1 1 2 1 2 1 2 1 1 1 2 1 2 1 2 1 2 1 1 1 2 1 2 1 2 1 2 1 2 1 1 1 1 1 2 2 11 2 80 2 80 2 80 1 5 3 240 3 240 1 1 2 40 1 5 1 7 1 8 2 80 1 1 1 5 1 5 1 5 1 8 1 2 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 2 1 2 1 1 5 APPID 10 FIELD_NAME 10 GROUP_NAME 10 QUERY_NAME 15 TARGET_POSITION 7 COMPUTE 7 HEADING 4 SKIP 11 FORMAT_MASK 5 WIDTH 8 DATATYPE 8 FUNCTION 11 RESET_GROUP 7 REPRINT 8 POSITION 12 LINES_BEFORE 13 SPACES_BEFORE 9 ALIGNMENT 1 E 263 SELECT K.APPID, DECODE(K.PARENTID, Q.PARENTID, FOREIGN_TLPOS, NULL) PARENT_1, DECODE(K.PARENTID, Q.MATRIX_PARENTID, FOREIGN_TLPOS, NULL) PARENT_2, K.ITEMID, K.PARENTID, LOCAL_TLPOS, NULL FROM SRW_FKEY K, SRW_QUERY Q WHERE K.APPID = Q.APPID AND K.ITEMID = Q.ITEMID 1 7 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 11 2 40 2 40 2 11 2 11 1 5 1 0 1 2 1 2 1 2 1 2 1 2 1 2 1 1 5 APPID 8 PARENT_1 8 PARENT_2 6 ITEMID 8 PARENTID 11 LOCAL_TLPOS 4 NULL 1 E 766 SELECT S.APPID, S.ITEMID, N.NAME SUMMARY_NAME, F.NAME SOURCE, DECODE(DATATYPE, 1, 'NUM', 2, 'CHAR', 3, 'DATE', 4, 'PRINTER', '') DATATYPE, DECODE(OPERATOR, 1, 'Sum', 2, 'Min', 3, 'Max', 4, 'Count', 5, 'Avg', 6, '%Total', 7, 'First', 8, 'Last', 51, 'R_Sum', 52, 'R_Min', 53, 'R_Max', 54, 'R_Count', 55, 'R_Avg', 56, 'R_%Total', '') FUNCTION, FORMAT_MASK, WIDTH, DECODE(PRINT_AT, 1, 'Report', 2, 'Page', P.NAME) PRINT_AT, DECODE(RESET_AT, 1, 'Report', 2, 'Page', R.NAME) RESET_AT FROM SRW_SUMMARY S, SRW_STE N, SRW_STE F, SRW_STE P, SRW_STE R WHERE S.APPID = N.APPID AND S.ITEMID = N.ITEMID AND S.APPID = F.APPID AND S.FIELDID = F.ITEMID AND S.APPID = P.APPID (+) AND S.PRINT_AT = P.ITEMID (+) AND S.APPID = R.APPID (+) AND S.RESET_AT = R.ITEMID (+) ORDER BY SUM_ORDER 2 10 1 0 1 1 1 1 1 2 1 2 1 2 1 2 1 2 1 1 1 2 1 2 2 11 2 11 2 80 2 80 1 7 1 8 2 40 1 5 2 80 2 80 1 2 1 2 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 5 APPID 6 ITEMID 12 SUMMARY_NAME 6 SOURCE 8 DATATYPE 8 FUNCTION 11 FORMAT_MASK 5 WIDTH 8 PRINT_AT 8 RESET_AT 1 E 871 SELECT T.APPID, T.ITEMID, DECODE(T.ITEMID, 1, 'Report', 2, 'Page', S.NAME) OBJECT, DECODE(T.TYPE, 3, 'Title Page', 4, 'Trailer Page', 5, 'Header', 6, 'Footer', 7, 'Column Heading', 8, 'Body', 9, 'Subfooter', 'Error') TYPE, DIRTY EDITED, DECODE(T.RELATIVE_POS, 1, 'Below', 2, 'Right', 3, 'Panel', 4, 'Margin', '') RELATIVE_POS, T.LINES_BEFORE, T.SPACES_BEFORE, WIDTH, DECODE(JUSTIFICATION, 1, 'Left', 2, 'Right', 3, 'Center', '') ALIGN, REPEAT, DECODE(FREQUENCY, 1, 'Report', 2, 'Page', F.NAME) FREQUENCY, PANEL, TEXT FROM SRW_TEXT T, SRW_GROUP G, SRW_TEXT_LONG L, SRW_STE S, SRW_STE F WHERE T.APPID = G.APPID (+) AND T.ITEMID = G.ITEMID (+) AND T.APPID = S.APPID (+) AND T.ITEMID = S.ITEMID (+) AND T.APPID = L.APPID AND T.ITEMID = L.ITEMID AND T.TYPE = L.TYPE AND T.APPID = F.APPID (+) AND T.FREQUENCY = F.ITEMID (+) AND T.DIRTY = 'X' ORDER BY GROUP_ORDER, T.TYPE, PANEL 2 14 1 0 1 1 1 1 1 2 1 2 1 2 1 2 1 1 1 1 1 1 1 2 1 2 1 2 1 1 1 2 2 11 2 11 2 80 2 14 1 1 1 6 1 5 1 5 1 5 1 6 1 1 2 80 1 4 1 0 1 2 1 2 1 1 1 1 1 1 1 1 1 2 1 2 1 2 1 1 1 1 1 1 1 2 1 8 5 APPID 6 ITEMID 6 OBJECT 4 TYPE 6 EDITED 12 RELATIVE_POS 12 LINES_BEFORE 13 SPACES_BEFORE 5 WIDTH 5 ALIGN 6 REPEAT 9 FREQUENCY 5 PANEL 4 TEXT 1 E 288 SELECT P.APPID , NAME PARAMETER_NAME, DECODE(DATATYPE, 1, 'NUM', 2, 'CHAR', 3, 'DATE', 4, 'PRINTER', '') DATATYPE, WIDTH , DEFAULT_VALUE , LABEL , PARAM_TYPE , INPUT_MASK , OUTPUT_MASK , SKIP FROM SRW_PARAM P, SRW_STE S WHERE P.APPID = S.APPID AND P.ITEMID = S.ITEMID ORDER BY PARAM_ORDER 2 10 1 0 1 1 1 2 1 2 1 1 1 2 1 2 1 1 1 2 1 2 1 2 2 11 2 80 1 7 1 5 3 240 3 240 1 4 2 40 2 40 1 1 1 2 1 1 1 1 1 2 1 1 1 1 1 2 1 1 1 1 1 1 5 APPID 14 PARAMETER_NAME 8 DATATYPE 5 WIDTH 13 DEFAULT_VALUE 5 LABEL 10 PARAM_TYPE 10 INPUT_MASK 11 OUTPUT_MASK 4 SKIP 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 121 3 392 6 srw175 2 60 3 186 1 0 1 0 1 0 1 2 4 1101 4 1110 1141 This report provides a complete listing of a SQL*ReportWriter report. It is designed to run on printers supporting line lengths of at least 175 characters, such as the LN03 running with form=landwide. A number of tricks are used to format this report which may be of interest: o The Relative Position of the body and footer of the access list are set to Margin to move them "within" the report level info. o A duplicate query of the srw_report table allows the report info, queries, groups, fields, summaries, and parameters could all be placed at the left margin. o The queries that retrieve the names of reset and print groups employ outer joins so that even if the reset group wasn't a group per se, the record would still show with a decoded value of "Page" or "Report". o A group containing only a single null field was created so that so that blank lines could separate the groups in one query from those in another without creating a traditional break report appearance. o User exits translate the target list position of expressions in queries and also remove the highlighting information from text objects. 5 SCOTT 7 EXAMPLE 14 19890319151017 14 19900508112935 16 Report Listing 24 Press Accept to continue 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 5 SCOTT 3 121 3 108 3 104 3 103 1 2 0 6 Height 0 1 3 0 1 5 1 1 0 0 0 1 1 1 4 1 5 0 1 A 5 SCOTT 3 121 3 112 3 104 3 103 1 6 0 6 Top 0 1 4 0 1 5 1 1 0 0 0 0 0 1 5 0 1 A 5 SCOTT 3 121 3 121 3 104 3 103 2 15 0 7 Title 0 1 5 0 2 55 1 2 0 0 0 0 0 1 5 0 1 A 5 SCOTT 3 121 3 109 3 104 3 103 1 3 0 6 Width 0 1 6 0 1 5 1 1 0 0 0 1 1 0 1 5 0 1 A 5 SCOTT 3 121 3 113 3 104 3 103 1 7 0 6 Bottom 0 1 7 0 1 5 1 1 0 0 0 0 0 1 5 0 1 A 5 SCOTT 3 121 3 122 3 104 3 103 2 16 0 7 Hint 0 1 8 0 2 55 1 2 0 0 0 0 0 1 5 0 1 A 5 SCOTT 3 121 3 110 3 104 3 103 1 4 0 6 Left 0 1 9 0 1 5 1 1 0 0 0 1 1 0 2 22 0 1 A 5 SCOTT 3 121 3 123 3 104 3 103 2 17 0 7 Status 0 2 10 0 2 55 1 2 0 0 0 0 0 1 5 0 1 A 5 SCOTT 3 121 3 111 3 104 3 103 1 5 0 6 Right 0 2 11 0 1 5 1 1 0 0 0 1 1 0 2 22 0 1 A 5 SCOTT 3 121 3 116 3 104 3 103 2 10 0 0 0 2 12 0 2 76 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 117 3 104 3 103 2 11 0 9 Created: 0 2 13 0 2 29 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 119 3 104 3 103 2 13 0 0 0 2 14 9 DD-Mon-YY 1 9 1 3 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 118 3 104 3 103 2 12 0 9 Modified: 0 2 15 0 2 29 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 120 3 104 3 103 2 14 0 0 0 2 16 9 DD-Mon-YY 1 9 1 3 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 325 3 104 3 103 1 8 0 0 0 2 17 0 1 7 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 326 3 104 3 103 1 9 0 0 0 2 18 0 1 7 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 128 3 126 3 125 1 2 0 0 0 2 19 0 2 27 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 143 3 130 3 129 1 1 0 10 Query Name 0 2 20 0 2 26 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 137 3 130 3 129 1 4 0 5 Query 0 2 21 0 3 106 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 145 3 130 3 129 1 5 0 8 Parent 1 0 2 22 0 2 18 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 330 3 130 3 129 1 6 0 11 Matrix Name 0 2 23 0 2 18 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 355 3 130 3 129 1 2 0 7 Upmatch 0 2 24 0 2 11 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 332 3 139 3 138 1 1 0 11 Report Name 0 1 1 0 2 30 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 351 3 139 3 138 1 2 0 5 Appid 0 1 2 0 2 11 1 1 0 0 0 0 0 0 1 1 1 A 5 SCOTT 3 121 3 172 3 153 3 152 1 2 0 10 Group Name 0 2 37 0 2 30 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 173 3 153 3 152 1 3 0 10 Query Name 0 2 38 0 2 30 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 170 3 153 3 152 1 4 0 6 Matrix 0 2 39 0 1 6 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 329 3 153 3 152 1 5 0 10 Repetition 0 2 40 0 2 11 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 178 3 153 3 152 1 6 0 10 Page Break 0 2 41 0 2 11 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 179 3 153 3 152 1 7 0 3 Pos 0 2 42 0 1 8 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 161 3 153 3 152 1 8 0 6 Before 0 2 43 0 1 6 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 162 3 153 3 152 1 9 0 6 Before 0 2 44 0 1 6 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 163 3 153 3 152 2 10 0 3 Row 0 2 45 0 1 5 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 164 3 153 3 152 2 11 0 5 Field 0 2 46 0 1 5 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 168 3 153 3 152 2 12 0 13 Fields Across 0 2 47 0 1 6 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 169 3 153 3 152 2 13 0 5 Panel 0 2 48 0 1 5 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 180 3 153 3 152 2 14 0 6 Labels 0 2 49 0 1 7 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 181 3 153 3 152 2 15 0 6 Field 0 2 50 0 2 10 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 182 3 153 3 152 2 16 0 6 Label 0 2 51 0 2 10 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 386 3 153 3 152 1 1 0 5 Appid 0 2 52 0 2 11 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 387 3 153 3 152 2 18 0 7 Queryid 0 2 53 0 2 11 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 382 3 177 3 152 2 17 0 0 0 2 35 0 1 1 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 328 3 177 3 152 1 3 0 0 1 X 2 36 0 2 80 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 205 3 184 3 183 1 2 0 10 Field Name 0 2 55 0 2 16 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 190 3 184 3 183 1 5 0 6 Expr # 0 2 56 0 1 5 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 191 3 184 3 183 1 6 0 7 Compute 0 2 57 0 2 10 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 207 3 184 3 183 1 4 0 5 Query 0 2 58 0 2 16 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 192 3 184 3 183 1 7 0 7 Heading 0 2 59 0 2 10 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 210 3 184 3 183 2 11 0 4 Type 0 2 60 0 1 7 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 196 3 184 3 183 2 10 0 5 Width 0 2 61 0 1 5 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 195 3 184 3 183 1 9 0 6 Format 0 2 62 0 1 7 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 212 3 184 3 183 2 15 0 8 Position 0 2 63 0 1 5 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 202 3 184 3 183 2 16 0 3 Bef 0 2 64 0 1 6 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 203 3 184 3 183 2 17 0 3 Bef 0 2 65 0 1 6 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 213 3 184 3 183 2 18 0 5 Align 0 2 66 0 1 8 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 193 3 184 3 183 1 8 0 4 Skip 0 2 67 0 1 4 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 200 3 184 3 183 2 14 0 3 Rep 0 2 68 0 1 7 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 211 3 184 3 183 2 12 0 8 Function 0 2 69 0 1 8 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 208 3 184 3 183 2 13 0 5 Group 0 2 70 0 2 16 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 206 3 209 3 183 1 3 0 0 0 2 54 0 2 16 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 384 3 215 3 214 1 4 0 0 1 X 2 26 0 2 11 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 389 3 215 3 214 1 5 0 0 1 X 2 27 0 2 11 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 219 3 215 3 214 1 6 0 0 1 X 2 28 0 2 26 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 385 3 215 1 0 1 0 53 #RWEGSC LOCAL_CNAME APPID6 LOCAL_ITEMID LOCAL_TLPOS 0 0 0 2 29 0 2 47 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 224 3 215 3 214 1 2 0 0 1 X 2 30 0 2 18 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 225 3 215 3 214 1 3 0 0 1 X 2 31 0 2 18 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 390 3 215 1 0 1 0 54 #RWEGSC PARENT1_CNAME APPID6 PARENT_ITEMID PARENTC_1 0 0 0 2 32 0 2 47 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 391 3 215 1 0 1 0 54 #RWEGSC PARENT2_CNAME APPID6 PARENT_ITEMID PARENTC_2 0 0 0 2 33 0 2 47 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 388 3 215 3 214 1 5 0 8 Parentid 0 2 34 0 2 11 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 249 3 232 3 231 1 3 0 12 Summary Name 0 2 71 0 2 30 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 245 3 232 3 231 1 4 0 6 Source 0 2 72 0 2 30 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 247 3 232 3 231 1 5 0 8 Datatype 0 2 73 0 1 7 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 239 3 232 3 231 1 8 0 5 Width 0 2 74 0 1 5 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 241 3 232 3 231 1 7 0 11 Format Mask 0 2 75 0 1 7 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 248 3 232 3 231 1 6 0 8 Function 0 2 76 0 1 8 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 291 3 232 3 231 1 9 0 8 Print At 0 2 77 0 2 30 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 304 3 232 3 231 2 10 0 8 Reset At 0 2 78 0 2 30 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 254 3 251 3 250 1 4 0 0 0 2 89 0 2 14 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 255 3 251 3 250 1 5 0 0 0 2 90 0 1 6 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 257 3 251 3 250 1 7 0 0 0 2 91 0 2 12 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 258 3 251 3 250 1 8 0 0 0 2 92 0 2 13 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 259 3 251 3 250 1 9 0 0 0 2 93 0 1 5 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 263 3 251 3 250 1 6 0 0 0 2 94 0 2 12 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 288 3 251 3 250 2 11 0 0 0 2 95 0 1 6 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 290 3 251 3 250 2 10 0 0 0 2 96 0 1 6 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 297 3 251 3 250 2 12 0 0 0 2 97 0 2 16 1 2 1 3 3 251 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 253 3 264 3 250 1 3 0 0 0 2 88 0 2 16 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 289 3 275 3 250 2 13 0 5 Panel 0 2 98 0 1 4 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 274 3 275 3 250 2 14 0 4 Text 1 X 2 99 0 3 150 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 383 3 275 1 0 1 0 22 #RWERTH TEXT NOHL_TEXT 4 Text 0 3 100 0 3 150 1 2 0 0 0 0 0 0 1 4 1 A 5 SCOTT 3 121 3 309 3 307 3 306 1 2 0 14 Parameter Name 0 2 79 0 2 30 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 318 3 307 3 306 1 3 0 8 Datatype 0 2 80 0 1 8 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 311 3 307 3 306 1 4 0 5 Width 0 2 81 0 1 5 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 312 3 307 3 306 1 5 0 13 Default Value 0 2 82 0 2 16 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 313 3 307 3 306 1 6 0 5 Label 0 2 83 0 2 40 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 315 3 307 3 306 1 8 0 10 Input Mask 0 2 84 0 2 16 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 316 3 307 3 306 1 9 0 11 Output Mask 0 2 85 0 2 16 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 317 3 307 3 306 2 10 0 4 Skip 0 2 86 0 1 1 1 2 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 314 3 307 3 306 1 7 0 10 Param Type 0 2 87 0 1 4 1 1 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 337 3 336 3 214 1 7 0 0 0 2 25 0 2 10 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 A 5 SCOTT 3 121 3 303 3 205 1 1 1 4 1 5 1 1 0 3 184 3 184 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 5 SCOTT 3 121 1 1 1 3 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 1 1 1 4 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 1 1 1 5 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 1 1 1 6 1 X 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 1 2 1 5 1 X 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 1 2 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 104 1 5 0 0 0 0 0 1 3 0 0 1 A 5 SCOTT 3 121 3 104 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 104 1 7 0 0 0 0 1 X 1 1 1 1 0 1 A 5 SCOTT 3 121 3 104 1 8 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 126 1 5 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 126 1 6 1 X 1 4 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 126 1 7 0 0 0 0 1 X 1 1 3 104 0 1 A 5 SCOTT 3 121 3 126 1 8 1 X 1 4 1 7 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 130 1 5 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 130 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 130 1 7 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 130 1 8 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 139 1 5 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 139 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 139 1 7 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 139 1 8 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 153 1 5 0 0 1 2 0 0 1 3 0 0 1 A 5 SCOTT 3 121 3 153 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 153 1 7 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 153 1 8 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 177 1 5 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 177 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 177 1 7 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 177 1 8 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 184 1 5 0 0 0 0 0 1 3 0 0 1 A 5 SCOTT 3 121 3 184 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 184 1 7 0 0 1 1 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 184 1 8 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 209 1 5 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 209 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 209 1 7 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 209 1 8 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 215 1 5 0 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 215 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 215 1 7 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 215 1 8 1 X 1 4 0 2 28 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 232 1 5 0 0 0 0 0 1 3 0 0 1 A 5 SCOTT 3 121 3 232 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 232 1 7 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 232 1 8 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 251 1 5 0 0 0 0 0 0 0 0 1 A 5 SCOTT 3 121 3 251 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 251 1 7 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 251 1 8 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 264 1 5 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 264 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 264 1 7 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 264 1 8 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 275 1 5 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 275 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 275 1 7 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 275 1 8 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 307 1 5 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 307 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 307 1 7 1 X 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 307 1 8 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 336 1 5 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 336 1 6 0 0 0 0 0 1 1 0 0 1 A 5 SCOTT 3 121 3 336 1 7 0 0 0 0 1 X 1 1 0 0 1 A 5 SCOTT 3 121 3 336 1 8 1 X 1 4 0 2 28 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 5 SCOTT 3 121 1 1 1 6 1 1 1 1 3 144 175 ================================================================ END OF REPORT DEFINITION LISTING =========================================================================== 1 A 5 SCOTT 3 121 1 2 1 5 1 1 1 1 3 128 268 Page &PAGE &DATE Report Definition Listing 1 A 5 SCOTT 3 121 3 104 1 8 1 1 1 2 3 144 175 ==================================================================== REPORT LEVEL INFORMATION =============================================================================== 3 128 1143 --- Page --- -- Margin -- -------------- Parameter Form -------------------------------- ----------------------------- Comments -------------------------------------- | Height &PAGE_HEIGHT | Top &TOP_MARGIN | Title &PARAM_TITLE | &COMMENTS | Width &PAGE_WIDTH | Bottom &BOTTOM_MARGIN | Hint &PARAM_HINT | | | Left &LEFT_MARGIN | Status &PARAM_STATUS | | | Right &RIGHT_MARGIN | | ----------------------------------------------------------------------------------------------| ------ Access List -------- --------------------------- History --------------------------| By Date Version | | Created: &OWNER &CREATE_DATE &VERSION | Modified: &MODIFIER &MODIFIED_DATE &MODIFIED_VERSION | ---------------------------------------------------------------- 1 A 5 SCOTT 3 121 3 126 1 6 1 1 1 1 3 128 31 ----------------------------- 1 A 5 SCOTT 3 121 3 126 1 8 1 1 1 1 3 128 12 | &GRANTEE | 1 A 5 SCOTT 3 121 3 130 1 5 1 1 1 2 3 144 175 ======================================================================== QUERY INFORMATION ================================================================================= 3 128 341 Query Name Query Parent 1 Parent 2 -------------------------- ---------------------------------------------------------------------------------------------------------- ------------------ ------------------ 1 A 5 SCOTT 3 121 3 130 1 8 1 1 1 1 3 128 39 &NAME &QUERY &PARENT_1 &MATRIX_NAME 1 A 5 SCOTT 3 121 3 139 1 8 1 1 1 1 3 128 42 Report Name: &REPORT_NAME Appid: &APPID6 1 A 5 SCOTT 3 121 3 153 1 8 1 1 1 1 3 128 198 &GROUP_NAME &QUERY_NAME &MATRIX_FLAG &PAGE_BREAK &RELATIVE_POS &LINES_BEFORE &SPACES_BEFORE &INTER_ROW &INTER_FIELD &FIELDS_ACROSS &MULTI_PANEL &LOCATE_LABELS &FIELD_HILITE &LABEL_HILITE 1 A 5 SCOTT 3 121 3 177 1 5 1 1 1 2 3 144 172 ======================================================================== GROUP INFORMATION ============================================================================== 3 128 516 Page Relative Lines Spaces -- Spacing - Fields Multi Locate ---- Highlight ------ Group Name Query Name Matrix Break Position Before Before Rec Field Across Panel Labels Field Label ------------------------------ ------------------------------ ------ ----------- -------- ------ ------ ----- ----- ------ ----- ------ ---------- ---------- 1 A 5 SCOTT 3 121 3 177 1 8 1 1 1 1 3 128 6 &NULL1 1 A 5 SCOTT 3 121 3 184 1 8 1 1 1 1 3 128 184 &FIELD_NAME &TARGET_POSITION &COMPUTE &QUERY_NAME2 &HEADING &DATATYPE2 &WIDTH &FORMAT_MASK &POSITION &LINES_BEFORE2 &SPACES_BEFORE2 &ALIGNMENT &SKIP &REPRINT &FUNCTION &RESET_GROUP 1 A 5 SCOTT 3 121 3 209 1 5 1 1 1 2 3 144 173 ======================================================================== FIELD INFORMATION =============================================================================== 3 128 500 Relative Lines Spaces Reset Group Field Name Expr # Compute Query Heading Type Width Format Position Before Before Align Skip Repeat Function Group ---------------- ---------------- ------ ---------- ---------------- ---------- ------- ----- ------- -------- ------ ------ -------- ---- ------- -------- ---------------- 1 A 5 SCOTT 3 121 3 209 1 8 1 1 1 1 3 128 12 &GROUP_NAME2 1 A 5 SCOTT 3 121 3 215 1 8 1 1 1 1 3 128 44 &LOCAL_CNAME &PARENT1_CNAME &PARENT2_CNAME 1 A 5 SCOTT 3 121 3 232 1 7 1 1 1 2 3 144 168 ================================================================ SUMMARY INFORMATION ================================================================================ 3 128 314 Summary Name Source Datatype Width Format Mask Function Print At Reset At ------------------------------ ------------------------------ -------- ----- ----------- -------- ------------------------------ ------------------------------- 1 A 5 SCOTT 3 121 3 232 1 8 1 1 1 1 3 128 97 &SUMMARY_NAME &SOURCE &DATATYPE3 &WIDTH2 &FORMAT_MASK2 &FUNCTION3 &PRINT_AT &RESET_AT 1 A 5 SCOTT 3 121 3 251 1 8 1 1 1 1 3 128 103 &TYPE &EDITED &LINES_BEFORE3 &SPACES_BEFORE3 &WIDTH3 &RELATIVE_POS3 &REPEAT &ALIGN &FREQUENCY 1 A 5 SCOTT 3 121 3 264 1 5 1 1 1 2 3 144 173 ============================================================= TEXT INFORMATION =========================================================================================== 3 128 244 Object Type Edited Lines Before Spaces Before Width Relative Pos Repeat Align Frequency ---------------- -------------- ------ ------------ ------------- ----- ------------ ------ ------ ---------------- 1 A 5 SCOTT 3 121 3 264 1 8 1 1 1 1 3 128 7 &OBJECT 1 A 5 SCOTT 3 121 3 275 1 7 1 1 1 1 3 128 182 Panel Text ----- ------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1 A 5 SCOTT 3 121 3 275 1 8 1 1 1 1 3 128 18 &PANEL &NOHL_TEXT 1 A 5 SCOTT 3 121 3 307 1 7 1 1 1 2 3 144 162 ================================================================== PARAMETER INFORMATION ====================================================================== 3 128 324 Parameter Name Datatype Width Default Value Label Input Mask Output Mask Skip Param Type ------------------------------ -------- ----- ---------------- ---------------------------------------- ---------------- ---------------- ---- ---------- 1 A 5 SCOTT 3 121 3 307 1 8 1 1 1 1 3 128 108 &PARAMETER_NAME &DATATYPE4 &WIDTH4 &DEFAULT_VALUE &LABEL &INPUT_MASK &OUTPUT_MASK &SKIP2 &PARAM_TYPE 1 A 5 SCOTT 3 121 3 336 1 8 1 1 1 1 3 128 287 &NULL Parent-Child Information: Current Query Parent 1 Parent 2 ----------------------------------------------- ----------------------------------------------- ------------------------------------------------ 1 D