I'm an informix newbie. So my question is very basic.
After I have backed up the logical logs how is the process of
reapplying them to the database to get it current done ? The logs have
been backed up using ontape -a

Has anyone worked on developing a VTI/External Data Access Method for
linking to other ODBC data sources?
sending to informix-list

I am new in informix database administration. I am currently using IDS 9.21.UC4
on Solaris7. However, it run very unstable, which usually down with assertion
fail, and we are planing to upgrade our server to 9.4x.
Does the upgrade process complicated? Do we need to re-create all ...

Does anyone know how to find out the primary key value of last inserted
record? In SQL Server this would be done as follows:
INSERT INTO Customers(name, customerSince, isDeleted) VALUES (?, ?, ?);
SELECT id_customer, name, customerSince, isDeleted FROM Customers WHERE

We have an Informix 7.31 UC4 server running on HP Unix 11.11 with High
availability data replication. Due to network problems, replication stopped.
The primary database server was running without any problems for about 24
hours and all of a sudden with no apparent warning signs, the ...

Hi Gurus,
I was an Informix man , but my last job needs Oracle skills which i
have no experience. My question is about oracle real application
clusters. I know that

When trying to import a database it was discovered that the export had
not properly created the indexes. Any ifeas>#

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C3569F.0B53DCA0
Content-Type: text/plain;

Folks,
In looking at Google groups, I see that many of us are still
struggling with compiling on Windows systems some of the best esql/c
programs from IIUG.  Things like Leffler's contributions, Art's stuff,

I guess I can dig this info out somewhere but if you happen to know please
share what Intel/AMD processors are 'i686 compatible' ? (ie. Pentium II or
above or such)
Thanks,

I'm trying to insert from a select statement but it is giving me an error
that I "Cannot modify table or view used in subquery." on my where clause.
Why?
INSERT INTO hospcontact

I'm evaluating IDS 9.40.UC1E1 on Linux, specifically I was interested in
seeing how ONBAR works on this version (for backup/recovery).
I have a problem, I can backup, but a simple restore test fails.
Maybe somebody can help (or has suggestions);  it's not very urgent, since

Weird one here; this is a test case because some 4gl's we have are
behaving oddly in R4GL and IDB but *not* in i4GL.
In I4gl we get the tabname followed by a '1' or a '2' back as
expected, but in R4GL/IDB we get a -1214 NUMBER EXCEEDS LIMIT OF

Hi Rajib,
could your please explain "point the binaries to
the 7.3 version" ! How does this work ? What to do ?
Mit freundlichen Gr??en

Ok, so I installed Informix on a new box, setup environments, and it seems
to be working. Woo hoo!
However, when I create a new table through dbaccess, everyone has
permissions to it as the default. On our old system, no one has