Using a single row insert
The easiest way to load data into OpenText™ Analytics Database is to run an INSERT SQL statement using the SQLExecuteDirect function.
The easiest way to load data into OpenText™ Analytics Database is to run an INSERT SQL statement using the SQLExecuteDirect function. However this method is limited to inserting a single row of data.
ret = SQLExecDirect(hstmt, (SQLTCHAR*)"INSERT into Customers values"
"(1,'abcda','efgh','1')", SQL_NTS);