geting SQL0668N on file load, please help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mrsmith - 09 Feb 2006 04:51 GMT

I'm trying to do a file load with this statement:

LOAD FROM "/directory/datafile.txt" OF ASC MODIFIED BY NULLINDCHAR=Y
METHOD L (1 8, 13 20, 28 30, 39 89) NULL INDICATORS (4, 7, 8,0) INSERT
INTO TMP_Table (EMPLOYEEID, MAJORID, SALESID, NAME) COPY NO INDEXING
MODE AUTOSELECT
commit

It worked couple of times but now I'm getting this:

SQL0668N Operation not allowed for reason code "3" on table
"USER.TMP_TABLE". SQLSTATE=57016

DB20000I The SQL command completed successfully.

What's wrong here?

Reply to this Message

Serge Rielau - 09 Feb 2006 04:57 GMT

> I'm trying to do a file load with this statement:
>
[quoted text clipped - 12 lines]
>
> What's wrong here?

Well, check the meaning of -668 with: db2 "? SQL0668"
It's pretty clear..

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

Reply to this Message

mrsmith - 09 Feb 2006 12:58 GMT

I know that

SQL0668N
Operation not allowed for reason code reason-code on table table-name .

3
The table is in Load Pending state. A previous LOAD attempt on this
table resulted in failure. No access to the table is allowed until the
LOAD operation is restarted or terminated.

The question is why did LOAD fail?

Reply to this Message

Serge Rielau - 09 Feb 2006 13:10 GMT

> I know that
>
[quoted text clipped - 7 lines]
>
> The question is why did LOAD fail?

Did you check the message file?

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

Reply to this Message