Sample Lister Report

Following is a sample report where the parameter file contained the settings shown in the Lister Report.

DATABridge Lister Report for BANKDB using (DB)DESCRIPTION/BANKDB ON HOST

Created Sunday, November 23, 2009 @ 05:26:05

Version 60.x.x compiled weekday, month day, year @ time

Reading parameter file (DB)DATA/LISTER/BANKDB/CONTROL ON HOST

List Options

------------

Names only = False

Max records = False

Comments = False

Parent = True

Sets = True

Subsets = False

Keys = True

DataItems = True

Null = False

Links = False

Filter = DBFILTER

Support = OBJECT/DATABRIDGE/SUPPORT

#0001 Dataset: BANKDB Format level 0 RecSz 5

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 GLB-REAL Float 0 12 0 S

2 GLB-ALPHA Alpha 12 30 15

3 GLB-TS Float 42 12 0 S

#0002 Dataset: MASTER-DS Format level 0 RecSz 1

#0007 Set: MASTER-SET

Key: MST-ITEM

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1*MST-ITEM Alpha 0 12 6

#0003 Dataset: ORDERED-DS Format level 0 RecSz 2

#0002 Parent: MASTER-DS

#0004 Set: ORD-ACCESS

Key: ORD-ITEM

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1*ORD-ITEM Number 0 12 12

2 ORD-NAME Alpha 12 6 3

#0005 Dataset: EMB-STANDARD Format level 0 RecSz 1

#0002 Parent: MASTER-DS

#0006 Set: EMBEDDED-SET

Key: EMB-ITEM

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1*EMB-ITEM Number 0 12 12

#0008 Dataset: RSDATA Format level 0 RecSz 14

#0009 Set: RSSET Duplicates Key change OK

Key: RS-ID

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1*RS-ID Number 14 6 6

2 RS-NEW-ITEM Float 20 12 0 S

3 RS-DATA Alpha 32 128 64

#0010 Dataset: BANK Format level 0 RecSz 19

#0011 Set: BANKIDSET

Key: BANK-ID

#0012 Set: BANKNAMESET Duplicates Key change OK

Key: BANK-NAME

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1*BANK-ID Number 0 4 4

2*BANK-NAME Alpha 4 60 30

3 BANK-ADDR1 Alpha 64 60 30

4 BANK-ADDR2 Alpha 124 20 10

5 BANK-ADDR3 Alpha 144 60 30

6 BANK-ROUTE Number 204 9 9

7 TS Float 214 12 0 S

#0013 Dataset: BRANCH Format level 0 RecSz 11

#0016 Set: BRANCHIDSET Key change OK

Key: BANK-ID

BRANCH-ID

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1*BANK-ID Number 0 4 4

2*BRANCH-ID Number 4 4 4

3 BRANCH-NAM Alpha 8 22 11

4 BRANCH-AD1 Alpha 30 60 30

5 BRANCH-MGR Alpha 90 24 12

6 TS Float 114 12 0 S

#0014 Dataset: MERGE-BRANCH Format level 0 RecSz 8

Remap of BRANCH

#0016 Set: BRANCHIDSET Key change OK

Key: BANK-ID

BRANCH-ID

Data: BRANCH-EXT-DATA

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 BANK-ID Number 0 4 4

2 BRANCH-ID Number 4 4 4

3 BRANCH-NAM Alpha 8 22 11

4 BRANCH-MGR Alpha 30 24 12

5 BRANCH-EXT-DATA Alpha 54 20 10

6 TS Float 74 12 0 S

#0015 Dataset: R-BRANCH Format level 0 RecSz 4

Remap of BRANCH

#0016 Set: BRANCHIDSET Key change OK

Key: BANK-ID

BRANCH-ID

Data: R-VIRT

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 R-VIRT Number 0 9 9

2 BANK-ID Number 9 4 4

3 BRANCH-ID Number 13 4 4

4 BRANCH-NAM Alpha 18 22 11

#0017 Dataset: CUSTOMER Format level 0 RecSz 51

#0025 Set: CUSTOMERSET Duplicates Key change OK

Key: CUST-ID

#0026 Set: CUSTIDSET

Key: BANK-ID

CUST-ID

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1*CUST-ID Number 0 8 8

2*BANK-ID Number 8 4 4

3 CUST-SSN Number 12 9 9

4 CUST-NAME Alpha 22 60 30

5*CUST-LINES Number 82 1 1

