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

Load terminate error; SQL0104N

P: n/a

We had a load that failed. Now we have a pending load.

When executing load terminate, we receive the following error:

db2 load terminate
SQL0104N An unexpected token "terminate" was found following "LOAD".
Expected tokens may include: "QUERY". SQLSTATE=42601

db2 query load terminate
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "load" was found following "query ".
Expected
tokens may include: "JOIN <joined_table>". SQLSTATE=42601
Nov 16 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Nov 16, 12:53 pm, Justin <kfw...@hotmail.comwrote:
We had a load that failed. Now we have a pending load.

When executing load terminate, we receive the following error:

db2 load terminate
SQL0104N An unexpected token "terminate" was found following "LOAD".
Expected tokens may include: "QUERY". SQLSTATE=42601

db2 query load terminate
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "load" was found following "query ".
Expected
tokens may include: "JOIN <joined_table>". SQLSTATE=42601
What a command is that??????
Please use the same format that you used for the load command with
only change being
the use of 'terminate into ' keyword in place of 'insert into'.
Also, you query only existing load process, not terminated process.
Thus the query load terminate is absured
command.
P.s I am assuming everything in this discussion pertains to db2 udb.
Nov 16 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.