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-35
Using SQL Descriptors to Select UCS2 Data
Using SQL Descriptors to Select UCS2 Data
Example A-11 selects UCS2 data from an SQL/MX table by using SQL descriptor
areas.
Example A-11. Using SQL Descriptors to Select UCS2 Data (page 1 of 5)
/* ------------------------------------------------------------
Description: Illustrate setting and getting of character
set related description items, comparison of
UCS2 host variables with ISO88591 columns and
retrieval of ISO88591 data to UCS2 host
variables (relaxation).
Statements: ALLOCATE DESCRIPTOR
PREPARE
DESCRIBE
SET DESCRIPTOR
OPEN
FETCH
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 CSDYNCURSORM NAMES ARE ISO88591;
long SQLCODE;
char SQLSTATE_OK[6] = "00000";
char SQLSTATE_NODATA[6] = "02000";
EXEC SQL
BEGIN DECLARE SECTION;
char SQLSTATE[6];
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_len;
long return_len;
VARCHAR charset_name[129];
char CHARACTER SET UCS2 hv_input_in_UCS2[21];
VARCHAR CHARACTER SET UCS2 hv_output_in_UCS2[21];
EXEC SQL END DECLARE SECTION;