SQL Programming Manual for TAL

System Procedures

HP NonStop SQL Programming Manual for TAL—527887-001

4-24

SQLSADISPLAY

Figure 4-1 shows an example of the information that SQLSADISPLAY displays at the

home terminal. To generate this display, a program must:

1. Include the SQLSA and SQLCA structures.

2. Execute an SQL DML statement.

3. Call the SQLSADISPLAY procedure:

CALL SQLSADISPLAY (sqlsa, sqlca);

Figure 4-1. SQLSADISPLAY Display

SQL statistics @ \sanfran.$system.accts.prog10.#333.2 process 12,255

Table Name

Records

Accessed

Records

Used

Disc

Reads

Message

Count

Message

Bytes

Lock WE

\sanfran.$sqlvol.accts.tab20

110 100 w

\sanfran.$vol001.fy91.employee

9987231

1 99999 1 100 e

\sanfran.$sqlvol.accts.tab10

123 22 3 10

3245

VST0401.vsd