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

[Dattatraya Shetty <datta_shetty@yahoo.com>]

Nikhil,
      How are you checking for the the Line to be blank? Also as per
Larry's suggestion, are you sure that the line it self does not have
special characters. 

   Try to query the Data just before the Random Blank line in oracle
and see the length of the total String. maybe that will help. 

HTH 
Datta. 
--- nikhil  sawant <nik2cool@rediffmail.com> wrote:

>   
> 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
> 



                
__________________________________ 
Do you Yahoo!? 
Check out the new Yahoo! Front Page. 
www.yahoo.com 
 


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