REPORT (Generate Reports) › Directory (CXX) Reports › Sample Report: REPORT CXX - Full - Special Fields

Sample Report: REPORT CXX - Full - Special Fields

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.

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

This page of the report shows the special columns (fields) for this table. Fields only appear if they have DBEDITS=Y or NULL-INDICATOR=Y.

TYPE

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

NULL

Indicates whether the field accepts no values (NULL-INDICATOR).

FORCE

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).

CHANGE

Indicates whether a change is allowed (UNCHANGEABLE).

DEFAULT

Indicates the type of default value.

• LITERAL - A specified value
• NO DFLT - No default
• STD - Standard default for type
• SYSTEM - Indicates an accessor ID default (default system user)
• USER - The system user ID (AUTHID)

VALUE

Contains the specified value for a literal value.

START

Contains the displacement of the field in the table.

LENGTH

Contains the length of the field.

OCCURRENCE

Contains the entity-occurrence name and status/version of the field.