DSXchange

Posted: **Wed Apr 05, 2006 12:38 pm**

Hi all,

Any idea why i am getting this error.

Initial_Extract,0: Warning: CopyOfJOB1.Initial_Extract: Sybase Server warning 2762 (severity 16): The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.

I am using sybase OCI stage to extract the data and written a big SQL using some temp table but at the end i am dropping these tables.I dont know y i am getting this error message.

Any help is appreciated
Thanks

Posted: **Wed Apr 05, 2006 12:57 pm**

Because a SQL statement is not the same as a DML statement. Only put SQL in the user-defined area. If you need to do DML, use before/after SQL with an anonymous block stored procedure, do your drops outside a transformation job, or switch to using a stored procedure.

DSXchange

SQL error

SQL error