RE: [sqr-users] Size of flat file

[Gina Bencke <g.bencke@csuohio.edu>]

Thank you gentlemen for the humor.

Just in case one is actually looking for a technical answer, the size
specified on the open for-reading statement is the number of bytes or
characters returned with each read.  If I remember correctly, a read will
fail if the record length specified on the open is smaller than the record
you are reading.  If on the other hand the size of the record specified on
the read is smaller than the actual record size, SQR will simply truncate
the record and return the first n bytes or characters.

Cheers,

Gina Bencke
Business Analyst
Information Services & Technology
Cleveland State University
Phone: (216) 875-9630
Fax:    (216) 687-9200
 
 

-----Original Message-----
From: sqr-users-bounces+gina.work=bencke.com@sqrug.org
[mailto:sqr-users-bounces+gina.work=bencke.com@sqrug.org] On Behalf Of Larry
Roux
Sent: Friday, June 24, 2005 10:47 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Size of flat file

<GRIN>


Larry Roux
Syracuse University
lroux@syr.edu


>>> KnappR@umsystem.edu 06/24/05 10:41 AM >>>

99

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu 

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org 
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
radhika reddy
Sent: Friday, June 24, 2005 9:30 AM
To: sqr-users@sqrug.org 
Subject: [sqr-users] Size of flat file

Hi,

   I never thought that there would be difference in specifying the
flat

file size in first statement and second statement. But I see that the
size 
in first statement is 301 and in second it is 400. what is the
difference?


Statement 1:      OPEN $filename1  AS 10
                        FOR-READING
                        RECORD=301:VARY
                        STATUS = #OPEN1

Statement 1:     while 1 = 1
                        read 10 into $record:400

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 

_______________________________________________
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