467,114 Members | 1,324 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,114 developers. It's quick & easy.

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

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
  • viewed: 2625
Share:
1 Reply
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.

Similar topics

3 posts views Thread by DarthMacgyver | last post: by
7 posts views Thread by William Gill | last post: by
3 posts views Thread by db2udbgirl | last post: by
1 post views Thread by Ultrak The DBA | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.