CLP Execution

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TheSpongebob - 02 Mar 2006 15:50 GMT

How do I cancel a query ( load ) mid way ?

Reply to this Message

TheSpongebob - 02 Mar 2006 16:12 GMT

ahaha ... I closed the window. I don't know how to tell if the task
died or not though.

Reply to this Message

Serge Rielau - 02 Mar 2006 16:31 GMT

> ahaha ... I closed the window. I don't know how to tell if the task
> died or not though.

If you are on a newer version there is a load command that lets you
inquire the LOAD STATUS. Check the command reference (I don't know it's
name off hand).

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Raj - 02 Mar 2006 16:38 GMT

You have to force the application off and do a load terminate ...

Reply to this Message

TheSpongebob - 02 Mar 2006 18:37 GMT

Thanx for answering my questions. Is there a good UDB ULW link at IBM
that you would recommend?
I would prefer long-winded explanations rather than the CLP help. I
have the SQL Cookbook already.

Thanx. Randy

Reply to this Message

Knut Stolze - 03 Mar 2006 07:43 GMT

>> ahaha ... I closed the window. I don't know how to tell if the task
>> died or not though.
>>
> If you are on a newer version there is a load command that lets you
> inquire the LOAD STATUS. Check the command reference (I don't know it's
> name off hand).

I guess you are referring to LOAD QUERY: http://tinyurl.com/qseby

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

TheSpongebob - 03 Mar 2006 18:46 GMT

Perrrfect. One stop shopping for information. Now I can get around to
asking some 'real' questions. ;) thanx

Reply to this Message