IIUG Software Repository

IIUG Software Repository

The IIUG Software Repository is hosted at SourceForge.
This Index allows you to browse and access the IIUG Software Repository. Entries have both a direct link to SourceForge resource and a Dowload link. A direct link will show the SourceForge page and display the content of the readme file, where one exists. A Download link will open a SourceForge page and initiate a download of the entire resource in tar.gz format.

Please read and heed the warnings, notices, and special instructions or agreements with each package.

Do you have some software you would like to contribute to the Repository? If so, check out the details on how to submit your files.

The resources are grouped as follows:

Data Warehouse Tools – Tools that can be used with data warehouse environments
DBAdmin Tools – Tools that help with database admin tasks
ESQL – ESQL programs and utilities
Informix4GL Tools – Programs and utilities in 4GL
InformixSQL Tools – SQL admin tools
JAVA Tools – Stored procedures and utilities written in Java
SQL Tools – Helpful SQL tools
Stored Procedures – Various stored procedures and utilities written in SPL
Miscellaneous – Everything else

Keywords

Many entries have one or more keywords attached to them that indicate the general category of software and/or the source language(s) used. The keywords used in this index are:

ACE     ACE Report Programing Language
AWK     AWK Programing Language
BISON     GNU Version of yacc
C     C Programing Language
C-ISAM     C functions for I-SAM files
CPP     cpp – C Language Preprocessor
DBA     Database Administration Utilities
ESQLC     ESQL/C Environment or ESQL/C Source
I4GL     Informix-4GL Environment or Informix-4GL Source
ISQL     Informix-SQL Environment
ISQLPERL     Perl Extension to Interface with Informix
JAVA     Java Environment or Java Source
KSH     Korn Shell
LEX     lex – Lexical Analysis Program Generator
LSDW     Large Scale Data Warehouse
MISC     Miscellaneous Routines and Utilities
NEWERA     New Era Environment or Source
ORDBMS     Object-Relational Database Extensibility, DataBlades
PERL     Perl Programming Language
PHP     PHP Web Programming Language
SH     Bourne Shell
SPERFORM     Informix Form Generation Utility
SPL     Stored Procedures
SQL     SQL Scripts or General SQL Tools
VB     Visual Basic
YACC     yacc – Yet Another Compiler Compiler

Software Repository Index

Data Warehouse Tools

iotest Scripts that determine the number of possible AIO VPs in a coserver [C, LSDW, PERL] Download .tar.gz  
readwriteperf Read and write program that determines I/O throughput on a machine [C, LSDW] Download .tar.gz  

^back to top

DBAdmin-Tools

