Liren Large Software Subsidy 5/05.iso/a/a522/7.ddi/SRW80.REX

OS/2 REXX Batch file | 1990-12-05 | 64.5 KB | 5,527 lines

16   SQL*ReportWriter5    101115    srw80
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
6    REPORT
4    5069
2    93
1    6
7    DECIMAL
1    A
6    REPORT
4    5069
2    94
1    6
9    THOUSANDS
1    A
6    REPORT
4    5069
2    95
1    6
8    CURRENCY
1    A
6    REPORT
4    5069
2    96
1    6
6    COPIES
1    A
6    REPORT
4    5069
2    97
1    6
9    DESFORMAT
1    A
6    REPORT
4    5069
2    98
1    6
7    DESNAME
1    A
6    REPORT
4    5069
2    99
1    6
7    DESTYPE
1    A
6    REPORT
4    5069
3    103
1    2
8    Q_REPORT
1    A
6    REPORT
4    5069
3    104
1    3
8    G_REPORT
1    A
6    REPORT
4    5069
3    108
1    4
11   PAGE_HEIGHT
1    A
6    REPORT
4    5069
3    109
1    4
10   PAGE_WIDTH
1    A
6    REPORT
4    5069
3    110
1    4
11   LEFT_MARGIN
1    A
6    REPORT
4    5069
3    111
1    4
12   RIGHT_MARGIN
1    A
6    REPORT
4    5069
3    112
1    4
10   TOP_MARGIN
1    A
6    REPORT
4    5069
3    113
1    4
13   BOTTOM_MARGIN
1    A
6    REPORT
4    5069
3    116
1    4
8    COMMENTS
1    A
6    REPORT
4    5069
3    117
1    4
5    OWNER
1    A
6    REPORT
4    5069
3    118
1    4
8    MODIFIER
1    A
6    REPORT
4    5069
3    119
1    4
11   CREATE_DATE
1    A
6    REPORT
4    5069
3    120
1    4
13   MODIFIED_DATE
1    A
6    REPORT
4    5069
3    121
1    4
11   PARAM_TITLE
1    A
6    REPORT
4    5069
3    122
1    4
10   PARAM_HINT
1    A
6    REPORT
4    5069
3    123
1    4
12   PARAM_STATUS
1    A
6    REPORT
4    5069
3    124
1    6
12   WHICH_REPORT
1    A
6    REPORT
4    5069
3    125
1    2
9    Q_GRANTEE
1    A
6    REPORT
4    5069
3    126
1    3
9    G_GRANTEE
1    A
6    REPORT
4    5069
3    128
1    4
7    GRANTEE
1    A
6    REPORT
4    5069
3    129
1    2
7    Q_QUERY
1    A
6    REPORT
4    5069
3    130
1    3
7    G_QUERY
1    A
6    REPORT
4    5069
3    137
1    4
5    QUERY
1    A
6    REPORT
4    5069
3    138
1    2
12   Q_REPORTHEAD
1    A
6    REPORT
4    5069
3    139
1    3
12   G_REPORTHEAD
1    A
6    REPORT
4    5069
3    143
1    4
4    NAME
1    A
6    REPORT
4    5069
3    145
1    4
8    PARENT_1
1    A
6    REPORT
4    5069
3    152
1    2
7    Q_GROUP
1    A
6    REPORT
4    5069
3    153
1    3
7    G_GROUP
1    A
6    REPORT
4    5069
3    161
1    4
12   LINES_BEFORE
1    A
6    REPORT
4    5069
3    162
1    4
13   SPACES_BEFORE
1    A
6    REPORT
4    5069
3    163
1    4
9    INTER_ROW
1    A
6    REPORT
4    5069
3    164
1    4
11   INTER_FIELD
1    A
6    REPORT
4    5069
3    168
1    4
13   FIELDS_ACROSS
1    A
6    REPORT
4    5069
3    169
1    4
11   MULTI_PANEL
1    A
6    REPORT
4    5069
3    170
1    4
11   MATRIX_FLAG
1    A
6    REPORT
4    5069
3    172
1    4
10   GROUP_NAME
1    A
6    REPORT
4    5069
3    173
1    4
10   QUERY_NAME
1    A
6    REPORT
4    5069
3    177
1    3
9    G_QUERY_G
1    A
6    REPORT
4    5069
3    178
1    4
10   PAGE_BREAK
1    A
6    REPORT
4    5069
3    179
1    4
12   RELATIVE_POS
1    A
6    REPORT
4    5069
3    180
1    4
13   LOCATE_LABELS
1    A
6    REPORT
4    5069
3    181
1    4
12   FIELD_HILITE
1    A
6    REPORT
4    5069
3    182
1    4
12   LABEL_HILITE
1    A
6    REPORT
4    5069
3    183
1    2
7    Q_FIELD
1    A
6    REPORT
4    5069
3    184
1    3
7    G_FIELD
1    A
6    REPORT
4    5069
3    191
1    4
7    COMPUTE
1    A
6    REPORT
4    5069
3    192
1    4
7    HEADING
1    A
6    REPORT
4    5069
3    193
1    4
4    SKIP
1    A
6    REPORT
4    5069
3    196
1    4
5    WIDTH
1    A
6    REPORT
4    5069
3    203
1    4
14   SPACES_BEFORE2
1    A
6    REPORT
4    5069
3    205
1    4
10   FIELD_NAME
1    A
6    REPORT
4    5069
3    206
1    4
11   GROUP_NAME2
1    A
6    REPORT
4    5069
3    207
1    4
11   QUERY_NAME2
1    A
6    REPORT
4    5069
3    208
1    4
11   RESET_GROUP
1    A
6    REPORT
4    5069
3    209
1    3
9    G_GROUP_F
1    A
6    REPORT
4    5069
3    210
1    4
9    DATATYPE2
1    A
6    REPORT
4    5069
3    211
1    4
8    FUNCTION
1    A
6    REPORT
4    5069
3    212
1    4
8    POSITION
1    A
6    REPORT
4    5069
3    213
1    4
9    ALIGNMENT
1    A
6    REPORT
4    5069
3    214
1    2
6    Q_LINK
1    A
6    REPORT
4    5069
3    215
1    3
6    G_LINK
1    A
6    REPORT
4    5069
3    219
1    4
11   LOCAL_TLPOS
1    A
6    REPORT
4    5069
3    224
1    4
9    PARENTC_1
1    A
6    REPORT
4    5069
3    225
1    4
9    PARENTC_2
1    A
6    REPORT
4    5069
3    231
1    2
9    Q_SUMMARY
1    A
6    REPORT
4    5069
3    232
1    3
9    G_SUMMARY
1    A
6    REPORT
4    5069
3    239
1    4
6    WIDTH2
1    A
6    REPORT
4    5069
3    241
1    4
12   FORMAT_MASK2
1    A
6    REPORT
4    5069
3    245
1    4
6    SOURCE
1    A
6    REPORT
4    5069
3    247
1    4
9    DATATYPE3
1    A
6    REPORT
4    5069
3    248
1    4
9    FUNCTION3
1    A
6    REPORT
4    5069
3    249
1    4
12   SUMMARY_NAME
1    A
6    REPORT
4    5069
3    250
1    2
6    Q_TEXT
1    A
6    REPORT
4    5069
3    251
1    3
6    G_TEXT
1    A
6    REPORT
4    5069
3    253
1    4
6    OBJECT
1    A
6    REPORT
4    5069
3    254
1    4
4    TYPE
1    A
6    REPORT
4    5069
3    255
1    4
6    EDITED
1    A
6    REPORT
4    5069
3    257
1    4
13   LINES_BEFORE3
1    A
6    REPORT
4    5069
3    258
1    4
14   SPACES_BEFORE3
1    A
6    REPORT
4    5069
3    259
1    4
6    WIDTH3
1    A
6    REPORT
4    5069
3    263
1    4
13   RELATIVE_POS3
1    A
6    REPORT
4    5069
3    264
1    3
9    G_GROUP_T
1    A
6    REPORT
4    5069
3    274
1    4
4    TEXT
1    A
6    REPORT
4    5069
3    275
1    3
7    G_PANEL
1    A
6    REPORT
4    5069
3    288
1    4
6    REPEAT
1    A
6    REPORT
4    5069
3    289
1    4
5    PANEL
1    A
6    REPORT
4    5069
3    290
1    4
5    ALIGN
1    A
6    REPORT
4    5069
3    291
1    4
8    PRINT_AT
1    A
6    REPORT
4    5069
3    297
1    4
9    FREQUENCY
1    A
6    REPORT
4    5069
3    303
1    5
2    s1
1    A
6    REPORT
4    5069
3    304
1    4
8    RESET_AT
1    A
6    REPORT
4    5069
3    306
1    2
7    Q_PARAM
1    A
6    REPORT
4    5069
3    307
1    3
7    G_PARAM
1    A
6    REPORT
4    5069
3    309
1    4
14   PARAMETER_NAME
1    A
6    REPORT
4    5069
3    311
1    4
6    WIDTH4
1    A
6    REPORT
4    5069
3    312
1    4
13   DEFAULT_VALUE
1    A
6    REPORT
4    5069
3    313
1    4
5    LABEL
1    A
6    REPORT
4    5069
3    316
1    4
11   OUTPUT_MASK
1    A
6    REPORT
4    5069
3    317
1    4
5    SKIP2
1    A
6    REPORT
4    5069
3    318
1    4
9    DATATYPE4
1    A
6    REPORT
4    5069
3    325
1    4
7    VERSION
1    A
6    REPORT
4    5069
3    326
1    4
16   MODIFIED_VERSION
1    A
6    REPORT
4    5069
3    328
1    4
15   QUERY_NAME_SKIP
1    A
6    REPORT
4    5069
3    329
1    4
10   REPETITION
1    A
6    REPORT
4    5069
3    330
1    4
11   MATRIX_NAME
1    A
6    REPORT
4    5069
3    332
1    4
11   REPORT_NAME
1    A
6    REPORT
4    5069
3    336
1    3
8    G_HIDE_L
1    A
6    REPORT
4    5069
3    337
1    4
4    NULL
1    A
6    REPORT
4    5069
3    351
1    4
6    APPID6
1    A
6    REPORT
4    5069
3    355
1    4
8    UPMATCH2
1    A
6    REPORT
4    5069
3    382
1    4
5    NULL1
1    A
6    REPORT
4    5069
3    383
1    4
9    NOHL_TEXT
1    A
6    REPORT
4    5069
3    384
1    4
12   LOCAL_ITEMID
1    A
6    REPORT
4    5069
3    385
1    4
11   LOCAL_CNAME
1    A
6    REPORT
4    5069
3    386
1    4
5    APPID
1    A
6    REPORT
4    5069
3    387
1    4
7    QUERYID
1    A
6    REPORT
4    5069
3    388
1    4
8    PARENTID
1    A
6    REPORT
4    5069
3    389
1    4
13   PARENT_ITEMID
1    A
6    REPORT
4    5069
3    390
1    4
13   PARENT1_CNAME
1    A
6    REPORT
4    5069
3    391
1    4
13   PARENT2_CNAME
1    A
6    REPORT
4    5069
3    393
1    4
12   FORMAT_MASK3
1    A
6    REPORT
4    5069
3    394
1    4
8    REPRINT2
1    A
6    REPORT
4    5069
3    395
1    4
13   LINES_BEFORE4
1    A
6    REPORT
4    5069
3    396
1    4
11   INPUT_MASK2
1    A
6    REPORT
4    5069
3    398
1    4
10   PARAM_TYPE
1    A
6    REPORT
4    5069
3    399
1    4
15   TARGET_POSITION
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
6    REPORT
4    5069
3    103
3    138
1    1
1    2
1    A
6    REPORT
4    5069
3    125
3    103
1    1
1    1
1    A
6    REPORT
4    5069
3    129
3    138
1    2
1    2
1    A
6    REPORT
4    5069
3    152
3    138
1    1
1    2
1    A
6    REPORT
4    5069
3    183
3    138
1    1
1    2
1    A
6    REPORT
4    5069
3    214
3    129
1    4
1    3
1    A
6    REPORT
4    5069
3    214
3    129
1    1
1    2
1    A
6    REPORT
4    5069
3    231
3    138
1    1
1    2
1    A
6    REPORT
4    5069
3    250
3    138
1    1
1    2
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    139
3    138
1    2
1    1
1    1
0
0
0
0
0
0
0
0
0
0
1    2
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    184
3    183
0
2    10
1    1
0
1    0
0
1    1
0
0
1    1
0
0
0
1    2
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    275
3    250
0
2    15
1    1
1    1
1    0
1    1
0
0
0
1    1
0
0
0
0
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
3    336
3    214
1    1
1    5
1    1
0
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
6    REPORT
4    5069
3    124
1    1
1    2
2    30
1    %
22   Which Report (or Wild)
1    1
0
0
0
1    A
6    REPORT
4    5069
2    99
1    2
1    2
2    80
6    Screen
26   Screen/Printer/File/Sysout
1    0
0
0
0
1    A
6    REPORT
4    5069
2    98
1    3
1    2
2    80
9    srw80.lis
24   File Name / Spool Device
1    0
0
0
1    X
1    A
6    REPORT
4    5069
2    97
1    4
1    2
2    80
6    dec180
24   Printer Description File
1    0
0
0
1    X
1    A
6    REPORT
4    5069
2    96
1    5
1    1
1    2
1    1
16   Number of Copies
1    0
0
0
1    X
1    A
6    REPORT
4    5069
2    95
1    6
1    2
1    4
0
15   Currency Symbol
1    0
0
0
1    X
1    A
6    REPORT
4    5069
2    94
1    7
1    2
1    1
0
19   Thousands Separator
1    0
0
0
1    X
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    125
3    103
0
1    3
36   select * from SRW_GRANTED
order by 2
1    A
6    REPORT
4    5069
3    129
3    138
0
1    4
422  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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    152
3    138
0
1    6
1138 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, 'Con', 2, 'Alw', '') 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, 'Abv', 2, 'Lft', '') locate_labels,
       decode(field_hilite, 0, 'Nor', 2, 'Und', 4, 'Rev',
                           16, 'Bld',   6, 'U/R',  18, 'U/B',
                           20, 'R/B', 22, 'U/R/B', '') field_hilite,

       decode(label_hilite, 0, 'Nor', 2, 'Und', 4, 'Rev',
                           16, 'Bld',   6, 'U/R',  18, 'U/B',
                           20, 'R/B', 22, 'U/R/B', '') 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
