Re: Create-Array/ Precompile question

[Peter Clark <PGCLARK@VAC-ACC.GC.CA>]

Glenn,

Just because the SQR was written by PeopleSoft doesn't mean it was WELL written 
:-)

Peter

>>> Glenn Jensen <glenn.jensen@DOIT.WISC.EDU> 2001/01/04 11:47:04 am >>>
Hi All!

I'm looking at a PeopleSoft SQR that uses, what I think to be, a
questionable approach to creating arrays;  they attempt to conditionally
create arrays based on user input.  Every book and document I've been able
to find on the subject specifically mentions that arrays are created during
a precompile stage - before user input ever occurs.  My own experience
confirms this.  Whether the create-array command is in a procedure that's
never called, or the create-array command sits within an unsatisfied
conditional statement in the body of the program the array is still
created...as expected.

Is this a leftover from previous versions of SQR?  I'm not an SQR expert, so
is there something I'm missing?  Ugh.

We're currently running:
SQR/4.3.4/PC/Windows NT 4.0/Oracle 7.3.4

A snippet of code from the body of the program looks like this:

  if $Update_Mode = 'Y'
     create-array name=xref_balance_changed size = 100000
                  field=Bus_unit:char='Unknow'
                  field=Emp_ID:char
                  field=Ext_org:char
                  field=Item_Nbr:char
                  field=Item_amt:number=0.00
                  field=Bal_Amt:number=0.00
                  field=Xref_amt:number=0.00
                  field=Line_sum:number=0.00
  end-if

when $update_mode = 'N' the array is still created, and moreover it's
created even before $update_mode is input.

Thanks!
Glenn