Re: [sqr-users] Problems in writing into a fixed length file.

["sri kanth" <gskchoudary@hotmail.com>]

nope Arun..I am done....thanks a lot for the response...

keep well
-choudary


>From: Arun Kumar <arunkumar13@yahoo.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reporting 
>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>Subject: Re: [sqr-users] Problems in writing into a fixed length file.
>Date: Thu, 3 May 2007 06:49:20 -0700 (PDT)
>
>then write command should be - "write 10 from $var1:20 $var2:80"  OR "write
>10 from $var1:20 $var2:15  ' ':65"
>
>Are you asking us which one of the above statement is correct or do you 
>still have any other questions?
>
>----- Original Message ----
>From: sri kanth <gskchoudary@hotmail.com>
>To: sqr-users@sqrug.org
>Sent: Thursday, May 3, 2007 12:27:06 AM
>Subject: RE: [sqr-users] Problems in writing into a fixed length file.
>
>many thanks for responding..
>In order to write into a fixed length file ,the sum of individual variable
>lengths specified in the 'write' statement must be equal to the one that 
>was
>specified in 'open' statement, it seems..
>I mean if record length is specified as 100 in open statement - "open
>'abc.txt' as 1 for writing record=100:fixed"
>
>then write command should be - "write 10 from $var1:20 $var2:80"  OR "write
>10 from $var1:20 $var2:15  ' ':65"
>
>correct me if I am wrong..!
>-choudary
>
> >From: "Alexander, Steven" <Steven.Alexander@sanjoseca.gov>
> >Reply-To: "This list is for discussion about the SQR database
> >reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> >To: "'This list is for discussion about the SQR database
> >reportinglanguagefrom Hyperion Solutions.'" <sqr-users@sqrug.org>
> >Subject: RE: [sqr-users] Problems in writing into a fixed length file.
> >Date: Wed, 2 May 2007 09:34:07 -0700
> >
> >The write statement will add 65 spaces at the end of the line if you say:
> >
> >write 10 from $var1:20 $var2:80
> >
> >However, if $var2 is starting with more than 15 characters and you want
> >only
> >the first 15 characters in the file, you'll have to say:
> >
> >let $var2 = substr($var2, 1, 15)
> >
> >before the write statement.
> >
> >-----Original Message-----
> >From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
> >[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On
> >Behalf Of Knapp, Richard
> >Sent: Wednesday, May 02, 2007 7:00 AM
> >To: This list is for discussion about the SQR database reportinglanguage
> >fromHyperion Solutions.
> >Subject: RE: [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
> >
> >_______________________________________________
> >sqr-users mailing list
> >sqr-users@sqrug.org
> >http://www.sqrug.org/mailman/listinfo/sqr-users
>
>_________________________________________________________________
>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
>
>
>
>
>
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Catch all the cricketing action right here. Live score, match reports, 
photos et al. http://content.msn.co.in/Sports/Cricket/Default.aspx


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