We currently have an old version of SE, 7.1 (date on the files is
1995, is there a way to pull the actual version number, the release
directory files don't seem to have it).  We are running applications
on 4gl RDS 6.03.UC1.  I seem to have been successful in beating the

i have a tranzaction which ahve lock on some tables.
The session it is not on informix server.
I see with onstat -x :
e0363b08         --X-G 0                33     16462   16462

hi friends
 i have some problem in creating a procedure in ttisql
i have written a procedure which syntactically correct in sqlplus of
oracle 10g.

Hi friends
  i am facing a severe problem in cache connect to Oracle.i tried
much but i got an error
that DSN not found or default dsn not specified

Hi Partners,
We have  Three   QA   Analyst's  for your projects
(1)
Name:                         Mahi

I've receive those errors, while the database is online but users can't
connect to it using the ODBC.
It seems like corrupted index on a system catalog table sysprocplan, can
I rebuild the catalog database or one of its components? HOW?

I am contracting at a new site and I need to return the PK from an
insert that I am making.
I have seen quite a few statements but not sure if this is correct?
select SQLCA.SQLERRD[2] from informix.myTable

Are there any tools out there that I can use to connect to and look at
our Informix databases.  I am looking for a "free" utility similar to
PC Client/Sybase Central or MySQL Admin etc.  I have used the dbaccess
menu driven utility in the past, but I wondered if there is something

Has anyone a technique for compressing onunload output as it's created ...
and uncompressing it directly to onload?
Similat to the ontape -s -t STDIO facility.
thx

select
select (today-day(today)+1) - INTERVAL (2) month  (2) TO month D1,
today D2
 from systables  where tabid=100

Hi Family.
I have a problem I have encountered before, years ago!
Reasons aside (relating to a failed restore) when I tried to bring up
the engine, it failed. No shared memory segments exist for the

I know this is kind of lame problem, but I realy cannot get over it.
So, I want create a procedure:
CREATE PROCEDURE delete_subject_if_no_program(subjectoid INT)
DEFINE ref INT;

Thanks in advance for your help.
Mike Badar
ESRI Professional Services

Is MACH 11 (http://www.physorg.com/news98803681.html) simply internal jargon
for RSS nodes or SDS nodes running in a blade center consisting of 1
read/write primary and multiple read only secondaries or is this something
completely different?

On IDS     10.00 when I  trying to startup it remains eternally.  In
another screen (onstat -) appears IBM Informix Dynamic Server Version
10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576
Kbytes Blocked:CKPT.