View previous topic :: View next topic
|
Author |
Message |
sumany
New User
Joined: 26 Feb 2009 Posts: 1 Location: Bangalore
|
|
|
|
Hi All,
Please help in which is better for my query -selcopy or sort utility
Prob is i have some data with some thing like (flat file)
2 111111111110 3-01-09 3-31-09001000P0020209821707641852200013W37941852
2 111111111130 04/16/2006 33,507 310
Code: |
2 111111111110 3-01-09 3-31-09001000P0020209821707641852200013W37941852
2 111111111130 04/16/2006 33,507 310 |
i want to do a select for all the things related to record type 10(mentioned in blue) and also '9'(mentioned in red)
My objective is by seeing the above conditions it must read all occurances of that number 1111111111 into output file.
If possible please provide the code.
Looking for your guidance.
Thanks |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
i want to do a select for all the things related to record type 10(mentioned in blue) and also '9'(mentioned in red) |
Hi sumany,
Welcome to the forums.
But I dont see anything mentioned in RED above. Have I become color blind?
Quote: |
it must read all occurances of that number 1111111111 into output file |
Neither your sample data nor your explanation seems to be sufficient to make your requirement clear to others. Please post some 5-10 records of input and make sure you cover all the possible scenarios. Also mention the input/output RECFM/LRECL etc. |
|
Back to top |
|
|
Nick Jones
New User
Joined: 28 Apr 2009 Posts: 13 Location: UK
|
|
|
|
Sumany,
As Arun said, we need a little more information about the input and output records. Some more samples of both please (include positions of important fields within the records).
This looks like it would be a relatively simple SELCOPY task. I will post some code pending your spec and sample data. |
|
Back to top |
|
|
|