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

[James Womeldorf <jwomeldo@fastenal.com>]

Good thought Larry.  I've run across data with embedded carriage returns in
it, and if the CR had been the last item in the last field printed this is
the exact result I would have gotten.

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
Larry Roux
Sent: Monday, November 08, 2004 6:10 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Flat file having NULL Lines.....


Could the source data have some embedded control characters in the data?
 




Larry Roux
Syracuse University
lroux@syr.edu

>>> nik2cool@rediffmail.com 11/08/04 6:14 AM >>>
  
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


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

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