SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

C Sample Programs
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
A-30
Using SQL Descriptor Areas to Select SQL/MP
KANJI and KSC5601 Data
Example A-10. Using SQL Descriptor Areas to Select SQL/MP KANJI and
KSC5601 Data (page1of5)
/* -------------------------------------------------------------
Description: Using SQL Descriptor Areas to pass-in and
select MP KANJI and KSC5601 data
Statements: ALLOCATE DESCRIPTOR
PREPARE
DESCRIBE
SET DESCRIPTOR
EXECUTE
DEALLOCATE PREPARE
DEALLOCATE DESCRIPTOR
WHENEVER
GET DIAGNOSTICS
------------------------------------------------------------- */
#include <stdio.h>
#include <stdlib.h>
#include <iostream.h>
#include <string.h>
#include <wchar.h>
EXEC SQL MODULE MPCSINOUTM NAMES ARE ISO88591;
long SQLCODE;
EXEC SQL
BEGIN DECLARE SECTION;
int hv_desc_max;
int i, j;
char in_sqlda[13];
char out_sqlda[13];
char hv_sql_stmt[255];
long degree;
long data_type;
long data_oct_len;
long data_len;
long return_len;
long return_oct_len;
VARCHAR charset_name[129];
char CHARACTER SET KANJI hv_input_in_KANJI[21];
char CHARACTER SET KSC5601 hv_input_in_KSC5601[21];
VARCHAR CHARACTER SET KANJI hv_output_in_KANJI[21];
VARCHAR CHARACTER SET KSC5601 hv_output_in_KSC5601[21];
EXEC SQL END DECLARE SECTION;
void handle_error()
{
EXEC SQL BEGIN DECLARE SECTION;
long i,num, hv_cond_num,hv_sqlcode;
char hv_sqlstate[6], hv_table_name[129],hv_column_name[129];
char hv_message_text[256];
EXEC SQL END DECLARE SECTION;