6    REPORT
4    5069
3    183
3    138
0
1    7
1498 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, 'CHR' ||'/',
                         3, 'DAT' ||'/', 4, 'PRT' ||'/', '' ||'/') 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, 'Bel' ||'/', 2, 'Rgt' ||'/', 3, 'Pnl' ||'/', '' ||'/') position,
       lines_before ||'/'      ,
       spaces_before           ,
       decode(alignment, 1, 'Lft', 2, 'Rt', 3, 'Ctr', 4, 'Wrp',
                    5, 'Var', '') 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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    250
3    138
0
2    10
1042 select t.appid,
       t.itemid,
       decode(t.itemid, 1, 'Report', 2, 'Page', s.name) object,
       decode(t.type, 3, 'Title Pg', 4, 'Trail Pg', 5, 'Header',
                      6, 'Footer', 7, 'Col Head', 8, 'Body',
                      9, 'Subfoot', '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
6    REPORT
4    5069
3    306
3    138
0
1    9
468  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    11
3    240
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
860  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, 'Con', 2, 'Alw', '') 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, 'Abv', 2, 'Lft', '') LOCATE_LABELS, DECODE(FIELD_HILITE, 0, 'Nor', 2, 'Und', 4, 'Rev', 16, 'Bld', 6, 'U/R', 18, 'U/B', 20, 'R/B', 22, 'U/R/B', '') FIELD_HILITE, DECODE(LABEL_HILITE, 0, 'Nor', 2, 'Und', 4, 'Rev', 16, 'Bld', 6, 'U/R', 18, 'U/B', 20, 'R/B', 22, 'U/R/B', '') 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
1    3
1    5
1    5
1    5
1    5
1    5
1    5
1    1
1    3
1    5
1    5
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
1087 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, 'CHR' ||'/', 3, 'DAT' ||'/', 4, 'PRT' ||'/', '' ||'/') 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, 'Bel' ||'/', 2, 'Rgt' ||'/', 3, 'Pnl' ||'/', '' ||'/') POSITION, LINES_BEFORE ||'/' , SPACES_BEFORE , DECODE(ALIGNMENT, 1, 'Lft', 2, 'Rt', 3, 'Ctr', 4, 'Wrp', 5, 'Var', '') 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    2
1    2
1    2
1    2
1    2
1    1
1    2
1    2
1    2
1    2
1    2
1    2
1    1
1    2
2    11
2    81
2    80
2    80
2    41
3    240
3    240
1    1
2    41
1    5
1    4
1    8
2    80
1    2
1    4
2    41
1    5
1    3
1    2
1    1
1    1
1    1
1    1
1    1
1    1
1    1
1    1
1    2
1    1
1    1
1    1
1    1
1    1
1    1
1    2
1    1
5    APPID
10   FIELD_NAME
10   GROUP_NAME
10   QUERY_NAME
20   TARGET_POSITION||'/'
7    COMPUTE
7    HEADING
4    SKIP
16   FORMAT_MASK||'/'
5    WIDTH
8    DATATYPE
8    FUNCTION
11   RESET_GROUP
12   REPRINT||'/'
8    POSITION
17   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
857  SELECT T.APPID, T.ITEMID, DECODE(T.ITEMID, 1, 'Report', 2, 'Page', S.NAME) OBJECT, DECODE(T.TYPE, 3, 'Title Pg', 4, 'Trail Pg', 5, 'Header', 6, 'Footer', 7, 'Col Head', 8, 'Body', 9, 'Subfoot', '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
1    8
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
329  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    81
1    8
1    5
3    240
3    240
1    4
2    41
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
15   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
4    5069
3    400
5    srw80
2    60
2    80
1    0
1    0
1    0
1    2
4    1108
4    1111
1095 This report provides a complete listing of a SQL*ReportWriter report.

It is designed to run on printers supporting line lengths of at least 80
characters.

A number of tricks are used to format this report which may be of interest:

* The Relative Position of the body and footer of the access list are set
  to Margin to move them "within" the report level info.
* 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.
* 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".
* 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.
* User exits translate the target list position of expressions in queries
  and also remove the highlighting information from text objects.
6    REPORT
6    REPORT
14   19891023122720
14   19900625170810
16    Report Listing
25    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
6    REPORT
4    5069
3    108
3    104
3    103
1    2
0
6    Height
0
1    3
0
1    3
1    1
0
0
0
1    1
1    4
1    5
0
1    A
6    REPORT
4    5069
3    112
3    104
3    103
1    6
0
6    Top
0
1    4
0
1    3
1    1
0
0
0
0
0
1    5
0
1    A
6    REPORT
4    5069
3    121
3    104
3    103
2    15
0
7    Title
0
1    5
0
2    40
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    109
3    104
3    103
1    3
0
6    Width
0
1    6
0
1    3
1    1
0
0
0
1    1
0
1    5
0
1    A
6    REPORT
4    5069
3    113
3    104
3    103
1    7
0
6    Bottom
0
1    7
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    122
3    104
3    103
2    16
0
7    Hint
0
1    8
0
2    40
1    2
0
0
0
0
0
1    5
0
1    A
6    REPORT
4    5069
3    110
3    104
3    103
1    4
0
6    Left
0
1    9
0
1    3
1    1
0
0
0
1    1
0
2    22
0
1    A
6    REPORT
4    5069
3    123
3    104
3    103
2    17
0
7    Status
0
2    10
0
2    40
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    111
3    104
3    103
1    5
0
6    Right
0
2    11
0
1    3
1    1
0
0
0
1    1
0
2    22
0
1    A
6    REPORT
4    5069
3    116
3    104
3    103
2    10
0
0
0
2    12
0
2    50
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    117
3    104
3    103
2    11
0
9     Created:
0
2    13
0
2    11
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
3    118
3    104
3    103
2    12
0
9    Modified:
0
2    15
0
2    11
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    128
3    126
3    125
1    2
0
0
0
2    19
0
2    15
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    143
3    130
3    129
1    1
0
10   Query Name
0
2    20
0
2    25
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    137
3    130
3    129
1    4
0
5    Query
0
2    21
0
2    70
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    145
3    130
3    129
1    5
0
8    Parent 1
0
2    22
0
2    25
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    330
3    130
3    129
1    6
0
11   Matrix Name
0
2    23
0
2    25
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    172
3    153
3    152
1    2
0
10   Group Name
0
2    37
0
2    12
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    173
3    153
3    152
1    3
0
10   Query Name
0
2    38
0
2    12
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    170
3    153
3    152
1    4
0
6    Matrix
0
2    39
0
1    3
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
3    178
3    153
3    152
1    6
0
10   Page Break
0
2    41
0
1    3
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    179
3    153
3    152
1    7
0
3    Pos
0
2    42
0
1    3
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    161
3    153
3    152
1    8
0
6    Before
0
2    43
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    162
3    153
3    152
1    9
0
6    Before
0
2    44
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    163
3    153
3    152
2    10
0
3    Row
0
2    45
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    164
3    153
3    152
2    11
0
5    Field
0
2    46
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    168
3    153
3    152
2    12
0
13   Fields Across
0
2    47
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    169
3    153
3    152
2    13
0
5    Panel
0
2    48
0
1    3
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    180
3    153
3    152
2    14
0
6    Labels
0
2    49
0
1    3
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    181
3    153
3    152
2    15
0
6    Field
0
2    50
0
1    5
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    182
3    153
3    152
2    16
0
6    Label
0
2    51
0
1    5
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    205
3    184
3    183
1    2
0
10   Field Name
0
2    56
0
2    20
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    399
3    184
3    183
1    5
0
15   Target Position
0
2    57
0
2    10
1    2
0
0
0
0
0
2    10
0
1    A
6    REPORT
4    5069
3    191
3    184
3    183
1    6
0
7    Compute
0
2    58
0
2    20
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    192
3    184
3    183
1    7
0
7    Heading
0
2    59
0
2    19
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    210
3    184
3    183
2    11
0
4    Type
0
2    60
0
1    4
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    196
3    184
3    183
2    10
0
5    Width
0
2    61
0
1    3
1    1
0
0
0
0
0
0
1    1
1    A
6    REPORT
4    5069
3    212
3    184
3    183
2    15
0
8    Position
0
2    62
0
1    5
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    203
3    184
3    183
2    17
0
3    Bef
0
2    63
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    213
3    184
3    183
2    18
0
5    Align
0
2    64
0
1    4
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    193
3    184
3    183
1    8
0
4    Skip
0
2    65
0
1    1
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    211
3    184
3    183
2    12
0
8    Function
0
2    66
0
1    5
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    208
3    184
3    183
2    13
0
5    Group
0
2    67
0
2    11
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    393
3    184
3    183
1    9
0
11   Format Mask
0
2    68
0
2    12
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    394
3    184
3    183
2    14
0
7    Reprint
0
2    69
0
1    6
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    395
3    184
3    183
2    16
0
12   Lines Before
0
2    70
0
1    4
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    206
3    209
3    183
1    3
0
0
0
2    54
0
2    20
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    207
3    209
3    183
1    4
0
0
0
2    55
0
2    20
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    385
3    215
1    0
1    0
53   #RWEGSC LOCAL_CNAME APPID6 LOCAL_ITEMID LOCAL_TLPOS 0
0
0
2    29
0
2    25
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    390
3    215
1    0
1    0
54   #RWEGSC PARENT1_CNAME APPID6 PARENT_ITEMID PARENTC_1 0
0
0
2    32
0
2    25
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    391
3    215
1    0
1    0
54   #RWEGSC PARENT2_CNAME APPID6 PARENT_ITEMID PARENTC_2 0
0
0
2    33
0
2    25
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
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
6    REPORT
4    5069
3    249
3    232
3    231
1    3
0
12   Summary Name
0
2    71
0
2    12
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    245
3    232
3    231
1    4
0
6    Source
0
2    72
0
2    12
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    247
3    232
3    231
1    5
0
8    Datatype
0
2    73
0
1    4
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    239
3    232
3    231
1    8
0
5    Width
0
2    74
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    241
3    232
3    231
1    7
0
11   Format Mask
0
2    75
0
2    12
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    248
3    232
3    231
1    6
0
8    Function
0
2    76
0
1    5
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    291
3    232
3    231
1    9
0
8    Print At
0
2    77
0
2    12
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    304
3    232
3    231
2    10
0
8    Reset At
0
2    78
0
2    12
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    254
3    251
3    250
1    4
0
0
0
2    89
0
1    8
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    255
3    251
3    250
1    5
0
0
0
2    90
0
1    3
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    257
3    251
3    250
1    7
0
0
0
2    91
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    258
3    251
3    250
1    8
0
0
0
2    92
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    259
3    251
3    250
1    9
0
0
0
2    93
0
1    3
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    263
3    251
3    250
1    6
0
0
0
2    94
0
1    3
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    288
3    251
3    250
2    11
0
0
0
2    95
0
1    3
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    290
3    251
3    250
2    10
0
0
0
2    96
0
1    4
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    297
3    251
3    250
2    12
0
0
0
2    97
0
2    20
1    2
1    3
3    251
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    253
3    264
3    250
1    3
0
0
0
2    88
0
2    20
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    289
3    275
3    250
2    13
0
0
0
2    98
0
1    5
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    274
3    275
3    250
2    14
0
0
1    X
2    99
0
2    80
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    383
3    275
1    0
1    0
22   #RWERTH TEXT NOHL_TEXT
0
0
3    100
0
2    70
1    2
0
0
0
0
0
0
1    4
1    A
6    REPORT
4    5069
3    309
3    307
3    306
1    2
0
14   Parameter Name
0
2    79
0
2    28
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    318
3    307
3    306
1    3
0
8    Datatype
0
2    80
0
1    5
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    311
3    307
3    306
1    4
0
5    Width
0
2    81
0
1    4
1    1
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    312
3    307
3    306
1    5
0
13   Default Value
0
2    82
0
2    19
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    313
3    307
3    306
1    6
0
5    Label
0
2    83
0
2    27
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    316
3    307
3    306
1    9
0
11   Output Mask
0
2    84
0
2    20
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    317
3    307
3    306
2    10
0
4    Skip
0
2    85
0
1    1
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    396
3    307
3    306
1    8
0
10   Input Mask
0
2    86
0
2    20
1    2
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    398
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
6    REPORT
4    5069
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
6    REPORT
4    5069
3    303
3    205
1    2
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
6    REPORT
4    5069
1    1
1    3
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
1    1
1    4
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
1    1
1    5
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
1    1
1    6
1    X
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
1    2
1    5
1    X
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
1    2
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    104
1    5
0
0
0
0
0
1    3
0
0
1    A
6    REPORT
4    5069
3    104
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    104
1    7
0
0
0
0
1    X
1    1
1    1
0
1    A
6    REPORT
4    5069
3    104
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    126
1    5
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    126
1    6
1    X
1    4
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    126
1    7
0
0
0
0
1    X
1    1
3    104
0
1    A
6    REPORT
4    5069
3    126
1    8
1    X
1    4
1    7
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    130
1    5
0
0
1    2
0
0
1    3
0
0
1    A
6    REPORT
4    5069
3    130
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    130
1    7
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    130
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    139
1    5
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    139
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    139
1    7
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    139
1    8
1    X
0
0
0
1    X
1    3
0
0
1    A
6    REPORT
4    5069
3    153
1    5
0
0
0
0
0
1    3
0
0
1    A
6    REPORT
4    5069
3    153
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    153
1    7
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    153
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    177
1    5
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    177
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    177
1    7
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    177
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    184
1    5
0
0
0
0
0
1    3
0
0
1    A
6    REPORT
4    5069
3    184
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    184
1    7
1    X
0
1    1
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    184
1    8
1    X
1    4
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    209
1    5
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    209
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    209
1    7
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    209
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    215
1    5
0
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    215
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    215
1    7
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    215
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    232
1    5
0
0
0
0
0
1    3
0
0
1    A
6    REPORT
4    5069
3    232
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    232
1    7
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    232
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    251
1    5
0
0
0
0
0
0
0
0
1    A
6    REPORT
4    5069
3    251
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    251
1    7
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    251
1    8
1    X
0
0
1    1
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    264
1    5
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    264
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    264
1    7
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    264
1    8
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    275
1    5
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    275
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    275
1    7
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    275
1    8
1    X
1    4
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    307
1    5
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    307
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    307
1    7
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    307
1    8
1    X
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    336
1    5
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    336
1    6
0
0
0
0
0
1    1
0
0
1    A
6    REPORT
4    5069
3    336
1    7
0
0
0
0
1    X
1    1
0
0
1    A
6    REPORT
4    5069
3    336
1    8
1    X
0
0
0
1    X
1    1
0
0
1    B
13   SRW_TEXT_LONG
1    6
5    OWNER
1    1
5    APPID
1    2
6    ITEMID
1    2
4    TYPE
1    2
5    PANEL
1    2
4    TEXT
1    8
1    A
6    REPORT
4    5069
1    1
1    6
1    1
1    1
3    144
78   =====================  END OF REPORT DEFINITION LISTING  =====================
1    A
6    REPORT
4    5069
1    2
1    5
1    1
1    1
3    128
130  Page &PAGE                                                           &DATE

                           Report Definition Listing


1    A
6    REPORT
4    5069
3    104
1    8
1    1
1    2
3    144
77   =========================  REPORT LEVEL INFORMATION  ========================
3    128
968

 ---- Page ----- Margin  ------------------  Parameter Form  ----------------
| Height &PAGE_HEIGHT | Top    &TOP_MARGIN | Title: &PARAM_TITLE  |
| 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   |
                           ----------------------  Comments  ----------------
                            &COMMENTS
1    A
6    REPORT
4    5069
3    126
1    6
1    1
1    1
3    128
27    -------------------------

1    A
6    REPORT
4    5069
3    126
1    8
1    1
1    1
3    128
12   | &GRANTEE |
1    A
6    REPORT
4    5069
3    130
1    8
1    1
1    2
3    144
78   =============================  QUERY INFORMATION  ============================
3    128
192

Query Name:  &NAME  Parent 1:  &PARENT_1
                                        Parent 2:  &MATRIX_NAME
----------------------------------  Query  -----------------------------------
&QUERY
1    A
6    REPORT
4    5069
3    139
1    8
1    1
1    1
3    128
71                         Report Name:  &REPORT_NAME
       Appid:  &APPID6
1    A
6    REPORT
4    5069
3    153
1    8
1    1
1    1
3    128
186  &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
6    REPORT
4    5069
3    177
1    5
1    1
1    2
3    144
78   =============================  GROUP INFORMATION  ===========================
3    128
235
                              Pg  Rel Lin Sp  -Spac-- Fld Mlt Lbl -Highlight-
Group Name   Query Name   Mtx Brk Pos Bef Bef Rec Fld Acr Pnl Pos Field Label
------------ ------------ --- --- --- --- --- --- --- --- --- --- ----- -----
1    A
6    REPORT
4    5069
3    177
1    8
1    1
1    1
3    128
6    &NULL1
1    A
6    REPORT
4    5069
3    184
1    7
1    1
1    1
3    128
361                                                       Lin  S Rep
                                               Rel   Bef/ k  On
Field Name/          Typ/ Expr #/              Pos/  Sp   i Pg/    Format/
Field Label          Wid  Compute              Align Bef  p Fctn   Reset Group
-------------------- ---- -------------------- ----- ---- - ------ ------------
1    A
6    REPORT
4    5069
3    184
1    8
1    1
1    1
3    128
186  &FIELD_NAME &DATATYPE2 &TARGET_POSITION           &POSITION &LINES_BEFORE4 &SKIP &REPRINT2 &FORMAT_MASK3
&HEADING  &WIDTH &COMPUTE  &ALIGNMENT  &SPACES_BEFORE2    &FUNCTION  &RESET_GROUP
1    A
6    REPORT
4    5069
3    209
1    5
1    1
1    1
3    144
80   =============================  FIELD INFORMATION  =============================
1    A
6    REPORT
4    5069
3    209
1    8
1    1
1    1
3    128
44   Group:  &GROUP_NAME2    Query:  &QUERY_NAME2
1    A
6    REPORT
4    5069
3    215
1    8
1    1
1    1
3    128
42   &LOCAL_CNAME &PARENT1_CNAME &PARENT2_CNAME
1    A
6    REPORT
4    5069
3    232
1    7
1    1
1    2
3    144
80   ==============================  SUMMARY INFORMATION  ==========================
3    128
190
                          Data
Summary Name Source       Type Wid Format Mask  Fctn  Print Group  Reset Group
------------ ------------ ---- --- ------------ ----- ------------ ------------
1    A
6    REPORT
4    5069
3    232
1    8
1    1
1    1
3    128
85   &SUMMARY_NAME &SOURCE &DATATYPE3 &WIDTH2 &FORMAT_MASK2 &FUNCTION3 &PRINT_AT &RESET_AT
1    A
6    REPORT
4    5069
3    251
1    8
1    1
1    1
3    128
93   &TYPE &EDITED &LINES_BEFORE3 &SPACES_BEFORE3 &WIDTH3 &RELATIVE_POS3 &REPEAT &ALIGN &FREQUENCY
1    A
6    REPORT
4    5069
3    264
1    7
1    1
1    2
3    144
80   =============================  TEXT INFORMATION  ==============================
3    128
257
                                                  Rep
                                  Lin Sp      Rel  on
Object               Type     Edt Bef Bef Wid Pos  Pg Algn Frequency
-------------------- -------- --- --- --- --- --- --- ---- --------------------
1    A
6    REPORT
4    5069
3    264
1    8
1    1
1    1
3    128
7    &OBJECT
1    A
6    REPORT
4    5069
3    275
1    8
1    1
1    1
3    128
110  Panel:  &PANEL
Text
-------------------------------------------------------------------------------
&NOHL_TEXT
1    A
6    REPORT
4    5069
3    307
1    7
1    1
1    2
3    144
77   ============================  PARAMETER INFORMATION  ========================
3    128
390
                                                                            S
                                                                            k
Parameter Name/              Type/ Default Value       Input Mask/          i
Label                        Wid                       Output Mask          p
---------------------------- ----- ------------------- -------------------- -
1    A
6    REPORT
4    5069
3    307
1    8
1    1
1    1
3    128
110  &PARAMETER_NAME &DATATYPE4 &DEFAULT_VALUE &INPUT_MASK2 &SKIP2
&LABEL &WIDTH4                      &OUTPUT_MASK
1    A
6    REPORT
4    5069
3    336
1    8
1    1
1    1
3    128
224  &NULL
--------------------------  Parent-Child Information  ------------------------
Current Query             Parent 1                  Parent 2
------------------------- ------------------------- --------------------------
1    D