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 or SQL. The default is the value defined by the YSYSDBF model value.

*DDS

*SQL

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.

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.