// Build statement.
sprintf( Statement, "call NSI.GDEPO(51, 5101)");
reg_log_msg(Statement);

// Execute the statement.
sqlrc = SQLPrepare(hstmt, Statement, SQL_NTS);
sprintf(msg, "Preparing SPOPZ with simply sqlexec. SQLRC= %d", sqlrc);
reg_log_msg(msg);	

sqlrc = SQLExecute(hstmt);
sprintf(msg, "Execute SPOPZ with simply sqlexec. SQLRC= %d", sqlrc);
reg_log_msg(msg);	

call NSI.GDEPO( 51 ,  5101 )

// Build statement.
sprintf( Statement, "call NSI.GDEPO(?, ?)");

// Preparing the statement.
sqlrc = SQLPrepare(hstmt, Statement, SQL_NTS);
sprintf(msg, "Preparing SPOPZ with link parameters. SQLRC= %d", sqlrc);
reg_log_msg(msg);	

// bind parameters
sqlrc = SQLBindParameter( hstmt,  1 , SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR,  2 ,  0 ,
								DR,  3 , &LenOrInd);
if (SQL_SUCCESS != sqlrc && SQL_SUCCESS_WITH_INFO != sqlrc) return(- 1 );
sprintf(msg, "Bind parameter #1");
reg_log_msg(msg);	

sqlrc = SQLBindParameter( hstmt,  2 , SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR,  4 ,  0 ,
								RETSTATUS,  5 , &LenOrInd);
if (SQL_SUCCESS != sqlrc && SQL_SUCCESS_WITH_INFO != sqlrc) return(- 1 );
sprintf(msg, "Bind parameter #2");
reg_log_msg(msg);	

//set parameters
sprintf(DR, "51");
sprintf(RETSTATUS, "5101");

//execute state
sqlrc = SQLExecute(hstmt);
sprintf(msg, "Execute SPOPZ with simply sqlexec. SQLRC= %d", sqlrc);
reg_log_msg(msg);