Skip to Content
0
Aug 11, 2005 at 07:21 PM

JDBC Adapter how to select multi format files on AS/400

105 Views

Hi all,

i want to access a multi format file in a AS/400 Library via JDBC Adaptor. When i try to 'select * from XXXX.FILEN' i get an error "SQLException during query 'select * from XXXX.FILEN': java.sql.SQLException:[SQL7003]File FILEN in XXXX has more than one format.

Does anybody knows how to access a multi format file in AS/400 via a SQL statement which i can use in the JDBC-Adaptor configuration.

Thanks,

Juergen