SaSQLExecDirect

SaSQLExecDirect

SaSQLExecDirect allows you to execute simple SQL statements such as CREATE TABLE, DROP TABLE, INSERT, and DELETE.

You cannot do SELECT operations because it is not possible to fetch the data.

Synopsis

SaRetT SA_EXPORT_H SaSQLExecDirect(SaConnectT* scon,
char *sqlstr)

Parameters

Parameters	Usage type	Description
scon	in, use	Pointer to a connection object.
sqlstr	in, use	Pointer to a string containing the SQL statement to execute.

Return value

SA_RC_SUCC

The possible error codes are as follows:

▪15001: SAP_ERR_SYNTAXERROR_SD. Syntax error: <error>, <line>.

▪15002: SAP_ERR_ILLCOLNAME_S. Illegal column name <name>.

▪15003: SAP_ERR_TOOMANYPARAMS. Too many parameters for string constraints.

▪15004: SAP_ERR_TOOFEWPARAMS. Too few parameters for string constraints.