RE: [sqr-users] Writing values in separate lines

[Roger.Harris@certegy.com]

Ok, maybe I am overlooking something here, but what would be wrong with
just doing it like this:

begin-select
emplid
tax
grss

    write #fileNum from &emplid
    write #fileNum from &tax
    write #fileNum from &grss

from ps_test
end-select

Presto! Each value on a separate line and no encoding or stringing.


Roger L. Harris
Programmer Analyst Sr
Product Development
Certegy Check Services
Fidelity National Information Services, Inc
11601 N. Roosevelt Blvd
St Petersburg, FL 33716

(727) 227-5850 direct
(800) 215-6280 x75850 toll free
(727) 570-4917  Fax



|---------+---------------------------------------------------->
|         |           "Dwight Schrute"                         |
|         |           <schrute.dwight@hotmail.com>             |
|         |           Sent by:                                 |
|         |           sqr-users-bounces+roger.harris=certegy.co|
|         |           m@sqrug.org                              |
|         |                                                    |
|         |                                                    |
|         |           11/15/2006 11:19 AM                      |
|         |           Please respond to "This list is for      |
|         |           discussion about the SQR database        |
|         |           reporting language from Hyperion         |
|         |           Solutions."                              |
|---------+---------------------------------------------------->
  
>---------------------------------------------------------------------------------------------|
  |                                                                             
                |
  |       To:       sqr-users@sqrug.org                                         
                |
  |       cc:                                                                   
                |
  |       Subject:  RE: [sqr-users] Writing values in separate lines            
                |
  
>---------------------------------------------------------------------------------------------|




Instead of using the "let" commands, try using "string".  Building upon
Bob's response, it would be:

   string &emp &tax &gss by $crlf into $var_to_write_as_rows
   write 10 from $var_to_write_as_rows

This is more concise and doesn't require the extra variables.  In addition,

performance is increase since "let" is so slow.

AND CLARK, DON'T BE SUCH AN ASS!!


>From: "Bob Stone" <bstone@fastenal.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] Writing values in separate lines
>Date: Tue, 14 Nov 2006 17:10:12 -0600
>
>lol.  Suppose he wanted an actual response?
>
>Why not just pretend you're hitting the enter key between each variable?
>I prefer to do that with a $cr variable set to the ascii of
>'carraige-return' (note that if your file is Windows you probably need
>to append 'line-feed' which is ascii 10).
>
>
>  ENCODE <13> INTO $CR
>
>(or)
>
>  ENCODE <13> into $cr
>  ENCODE <10> into $lf
>  let $crlf = $cr || $lf
>
>
>begin-select
>emplid
>tax
>grss
>   let $emp = &emplid
>   let $tax = &tax
>   let $grss = &grss
>
>   let $var_to_write_as_rows = $emp || $cr || $tax || $cr || grss || $cr
>
>   write 10 from $var_to_write_as_rows
>from ps_test
>end-select
>
>
>
>-----Original Message-----
>From: sqr-users-bounces+bstone=fastenal.com@sqrug.org [mailto:sqr-users-
>
>Why yes, it is....
>
>peace,
>clark 'the dragon' willis
>
>----Original Message Follows----
>
>Hi,
>     Is it possible to write 4 column values as 4 separate rows to a text
>
>file in SQR? For eg. if i use
>            begin-select
>            emplid
>            tax
>            grss
>                        write-file
>                        !instead of writing 3 values as one row, i need to
write
>it as 3 different
>rows, some thing like this
>                        !emplid
>                        !tax
>                        !grss
>            from ps_test
>
>Thanks
>RK
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Get today's hot entertainment gossip
http://movies.msn.com/movies/hotgossip?icid=T002MSN03A07001


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





------------------------------------------------------------------------------
This message contains information from Certegy, Inc which may be confidential 
and privileged.  If you are not an intended recipient, please refrain from any 
disclosure, copying, distribution or use of this information and note that such 
actions are prohibited.  If you have received this transmission in error, 
please notify by e:mail postmaster@certegy.com.
==============================================================================


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