Re: Embedded sql and parameter markers

Cannot use parm markers for filename.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
3776 South High Street, Columbus, OH 43207
Phone: 614/492-7419 Fax: 614/409-2017
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"


rpg400-l-bounces@xxxxxxxxxxxx wrote on 08/01/2007 09:51:42 AM:

I am trying to write an sql program that receives a file name as a parm.
I am trying to do a dynamic sql statement with a Parameter marker for
the filename. I keep getting a '? Token not valid'.

Is it possible to use a parmameter marker for the filename. I haven't
been able to find anything online or in my sql books that tells me.

Here is my sql statements.

C Eval sel ='Select * from ? ' +
C ' where srcdta like(' + q +
C '%226%' + q + ')' +
C ' or srcdta like(' + q +
C '%550%' + q +') ' +
C ' or srcdta like(' + q +
C '%530%' + q + ') ' +
C ' or srcdta like(' + q +
C '%150%' + q + ') ' +
C ' or srcdta like(' + q +
C '%bytes transferred%' + q + ')
'
C/EXEC SQL
C+ PREPARE #SEL FROM :sel
C/END-EXEC
C/EXEC SQL
C+ Declare CTLCURS SCROLL Cursor For #SEL
C/END-EXEC
C/EXEC SQL
C+ Open Ctlcurs using :filename
C/END-EXEC


Thanks
Michael Smith


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.