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 /type	dataset_name/rectype	ST	subtype	AFN	audit_filenum
set	set_name	ICNT	item_count	ABSN	audit_block
A	active	OP	ds_options	SEG	audit_seg
ST#	strnum	MISC	misc_flags	INX	audit_inx
FMT	client_fmtlevel	EXTC	external_columns	Time Stamp	audit_ts
RSZ	recsz_bytes	VDS	virtual_ds_num	M	ds_mode
P#	parent_strnum	RDS/type	real_ds_num real_ds_rectype	SB	status_bits
#C	num_children	chg	changes	MAXRECS	max_records
B#	base_strnum	BMASK	ds_user_bmask	PRI	extract_priority

DATATABLES

ds /type	dataset_name/rectype	T#	table_number	isf	index_suffix
table_name	table_name	A	active	OP	dt_options
index	index_name	P	prim_table	chg	changes
occ	occurs_level	suf	create_suffix	BMASK	dt_user_bmask

DMS_ITEMS

item name	dms_item_name	S	dms_scale	lnk	dms_link_ds_num
A	active	OFF	dms_offset	ST	dms_subtype
K	item_key	LEN	dms_length	CAT	dms_concat_num
#	dms_item_number	s	dms_signed	OP TIONS	di_options
P#	dms_parent_item	#O	dms_num_occurs	OPT2	di_options2
T	dms_item_type	#D	dms_num_dims	chg	changes
DL	dms_decl_length	dep	dms_depends_num	BMASK	di_user_bmask
				BM2	di_user_bmask2

DATAITEMS

#	item_number	V K	virtual_key	chg	changes
item_name	item_name	STY	dms_subtype	BMASK	da_user_bmask
A	active	OLV	occurs_level
K	item_key	OPTIONS	da_options

Abbreviations for columns grouped under DMS

DMS I#	dms_item_number	DMS SC	dms_scale	DMS OCC	dms_num_occurs
DMS P#	dms_parent_item	DMS OFF	dms_offset	DMS dep	dms_depends_num
DMS TYP	dms_item_type	DMS LEN	dms_length
DMS DL	dms_decl_length	DMS s	dms_signed

Abbreviations for columns grouped under SQL

SQL TY

sql_type

SQL LEN

sql_length

SQL SC

sql_scale