DBD-Informix

 view release on metacpan or  search on metacpan

ChangeLog  view on Meta::CPAN

1997-04-01: Add '-Ae' for HP-UX unless $Config{ccflags} includes -Aa or -Ae,
            per information from Oyvind Gjerstad <ogj@tglobe1.tollpost.no>.
            Include $Config{ccflags} in the command line when building the
            ESQL/C test program.
1997-03-28: Correct the handling of $dbase2 in multiple connections tests when
            DBD_INFORMIX_DATABASE2 is not set.  Fix required after John C
            Hossfeld <john@netpub.com> had problems.  Also report which database
            is being connected to!  Problem (and solution) also subsequently
            reported by James F Miner <jfm@winternet.com>.
1997-03-26: Add ODBC type handling.
1997-03-20: Update Makefile.PL to handle relocated DBIXS.h header, again.
1997-03-18: Change the handling of deprecated attributes per Informix.PM.

0.53 Release
------------
1997-03-06: Change the handling of deprecated attributes per Informix.PM.
            Update the README file to spell out the pre-requisites better.
            Update Makefile.PL with 0.53a1 version number, and so that it
            insists that $INFORMIXDIR is set, and that $INFORMIXDIR/bin is in
            $PATH.  Update tests to use the non-deprecated attributes.  Add the
            test program esqltest.ec to check that the ESQL/C environment is OK

Informix.pm  view on Meta::CPAN

data type (C<ix_ColType> value--see below), and data length
(C<ix_ColLength> value--see below).
If no tables are listed, all columns in the database are listed.
This can be quite slow because handling synonyms properly requires a
UNION operation.
Further, although the '_tables' method reports the names of remote
synonyms, the '_columns' method does not expand them (mainly because
it is very hard to do properly).
See the examples in t/t55mdata.t for how to use these methods.
Exercise for the reader: Extend '_columns' to get reports on the
columns in remote synonyms, including relocated remote synonyms where
the original referenced site now forwards the name to a third site!

See also C<DBD::Informix::Metadata(3)>.

=head2 DISCONNECTING FROM A DATABASE

You can also disconnect from the database:

    $dbh->disconnect;

Makefile.PL  view on Meta::CPAN

{
    $opts{DEFINE} .= " -DDBD_INFORMIX_ENABLE_ASSERT";
    print "** Warning ** assert macro is enabled!\n\n";
}
else
{
    print "Assert macro will be disabled!\n\n";
    $opts{DEFINE} .= " -DNDEBUG";
}

print "** Warning ** you will build $opts{NAME} for a relocatable INFORMIXDIR!\n\n"
    if (defined($ENV{DBD_INFORMIX_RELOCATABLE_INFORMIXDIR}));

$opts{INC} = " ";

Write_DBD_Informix_Defaults($ID);

# Grumble: ifx_loc_t was added to CSDK (ESQL/C) 3.00/xC3 and was not in
# 3.00.xC2.  Hence this test is more complex than I'd like.
sub check_for_ifx_loc_t
{

Makefile.PL  view on Meta::CPAN

(Informix Database Driver for Perl DBI Version 2018.1031 (2018-10-31)).
It records the default values of INFORMIXDIR and INFORMIXSERVER
that were in use when DBD::Informix was built.
You can edit the returned values if you need to,
but worry about where the Informix libraries are loaded from.

EOF

    if (defined($ENV{DBD_INFORMIX_RELOCATABLE_INFORMIXDIR}))
    {
        print DEFAULTS "Because $opts{NAME} was built with a relocatable INFORMIXDIR,\n";
        print DEFAULTS "if you edit INFORMIXDIR here, you will need to worry about\n";
        print DEFAULTS "how the shared libraries are located, which is hard, in general,\n";
        print DEFAULTS "because the mechanisms vary from platform to platform.\n\n";
    }
    else
    {
        print DEFAULTS "Because $opts{NAME} was built without a relocatable INFORMIXDIR,\n";
        print DEFAULTS "if you edit INFORMIXDIR here, you will need to keep the libraries\n";
        print DEFAULTS "in the original location because those path names are hard-linked.\n\n";
    }

    print DEFAULTS qq'The recorded default values are:\n\n';
    print DEFAULTS qq'    INFORMIXDIR    = "$ENV{INFORMIXDIR}"\n';
    print DEFAULTS qq'    INFORMIXSERVER = "$ENV{INFORMIXSERVER}"\n\n';

    if ($effvernum < 600)
    {

lib/DBD/Informix/Metadata.pm  view on Meta::CPAN

below).
If no tables are listed, all columns in the database are listed.
This can be quite slow because handling synonyms properly requires a
UNION operation.

Further, although the '_tables' method reports the names of remote
synonyms, the '_columns' method does not expand them (mainly because it
is very hard to do properly).
See the examples in t/t55mdata.t for how to use these methods.
Exercise for the reader: Extend '_columns' to get reports on the columns
in remote synonyms, including relocated remote synonyms where the
original referenced site now forwards the name to a third site!

Note that the return values from this are in the same format as found in
the system catalogues and are not necessary suitable for directly
embedding in an SQL statement.

=head2 The ix_map_tablename method

This method is used internally to map the owner, table (and optionally
column) names from the format found in the system catalog to a format