Load terminate error; SQL0104N

Justin

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

Subscribe Post Reply

7235

tnj.guy07

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

Similar topics

Failed to load viewstate error

by: Eamonn O'Connell | last post by:

Hi, We have an ASP.net application, where we dynamically add controls, in the Page_Load. Occasionally, when the user posts back the page (e.g. clicks Save button on the page), we get a "Failed...

.NET Framework

Error SQL0104N on very simple client setup. Help.

by: Pradeep | last post by:

DB2ers, In my setup, DB2 server is installed on a Windows box "test16" and "SAMPLE" database has been loaded. Now, on a clean Windows machine (test15), I installed DB2 client...

DB2 Database

Provider Load Failure error message installing FMStocks 7

by: Michael Brame | last post by:

Hello, I am getting the "Provider Load Failure" error message when attempting to install FMStocks 7. I have seen other people post with this error but have not seen a solution for it yet. I...

ASP.NET

Banging my head: Could not load type ERROR

by: darrel | last post by:

What does that MEAN? I'm working on a VS project with another person. We keep our DLLs and files in sync with each other. Last week I hit a snag where i kept getting the 'could not load type'...

ASP.NET

Could not load type error message

by: sling blade | last post by:

Hi, For some reason asp.net will not let me publish a new Webpage. I am able to create a new page however when I set it as the start page and hit run, I recieve "Could not load type" error...

ASP.NET

could not load type error message from ASP.NET

by: Curtiss | last post by:

I receive "could not load type" error message when trying to load aspx page. The DLL is built and is located in the correct bin directory. The type name in the "inherits" attribute matches the...

ASP.NET

Crystal Report - LoadSaveReportException: Load Report Error

by: Crystal Report - LoadSaveReportException | last post by:

I have a web system which will display a crystal report for clients. It is written in Visual Studio 2003, VB.Net and Crystal Report which comes with VS 2003, and it is running on Windows 2000. It...

Visual Basic .NET

Crystal Report:The LoadSaveReportException: Load Report Error

by: Crystal Report - LoadSaveReportException | last post by:

I have a web system which will display a crystal report for clients. It is written in Visual Studio 2003, VB.Net and Crystal Report which comes with VS2003, running on Windows 2000. It works very...

Visual Basic .NET

XslCompiledTransform load compile error

by: andrewcw | last post by:

I am moving some code forward from .NET 1.1. I was able to load the XSL file and perform the transform. The MSDN documentation looks like it should be easy. But I get a compile error. Ideas ?...

.NET Framework

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server