Site navigation
Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase, DB2, & more.
/**********************************************************************
* FILENAME : ParseNativeSql.c
*
* DESCRIPTION :
* Simple example to execute SQLNativeSql(), which when
* passed a SQL string, returns an equivalent but maybe as
* modified by the driver
*
* ODBC USAGE :
* Prompts for SQL Statement
* SQLNativeSql - with statement entered
* Output statement returned by the driver
* For example:
*
* Passing - SELECT { fn CONVERT (emp, SQL_SMALLINT) }
* FROM employees
* May return - SELECT convert (smallint, emp) FROM employees
*
* The returned SQL string is driver dependent.
*/
#include <stdio.h>
#include <stdlib.h>
#include <sql.h>
#include <sqlext.h>
#include <string.h>
#include "util.c"
#define BUFF_LEN 255
main () {
SQLHENV henv = SQL_NULL_HENV; // Environment
SQLHDBC hdbc = SQL_NULL_HDBC; // Connection handle
SQLHSTMT hstmt = SQL_NULL_HSTMT; // Statement handle
SQLRETURN retcode;
SQLCHAR sqlStatementIN[BUFF_LEN];
SQLCHAR sqlStatementOUT[BUFF_LEN];
SQLINTEGER lenStatementOUT;
char reply=' ';
/* Allocate an environment handle */
retcode=SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
CHECK_ERROR(retcode, "SQLAllocHandle (SQL_HANDLE_ENV)",
henv, SQL_HANDLE_ENV);
/* We want ODBC 3 support */
retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,
(void *) SQL_OV_ODBC3, 0);
CHECK_ERROR(retcode, "SQLSetEnvAttr (SQL_ATTR_ODBC_VERSION)",
henv, SQL_HANDLE_ENV);
/* Allocate a connection handle */
retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
CHECK_ERROR(retcode, "SQLAllocHandle (SQL_HANDLE_DBC)",
hdbc, SQL_HANDLE_DBC);
// Set connection timeout
retcode = SQLSetConnectAttr(hdbc, SQL_LOGIN_TIMEOUT, (SQLPOINTER)5, 0);
CHECK_ERROR(retcode, "SQLSetConnectAttr (SQL_LOGIN_TIMEOUT)",
hdbc, SQL_HANDLE_DBC);
// Connect
retcode=SQLDriverConnect(hdbc, NULL, "DSN=DATASOURCE;",
SQL_NTS, NULL, 0, NULL, SQL_DRIVER_COMPLETE);
CHECK_ERROR(retcode, "SQLDriverConnect (DATASOURCE)",
hdbc, SQL_HANDLE_DBC);
memset (sqlStatementIN, ' ', BUFF_LEN);
memset (sqlStatementOUT,' ', BUFF_LEN);
getStr ("Enter SQL Statement", sqlStatementIN, BUFF_LEN, 'N');
retcode = SQLNativeSql (hdbc,
sqlStatementIN, strlen(sqlStatementIN),
sqlStatementOUT, BUFF_LEN,
&lenStatementOUT);
CHECK_ERROR(retcode, "SQLNativeSql (hdbc)", hdbc, SQL_HANDLE_DBC);
printf ("\nStatement IN : %s (Len %i)\n",
sqlStatementIN, (int) strlen(sqlStatementIN));
printf ("Statement OUT : %s (Len %i)\n",
sqlStatementOUT, (int) lenStatementOUT);
printf ("\nThe End.\n");
exit:
printf ("\nComplete.\n");
// Free handles
// Statement
if (hstmt != SQL_NULL_HSTMT)
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
// Connection
if (hdbc != SQL_NULL_HDBC) {
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
}
// Environment
if (henv != SQL_NULL_HENV)
SQLFreeHandle(SQL_HANDLE_ENV, henv);
return 0;
}
Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase, DB2, & more.