19.4.12 a_rdb_SQLNumParams() (acquire the number of dynamic parameters)

(1) Function

CLI function acquires the number of dynamic parameters in an SQL statement.

To Page Top

(2) Format

signed short a_rdb_SQLNumParams
(
  void                          *ConnectionHandle,    /* In  */
  void                          *StatementHandle,     /* In  */
  unsigned short                *ParameterCount,      /* Out */
  void                          *Option               /* In  */
)

To Page Top

(3) Arguments

ConnectionHandle

Specifies a connection handle.

StatementHandle

Specifies a statement handle.

ParameterCount

Specifies the address at which the number of dynamic parameters is to be stored.

Option

Specifies NULL.

To Page Top

(4) Return value

1. If a_rdb_SQLNumParams() terminates normally, a_rdb_RC_SQL_SUCCESS is returned.

2. If the number of dynamic parameters is acquired successfully, but the disk containing client message log files has become full, a_rdb_RC_SQL_WARNING is returned.

3. If an error occurs while messages cannot be output to the client message log file, the error cause code is returned. For details about the error cause code, see 19.8 Return values of the CLI functions.

To Page Top

(5) Notes

a_rdb_SQLNumParams() cannot be executed in the following cases:

• Connection has not been established.

• An invalid statement handle is specified.

To Page Top