6 CUST-ADDR Alpha 84 60 30 5 1

7 CUST-DOB Number 384 8 8

8 CUST-INFO Alpha 392 200 100

9 TS Float 592 12 0 S

#0018 Dataset: EMPLOYEES Format level 0 RecSz 14

#0021 Set: EMP-NAME-SET Duplicates Key change OK

Key: EMP-NAME

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 EMP-ID Number 0 6 6

2*EMP-NAME Group 6 88 0

3*EMP-LAST-NAME Alpha 6 40 20

4*EMP-FIRST-NAME Alpha 46 24 12

5*EMP-MIDDLE-NAME Alpha 70 24 12

6 EMP-ADDRESS Alpha 94 60 30

7 TS Float 154 12 0 S

#0022 Dataset: R-CUST Format level 0 RecSz 3

Remap of CUSTOMER

#0025 Set: CUSTOMERSET Duplicates Key change OK

Key: CUST-ID

#0026 Set: CUSTIDSET

Key: BANK-ID

CUST-ID

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 CUST-ID Number 0 8 8

2 BANK-ID Number 8 4 4

3 CUST-SSN Number 12 9 9

4 TS Float 22 12 0 S

#0023 Dataset: CUSTONELINE Format level 0 RecSz 32

Remap of CUSTOMER

#0025 Set: CUSTOMERSET Duplicates Key change OK

Key: CUST-ID

#0026 Set: CUSTIDSET

Key: BANK-ID

CUST-ID

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 CUST-ID Number 0 8 8

2 BANK-ID Number 8 4 4

3 CUST-NAME Alpha 12 60 30

4 CUST-LINES Number 72 1 1

5 CUST-ADDR Alpha 74 60 30 5 1

#0024 Dataset: CUSTNAMEONLY Format level 0 RecSz 7

Remap of CUSTOMER

#0025 Set: CUSTOMERSET Duplicates Key change OK

Key: CUST-ID

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 CUST-NAME Alpha 0 60 30

2 CUST-ID Number 60 8 8

3 TS Float 68 12 0 S

#0027 Dataset: TELLER Format level 0 RecSz 15

#0028 Set: TELLERIDSET

Key: BANK-ID

BRANCH-ID

TL-ID

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1*BANK-ID Number 0 4 4

2*BRANCH-ID Number 4 4 4

3 TL-PROC-DT Number 8 6 6

4*TL-ID Number 14 9 9

5 TL-SUP-ID Number 23 9 9

6 TL-NAME Alpha 32 60 30

7 TL-CSH-IN Number 92 12 11 2 S

8 TL-CSH-OUT Number 104 12 11 2 S

9 TL-CHKSIN Number 116 12 11 2 S

10 TL-CHKSOUT Number 128 12 11 2 S

11 TL-FLAGS Group 140 2 0

12 TL-ACTIVE Number 140 1 1

13 TL-AUTHRZD Number 141 1 1

15 TS Float 142 12 0 S

#0029 Dataset: ACCOUNT Format level 0 RecSz 9

#0030 Set: ACCOUNTSET

Key: BANK-ID

BRANCH-ID

AC-NUMBER

#0031 Set: AC-BYNBR Duplicates Key change OK

Key: AC-NUMBER

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 AC-TYPE Rec Type 0 1 4

2 AC-RELATED Group 2 24 0

3 AC-NEXT Number 2 12 12

4 AC-PRIOR Number 14 12 12

5*BANK-ID Number 26 4 4

6*BRANCH-ID Number 30 4 4

7*AC-NUMBER Number 34 12 12

8 CUST-ID Number 46 8 8

9 AC-BALANCE Number 54 12 11 2 S

10 AC-HLD-AMT Number 66 12 11 2 S

11 AC-DT-OPEN Number 78 6 6

12 AC-DT-CLSE Number 84 6 6

13 TS Float 90 12 0 S

#0029 Dataset: ACCOUNT (1) Format level 0 RecSz 26

#0030 Set: ACCOUNTSET

Key: BANK-ID

BRANCH-ID

AC-NUMBER

#0031 Set: AC-BYNBR Duplicates Key change OK

Key: AC-NUMBER

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 AC-TYPE Rec Type 0 1 4

2 AC-RELATED Group 2 24 0

3 AC-NEXT Number 2 12 12

4 AC-PRIOR Number 14 12 12

5*BANK-ID Number 26 4 4

6*BRANCH-ID Number 30 4 4

7*AC-NUMBER Number 34 12 12

8 CUST-ID Number 46 8 8

9 AC-BALANCE Number 54 12 11 2 S

10 AC-HLD-AMT Number 66 12 11 2 S

11 AC-DT-OPEN Number 78 6 6

12 AC-DT-CLSE Number 84 6 6

13 TS Float 90 12 0 S

14 AC-VF1-GROUP Group 102 200 0

15 AC-DATA1 Alpha 102 200 100

#0029 Dataset: ACCOUNT (2) Format level 0 RecSz 42

#0030 Set: ACCOUNTSET

Key: BANK-ID

BRANCH-ID

AC-NUMBER

#0031 Set: AC-BYNBR Duplicates Key change OK

Key: AC-NUMBER

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 AC-TYPE Rec Type 0 1 4

2 AC-RELATED Group 2 24 0

3 AC-NEXT Number 2 12 12

4 AC-PRIOR Number 14 12 12

5*BANK-ID Number 26 4 4

6*BRANCH-ID Number 30 4 4

7*AC-NUMBER Number 34 12 12

8 CUST-ID Number 46 8 8

9 AC-BALANCE Number 54 12 11 2 S

10 AC-HLD-AMT Number 66 12 11 2 S

11 AC-DT-OPEN Number 78 6 6

12 AC-DT-CLSE Number 84 6 6

13 TS Float 90 12 0 S

16 AC-VF2-GROUP Group 102 400 0

17 AC-DATA2 Alpha 102 400 200

#0029 Dataset: ACCOUNT (3) Format level 0 RecSz 59

#0030 Set: ACCOUNTSET\

Key: BANK-ID

BRANCH-ID

AC-NUMBER

#0031 Set: AC-BYNBR Duplicates Key change OK

Key: AC-NUMBER

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 AC-TYPE Rec Type 0 1 4

2 AC-RELATED Group 2 24 0

3 AC-NEXT Number 2 12 12

4 AC-PRIOR Number 14 12 12

5*BANK-ID Number 26 4 4

6*BRANCH-ID Number 30 4 4

7*AC-NUMBER Number 34 12 12

8 CUST-ID Number 46 8 8

9 AC-BALANCE Number 54 12 11 2 S

10 AC-HLD-AMT Number 66 12 11 2 S

11 AC-DT-OPEN Number 78 6 6

12 AC-DT-CLSE Number 84 6 6

13 TS Float 90 12 0 S

18 AC-VF3-GROUP Group 102 600 0

19 AC-DATA3 Alpha 102 600 300

#0029 Dataset: ACCOUNT (4) Format level 0 RecSz 11

#0030 Set: ACCOUNTSET

Key: BANK-ID

BRANCH-ID

AC-NUMBER

#0031 Set: AC-BYNBR Duplicates Key change OK

Key: AC-NUMBER

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 AC-TYPE Rec Type 0 1 4

2 AC-RELATED Group 2 24 0

3 AC-NEXT Number 2 12 12

4 AC-PRIOR Number 14 12 12

5*BANK-ID Number 26 4 4

6*BRANCH-ID Number 30 4 4

7*AC-NUMBER Number 34 12 12

8 CUST-ID Number 46 8 8

9 AC-BALANCE Number 54 12 11 2 S

10 AC-HLD-AMT Number 66 12 11 2 S

11 AC-DT-OPEN Number 78 6 6

12 AC-DT-CLSE Number 84 6 6

13 TS Float 90 12 0 S

20 AC-SAME-VF-GROUP Group 102 8 0

21 AC-DATA4 Number 102 4 4

22 AC-DATA5 Alpha 106 4 2

23 AC-VF4-GROUP Group 110 12 0

24 AC-VF4-ITEM Float 110 12 0 S

#0029 Dataset: ACCOUNT (5) Format level 0 RecSz 11

#0030 Set: ACCOUNTSET

Key: BANK-ID

BRANCH-ID

AC-NUMBER

#0031 Set: AC-BYNBR Duplicates Key change OK

Key: AC-NUMBER

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 AC-TYPE Rec Type 0 1 4

2 AC-RELATED Group 2 24 0

3 AC-NEXT Number 2 12 12

4 AC-PRIOR Number 14 12 12

5*BANK-ID Number 26 4 4

6*BRANCH-ID Number 30 4 4

