thanks for answering. I suspect, that you will get in trouble if CA will use this triple some day.
I'm looking for a place to store the DDS fieldname (DDSVNM in Synon modelfile YFLDDTARFP), so that we can modify the generated CREATE TABLE-Source with a column renaming, using the DDS fieldname in combination with a longer SQL fieldname, we used while generating our SQL tables on the iSeries (with JAVA JDBC server)
So, 2E can generate DDL for your tables instead of DDS? I wish Plex would do that. I'm working on a similar problem here. I want to assign long names to our fields in addition to our existing 10 char impl names. That way, JDBC/ODBC interfaces can use the long name. This is mainly for query tools such as MS Access. I have figured out that assigning a long name to a field does not change the format identifier for a file. So, you can recreate the file with the long names and not have to recompile any of your existing RPG programs.