Entering content frame

Background documentation Parameters in SQL Statements Locate the document in its SAP Library structure

SQL statements for the database system can be embedded in program languages such as C and C++. In this way, a database instance can be accessed from the programs. The values that you want to query or save can be specified within the SQL statements using parameters. The parameters are declared as variables – or “host variables” – within the embedding program.

The data type of the host variables is specified in the programming language when they are declared. The values of the host variables are (if possible) implicitly converted from the programming language data type into the database system data type, and also in the other direction.

Each parameter can be combined with an indicator variable, which provides information about any irregularities that have arisen during allocation, such as differences in the length of the value and the parameter, ZERO values, or special ZERO values. Indicator variables are essential for specifying ZERO values and special ZERO values. Indicator variables are defined as variables within the embedding program.

See also:

Reference Manual, Parameter Name

 

 

 

Leaving content frame