Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Unable to use NONRECOVERABLE option in a LOAD Command

Posted on 2010-09-15
2
Medium Priority
?
1,398 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 500 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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
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 navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Suggested Courses

810 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