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

Using PF Keys in CMS FULLSCREEN Mode (DB2 Server for VM)

If you are using ISQL in CMS FULLSCREEN mode, you may want to reset the functions of some PF keys. You can reset your keys by executing a routine. The routine can be a PROFILE routine which is executed automatically every time you start ISQL. To reset the PF key functions, you can include the following example commands in the routine:

     CMS
     SET LINEND OFF
     SET CMSPF 07 BACKWARD NOECHO #WM SCROLL BACKWARD CMS 1
     SET CMSPF 08 FORWARD NOECHO #WM SCROLL FORWARD CMS 1
     SET LINEND ON
     RETURN

This addition to your routine lets you use PF7 and PF8 in ISQL command mode to scroll forward and backward in a manner similar to the CMS FULLSCREEN mode.

For information about creating and running routines, see Chapter 7, Creating and Using Routines.

You can also reset the PF keys every time you use ISQL. For more information on resetting the PF keys, see Routines to Which Parameters Can Be Passed (DB2 Server for VM).