I am very new to informix so be kind.

- Do stored procs have a procompiled/cached query plan in informix? If
you have any links discussing it would be very helpful.
- Does informix have anything similar to DTS packages in MS SQL Server
for doing optimized nightly loads of datafiles? Currently we are using
some incredibily inefficient shell script or compiled external load
program and it is causing major problems holding locks and taking
several hours to complete (i could do this load in SQL Server in under
and hour)