Primary commands in File-AID for Db2 options

The File-AID for Db2 primary commands are entered in the COMMAND field. Whenever the action bar is active for a screen, you can also select the primary commands from the action bar pull-down menus. The following table shows primary command availability by function.

Primary command availability by function

Primary Command	Browse	Edit	Table Mode	Row Mode	SQL Analysis¹	Utilities	Relationships
ADD	x	x	x	x			x
BOTTOM-BOT	x	x	x	x	x	x	x
BROWSE-BRO	x	x	x	x	x	x
CANCEL-CAN	x	x	x	x	x	x	x
CAPS	x	x	x	x
CHANGE-C		x	x	x
CUT-CU		x	x
DELETE-DEL		x		x
DOWN	x	x	x	x	x	x	x
E	x	x		x
EDIT-ED	x	x	x	x		x
END	x	x	x	x	x	x	x
EXCLUDE-X	x	x	x
EXECUTE-EXEC						x
EXPAND	x	x	x			x
FADB2					x
FIND-F	x	x	x	x			x
FLIP	x	x	x
GO-G						x	x
GRAPHIC-GR	x	x	x	x			x
HELP	x	x	x	x	x	x	x
HEX	x	x		x
HIDE	x	x	x	x
HOLD	x	x	x	x
INFO	x	x	x	x	x	x	x
INSERT-INS		x		x
JUMP-J	x	x	x	x
KEYLIST							x
KEYS	x	x	x	x	x	x	x
LEFT	x	x	x		x
LOCATE-L	x	x	x	x		x	x
MAX	x	x	x	x
MAXCOL	x	x	x	x
MEMORY-MEM	x	x
MIN	x	x
MODE						x	x
NEXT-N	x	x		x
PASTE-PAS		x	x
PATH	x	x	x	x
PREV-P	x	x		x
PRINTDS-PRTDS	x	x	x	x
PRINTP-PRTP	x	x	x	x
PROFILE-PRO	x	x	x	x
RBROWSE-RB	x	x	x	x
RCHANGE		x	x	x
REDIT-RE	x	x	x	x
REPEAT-REP		x		x
RESET-RES	x	x	x	x
RETRIEVE	x	x	x	x	x	x	x
RFIND	x	x	x	x
RI ²		x		x
RIGHT	x	x	x		x
ROW	x	x	x
ROWH	x	x	x
SAVE		x	x	x	x
SCHEMA ³					x
SIZE	x	x				x
SORT	x	x	x	x	x	x	x
SPLIT	x	x	x	x	x	x	x
SQL	x	x			x	x
SQLID	x	x	x	x	x	x	x
SWAP	x	x	x	x	x	x	x
TABLE-TAB	x	x		x
TEMPLATE-TEMP	x	x
TOP	x	x	x	x	x	x	x
UDT	x	x	x	x		x	x
UDTSWAP						x	x
UDTTYPE						x	x
UP	x	x	x	x	x	x	x
V	x	x		x
WRAP	x	x	x
XLOB	x	x		x
ZOOM	x	x	x
ZOOMH	x	x	x

¹ Unless otherwise noted, commands are available in SQL Source Analysis only.

2 Valid only from the RI Browse window.

3 Valid only from the SQL Plan Analysis option.

Important

The following commands have been replaced by the Object Administration utility: ALTER, ATOMIC, COLCHECK, CREATE, DEFAULT, FOREIGN, GRANT, IDENTITY, MODIFY, NAMCHECK, PARMS, PARTITN, PRIMARY, REMARKS, RETPARM, REVOKE, RUNOPTS, SRCPARM, UDFOPTS, VALUES and WHENCOND. Refer to File-Aid for Db2 Object Administration User Reference for more information.

Primary commands in File-AID for Db2 options

On this page