View previous topic :: View next topic
|
Author |
Message |
brahmanandarm
New User
Joined: 15 Jun 2009 Posts: 28 Location: bangalore
|
|
|
|
Hi All,
I have a requirement.
I have a an FB file of lenght 80 with followign records
EREWJ505 --------- STRING(S) FOUND ----------------
QEWQJ506 --------- STRING(S) FOUND ----------------
GEREJ098 --------- STRING(S) FOUND ----------------
114 DISCARD FROM TABLE QBCE.DKALALAL
QWEWJ099 --------- STRING(S) FOUND ----------------
118 DISCARD FROM TABLE AERE.TDFASDSA
228 DISCARD FROM TABLE AERE.TREEQWER
QEEQJ03M --------- STRING(S) FOUND ----------------
113 ASSE.DAEREA6 A
EQELJAA0 --------- STRING(S) FOUND ----------------
EEREJAA9 --------- STRING(S) FOUND ----------------
QWELJADA --------- STRING(S) FOUND ----------------
136 -TERM UTIL(FDAEE1.AERWQWEA)
I would need the output as
GEREJ098 --------- STRING(S) FOUND ----------------
114 DISCARD FROM TABLE QBCE.DKALALAL
QWEWJ099 --------- STRING(S) FOUND ----------------
118 DISCARD FROM TABLE AERE.TDFASDSA
228 DISCARD FROM TABLE AERE.TREEQWER
QEEQJ03M --------- STRING(S) FOUND ----------------
113 ASSE.DAEREA6 A
QWELJADA --------- STRING(S) FOUND ----------------
136 -TERM UTIL(FDAEE1.AERWQWEA)
i.e. i need to discard records where there
ABCDJ121 --------- STRING(S) FOUND ----------------
EFGHJ502 --------- STRING(S) FOUND ----------------
REWWJ503 --------- STRING(S) FOUND ----------------
REWWJ504 --------- STRING(S) FOUND ----------------
EREWJ505 --------- STRING(S) FOUND ----------------
QEWQJ506 --------- STRING(S) FOUND ----------------
EQELJAA0 --------- STRING(S) FOUND ----------------
EEREJAA9 --------- STRING(S) FOUND ---------------- |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
In addition to data examples, you need to post "the rules" for processing. . .
You also need to re-check the sample data. . . How can "ABCDJ121 --------- STRING(S) FOUND ---------------- " be "discarded" when it is not in the input file? |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
brahmanandarm,
It's not clear what you want to do. Please explain the "rules" for getting from input to output. Do you actually have two input files? Or just one?
Do you want to match records between the two files? Or do you want to remove records in the one file that have 'STRING(S) FOUND" not followed by another record, or what? We can't help you until you explain clearly what you're trying to do.
Also, what is the RECFM and LRECL of the input file(s). What is the starting position, length and format of each relevant field? |
|
Back to top |
|
|
|