db2 - Multiple query with iDB2DataAdapter -

db2 - Multiple query with iDB2DataAdapter -

i trying run multiple statements in idb2dataadapter , not know separator utilize between sql query statements or if can run multiple statements sql server.

using scheme inavigator (sql server management studio db2) "run sql scripts" functionality (query analyzer), can run multiple query statements when separate them semicolon ";". not work idb2dataadapter.

if terminate first command ";", returns error:"sql0104 token ; not valid. valid tokens: ."

replacing ";" "end-of-statement" returns error:"sql0199 keyword end not expected. valid tokens: utilize skip wait fetch order union except optimize."

putting "begin" , "end' around statements did not help.

any suggestions appreciated. thanks, mike

db2 dataadapter