Code Specification 

In the code specification, you can define the default code type for interpreting data streams that contain plain text values. You can determine code specifications for a Loader session or for a Loader command by using the SET command to define the data format.

Syntax

<set_codetype_command> ::= SET CODETYPE <standard_code_spec>

<code_spec>            ::= <standard_code_spec>
                         | CODESET <literal>

<standard_code_spec>   ::= ASCII | UCS2 | UTF8

ASCII	The code type for interpreting data streams is ASCII The Loader’s default value is ASCII
UCS2	The code type for interpreting data streams is UCS2
UTF8	The code type for interpreting data streams is UTF8
CODESET <literal>	literal: name of the code type See the SQL Reference Manual, Literal (literal)

 

Code specification when using LONG data:

<lob_code_spec>      ::= <code_spec> | BINARY

BINARY

Data is exported/imported without being converted Specifying BINARY is only useful for columns of the data type LONG BYTE.

Examples

EXPORT TABLE hotel.room
  CATALOG OUTSTREAM 'room_ddl.catalog'
  DATA OUTSTREAM 'room_csv.data' ASCII

Specifying the code when LONG data is used:
Exporting and Importing LONG values

Explanation

If the  code_spec code specification is missing in the command, the Loader uses the code type set by the SET CODETYPE command or a default value.

●     SET CODETYPE command:
This setting applies to the entire Loader session provided that the character strings are not changed by another SET CODETYPE command.
You can change the current value for individual commands by using the syntax element  code_spec  to define the data format (field_format_spec).

●     Default value: this is derived from the internal database data type of the column to be imported. If the internal database data type and the code specified for the data streams are different, the Loader converts the data. If the data base type and the code specification are incompatible, the Loader generates an error message and stops processing the command.

<code_spec>

When you export or import data, you can transform it between various code types. If you export/import ASCII data into an ASCII database or UCS2 data into a UNICODE database, the data does not have to be converted.

The following combinations are possible (internal and external database data types):

Internal Database Data Type	Possible Code Specifications for Data Streams with Clear Text Values when Exporting Data
(VAR)CHAR ASCII	ASCII, UCS2, UTF8
(VAR)CHAR UNICODE	UCS2, UTF8
(VAR)CHAR BYTE	BINARY, ASCII (HEX), UCS2 (HEX), UTF8 (HEX)
Numeric data types	ASCII, UCS2, UTF8

 

Internal Database Data Type	Possible Code Specifications for Data Streams with Clear Text Values when Importing Data
(VAR)CHAR ASCII	ASCII
(VAR)CHAR UNICODE	ASCII, UCS2, UTF8
(VAR)CHAR BYTE	BINARY, ASCII, UCS2 (HEX), UTF8 (HEX)
Numeric data types	ASCII, UCS2, UTF8

<lob_code_spec>

When you export /import LONG data, you determine the default code types by using the syntax rule lob_code_spec. This enables you to convert LONG data between various code types.

If you are exporting/importing ASCII LONG data into an ASCII database or UCS2 LONG data into a UNICODE database, the data does not have to be converted.

The following combinations are possible (internal and external database data types):

Internal Database Data Type	Possible Code Specifications of the LONG Data Stream for Exporting Data
LONG ASCII	ASCII, UCS2, UTF8
LONG UNICODE	UCS2, UTF8
LONG BYTE	BINARY, ASCII (HEX), UCS2 (HEX), UTF8 (HEX)

 

Internal Database Data Type	Possible Code Specifications of the LONG Data Stream for Importing Data
LONG ASCII	ASCII
LONG UNICODE	ASCII, UCS2, UTF8
LONG BYTE	BINARY, ASCII, UCS2 (HEX), UTF8 (HEX)

See also:

Importing and Exporting LONG Values

Data Types

SQL Reference Manual, Data Type (data_type)