NAME
    dec_onlog.pl

USAGE
    dec_onlog.pl <database>:<table> < <`onlog -l` listing>

DESCRIPTION
    The utility meant to restore erroneously deleted rows (not tables).
    It decodes HDELETE records of 'onlog -l' listing into LOAD-ready output.

SUPPORTED DATATYPES
    CHAR NCHAR
    VARCHAR NVARCHAR
    SMALLINT INT SERIAL
    INT8 SERIAL8
    FLOAT SMALLFLOAT
    DECIMAL MONEY
    DATE
    DATETIME
    INTERVAL

HOW TO PREPARE INPUT
    onlog -n <lognum> -l [-t <partnum>] [-u <username>] [-x <trans_id>] > file

TEST ENVIRONMENT
    IDS 9.40.FC5
    Client SDK 2.81.UC3
    SunOS 5.8 SPARC
    gcc 2.95.3
    perl 5.8.8
    DBI-1.609
    DBD::Informix-2008.0513
    Date::Simple-3.03

SYSTEM REQUIREMENTS
    Date::Simple
    DBD::Informix (optional, if not present, use dbaccess)
    Informix server must be in On-Line mode.

POSSIBLE CUSTOMIZATION
    DATAOFFSET means where data begin in HDELETE record (at the 4th line in
    9.40.FC5.)
    INT8 occupies 10 bytes in the testing environment.

AUTHOR
    Denis Melnikov <dbmelnikov//gmail.com>