RE: Re:[sqr-users] Qpen command record-length problem

["Paul hoyte" <pi_hoyte@si-proservices.com>]

This can be done simply by declaring the file as a variable length file with
say a max of 1000 characters (pick any length you want that will not be ever
exceeded), then open the file and read it into a $variable.  Then parse the
$variable to extract the data from $variable into other specific $variables
if needed.

Paul Hoyte
pa_hoyte@si-proservices.com
(248) 752-6970

-----Original Message-----
From: sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org
[mailto:sqr-users-bounces+pi_hoyte=si-proservices.com@sqrug.org] On Behalf
Of Jones.Steven@ups.com
Sent: Wednesday, July 01, 2009 6:50 PM
To: sqr-users@sqrug.org
Subject: RE: Re:[sqr-users] Qpen command record-length problem

I'm not very familiar with Ask, however the user has no idea of the value to
put in the ASK.  The value is added up from the db column widths the user
selects during the run, so the SQR obtains the value at run-time prior to
the open.  Can that be somehow put in as if it came from an ASK?
-Steve

-----Original Message-----
From: sqr-users-bounces+jones.steven=ups.com@sqrug.org
[mailto:sqr-users-bounces+jones.steven=ups.com@sqrug.org] On Behalf Of
franck.masson
Sent: Wednesday, July 01, 2009 3:16 PM
To: This list is for discussion about the SQR database reporting language
from Hyperion Solutions.
Subject: RE: Re:[sqr-users] Qpen command record-length problem

Have you try the Ask command as proposed in the previous email ? 



> Message du 02/07/09 00:12
> De : Jones.Steven@ups.com
> A : sqr-users@sqrug.org
> Copie à : 
> Objet : RE: Re:[sqr-users] Qpen command record-length problem
>
> 
> The sqr version I am using is 6.2. I saw that syntax in the manual for 8.5
but haven't been able to test it. Anyone know how to do it in 6.2?
> -Steve
> 
> -----Original Message-----
> From: sqr-users-bounces+jones.steven=ups.com@sqrug.org 
> [mailto:sqr-users-bounces+jones.steven=ups.com@sqrug.org] On Behalf Of 
> franck.masson
> Sent: Wednesday, July 01, 2009 2:39 PM
> To: This list is for discussion about the SQR database reporting language
from Hyperion Solutions.
> Subject: Re:[sqr-users] Qpen command record-length problem
> 
> According to the documentation :
> OPEN {filename_lit|_var|_col} AS
> {filenum_num_lit|_var|_col}
> {FOR-READING|FOR-WRITING|FOR-APPEND}
> {RECORD=length_num_lit|_var|_col[:FIXED|:FIXED_NOLF|:VARY:BINARY]}]
> [STATUS=num_var]]
> [ENCODING={_var|_col|ASCII|ANSI|SJIS|JEUC|EBCDIC| 
> EBCDIK290|EBCDIK1027|
> UCS-2|UTF-8|others... }]
> 
> you can use a variable to specify the RECORD value
> 
> franck,
> 
> 
> 
> 
> > Message du 01/07/09 23:09
> > De : Jones.Steven@ups.com
> > A : sqr-users@sqrug.org
> > Copie à : 
> > Objet : [sqr-users] Qpen command record-length problem
> >
> > 
> > I need to open a window-compatible .txt file for writing where all
records are the same length, but that length is not known until run time.
The syntax appears to expect an integer literal value for the length. What
is needed is something like either using an integer variable for the length
or dynamically building the open command and then execute it.
> > Can anyone help?
> > -Steve Jones
> > UPS
> > 
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> > 
> > 
> 
> Créez votre adresse électronique prenom.nom@laposte.net
> 1 Go d'espace de stockage, anti-spam et anti-virus intégrés.
> 
> _______________________________________________
> 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
> 
> 

 Créez votre adresse électronique prenom.nom@laposte.net
 1 Go d'espace de stockage, anti-spam et anti-virus intégrés.

_______________________________________________
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