RE: [sqr-users] Use of Arrays

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

Arrays are great, but using them is more complicated than not using them, so
consider whether you really need them.  If you are checking the input from
files against database tables, you may want to use load-lookup on the
tables.  But do you need to keep each line of the file in memory after
you've checked it?  If not, don't put it in an array.

-----Original Message-----
From: Bartlett, Dwain [mailto:dbartlett@state.mt.us]
Sent: Tuesday, August 03, 2004 2:53 PM
To: 'This list is for discussion about the SQR database reporting
languagef rom Hyperion Solutions.'
Subject: RE: [sqr-users] Use of Arrays


Then I would use arrays.  Here is an example of how to build an array.

                        let #f = 0
                        while #f < #fund-max
                                get $array-fund from fund-totals(#f) fund
                                if $gls9002-fund = $array-fund
                                                array-add #gls9002-amt to
fund-totals(#f) amount
                                                break
                                        else
                                                if $array-fund = ' '
                                                                put
$gls9002-fund #gls9002-amt
                                                                into
fund-totals(#f) fund amount
                                                                break
                                                end-if
                                end-if
                                let #f = #f + 1
                        end-while

Dwain Bartlett
SABHRS Services Bureau, ITSD
HR Systems Analyst
(406) 444-0418
dbartlett@state.mt.us


-----Original Message-----
From: subrahmanyam Uppuganti [mailto:u_subbu_2004@yahoo.com]
Sent: Tuesday, August 03, 2004 3:37 PM
To: This list is for discussion about the SQR database reporting
language from Hyperion Solutions.
Subject: RE: [sqr-users] Use of Arrays


Yes, they are all of the same format with .dat extension...
subbu

"Bartlett, Dwain" <dbartlett@state.mt.us> wrote:
You need to clarify more. Are all of the input files the same format?

Dwain Bartlett
SABHRS Services Bureau, ITSD
HR Systems Analyst
(406) 444-0418
dbartlett@state.mt.us


-----Original Message-----
From: subrahmanyam Uppuganti [mailto:u_subbu_2004@yahoo.com]
Sent: Tuesday, August 03, 2004 2:54 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Use of Arrays


All,
Iam having some questions in using the Arrays,would greatly appreciate if
some one can clarify the same.I have 11(Eleven) Input files in an sqr and
needs to validate the values in the input files with that from the
Peoplesoft tables, Iam thinking of using temp tables as I used that before
but I need to create 11 temp tables, so is it wise to create 11 Arrays
instead? if some can some one tell me the syntax.
My program needs to read all the flat files,and needs to validate the values
with the data base tables...
Ur help is greatly appreciated...
Thanks
Subbu 


---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!

_______________________________________________
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

                
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!

_______________________________________________
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