467,209 Members | 1,390 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

CLP Execution


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

Mar 2 '06 #1
  • viewed: 981
Share:
6 Replies
ahaha ... I closed the window. I don't know how to tell if the task
died or not though.

Mar 2 '06 #2
TheSpongebob wrote:
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

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 2 '06 #3
Raj
You have to force the application off and do a load terminate ...

Mar 2 '06 #4
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

Mar 2 '06 #5
Serge Rielau wrote:
TheSpongebob wrote:
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

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Mar 3 '06 #6
Perrrfect. One stop shopping for information. Now I can get around to
asking some 'real' questions. ;) thanx

Mar 3 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Paolo Losi | last post: by
2 posts views Thread by Jenny Zhang | last post: by
5 posts views Thread by Johannes Lebek | last post: by
75 posts views Thread by Beni | last post: by
3 posts views Thread by iam980@gmail.com | last post: by
2 posts views Thread by Ina Schmitz | last post: by
17 posts views Thread by romixnews@googlemail.com | last post: by
2 posts views Thread by abhaybhat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.