Description:
Informix database management software discussions.
|
|
|
Error 310 - Table (xxxxxxxx) already exists in database
|
| |
Hi all, I have a big problem these days:
I have to import an old database to Informix 11.70.FC2 on Linux. The old db also resides on 11.70.FC2, and contains several tables with different owner, but same name, eg:
create table "SIACG".tabutin (
tn_tabella char(5),
tn_codice integer,... more »
|
|
|
ER tool
|
| |
Dezign for Database by Datanamics can reverse engineer from dbschema output
and generate Informix schema from ER diagrams.
Art
On May 16, 2013 9:49 AM, "Cesar Inacio Martins" <
...
|
|
|
ER tool
|
| |
Hi,
Anyone use a ER tool with Informix able to do reverse enginer?
Low cost or free ...
All I tested so far... anyone works... :(
In past (10 years ago) ERWin was a excellent choice , but today has a very
high price for my situation and their "community" edition is a joke.... and
I not sure if today it is compatible with Informix was early...... more »
|
|
|
Resizing a dynamic array
|
| |
Hi guys,
I'm having problems resizing a multidimensional dynamic array. Resizing a single dimension dynamic array works as expected though.
/home/user1>cat test.4gl
main
define l_dyn dynamic array with 2 dimensions of char(9)
allocate array l_dyn[2,2]
resize array l_dyn[3,2]
end main... more »
|
|
|
ER error
|
| |
Im wondering if anyone has seen this error?
15:37:07 CDR CDRD_217: transaction aborted (One or more rows in a
transaction defined with tx scope were rejected) with sql error 908 isam
error 0.
The 908 would indicate that the servers were not able to connect... but
then why would I get the error on the receiving server? some data is still... more »
|
|
|
AGS Server Studio - Extent Calculator
|
| |
IDS 11.50.FC6 running on Linux RHEL 5.3
We're in the process of moving our production databases (about 200GB) to new disk space, so I wanted to take the opportunity to recalculate the extent sizes for some of our larger tables. I'm planning on using the Extent Calculator in AGS Server Studio (version R.9) to determine the new extents. It takes row count, monthly growth %, index fill % and est. fill % for varchar columns into consideration to determine optimal extent sizes to accommodate 6 months of growth in the "next" size.... more »
|
|
|
Happy Mothers' Day!
|
| |
Returns of the day to all of the mothers in our little world and beyond!
Art
Art S. Kagel
Advanced DataTools ([link])
Blog: [link]
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any... more »
|
|
|
Fastest Informix DBA Contest 2013
|
| |
Advanced DataTools is pleased to announce our latest Fastest Informix DBA Contest!
This year the Fastest Informix DBA Contest will be held over the web so anyone, anywhere in the world can participate from July 1 to 31, 2013. Contest details and challenge will be posted June 1, 2013. The challenge will be a combination of OLTP and batch. The winner will be the DBA who can get the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job and generate the most bills in a 10 minute run.... more »
|
|
|
ER Problem
|
| |
IDS 11.7 FC7
Linux
Im getting this error when I try to run cdr chek on a single replicate.
cdr check repl -m g_psprod1sl -r abc_checks_incident_status -a
Error returned from getNumRows: select count(*) from
'informix'.incident_status
SQLCODE -252 ISAM -154
Error Details:
252: Cannot get system information for table.... more »
|
|
|
Skip 4gl form field
|
| |
to skip input fields, I have used code like...
before field voicemail
IF GET_FLDBUF(site) = "UCP" THEN
IF fgl_lastkey() = fgl_keyval("DOWN") OR
fgl_lastkey() = fgl_keyval("TAB") OR
fgl_lastkey() = fgl_keyval("NEXT") OR... more »
|
|
|
