HP NonStop SQL/MP User Manual

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for C—429847-008
5-21
SQLSADISPLAY
C compiler automatically declares the SQLCA structure if you specify the
INCLUDE SQLCA directive. If you omit the SQLCA name, the display does not
contain the procedure name and process name of the caller.
output_file_number
is the output file number. If you omit this value or set it to a negative value,
SQLSADISPLAY displays information at your home terminal. NonStop SQL/MP
ignores this parameter if detail_params specifies sequential I/O (SIO).
detail_params
determines whether the program uses sequential I/O (SIO) or Enscribe I/O to write
to the output file. The parameter detail_params points to a structure with this
layout:
struct detail_params_type
{
char sio;
short *out_fcb_1;
short *out_fcb_2;
} detail_params;
sio
specifies whether sequential I/O (SIO) is used:
outfcb1
specifies the first output file control block if SIO is enabled.
outfcb2
specifies the second output file control block if SIO is enabled. To use
outfcb2, assign it a value greater than 0.
If you omit detail_params, Enscribe I/O is the default.
Example of the SQLSADISPLAY Display
SQLSADISPLAY displays statistics in this format:
SQL statistics @ \system.$vol.subvol.file.#line process cpu,pin
Records Records Disc Message Message Lock
Table Name Accessed Used Reads Count Bytes WE
Y Use SIO; ignore output_file_number.
N Do not use SIO; write to output_file_number.

HP NonStop SQL/MP Specifications

General

Platform	HP NonStop Servers
Data Model	Relational
SQL Standard	ANSI SQL
Concurrency Control	Multi-Version Concurrency Control (MVCC)
Fault Tolerance	Yes
High Availability	Yes
Category	Database Software
Initial Release	1980s
Operating System	HP NonStop OS
License	Proprietary
Type	Relational Database Management System
Transaction Management	ACID Compliance
Developer	Hewlett Packard Enterprise

Summary

1. Introduction

Developing a C Program

Outlines the process of creating C programs with embedded SQL statements.

Dynamic SQL

Describes how to construct, compile, and run SQL statements at runtime.

2. Host Variables

3. SQL/MP Statements and Directives

4. Data Retrieval and Modification

Single-Row SELECT Statement

Retrieves a single row of data from tables or views into host variables.

Multirow SELECT Statement

Returns multiple rows from tables or views, one row at a time, using cursors.

INSERT Statement

Inserts one or more rows into a table or protection view using host variables.

Using SQL Cursors

Explains how to use named pointers to access sets of rows one at a time.

5. SQL/MP System Procedures

6. Explicit Program Compilation

Explicit Program Compilation

Outlines the general steps for compiling C programs with embedded SQL.

Developing a C Program in the Guardian Environment

Details C program development within the Guardian environment.

Developing a C Program in the OSS Environment

Developing a C Program in a PC Host Environment

7. Program Execution

Required Access Authority

Specifies the access permissions needed to run NonStop SQL program files.

Entering the TACL RUN Command

Running a Program in the OSS Environment

8. Program Invalidation and Automatic SQL Recompilation

Program Invalidation

Explains how SQL program files can become invalid due to changes or errors.

Causes of Program Invalidation

Automatic SQL Recompilation

Describes the run-time recompilation process invoked by the SQL executor.

9. Error and Status Reporting

Returning Error and Warning Information

Using the WHENEVER Directive

10. Dynamic SQL Operations

Uses for Dynamic SQL

Identifies scenarios where dynamic SQL programs are beneficial.

Dynamic SQL Statements

Summarizes dynamic SQL statements usable in a C program.

Dynamic SQL Features

11. Character Processing Rules (CPRL) Procedures

Appendix B: Memory Considerations

Estimating Memory Requirements

Avoiding Memory Stack Overflows

Provides guidelines to prevent stack overflows for SQL statements.