Forums

by Martin Connolly >> Wed, 21 Jul 1999 1:05:51 GMT

Anybody have experience with interfacing from Jade to AS/400 databases? Is it as 'simple' as External Database/ODBC?

Comments on Do's & Dont's, Can's & Cant's would be greatly appreciated



Martin Connolly

by Sean Dick >> Sat, 24 Jul 1999 5:01:43 GMT

We have done this from Jade but have done some exporting to SQL from AS400 using the Start SQL ODBC drive that comes on the SNA Server 4 CD.

The problem with this is that MS gave it back to the original writer.

So all I can say is that there is at least one ODBC driver to access the AS400 so if the access to ODBC works in Jade then you should be in ..

by Leigh Roberts >> Mon, 26 Jul 1999 20:58:02 GMT

Martin

We have connected to AS/400 systems by using flat file transfers with IBM SNA to DOS software. It works fine as we only need to poll directories and process files when the are detected by a Jade application. This works in mission critical production systems.

Also I've connected to DB2 from a Jade application to prove to myself that it works. It works fine but haven't built a production system with it.

I've had experience connecting to SQL databases in this way before to build client-server applications (not with Jade). There are books written on the subject because it is not as simple as just getting rows from a table or updating a single table. From what I've seen using Jade would entail solving all the known OO-relational impedence mismatch problems everyone else has to solve. I'm sure it could work well but it needs some careful design up front and a good thrashing to prove that performance isn't an issue.

Leigh