By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

can i use load terminate with cursor for select * from table name?

P: n/a
I wanted to know if i always have to use

1..load from /dev/null/ of del terminate into tablename nonrecoverable

or can i do something like

2...declare cur cursor for select * from tablename ...........( the
table which recently failed loading)
load from cur for cursor terminate into tablename ( the table which
failed loading )

I know number 1 works always..but if 2 works then my life would be so
easier..!

Thanks

Apr 15 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I think the above post wasnt clear enough...hers the actual java
psudeocode doing that

delcare cur of cursor for select * from tablename
try{
load from cur of cursor INSERT into table 2
nonrecoverable
}
exception()
{
load from cur of cursor TERMINATE into table 2
nonrecoverable
}
I was wondering if the above wud work....loading from the same cur
again to terminate also...rather than using a NULL file

Apr 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.