Balaram

Hi,

What keys do you have for the file?

If its a Sequence number as the last key part, then just set that to '000100' and then set a $VAR to '999999' and do a SEL-RANGE($VAR) in Default Logic.....

Rob D.

i have 8 keys in that file , some of them are (5)date ,(6)terminal, (7)time and (8)seq .I want to select records based on time .Guess SEL-RANGE won't work here ,because i would have records which might be having a different key sets .. apart from the first one .I need to jump to that particlar record and process thereafter ...

Balaram,

If Deletes are a possibility, then you'll have to code specifically for that as well.

Depending on the scope of the project, you could look at moving the table to SQL and using replication as a solution. However, this would be a significant learning curve...

Regards,

Joseph

Thanks Rob and Joseph,

Joseph i am ready to try my hand out at moving the table to SQL ,But does it really work ??if it does then how should i go about writing the code .

P.S :i am working on Native PRO IV and not SL or VIP.

If the dummy file is set up as an external SEQ file with the correct Alternate name then you have already got a text file! (Not a Superlayer person so not sure on how exactly this is set on the Filedef).

Otherwise just write a Report function to dump the file (setting the $SPOOL option to File).

THANKS CHRIS , IT WORKED FINE . WISH YOU A HAPPY NEW YEAR

I would suggest you first of all make a LSCALL to list all the filenames (from the folder you save all the files) and save them into a temp file (by dir or ls depends on your O/S), you may also want to delete or move all the files after processing them.

Then you loop the temp file to read all the files from the folder and then proceed them one by one to generate the CSV file.

Does this make sense to you?

Could you please elaborate some more on this ,Could you go a bit deeper . Guess you are making sense but then i have no idea as to how should i proceed.

After i save filenames in a file , How do i loop the temp file to generate the CSV file , please suggest me in superlayer or Native PRO IV term.

Thanks a lot Vol Yip.
I really appreciate your suggestions.

forgot to add.. i develop in superlayer ..