FairCom RTG COBOL User Guide

<sqlize>

The sqlize option indicates whether to attempt linking the table to FairCom DB SQL when creating a new table. If this option is set to yes, the necessary operations to make the file accessible from FairCom DB SQL are performed when the file is open with OUTPUT or EXTEND mode. This option is disabled by default. The sqlize option accepts both XFD and XDD files as input.

Accepted Values

Value	Effect	Synonyms
yes	Files opened with OUTPUT or EXTEND mode are linked to FairCom DB SQL.	y, true, on, 1
no	No attempt to link table is made. This is the default value.	n, false, off, 0

Attributes

Attribute	Description	Synonyms
xfd	Path to XFD data definition file. Files and paths are relative to the ctutil working directory. For example: <sqlize xfd="custmast.xfd">yes</sqlize> A full path to file is also accepted. For example, <sqlize xfd="/usr/local/etc//rtg/custmast.xfd">yes</sqlize> If only a directory is specified, a file with the same name as the table name is searched with an ".xfd" extension. See XFD/XDD Notes below.
xdd	Same behavior as xfd above except xdd is used as the search criteria.
database	Database name to add the file to. The default value is "ctreeSQL".	db
password (deprecated)	FairCom RTG ADMIN password. The default value is "ADMIN". The user performing the sql* operation must have either DBA or RESOURCE SQL privileges in order for the operation to succeed or a FairCom RTG error 456 (group access denied) will be returned.	pw
symbolic	Optional table name to use when adding file to a database.	symb
prefix	Optional prefix for table or symbolic name.
owner	Optional user name to assign table ownership.
public	Optionally grant public access permissions. Values: "yes" : Grant public permissions. "no" : Turns off CRC checks. "readonly" : Grant read-only permission. (The owner of the table and the DBA have all the permissions)
convention	Numeric storage convention ID. Values: A - ACUCOBOL-GT B - MBP COBOL D - Data General I - IBM M - Micro Focus N - NCR COBOL R - Realia COBOL V - VAX COBOL The default value is "M" for EXTFH or "A" for ACUCOBOL-GT.	conv, numformat
rules	Optional path to rules file - see Define External Rules	rule

XFD / XDD Notes

The xfd and xdd attributes can be used to specify an XDD (or XFD or .iss) file to use for the sqlize operation. This parameter accepts either a XDD file name or a full path to a XDD file. If only the file name is specified, the XDD file must be available to the ctutil client. Files and paths are relative to the ctutil working directory.

Values may contain %n and %d substitution specifiers. For more information about substitution specifiers, please refer to the topic Substitution specifiers.

Note: If both xfd and xdd attributes are specified, the logic first looks for an XDD file and if the file is not found, sqlize falls back to looking for an XFD file.

Note: If an XDD is directly specified with ctutil -make, any XDD specified with <sqlize> in a ctree.conf configuration is ignored in favor of the passed in XDD.

Examples