Previous Topic: View Definitions-VNext Topic: VIEW_SET


VIEW_IMPLEMENT (View Implementation)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

VIEW_IMPLEMENT

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

NAME

STRING

Field name

NAME_TYPE

CHARACTER

Field name type:

  • N-Name base
  • R-Row or column based, space

IMPLEMENT_TYPE

CHARACTER

Field implementation type:

  • P-Packed
  • X-Test
  • F-Float
  • S-Small
  • I-Integer
  • Q-Timestamp
  • D-Date
  • T-Time
  • V-Varchar
  • Z-Zoned
  • G-Graphic
  • U-Vargraphic
  • M-Long Vargraphic
  • L-Long Varchar

FIELD_LENGTH

NUMERIC

Field length

DEC_PLACES

NUMERIC

Field decimal places

STRUCTURE_TYPE

CHARACTER

Field structure type

ROW_OR_COL_WISE

CHARACTER

Field repeats columnwise or rowwise:

  • R-Row
  • C-Column, space

REPET_OFFSET

NUMERIC

Field repeating offset from start of field to the start of next

MISSING_FLAG

CHARACTER

Missing flag passed:

  • Y-Yes
  • N-No

ATTR_VIEW_ID

NUMERIC

ID of the attribute view.

Join with ATTR_VIEW.