[sqr-users] Load-lookup problem - solved???

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

Thanks to all who replied to my problem with the load-lookup that suddenly 
would not compile, after running successfully for months.  I have now narrowed 
it down to what in the load-lookup is specifically causing the problem.  It is 
the Oracle substr() function.  Again, the following was my code:

!  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'')'

When I removed the substr() function and just returned the datacontrol field, 
this worked fine.  I was then able to use the SQR substr() function in a LET 
command to get the character I wanted.

However, now I am confused as to why the Oracle substr() function, which had 
been working fine, all of a sudden ceased to function (no pun intended!).  I 
confirmed that I was still able to use it successfully in a regular 
BEGIN-SELECT; it only is in the load-lookup that I am having this problem.  Any 
ideas?  At this point, it is really only curiosity, as I can now get the 
program to run successfully.

Thanks!

Denise M. White
Sr. Software Engineer
Vicor 

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