[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] Read Flat file



Hi,

   I have a requirement where i have to read a flat file in SQR. The flat 
file has heading and then the data. earlier i wrote some sqr's where i read 
the data without heading like the following:-
but now i want to process the data without heading. Any ideas?

let $file = {FILEPREFIX}emplben.txt
OPEN $file  AS 10
FOR-READING
RECORD=301:VARY
STATUS = #OPEN1

IF #OPEN1 =-1
   SHOW 'ERROR OPENING INPUT FILE:'
   let #prcs_run_status = #prcs_run_status_unsuccessful
   let $prcs_message_parm1 = 'Unsuccessful Completion'
   do Update-Prcs-Run-Status

   STOP
END-IF


For example:-

SSNO                  Name
4453333333       Paul
3443434343       kim

Here i just want to process the data.

Thanks.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users