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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |