I'm very new to informix and I try to write simple test procedure that
return multi rows value to the caller.
I tried :
create  function func1(c1 varchar(255)) returning  person_t2;

I have an Informix 5-based application on AIX and need help with SQLEXECD
(I-Star).  Specifically, I am trying to get desktop PCs running reporting
software (e.g., Crystal Reports) and the Client SDK to be able to access my
Informix 5 databases.  

Database selected.
 201: A syntax error has occurred.
Error in line 1

All my logical logs are full and I have a long running job that have filled
the logs.
I tried to do a backup of the logs with "onbar -b -l", but that gave my the
following error :

I have IDS 7.31 FD6 running on AIX 5.3. For memory configuration I have
the following parameters in the onconfig file:
BUFFERS 2100000 (aprox. 8.4 GB)
SHMVIRTSIZE 767000

All;
I need a copy of 9.3 or 9.4 IDS for Redhat (32bit). I'm hearing that IBM no
longer sells 9.x...
Anyone have a copy to sell?

Is any know , how can I monitor which user alter my table ?

HP-UX11i; IDS9.30HC5; i4GL 7.20UD8 (I know they're old but we're
working on it.... )
Just had this pair of errors (finderr output and the 4gl context
below).

Im working on Windows environment.
my scenario is something like this:
I have pc A and B. I have install the informix database in pc A. I want
to use pc B to access the database. How should i go about it?

We are running around 10 stable instances of IDS 9.21 with lots of 4GL
code written in v7.3 on HP-UX 11.0.
I know, it's really old and long overdue for an upgrade !! We tried for
some time, but de-support of HP-UX 11.0 is finally enabling us to

And here I thought there was some momentum building that we could
leverage and sell fist-fight tickets at conference.....  oh the
potential !
don't mean to be overly asinine or humorous.....  I have been doing

Is it possible to dd an ontape backup from one tape to another, to make
a copy of it ?
Dirk Moolman
Database and Unix Administrator

 I need to query my database from MS Excel. I am using INFORMIX SE 7.2 on WINDOWS XP. How can i do it?. Where can i get the appropriate ODBC driver?. Do i need the whole CLIENT SDK?.
 Thanks a lot
Cordial saludo:
Luis Carlos Díaz Otero

New Informix user - coming from Oracle here. I'm baffled.
Why doesn't something simple like:
select * from (select * from bob)
work?

O/S AIX 5.3
Engine IDS 9.4 FC6
We currently use a very simple (but highly effective) archive
mechanism, ontape -L 0 every night (approx 1.25 hrs) and ontape -c (to