Re: SQL error

["Colin Williams" <colin.williams@xxxxxxxxxxxx>]

William,

look at message desc. SQL7008 in QSQLMSG in QSYS, look at the second level
text and check whether your error meets any of the error codes shown.

cheers
Colin.W
----- Original Message -----
From: "William A. Hansen" <whansen@xxxxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, February 04, 2004 12:03 AM
Subject: SQL error


I'm trying to execute an SQL INSERT from Net.Data and I'm getting the
following error message:

The statement failed. CUSTLIST in TSTLIB not valid for operation. (SQLSTATE
55019, SQLCODE -7008)

The manual says this message indicates "The table is in an invalid state for
the operation."  I have no idea what that means.

The statement works from a STRSQL command line.

I first thought the problem was a security issue, since the transactions are
being run under different user IDs.  So I checked all authorities to the
library and file to confirm that me and the servers have equal authority.
Any suggests where I should check next?

I know you're lurking out there, Bruce.


William A. Hansen
Manta Technologies Inc.
(847) 382-7189
whansen@xxxxxxxxxxxxx
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.