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
declare local temporary table tmpRSTDOMAIN
( RSTDOMAIN_KDNR integer null ) ON COMMIT PRESERVE ROWS;
load table tmpRSTDOMAIN( RSTDOMAIN_KDNR )
using client file 'c:\\loadTableTest.csv'
delimited by ';' defaults on;
select * from tmpRSTDOMAIN;
The File is only for testing
ASA Version is 220.127.116.116
The Documentation http://dcx.sybase.com/index.html#1101en/dbreference_en11/load-table-statement.html*d5e42427 states that under Remarks that
For base tables and global temporary
tables, a commit is performed. For local temporary tables, a commit is
Do not use the LOAD TABLE statement on
a temporary table for which ON COMMIT
DELETE ROWS was specified, either
explicitly or by default, at creation
time. However, you can use LOAD TABLE
if ON COMMIT PRESERVE ROWS or NOT
TRANSACTIONAL was specified.
I get an ERROR that no commit/rollback is allowed inside a atomic statement. SQLCODE -267
Any ideas ? Documentation flaw ?
16 Nov '10, 16:05