DSXchange

Hi,
i am reading a sequential file in a job control(pipe delimited), having just 2 records. First record is header ( ValidFrom | ValidTo) & second is having some data values (like, 10 | 15).
I need to directly read the data record(10 | 15) and separate the field values and use them for further logic.
for now, i have just read the file in loop and after exiting from loop it gives me the desired result. but i feel there could be a way to directly read a particular record from seq file. i checked BASIC guide, but couldn't find any.
Any help on this would be appreciated.

Set First Line is Column Name to False.
The header record will get automatically rejected.

"Sequential" means just that - you must read past every byte in the file to get to the next. Your simplest solution is two ReadSeq statements - discard the results of the first and process the results of the second.

Chandra- we need to have a header as well, as per the requirements.
Ray - i got your point. But isn't that same as issuing READSEQ in loop ?

if you are insisting to use jobcontrol code , then READSEQ is the way you need to follow;
If you are ok with a job, then read header separately using and read remaining using in filter option in sequential file stage.

chandra.shekhar@tcs.com wrote:Set First Line is Column Name to False.
The header record will get automatically rejected.

True or False ?

Neither. This is a question about the programming language, not about job design.

My bad, I thought mdbatra does not want any header rows.

It's the same as using a loop, but why code the loop when you know that there are only two lines in the file?

Ray- yeah correct...plus i find that the processing which i needed, would be executed only once if i use 2 READSEQs, but in loop 2 times. Not much difference, but yes as u said, still better to reduce any processing if we can.
Thanks !

on a lighter note - ..as you said..., not "u" :D