Solved

Unable to use NONRECOVERABLE option in a LOAD Command

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Result Set to XML 4 40
remove one line from a file in solaris 8 29
export sql results to csv 6 36
SQL Use Distinct with two fields 3 11
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 …
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
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.:
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

831 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