I need to make a screen shot report on some of my programs as soon as
the users presses the accept-key to start processing transactions for
audit purposes. I've been using the DBSCREENOUT for years and know
this to be the easiest way to get a screen dump but the problem is

i am needing to move some existing tables that are rather large to a
different dbspace.
what is the best and quickest method to do this? (hoping that the
quickest is also the best)

--0-975139384-1106928503=:17286
Content-Type: text/plain; charset=us-ascii
We are selecting 500,000 rows into a a cursor, with an order by, then processing those rows with by fetching them and doing work with them.
I assume our tempdbspaces are being used for this.

I am trying to determine how many locks have been used
or are currently being used.  On IDS 9.3 we can do an
onstat -k and look at the last line of output but when
we try to do the same with IDS 9.4 the onstat -k often

I ran into a problem where $sth->err was not being set to the
appropriate Informix SQL error. It was always being set to undef. This
only happens when I was using an ISPY server. If I run the exact code
and point it to the actual Informix server, $sth->err gets set correct.

We have recently encountered a problem which has left
us a little less
than happy.  We have IDS 9.30.FC6 installed on AIX 5.2
on an HACMP

New to this Usenet group :)
And this is my first posting,,,
I run IDS 7.31 TD6 on a NT4 box today and are planing to move to a
Windows 2000 Server with SP4.

Anyone else using this platform for IDS?
I am not impressed by performance of 9.40 on this platform so far. It's
only about 25% faster than standard engine on our old AIX box! For
reference the hardware we have:

I have informix  9.40.TC4 on Windows 2000 and I would like to automate
the ontape. I have created a batch file as follows:
cd C:\Program Files\Informix
echo ol_ctseu11.cmd

i am looking to sum a summed column. in sql server, there is a compute
function that will perform basically a sum of a sum. is there any way
to do this through sql in informix? we are on 9.40.
MSSQL SQL:

In case you have not heard about this yet, there is new third-party
technology
for IDS in the form of an indexing DataBlade.  It's good stuff.
Learn how to load data up to 25X faster on the exact same hardware

If I have 1.6 billion lockreqs is this going to create a major problem (lag etc)
if so does increasing the locks help?

Buen dia a todos,
Somebody knows that company in Peru sells the Server Studio?
I need buy that tool.
Alguien sabe que empresa en el Peru vende el Server Studio ???

IDS9.50/IDS10.00 ?
.... I want this fix ... ;)
Chucho!
rwboardley@west.com wrote:

How do I sort always in UCS-2 character set. Even if my CHAR and NCHAR
column character set is different.
Thanks,
Irfan