JRH DB2I2 line object

JRH DB2I2 Line Objects

The DB2I2 line objects consists of a line object abbreviation and line object separated by a blank
The DB2I2 line objects can start any positions on the edit line. However, no other information can be entered before the line object abbreviation.
Enter '--' on the first position of the edit line to indicate the line is a comment line.

For example, to request action on a DB2 table Q.PROFILES, you enter the following DB2I2 line objects as follows:

        TB Q.PROFILES

The following is the list of all the line objects you can enter:

JRH DB2I2 Line Object List
Line Object Abbr.	Line Object	Description
AC	active log line	from DSNJU004
AI	ixcreator.ixname partno row-count keycard	adjust index part line
AL	creator.name	Alias
AR	archive log line	from DSNJU004
AT	db.ts partno tbcreator.tbname row-count %compressed	adjust table part line
BP	buffername	Bufferpool
CI	catalog table insert line	from SELPATHV
CO	colname	Column name
CL	collid	Collection
CP	check point line	from DSNJU004
CU	catalog table update line	from SELPATHV
DB	dbname	Database Name
DM	planname.dbrm	DBRM name
DS	datasetname	DB2 VSAM dataset name
DT	schema.name	Distinct Type
FU	schema.name	DB2 function name
GV	&var=value	DB2I2 Global Variable
IC	indexcolumn	Index Column
IP	creator.name [partno]	Index Partition
IX	creator.name	Index
PG	[location].collid.name[.version]	Package name
PL	planname	Plan Name
RI	parent-creator.tbname.child-creator.tbname	Referential Integrity
RL	archive log RBA line	from DSNJU004
SC	[ssid[\loc].]dbname.tsname [ssid[\loc].]dbname.tsname [part#]	Tablespace Copyline for DSCOPY
SG	stogroupname	StoGroup name
SH	schema	Schema name
SP	schema.name	Stored Procedure
SY	creator.name	Synonyms name
TB	creator.name	Table name
TP	dbname.tsname [partno]	Table Partition
TR	schema.name	Trigger name
TS	dbname.tsname	Tablespace
US	username	User name
VL	volume	Volume name
VW	creator.name	View name
XC	[ssid[\loc].]ixcreator.ixname [ssid[\loc].]ixcreator.ixname [part#]	Index copyline for DSCOPY

(C)opyrighted 1997, 2008 By JRH Golden State Software Inc.