Changes for version 0.900007 - 2026-11-17

  • Storage
    • A DECIMAL, NUMERIC, REAL, DOUBLE or DECFLOAT value is read with a decimal point whatever the locale of the process is. Under a German LC_CTYPE the Db2 CLI writes a comma (`1234567890,12`); the cursor, select_single and the rows of explain put a point in its place. Other values stay as the CLI hands them over. DBIO sets no environment or session setting and leaves the locale of the process alone.
    • A `time` column with `inflate_datetime` is read and written through DBIO::DB2::Storage::DateTimeFormat, the storage's datetime parser: DateTime::Format::DB2 with a `parse_time` and a `format_time` of its own. The time of day comes back on 1970-01-01 and is written as `HH:MM:SS`, the form Db2 takes for a `TIME`.
  • Installation
    • DBI is a configure requirement, so it is installed before DBD::DB2, whose Makefile.PL needs it.
  • Documentation
    • The dbio-db2 and dbio-db2-database skills follow the code: diff pass order, model sections, type mapping, savepoints, pagination reason, live-test setup.

Documentation

Modules

IBM DB2-specific schema management for DBIO
Generate DB2 DDL from DBIO Result classes
Deploy and upgrade DB2 schemas via test-deploy-and-compare
Compare two introspected DB2 models
Diff operations for DB2 columns
Diff operations for DB2 foreign keys
Diff operations for DB2 indexes
Diff operation for the REORG a DB2 table needs after some column changes
Diff operations for DB2 tables
Diff operations for DB2 unique constraints
Diff operations for DB2 views
Introspect a DB2 database via SYSCAT
Introspect DB2 columns
Introspect DB2 foreign keys
Introspect DB2 indexes
Introspect DB2 tables and views
Introspect DB2 unique constraints
SQL dialect for IBM DB2
IBM DB2 support for DBIO
Reads the character columns of a Db2 result as characters and its decimals with a point
Db2 datetime parser with a working time of day
Answers the shared conformance case table for the Db2 driver
DB2 column type utilities
`use DBIO -db2` shortcut for the DB2 driver