How would this be accomplished? I’ve tried to connect unsuccessfully.
As far as I know, the only way to achieve this is by using an ODBC connection to the database. That means you must install and configure the DB2 ODBC driver (how to achieve that is beyond the scope of this forum).
Once you have the driver set up properly, then connecting to the DB on the AS/400 is no different than with any other DB engine accessed through ODBC.
I have a similar scenario at my workplace. I found the easiest way to handle this was to convert the AS/400 file into XML (using local tools) and output the resulting file to the IFS area of the AS/400.
The IFS area has a similar structure to a Windows file system and can be mapped if the correct permissions to it are applied. The XML file can picked up by a workflow process using the Folder Capture widget and mapped with a datamapper.
I’m assuming the file you’re attempting to access is not highly volatile. If it is, then the method above may not suit your purposes.