Losing an assigned variable

[Lynn Gibson <lxgibson@SRPNET.COM>]

I am modifying an existing db2 sqr program. I need to connect to Oracle to
pull some Maximo info. Once the begin-select statement is made the assigned
variable that was set in DB2 is no longer set. This sqr needs to run in
Peoplesoft Purchasing. Does anyone have any helpful hints or suggestions to
resolve this issue?

   let $_wrkordr = &REQL.PROJECT_ID  - code where the variable is set

begin-procedure Get-MFP-System-Info - code where Oracle connection is made
begin-select -db'DSN=xxxmaxxxx;UID=xxxxxx;PWD=yyytest'

A.eqnum
B.description
C.pr
C.prlinenum
C.wonum

>From Workorder A, Equipment B, Wpmaterial C
 Where C.wonum = $wrkordr
 and A.eqnum = B.eqnum
 And A.wonum = C.wonum
 and C.directreq = 'Y'

Thanks,
Lynn Gibson