Solved

Unable to use NONRECOVERABLE option in a LOAD Command

Posted on 2010-09-15
2
1,320 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
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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

I promised to write further about my project, and here I am.  First, I needed to setup the Primary Server.  You can read how in this article: Setup FreeBSD Server with full HDD encryption (http://www.experts-exchange.com/OS/Unix/BSD/FreeBSD/A_3660-S…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
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…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

820 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