comp.databases.informix

Syndicate content
Informix database management software discussions.
Updated: 51 min 12 sec ago

"set environment variable

Fri, 2008-11-21 16:01
Hi, i note there is not a FGL_SETENV function in traditional Informix
4GL
Anybody has resolved how to set an environment variable (linux, bash)
from 4gl program??
i need:
$ fglgo my4gl
-- my4gl must set MYVAR=SOMEVALUE
$ echo $MYVAR
SOMEVALUE
Can make this works....
Thanks!

"garbage after unsintall BTS 1.10

Thu, 2008-11-20 18:32
Hi,
I have here a IDS 11.50 UC2 Developer with BTS 1.10 installed and registered in a database.

Now I will migrate all data to another instalation with IDS 11.50
UC3 Developer on another machine, and I want to use the dbexport. So I
execute the dbexport and see a lot of casts, data types, procedures

"Query Web Service from Informix 4GL

Thu, 2008-11-20 15:11
Hi !!
Our DBA tell us (developers) that in informix IDS 11.5 and his new
version of Informix 4GL we can query web services from Informix 4gl
program.
I cant find any help or guide to do this.
Does anyone have some link or doc where i can get info on this
function ?
Thanks !!!
Enrique

"Informix Roundup: 19 November 2008

Thu, 2008-11-20 12:49
Whoops! I forgot to post this!
[link]

"Why would a query work on one machine but not another?

Thu, 2008-11-20 02:12
I have an install of 11.5 in production and one in development. The
installs should be the same, except one machine is fedora and the
other is debian. On one box I my query works on the other I get a
-360 error "Cannot modify table or view used in subquery." I am
deleting duplicate rows with:
DELETE FROM table

"On undocumented table Sysshmvals

Wed, 2008-11-19 18:29
Hi everyone.
While I was checking an auditing script from a third part I found that table Sysshmvals field sh_ovlmaxcons is used to establish the max # of connections. I found out complete information about this table at [link] and I verified that actually field represents which it's supposed to do.

"Recovering a primary and secindary using SAN techniques (quite long)

Wed, 2008-11-19 00:57
IDS 10.0FC8W2 on HP-UX 11.31:
We've set a up DR system for a customer.
Their system - a Primary database and an HDR pair - run at site A. The SAN
LUNs containing the primary database (but not the temp dbspaces) are in a
consistency group and are replicated syncronously to a SAN at Site B.
The recovery process at Site B, in the event of failure, is thus:

"SQL Developer - diagram editor slow

Tue, 2008-11-18 19:04
Hi there,
I'm been using the SQL Developer GUI from:
[link]
I'm using this to run queries on a Informix 10 db and also draw
diagrams of the table relationships.
When connnecting to my database I notice that all the other dbs on the
server are displayed e.g:
Databases ->
|- my_db@my_server

"Informix roundup: 17 Nov 2008

Tue, 2008-11-18 02:30
The Timmy Special Remix:
[link]

"Error -23197 from scheduler

Mon, 2008-11-17 16:25
Using 11.50 X1, am seeing the following error in online log:
...
17:58:56 SCHAPI: Error -23197 Database locale information mismatch.
17:58:56 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation,
Location: NULL.
17:58:56 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation,
Error Message: Unable to execute function [ aus_evaluator

"Re: dbschema and informix.sysseclabelcomponents [SOLVED]

Mon, 2008-11-17 00:40
Thanks to Art the problem is now fixed. You can't use the Informix 11 dbschema
against an Informix 10 database - either use myschema or the correct version
of dbschema.
Thanks

"dbschema and informix.sysseclabelcomponents

Sun, 2008-11-16 21:20
One of our databases we have installed on Informix 10TC8 on Windows. From our
Solaris development when we try to do a dbschema we get the following error:
-206 - The specified table (informix.sysseclabelcomponent s) is not in the
database.
-111 - ISAM error: no record found.
This doesn't happen for any other of our databases, whether local or remote.

"technological singularity

Sun, 2008-11-16 04:21
The technological singularity is a theoretical future point of
unprecedented technological progress, caused in part by the ability of
machines to improve themselves using artificial intelligence.[1]
Statistician I. J. Good first wrote of an "intelligence explosion",
suggesting that if machines could even slightly surpass human

"Informix Roundup: 14 Nov 08

Sat, 2008-11-15 01:32
The wodka edition:
[link]

"connecting to informix

Fri, 2008-11-14 21:51
I am trying to connect to Informix using an existing application with
a field for a connection string. Using the ODBC driver works great,
however I would like to use the .NET driver for performance reasons.
Is there a way to specify the string use that driver instead of the
current example:
Driver={IBM INFORMIX ODBC

"For those who keep asking for a "free" version...

Fri, 2008-11-14 19:38
Watch history in the making as Sun Micro is taking a hit after the
MySQL purchase.
Can you say $1 billion dollar waste?

"it was a SCAM you FUCKERS reti roscoe and holland

Fri, 2008-11-14 10:28
it was a goddam SCAM
you couldn't deliver
and when i discovered it you fired me
i challenged you KARL RETI about the scam
you fired me
you stole my designs you demonstrated designs to me (presentations,
your own)
these are times of equalisation reti, roscoel, holland
i am not finished yet
sue me you human effluent