Stored Procedures & SPL

Stored procedures and functions in Informix SPL, the server's procedural language. Threads cover writing and debugging procedures, returning multiple rows, handling errors with exceptions, and calling procedures from applications.

2,109 threads, 1992–2019.

Problem with SYS_CONNECT_BY_PATH i SPL

Re: datatype for string

Re: ISQL problem

four j's client connect error

Re: What's happened to the http://www.ibm.com/informix ?

Monitoring Informixservers

ER out of sync

Re: load statement error on 4gl

Insert to a TEXT field using SPL

Re: Dynamically allocated new virtual shared memory segment repeatdly

Functional Index & sizing

Re: SMI queries to calculate the buffer wait ratio, the buffer turnover rate and the readahead utilization

System Error on Windows 2003 x64 DB Server

Re: Dynamic Sql - -661 Errors

Lcok iSsue on Sysproc plan catalog table

Re: ERROR 770 on IDS 11.50 FC6

am I catching the exception?

improve user defined function for cutting of trailing blanks

Subquery or Join?

Re: Dbspace recovery

RE: Copy Table Schema ?

Re: Looking for ESQL/C Multithreaded Source Code Example

Re: Update statistics after the upgrade

catch exception within a foreach loop and move to the next row

Re: catch exception within a foreach loop and move to the next row

Re: A teensy-weensy little oversight in the QA suite?

Re: how to use a trigger to stop an insert/update?

Update statistics after the upgrade

How to tell if a given temporary table exists in the current session?

how to use a trigger to stop an insert/update?

Re: Informix FAQ

Informix DB on SAN with SRDF

Re: trigger on insert: updating one value of the same table

Help!!! syntax error

Re: Can I optimize the engine here or do I have to get the developers to change the SQL?

Re: sysmaster query help

RE: help with fragmentation scheme

shm wrong buffer status

Re: help with fragmentation scheme

Re: ontape of large database

Re-select row after insert in 4GL?

A rogue update hard to find.

Buffer Turnover Rate for IDS11.x

SPL result set

I should know this - sql output formatting

Stored Procedure Returning Record Set and column names?

Calling stored function

Informix DBA position Available in Huntington Beach CA -Know anybody for it

Re: External backup

On SP's performance (kinda weird)