How to connect AS400 (best practice)

[Former Member]

Hi folks,

I'm trying to connect to an AS400 server and need expert advise to do so.

I'm planning to use a JDBC driver to connect to the DB2400 database (for write/read into specific tables).

What is the best way to reset AS400 user/password ? Use JDBC connectio and write into correct table or use Windows programs as RMTCMD to connect to AS400 and then launch AS400 command line ?

Does any of you have try these kind of solution ?

Thanks for your help,

Ben

[former_member2987]

Ben,

That's an interesting question. I think there are a couple of approaches to this:

1. Check with SAP to see if they have an "official" connector. I know there was a slide deck out there a couple of years ago with some "approved" connectors. There might be one there. Slim chance, but why re-invent the wheel?

2. More likely you'll need to create your own. You're on the right path with the JDBC connector, but I'm not sure if you'll be able to set passwords. It'll depend on the system and level of access you have. You should also look to see if there's an LDAP interface to the system. Might not be helpful for database applications, but would be good for general system (OS) access.

Good luck!

Matt