Key to Control Table Columns
Use the following tables to interpret abbreviations used in client control tables displayed from the Client Console. For more information, see Chapter 6 in the DATABridge Client Administrator's Guide.
DATASETS
ds
|
dataset_name
|
Time Stamp
|
audit_ts
|
OP
|
ds_options
|
/type
|
rectype
|
M
|
ds_mode
|
SB
|
status_bits
|
set
|
set_name
|
FMT
|
client_fmtlevel
|
MISC
|
misc_flags
|
A
|
active
|
RSZ
|
recsz_bytes
|
MAXRECS
|
max_records
|
ST#
|
strnum (structure number)
|
P#
|
parent_strnum
|
VDS
|
virtual_ds_num
|
AFN
|
audit_filenum
|
#C
|
num_children
|
RDX/type
|
real_ds_num real_ds_rectype
|
ABSN
|
audit_block
|
B#
|
base_strnum
|
EXTC
|
external columns
|
SEG
|
audit_seg
|
ST
|
subtype
|
|
|
INX
|
audit_inx
|
ICNT
|
item_count
|
|
|
DATATABLES
ds
|
dataset_name
|
occ
|
occurs_level
|
original name
|
original_name
|
table name
|
table_name
|
T#
|
table_number
|
P
|
prim_table
|
index
|
index_name
|
A
|
active
|
|
|
/type
|
rectype
|
suf
|
create_suffix
|
|
|
DMS_ITEMS
ds
|
dataset_name
|
DL
|
dms_decl_length
|
dep
|
dms_depends_num
|
/type
|
dsm_item_name
|
S
|
dms_scale
|
ST
|
dms_subtype
|
A
|
active
|
O
|
dms_offset
|
OP
|
di_options
|
K
|
item_key
|
L
|
dms_length
|
lnk
|
dms_link_ds_num
|
#
|
dms_item_number
|
s
|
dms_signed
|
|
|
P#
|
dms_parent_name
|
#O
|
dms_num_occurs
|
|
|
T
|
dms_item_type
|
#D
|
dms_num_dims
|
|
|
DATA_ITEMS
table
|
table_name
|
P#
|
dms_parent_item
|
OCC
|
dms_num_occurs
|
#
|
item_number
|
TYP
|
dms_item_type
|
TY
|
sql_type
|
item_name
|
item_name
|
DL
|
dms_decl_length
|
LEN
|
sql_length
|
A
|
active
|
SC
|
dms_scale
|
STY
|
dms_subtype
|
K
|
item_key
|
OFF
|
dms_offset
|
SC
|
sql_scale
|
VK
|
virtual_key
|
LEN
|
dms_length
|
dep
|
dms_depends_num
|
I#
|
dms_item_number
|
s
|
dms_signed
|
OP
|
da_options
|
|