[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
- Subject: [sqr-users] Read Flat file
- From: "radhika reddy" <radhika_05@hotmail.com>
- Date: Mon, 13 Dec 2004 16:13:06 -0600
- Bcc:
- Delivery-date: Mon, 13 Dec 2004 17:19:39 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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