FYI: Undelete Utility Contributed to IIUG Repository
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>