Session services description

 

You can change session attributes from the Session Services display. You can also print, clear, or save the session to a source file.

To access the Session Services display, press F13 (Services) on the Enter SQL Statements display.

Option 1 (Change session attributes) displays the Change Session Attributes display, which allows you to select the current values that are in effect for your interactive SQL session. The options shown on this display change based on the statement processing option selected.

The following session attributes can be changed:

• Commitment control attributes.

• The statement processing control.

• The SELECT output device.

• The list of schemas.

• The list type to select either all your system and SQL objects, or only your SQL objects.

• The data refresh option when displaying data.

• The allow copy data option.

• The naming option.

• The programming language.

• The date format.

• The time format.

• The date separator.

• The time separator.

• The decimal point representation.

• The SQL string delimiter.

• The sort sequence.

• The language identifier.

• The SQL rules.

• The CONNECT password option.

Option 2 (Print current session) accesses the Change Printer display, which lets you print the current session immediately and then continue working. You are prompted for printer information. All the SQL statements you entered and all the messages displayed are printed just as they appear on the Enter SQL Statements display.

Option 3 (Remove all entries from current session) lets you remove all the SQL statements and messages from the Enter SQL Statements display and the session history. You are prompted to ensure that you really want to delete the information.

Option 4 (Save session in source file) accesses the Change Source File display, which lets you save the session in a source file. You are prompted for the source file name. This function lets you embed the source file into a host language program by using the source entry utility (SEU).

Option 4 allows you to embed prototyped SQL statements in a high-level language (HLL) program that uses SQL. The source file created by option 4 may be edited and used as the input source file for the Run SQL Statements (RUNSQLSTM) command.

 

Parent topic:

Using interactive SQL