SAP Note 29824 - DB6: Mapping of data types (DDIC -> DB)

Component : DB2 Universal Database for Unix / NT -

Solution : https://service.sap.com/sap/support/notes/29824 (SAP Service marketplace login required)

Summary :
This SAP Note addresses the mapping of ABAP Data Dictionary (DDIC) data types to database-specific data types in DB2 for Linux, UNIX, and Windows (DB6). It explains that the mapping varies based on the table space’s page size and the database’s code page (Unicode or non-Unicode). A detailed table outlines how various DDIC data types correspond to DB2 data types, covering a range of conditions such as length limits and data type characteristics. Additionally, it specifies conditions under which different SAPDB6 pseudo data types are applied, influenced by database version and page size specifications. This information is crucial for troubleshooting and configuration of SAP systems on DB2 databases.

Key words :
int1          smallint int2          smallint prec          smallint int4          integer fltp          float / doublefor sapdb6 pseudo data types, sapdb6 pseudo data types depending, ddic type      db-type ============================================================ raw          char, logged strg          sapdb6clob logged dec, symptom abap data dictionary abap, database data types differently depending, ddic data type explicitly, long field types depends, bit data char          sapdb6fixchar, database data type

Related Notes :

1524339DB6: SQL0301N after LONG to LOB conversion
1430621DB6: Performance of VBDATA
523622DB6: BW external DB connect to an external DB6 database