Appendix A. Sample Codes#
The following describes notes on programming the client using the Altibase CLI and frequent errors:
Programing Considerations#
The following describes notes on programming the client using the Altibase CLI and frequent errors:
Binding Parameters#
Note on using the last argument, valueLength(indicator), upon calling SQLBindCol() and SQLBindParameter().
In case the value fetched by the output argument in SQLBindCol() is NULL, SQL_NULL_DATA will be returned to the indicator argument.
The valueLength of SQLBindParameter() is used to indicate the length of the buffer when the data type of the argument bound to the input buffer is the variable type. (When the parameter inout type is SQL_PARAM_INOUT)
For example, the user can specify the following values for valueLength:
- SQL_NTS
A string in which the buffer ends with NULL ( '\0' ) - SQL_NULL_DATA
Binding the NULL value - Result of the SQL_DATA_AT_EXEC or SQL_LEN_DATA_AT_EXEC() macro
This means that data will be inserted using a combination of SQLPutData() and SQLParamData(). SQLExecute() returns SQL_NEED_DATA when executed.
When SQLBindParameter() specifies the input/output type in SQL_PARAM_OUTPUT valueLength is equivalent to valueLength of the SQLBindCol() function used when executing a SELECT statement. Play the same role.
Transaction Commit Mode#
All transactions that are not committed when an application program is terminated in an autocommit off session are rolled back by the Altibase server. However, the Altibase server commits the transactions which were not committed if the application program is terminated after SQLDisconnect() was called.
Using SQLFreeStmt() function#
If the second argument is SQL_DROP in SQLFreeStmt(), the status of the handle will be changed into the previous status before the handle was allocated. however, when SQL_CLOSE argument is used, the handle status after SQLAllocStmt() is executed will be selected and can be used for other queries. In case the command executes SQLPrepare(), the status will be changed into the preparation status after SQLFreeStmt() is called by SQL_CLOSE.
In case SELECT statement is executed by SQLPrepare(). Execution result of SELECT statement upon changing from SQLExecute() to SQLFetch(). When SQLExecute() is called again by binding other hosts variables without fetching untill the last record of the result set, "invalid cursor state" may occur. To prevent this, the user must call SQLFreeStmt ( .. , SQL_CLOSE ) and SQLExecute(). However, if SQLFetch() was executed until the last record in the execution result of SELECT statement, SQLFreeStmt() of SQL_CLOSE does not need to be called for normal operation.
Sample of Simple Basic Program#
/***********************************************
** File name = demo_ex1.cpp
***********************************************/
#include <sqlcli.h>
#include <stdio.h>
#include <stdlib.h>
#define SQL_LEN 1000
#define MSG_LEN 1024
SQLHENV env; // Environment Handle
SQLHDBC dbc; // Connection Handle
int conn_flag;
SQLRETURN alloc_handle();
SQLRETURN db_connect();
void free_handle();
SQLRETURN execute_select();
void execute_err(SQLHDBC aCon, SQLHSTMT aStmt, char* q);
int main()
{
SQLRETURN rc;
env = SQL_NULL_HENV;
dbc = SQL_NULL_HDBC;
conn_flag = 0;
/* allocate handle */
rc = alloc_handle();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
/* Connect to Altibase Server */
rc = db_connect();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
rc = execute_select();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
free_handle();
}
static void print_diagnostic(SQLSMALLINT aHandleType, SQLHANDLE aHandle)
{
SQLRETURN rc;
SQLSMALLINT sRecordNo;
SQLCHAR sSQLSTATE[6];
SQLCHAR sMessage[2048];
SQLSMALLINT sMessageLength;
SQLINTEGER sNativeError;
sRecordNo = 1;
while ((rc = SQLGetDiagRec(aHandleType,
aHandle,
sRecordNo,
sSQLSTATE,
&sNativeError,
sMessage,
sizeof(sMessage),
&sMessageLength)) != SQL_NO_DATA)
{
printf("Diagnostic Record %d\n", sRecordNo);
printf(" SQLSTATE : %s\n", sSQLSTATE);
printf(" Message text : %s\n", sMessage);
printf(" Message len : %d\n", sMessageLength);
printf(" Native error : 0x%X\n", sNativeError);
if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO)
{
break;
}
sRecordNo++;
}
}
void execute_err(SQLHDBC aCon, SQLHSTMT aStmt, char* q)
{
printf("Error : %s\n",q);
if (aStmt == SQL_NULL_HSTMT)
{
if (aCon != SQL_NULL_HDBC)
{
print_diagnostic(SQL_HANDLE_DBC, aCon);
}
}
else
{
print_diagnostic(SQL_HANDLE_STMT, aStmt);
}
}
SQLRETURN alloc_handle()
{
/* allocate Environment handle */
if (SQLAllocEnv(&env) != SQL_SUCCESS)
{
printf("SQLAllocEnv error!!\n");
return SQL_ERROR;
}
/* allocate Connection handle */
if (SQLAllocConnect(env, &dbc) != SQL_SUCCESS)
{
printf("SQLAllocConnect error!!\n");
return SQL_ERROR;
}
return SQL_SUCCESS;
}
void free_handle()
{
if ( conn_flag == 1 )
{
/* close connection */
SQLDisconnect( dbc );
}
/* free connection handle */
if ( dbc != NULL )
{
SQLFreeConnect( dbc );
}
if ( env != NULL )
{
SQLFreeEnv( env );
}
}
SQLRETURN db_connect()
{
char *USERNAME = "SYS"; // user name
char *PASSWD = "MANAGER"; // user password
char *NLS = "US7ASCII"; // NLS_USE ( KO16KSC5601, US7ASCII )
char connStr[1024];
sprintf(connStr,
"DSN=127.0.0.1;UID=%s;PWD=%s;CONNTYPE=%d;NLS_USE=%s", /* ;PORT_NO=20300", */
USERNAME, PASSWD, 1, NLS);
/* establish connection */
if (SQLDriverConnect( dbc, NULL, (SQLCHAR *)connStr, SQL_NTS,
NULL, 0, NULL,
SQL_DRIVER_NOPROMPT ) != SQL_SUCCESS)
{
execute_err(dbc, SQL_NULL_HSTMT, "SQLDriverConnect");
return SQL_ERROR;
}
conn_flag = 1;
return SQL_SUCCESS;
}
SQLRETURN execute_select()
{
SQLHSTMT stmt = SQL_NULL_HSTMT;
SQLRETURN rc;
int i;
char query[SQL_LEN];
SQLSMALLINT columnCount;
char columnName[50];
SQLSMALLINT columnNameLength;
SQLSMALLINT dataType;
SQLSMALLINT scale;
SQLSMALLINT nullable;
SQLULEN columnSize;
void **columnPtr;
SQLLEN *columnInd;
/* allocate Statement handle */
if (SQL_ERROR == SQLAllocStmt(dbc, &stmt))
{
printf("SQLAllocStmt error!!\n");
return SQL_ERROR;
}
sprintf(query,"SELECT * FROM DEMO_EX1");
if (SQLExecDirect(stmt, (SQLCHAR *)query, SQL_NTS) != SQL_SUCCESS)
{
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
SQLNumResultCols(stmt, &columnCount);
columnPtr = (void**) malloc( sizeof(void*) * columnCount );
columnInd = (SQLLEN*) malloc( sizeof(SQLLEN) * columnCount );
if ( columnPtr == NULL )
{
return SQL_ERROR;
}
for ( i=0; i<columnCount; i++ )
{
SQLDescribeCol(stmt, i+1,
(SQLCHAR *)columnName, sizeof(columnName), &columnNameLength,
&dataType, &columnSize, &scale, &nullable);
printf("columnName = %s, nullable = %d\n", columnName, nullable);
switch (dataType)
{
case SQL_CHAR:
printf("%s : CHAR(%d)\n", columnName, columnSize);
columnPtr[i] = (char*) malloc( columnSize + 1 );
SQLBindCol(stmt, i+1, SQL_C_CHAR, columnPtr[i], columnSize+1, &columnInd[i]);
break;
case SQL_VARCHAR:
printf("%s : VARCHAR(%d)\n", columnName, columnSize);
columnPtr[i] = (char*) malloc( columnSize + 1 );
SQLBindCol(stmt, i+1, SQL_C_CHAR, columnPtr[i], columnSize+1, &columnInd[i]);
break;
case SQL_INTEGER:
printf("%s : INTEGER\n", columnName);
columnPtr[i] = (int*) malloc( sizeof(int) );
SQLBindCol(stmt, i+1, SQL_C_SLONG, columnPtr[i], 0, &columnInd[i]);
break;
case SQL_SMALLINT:
printf("%s : SMALLINT\n", columnName);
columnPtr[i] = (short*) malloc( sizeof(short) );
SQLBindCol(stmt, i+1, SQL_C_SSHORT, columnPtr[i], 0, &columnInd[i]);
break;
case SQL_NUMERIC:
printf("%s : NUMERIC(%d,%d)\n", columnName, columnSize, scale);
columnPtr[i] = (double*) malloc( sizeof(double) );
SQLBindCol(stmt, i+1, SQL_C_DOUBLE, columnPtr[i], 0, &columnInd[i]);
break;
case SQL_TYPE_TIMESTAMP:
printf("%s : DATE\n", columnName);
columnPtr[i] = (SQL_TIMESTAMP_STRUCT*) malloc( sizeof(SQL_TIMESTAMP_STRUCT) );
SQLBindCol(stmt, i+1, SQL_C_TYPE_TIMESTAMP, columnPtr[i], 0, &columnInd[i]);
break;
}
}
/* fetches next rowset of data from the result set and print to stdout */
printf("==========================================================================\n");
while ( (rc = SQLFetch(stmt)) != SQL_NO_DATA)
{
if ( rc != SQL_SUCCESS )
{
execute_err(dbc, stmt, query);
break;
}
for ( i=0; i<columnCount; i++ )
{
SQLDescribeCol(stmt, i+1,
NULL, 0, NULL,
&dataType, NULL, NULL, NULL);
if ( columnInd[i] == SQL_NULL_DATA )
{
printf("NULL\t");
continue;
}
switch (dataType)
{
case SQL_CHAR:
case SQL_VARCHAR:
printf("%s\t", columnPtr[i]);
break;
case SQL_INTEGER:
printf("%d\t", *(int*)columnPtr[i]);
break;
case SQL_SMALLINT:
printf("%d\t", *(short*)columnPtr[i]);
break;
case SQL_NUMERIC:
printf("%10.3f\t", *(double*)columnPtr[i]);
break;
case SQL_TYPE_TIMESTAMP:
printf("%4d/%02d/%02d %02d:%02d:%02d\t",
((SQL_TIMESTAMP_STRUCT*)columnPtr[i])->year,
((SQL_TIMESTAMP_STRUCT*)columnPtr[i])->month,
((SQL_TIMESTAMP_STRUCT*)columnPtr[i])->day,
((SQL_TIMESTAMP_STRUCT*)columnPtr[i])->hour,
((SQL_TIMESTAMP_STRUCT*)columnPtr[i])->minute,
((SQL_TIMESTAMP_STRUCT*)columnPtr[i])->second);
break;
}
}
printf("\n");
}
SQLFreeStmt(stmt, SQL_DROP);
for ( i=0; i<columnCount; i++ )
{
free( columnPtr[i] );
}
free( columnPtr );
free( columnInd );
return SQL_SUCCESS;
}
Sample of Using Metadata#
/***********************************************
** File name = demo_meta1.cpp
** Meta data search program example
************************************************/
#include <sqlcli.h>
#include <stdio.h>
#include <stdlib.h>
#define SQL_LEN 1000
#define MSG_LEN 1024
SQLHENV env; // Environment Handle
SQLHDBC dbc; // Connection Handle
int conn_flag;
SQLRETURN alloc_handle();
SQLRETURN db_connect();
void free_handle();
SQLRETURN get_tables();
void execute_err(SQLHDBC aCon, SQLHSTMT aStmt, char* q);
int main()
{
SQLRETURN rc;
env = SQL_NULL_HENV;
dbc = SQL_NULL_HDBC;
conn_flag = 0;
/* allocate handle */
rc = alloc_handle();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
/* Connect to Altibase Server */
rc = db_connect();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
rc = get_tables();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
free_handle();
}
static void print_diagnostic(SQLSMALLINT aHandleType, SQLHANDLE aHandle)
{
SQLRETURN rc;
SQLSMALLINT sRecordNo;
SQLCHAR sSQLSTATE[6];
SQLCHAR sMessage[2048];
SQLSMALLINT sMessageLength;
SQLINTEGER sNativeError;
sRecordNo = 1;
while ((rc = SQLGetDiagRec(aHandleType,
aHandle,
sRecordNo,
sSQLSTATE,
&sNativeError,
sMessage,
sizeof(sMessage),
&sMessageLength)) != SQL_NO_DATA)
{
printf("Diagnostic Record %d\n", sRecordNo);
printf(" SQLSTATE : %s\n", sSQLSTATE);
printf(" Message text : %s\n", sMessage);
printf(" Message len : %d\n", sMessageLength);
printf(" Native error : 0x%X\n", sNativeError);
if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO)
{
break;
}
sRecordNo++;
}
}
void execute_err(SQLHDBC aCon, SQLHSTMT aStmt, char* q)
{
printf("Error : %s\n",q);
if (aStmt == SQL_NULL_HSTMT)
{
if (aCon != SQL_NULL_HDBC)
{
print_diagnostic(SQL_HANDLE_DBC, aCon);
}
}
else
{
print_diagnostic(SQL_HANDLE_STMT, aStmt);
}
}
SQLRETURN alloc_handle()
{
/* allocate Environment handle */
if (SQLAllocEnv(&env) != SQL_SUCCESS)
{
printf("SQLAllocEnv error!!\n");
return SQL_ERROR;
}
/* allocate Connection handle */
if (SQLAllocConnect(env, &dbc) != SQL_SUCCESS)
{
printf("SQLAllocConnect error!!\n");
return SQL_ERROR;
}
return SQL_SUCCESS;
}
void free_handle()
{
if ( conn_flag == 1 )
{
/* close connection */
SQLDisconnect( dbc );
}
/* free connection handle */
if ( dbc != NULL )
{
SQLFreeConnect( dbc );
}
if ( env != NULL )
{
SQLFreeEnv( env );
}
}
SQLRETURN db_connect()
{
char *USERNAME = "SYS"; // user name
char *PASSWD = "MANAGER"; // user password
char *NLS = "US7ASCII"; // NLS_USE ( KO16KSC5601, US7ASCII )
char connStr[1024];
sprintf(connStr,
"DSN=127.0.0.1;UID=%s;PWD=%s;CONNTYPE=%d;NLS_USE=%s", /* ;PORT_NO=20300", */
USERNAME, PASSWD, 1, NLS);
/* establish connection */
if (SQLDriverConnect( dbc, NULL, (SQLCHAR *) connStr, SQL_NTS,
NULL, 0, NULL,
SQL_DRIVER_NOPROMPT ) != SQL_SUCCESS)
{
execute_err(dbc, SQL_NULL_HSTMT, "SQLDriverConnect");
return SQL_ERROR;
}
conn_flag = 1;
return SQL_SUCCESS;
}
SQLRETURN get_tables()
{
SQLHSTMT stmt = SQL_NULL_HSTMT;
SQLRETURN rc;
char schem[50+1] = {0};
char name[50+1] = {0};
char type[50+1] = {0};
SQLLEN schem_ind;
SQLLEN name_ind;
SQLLEN type_ind;
/* allocate Statement handle */
if (SQL_ERROR == SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt))
{
printf("SQLAllocHandle error!!\n");
return SQL_ERROR;
}
if (SQLTables(stmt,
NULL, 0,
NULL, 0,
NULL, 0,
NULL, 0) != SQL_SUCCESS)
{
execute_err(dbc, stmt, "SQLTables");
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
if (SQLBindCol(stmt, 2, SQL_C_CHAR,
schem, sizeof(schem), &schem_ind) != SQL_SUCCESS)
{
execute_err(dbc, stmt, "SQLBindCol");
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
if (SQLBindCol(stmt, 3, SQL_C_CHAR,
name, sizeof(name), &name_ind) != SQL_SUCCESS)
{
execute_err(dbc, stmt, "SQLBindCol");
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
if (SQLBindCol(stmt, 4, SQL_C_CHAR,
type, sizeof(type), &type_ind) != SQL_SUCCESS)
{
execute_err(dbc, stmt, "SQLBindCol");
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
/* fetches the next rowset of data from the result set and print to stdout */
printf("TABLE_SCHEM\t\tTABLE_NAME\t\tTABLE_TYPE\n");
printf("=============================================================\n");
while ( (rc = SQLFetch(stmt)) != SQL_NO_DATA)
{
if ( rc == SQL_ERROR )
{
execute_err(dbc, stmt, "SQLFetch");
break;
}
printf("%-40s%-40s%s\n", schem, name, type);
}
SQLFreeHandle(SQL_HANDLE_STMT, stmt);/* == SQLFreeStmt(stmt, SQL_DROP); */
return SQL_SUCCESS;
}
Example of Procedure Test Program#
/***********************************************
** File name = demo_ex6.cpp
** Example of procedure test program
************************************************/
#include <sqlcli.h>
#include <stdio.h>
#include <stdlib.h>
#define SQL_LEN 1000
#define MSG_LEN 1024
SQLHENV env; // Environment Handle
SQLHDBC dbc; // Connection Handle
int conn_flag;
SQLRETURN alloc_handle();
SQLRETURN db_connect();
void free_handle();
SQLRETURN execute_proc();
SQLRETURN execute_select();
void execute_err(SQLHDBC aCon, SQLHSTMT aStmt, char* q);
int main()
{
SQLRETURN rc;
env = SQL_NULL_HENV;
dbc = SQL_NULL_HDBC;
conn_flag = 0;
/* allocate handle */
rc = alloc_handle();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
/* Connect to Altibase Server */
rc = db_connect();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
/* select data */
rc = execute_select();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
/* procedure execution */
rc = execute_proc();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
/* select data */
rc = execute_select();
if ( rc != SQL_SUCCESS )
{
free_handle();
exit(1);
}
/* disconnect, free handles */
free_handle();
}
void execute_err(SQLHDBC aCon, SQLHSTMT aStmt, char* q)
{
SQLINTEGER errNo;
SQLSMALLINT msgLength;
SQLCHAR errMsg[MSG_LEN];
printf("Error : %s\n",q);
if (SQLError ( SQL_NULL_HENV, aCon, aStmt,
NULL, &errNo,
errMsg, MSG_LEN, &msgLength ) == SQL_SUCCESS)
{
printf(" Error : # %ld, %s\n", errNo, errMsg);
}
}
SQLRETURN alloc_handle()
{
/* allocate Environment handle */
if (SQLAllocEnv(&env) != SQL_SUCCESS)
{
printf("SQLAllocEnv error!!\n");
return SQL_ERROR;
}
/* allocate Connection handle */
if (SQLAllocConnect(env, &dbc) != SQL_SUCCESS)
{
printf("SQLAllocConnect error!!\n");
return SQL_ERROR;
}
return SQL_SUCCESS;
}
void free_handle()
{
if ( conn_flag == 1 )
{
/* close connection */
SQLDisconnect( dbc );
}
/* free connection handle */
if ( dbc != NULL )
{
SQLFreeConnect( dbc );
}
if ( env != NULL )
{
SQLFreeEnv( env );
}
}
SQLRETURN db_connect()
{
char *USERNAME = "SYS"; // user name
char *PASSWD = "MANAGER"; // user password
char *NLS = "US7ASCII"; // NLS_USE ( KO16KSC5601, US7ASCII )
char connStr[1024];
sprintf(connStr,
"DSN=127.0.0.1;UID=%s;PWD=%s;CONNTYPE=%d;NLS_USE=%s", /* ;PORT_NO=20300", */
USERNAME, PASSWD, 1, NLS);
/* establish connection */
if (SQLDriverConnect( dbc, NULL, (SQLCHAR *) connStr, SQL_NTS,
NULL, 0, NULL,
SQL_DRIVER_NOPROMPT ) != SQL_SUCCESS)
{
execute_err(dbc, SQL_NULL_HSTMT, "SQLDriverConnect");
return SQL_ERROR;
}
conn_flag = 1;
return SQL_SUCCESS;
}
SQLRETURN execute_select()
{
SQLHSTMT stmt = SQL_NULL_HSTMT;
SQLRETURN rc;
char query[SQL_LEN];
SQLINTEGER id;
char name[20+1];
SQL_TIMESTAMP_STRUCT birth;
/* allocate Statement handle */
if (SQL_ERROR == SQLAllocStmt(dbc, &stmt))
{
printf("SQLAllocStmt error!!\n");
return SQL_ERROR;
}
sprintf(query,"SELECT * FROM DEMO_EX6");
if (SQLPrepare(stmt, (SQLCHAR *)query, SQL_NTS) != SQL_SUCCESS)
{
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
/* binds application data buffers to columns in the result set */
if (SQLBindCol(stmt, 1, SQL_C_SLONG,
&id, 0, NULL) != SQL_SUCCESS)
{
printf("SQLBindCol error!!!\n");
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
if (SQLBindCol(stmt, 2, SQL_C_CHAR,
name, sizeof(name), NULL) != SQL_SUCCESS)
{
printf("SQLBindCol error!!!\n");
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
if (SQLBindCol(stmt, 3, SQL_C_TYPE_TIMESTAMP,
&birth, 0, NULL) != SQL_SUCCESS)
{
printf("SQLBindCol error!!!\n");
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
/* fetches the next rowset of data from the result set and print to stdout */
printf("id\t Name\tbirth\n");
printf("=====================================================================\n");
if ( SQLExecute(stmt) != SQL_SUCCESS )
{
execute_err(dbc, stmt, "SQLExecute : ");
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
while ( (rc = SQLFetch(stmt)) != SQL_NO_DATA )
{
if ( rc != SQL_SUCCESS )
{
execute_err(dbc, stmt, query);
break;
}
printf("%d%20s\t%4d/%02d/%02d %02d:%02d:%02d\n",
id, name, birth.year, birth.month, birth.day,
birth.hour, birth.minute, birth.second);
}
SQLFreeStmt(stmt, SQL_DROP);
return SQL_SUCCESS;
}
SQLRETURN execute_proc()
{
SQLHSTMT stmt = SQL_NULL_HSTMT;
char query[SQL_LEN];
SQLINTEGER id;
char name[20+1];
SQL_TIMESTAMP_STRUCT birth;
SQLINTEGER ret = 0;
SQLLEN name_ind = SQL_NTS;
/* allocate Statement handle */
if (SQL_ERROR == SQLAllocStmt(dbc, &stmt))
{
printf("SQLAllocStmt error!!\n");
return SQL_ERROR;
}
sprintf(query,"EXEC DEMO_PROC6( ?, ?, ?, ? )");
/* prepares an SQL string for execution */
if (SQLPrepare(stmt, (SQLCHAR *) query, SQL_NTS) != SQL_SUCCESS)
{
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
if (SQLBindParameter(stmt,
1, /* Parameter number, starting at 1 */
SQL_PARAM_INPUT, /* in, out, inout */
SQL_C_SLONG, /* C data type of the parameter */
SQL_INTEGER, /* SQL data type of the parameter : char(8)*/
0, /* size of the column or expression, precision */
0, /* The decimal digits, scale */
&id, /* A pointer to a buffer for the parameter's data */
0, /* Length of the ParameterValuePtr buffer in bytes */
NULL /* indicator */
) != SQL_SUCCESS)
{
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
if (SQLBindParameter(stmt, 2, SQL_PARAM_INPUT,
SQL_C_CHAR, SQL_VARCHAR,
20, /* varchar(20) */
0,
name, sizeof(name), &name_ind) != SQL_SUCCESS)
{
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
if (SQLBindParameter(stmt, 3, SQL_PARAM_INPUT,
SQL_C_TYPE_TIMESTAMP, SQL_DATE,
0, 0, &birth, 0, NULL) != SQL_SUCCESS)
{
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
if (SQLBindParameter(stmt, 4, SQL_PARAM_OUTPUT,
SQL_C_SLONG, SQL_INTEGER,
0, 0, &ret,
0,/* For all fixed size C data type, this argument is ignored */
NULL) != SQL_SUCCESS)
{
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
/* executes a prepared statement */
id = 5;
sprintf(name, "name5");
birth.year=2004;birth.month=5;birth.day=14;
birth.hour=15;birth.minute=17;birth.second=20;
birth.fraction=0;
name_ind = 5; /* name => length=5 */
if (SQLExecute(stmt) != SQL_SUCCESS)
{
execute_err(dbc, stmt, query);
SQLFreeStmt(stmt, SQL_DROP);
return SQL_ERROR;
}
else
{
printf("\n======= Result of exec procedure ======\n");
printf("ret => %d\n\n", ret);
}
SQLFreeStmt(stmt, SQL_DROP);
return SQL_SUCCESS;
}