JDBC connection string not finding sort table in iASP

I’m creating a connection with the URL string:

jdbc:as400://MYSYSTEM;translate binary=true;date
format=iso;prompt=false;database name=IASP01;sort=table;sort

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:

Program: QZDASRV

Library: QSYS



Statement: 13545

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.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.