Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r092

D toc

D s ed
rtrue
editionsgdpent,gdppro,gdppr,awsent,awspro,awspr

Excerpt

This section covers data type conversions between the

D s webapp
rtrue
and DB2 databases.

Info

NOTE: The

D s item
itemdata types
rtrue
listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

Source Data TypeSupported

D s item
itemData Type

BOOLEANYBool
VARCHARYString
INTEGERYInteger

Publish/Write

D s item
itemData Type

DB2 Data TypeNotes
BoolBOOLEAN

VARCHAR
IntegerBIGINT

INT

SMALLINT

VARCHAR
StringVARCHAR(1024)
DatetimeTIMESTAMP

VARCHAR
TimeVARCHAR(1024)
DecimalDECIMAL

NUMERIC

VARCHAR
MapVARCHAR(1024)
ArrayVARCHAR(1024)

D s also
labeldb2