Invoking isql and initializing the environment

StepsTo invoke isql and intialize the environment

  1. Enter the isql command on a 3270 terminal window to invoke the Open Client Environment window.

    When you open this window, it invokes isql.

  2. To set tracing, enter:

    • Y – to enable tracing.

      During the current isql session, each time you press Enter after keying a value in a window or typing a SQL command, the Trace/Error window displays trace information results.

    • N (or blank) – to proceed without tracing.

      When you press Enter after typing a value or SQL command, the SQL Result Display window displays results.

  3. To set whether to save results for browsing, enter:

    • Y – to save results to temporary storage.

      This allows you to scroll backward as well as forward through returned rows. Otherwise, you can scroll forward only.

    • N (or blank) – to proceed without saving results to temporary storage.

    Whether or not you save results, you can scroll left and right, if needed, to view the entire length of returned rows.b

Refer to Table 4-1 for isql function and action keys.