Using a Linux Web server and calling an SQL package on the iSeries

I have a Linux Web server running IASP connected to my AS/400 for data access. I can't seem to figure out how to call/create an SQL package on the AS/400 that will stay. My SQLs run, but they refer to an SQLPKG that does not exist. (A prior staff member set this up, and now I have to maintain it.)

I'm not familiar with your configuration, however, the SQL package is created when you enable extended dynamic support.

If you use ODBC -- This can be set in the performance tab of the ODBC setup.

If you use JDBC this is doable by using a property 'extended dynamic' on the connection string, or the properties object.

This was first published in May 2001

Back to top