RE: [sqr-users] Flat file having NULL Lines.....

["Manakotte, Krishnadas" <krishnadas.manakotteAU@logicacmg.com>]

Please ensure that your source is clean.

-----Original Message-----
From: nikhil sawant [mailto:nik2cool@rediffmail.com] 
Sent: Monday, 8 November 2004 10:14 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Flat file having NULL Lines.....

  
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

This e-mail and any attachment is for authorised use by the intended 
recipient(s) only. It may contain proprietary material, confidential 
information and/or be subject to legal privilege. It should not be copied, 
disclosed to, retained or used by, any other party. If you are not an intended 
recipient then please promptly delete this e-mail and any attachment and all 
copies and inform the sender. Thank you.

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