Model Value

Description

Allowed Values

YDBFACC

Specifies whether data is accessed using the SQL table directly or an SQL view.

*DBFGEN—Access data using a view.

*TABLE—Access data directly from the SQL table.

YDBFGEN

Defines the method for database definition, either DDS, SQL or DDL. The default is the value defined by the YSYSDBF model value.

*DDS

*SQL

*DDL

YFRFPFX

Prefix for fields in field reference file.

Valid System Name—Specify your own.

YFRFTXT

Text for field reference file.

Character string

YFRFVNM

Name of field reference file.

Valid System Name or *NONE

YOLDDBS

Controls display of the old DBF name field on the Edit Field Details display.

*YES—Display YES.

*NO—Display NO.

YSQLLEN

Controls the length of the extended SQL name.

A numeric value up to 25.

This model value is used only when YSQLVNM is *SQL.

YSQLFMT

Specifies whether the RCDFMT keyword must be generated for SQL tables, views, and indexes.

*NO

*YES

YSQLVNM

Specifies whether to assign DDS names or model object names to SQL tables and columns.

*DDS—Use DDS names.

*SQL—Use the names of the CA 2E model objects; in other words, use extended SQL naming.

*LNG—Use the long names of the CA 2E objects in the model along with the DDS or implementation names.

*LNF—Use the long field names of the CA 2E objects in the model along with the DDS or implementation names.

*LNT—Use the long table names of the CA 2E objects in the model along with the DDS or implementation names.