SQL/MX Programming Manual for Java

SQLJ Programming
HP NonStop SQL/MX Programming Manual for Java—523726-003
3-41
Character String Data Types
Assigning Character String Data to an Output Host Variable
You must declare a Java host variable that handles character string data as a String
or Byte data type in an SQLJ program. You cannot specify a character set in the Java
variable declaration:
String empname = null;
Java host variables accept character string data of any character set.
For example, the LAST_NAME column of an SQL/MP table named
EMPLOYEE_JAPAN stores Japanese characters in KANJI character-set format:
CREATE TABLE $samdb.persnl.employee_japan
( empnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,last_name CHARACTER (20) CHARACTER SET KANJI
...
In an SQLJ program, SQL/MX assigns a KANJI character string to the empname host
variable:
String empname = null;
...
#sql {SELECT last_name
INTO :empname
FROM employee_japan
WHERE empnum = 65};
In this example, the LAST_NAME column of an SQL/MX table named
EMPLOYEE_INTERNATL stores characters in UCS2 character-set format:
CREATE TABLE samdbcat.persnl.employee_internatl
( empnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,last_name CHARACTER (20) CHARACTER SET UCS2
...
In an SQLJ program, SQL/MX assigns a USC2 character string to the empname host
variable:
String empname = null;
...
#sql {SELECT last_name
INTO :empname
FROM employee_internatl
WHERE empnum = 43};
For more information about output host variables, see Host Variables and Expressions
on page 3-27.