DevX Tips Bank: Informix

Making System Calls in Stored Procedures

I'm writing a procedure to send an e-mail that will receive two parameters: the e-mail …

Query from One Informix Database to Another

I have two Informix databases existing on a Unix server. How do I write a stored procedure …

Informix Ontape Backups

I need to do an ontape Level 0 backup but I need to bypass the "Press Enter to Continue." …

Informix SQL

Are Transact SQL stored procedures currently running on a SQL Server 7.0 database …

Log Error

I am receiving this error in my log: connections rejected: no calls allowed for …

Changing the Environment Inside a Program

How do I change the environment inside a program (filename.4gl)? Example: setenv …

Maximum Number of Columns Allowed

What is the maximum number of columns allowed in an Informix table?

Informix Backups Error Message

We have Informix IDS 7.30 running under SCO 5.0.5. Backups by ontape fail with an error: …

Locking a Row

How can I lock a row in a table from a stored procedure?

Upgrading from AIX 4.2 to AIX 4.3

We have plans to upgrade our AIX operating system to version 4.3. We are using Informix …

Choosing a Column Depending on Procedure Argument

Can I specify the column I want to select from as an argument to the procedure? Something …

Determining Database Size

I am using Informix 7.24 and my raw partitions are getting quite large. Is there a way to …

Ontape for Backups to Disk

How can 'Ontape' functions be used to back up Informix/Lawson DB to disk? Is dbspace …

Dropping a Bad Chunk

I have a bad chunk in a dbspace that is bad and marked "down" by Informix. I don't really …

Validation on Date Inputs

I'm using Web Datablade and IIF to develop Web pages. I need validation (other than …