Hi, I have to process table row by row but without using cursor! Is there any alternative for it in Informix? I tried to get first row and put it in...

AT

07-19-2006 11:29 AM
bozon

Dear all, We have just installed Informix 10 IDS on Linux. Now By using 'export TMOUT=180' all the login with prompt is going logoff if no work is...

AT

07-19-2006 10:30 AM
Art S. Kagel

Dear Group, Can i install Install IDS 2000 9.21 UC 3 on Linux manderak ? thanks for your support Yours, A.Hassan

a.samy00 (AT) gmail (DOT) com

07-19-2006 10:27 AM
Jonathan Leffler

Hi, I’m have a problem, I would like know how return a last day of the month in db Informix . Thank you. leandro@logus-consultoria.com.br.

leandro_logus

07-19-2006 05:05 AM
AT

hello , i need some help for a complicate sql search, hope someone can help me Problem: Table A: mega_grp, grp ---------------------- e.g. ...

Thorsten Knopel

07-19-2006 02:53 AM
Thorsten Kettner

Ian Michael Gumby wrote: We're seeing you Gum. But Verizon doesn't have it's act together. Besides, they own USENET now so if they F*&^UP we're...

Art S. Kagel

07-18-2006 04:19 PM
Art S. Kagel

IBM suggested I upgrade my 9.4UC7 to UC8 for an assertion error issue. My development server was running 9.4UC5 so I decided to try the UC8 there...

Gary Quiring

07-18-2006 12:44 PM
Dale Gilbert

Hi All, I am using IDS 9.4 . Using Multiset i have developed a query which is generating the desired output but takes around 3 minutes to generate...

AT

07-18-2006 09:35 AM
bozon

Hi All, I am trying to run an sql statement which is like select from (select) statement.This sql query works fine in oracle database & throws an...

AT

07-18-2006 08:18 AM
macgillivary

Hi, I intend to make ER betwen AIX ids 9.4 (primary server) and HP ids 7.3 (secondary server). I used to set up ER in the same version of ids , and...

AT

07-18-2006 07:09 AM
Madison Pruet

Adam Tauno Williams wrote: onstat and even tbstat weren't even invented in this era. ;-) No, you are thinking of ANALYSE. A VACUUM, as detailed...

VD1

07-17-2006 05:25 PM
Mark D. Stock

Is there any disk benefit gained from doing an Informix restore ? In other words, does a restore cause data to be placed more contiguously on the OS...

Floyd Wellershaus

07-17-2006 04:59 PM
Art S. Kagel

I have spend DAYS trying to do this. I have no idea what to try next. I uninstalled the 64 bit sdk and tried to install the 32 bit, using the IBM...

kjuliff (AT) gmail (DOT) com

07-17-2006 12:27 PM
kjuliff (AT) gmail (DOT) com

Can anyone provide the command how to send a text file as a attachment with a proper subject using mailx or sendmail command in UNIX. Note: I am...

yy4 via DBMonster.com

07-17-2006 11:23 AM
bozon

IDS 10.0 UC5 on RHEL 4 AS If I disable kaio it's fine but if not ... Probably a kernel tuning thing but I can't for the life of me see what. Any...

Neil Truby

07-17-2006 06:45 AM
Neil Truby

Hi Everybody One table has got locked and the error number itis giving is 244 and 107(ISAM error) Before that delete query was fired on the above...

Prateek Jain

07-17-2006 03:20 AM
Jonathan Leffler

Did I read somewhere that I-SPY has a bug and will not work with IDS 10.0 xC4? I thought I did, but just did a Google search and can't find...

Neil Truby

07-16-2006 07:39 PM
Jonathan Leffler

I see the instructions for this as ../installclientsdk (the online instructions) ../installclientsdk -i printed from another IBM source If I do the...

kjuliff (AT) gmail (DOT) com

07-14-2006 11:25 AM
Andreas Breitfeld

A great company, in a great city(read that slowly Stuart), St. Louis, Missouri, USA is looking for a 4gl coder. It's a permanent gig. Email me for...

Hamilton, Jerry

07-14-2006 11:05 AM
Hamilton, Jerry

Hi! I am using the latest JDBC Driver for IBM Informix (3.00.JC3), supplied by IBM itself. My problem is this. I have a table with an INTEGER as...

Torsten Schlabach

07-14-2006 07:36 AM
Torsten Schlabach

All, My Informix 7 Server peformance on the Local Area Network is very acceptable, when connecting a new site using 2 Mbps, client experience was...

WalidFahmy

07-14-2006 04:24 AM
Jose da Fonseca

Hi, Today is Bastille Day and your last chance to participate in the 2006 4GL Study. Go to: http://www.jgp.net/4glsurvey Results will be published...

Jean Georges Perrin

07-14-2006 02:13 AM
Jean Georges Perrin

client server application performance over lan is very good but over wan very poor bandwidth is not an issue as the wan links is not saturated at...

m.mahmoud

07-13-2006 07:21 AM
m.mahmoud

hello,everyone,I am the newcomer.I hope you can go to this website:flickr.com/photos/partpic/.I am sure it is NOT spam. Then,you can feel that it is...

Part Pic

07-13-2006 04:20 AM
Part Pic

somebody help me ? we are using Informix 9.4 UC2 with Linux, but anytime the database server show (TOP) column idle 5%. How can I know which...

Cristiano Torres

07-12-2006 11:19 PM
PeterP

