[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Flat file having NULL Lines.....
- Subject: [sqr-users] Flat file having NULL Lines.....
- From: "nikhil sawant" <nik2cool@rediffmail.com>
- Date: 8 Nov 2004 11:14:27 -0000
- Delivery-date: Mon, 08 Nov 2004 06:18:21 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi,
We are faced with a strange scenario in one of our SQRs..
The SQR essentially generates a flat file that has the data extract(rows) of a
PeopleSoft Table.
Simple.
However, when the extract is examined closely, it has random NULL lines/entries
(Blank lines with no chars or spaces..)
We write to the file only when there is row of data to be written. So it does
not explain these lines.(4 lines out of 30,000 written)
The OPEN, WRITE and extract data sizes are Fixed and equal.
If anyone has encountered this/similar situation, please advise..
We are at:
SQR Version: SQR/4.3.4/Sun/SunOS 5.5.1/Oracle 7.3.4/Jun 03 1999
TIA...
-Nikhil
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users