Connection to DB2 on AS/400 through ODBC

1

Dear all,

despite to what I have read in this forums - Posting from @dgudkov: DB2 Connections? - for me it seems that a connection to DB2 on an AS/400 (Sytem i) seems to work.

2020-06-22_074547
2020-06-22_074547.jpg1026×643 154 KB

As seem on the screenshot above there are only some fields of the DB2 where the type (NUMERIC) is not recognised. (Don`t know how much limitation this meens?)

As this is the main database we use in the office (bank; hosting their core banking system on a AS/400 (System i) ) it would be great if it could be officially confirmed that DB2-connection works also for non DB2 LUW.

Best regards,
MacGyver

2

Hi @Handelsbank.PB,

I’ve sent you a private message on this forum. Please check it out.

3

Support for DB2 for IBM i (AS/400) was added in version 4.4.1. You can get it from our download page.

In order to use it, you have to choose “DB2 for i (AS/400)” in the “SQL dialect” option in the ODBC connector configuration:

image