SQLError -206: SQLSTATE 42703
Nicola Mackin
Hope somebody can help me. I am using Microsoft HIS2000 connecting to an
aging AS400 running V3R1M0.
What I am trying to do is extract various files from DB2/400 and import into
a basic text file, having setup Microsoft OLD DB Provider for DB2 correctly
(I think) I find that I am able to view all tables on my AS400 without
problem, I can also view fields within my tables.
However when I try to physically extract the tables I constantly get the
following errors:
SQLSTATE 42703 and SQLError -206 and the hole procedure stops running. There
are no errors logged on my AS400 anywhere.
Strange thing is that my procedure worked perfectly on AS400 DB files
created by one vender but not on other vendors!
Any ideas? As I am fairly egger to decommission this machine ASAP.
Your thanks in Advance.
Nicola Mackin
SJ Lennon
Explanation: Column &1 not in specified tables.
There should be a server job somewhere on the AS/400 that is handling
your connection. Msl SLQ0206 will turn up somewhere in it's job log.
If you expand that message it will have the &1 replaced with the column
in error. I don't know the name of the server job, but at an AS/400
command line, WRKOBJLCK userprofile *USRPRF, where userprofile is the
user profile through which you are connecting, should give you a list of
one or more jobs, one of which is the server job.
SQL states a codes are documented in the iSeries InfoCenter:
http://as400bks.rochester.ibm.com/pubs/html/as400/v4r5/ic2924/index.htm
http://as400bks.rochester.ibm.com/pubs/html/as400/infocenter.html
Sam
"Nicola Mackin" <nma...@abdick.co.uk> wrote in message
news:uijepv...@corp.supernews.com...