Solved

Unable to use NONRECOVERABLE option in a LOAD Command

Posted on 2010-09-15
2
1,336 Views
Last Modified: 2012-08-13

Hello all,
I am unable to use NONRECOVERABLE option in the following command. Could it be that I am using a virtual cursor file?
db2 => LOAD FROM LOAD_CUR2 OF CURSOR warningcount 20 REPLACE INTO DBLTDBA.RCATB_SMS_TBL2 NONRECOVERABLE;
SQL0104N  An unexpected token "NONRECOVERABLE;" was found following "<identifier>".  Expected tokens may include:  "(".  SQLSTATE=42601

Thanks
okonita1
0
Comment
Question by:okonita1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
db2inst1 earned 125 total points
ID: 33694813
You load command looks good, i did a quick test. It works ok. How are you declaring your cursor?

declare c1 cursor for select COL1 from test1
DB20000I  The SQL command completed successfully.

load from c1 of cursor warningcount 20 replace into test nonrecoverable

  Agent Type     Node     SQL Code     Result
______________________________________________________________________________
  LOAD           001      +00000000    Success.
______________________________________________________________________________
  LOAD           002      +00000000    Success.
______________________________________________________________________________
  PARTITION      000      +00000000    Success.
______________________________________________________________________________
  RESULTS:       2 of 2 LOADs completed successfully.
______________________________________________________________________________

Summary of Partitioning Agents:
Rows Read                   = 2
Rows Rejected               = 0
Rows Partitioned            = 2

Summary of LOAD Agents:
Number of rows read         = 2
Number of rows skipped      = 0
Number of rows loaded       = 2
Number of rows rejected     = 0
Number of rows deleted      = 0
Number of rows committed    = 2


0
 

Author Closing Comment

by:okonita1
ID: 33721575
Thank you...
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question