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

[former_member262685]

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

[Former Member · Accepted solution]

Hi Jürgen,

And if nothing works, use Java Proxys and write your own SQL Statements.

Regards,

Robin

[Former Member]

Hi Jurgen,

Check this link,

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

also a guess, instead of "*", can you try with column names of required columns (and make multiple queries, based on qualifiers/columns for appropriate formats within the same file)

Regards

Vishnu