db_field

The db_field table contains metadata about fields assoc with COBOL records.

Column Name Column Datatype Column Null Option Column Comment
dbrep_iid integer not null The unique ID of the object.
dbrep_sequencenum integer with null The sequence number of column in db_field table.
dbrep_groupiid integer with null The ID of the parent group object.
dbrep_pictureclause varchar(31) with null The picture clause (if any) (ie S999V99).
dbrep_usageclause varchar(255) with null The usage clause (if any) (ie COMP-3)
dbrep_synctype smallint with null The sync value (byte alignment, used on COMP fields).
dbrep_isgroup smallint with null TRUE if this field contains other fields (is a group field).
dbrep_isnested smallint with null TRUE if containing group is a FIELD, FALSE if containing group is a LAYOUT.
dbrep_type smallint with null The type of field - CHAR, COMP, COMP-3, etc.
dbrep_length integer with null The length of the field.
dbrep_precision integer with null The precision of the field.
dbrep_scale integer with null The scale of the field.
dbrep_blankwhenzero smallint with null The Z in the COBOL pic clause.
dbrep_justified smallint with null Indicates whether field is justified (TRUE) or not (FALSE).
dbrep_issigned smallint with null Indicates whether field is signed or not.
dbrep_issignseparate smallint with null Indicates if sign is separate.
dbrep_signtype smallint with null The sign type - Leading","Trailing","None" not printed if default of "None".
dbrep_redefinesfieldname varchar(255) with null The COBOL redefines clause.
dbrep_dependsonfieldname varchar(255) with null Occurs X times depending on Z (this is Z).
dbrep_occursmin smallint with null Occurs X to Y times (this is X or min)
dbrep_occursmax smallint with null Occurs X to Y times (this is Y or max)

Product Name: Data Transformer

Table Type: Table


Copyright © 2006 CA. All rights reserved.