comp.databases.informix
"set environment variable
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!
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
Hi,
I have here a IDS 11.50 UC2 Developer with BTS 1.10 installed and registered in a database.
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
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
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
Whoops! I forgot to post this!
[link]
[link]
"Why would a query work on one machine but not another?
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
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
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.
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)
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:
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
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
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
The Timmy Special Remix:
[link]
[link]
"Error -23197 from scheduler
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
...
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]
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
against an Informix 10 database - either use myschema or the correct version
of dbschema.
Thanks
"dbschema and informix.sysseclabelcomponents
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.
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
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
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
The wodka edition:
[link]
[link]
"connecting to informix
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
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...
Watch history in the making as Sun Micro is taking a hit after the
MySQL purchase.
Can you say $1 billion dollar waste?
MySQL purchase.
Can you say $1 billion dollar waste?
"it was a SCAM you FUCKERS reti roscoe and holland
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
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





