I have been chasing a problem in an old long standing 4GL system. SPL has been added over the years. Weblogic and others (perl and the like) SQL have...

ian

08-17-2009 05:50 AM
lintel

On Fri, 14 Aug 2009 22:50:17 +0200, Richard Kofler <richard.kofler (AT) chello (DOT) at> wrote: In some cases a third of the lifetime would be a...

Penang

08-15-2009 02:47 PM
kony

Enviroment: Informix 7.31 S.O. HP-UX 11i I've heard about using the varchar data type has a certain overhead compared with the data type char. But,...

Peternt

08-14-2009 05:20 PM
Fernando Nunes

Sigh. KISS applies. 4GL apps are client/server. You may want to consider some sort of DNS / host mapping solution. That is, your application...

Keith Simmons

08-14-2009 03:47 PM
Ian Michael Gumby

Or 4GL or ESQL/C or C/C++ & ODBC or Java & JDBC. Lots of other interfaces. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art...

SGBoyUK

08-14-2009 01:05 PM
Art Kagel

Hi, the following shell script is a bit tricky but works and should solve your problem: pipe=cat ( dbaccess stores_demo 2>/dev/null <<- !EOF

Andreas Maier

08-14-2009 09:27 AM
Andreas Maier

Hi all, the HP-UX High Availability solution is called MC/Service Guard - this product is still available and also supported on Linux! So, if you...

Andreas Maier

08-14-2009 07:46 AM
Andreas Maier

Hello everybody, Our is planning to upgrade IDS from 9.4 to 11.50 along with hardware upgrade which includes FC attached disk array that will be...

Alexander

08-13-2009 06:04 PM
Alexander

SE 7.25.UC6R1 C4GL 7.32.UC4 I'm looking for a way to extract a value from a 4GL construct variable. Is using substrings the only way to do...

loc

08-13-2009 03:09 PM
Mike Aubury

Omar, Thank you. Yes that seems to work. I just need to grep for the sqlexec and map that to onstat -u. Works well. Thank you very...

Dave

08-13-2009 07:44 AM
Informix DBA

Hi... I'm trying to generate a WS using IBM datastudio 2.1. I create a script, and i can get it working if i use one only statement. How do I can...

Fmalmeida

08-13-2009 04:49 AM
Fmalmeida

Hi! After run checkpoint - SDS server is blocked. IBM Informix Dynamic Server Version 11.50.FC5 -- Read-Only (SDS) (CKPT REQ) -- Up 00:00:41 --...

zaiets.komus@gmail.com

08-13-2009 03:05 AM
zaiets.komus@gmail.com

All Running IDS 9.4 FC6 on AIX 5.3, application written in INFORMIX-4GL Version 7.32.FC3. (I know it's a bit old, but it runs well (till now...

Keith Simmons

08-12-2009 04:58 PM
david@smooth1.co.uk

Hi... Does anyone knows if it's possible to return more than one result set in a stored procedure? How can i do it? Thanks... Fernando Almeida

Fmalmeida

08-12-2009 01:32 PM
Prasad Mujumdar

Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix...

Nog

08-11-2009 04:20 PM
Nog

Hi: I have 6 temp dbspaces and only one of them shows me that this used to 90%. The other shows that I used 10% alike. Remove all Informix users...

emaus

08-11-2009 03:40 PM
LIGHT SCANS

Hi all, some weeks ago i installed Netbeans IDE and downloaded the JDBC Informix driver from IBM. I got a package which included...

Chris

08-06-2009 07:23 AM
grendal

Hi: I have 6 temp dbspaces and only one of them shows me that this used to 90%. The other shows that I used 10% alike. Remove all Informix users...

emaus

08-06-2009 03:17 AM
DBA

Hello, I have 3 Tables wich are related 1:1 with the field artikel Table1 fyar1sta Fields: artikel, artwgr fyar2sta Fields artikel, wbzkrit fyar3sta...

Ralf Hackmann

08-05-2009 03:51 PM
Omar Muñoz

In SQL Server I can create a procedure that would select all rows matching an input parameter, for example:- CREATE PROCEDURE . @UserId int...

mc

08-05-2009 12:36 PM
mc

emaus wrote: Not a problem I guess - your session is probably using PDQPRIORITY and has multiple scan threads maybe. Check output of 'onstat -g...

tilleul17@web.de

08-04-2009 11:34 AM
theBP

How can I force disconnect user threads from Informix IDS? Thanks.

gansvv

08-03-2009 10:53 PM
Jonathan Leffler

Hi. While I was studying contention on disk issues, I realized that my sysprocplan has a lot of write activity - in fact, it's the most written...

Omar Muñoz

08-03-2009 03:10 PM
jrenaut

Friends, The latest release of my utils2_ak package has been uploaded to both the Oninit web site (www.oninit.com/utils) and the IIUG Software...

Art Kagel

08-03-2009 08:02 AM
Art Kagel

Ok, While I'm using Java, it would be the same for C/C++. System.currentTimeMillis() returns the current system time in milliseconds.Note that...

Ian Michael Gumby

08-02-2009 03:59 PM
Ian Michael Gumby

The latest IDS 11.50 release 11.50.xC5 supports Merge statement which can be used for such update joins. For example, MERGE INTO tab2 USING tab1 ON...

Ralf Hackmann

08-02-2009 04:01 AM
Ralf Hackmann

We are running Informix 9.40.FC4 on HPUX-11i. For the past few weeks, we are experiencing this problem. The informix server keeps continuosuly...

Pankaja Kadakuntla

08-01-2009 04:47 AM
moppel

Preparing to migrate from IDS 10 to 11.5. Is there any downside to setting IFX_FOLDVIEW to 1? Thank you. DG IDS 11.5 Solaris 10

pretzel

08-01-2009 04:01 AM
theBP

Yellowfin, leading web-based Business Intelligence software providers, today announced the release of Yellowfin 4.1, the next generation of the...

JTP PR

07-31-2009 05:57 AM
JTP PR

We are working with Oracle ODI to connect to our non-transaction logged database. ODI wants to do begin work, commit etc... I know this is very...

Floyd Wellershaus

07-30-2009 02:57 PM
Jonathan Leffler

Right, I knew this. The question was more about PCIe over just relying on the SATA-3 interface. IBM released an SSD where half of the potential...

Ian Michael Gumby

07-30-2009 07:31 AM
Ian Michael Gumby

IDS 10.0 for example, any O/S. I've never understood why we have to an onmode -c block/onmode -c unblock when taking a clone of Informix's data...

Neil Truby

07-30-2009 06:25 AM
Neil Truby

Of course - in Aubit4GL you can generate PDF reports (same format as a normal report - just more options - so nice and easy to convert!) In that -...

loc

07-29-2009 01:05 PM
Sky Knight

LOL as if they'll let your arse in to this country. As if there aren't already enough Clowns here....

Bill Law

07-29-2009 12:07 PM
Ian Michael Gumby

Hello, I have following function in my Informix database: CREATE PROCEDURE climbertops(c varchar(128)) RETURNING row DEFINE result row(mountain...

agad

07-29-2009 03:55 AM
agad

Hi. I want to know if replacing former NUMCPUVPS, AFF_SPROCS, and so on for VPCLASS in IDS 10 brings any advantage in terms of better performance or...

Omar Muñoz

07-28-2009 05:17 PM
Fernando Nunes

Koya wrote: That looks more consistent with reality. But it would be fair to also say that usenet is dying... Even our Oracle "spy" has given up on...

Ian Michael Gumby

07-27-2009 08:01 PM
DBA

Hi. I catched a SP whichs take 10 seconds in perform. I checked that SQL onit was correctly written, used indexes, and so on (anyway, it's not a...

Omar Muñoz

07-27-2009 05:37 PM
Fernando Nunes

Doesn't rain on my parade, I could care less. I think that Oracle has to support competitor's databases as part of their acquisition. Unless of...

wcottishpoet

07-27-2009 02:32 PM
Ian Michael Gumby

onmode -yuck export TRACECKPT=1 oninit -v HTH, Paul M.

07-27-2009 02:10 PM

Folks, We have over 40 Informix DBA's participating in our new Fastest Informix DBA Contest. See http://www.advancedatatools.com/Informix/index.html...

Lester Knutsen

07-25-2009 03:56 PM
Lester Knutsen

All: With the recent post "End of an...

epsilon

07-25-2009 03:13 PM
Captain Pedantic

All: I have researched how to configure the dbaccess environment and have not found anything on this topic. My goal is to configure the dbaccess ...

epsilon

07-25-2009 11:43 AM
Luis Carlos Díaz Otero

Hi all, our php developers claim they need DRDA support to connect to IDS 11.50. Development platform is the Zend framework. The databases classes...

Habichtsberg, Reinhard

07-24-2009 06:48 AM
Ian Michael Gumby

I'm working on a 4GL program to enter AP vendors into a database and I'm wondering how the vendor numbers should be assigned. Should they be...

loc

07-23-2009 02:40 PM
loc

I would like to install the Informix 4GL Development version from a Linux Server, and then install the Runtime. Can anybody please help me with the...

David Reed

07-22-2009 07:08 PM
Jonathan Leffler

Hi. We have just migrated an instance from 9.40 FC6 to IDS 10 FC8 on an Solaris9 - sparc server. Prior to this, we had a lot of problems with long...

Omar Muñoz

07-22-2009 03:09 PM
Omar Muñoz

I'm running OAT 2.23 on WinXP against IDS 11.50.FC4 on HP-UX 11.23. I've logged in as user 'informix' and configured parameters via the GUI for a...

red_valsen@yahoo.com

07-22-2009 09:47 AM
Russ

One of my concerns is will adding however many more logs at what ever size - is will it slow down the response time. also I have a developer that...

jda

07-21-2009 09:40 AM
jda

Hello, Im performing a query that results in a number like 2.93485723 But i just want that my query always return a number like PPP.DD. How can i...

Josep

07-21-2009 08:53 AM
Paulo