[color=#cb082f]There are a number of ISQL commands that most people never use or have ever seen.
When you are on the ISQL screen just use a ? to see commands available on the current panel.
Actually you can do this in various products and many of their panels (they can vary from panel to panel).
[color]
[font=Courier New]COMMAND ===> ? <enter>[font]
[color=#cb082f]Results in this:[color]
[font=Courier New]
PTPGLBL --------------- Primary Command Display -------------- 2013/05/29
COMMAND ===> SCROLL ===>
S COMMAND COMMAND DESCRIPTION
PANEL SPECIFIC COMMANDS
_ Caps - Switch the display between CAPS lock on and off
_ COLS - Switch the display of table column information on/off
? DCOPY - Copy a member of a PDS or a sequential dataset
_ DCREATE - Create a new member of a PDS
_ DREPLACE - Replace a member of a PDS or a sequential dataset
_ ESQL - Display the RC/SQL Online/Batch SQL Execution panel
_ EXPLain - Explain the sql statement
_ EXPLOPTS - Set explain options and explain the sql statement.
_ Header - Switch the display of the panel header on or off
_ ISPFEDIT - Invoke ISPF editor
_ Nulls - Toggle the display between NULLS on and off
_ PARSE - Parse SQL for special characters
_ PRED - Perform predicate analysis on the sql statement
_ RESet - Remove msg lines and pending line commands from screen.
_ STAND - Reformat the sql into a standard form
_ SYNTAX - Syntax check the sql statement
_ TE - Text Enter: format the display for power typing
_ WS - Word Split: separate the SQL text into tokens
_ WW - Word Wrap: reflow fragmented text into uniform lines [font]
[color=#cb082f]Underlined ones above I've found particularly useful.
Now you can put a '[size=5]S[size]'elect on any of those lines to execute them
or
put a '[size=5]?[size]' on the line to get a more detailed description. DCOPY for example.[color]
[font=Courier New]PTHECMDF ------------- CA-DB2 Help Facility ------------- 2013/05/29 13:15:25
Command ===>
COMMAND : DCOPY
DESCRIPTION : The DCOPY command allows you to import a member of a PDS or
sequential dataset into the RC/SQL Editor.
To use the command, you must specify where in the SQL Editor you
want the member imported using the A (After) or B (Before) line
command; then enter the DCOPY command in the command area and
press <Enter>.
You can specify the dataset and member to be copied in the
command syntax, if desired. For example,
DCOPY 'TDKATR.KAT.TEST(MEMBER1)'. If you do not specify a member
name, a member selection list will be displayed. If you do not
specify a dataset, the SQL Editor Copy screen will appear.
SYNTAX : DCOPY {'datasetname(member)'}
ABBREVIATION: DCOPY [font]
[color=#cb082f]Remember that once you learn the command you can just enter it directly.[color]
[font=Courier New]COMMAND ===> DCOPY 'MY.SQL.LIB(RTSSTATS)'[font]