[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Problems in writing into a fixed length file.
- Subject: RE: [sqr-users] Problems in writing into a fixed length file.
- From: "Knapp, Richard" <KnappR@umsystem.edu>
- Date: Wed, 2 May 2007 09:00:10 -0500
- Delivery-date: Wed, 02 May 2007 10:04:41 -0400
- In-reply-to: <BAY138-F331803C61F3549AE4BA6BEAF420@phx.gbl>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- References: <BAY138-F331803C61F3549AE4BA6BEAF420@phx.gbl>
- Thread-index: AceMwateCRM8f84fSfyoqrz76ujc9gAAE2lA
- Thread-topic: [sqr-users] Problems in writing into a fixed length file.
Choudary,
There is a concept in data processing called padding. Use a variable of
spaces to make up the difference in your line length.
Richard Knapp
EAS - Data Warehouse Group
University of Missouri
615 Locust Street #200
Columbia, MO 65201
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
sri kanth
Sent: Wednesday, May 02, 2007 8:53 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Problems in writing into a fixed length file.
Iam facing problem in writing variables into fixed length file with line
terminator. I am able to write fixed length file without line
terminators
but not with line terminators...!!
I am using below code for the same..
open 'test.txt' as 10 for-writing record=100:fixed
write 10 from $var1:20 $var2:15
Then it is writing only 35 length record but not 100..!!
Am I going wrong somewhere..?!
Quick response would be highly appreciated.
Thanks in advance.
-Choudary
_________________________________________________________________
Tried the new MSN Messenger? It's cool! Download now.
http://messenger.msn.com/Download/Default.aspx?mkt=en-in
_______________________________________________
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