HI, I am using dbexport/dbimport to migrate db from IDS 9.4 to IDS10. Two quesstions, (1) Any tricks to improve the performacne? (2) If ...

Quman

07-12-2006 03:28 PM
bozon

Hello! Sorry for dumb question, but can't find such simple thing in SQL reference. So how can I create user from SQL script? Something like 'CREATE...

Serge Kholod

07-12-2006 12:19 PM
Art S. Kagel

We have a customer with a number (>100) of databases within the same IDS V10 instance who run a different end of day process at a different time on...

AT

07-12-2006 12:17 PM
Art S. Kagel

9.40.FC5 Solaris 9. Someone has suggested to me that I could unload the statistics data from the database catalog, run the batch data load, then put...

Campbell, John \(GE Cons Fin\)

07-12-2006 11:52 AM
Campbell, John \(GE Cons Fin\)

Although I have read the IBM documentation I cannot find what 32 bit ODBC driver is available for IDS 10. I need the 32 bit version as, though IDS...

kjuliff (AT) gmail (DOT) com

07-12-2006 10:29 AM
Sheshnarayan Agrawal

Can someone please tell me what setting I should use for this parameter as I can't find much information on it. Do I need to do anything at all if I...

Colin Dawson

07-12-2006 09:44 AM
Floyd Wellershaus

hello,everyone,I am the newcomer.I hope you can go to this website:www.flickr.com/photos/partpic/.I am sure it is NOT spam.Then,you can feel that it...

Part Pic

07-12-2006 05:13 AM
Part Pic

I'm currently installing a new system (obvious due to prior postings). It's running on a Linux-OS, and I'm using software RAID1 for data security....

disposablegarry (AT) googlemail (DOT) com

07-12-2006 04:08 AM
disposablegarry (AT) googlemail (DOT) com

Hi, I'm trying to set up a new installation of Informix, and not having done anything much with Informix for something like 5 years, I recon I'm a...

AT

07-12-2006 12:12 AM
John Carlson

Hola, quisiera saber si alguno de ustedes me puede informar que quiere decir el parametro del onconfig TXTIMEOUT 0x12c, a cuantos segundos...

vesf

07-11-2006 02:36 PM
Art S. Kagel

Is anyone using or have used Cobrasonic db_sonar and db_expert enterprise ? The product description seems pretty nice, like it does more things than...

Floyd Wellershaus

07-11-2006 12:55 PM
Art S. Kagel

Hi people !! I have 2 questions about ER in Informix 9.40: 1 - I am testing ER in a same host, using Linux and Informix 9.40, but I am receiving...

AT

07-11-2006 03:16 AM
TBP

When I launch a MTS transaction against an Informix 9.40UC2 or 10.0UC3, the transaction appears to be completed in the client side, but in the server...

Francisco

07-10-2006 07:47 PM
nrice

Hello, after a cold recovery of Informix 9.40 UC2 the status remained in Fast-Recovery. Last line of the online.log during recovery was: 11:50:28 ...

GemaVi

07-10-2006 01:59 PM
AT

Invoices being processed - Invoice No: 209001699 Program stopped at "st_invtype.4gl", line number 102. FORMS statement error number -1226. Decimal...

Heath Norton

07-10-2006 10:34 AM
Olmedo Monteverde

we are using Informix 9.4 UC2 with Linux, but anytime the database server show (TOP) column idle 5%. How can I know which session a lot of CPU in...

Cristiano Torres

07-10-2006 10:15 AM
Art S. Kagel

I am trying to create an esql program BUT within it I need to open and close a UNIXodbc datasource. Because of this I'm having problems. I can...

kjuliff (AT) gmail (DOT) com

07-10-2006 10:10 AM
Art S. Kagel

---------- Forwarded message ---------- From: Quman <yquman (AT) gmail (DOT) com> Date: Jul 7, 2006 11:55 AM Subject: Re: fragment elimination on...

Quman

07-10-2006 01:47 AM
Superboer

I need some help in the process of conversion from 4gl to egl. This time around I`m doing that conversion from the ground up, and I've come across...

AT

07-07-2006 03:21 PM
AT

I have a table, ds_archive, I just run alter fragment on table ds_archive add partition pt7 (archive_dt >= datetime(2008-01-01 00:00:00) year to...

Yunyao (Frank) Qu

07-07-2006 01:47 PM
Yunyao (Frank) Qu

Hi, I have a pb connecting to an IDS 10.0.TC4 on Windows. Dbaccess works fine. Ilogin works fine. JDBC refuses the connection. Netstat reports well...

Jean Georges Perrin

07-07-2006 12:53 PM
Guy Bowerman

Alguém conhece algum recurso Informix em Recife/Pernamcuco/Brazil ? _______________________________________________ Informix-list mailing...

AT

07-07-2006 12:43 PM
AT

Alguém conhece algum recurso Informix em Recife/Pernamcuco/Brazil ?

Tarcisio Gouveia

07-07-2006 12:38 PM
Tarcisio Gouveia

I just installed IDS 10 UC4 . Every thing looks fine. But it only displays the following one line when I run " info columns for table...

Quman

07-07-2006 10:12 AM
Art S. Kagel

Hello All, Wondering about the reasoning behind doing something like..... create index some_index on employee ( toupper (department_name) ); 1....

Tam OShanter

07-07-2006 09:44 AM
Art S. Kagel