Connection to AS400 with Ecto

[Ted]

@saintex

SQL0104 - Token not valid. Valid Token: + - AS . SQLSTATE IS: 42000’

So the good news it that the server responds (thank you all).
The bad one is that I have to learn to query DB2 with is SQL dialect.
Here perhaps it seems not so happy with the numbers.

You’re right: DB/400 has its own dialect (and it’s a little different than standard DB2).

Try SELECT 1 + 1 FROM SYSIBM.SYSDUMMY.

(EDIT: changed SYSDUMMY1 to SYSDUMMY.)