ODBC Server Reference Manual

Stored Procedures
HP NonStop ODBC Server Reference Manual—429151-002
5-36
SPELIB Interface
SP_SRV_ENCODE_ROW_DATA
This function encodes a row of data of the result set generated by the execution of the
stored procedure. This function cannot be used until a call to
SP_SRV_ENCODE_ROW_DESCR has been successfully completed for that result
set.
env
input
is a pointer to the environment object STRUCT.
sqlda
output
is a pointer to a SQL descriptor area containing the row data to be returned. The
caller should set up the SQLDA as if it were the output from a DYNAMIC FETCH
statement.
SP_SRV_ENCODE_SQL_DIAGNOSTIC
This function encodes the diagnostic structure of the SQL communications area
(SQLCA). This enables the server to report SQL errors, warnings, and any information
associated with the execution attempt.
env
input
is a pointer to the environment object STRUCT.
sqlca
input
is a pointer to a SQL communications area.
num-levels
input
specifies the number of error levels/entries from the SQLCA to be packed into the
IPC. Normally, two entries will be sufficient.
short int SP_SRV_ENCODE_ROW_DATA
( void * env
, void * sqlda
)
short int SP_SRV_ENCODE_SQL_DIAGNOSTIC
( void * env
, void * sqlca
, short int num-levels
)