Any idea about this?
> -----Original Message-----
> From: Bandaru, Jayaprakash
> Sent: Thursday, February 24, 2005 8:10 PM
> To: '[Email address protected]
> Subject: Sybase to DB2 Migration issue.
>
> Hi,
>
> Following is the Stored procedure definition which is called by C++
> application, which returns SQLCODE
>
> CREATE PROCEDURE t1
> LANGUAGE SQL
> BEGIN
> DECLARE SQLCODE INT;
>
> BEGIN
> DECLARE l_sqlcode INT;
>
> DECLARE CONTINUE HANDLER FOR SQLEXCEPTION,SQLWARNING,NOT FOUND
> SET l_sqlcode = SQLCODE;
> INSERT INTO SESSION.#m values (1);
> COMMIT;
>
> RETURN l_sqlcode;
>
> END;
>
> END!
>
> The Temporary table is created in C++ application on DB2 database
> after establishing the database connection
>
> csSQL = "DECLARE GLOBAL TEMPORARY TABLE SESSION.\"#m\" AS( id
> int)DEFINITION ONLY WITH REPLACE ON COMMIT PRESERVE ROWS NOT LOGGED";
> stat = myConnection.executeSql(csSQL);
> cout << "status of create table m"<<
> stat.status().message()<<endl;
>
> spProc = myDbase.storedProc("t1", myConnection);
> udResult = spProc.execute();
> vlRetValue = spProc.returnValue();
> if( vlRetValue.asInt() != 0 )
> {
> cout << "Store Procedure t1 returns Error #: "
> << vlRetValue.asString() <<
> spProc.status().message()<< endl;
> }
> else {
> cout << "Store Procedure t1 returns success." << endl;
> }
>
> When Stored procedure is called in the application the following
> message is displayed
>
> status of create table m
> Store Procedure t1 returns Error #: -727
>
> Please share any ideas on this issue.
>
> Thanks,
>
> Jayaprakash.
>
>

DB2 & UDB email list listserv db2-l LazyDBA home page