Re: Dumb SQL question

Jeff,
  From what I understand, it will not resolve the variable names.
   
  

Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx> wrote:
  Be gentle, cause this SQL stuff is all new to me.

If I define my SQL SELECT as a constant (not to scale so it doesn't wrap):

D FetchSQL C 'SELECT * FROM dbmstf/ordtlhst +
D WHERE onrcu IN (SELECT onrcu FROM +
D dbmstf/orhdrhst WHERE +
D shpdtiso >= DATE(:bgndate) +
D AND +
D shpdtiso <= DATE(:enddate)) +
D ORDER BY NAMEK10, DATEKISO, TIMEKISO'

Then, in the calcs (which are all procedureized and prototyped), I do:

MySQL = FetchSQL;

C/exec sql
C+ declare MyCursor cursor
C+ for mainStatement
C/end-exec

C/exec sql
C+ prepare mainStatement
C+ from :MySQL
C/end-exec

And then start fetching, will the contents of host variables 'bgndate' and
'enddate' automatically be put in the proper place? If not, why not. If
yes, then I'll figure out what I screwed up cause I get SQL error 26501.

Thanks.