Create Table Facility for DB2
The Create Table facility (/genSqlcreatetable
) is
fully supported.
DBMS Connection
Note: When generating scripts, you must ensure that the assignment file contains settings that match the DBMS connector version and parameters that will be used for the target database.
If there is no database connection, the utility
assumes that the database is non-unicode (for compatibility) and will therefore add the
CCSID
clause if there is a W field or $DEF_CHARSET is UTF8.
If there is a database connection, the database to
which Uniface IDE is connected determines whether the CCSID
clause is necessary,
and whether a W field is mapped to [VAR]CHAR or [VAR]GRAPHIC.