which its PK is of a SERIAL datatype, and to retrieve the just
generated pk, I execute the following select:
select dbinfo('sqlca.sqlerrd1') from systables where tabid=1

Good Day
I have the following problem which I would appreciate some help with
I have a Stored Procedure which executes a System command to call a 4G
program.

I have this query, ( below is the sqexplain file ).  It's a bugger for sure.
Anyway, pardon my igorance, but I don't understand something. The stprofil table ( st ), is a view of some very big tables.
If I do a dbschema -ss on it, there are no indexes. I'm not even sure you can put ...

I am in the process of moving my informix instance from local drives
attached to our server to some disk space on our SAN. I've gotten the
dbspaces and associated chunks set up based on the raw disk files on
the SAN drives, and the instance is up and running. Root dbspace seems

where can I find the number of the actual client version?
I need this for an other application.
registry, systemvariable ???
thanks

 I do a ER primary-target  between 2 server:
 primary server :  redhat as3 , ids 9.4.uc5
 secondary server : redhat 7.2 , ids7.31.ud2
sqlhosts's set up:

Has anyone practical experience of mixing HDR and ER in the same
environment, as is now possible in IDS 10?
rgds

Need to output the data from a blob in a format that will fit into
Excel - but as users have added returns, it messes Excel up and puts
data on the next line.
How to remove the hard returns? Replace won't work on blobs - tried

I am not v familiar with bash so please don't laugh at me!
I am getting that horrible "undefined regerence to main..." when
linking two objects, one of whick DOES have main defined. Could some
kind soul look at the makefile below and tell me what I am doing wrong?

Hello Madison (and the rest).
Setting up my test ER/HDR environment I came accross a problem.
The environment consists of three instances, each on it own host.
Instance A (IDS10.00UC5 on RHEL 4) is primary in ER,

We recently upgraded to Informix v 9 from 7.31 with one of our
customers, and we are having trouble with some correlated subqueries.
In dbaccess they appear to run fine, but under some processes they run
slowly.

IDS 10.0 on RHEL AS 4:
We're setting up a new database server for an OLTP application (24x7
website).  We've agreed on 100Gytes of application dbspace in a single
dbspace.  What are poeple's opinions on having 10 x 10g chunkis rather than

IDS 10.00.FC1
Solaris 10
Suppose I am running HDR.
Now suppose I run 'onunload -t <filename> <database name>' on the secondary.

We have a standby database here for backup purpose. Taking a backup from
production db using onunload, and restoring on standby system with
onload.(using IDS 7.31 on HP/UX) how can i make the restore operation go
faster? i have read something about modifying onconfig parameters such

Hello... I am new to this group... as well as a new informix DBA...
I was wondering if there is anyway for me to know is the partnum column
from table systabnames in the sysmaster database is a unique column.
I checked my database and it is unique.  Is there any documentation on