JDBC connection string not finding sort table in iASP
I’m creating a connection with the URL string:
I use “database name=IASP01” to indicate that my database exists in the
I use “sort=table” along with the “sort table=MYLIB/MYTABLE” to indicate
what sort table to use.
MYTABLE *TBL does indeed exist in MYLIB
MYLIB *LIB does indeed exist in IASP01
IASP01 is varied on and available.
When i execute
I can see a new QZDASOINIT job started with my user as the current user.
The job attributes indicate the Auxiliary storage pool group is set to
The job log indicates CPF9810 – Library MYLIB not found
The connection then throws an exception:
SQL0332 Character conversion between CCSID 0 and CCSID 37 not valid.
This message comes from:
This is a v7.1 box.
Why would the library not be found in this case?
If I leave off the sort properties I can get a connection and access my
tables in MYLIB.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.