Does anyone have the experience of using sysproc.db2load stored procedure ? I don't seem to find any documentation of the procedure ...

BTW, I'm on V8.1 FP 7a (ie V8.2) on AIX and W2K ..

Cheers
Sathyaram

I have tried using the procedure to load and it seems to work OK ... Any comments ??

Cheers
sathyaram

call db2load(8,'DECLARE mycurs CURSOR FOR select * from load_source','load from mycurs of cursor insert into load_target nonrecoverable',?,'',?,?,?,?,?,?,?,?,?,'')

Value of output parameters
--------------------------
Parameter Name : SQLCODE
Parameter Value : 0

Parameter Name : SQLMESSAGE
Parameter Value :

Parameter Name : ROWS_READ
Parameter Value : 4

Parameter Name : ROWS_SKIPPED
Parameter Value : 0

Parameter Name : ROWS_LOADED
Parameter Value : 4

Parameter Name : ROWS_REJECTED
Parameter Value : 0

Parameter Name : ROWS_DELETED
Parameter Value : 0

Parameter Name : ROWS_COMMITTED
Parameter Value : 4

Parameter Name : ROWS_PART_READ
Parameter Value : 0

Parameter Name : ROWS_PART_REJECTED
Parameter Value : 0

Parameter Name : ROWS_PART_PARTITIONED
Parameter Value : 0

Parameter Name : MPP_LOAD_SUMMARY
Parameter Value :

Return Status = 0

Note the SYSPROC.DB2LOAD stored procedure is no longer supported in v9. It is not thread-safe and has other deficiencies.
In v9+ use the ADMIN_CMD stored procedure instead.

DB2 Database for Linux, UNIX, and Windows