First published in the Washington Area Informix User Group Newsletter Volume 7, No.3 – July 1997 This article will take a look at some tricks for using SQL to generate SQL to help you maintain and support your databases. One of the advantages of querying the system tables is that you can use the output […]
Tag Archives: WAIUG
A Web/CGI Interface to the ONSTAT Utility
First published in the Washington Area Informix User Group Newsletter Volume 7, No. 2 – April 1997 This is one of the scripts I presented at the WAIUG Training Day. The purpose is to provide a web interface to the INFORMIX-OnLine ONSTAT Utility. There are two parts to this interface: the first is a […]
Error Handling Functions in Informix Programs
First published in the Washington Area Informix User Group Newsletter Volume 6, No. 2 – April 1996 This article defines some guidelines for error handling functions. An error handling function is the code that responds to a user or system generated error. There are two classes of errors: fatal errors and non-fatal errors. Events that […]
Roles – A New Security Feature in INFORMIX OnLine 7.10.UD1
First published in the Washington Area Informix User Group Newsletter Volume 5, No. 4 – October 1995 INFORMIX OnLine 7.10.UD1 was released with a few surprises in the form of new features. One of the features I was most interested in is Roles. Roles provide a way to grant and revoke privileges to a function, […]
Informix Online 5.X TB Utilities Quick Reference Guide
First published in the Washington Area Informix User Group Newsletter Volume 5, No. 2 – May 1995 TBCHECK Usage: tbcheck [-clist] [-plist] [-qny] [ { database[:[owner.]table] | TBLSpace number | Chunk number} { rowid | page number […]
Informix 4GL Programming Tips
First published in the Washington Area Informix User Group Newsletter Volume 4, No. 3 – July 1994 1. Only select columns that you really need When you select data, it goes from disk to memory. Ten un-needed bytes of data from 10,00 rows translates into reading 100,000 bytes unnecessarily. Avoid “SELECT *” statements and only […]
An Introduction to INFORMIX Database Security
First published in the Washington Area Informix User Group Newsletter Volume 4, No. 3 – July 1994 Informix applies security at the database, table and column level. All security is based on a users login name. Using Informix SQL, the creator of a database can give and remove privileges. The SQL command to give access […]
Reading Informix SE audit files
First published in the Washington Area Informix User Group Newsletter Volume 4, No. 1 – January 1994 Twice in the last month I have been asked how to read Informix SE audit files. Informix SE has a feature (this is not available in Informix Online) to create an audit trail of all adds, deletes and […]
An Introduction to Using Informix SQL in Shell Scripts
One of the advantages of UNIX is the power of shell scripts for developing systems. This article is an introduction to using shell scripts with embedded SQL to access your database. I am using the Informix database for these examples, and the Informix SQL command interpreter “dbaccess”. However, these examples will also work with Informix […]
Getting Informix Column Names Within Unix Vi Editor
First published in the Washington Area Informix User Group Newsletter WAIUG – Volume 3, No. 4 – July 1993 How often have you tired of retyping the same column names repeatedly in vi? One solution is to save the column names in a file and read them in as needed. However, vi has the capability […]
Informix 4GL Application Error Logging
First published in the Washington Area Informix User Group Newsletter Volume 3, No. 4 – July 1993 In every major application that I have developed, a requirement has been to have some way of logging what is going on inside the program. There are three types of application logging I like to use. The first […]
ANSI Terminal Emulation and Informix 4GL Terminal Capabilities
First Published in the Washington Area Informix User Group Newsletter, Volume 3, No. 3 – May 1993 In the Q&A sessions at our user group meetings several questions have been asked about creating termcap entries for PCs using ansi terminal emulation software to work with Informix 4GL. The following is the ansi termcap entry I […]