7*AC-NUMBER Number 34 12 1

8 CUST-ID Number 46 8 8

9 AC-BALANCE Number 54 12 11 2 S

10 AC-HLD-AMT Number 66 12 11 2 S

11 AC-DT-OPEN Number 78 6 6

12 AC-DT-CLSE Number 84 6 6

13 TS Float 90 12 0 S

25 AC-SAME-VF-GROUP Group 102 8 0

26 AC-DATA4 Number 102 4 4

27 AC-DATA5 Alpha 106 4 2

28 AC-VF5-GROUP Group 110 18 0

29 AC-VF5-ITEM Alpha 110 18 9

#0032 Dataset: R-ACCT Format level 0 RecSz 5

Remap of ACCOUNT

#0030 Set: ACCOUNTSET

Key: BANK-ID

BRANCH-ID

AC-NBR

#0031 Set: AC-BYNBR Duplicates Key change OK

Key: AC-NBR

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 AC-TYPE Rec Type 0 1 4

2 BANK-ID Number 2 4 4

3 BRANCH-ID Number 6 4 4

4 AC-NBR Number 10 12 12

5 CUST-ID Number 22 8 8

6 AC-DT-OPEN Number 30 6 6

7 AC-DT-CLSE Number 36 6 6

8 TS Float 42 12 0 S

#0032 Dataset: R-ACCT (3) Format level 0 RecSz 55

Remap of ACCOUNT

#0030 Set: ACCOUNTSET

Key: BANK-ID

BRANCH-ID

AC-NBR

#0031 Set: AC-BYNBR Duplicates Key change OK

Key: AC-NBR

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 AC-TYPE Rec Type 0 1 4

2 BANK-ID Number 2 4 4

3 BRANCH-ID Number 6 4 4

4 AC-NBR Number 10 12 12

5 CUST-ID Number 22 8 8

6 AC-DT-OPEN Number 30 6 6

7 AC-DT-CLSE Number 36 6 6

8 TS Float 42 12 0 S

9 AC-VF3-GROUP Group 54 600 0

10 AC-DATA3 Alpha 54 600 300

#0033 Dataset: FUNNY-STUFF Format level 0 RecSz 9

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 FS-GROUP Group 0 102 0

2 FS-FLAGS Field 0 1 3

3 FS-1 Boolean 0 1 0 2

4 FS-2 Boolean 0 1 0 1

5 FS-3 Boolean 0 1 0

6 FS-KANJI Kanji 2 48 12

7 FS-NAME Alpha 50 40 20

8 TS Float 90 12 0 S

#0034 Dataset: R-FS Format level 0 RecSz 9

Remap of FUNNY-STUFF

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 FS-GROUP Group 0 102 0

2 FS-FLAGS Field 0 1 3

3 FS-1 Boolean 0 1 0 2

4 FS-2 Boolean 0 1 0 1

5 FS-3 Boolean 0 1 0

6 FS-KANJI Kanji 2 48 12

7 FS-NAME Alpha 50 40 20

8 TS Float 90 12 0 S

#0035 Dataset: HISTORY Format level 0 RecSz 8

#0036 Set: HISTORYSET

Key: BANK-ID

AC-NUMBER

TRAN-DATE Descending

TRAN-TIME Descending

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1*BANK-ID Number 0 4 4

2*AC-NUMBER Number 4 12 12

3*TRAN-DATE Number 16 6 6

4*TRAN-TIME Number 22 6 6

5 PROC-DATE Number 28 6 6

6 TRAN-TYPE Number 34 2 2

7 TRAN-AMT Number 36 12 11 2 S

8 BRANCH-ID Number 48 4 4

9 TL-ID Number 52 9 9

10 CUST-NAME Alpha 62 20 10

11 TS Float 82 12 0 S

#0037 Dataset: TRIALBALANCES Format level 0 RecSz 1334

#0038 Set: TB-SET

Key: BANK-ID

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1*BANK-ID Number 0 4 4

2 MONTH Group 4 1332 0 12 1

3 STARTING-BAL Number + 0 11 10 2 S 1

4 DAY-INFO Group + 12 1308 0 1

5 DOW Number + 12 1 1 1

6 MDAY Group + 14 42 0 31 2

7 TRANS Number + 0 6 6 2

8 DEBITS Binary + 6 12 11 2 S 2

9 CREDITS Binary + 18 12 11 2 S 2

