Call IBM i Command

Typically remote clients access IBM i data via DB2 SQL Query Engine and the JDBC or ODBC interface. This works well for regular files and DB2 tables. However on a recent call with prospect I ran into a use case where the data needs to be pushed into a multi-member file. This is a special IBM i file type widely used in older IBM i (AS400) applications, that supports partitioning content into multiple "members" and provides methods for isolating the data for traditional IBM i programs.

The Standard ODBC and JDBC access methods don’t work with multi-member files.

This template dynamically:

• Creates a new member in the IBM i file using the AS400 connector Command Call operation.
• FTPs the data to the new member.
• Calls the IBM i processing program and passes the member name in parameters, again using the AS400 connector Command Call operation.