|
Based on the error code, it looks like you're missing
a clause on the create procedure statement. I've
attached the options below you can use. I suspect the
last one listed is the one you want (modifies SQL
data). If that gives an error, try the first
(contains SQL). I've done calls to host programs
running SQL returning result sets but not calling
strqmqry...
*******************************************
CONTAINS SQL, READS SQL DATA, MODIFIES SQL DATA, or
NO SQL
Specifies which SQL statements, if any, may be
executed in the procedure or any routine called from
this procedure. See Appendix C, Characteristics of SQL
Statements for a detailed list of the SQL statements
that can be executed under each data access
indication.
CONTAINS SQL
Specifies that SQL statements that neither read nor
modify SQL data can be executed by the procedure.
NO SQL
Specifies that the procedure cannot execute any SQL
statements.
READS SQL DATA
Specifies that SQL statements that do not modify SQL
data can be included in the procedure.
MODIFIES SQL DATA
Specifies that the procedure can execute any SQL
statement except statements that are not supported in
procedures.
==================================
MORE INFORMATION ON THIS TOPIC
==================================
Ask your Web development questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: tips, tutorials and more.
|
