A list of certain special fields can appear after the elements section on the report. To appear on the list, the field must have the DBEDITS or NULL-INDICATOR attribute turned on. The DBEDITS attribute is turned on for all columns (fields) when the table is created through SQL.
When the DBEDITS attribute-value for a FIELD entity-occurrence is set to Y, additional information is stored in the Directory during a catalog and the records are edited by CA Datacom/DB according to data type when they are added, loaded, or updated.
Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn Base: 16 ******************************************************************************** Directory: PRODCXX TABLE A11 CONTINUED ELEMENTS - NAME SECURITY CODE START LENGTH DATA TYPE NULL COL. OCCURRENCE SQLEL 00-000 0 27 CHARACTER YES SQLEL P001 FIELDS - TYPE NULL FORCE CHANGE DEFAULT VALUE START LENGTH OCCURRENCE } CHAR NO NO YES LITERAL DEMOCHAR 0 8 DEMCHAR P001 } BIN YES NO YES LITERAL 9999 8 5 DEMINT P001 } BIN YES NO YES NO DFLT 13 5 DEMINT2 P001 } CHAR YES NO YES NO DFLT 18 9 DEMCHAR2 P001 }
Report of the special columns (fields) for this table. Fields only appear if they have DBEDITS=Y or NULL-INDICATOR=Y.
Indicates the data type of the field or, if it was placed on the list because NULL-INDICATOR=Y, NOEDT to signify that the DBEDITS attribute is not turned on for this field.
BIN Binary in a database cataloged in a previous version (see SBIN and UBIN)
BIT Character field, bit data (not converted to or from PC)
CHAR Character
DATE SQL DATE
FLOAT Floating-point
GRAF Double-byte character set (replaces DBCS)
MIXED Character field which allows single-byte and double-byte characters (double-byte characters must be within Shift-Out/Shift-In pairs)
NOEDT No DBEDITS on this field
SBIN Signed binary (see BIN and UBIN)
SPACK Signed packed decimal
STAMP SQL TIMESTAMP
SZONE Signed zoned decimal
TIME SQL TIME
UBIN Unsigned binary (see BIN and SBIN)
UPACK Unsigned packed decimal
UZONE Unsigned zoned decimal
VBIT Variable length BIT
VCHAR Variable-length character
VGRAF Variable length GRAF (double-byte character set)
VMIX Variable length MIXED
Indicates whether the field accepts no values (NULL-INDICATOR).
Indicates whether a value must be provided.
ADD Must supply a value when adding (FORCEADD).
ALL Must supply a value when adding or updating (FORCEADD and FORCEUPD).
NO A value is not required when adding or updating.
UPDT Must supply a value when updating (FORCEUPD).
Indicates whether a change is allowed (UNCHANGEABLE).
Indicates the type of default value.
LITERAL A specified value
NO DFLT No default
STD Standard default for type
USER The system user ID (AUTHID)
Contains the specified value for a literal value.
Contains the displacement of the field in the table.
Contains the length of the field.
Contains the entity-occurrence name and status/version of the field.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|