Solved

Unable to use NONRECOVERABLE option in a LOAD Command

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
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.:

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now