Create Table Facility for Sybase

The Create Table facility (/genSqlcreatetable) is fully supported.

The Create Table facility creates a command file containing the Transact-SQL statements required to create all necessary database objects (tables, indexes, and stored procedures) for each Uniface entity.

Note:  When generating scripts, the assignment file must contain settings that match the DBMS connector version and parameters that will be used for the target database.

The following connector options can affect the generated scripts:

• row level locks—when enabled, the generated SQL scripts create tables that support row-level locking.
• disable numerics—when enabled, the generated SQL commands create tables that do not support the numeric data type.

• dump tran—when enabled, the generated SQL script contains one dump transaction command for each table

Related Topics