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

Host Variables in C/C++ Programs
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
3-41
Selecting From a UCS2 Character Set Into a
VARCHAR Host Variable
primary key(pnum)
);
Selecting From a UCS2 Character Set Into a VARCHAR Host
Variable
This example selects from a UCS2 character set into a VARCHAR host variable:
EXEC SQL WHENEVER SQLERROR CALL handle_error;
//select VARCHAR ucs2 column to VARCHAR UCS2 host variables with
the same length
void select_varchar2varchar_ucs2()
{
EXEC SQL BEGIN DECLARE SECTION;
char CHARACTER SET IS UCS2 hv_empnum[4];
VARCHAR CHARACTER SET UCS2 hv_empname[21];
VARCHAR CHARACTER SET UCS2 hv_city[16 CHARACTERS];
EXEC SQL END DECLARE SECTION;
hv_empnum[3] = '\0';
EXEC SQL
select empnum,empname,city into :hv_empnum, :hv_empname,
:hv_city
from staff_uc
where empnum < _ucs2'E8' and grade = 10;
//use the value in hv_empnum, hv_empname, and hv_city
}
Fetching From a UCS2 Character Set into a VARCHAR Host
Variable
This example uses a FETCH operation from a UCS2 character set into a VARCHAR
host variable:
EXEC SQL BEGIN DECLARE SECTION;
long SQLCODE;
static char SQLSTATE_OK[6] = "00000";
char SQLSTATE[6];
char CHARACTER SET IS UCS2 hv_empnum[4];
VARCHAR CHARACTER SET UCS2 hv_empname[21];
DECIMAL(4) hv_grade;
VARCHAR CHARACTER SET UCS2 hv_city[16 CHARACTERS];
EXEC SQL END DECLARE SECTION;
//select UCS2 columns into host variable
void fetch_varchar2varchar_ucs2()
{
EXEC SQL BEGIN DECLARE SECTION;