View previous topic :: View next topic
|
Author |
Message |
srinivasulu.p
New User
Joined: 10 Jul 2012 Posts: 22 Location: india
|
|
|
|
Code: |
The complete record is like this , i am new to easytrtrive. i need to comapre SAA record and WHD records below in it till it reaches to next SAA.if it matches we need to write matched record to outfile, non matching records to another file.
FBSI-BRCH-C FBSI-BASE-C FBSI-ACC-TY-C ENTR-D WH-TYPE SEQ-N CUSP-NBR
3/AN 6/AN 1/AN 10/AN 3/AN 2/BI 9/AN
(1-3) (4-9) (10-10) (11-20) (21-23) (24-25) (26-34)
1---------- 2---------- 3------------ 4--------- 5------- 6------- 7--------
AEL 367028 1 2013-04-02 WHD 0 543487144
AEL 367028 1 2013-04-15 SAA 0 316390327
AEL 367028 1 2013-04-15 WHD 0 316390327
AEL 367028 1 2013-04-15 WHD 1 316390327
AEL 367028 1 2013-04-30 WHD 0 922021407
AEL 367028 1 2013-04-30 WHD 1 68380T103
AEL 367028 1 2013-04-30 WHI 0 FDIC66606
AEL 367028 1 2013-05-01 WHD 0 552986309
AEL 367028 1 2013-05-02 WHD 0 543487144
AEL 367028 1 2013-05-31 WHD 0 922021407
AEL 367028 1 2013-05-31 WHD 1 68380T103
AEL 367028 1 2013-05-31 WHI 0 FDIC66606
AEL 367028 1 2013-06-03 SAA 0 552986309
AEL 367028 1 2013-06-03 WHD 0 552986309
KEY-C ENTR-C BKPG-AMT WH-AMT WH-CTRY RVS-I
2/AN 3/AN 6/PS 6/PS 3/AN 1/AN
(35-36) (37-39) (40-45) (46-51) (52-54) (55-55)
8------- 9------- 10----------- 11----------- 12------ 13-----
39 DIV -65.94 18.46 000 O
56 LTG -4.55 0.32 000 O
39 DIV -8.56 2.40 000 O
56 LTG -4.55 1.27 000 O
39 DIV -57.30 16.04 000 O
39 DIV -64.31 18.01 000 O
32 INT -0.16 0.04 000 O
39 DIV -36.33 10.17 000 O
39 DIV -64.07 17.94 000 O
39 DIV -53.80 15.06 000 O
39 DIV -65.34 18.30 000 O
32 INT -0.17 0.05 000 O
56 LTG -5.47 0.38 000 O
39 DIV -36.33 10.17 000 O
56 LTG -5.47 1.53 000 O
39 DIV -67.96 19.03 000 O
39 DIV -178.24 49.91 000 O
IRA-I WH-RT CRTE-D ST-C FTPS-OFST-C OVRD-WH-RTE
1/AN 3/PS 10/AN 2/AN 2/AN 3/PS
(102-102) (103-105) (106-115) (116-117) (118-119) (120-122)
19------- 20------- 21-------- 22------- 23--------- 24---------
N 28.00 2013-04-03 0
N 7.00 2013-04-15 CA 0
N 28.00 2013-04-15 0
N 28.00 2013-04-15 0
N 28.00 2013-05-01 0
N 28.00 2013-05-01 0
N 28.00 2013-04-30 0
N 28.00 2013-05-01 0
N 28.00 2013-05-03 0
N 28.00 2013-06-03 0
N 28.00 2013-06-03 0
N 28.00 2013-05-31 0
N 7.00 2013-06-03 CA 0
N 28.00 2013-06-03 0
N 28.00 2013-06-03 0
N 28.00 2013-06-05 0
N 28.00 2013-06-17 0
|
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You need to explain the "rules" for processing and the desired output. Mention the dsorg and lrecl.
I do not understand what is meant by "matches".
Once the problem definition is clear, we can go on with what to do with Easytrieve. With what has been provided, i would jnot knkow what to do in any language. |
|
Back to top |
|
|
|