3.6.17 Convert Special Characters in Column Names

Specifies whether column names should be used as-is when creating database columns from column names.

Default = NO (unchecked/not selected) for tables created from LANSA Version 11 SP4 onwards. Tables created in earlier versions default to YES (checked/selected).

Prior to LANSA Version 11 SP4, any tables compiled under Windows might create database columns that did not match the column names. For example, the SECTION column on the Demonstration table SECTAB was created as S_CTION because SECTION was an SQL Keyword. For the same reason, the column MY@FLD would be created as MY_FLD.

From Version 11 SP4, column names in all new tables will not be converted in the database.

This now allows Visual LANSA to use tables that previously would not compile on Windows and failed with error 979. For example, if you had two columns named MY@FLD and MY#FLD on a table, the table would fail to build on Windows with the message:

979 FATAL - Fields MY@FLD and MY#FLD resolve to the same SQL column name MY_FLD

The table could only be used on IBM i. Now, you can change the setting to NO (unchecked/not selected) and the table will build successfully.


Tips & Techniques

Platform Considerations