10 EOD Binary + 30 12 11 2 S 2

11 ALL-DAYS Number + 1316 4 4 1

12 ENDING-BAL Number + 1320 11 10 2 S 1

13 TS Float 15988 12 0 S

#0039 Dataset: ADDRESSES Format level 0 RecSz 19

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 ADDR-ID Number 0 8 8

2 ADDR-LINE Alpha 8 60 30 3 1

3 ADDR-COUNTRY Alpha 188 18 9

4 TS Float 206 12 0 S

#0040 Dataset: DIS-ORDERED Format level 0 RecSz 4

#0043 Set: DO-ACCESS

Key: DO-KEY

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 DS-NAME Alpha 0 22 11

2*DO-KEY Number 22 6 6

5 TS Float 28 12 0 S

#0044 Dataset: L1 Format level 0 RecSz 7

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 DS-NAME Alpha 0 4 2

2*L1-ITEM Number 4 6 6

4 TS Float 10 12 0 S

#0045 Dataset: L2 Format level 0 RecSz 3

#0044 Parent: L1

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 LS-NAME Alpha 0 4 2

2 L2-ITEM Alpha 4 20 10

3 L2-NEW-NUM Number 24 4 4

#0046 Dataset: L3 Format level 0 RecSz 4

#0045 Parent: L2

#0047 Set: L3-ACCESS

Key: L3-ITEM

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 L3-NAME Alpha 0 4 2

2*L3-ITEM Alpha 4 40 20

#0048 Dataset: R-L2 Format level 0 RecSz 2

Remap of L2

#0044 Parent: L1

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 L2-ITEM Alpha 0 20 10

#0052 Dataset: L1-WITH-EMB Format level 0 RecSz 1

Remap of L1

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 DS-NAME Alpha 0 4 2

#0053 Dataset: L1-NO-EMBEDDED Format level 0 RecSz 1

Remap of L1

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 DS-NAME Alpha 0 4 2

2 L1-ITEM Number 4 6 6

#0054 Dataset: SHORT-VF Format level 0 RecSz 1

#0055 Set: SHORT-VF-SET Duplicates Key change OK

Key: SVF-KEY

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 SVF-TYPE Rec Type 0 2 8

2*SVF-KEY Alpha 2 6 3

#0054 Dataset: SHORT-VF (2) Format level 0 RecSz 3

#0055 Set: SHORT-VF-SET Duplicates Key change OK

Key: SVF-KEY

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 SVF-TYPE Rec Type 0 2 8

2*SVF-KEY Alpha 2 6 3

3 SVF-2 Alpha 8 20 10

#0054 Dataset: SHORT-VF (5) Format level 0 RecSz 2

#0055 Set: SHORT-VF-SET Duplicates Key change OK

Key: SVF-KEY

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 SVF-TYPE Rec Type 0 2 8

2*SVF-KEY Alpha 2 6 3

4 SVF-5 Alpha 8 10 5

#0056 Dataset: MERGED Format level 0 RecSz 2

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 M-TYPE Rec Type 0 2 8

2*M-TIMESTAMP Float 2 12 0 S

#0056 Dataset: MERGED (1) Format level 0 RecSz 8

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 M-TYPE Rec Type 0 2 8

2*M-TIMESTAMP Float 2 12 0 S

3 HIST-BANK-ID Number 14 4 4

4 AC-NUMBER Number 18 12 12

5 TRAN-DATE Number 30 6 6

6 TRAN-TIME Number 36 6 6

7 PROC-DATE Number 42 6 6

8 TRAN-TYPE Number 48 2 2

9 TRAN-AMT Number 50 12 11 2 S

10 BRANCH-ID Number 62 4 4

11 TL-ID Number 66 9 9

12 HIST-CUST-NAME Alpha 76 20 10

#0056 Dataset: MERGED (2) Format level 0 RecSz 51

Num Name Type Offset Size DecSz Decs Sign Occurs Subs

1 M-TYPE Rec Type 0 2 8

2*M-TIMESTAMP Float 2 12 0 S

13 CUST-ID Number 14 8 8

14 CUST-BANK-ID Number 22 4 4

15 CUST-SSN Number 26 9 9

16 CUST-NAME Alpha 36 60 30

17 CUST-LINES Number 96 1 1

18 CUST-ADDR Alpha 98 60 30 5 1

19 CUST-DOB Number 398 8 8

20 CUST-INFO Alpha 406 200 100