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

[<Jones.Steven@ups.com>]

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