Data type support in SQL operations

The following topics detail data type support in SQL operations in IBM® Data Replication VSAM Remote Source.

Binary strings
A binary string is a sequence of bytes. The length of a binary string is the number of bytes in the sequence.
COBOL data types supported by the data server
When you map user tables in the metadata catalogs on the data server, Classic Data Architect can convert COBOL data types to native types that the server supports and their corresponding SQL types.
PL/I data types supported by the data server
When you map user tables in the metadata catalogs on the data server, Classic Data Architect can convert PL/I data types to native types that the server supports and their corresponding SQL types.
Constants
A constant (also called a literal) specifies a value. Constants are classified as string constants or numeric constants. Numeric constants are further classified as integer, floating-point, or decimal. String constants are classified as character or graphic. All constants have the attribute NOT NULL. A negative sign in a numeric constant with a value of zero is ignored.
Columns for IMS
You can define a column that references an IMS database. For IMS column definitions, you must also identify the name of the segment where the column resides.
Columns for VSAM
Column definitions are a part of CREATE TABLE statements. You use column definitions to define the columns in a table that references a VSAM file. There are no differences between a sequential column definition and the generic column definitions.

Parent topic: Configuring InfoSphere Classic CDC for z/OS