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.

Related Topics