I try to load data of a client file into a local temporary table. I try to put all my procedure/function code if possible in an ATOMIC Block. The sample below works without the ATOMIC
The File is only for testing
ASA Version is 11.0.1.2506 The Documentation http://dcx.sybase.com/index.html#1101en/dbreference_en11/load-table-statement.html*d5e42427 states that under Remarks that
I get an ERROR that no commit/rollback is allowed inside a atomic statement. SQLCODE -267 Any ideas ? Documentation flaw ? asked 16 Nov '10, 16:05 Thomas Dueme... |
This is a documentation error. LOAD TABLE causes a commit when loading into a temporary table as of the fix for QTS 454858. I will inform the doc team. answered 16 Nov '10, 16:47 Bruce Hay Volker Barth @Bruce: I had suspected an interference with a CHECKPOINT as done by LOAD TABLE. Is a CHECKPOINT valid inside an ATOMIC block? (According to the docs, it seems so - at least I haven't found a contrary statement.) 1
I don't think there is a restriction against checkpoints within atomic blocks; however, statements such as LOAD TABLE and ALTER TABLE that cause checkpoints as side effects also cause commits. |