Re: Losing an assigned variable

[Bill Beckner <Bbeckner@ICC.CC.IL.US>]

You need to add an underscore to the variable name used in your select's
where clause.  It looks like you assign a value to $_wrkordr, but your where
clause is using $wrkordr.


Hope this helps!!!
--
William Beckner -- Stunt Programmer (Just call me "Bill")
Illinois Central College, Rm L141 -- East Peoria, IL  61635-0001
PH: (309) 694-8419 -- FAX: (309) 694-8995
"I don't need any of that SQL stuff -- I just want a database!"

 -----Original Message-----
From:   Lynn Gibson [mailto:lxgibson@SRPNET.COM]
Sent:   Thursday, September 13, 2001 5:12 PM
To:     SQR-USERS@list.iex.net
Subject:        Losing an assigned variable

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