NAME¶

  Jifty::DBI::Handle::Informix - An Informix specific Handle object

SYNOPSIS¶

DESCRIPTION¶

This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Informix.

METHODS¶

insert¶

Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted. If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.

case_sensitive¶

Returns 1, since Informix's searches are case sensitive by default

apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW¶

takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;

disconnect¶

Disconnects and removes the reference to the handle for Informix.

distinct_query STATEMENTREF¶

takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.

AUTHOR¶

Oliver Tappe, oliver@akso.de

SEE ALSO¶

perl(1), Jifty::DBI