RE: Going Nuts

["Carlos Kozuszko" <tidesarrollo@xxxxxxxxxxxxxxxxxxxxxx>]

Bob C. said:
>
> SQL can only refer to GLOBAL variables. So if it is used in a
> procedure is may not work or compile.
>
> -Bob
>

Bob, i keep hearing that everywhere, but i have never ran into problems by
using local variables, even parameters, as host variables on my embedded SQL
sentences.

Here's an example that compiles fine:

<snippet>

p SQLDomCod       B                   EXPORT
d SQLDomCod       PI             1a
d   pTipos                       5a   varying
d   pPref                        3p 0
d   pCliNum                      9p 0
d   pResult                           like(SQLDomCod)
d   pInd1                        5i 0
d   pInd2                        5i 0
d   pInd3                        5i 0
d   pResultInd                   5i 0
d   pSQLSTATE                    5a
d   pFuncName                  139A   VARYING
d   pSpecName                  128A   VARYING
d   pMsgTxt                     70A   VARYING

....

c/exec sql
c+ SELECT A3CODD INTO :pResult
c+   FROM A3DOM3
c+  WHERE A3PCLI = :pPref AND A3NCLI = :pCliNum
c+    AND A3CORR = '1'
c/end-exec

...

p SQLDomCod       E

</snippet>

Carlos K.