alarm Monitors warnings, errors, and online status of databases [DBA, PERL]  Download .tar.gz  
alarm_space Specialized versions of the Informix alarm and evidence shell scripts, plus a script that warns if dbspace is running low, plus 4 other admin scripts [DBA, KSH]  Download .tar.gz  
analyse_idx Interactive program that gives information on indexes [DBA, I4GL]  Download .tar.gz  
arch_hp_tape Archives an OnLine database to an HP shuttle tape drive [DBA, SH]  Download .tar.gz  
arch2disk Archives an OnLine database to disk [DBA, SH]  Download .tar.gz  
auto_ontape Runs ontape unattended for multi-tape backup [DBA, SH]  Download .tar.gz  
bloqueos script for view and kill users using a table [AWK, DBA, SQL]  Download .tar.gz  
chkinstall Checks for and optionally fixes Informix installation errors [AWK, DBA, SH]  Download .tar.gz  
chklock-1.2 Reports locks on an SE database [C, DBA]  Download .tar.gz  
ckfls Reports files in $INFORMIXDIR with incorrect permissions [DBA, SH]  Download .tar.gz  
cmp_row Checks the consistency of rows in an Informix Enterprise Replication configuration [DBA, ESQLC]  Download .tar.gz  
copy_spaces Converts onstat -d commands into onspaces commands [DBA, SH]  Download .tar.gz  
db_ontape Runs ontape [DBA, PERL, SH]  Download .tar.gz  
dbalter Alters one database to be like another [DBA, ISQLPERL]  Download .tar.gz  
dbamon Monitors OnLine engine performance [DBA, SH]  Download .tar.gz  
dbdiff2 Generates SQL that alters one database to be like another. UPDATED! Contains a new version created by David Williams. [DBA, I4GL]  Download .tar.gz  
dbinfo_lk Displays INFO statement output [AWK, DBA, SQL]  Download .tar.gz  
dbldfmt Converts a fixed-field-length file to LOAD format [C, DBA, MISC]  Download .tar.gz  
dbmon_pm Database monitoring utility scripts [AWK, DBA, SH]  Download .tar.gz  
dbping Simple timing to see if your database connection is up [AWK, DBA, MISC, SH]  Download .tar.gz  
dbps merges the output of onstat -g ses with ps -f (ie not Berkeley) [DBA, PERL]  Download .tar.gz  
dbref Analyzes referential integrity & builds (un)load scripts [DBA, I4GL]  Download .tar.gz  
dbsh Splits dbschema output into a set of files [AWK, DBA, SH]  Download .tar.gz  
dbspace_pages Reports unused space in all dbspaces [DBA, SH, SQL]  Download .tar.gz  
dbspace_space Reports unused space in all dbspaces [DBA, SH, SQL]  Download .tar.gz  
dbtop Quick real-time resource monitor for Informix database servers, similar to the Unix ‘top’ command. [DBA, PERL]  Download .tar.gz  
dbweb-1.0.3 Web based database interrogator and remote monitor [C, DBA, ESQLC, MISC]  Download .tar.gz  
ddhash_stats Calculate DD_HASHSIZE and DD_HASHMAX [C, DBA]  Download .tar.gz  
defrag_table Defragments tables [DBA, PERL, SQL]  Download .tar.gz  
deinstall Uninstalls and removes Informix software products [AWK, DBA, SH]  Download .tar.gz  
disk_struct Displays the disk structure for the current instance [DBA, I4GL, SH]  Download .tar.gz  
dm Shows summary of output from various onstat commands [DBA, ESQLC]  Download .tar.gz  
dup_spaces Produces onspaces commands to replicate dbspaces, chunks, temp spaces and blob spaces [AWK, DBA, KSH]  Download .tar.gz  
dup-auth Generates SQL to grant or revoke existing table and column privileges [DBA, KSH, SQL]  Download .tar.gz  
entropymap Dirty bit of 4GL to display extent entropy in a dbspace as html [DBA, I4GL, MISC]  Download .tar.gz  
errmsgtbl Creates a database table of Informix error messages [AWK, DBA, MISC, SH]  Download .tar.gz  
extent_report Reports extent size and usage info [DBA, PERL]  Download .tar.gz  
extentsize Calculates extent sizing for a table [DBA, SH]  Download .tar.gz  
find_tmp_tbls Lists temp tables per session in an instance using onstat [AWK, DBA, KSH, MISC]  Download .tar.gz  
format_ps Formats the output of ps -el, shows in a tree-like format who started what – oninit processes are shown as owning shm segments (IDS not XPS) [C, DBA, MISC]  Download .tar.gz  
fragments.shar Details on every tablespace (including fragments ) on a server [AWK, DBA, KSH, MISC]  Download .tar.gz  
idbb Automatic Informix database back-up utility [DBA, SH]  Download .tar.gz  
idstools A collection of numerous tools for I4GL and ESQL/C development, and database administration of IDS [AWK, C, DBA, ESQLC, I4GL, MISC, SH]  Download .tar.gz  
ifmx_user Counts the number of concurrent Informix users (sessions) [DBA, ESQLC, MISC]  Download .tar.gz  
ifmxtools Contains admin scripts that may help your daily DBA life. Includes ILAP  (Informix Log Allmighty Parser) [DBA,Perl,log,parser] Download .tar.gz  
ifx_xferdb Import a database (across platforms) using External tables and PIPES [DBA, KSH]  Download .tar.gz  
indexSizeEstimating EXCEL spreadsheet to estimate the size of a new index [DBA, KSH]  Download .tar.gz  
infmx2html Creates Web pages describing one or more databases [DBA, I4GL]  Download .tar.gz  
infotable Gives comprehensive information about a table similar to Oracle’s “describe” command [DBA, ESQLC, MISC]  Download .tar.gz  
isextract Unloads data from C-ISAM files [C, DBA, ESQLC, MISC]  Download .tar.gz  
JLoader load / unload via jdbc, BLOB handling incomplete [DBA, JAVA]  Download .tar.gz  
killidle Monitors and kills idle processes [AWK, DBA, MISC]  Download .tar.gz  
linkpath LINKPATH is a program that lets you check the security of the path leading to $INFORMIXDIR, or indeed for any file or directory. [C, DBA]  Download .tar.gz  
listtabchunk a tool which will print all tables/indexes residing in a chunk [DBA, ESQLC]  Download .tar.gz  
lockrep Reports tables locked by users [AWK, DBA, MISC, SH]  Download .tar.gz  
lockwt Reports user sessions holding locks and any sessions waiting for those locks to be released [DBA, ESQLC]  Download .tar.gz  
logcheck Reads log numbers from logical log tapes [AWK, DBA, SH]  Download .tar.gz  
logs Real-time HDR replication monitor for Informix database servers. [DBA, PERL]  Download .tar.gz  
long2time Converts an ER timestamp into display format [C, DBA, MISC]  Download .tar.gz  
lwt_install Windows embedability tool to deploy pre-configured IDS instances [C, DBA, MISC]  Download .tar.gz  
master_event.plx This program will monitor all event’s reported by the Informix Engine. [DBA, PERL]  Download .tar.gz  
maxextents Determines total number of extents for a table [C, DBA, JAVA]  Download .tar.gz  
misql Alternative to isql/dbaccess, including simple forms [DBA, I4GL, ISQL, MISC]  Download .tar.gz  
mon_buffer Reports buffer utilization [AWK, DBA, KSH]  Download .tar.gz  
monitor Database that holds historical and performance data on all tables [DBA, KSH, SQL]  Download .tar.gz  
monitor_space Monitors dbspaces for level of fullness [AWK, DBA, SH]  Download .tar.gz  
movetab Allows moving tables between Informix instances without having to turn off logging [DBA, ESQLC, MISC]  Download .tar.gz  
myexport Replacements for dbexport and dbimport [AWK, DBA, KSH, MISC]  Download .tar.gz  
myonpload Command line interface to onpload like sqlunload and sqlreload [DBA, ESQLC, MISC, SQL]  Download .tar.gz  
on_to_unload Reads arcunload or single-table onunload output [AWK, C, DBA]  Download .tar.gz  
ondd This script provides serial or parallel data streams in conjunction with the HPL to move data between versions 7, 8, and 9 instances. [DBA, KSH, LSDW]  Download .ksh  
onlsize Reports sizes of OnLine databases [DBA, PERL]  Download .tar.gz  
OnManager An administration utility to monitor server, user sessions, manage disk space, grant and limit access to databases [C, DBA, ESQLC, SQL]  Download .tar.gz  
onprocs Shows which stored procedures are being executed [AWK, DBA, MISC, SH]  Download .tar.gz  
onstat_rau_ur Computes read ahead utilization and bufwait ratios from onstat -p [AWK, DBA]  Download .tar.gz  
onweb_10uc1_dec The 1.0 UC1 release of OnWeb in compressed TAR format for DIGITAL UNIX [DBA, PERL, SQL]  Download .tar.gz  
onweb_10uc1_hp The 1.0 UC1 release of OnWeb in compressed TAR format for HP-UX [DBA, PERL, SQL]  Download .tar.gz  
onweb_10uc1_lin The 1.0 UC1 release of OnWeb in compressed TAR format for LINUX [DBA, PERL, SQL]  Download .tar.gz  
onweb_10uc1_sol The 1.0 UC1 release of OnWeb in compressed TAR format for SOLARIS [DBA, PERL, SQL]  Download .tar.gz  
orclproc Oracle function equivalents as stored procedures [DBA, ISQL, SPL]  Download .tar.gz  
partitions Lists table info like extents and pages in partitions [AWK, DBA, KSH, SQL]  Download .tar.gz  
partn Decodes partnum column in onstat commands and adds “database:owner.table[#index][%fragpart][,fragdbs]” to stdout [DBA, ESQLC]  Download .tar.gz  
pgdump Displays pages of an OnLine database [C, DBA, MISC]  Download .tar.gz  
pres_ext Creates SQL script to preserve OnLine extents [DBA, SH]  Download .tar.gz  
privproc Reports privileges for Stored Procedures [ACE, DBA, ISQL]  Download .tar.gz  
pwatson_utils Paul Watson’s utilities ondump, onspeed and onpatch [DBA, ESQLC]  Download .tar.gz  
ratios Calculates Read-ahead utilization, Bufwaits and Buffer Turnover ratios [DBA, PERL]  Download .tar.gz  
ratios.shr_ak Script and SQL to calculate server performance metrics [AWK, DBA, KSH, MISC, SQL]  Download .tar.gz  
recreate_er_define_stmts Enterprise Replication – Reverse engineer “cdr define” statements from syscdr [DBA, MISC, SH, SQL]  Download .tar.gz  
rehex Reformats hexadecimal numbers from onstat commands. [C, DBA]  Download .tar.gz  
reorg_pl Reorganizes an entire database or single table [DBA, PERL]  Download .tar.gz  
rix-0.4 This is a program that allows you to run the onstats against remote hosts, or, if you run multiple instances on one machine, then is sorts your environment. [C, DBA]  Download .tar.gz  
save_idx Saves and recreate indexes [AWK, DBA, SH]  Download .tar.gz  
schemadiff Compares 2 schemas, described in _Tech_Notes_ v5,i3 [C, DBA]  Download .tar.gz  
seqscan Monitors sequential scans using “onstat -g ppf” [AWK, DBA, SH, SQL]  Download .tar.gz  
set_index This script sets the object mode of contraints and indexes on a table(s) either ENABLED or DISABLED. [DBA, KSH]  Download .tar.gz  
setixd Tools for Working with Multiple INFORMIXDIRs [C, DBA, SH, SQL]  Download .tar.gz  
size9 Script to size databases, esp v9 [DBA, SPL, SQL]  Download .tar.gz  
space_usage Reports table space usage in an OnLine database [C, DBA, I4GL]  Download .tar.gz  
spsl Stored procedure that shows who owns locks on a table [DBA, SPL]  Download .tar.gz  
sqlrun32 Win32 executable to process SQL on a remote Informix server [DBA, ISQL]  Download .tar.gz  
sqsl Structured Query Scripting Languge Tool [BISON, DBA, ESQLC, MISC, SQL, YACC]  Download .tar.gz  
su_ontape Does an su to user “informix”, then runs ontape [C, DBA]  Download .tar.gz  
sysmaster SQL scripts using the sysmaster database to provide monitoring and tuning of your Informix Server [DBA, ISQL, SQL]  Download .tar.gz  
tab_col_frm Table/column information screen file [DBA, SPERFORM]  Download .tar.gz  
table-iostats Displays I/O counts for each tblspace [AWK, DBA, SH, SQL]  Download .tar.gz  
tbheader Prints header information from an Informix back-up tape [C, DBA]  Download .tar.gz  
tbrpt Combines several tbstat options into one report [AWK, DBA, SH, SQL]  Download .tar.gz  
temptab Generates information about temporary tables [DBA, I4GL]  Download .tar.gz  
temptab.pl A perl version of temptab [DBA, PERL]  Download .tar.gz  
topdb Monitors database activity using onstat similar to Unix top command [AWK, DBA, SH, SQL]  Download .tar.gz  
trigger Attaches to the end of a file and spawns processes whenever a key string is added [C, DBA, MISC]  Download .tar.gz  
trigger_test Tests triggers and stored procedures from I4GL [DBA, I4GL, MISC, SQL]  Download .tar.gz  
tx_split Splits SQL update/delete statements into smaller transaction groups to avoid lock table overflows and long transaction problems [DBA, ESQLC, MISC, SQL]  Download .tar.gz  
undelete Undelete rows via decoding onlog listing [DBA, PERL]  Download .tar.gz  
unused_space Reports remaining space in currently used volumes [AWK, DBA, SH]  Download .tar.gz  
upd_stats Collection of utilities that generate optimal update statistics statements and perform other Informix and Unix functions [DBA, PERL]  Download .tar.gz  
upd_stats_rt Generate and perform UPDATE STATISTICS on Informix tables [DBA, PERL]  Download .tar.gz  
updstats_fn SHELL scripts to update statistics [DBA, KSH]  Download .tar.gz  
uque Identifies who’s locked on what and what it is that is locked [DBA, ESQLC, MISC]  Download .tar.gz  
utils_ak Database administration scripts and programs [AWK, DBA, ESQLC, SH]  Download .tar.gz  
utils_jl Database administration utility package [C, DBA, SH]  Download .tar.gz  
utils_sp Database administration scripts and programs [C, DBA, I4GL, PERL]  Download .tar.gz  
utils2_ak Database administration programs and utilities [DBA, ESQLC]  Download .tar.gz  
utils3_ak Event alarm handler program and script [C, DBA, KSH]  Download .tar.gz  
utils4_ak Scripts to process dbschema or myschema (utils2_ak) output [AWK, DBA]  Download .tar.gz  
who_access Determines who is accessing or locking a table [AWK, DBA, KSH, SQL]  Download .tar.gz  
who-locks Display pertinent information on locks [DBA, KSH]  Download .tar.gz  
xtbload X application that displays OnLine status similar to xload [C, DBA]  Download .tar.gz  

^back to top

ESQL

busdays Adds/subtracts workdays [ESQLC] Download .tar.gz
chkmsg Displays messages in Informix message files [C, ESQLC, MISC] Download .tar.gz
cmp_row Checks the consistency of rows in an Informix Enterprise Replication configuration [DBA, ESQLC] Download .tar.gz
connect_4gl I4GL callable ESQLC code for handling CONNECT, etc. [ESQLC, I4GL] Download .tar.gz
credit_card Processes point-of-sale credit card transactions [C, ESQLC, I4GL] Download .tar.gz
dbnames Gets list of visible databases [ESQLC] Download .tar.gz
dbstruct Generates C structs for database tables [ESQLC, SH] Download .tar.gz
dbweb-1.0.3 Web based database interrogator and remote monitor [C, DBA, ESQLC, MISC] Download .tar.gz
dm Shows summary of output from various onstat commands [DBA, ESQLC] Download .tar.gz
esql_c++ Instructions and files for compiling ESQLC programs with c++, including header (“.h”) files containing ESQLC function prototypes (TechInfo # 5563) [C, ESQLC, SH] Download .tar.gz
esql_cpp Preprocesses ESQLC programs using cpp [AWK, CPP, ESQLC] Download .tar.gz
esql_proto2 File describing ESQLC function prototypes [C, ESQLC] Download .tar.gz
eSQLEditor shows list of tables or procedures by pattern of name, columns, indexes, etc; paste name of table or other database object to sql text by double click; execute sql scripts with timing and logging and show error place. [C, ESQLC] Download .tar.gz
esqlutil Generates C structs for database tables [ESQLC] Download .tar.gz
excel4w Excel file output with Informix 4GL [C, ESQLC, I4GL, MISC] Download .tar.gz
fgldoc A documenter for I4GL programs [C, ESQLC, I4GL, LEX, YACC] Download .tar.gz
gettype Article/code for getting data type from syscolumns [C, ESQLC, SH] Download .tar.gz
hierarc_sql Handles hierarchical data like parts explosion [ACE, ESQLC, SQL] Download .tar.gz
idstools A collection of numerous tools for I4GL and ESQL/C development, and database administration of IDS [AWK, C, DBA, ESQLC, I4GL, MISC, SH] Download .tar.gz
ifmx_user Counts the number of concurrent Informix users (sessions) [DBA, ESQLC, MISC] Download .tar.gz
intvl_conv Functions to convert intervals [ESQLC, MISC, SPL] Download .tar.gz
load2 Library of ESQL/C generic data load/unload functions for Informix database + couple of useful utilities which makes use of this library (xml loader for example). [C, ESQLC, MISC] Download .tar.gz
lockwt Reports user sessions holding locks and any sessions waiting for those locks to be released [DBA, ESQLC] Download .tar.gz
mkproc Creates procedures from SQL statements in files [C, ESQLC, ISQL, MISC] Download .tar.gz
movetab Allows moving tables between Informix instances without having to turn off logging [DBA, ESQLC, MISC] Download .tar.gz
pload.zip Scripts to help manipulate the onpload database without going through the graphical user interface (not same as pload.tar) [ESQLC, LSDW, SQL] Download .tar.gz
pwatson_utils Paul Watson’s utilities ondump, onspeed and onpatch [DBA, ESQLC] Download .tar.gz
recursion An example of recursion in I4GL [ESQLC, I4GL] Download .tar.gz
reserved List of I4GL and ISQL reserved keywords [C, ESQLC, I4GL, ISQL] Download .tar.gz
sqlcmd-90.02 Interprets and processes SQL commands (Version 90.02) [C, ESQLC, SQL] Download .tar.gz
sqlda_funcs Functions for handling sqlda structures [ESQLC] Download .tar.gz
sqlstruct Outputs a C structure corresponding to the output of a specified SQL SELECT statement [ESQLC] Download .tar.gz
sqsl Structured Query Scripting Languge Tool [BISON, DBA, ESQLC, MISC, SQL, YACC] Download .tar.gz
tbschema A schema utility similar to dbschema [ESQLC] Download .tar.gz
tclsql Functions for interfacing TCL with Informix-SQL [C, ESQLC, ISQL] Download .tar.gz
tx_split Splits SQL update/delete statements into smaller transaction groups to avoid lock table overflows and long transaction problems [DBA, ESQLC, MISC, SQL] Download .tar.gz
updblob Generic program to update BLOB fields [ESQLC] Download .tar.gz
uque Identifies who’s locked on what and what it is that is locked [DBA, ESQLC, MISC] Download .tar.gz
utils_ak Database administration scripts and programs [AWK, DBA, ESQLC, SH] Download .tar.gz
utils2_ak Database administration programs and utilities [DBA, ESQLC] Download .tar.gz

^back to top

Informix4GL-Tools

4gl_lib Collection of I4GL functions [I4GL] Download .tar.gz  
4gltags_awk Generates vi tags file for I4GL source [AWK, I4GL] Download .tar.gz  
4gltags_c Generates vi tags for I4GL source [C, I4GL] Download .tar.gz  
4gltools_ak 4GL functions to ease application building [I4GL] Download .tar.gz  
4gltree Produces a function map for I4GL source [AWK, I4GL] Download .tar.gz  
altris A Tetris look-alike [C, I4GL] Download .tar.gz  
analyse_idx Interactive program that gives information on indexes [DBA, I4GL] Download .tar.gz  
appstart Runs Informix applications setuid [C, I4GL] Download .tar.gz  
arrdemo Demonstrates a method of displaying I4GL arrays [C, I4GL] Download .tar.gz  
barcode25 Produces CODE I25 barcodes on a PCL printer. See also barcodelp. [I4GL] Download .tar.gz  
barcodelp Functions for printing barcodes on laser printers [I4GL] Download .tar.gz  
barcodesw I4GL interface to the StrandWare barcode package [C, I4GL] Download .tar.gz  
binary Functions to implement binary arithmetic in I4GL [I4GL] Download .tar.gz  
blackjack The well-known casino game [I4GL] Download .tar.gz  
blob_to_char Converts a TEXT type to a CHAR type [C, I4GL] Download .tar.gz  
browser Browses an array [I4GL] Download .tar.gz  
calx Pops up a calendar pick-list [I4GL] Download .tar.gz  
cfuncts Functions for use in I4GL, including a Soundex routine [C, I4GL] Download .tar.gz  
cgi_4gl Functions to help create WWW interface programs in I4GL [C, I4GL] Download .tar.gz  
check_prt Examples of printing checks with dollar amounts as words [I4GL] Download .tar.gz  
codereuse Article and discussion on writing reusable I4GL code [I4GL] Download .tar.gz  
connect_4gl I4GL callable ESQLC code for handling CONNECT, etc. [ESQLC, I4GL] Download .tar.gz  
constr_err Traps constraint error and tells which constraint failed [I4GL] Download .tar.gz  
credit_card Processes point-of-sale credit card transactions [C, ESQLC, I4GL] Download .tar.gz  
cursor_name6 Prints strings that cause problems in I4GL 6.x cursor names [I4GL] Download .tar.gz  
cvtdatetime Functions to convert local datetime and Universal time [I4GL] Download .tar.gz  
datelib_ak Date functions [BISON, C, I4GL, YACC] Download .tar.gz  
dbdiff2 Generates SQL that alters one database to be like another. UPDATED! Contains a new version created by David Williams. [DBA, I4GL] Download .tar.gz  
dbref Analyzes referential integrity & builds (un)load scripts [DBA, I4GL] Download .tar.gz  
dbxref Cross-references I4GL variables, labels and functions [C, I4GL] Download .tar.gz  
disk_struct Displays the disk structure for the current instance [DBA, I4GL, SH] Download .tar.gz  
easter Several methods of calculating Easter for a specified year [C, I4GL] Download .tar.gz  
editstr A substring replacement function for use in Informix-4GL [C, I4GL] Download .tar.gz  
emacs_4gl I4GL mode file for emacs [I4GL] Download .tar.gz  
entropymap Dirty bit of 4GL to display extent entropy in a dbspace as html [DBA, I4GL, MISC] Download .tar.gz  
excel4w Excel file output with Informix 4GL [C, ESQLC, I4GL, MISC] Download .tar.gz  
fgl_crypt Several approaches to encrypting strings in a I4GL program [C, I4GL] Download .tar.gz  
fgl_run Runs commands without I4GL “run” statement [C, I4GL] Download .tar.gz  
fgldoc A documenter for I4GL programs [C, ESQLC, I4GL, LEX, YACC] Download .tar.gz  
fgledit Small script that simplifies the development cycle for .4gl and .per files [I4GL, PERL] Download .tar.gz  
fglpp A I4GL preprocessor/precompiler [AWK, I4GL] Download .tar.gz  
flat_4gl Several collections of functions for processing flat files from within I4GL programs [C, I4GL] Download .tar.gz  
get_user Returns current login-ID to a I4GL program [C, I4GL] Download .tar.gz  
getopt I4GL version of getopt(3) function [I4GL] Download .tar.gz  
hangman The well-known word guessing game [I4GL] Download .tar.gz  
i4glcgi Source version of an I4GL CGI interface [I4GL] Download .tar.gz  
idstools A collection of numerous tools for I4GL and ESQL/C development, and database administration of IDS [AWK, C, DBA, ESQLC, I4GL, MISC, SH] Download .tar.gz  
iedit Simple text editor [C, I4GL] Download .tar.gz  
ifx.tables Analyses .4gi files and lists tables used, plus flags indicating type of activity on those tables [I4GL, PERL]  Download .tar.gz  
iid Informix-4GL code beautifier [C, I4GL] Download .tar.gz  
img2mac Script to create a printer macro from an image file to print images from an Informix 4GL report (Logos, check signatures etc…) [I4GL, SH] Download .tar.gz  
incerto Random number generator for I4GL [C, I4GL] Download .tar.gz  
inferr Scans .err files for error messages [AWK, I4GL] Download .tar.gz  
infmx_tidy Informix-4GL code beautifier [C, I4GL] Download .tar.gz  
intvl_round Rounds intervals [I4GL] Download .tar.gz  
kw Prints I4GL source file with keywords in upper case [C, I4GL] Download .tar.gz  
l_pop Handles pop-up windows for display and choosing [I4GL] Download .tar.gz  
look_date Allows date selection in a pop-up window [I4GL] Download .tar.gz  
lu_cust Replaces DISPLAY/INPUT ARRAY for customer look-up/choosing [I4GL] Download .tar.gz  
m4gl M4 macro to provide define/include for I4GL [I4GL] Download .tar.gz  
maintlib Functions for writing interactive maintenance programs [C, I4GL] Download .tar.gz  
make_sccs Examples for using make with I4GL & ISQL, plus numerous scripts and utilities for working with SCCS [AWK, I4GL, ISQL, SH] Download .tar.gz  
makedic Makes a data dictionary listing file [I4GL, MISC] Download .tar.gz  
meta_qa Detect differences between source data and a table [I4GL, KSH, MISC] Download .tar.gz  
metaphone Several implementations of the Metaphone phonetic algorithm [C, I4GL, MISC] Download .tar.gz  
metrics_4gl Computes several metrics for I4GL source files [I4GL, MISC, PERL] Download .tar.gz  
misql Alternative to isql/dbaccess, including simple forms [DBA, I4GL, ISQL, MISC] Download .tar.gz  
msg_pmpt Displays message box and lets user choose option [I4GL] Download .tar.gz  
multi_rpt Multiple report interleaved output processing [C, I4GL] Download .tar.gz  
multiscreen Program that is an example of doing multi-screen input in I4GL [C, I4GL] Download .tar.gz  
need_inc_4gl Determines if a I4GL program requires an include file [I4GL, JAVA] Download .tar.gz  
noncaseqry Converts WHERE clause for non-case-sensitive query [I4GL] Download .tar.gz  
ppcc4gl Preprocesses I4GL source using cpp [CPP, I4GL, SH] Download .tar.gz  
progbar Displays a progress bar to track completion of a process [I4GL] Download .tar.gz  
progtest A test of 25 questions for I4GL programmers with answers [I4GL] Download .tar.gz  
prt_decimal Methods of formatting decimal numbers for printing [C, I4GL] Download .tar.gz  
query_win Provides scrolling QBE pick-list in a pop-up window [I4GL] Download .tar.gz  
random_4gl Random number generator for I4GL [C, I4GL] Download .tar.gz  
rdslib There are three programs in this product for use with Informix 4GL-RDS: rdsscan p-code scanner ; rdslib p-code librarian ; rdslink p-code linker [C, I4GL]  Download .tar.gz  
reccmp Compares data in two identically structured RECORDs in I4GL [C, I4GL] Download .tar.gz  
recursion An example of recursion in I4GL [ESQLC, I4GL] Download .tar.gz  
reserved List of I4GL and ISQL reserved keywords [C, ESQLC, I4GL, ISQL] Download .tar.gz  
rpt_awk Functions to control AWK reports like I4GL or ACE [AWK, I4GL, ISQL] Download .tar.gz  
rpt_blobs Prints BLOB’s such as images and logo’s in I4GL reports [C, I4GL] Download .tar.gz  
rpt_length Several approaches to having variable report lengths [I4GL] Download .tar.gz  
rpt_size Changes I4GL report dimensions at run-time [C, I4GL] Download .tar.gz  
rptview UNIX file browsing and processing tool [I4GL] Download .tar.gz  
scriba Tools for documenting and indexing I4GL source files [AWK, I4GL, MISC, SH] Download .tar.gz  
setenv An enhanced version of putenv(3 [C, I4GL] Download .tar.gz  
solitaire Solitaire game similar to the one on most Windows PC’s [I4GL] Download .tar.gz  
soundex Utilities for generating Soundex codes [C, I4GL] Download .tar.gz  
soundex_ius Soundex function for use in with Illustra/Universal Server [C, I4GL, MISC] Download .tar.gz  
soundex_spl Stored procedure to return a 5-position Soundex code [I4GL, MISC, SPL] Download .tar.gz  
space_usage Reports table space usage in an OnLine database [C, DBA, I4GL] Download .tar.gz  
split_string Functions for splitting/parsing I4GL strings [C, I4GL] Download .tar.gz  
sqlfmt 4GL cross-referencing program [C, I4GL] Download .tar.gz  
sqrt_4gl sqrt() function for I4GL [C, I4GL] Download .tar.gz  
tbed Database access and manipulation tool [I4GL] Download .tar.gz  
tbl_ring_mnu Table-driven ring menu utility [I4GL] Download .tar.gz  
tbrb Report building tool [I4GL] Download .tar.gz  
tcl4gl Functions for interfacing TCL with Informix-4GL [C, I4GL] Download .tar.gz  
temptab Generates information about temporary tables [DBA, I4GL] Download .tar.gz  
test4glcomp Source code to test I4GL compiler [I4GL] Download .tar.gz  
timeout Allows I4GL programs to set input time-out intervals [C, I4GL] Download .tar.gz  
trigger_test Tests triggers and stored procedures from I4GL [DBA, I4GL, MISC, SQL] Download .tar.gz  
utils_sp Database administration scripts and programs [C, DBA, I4GL, PERL] Download .tar.gz  
vari_functs Functions using variable values [C, I4GL] Download .tar.gz  
vertmenu Vertical pull-down menus for I4GL [C, I4GL] Download .tar.gz  
vertmenu_tk Tony Kaser has made some changes to vertmenu that fit his needs. He has included a file called CHANGES that hightlights his modifications. This is not to be considered as a drop in replacement of Marco Greco’s vertmenu. [C, I4GL] Download .tar.gz  
vgrind_4gl Vgrind definition file for I4GL [I4GL] Download .tar.gz  
wordwrap Demonstrates using INPUT ARRAY and WORDWRAP [I4GL] Download .tar.gz  
work_days Methods for computing number of work days [I4GL] Download .tar.gz  
zipbundle Prints bundling instructions for bulk mailing by Zipcode [I4GL] Download .tar.gz  

^back to top

InformixSQL-Tools

col2rows Reformats SQL output from columns to rows [ISQL, PERL] Download .tar.gz  
loop_scr Generates multi-table SPERFORM screens [AWK, ISQL, SH] Download .tar.gz  
reform_sql Reformats ISQL output to 1 wide line per row [AWK, ISQL] Download .tar.gz  
rpt_awk Functions to control AWK reports like I4GL or ACE [AWK, I4GL, ISQL] Download .tar.gz  
sh_select Example of doing SQL queries from the shell [AWK, ISQL, MISC, SH] Download .tar.gz  

^back to top

JAVA-Tools

blobtool Loads and unloads blob/text data using JDBC [JAVA] Download .tar.gz  
InformixDynamicServerDialect Extending the Hibernate Informix Dialect [JAVA] Download .tar.gz  
JLoader load / unload via jdbc, BLOB handling incomplete [DBA, JAVA] Download .tar.gz  
jselect Runs SELECT statements and outputs various formats [JAVA] Download .tar.gz  
maxextents Determines total number of extents for a table [C, DBA, JAVA] Download .tar.gz  
need_inc_4gl Determines if a I4GL program requires an include file [I4GL, JAVA] Download .tar.gz  
viewer Web browser based database query tool using servlets [JAVA] Download .tar.gz  

^back to top

Miscellaneous

termcaps A collection of termcap entries submitted by Informix users and/or taken from public postings on the Net. In most cases, these entries work correctly in the specific environment for which they were developed. However, they have been accumulated here without testing or editing, so of course “your mileage may vary.” The entries are divided into files based loosely on the actual and/or emulated equipment which they support. This categorization is somewhat arbitrary, and is designed mainly to help decide if a new entry is already in the archive. There is some overlap of entries; e. g., entries for Wyse terminals emulating DEC VT100’s appear in the files for both “Wyse” and “VTxxx” groups. [MISC]  Download .tar.gz  
tpc-c_benchmark Autoloading and running Informix TPC-C benchmark, useful to calibrate your engine. [C,ESQL,benchmark,tpc] Download .tar.gz  

^back to top

SQL-Tools

dbimport.ksh Mimics the functionality of the dbimport utility on the XPS engine [KSH, LSDW, SQL]  Download .tar.gz  
dbinfo_lk Displays INFO statement output [AWK, DBA, SQL]  Download .tar.gz  
dbpipe Executes SQL from multiple sources through a single dbaccess process [AWK, KSH, SQL]  Download .tar.gz  
dbspace_pages Reports unused space in all dbspaces [DBA, SH, SQL]  Download .tar.gz  
dbspace_space Reports unused space in all dbspaces [DBA, SH, SQL]  Download .tar.gz  
defrag_table Defragments tables [DBA, PERL, SQL]  Download .tar.gz  
exec_sql_udr Bladelet that provides dynamic SQL functionality within an SPL procedure [C, ORDBMS, SPL, SQL]  Download .tar.gz  
hierarc_sql Handles hierarchical data like parts explosion [ACE, ESQLC, SQL]  Download .tar.gz  
infspy Watches SQL activity over TCP/IP connections [C, MISC, SQL]  Download .tar.gz  
isqlperl12 isqlperl 1.2 – perl interface to Informix databases [C, MISC, PERL, SQL]  Download .tar.gz  
oncheck.ksh Mimics the oncheck utility’s functionality on XPS [KSH, LSDW, SQL]  Download .tar.gz  
onspaces.ksh Mimics the functionality of the onspaces utility on XPS [KSH, LSDW, SQL]  Download .tar.gz  
period Bladelet that provides SQL support for managing fixed time intervals [C, ORDBMS, SPL, SQL]  Download .tar.gz  
pload.tar Scripts to help manipulate the onpload database without going through the graphical user interface (not same as pload.zip) [KSH, LSDW, SQL]  Download .tar.gz  
pload.zip Scripts to help manipulate the onpload database without going through the graphical user interface (not same as pload.tar) [ESQLC, LSDW, SQL]  Download .tar.gz  
random_udr Bladelet with several random number User Defined Routines (UDR’s) [C, ORDBMS, SQL]  Download .tar.gz  
ratios.shr_ak Script and SQL to calculate server performance metrics [AWK, DBA, KSH, MISC, SQL]  Download .tar.gz  
recreate_er_define_stmts Enterprise Replication – Reverse engineer “cdr define” statements from syscdr [DBA, MISC, SH, SQL]  Download .tar.gz  
setixd Tools for Working with Multiple INFORMIXDIRs [C, DBA, SH, SQL]  Download .tar.gz  
size9 Script to size databases, esp v9 [DBA, SPL, SQL]  Download .tar.gz  
split_udr Bladelet with two string handling UDR’s similar to Perl split operator [C, ORDBMS, SQL]  Download .tar.gz  
sqlcmd-90.02 Interprets and processes SQL commands (Version 90.02) [C, ESQLC, SQL]  Download .tar.gz  
sqsl Structured Query Scripting Languge Tool [BISON, DBA, ESQLC, MISC, SQL, YACC]  Download .tar.gz  
tbrpt Combines several tbstat options into one report [AWK, DBA, SH, SQL]  Download .tar.gz  
trigger_test Tests triggers and stored procedures from I4GL [DBA, I4GL, MISC, SQL]  Download .tar.gz  
tx_split Splits SQL update/delete statements into smaller transaction groups to avoid lock table overflows and long transaction problems [DBA, ESQLC, MISC, SQL]  Download .tar.gz  
upper_spl Methods for upshifting characters in SPL [ISQL, MISC, SPL, SQL]  Download .tar.gz  
upshift_spl Methods for upshifting characters in SPL [ISQL, MISC, SPL, SQL]  Download .tar.gz  

^back to top

Stored Procedures

add_date_eom Adds/subtracts dates, forcing bad results to end-of-month [MISC, SPL] Download .tar.gz  
currentdb Stored procedure that returns current database name [MISC, SPL] Download .tar.gz  
datespl_jl Stored procedures that calculate several ISO 8601 date values [SPL] Download .tar.gz  
exec_sql_udr Bladelet that provides dynamic SQL functionality within an SPL procedure [C, ORDBMS, SPL, SQL] Download .tar.gz  
informixtypes Stored procedures to decode coltype and collength into strings [SPL]  Download .tar.gz  
mdspatial Multi-dimensional spatial datablade module [C, ORDBMS, SPL] Download .tar.gz  
mkfinderr Creates unload file of first lines of all Informix error messages for use in a table accessible via SPL [KSH, MISC, SPL] Download .tar.gz  
newupper A version of upper() designed to run faster [MISC, SPL] Download .tar.gz  
orclproc Oracle function equivalents as stored procedures [DBA, ISQL, SPL] Download .tar.gz  
period Bladelet that provides SQL support for managing fixed time intervals [C, ORDBMS, SPL, SQL] Download .tar.gz  
random_spl Stored procedures for generating a random number [ISQL, SPL] Download .tar.gz  
soundex_spl Stored procedure to return a 5-position Soundex code [I4GL, MISC, SPL] Download .tar.gz  
spl_jl_20021010 Collection of stored procedures and functions, some of which are more recent versions of those appearing in other Repository packages [SPL] Download .tar.gz  
spsl Stored procedure that shows who owns locks on a table [DBA, SPL] Download .tar.gz  
unixtimespl Stored procedures that convert seconds to/from datetime values, which is often helpful in Unix environments [MISC, SPL] Download .tar.gz  
upper_spl Methods for upshifting characters in SPL [ISQL, MISC, SPL, SQL] Download .tar.gz  
upshift_spl Methods for upshifting characters in SPL [ISQL, MISC, SPL, SQL] Download .tar.gz  

^back to top