call stored procedure db2 problem

  • Thread starter Thread starter Hugo Gonzo
  • Start date Start date
H

Hugo Gonzo

Hi all,

i have a problem execute a sql-script on DB2 database from a dotnet c#
program. The sql-script terminates after a CALL statement. The
following code should ilustrate this.

the sql-script:


OleDbConnection con = new OleDbConnection("Provider=IBMDADB2; User
ID=User1; Password=user1; Data Source=MyDB; Timeout=3600");
con.Open();

// the simple sql-script
string script = "SELECT * FROM Table1; CALL TestProc; SELECT * FROM
Table2;"

OleDbCommand cmd = new OleDbCommand(script, con);
OleDbDataAdapter adapt = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
int k = ds.Tables.Count;

// here the DataSet contains one Table, if I remove the CALL TestProc;
from the sql-script i get two Tables


The script comes to the call TestProc (which is called correctly) and
then exit without an error. The script execute correctly.

my enviroment:
DB2 Database 8.1.2
..Net 2003

Another question is:
How can i change the statement termination character from OleDB ?

any solutions

Hugo
 
Hugo,

I don't have that much experience with DB2, but is there a statement
termination character in the stored procedure, and if so, what is it?
 
Back
Top