DB2 Server for VSE & VM: Interactive SQL Guide and Reference

Appendix C. Summary of ISQL PF Keys

Listed below is a summary of the default PF key functions:

PF1, PF13

Issues a HELP command, which retrieves an explanation of how to use HELP information and a list of the topics available.

PF2, PF14

Issues a START command, which starts the statement in the SQL command buffer (the current SQL statement).

PF3, PF15

Issues an END command.

PF4, PF16

Issues a PRINT command, which requests the currently displayed query result to be printed on the designated printer.

PF5, PF17

Issues a RECALL command, which displays the contents of the SQL command buffer.

PF6, PF18

Not assigned.

PF7, PF19

Issues a BACKWARD command, which moves your view of the query result backward one-half display.

PF8, PF20

Issues a FORWARD command, which moves your view of the query result forward one-half display.

PF9, PF21

Issues a HOLD command.

PF10, PF22

Issues a LEFT 1 command, which moves your view of the query result one column to the left.

PF11, PF23

Issues a RIGHT 1 command, which moves your view of the query result one column to the right.

PF12, PF24

Issues a RETRIEVE command, which displays the last input line from the SQL command buffer and places it in the input area. Each successive use of RETRIEVE retrieves an earlier input line. When there are no more lines in the SQL command buffer to be retrieved, the newest line (the last one entered in the buffer) is again retrieved.