https://wiki.ispirer.com/ 2026-04-08T00:34:57+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/data-types?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 Data Types Versions: IBM DB2 9.x, 8.x, 7.x, 6.1 and 5.2 Data Type Parameters and Range Character Data Types CHAR(n) - Fixed-length character data 1 <= n <= 254, default is 1 GRAPHIC(n) - Fixed-length double-byte character data 1 <= n <= 127, default is 1 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 Functions * SQL Functions Mapping to Other Databases * Numeric Functions * ABS * ACOS * ASIN * ATAN * ATANH * ATAN2 * CEILING * COS * COSH * COT * DEGREES * EXP * FLOOR * LN * LOG * LOG10 * MOD * MULTIPLY_ALT * POWER * RADIANS * RAND * ROUND * SIGN * SIN * SINH * SQRT * TAN * TANH * TRUNCATE * String F… text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/identifiers?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 - Identifiers This article describes identifiers in DB2. Identifiers rules DB2 - Identifier First Character An alphabetical character Subsequent Characters Alphanumeric characters and the underscore (_) Maximum Length 128 bytes text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/iseries-library-schema?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 for iSeries - Library and Schema A library is an iSeries system object that serves as a directory to other objects. The library object type has identifier *LIB. Before you can create a database file, you must create a library to store it. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/iseries-migration-assessment?rev=1741078744&do=diff User Documentation Ispirer Assessment Tools Overview Pricing IBM DB2 Migration Assessment * Collecting Information text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/iseries-physical-logical-files?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 for iSeries - Physical and Logical Files Physical Files A physical file is a database file that stores data. It also contains a description how data is actually stored in the database. From the perspective of the SQL standard, physical files are identical to tables. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/limits?rev=1741078744&do=diff User Documentation Ispirer Capabilities - DB2 Migration Pricing IBM DB2 Limits This article describes the database and SQL limits DB2 9.5 and earlier. Tables Row Size IBM DB2 - Row Size Maximum Row Size 4005 bytes (4K page size), 8101 bytes (8K page size), 16293 bytes (16K page size), 32677 bytes (32K page size) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/db2/migration-assessment?rev=1741078744&do=diff User Documentation Ispirer Assessment Tools Overview Pricing IBM DB2 Migration Assessment * Collecting Information