Re: AW: AW: dbproc + dynamic sql

Thanks for the help, it works now. The version of my Maxdb is 7.5.00.05 Thanks, Norbert "Anhaus, Thomas" <[EMAIL PROTECTED]> írta: > Norbert Felde wrote : > > > >I verified my proc using sqlstudio and executed the following > >2 queries: > >call data_uj( '0410', 1, 1, '1' ) > >select * from da

AW: AW: dbproc + dynamic sql

Norbert Felde wrote : > >I verified my proc using sqlstudio and executed the following >2 queries: >call data_uj( '0410', 1, 1, '1' ) >select * from data0410 > >The data0410 exists, I created it before. The attached trace was made >when I executed this two queries. > >Thanks, >Norbert > >"Anhaus,

Re: AW: dbproc + dynamic sql

I verified my proc using sqlstudio and executed the following 2 queries: call data_uj( '0410', 1, 1, '1' ) select * from data0410 The data0410 exists, I created it before. The attached trace was made when I executed this two queries. Thanks, Norbert "Anhaus, Thomas" <[EMAIL PROTECTED]> írta: >

AW: dbproc + dynamic sql

Norbert Felde wrote : >Hello, > >I wrote the dbproc as follows. I can create it and call it without any >error message, but it dous not insert any data into the table. >Could you >tell me what is wrong in the proc. > >thank you advance, >Norbert > >the proc: > >CREATE DBPROC DATA_UJ ( > I

dbproc + dynamic sql

Hello, I wrote the dbproc as follows. I can create it and call it without any error message, but it dous not insert any data into the table. Could you tell me what is wrong in the proc. thank you advance, Norbert the proc: CREATE DBPROC DATA_UJ ( IN TABLEIDX varchar(4),