Results 1 to 3 of 3

Thread: db2load

  1. #1
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Unanswered: db2load

    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2009
    Posts
    1
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •