NAME

DBIO::Informix::Introspect::Columns - Introspect Informix columns

VERSION

version 0.900007

DESCRIPTION

Fetches column metadata via syscolumns joined with systables, plus sysdefaults for default values.

not_null is bit 256 of syscolumns.coltype (the type is coltype % 256). Primary keys are read through sysconstraints (constrtype = 'P') -> idxname -> the sysindexes row of that name on the same table -> part1 .. part16 -> syscolumns.colno; pk_position is the position within the key.

Measured against Informix 15.0.1: $schema is validated (\w+) and used as the database qualifier; the sysdefaults.default column needs no quoting.

METHODS

fetch

my $columns = DBIO::Informix::Introspect::Columns->fetch($dbh, $schema, $tables);

Given the tables hashref produced by DBIO::Informix::Introspect::Tables, returns a hashref keyed by table name. Each value is an arrayref of column hashrefs (in declaration order) with keys: column_name, data_type, not_null, default_value, is_pk, pk_position, size, is_auto_increment.

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.