ESS and DB2/AS400

[Richard_N]

I am looking for help connecting to our AS400. We use a manufacturing program (CA-KBM) that stores its files in DB2/400 format. I am using the data from this program for reference only. Presently I get a daily .csv download which I manually import to my Filemaker file (I must first delete all records). The act of deleting and then importing is time consuming and interferes with user displays.

Does anyone have ideas how to get from DB2 format to a format that is supported by ESS? The .csv file is currently being generated automatically everyday.

Can I use ESS if the output file is an Excel file rather than .csv?

Any suggestions would be appreciated.

Rich

[TimD]

It's been a few years since I've integrated FileMaker with DB2/400, but it can be done. You can setup the DB2/400 database as an ODBC datasource, and then access the data via FileMaker that way. But this isn't going to allow you to use FM's ESS functionality -- you'll only be able to use the ODBC connection for importing.

Hope this helps...

-- Tim

[Garry Claridge]

You can also use ODBC for INSERT, UPDATE and DELETE via the "Execute SQL" Scriptmaker step.

All the best.

Garry