PRSQL9103015: Referencing a Table Created in a Transaction

ID Number: Q70835

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9103015

SYMPTOMS

Referencing a table that was supposed to be created by a SELECT

INTO statement inside of a BEGIN...COMMIT transaction will GP-fault

SQL Server.

CAUSE

A SELECT INTO statement is not allowed within a user-defined

transaction.

RESOLUTION

Create the table outside of the user-defined transaction. If the

transaction fails, set the global variable @@error, and rollback

the transaction. Then, outside of the transaction, check for the

value of @@error, and drop the table if this value is set.