SQLRPG question

I'm trying to create a dynamic SQL statement for an intranet based lookup
application. The actual select portion is fixed, but the where and order by
portions are dynamic.

Fixed portion:
SELECT chg_cc as cc, stockno, desc, issueqty, uom, cost, date, value,
mtlreqn, number FROM mspivtfd WHERE type = ''5''

Varying portions (to be added to above, depending on conditions):
and date='':TEMPDATE''
and date between '':TEMPDATE'' and '':TEMPDATE2''
and cc='':INDEPT''
and stockno=''INSTOCKNO''
order by cc, date, stockno
order by cc, stockno

I am building the SQL statement in an RPG variable at run time. 

Some questions...
1) I assume I need to use SQLDA because the varying portions of my where
statements have different variables.
2) Do I use the host variable :VAR syntax, or the ? marker syntax in the sql
statement?

Thanks,
Loyd

--
Loyd Goodbar
Programmer/Analyst
BorgWarner Incorporated
Air/Fluid Systems, Water Valley, MS



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---