we are evaluating Natural SQL Gateway (CONNX 11.5 SP1) to access from our Natural Programs in Mainframe to a DB2 UDB database.
We are having troubles with DATE fields.
Our Natural programs are expecting the EUR format (DD.MM.YYYY) but through CONNX we are only able to get the ISO format (YYYY-MM-DD).
From Infonaut we can get the different formats modifying the Regional Settings related to date/time in the workstation where we are importing the data definition through CONNX Data Dictionary. We have tried to modify the Native Type to the format that we need, the field is protected and we can’t do it in the DDM.
Do you know how to solve this issue?
We know that with the concat and substr functions we have a chance, but the performance is very poor.
Thanks in advance.