[sqr-users] Weird problem with load-lookup

["White, Denise" <DEWhite@vicr.com>]

Hi,

This makes no sense at all.  I have a program that has been running in 
production every weeknight since late October, and as of last Friday, it will 
no longer run.  I have managed to narrow the problem down to a load-lookup 
(when I remove the load-lookup, it runs successfully).  The job is run in 
PeopleSoft and retrieves data from ADP through a database link.

When the job is run from a PeopleSoft panel, it remains in Initiated status and 
never runs.  When I run it from SQRW, I get the icon for SQR in my task bar, 
but the DOS window never appears (it should appear with that message about 
hitting enter without entering anything that is standard for PSoft jobs and is 
generated by one of the copybooks).  Because of this, I am assuming that the 
job is failing to compile, and so never gets to the point where it starts to 
run.  I have made no modifications to the program recently.

I have confirmed that the database link to ADP works, and that I can do a 
regular begin-select of the same data using it and successfully display the 
data retrieved.  Does anyone have any idea why my load-lookup would suddenly 
fail to compile, when it has been doing so successfully for months?  Here is 
the code:

BEGIN-SETUP
#Include 'setup01a.sqc'
!  Load shift differentials from ADP database
   load-lookup
      name=shift_differential
      table=reports.v_employee@pay4win
      key=file#
      return_value=substr(datacontrol,4,1)
      rows=9999
      where='status in (''A'',''L'')'
END-SETUP

I guess I will have to give up and rewrite it using an array, since I find I 
can still select data with the database link, but I hate to admit defeat!

(SQR 4.3.2)

TIA!

Denise M. White
Sr. Software Engineer
Vicor 

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