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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

technocrat - 15 Apr 2006 07:06 GMT

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

Reply to this Message

technocrat - 15 Apr 2006 07:19 GMT

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

Reply to this Message