> I have an existing client that is purchasing another company that’s using an AS400. What are my connectivity options via 4D? ODBC?
Wow - I haven’t seen one of those things in a long time. When they came out I was using 4D v1.0.6.
It’s going to depend on what’s running on it. If it’s been upgraded over the years (and even has an IP stack on it), it may be running web apps and (assuming they have developers) you may be able to do REST calls. Maybe.
Most likely it’s running DB2, which means ODBC at best.
If you can’t get in via ODBC and you have to do some sort of file transfer, be aware that the AS/400 uses EBCDIC. You’ll be better off just dropping the client.
LOL… this is freaking hilarious! I will keep Mr Willis in mind…. Long ago he was in Florida and he was speaking to me. At the moment, it looks like I will not have to deal with the AS400 but it was a question from an existing client.