Starting interactive SQL

 

To start using interactive SQL, enter STRSQL from an i5/OS^® command line.

The Enter SQL Statements display appears. This is the main interactive SQL display. From this display, you can enter SQL statements and use:

• F4=prompt

• F13=Session services

• F16=Select collections

• F17=Select tables

• F18=Select columns

                             Enter SQL Statements  
Type SQL statement, press Enter.
    Current connection is to relational database rdjacque.
===>_____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
    _____________________________________________________________________
 
                                                                    Bottom F3=Exit   F4=Prompt   F6=Insert line   F9=Retrieve   F10=Copy line F12=Cancel            F13=Services     F24=More keys  

Press F24=More keys to view the remaining function keys.

     _____________________________________________________________________
     _____________________________________________________________________
     _____________________________________________________________________
     _____________________________________________________________________
 
                                                            Bottom  
F14=Delete line   F15=Split line     F16=Select collections (libraries)
F17=Select tables                    F18=Select columns   F24=More keys            (files)                              (fields)

If you are using the system naming convention, the names in parentheses appear instead of the names shown above.

An interactive session consists of:

• Parameter values you specified for the STRSQL command.

• SQL statements you entered in the session along with corresponding messages that follow each SQL statement

• Values of any parameters you changed using the session services function

• List selections you have made

Interactive SQL supplies a unique session-ID consisting of your user ID and the current workstation ID. This session-ID concept allows multiple users with the same user ID to use interactive SQL from more than one workstation at the same time. Also, more than one interactive SQL session can be run from the same workstation at the same time from the same user ID.

If an SQL session exists and is being re-entered, any parameters specified on the STRSQL command are ignored. The parameters from the existing SQL session are used.

 

Parent topic:

Using interactive SQL

 

Related reference

Start SQL Interactive Session (STRSQL) command