Model Values

Introduction to Access Paths › Model Values

Model Values

Model-specific values control particular features of the interactive use of CA 2E, code generation, and implementation.

For more information about what a model value is, see the "Using Your Development Environment" chapter in the Administration Guide.

The model values you need when building access paths are:

YALCVNM	The Allocate Valid Name (YALCVNM) model value specifies whether DDS and SQL object names are to be allocated automatically by CA 2E or by a specific standard you establish for the CA 2E model.
YOBJPFX	The Object Prefix (YOBJPFX) model value specifies the prefix to be used when generating system objects.
YFILPFX	The Last Used File Prefix (YFILPFX) model value contains the last 2-character identifying mnemonic CA 2E used when creating a new file. These two characters occupy positions three and four of the new file name, following the model object prefix.

For more information about object name prefixes, see the following:

The "Creating and Managing Your Model" chapter in the Administration Guide
The Setting Up the User Environment section in the "Using Your Development Environment" chapter of the Administration Guide

YDBFGEN

The Database Generation (YDBFGEN) model value specifies the default method of source generation (DDS or SQL) for database definition.

You can set your source generation type by doing the following:

Setting the model value YDBFGEN at the time that you create your CA 2E model.
Changing the model value YDBFGEN after creating the model.
Changing the generation mode on a specific access path.

For more information about setting the source generation type for your model, see the "Creating and Managing Your Model" chapter in the Administration Guide.

YSQLLIB	The SQL Library (YSQLLIB) model value specifies the library (collection) in which to place the SQL objects needed to implement an SQL database.
YSQLVNM	The SQL Naming (YSQLVNM) model value specifies whether to use the extended SQL naming capability. You can specify either DDS names (the shipped default) or the names of CA 2E objects in the model (extend SQL naming).
YSQLLEN	The SQL Naming Length (YSQLLEN) model value is a numeric value that controls the length of the extended SQL name. Its maximum value is 25. This model value is used only when YSQLVNM is *SQL.

For more information about extended SQL naming, see the "SQL Implementation" appendix in the Administration Guide.

YDBFACC

The Database Access Method (YDBFACC) model value lets you specify whether to access data from a table or from a view when an access path and the table over which it is based contain the same fields.

For more information about direct table access, see the "SQL Implementation" appendix in the Administration Guide.

You can set your model values when you create your model or change the model value with the YCHGMDLVAL command. However, once you have set your model values, you can then override many of these defaults for a specific access path using the access path detail options.

For more information about model values and how to set model values, see YCHGMDLVAL in the CA 2E Command Reference Guide.

Tell Technical Publications how we can improve this information