geting SQL0668N on file load, please help

[mrsmith]

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?

[Serge Rielau]

mrsmith wrote:

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?

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

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

[mrsmith]

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?

[Serge Rielau]

mrsmith wrote:

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?

Did you check the message file?

Cheers
Serge

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