Threads from 2005

DL Redden said: > > Very nice Matt. > > OTC, you should lay off the caffeine. I haven't had any for two days, hence the stress. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ï¿½ dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go s…

help : i can't access to my info

maca

hi everyone, I have informix installed on Unix machine, and i get access to my database trough Unix-shell, last time when i want to access to some tables I get an error saying : there is already a user with the same name Presnet (un utilisateur ayant le meme nom est deja present)…

Re: I4GL licenses

Mrinal Kant said: > I have a query regarding I4GL Compiler licenses. > > What is the difference between development and runtime (concurrent users) > licenses? That is, when are they required? > > As far as I understand, if I have 3 developers, each using 5 simultaneous > i4gl ses…

Re: How to build the regex datablade

Matt Penning said: > > performant? For the fucking sake of fucking fuck: "performant" is not a fucking word. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ï¿½ dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say tha…

RE: the ugly Americans and how the IIUG will save Europe

Konikoff, Rob \$Contractor\$ said: > > I've said it before... If IBM put as > much marketing into INFORMIX that they do into DB2 Sadly, I'm afraid that they do. :o( -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ï¿½ dire qu'il faut fermer sa gueule" - Coluche did i …

Re: HPL error starting ipload

Laurie Gustin

I'm pretty sure it is network, I dont have any shared memory connections set up in my sqlhosts file. I just typed ipload from the command line. I have read about the variable LD_LIBRARY_PATH, but I can't find anything that says what to set the value to. I have tried setting it…

ISM imported restore

I want to do an imported restore to a system that has had ISM on it in the past. Even when I do ism_startup -init I find that all devices, policies etc are still available. I am wondering how much of the $INFORMIXDIR/ism directory I need to wipe to get rid of that information. …

Re: compress vs gzip vs bzip2 (vs pack) - was IDS TRIAL ( not trail) download - now off-topic and degenerating into a rant about the IBM website

I did find www.informix.co.uk but that didn't do me much good. That only routed me to some company called "ardenta". And I was looking for the best information possible. Still, c'est la vie. And at the risk of violating political correctness can I take this moment to wish ev…

Re: Varias Instancias en un mismo Servidor

There is definitely a restriction on the number of instances. Servernum is a 1 byte integer so the range is 0-255. But otherwise I agree with Neil, the most likely limit is going to an operating system limit. That said with modern technology I think it should be possible to cre…

RE: Some vital information on ISM

David, The workaround is either to run a savegrp command as part of the level 0 backup - which incidentally has to be run as root to get any bootstrap information - or to run a backup every Sunday as root to ensure that there will be a full bootstrap. And watch this space as I s…

I4GL licenses

Mrinal Kant

I have a query regarding I4GL Compiler licenses. What is the difference between development and runtime (concurrent users) licenses? That is, when are they required? As far as I understand, if I have 3 developers, each using 5 simultaneous i4gl sessions, then I need 3 developer…

Re: HDR over secondary network

MMarks

Andreas Legner wrote: > Hmmm ... if two networks are used, srvB and srvB-sync would resolve to different ip addresses, > similar would be true for srvA and srvA-sync, wouldn't it? > Correct. The machines are on two networks. as srvA and srvB they have IP addresses such as X.X.…

Informix User Forum 2005 presentations, pictures and results are on web site

Lester Knutsen

Folks, I have posted all the presentations from Forum 2005 and some of the pictures on our web site. http://www.iiug.org/waiug/present/Forum2005/Forum2005.html I have been putting together the Washington Area Informix Users Group Forums since 1994 and this was the best event we…

Varias Instancias en un mismo Servidor

Juan Pablo

saludos a la lista: Cuantas instancias INFORMIX puedo crear en un mismo servidor ???. IBM Informix tienen algun limite de instancias a crear en un mismo server ???? Cual es el criterio que se debe tener para la creacon de 2 o mas instancias en un mismo servidor. Muchas gracias p…

HPL error starting ipload

Laurie Gustin

IDS 1.FC4 HP-UX 11.11 When I try to start ipload, I get the following error. Bus error. coredump. ipload works on my other servers (IDS 9.21) and I am not sure what the difference is. I am moving to the new server and wanted to try HPL, without having to do all the command li…

RE: the ugly Americans and how the IIUG will save Europe

Maybe you should read "DB2 Magazine." Lots of ads there! hahaha Rob -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of scottishpoet Sent: Thursday, December 29, 2005 11:31 AM To: informix-list@iiug.org Subject: …

RE: the ugly Americans and how the IIUG will save Europe

LoL... I am relaxed! I'm SO RELAXED I COULD EXPLODE! Just kidding :) Yea, I know. I was poking fun, mainly at IBM. I'm not at all convinced of THEIR loyalty to their product. I've said it before... If IBM put as much marketing into INFORMIX that they do into DB2, or as much …

RE: compress vs gzip vs bzip2 (vs pack) - was IDS TRIAL ( not trail)download - now off-topic and degenerating into a rant about the IBMwebsite

Hey... I LIKE INFORMIX! I have to put up with Oracle, MySQL, MS-SQL, and a bunch of other home grown stuff using everything from old dBase to MSAccess products... My preference is INFORMIX. Now, with all that stuff to put with, I think my loyalty to INFORMIX is pretty good, and…

RE: compress vs gzip vs bzip2 (vs pack) - was IDS TRIAL ( not trail)download - now off-topic and degenerating into a rant about theIBM website

Willem Roos

> http://www-306.ibm.com/software/info/ecatalog/en_GB/products/F106034N081 19V60.html ahhh, so www-306.ibm.com serves the uk pages :-) Disclaimer http://www.shoprite.co.za/disclaimer.html…

Some vital information on ISM

One of the problems that has been reported on ISM is that it doesn't do a FULL backup of the bootstrap. There is even a bug report cncerning this. But I couldn't understand why one of my sites was doing a full backup and others were not. After much research I disocvered that th…

Informix Stored procedure and MQ-Series

Deenadhayalan Subramani

Hi All, We are using Informix 9.3 and SP needs to get data from other application through MQ Series - Synchronous mode of transfer . Please let me know how do we achieve this . Regards Deena --------------------------------- Yahoo! for Good - Make a difference this …

Re: Merry Christmas & Happy new year

John Carlson

On 25 Dec 2005 20:30:59 -0800, david@smooth1.co.uk wrote: > >"Damn it Jim I'm a doctor not an Informix marketing agent"... "Doctor, are you aware that the odds of meeting a real Informix marketing agent are approximately the same as getting a royal fizzbin?" Sorry . . . .could…

Re: Merry Christmas & Happy new year

John Carlson

On 25 Dec 2005 20:38:36 -0800, david@smooth1.co.uk wrote: > >Cool! The sender talking using THEIR terminology and the >receiver took it in the spirit in which it was intended. > >If I says "Merry Christmas" and somebody replies >"Happy Hanukah" I won't get all pissy. > >We each …

Re: Re: why can't Online 5.20 be opensourced

So that a "bad" money maker is worth open source it?! Maybe that was the case with Cloudscape... who knows? J. -----Original Message----- From: david@smooth1.co.uk To: informix-list@iiug.org Date: 27 Dec 2005 16:13:19 -0800 Subject: Re: why can't Online 5.20 be opensourced I …

Re: IDS TRIAL ( not trail ) download.

Double Echo

david@smooth1.co.uk wrote: > Well I have seen the release notes for IDS 10.00.UC4 but it is still > not > on the trail download site... > > why the delay? > > It's very nice of IBM to make me click through several pages to see if > it has been put up their yet..and to send me an …

RE: Informix manuals - imported restore

Savio Pinto (s)

i used to do the imported restore couple of years ago, below are the steps that i used to follow (for informix version 9.21) 1) copy the ism backup directory from source machine to target machine 2) initialize the ism on the target machine 3) remove the default device from the t…

SQL question

gucis

Hi, all. Actually, I am working with Sybase AS IQ 12.6, but hope that your SQL experience would be helpful Situation - I have several tables, containing date fields: table1(start_date, end _date, id1, id2) table2(start_date, end _date, id1, id2) table3(start_date, end _date, i…

Re: IDS trail download.

scottishpoet

what difference does it make if the trial version is UC3 or UC4?…

Re: How to build the regex datablade

malc_p@btinternet.com

Jonathan Leffler wrote: > On 23 Dec 2005 04:26:53 -0800, malc_p@btinternet.com > <malc_p@btinternet.com> wrote: > > Ok - first hurdle: > > Make for morons? (not allowed to say "make for dummies" or I'll get > > sued. Oh gosh darn I just did. Shucks). > > Can anyone explain what >…

Re: Informix manuals - imported restore

Andreas Breitfeld

Hi, imported restore using onbar and ISM is described in "IBM Informix Storage Manager Administrator's Guide" chapter "Transferring Data with the Imported Restore". It can be found at following URL: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.is…

Re: IDS trail download.

Captain Pedantic

<david@smooth1.co.uk> wrote in message news:1135729118.052816.140530@z14g2000cwz.googlegroups.com... > > Well I have seen the release notes for IDS 10.00.UC4 but it is still > not > on the trail download site... > > why the delay? > > It's very nice of IBM to make me click throug…

Re: Consult about functions.

Serge Rielau

Obnoxio The Clown wrote: > Mark Townsend said: > >>david@smooth1.co.uk wrote: >> >> >>>so what is this guy doing then? >> >>Commiting the IT equivalent of seppuku ? >>With a very blunt, very rusty knife ? > > > Au contraire: he is using a shiny new DataBlade! > > :o) > In a human…

Informix manuals - imported restore

Has anyone done an imported restore using onbar and ISM? Apparently you can a) use onbar/Ism on one host to backup to disk b) restore onto another host (possibly without copying everything over) The restore involves logging into the new host with INFORMIXSERVER set to the old …

IDS trail download.

Well I have seen the release notes for IDS 10.00.UC4 but it is still not on the trail download site... why the delay? It's very nice of IBM to make me click through several pages to see if it has been put up their yet..and to send me an email each time..but why is the trial ver…

RE: Merry Christmas & Happy new year

Everett Mills

Happy Chanukah! > -----Original Message----- > From: Art S. Kagel [mailto:kagel@bloomberg.net] > Sent: Tuesday, December 27, 2005 4:59 PM > To: informix-list@iiug.org > Cc: informix-list@iiug.org; david@smooth1.co.uk > Subject: Re: Merry Christmas & Happy new year > > Tsutomu Og…

Re: Interesting Problem..

Andreas Legner

Sounds like we might have been in the wrong database ;-) Not *necessarily* an application problem; so if that can really be ruled out once the problem reoccurs, get your shared memory dumped (with the error still occuring) and a call logged with tech support.…

Senior Informix DBA opportunity

Bronson Tubb

Hello, We are looking for a senior level Informix DBA for a full time position in the Orlando, FL area, salary is negotiable based on skill, moving expenses/signing bonuses included. We are a unix based IT shop, using Informix v7 and v9 for a few canned apps, lots of internally…

Re: Merry Christmas & Happy new year -- off-topic indeed!

I guess I don't see your point. Since some months of the year are named after Roman and Greek gods, and days of the week same, I can't get away from such influences in my life. Even saying 'Good luck' has influences from other religions if I remember right. I would prefer to ce…

Re: Merry Christmas & Happy new year -- off-topic indeed!

CKGeier@nwc.edu said: > > The holiday might be good, but the founder evil. I have a deeper concern though, and it's just as applicable to Christmas as it is to Kwanzaa: is it right to validate yourself with a lie? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ï¿½ dire qu…

Re: Consult about functions.

=?iso-8859-1?B?SvxyZ2VuIEJ1Y2s=?=

Jorge Silva said: > Obnoxio, thanx for your answer; but what i need is this: > I have a DATETIME, let's say "1981/12/31 10:20:12"; if I do: > MONTH("1981/12/31 10:20:12") that will return me 12 (December), right? The > same if I do YEAR() or DAY(); that will return me 1981 and 31…

Re: why can't Online 5.20 be opensourced

Why do you want Online 5.x to be opensourced ? Just to save your own licence costs ? or to grow marketshare ?…

Visual Query Builder with unions and sub-queries

sales@activedbsoft.com

I am glad to present to the community of this group the new version of our component intended for visual building of SQL queries via an intuitive interface - Active Query Builder (http://www.activequerybuilder.com/). It has full support for Informix SQL dialect starting from vers…

Re: Merry Christmas & Happy new year -- off-topic indeed!

Wow, thanks for enlightening me. That is pretty awful what happened to those women. Thanks for looking into that. But take a look at the history to Christmas traditions. It isn't as Christian as you may have thought. Not quite the same parallels but the origins of much of Christ…

Consult about functions.

Jorge

Hi! I'm new in this, in my work, we are migrating to Informix from Oracle and I have to migrate some chunks of code and I have a problem when I gotta translate the function "Extract" from Oracle to something similar in Informix. This function "extract" - as the word says -, extar…

Check INFORMIXDIR and DBLANG.FAILED

ANGEL M. RUIZ GARZON

Hill, what could have caused it ? angel:/opt/informixids/msg/en_us/0333}oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informixids/etc/onconfig.angel'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating …

Re: Merry Christmas & Happy new year

Cool! The sender talking using THEIR terminology and the receiver took it in the spirit in which it was intended. If I says "Merry Christmas" and somebody replies "Happy Hanukah" I won't get all pissy. We each view things in different ways and shouldn't get annoyed when somebod…

Re: Merry Christmas & Happy new year

John

Captain Pedantic wrote: > <hariog@yahoo.com> wrote in message > news:1135289164.033317.66640@g47g2000cwa.googlegroups.com... > > Thanks every one for providing untiring assistance & contribution to > > this group through out the year. Wish you all a Merry Christmas and > > Happy…

Re: why can't Online 5.20 be opensourced

Adam Tauno Williams

>Even though I haven't see OL5.x after 1994, my memories of this >product has nothing but great. Would it even compile on modern platforms? And what about the 2Gb limit? Sounds pointless to me. > Surely even now this must be >better than the likes of MySQL. Then use PostgreS…

Re: How to build the regex datablade

On 23 Dec 2005 04:26:53 -0800, malc_p@btinternet.com <malc_p@btinternet.com> wrote: > Ok - first hurdle: > Make for morons? (not allowed to say "make for dummies" or I'll get > sued. Oh gosh darn I just did. Shucks). > Can anyone explain what > "Make: Cannot read or get ." - that…

RE: Merry Christmas & Happy new year

And there are many of us who just wish we could re-invent dates and times to fit the computer industry - aren't there? Just imagine how much code we could save with decimalised dates and times. But now I am dreaming! Bless you all Malcolm -----Original Message----- From: inf…

Informix ontape problem

Vijay

I am getting following error while performing 0 level backup using ontape command. "Archive failed - function write to tape failed code -1 errno 6." I am using INFORMIX-OnLine Version 7.31 UC4 running on SCO Unix 5.0.2 Thanks in advance for your help. Thanks, Vijay Kakad…

Re: Merry Christmas & Happy new year

scottishpoet wrote: > how about > > "best wishes for 2006 everyone" > > hopefully that meets with everyones approval Nah - there are plenty who count their years from different dates, so their next calendar year is not 2006. Not necessarily so many reading c.d.i, 'tis true. Bu…

FW: Merry Christmas & Happy new year

Everett Mills

For OTC- Kwanzaa: A week long celebration of the African roots of black people in America. It is loosely based on a tribal harvest festival mixed with Hanukah (light one candle each night, read a thought for contemplation), animism (offerings are made to dead ancestors) and anc…

Re: Merry Christmas & Happy new year

Kwanzaa: http://www.officialkwanzaawebsite.org/ sending to informix-list…

Re: HDR over secondary network

MMarks

On Thu, 22 Dec 2005 17:55:56 -0500, "Art S. Kagel" <kagel@bloomberg.net> wrote: >MMarks wrote: > >OK, post the sqlhosts entries for the two servers and the exact onmode >command you are trying to use to initiate HDR. > on srvA: srvA onipcshm srvA srvA srvB onsoctcp srvB-sync …

RE: Merry Christmas & Happy new year

Hamilton, Jerry

That's how I read it. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Donny Sent: Friday, December 23, 2005 4:37 AM To: informix-list@iiug.org Subject: Re: Merry Christmas & Happy new year Is this a joke? CKGeier…

Re: HDR over secondary network

scottishpoet

server name = srvB-db but you want srvB-sync…

Re: Merry Christmas & Happy new year

Marco Greco

CKGeier@nwc.edu wrote: > > We all live together in America, we should respect each other as much as > I do? Gosh! I must have been asleep when the CIA kidnapped me. How do I get back to London, UK? -- Ciao, Marco __________________________________________________________________…

RE: Merry Christmas & Happy new year

Hamilton, Jerry

Amen Brother! -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of DL Redden Sent: Thursday, December 22, 2005 7:52 PM To: Captain Pedantic; informix-list@iiug.org Subject: Re: Merry Christmas & Happy new year This who…

RE: Finding the Position of a String Within a String

Scott O'Rourke

You quoted the numbers in the URLs! Naughty, naughty... -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of malc_p@btinternet.com Sent: 23 December 2005 10:22 To: informix-list@iiug.org Subject: Re: Finding the Positio…

Re: Merry Christmas & Happy new year

Double Echo

Happy Holidays and Happy New Year! By the way... While I was out shopping I met a guy who said Jesus was an alien, and he did not give me a birthday for this Jesus, I think he said this Jesus was hatched by lizard men living underground somewhere out in the southwestern desert …

Re: Merry Christmas & Happy new year

As an American, I greatly accept the Merry Christmas....and I extend it back to all of you as well as... peace, love, rock n roll, Happy Hanukah, Happy Kwanza, Happy Holiday, Seasons Greetings......fa la la la!! "Obnoxio The Clown" <obnox…

RE: Merry Christmas & Happy new year

Unlike DB2, the holidays no longer have a single code base here in the U.S. > -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of Obnoxio The Clown > Sent: Thursday, December 22, 2005 6:26 PM > To: Captain Pedantic >…

Re: Merry Christmas & Happy new year

CKGeier@nwc.edu said: > > Ok, so I'm a Christian too. But I also realize that Hanukah starts Dec 25 > this year, and Kwanzaa Dec. 26, and Ramadan (although over) > started on Oct 4. What is this Kwanzaa thing of which you speak? -- Bye now, Obnoxio "C'est pas parce qu'on n'a r…

Re: Merry Christmas & Happy new year

Ok, so I'm a Christian too. But I also realize that Hanukah starts Dec 25 this year, and Kwanzaa Dec. 26, and Ramadan (although over) started on Oct 4. And, of course there are those folks who don't really celebrate anything but a "happy holiday". So it seems more like we should…

Re: Merry Christmas & Happy new year

DL Redden

This whole "happy holidays" crap is really pissing me off, I know, quite Christian of me huh. Please avoid the HH stuff and keep up the "Merry Christmas". Maybe, if we're lucky, one day the rest of the nation will get their heads out of their asses and re-join common sense. Merr…

RE: Archive seems to be failing

ifxmaillist@quanta.co.nz

Can you run the archive from the command line? Are there any other symptoms of problems in the database? Are you filling the device you are writing and reaching the end of tape? (How much was written to the tape?) 7.31.UC6 is somewhat old. You should look at upgrading to UD8. …

Support phone numbers....

http://www.ibm.com/software/data/informix/ids/ on the right hand side " We're here to help Easy ways to get the answers you need. Call me (link) E-mail us (link) or call us at 877-426-3774 Priority code: 104CBW60" click on call me and get a page that starts "Just com…

Archive seems to be failing

HarryH

The DB is IDS 7.31.UC6. I was looking at the online.log this morning and discovered these lines: 22:10:10 Level 0 Archive started on rootdbs, hutrep_dbs, gendbs, eom_dbs 23:00:52 Checkpoint Completed: duration was 14 seconds. 23:51:01 Checkpoint Completed: duration was 9 se…

Re: Merry Christmas & Happy new year

Captain Pedantic said: > > <hariog@yahoo.com> wrote in message > news:1135289164.033317.66640@g47g2000cwa.googlegroups.com... >> Thanks every one for providing untiring assistance & contribution to >> this group through out the year. Wish you all a Merry Christmas and >> Happy Ne…

IIUG Server move

Lester Knutsen

Folks, Just an FYI, we will be moving the IIUG server to new hardware donated by Sun. The move will happen tomorrow, 12/22/2005 at noon EST. The downtime will be very short for the web site and mailing lists. The only delay might be in how long it takes for the new DNS address …

Merry Christmas & Happy new year

hariog@yahoo.com

Thanks every one for providing untiring assistance & contribution to this group through out the year. Wish you all a Merry Christmas and Happy New Year. Drive safely if you are traveling around. Hari…

Re: View performance in IDS - suggestions?

Matt Penning

Thanks, that seems to do the trick. - Matt Richard Harnden wrote: > Matt Penning wrote: > >> Hi all, >> >> I'm having performance problems with views in IDS 10 (RC3,Linux). >> >> Creating a simple view with one join and then querying against it >> results in not only a temporar…

Re: how to find the maximum id from two tables

Captain Pedantic said: > > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message > news:doekll$n0s$1@news.xmission.com... >> >> Frank Langelage said: >>> >>> The JBossAS tries to execute this query and gets a syntax error: >>> SELECT MAX(TXID) FROM ( >>> SELECT MAX(TXID)…

HDR over secondary network

MMarks

HPUX machines, Informix 9.4 We have a primary database server, srvA, and a server we want to use HDR to back the database up to, srvB. Both machines are on our primary network, as well as a sync network, where they have a different set of IP addresses (which are identified in…

IDS New Features Request

Ford, Andrew G

A request for the list. Change table owner without dropping/recreating table - 12/22/2005 Andrew Ford sending to informix-list…

Re: IBM branding

Just thought I would let you all know that the IBM wheels are still churning. I have now been contacted by IBM and told that the rebranding of DB2 into Information Management (IM) will be kicked off at the IBM kick off in January 2006. Now should we all request that the Brand N…

Calling all Peoplesoft/Informix customers - More info

Greetings All, This is just a followup to let the Peoplesoft/Informix community in on why I'm searching for current customers. I have recently requested certification for Tools 8.47 with IDS 10 FC3 through Oracle. The response was that there were no plans to cert. 8.47 with 10…

Re: how to find the maximum id from two tables

=?iso-8859-1?Q?Omar_Mu=F1oz_Perez?=

Frank Langelage said: > > The JBossAS tries to execute this query and gets a syntax error: > SELECT MAX(TXID) FROM ( > SELECT MAX(TXID) AS TXID FROM JMS_TRANSACTIONS > UNION > SELECT MAX(TXID) AS TXID FROM JMS_MESSAGES > ) > > The goal is to find the maximum txid out of two ta…

how to find the maximum id from two tables

Frank Langelage

The JBossAS tries to execute this query and gets a syntax error: SELECT MAX(TXID) FROM ( SELECT MAX(TXID) AS TXID FROM JMS_TRANSACTIONS UNION SELECT MAX(TXID) AS TXID FROM JMS_MESSAGES ) The goal is to find the maximum txid out of two tables with one query. I know I may creat…

Finding the Position of a String Within a String

Ekstrand, Pam

Hello All, IDS version 9.40FC6. Does anyone know of a function that will return the position of the first occurrence of a value within a string? For example, something that would return '3' if searching for 'C' in string 'ABCD'. Thanks in advance for any suggestions. Pam Eks…

Interesting Problem..

coleas@gmail.com

We have had IDS 9.4 UC3 installed for over a year with no problems. except now Our live database errored yesterday and the client program thats uses it couldn't connect. The error that occured was --> cannot find table syssessions. Very strange. I could see the table in sysm…

Re: On sysprocplan being locked

Art S. Kagel

Bill Dare wrote: > I always ran into this problem when my daily update statistics would > run. Caused real problems with stored procedures called from triggers > on very busy tables. If statistics were updated on a table which was > accessed from the stored procedure, the optim…

Re: On Set Optimization Low

Hi. I have proved an applicacion with set optimization low. I didn't notice any difference on performance, except when tables, indexes and store procedures change very often, but a productive environment isn't on this situation. By the way, I had problems due to…

Calling all Peoplesoft/Informix customers

Greetings, If you are a Peoplesoft customer running on informix please send me an email. I would like to get an idea of what version of informix you are running and what your future plans are. TIA sending to informix-list…

On Set Optimization Low

jpierrot@chubb.com

Any thoughts on this folks - Will appreciate it. Setting "Set Optimization Low" for stored procedures is one of the suggested workaround. Have not tried it yet. Are you aware of any downfalls (pros & cons) using it in an environment. Does it impact other objects directly or indir…

Fill Factor in database used with baan

Jaime Casanova

Hi all, OS: Windows NT Database: Informix IDS 9.2x ERP: BaaN B40c.66 checking for the onconfigs of the company i am working for... i have found that the two server are configured with FILLFACTOR 60... is this something BaaN is recommending are there any reasons for not having …

RE: On sysprocplan being locked

Gosney Simon

We've also come across the same problem, and also issued SET OPTIMIZATION HIGH before the CREATE PROCEDURE statement as well as the SET OPTIMIZATION LOW in the procedure called from the trigger. This certainly seems to drastically reduce the problem. Regards Simon -----Origin…

RE: Informix CRONTAB problem

Looks like you maybe don't have your environment set. Cron does no execute your .profile unless explicitely told to do so. Add it to your script or add it to the cron entry. Bill > -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.o…

Re: Informix CRONTAB problem

Carsten Haese

On Wed, 2005-12-21 at 06:17, gary.cobden@nhs.net wrote: > Morning all > > I have a problem with the following script which is designed to run a > database export (dbexport) after cancelling all currently active > sessions. It runs fine when run interactively:- > > cd /comwise343…

RE: Informix CRONTAB problem

Try using an absolute path for defining sids when outputting from the dbaccess. Then specify the absolute path in the for loop. Chances are, cron doesn't know where to look for it. Rob -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@i…

RE: On sysprocplan being locked

I always ran into this problem when my daily update statistics would run. Caused real problems with stored procedures called from triggers on very busy tables. If statistics were updated on a table which was accessed from the stored procedure, the optimizer would re-optimize th…

RE: Informix CRONTAB problem

Link, David A. (Omaha)

Just looking at it real quick I would say that you need to move up the setting of your environment variables to the top of the script. I believe that the onmode command will need these set as well as the dbaccess. Try that. David Link -----Original Message----- From: owner-inf…

Re: Informix Connect - acquire password

Sheshnarayan Agrawal

Hi Elvis, I am not sure if I get your question correctly ... If you are asking to get the password in plain text(which is stored in encrypted format) from the mentioned registry location using ODBC then you can't do it ... Regarding Informix Connect, Yes you should be able to …

Informix CRONTAB problem

gary.cobden@nhs.net

Morning all I have a problem with the following script which is designed to run a database export (dbexport) after cancelling all currently active sessions. It runs fine when run interactively:- cd /comwise343/etc/local mv cs_top cs_top_old cd /home/informix/bin rm sids dbac…

Informix Connect - acquire password

Elvis

Hi all, I want acquire password from Informix Connect. In registry HKEY_CURENT_USER\\Software\\Informix\\netrc I have password, but hashed or coded. Client application works on Win2K, WinXP. Password is needed for using in odbc connection (in client application). I use odbc driv…

Re: solaris IDS 9.4 wont start after patch install

Tsutomu Ogiwara

Hi David. Using gethostbyname(), getservicebyname() ? -- Tsutomu Ogiwara from Tokyo Japan. >From: david@smooth1.co.uk >Reply-To: david@smooth1.co.uk >To: informix-list@iiug.org >Subject: Re: solaris IDS 9.4 wont start after patch install >Date: 15 Dec 2005 19:59:43 -0800 > >Do…

Re: Changing versions of AIX - is new software required?

Dave Thacker

On Tue, 2005-12-20 at 14:08 +0000, malcolm weallans wrote: > One of my customers is planning to upgrade from AIX 5.1 to AIX 5.3. They > are currently running IDS 9.40.UC4 > I have been asked if they will need a new copy of IDS for this upgrade. I believe UC7/FC7 is current, the…

Re: Upgrading from 9.21 to 10 planning

Fixed in UC4? The release notes for UC4 are up on the IBM site but not the list of bugs fixed! It seems to have been packaged on 1st December. I'm not sure if it has been released to the public yet?…

On sysprocplan being locked

jpierrot@chubb.com

Guys, This had been question of discussion in the iiug forum in many occasions or for years. Correct me if I am wrong, I can recall one saying that altering and modifying objects in the database will cause IDS to force the reoptimization of stored procedures thereby at times caus…

Re: Validating sqlhosts and services

Thanks for this ...not knocking it or anything but what if the services are stored in yp? "ypcat services" apparently gives something that is searchable.. I'm not sure if you can store services stuff in LDAP? Very good tho..like it...portable...easy to use...…

Re: View performance in IDS - suggestions?

Which table is order_num in? There is an index on this column and the join column on the other table? You have done update statistics using Art Kagel's dostats? There are enough rows in both tables >1000 to warrant using an index?…

Re: 668: System command cannot be executed. 255: Not in

I wonder if the 'system command cannot be executed' relates to the sql statement error. Is there a 'system' command anywhere in the sql script ? If so, then you may need to make sure that the informix engine is started by the user informix, not the user root. We had that error an…

RE: onbar scripts to TSM

You really don't need a script unless you're doing something out of the ordinary, like special handling for monthlys. From my midnight processing script: export DSMI_CONFIG=${INFORMIXDIR}/prodifx.opt onbar -b -L0 RC=$? ${INFORMIXDIR}/prodifx.opt would c…

RE: 668: System command cannot be executed. 255: Not in

ifxmaillist@quanta.co.nz

Have a look at the schema of the table. Sound like the table has an update trigger running a stored procedure that is doing something inconsistent with the rest of your code. MW -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]…

4G systeme

maca

Hi, does anyone has an idea about this program : 4G systeme Ver 5. it is installesd on UNIX system to access Database 'dbaccess' when i want to access to a table a get a message (un utilisateur ayant le meme nom est deja present) = a user with the same name is present = , means…

Informix DBA - NYC- for 18 month contract

AL

We have an opening for an Informix DBA, a long-term contract position in Brooklyn, NY. The requirements are 4+ years Informix DBA experience on Sun/Solaris, strong SQL and scripting. The client will consider a phone interview for the right candidate. Rate is around $60+/hour. P…

668: System command cannot be executed. 255: Not in transaction

Frank

Hi all I'm new to this... so please be patient. I'm using AIX Version 5.2. I'm just trying to update a table and it's giving me the following errors: 668: System command cannot be executed. 255: Not in transaction. This is happening in a "4gl program" and/or "SQL" It's a simple…

RE: Changing versions of AIX - is new software required?

Simmons, Keith

Malcolm I would have thought so, 5.1 I believe is 32 bit whereas 5.3 is 64 bit, better to get FC to run on it. Keith -> -----Original Message----- -> From: malcolm weallans [mailto:malcolm.iiug@btopenworld.com] -> Sent: Tuesday, December 20, 2005 2:09 PM -> To: informix-list@i…

IBM Contact info from Users Forum in Atlanta?

Greetings, Anyone have the contact info for a few of the IBM'ers listed below. Some I had from the 2 Users Forum in Atlanta but they have been misplaced. Bruce Weed Foreign speaking gent that mentioned he had a "big stick". Yeah, thats food for fodder!!!! If you have the abo…

onbar scripts to TSM

Greetings, Does anyone have a script to perform nightly backups to TSM? IDS 9.40 FC2 HPUX 11.11 TIA sending to informix-list…

Re: Changing versions of AIX - is new software required?

malcolm weallans said: > > One of my customers is planning to upgrade from AIX 5.1 to AIX 5.3. They > are currently running IDS 9.40.UC4 > I have been asked if they will need a new copy of IDS for this upgrade. > > I have been trying to find this information on the IBM web-site …

Changing versions of AIX - is new software required?

One of my customers is planning to upgrade from AIX 5.1 to AIX 5.3. They are currently running IDS 9.40.UC4 I have been asked if they will need a new copy of IDS for this upgrade. I have been trying to find this information on the IBM web-site and have failed. Does anybody kno…

Re: View performance in IDS - suggestions?

Richard Harnden

Matt Penning wrote: > Hi all, > > I'm having performance problems with views in IDS 10 (RC3,Linux). > > Creating a simple view with one join and then querying against it > results in not only a temporary table being created, but a temporary > table with no indexes on it. The temp…

Restore IDS 9.40 archive to different version of S

Sadi

Hi all. We have two 9.40.UC2 systems on Solaris 9 (Sun-2900 server) and Solaris 8 (sun-3500 server) Since the mainboard of the 2900 server went down and it will take some time to have the new board, we have to make our old Solaris 8 system online. Is it possible to restore the…

RE: Problem with the sysmaster database.

I have often found that doing selective queries directly off of the sysmaster tables can take a long time. This is all to do with the fact that the sysmaster database is in fact a map onto some shared memory tables which aren't controlled by the normal lock mechanisms. What I p…

Re: Problem with the sysmaster database.

SaltTan

Jiten Thakkar said: > Hi , > > Environment : > Hardware : Sun4u-Sparc/Ultra > O/S : Solaris 8 > Informix : 9.30.FC2 ( 64 bit) > > I have a database with 40,000 tables. The data warehouse application creates > new tables to store the information for new products. > > My problem i…

listener-thread: err = -25580 IDS 9.40 UC 4

Marconus

Hallo, since a few days we get the fallowing error in our online Log: 09:10:18 listener-thread: err = -25580: oserr = -1: errstr = : System error occ urred in network function. The error occure every 10 seconds. We are running IDS 9.40 on an Red Had Cluster. We can`t remember…

Stored procedure

Nirmala Kesavan

hi, I am using informix dynamic server 7.2 . how do i use SQLCA.SQLCODE in a stored procedure . thanks and regards , Nirmala __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail…

RE: Manually Adding a Row to a Resultset

Christopher Coleman

Actually, there is a problem I had not noticed, which is that you are selecting a null. IDS is a little bit sensitive about such things. In IDS version 9 and above, you can cast the null to the same data type as Field1 SELECT Field1 as ValueField ,Field2 as …

Re: Problem with the sysmaster database.

Jiten Thakkar said: > > Hi , > > Environment : > Hardware : Sun4u-Sparc/Ultra > O/S : Solaris 8 > Informix : 9.30.FC2 ( 64 bit) > > I have a database with 40,000 tables. The data warehouse application > creates > new tables to store the information for new products. "Interesting…

Re: Manually Adding a Row to a Resultset

Try this: create table dual( dummy char(1) ); insert into dual values ('x'); and the use dual as you normally would in oracle. for your problem, this could be: select 'constant' from dual; and use it in a join. if you want to be very fancy don't create that dual table, i…

View performance in IDS - suggestions?

Matt Penning

Hi all, I'm having performance problems with views in IDS 10 (RC3,Linux). Creating a simple view with one join and then querying against it results in not only a temporary table being created, but a temporary table with no indexes on it. The temp table creation followed by sequ…

Problem with the sysmaster database.

Jiten Thakkar

Hi , Environment : Hardware : Sun4u-Sparc/Ultra O/S : Solaris 8 Informix : 9.30.FC2 ( 64 bit) I have a database with 40,000 tables. The data warehouse application creates new tables to store the information for new products. My problem is the query on SYSMASTER database is ve…

Re: Informix Gateway with DRDA connection to V5R2 iSeries...

Manas Dadarkar

You need to search the DB2 messages documentation for what DB2 iSeries SQLCODE -204 stands for. That will tell you what is the problem on DB2 Thanks, -Manas On 12/17/05, iSeriesDude <nowhere@nowhere.com> wrote: > > The exact error message is, > > -29000: Application Server erro…

RE: Manually Adding a Row to a Resultset

Christopher Coleman

Potter asked: > I am querying an Informix database via Sequelink and I want to manually > add a row to my recordset. Yes, you can use similar syntax for Informix to the UNION clause you demonstrated, but you must specify a table. I am not certain if you can get away without it …

Re: Manually Adding a Row to a Resultset

Potter said: > > I am querying an Informix database via Sequelink and I want to manually > add a > row to my recordset. In SQL Server, I would use a UNION clause like > this: > > > SELECT > Field1 as ValueField > ,Field2 as DescField > FROM TableA > UNION > SELEC…

Manually Adding a Row to a Resultset

Potter

I am querying an Informix database via Sequelink and I want to manually add a row to my recordset. In SQL Server, I would use a UNION clause like this: SELECT Field1 as ValueField ,Field2 as DescField FROM TableA UNION SELECT Null as ValueField ,…

Re: Another Datetime/Interval question

Carsten Haese

On Mon, 2005-12-19 at 06:12, Richard Spitz wrote: > And on to the next INTERVAL problem. We are still in IDS 7.31, so > no casts. > > I have a table where the duration of a procedure (in minutes) is > stored in a smallint column. Another table stores beginning and end > of a proc…

Re: Re: complex duplicate row

Could you provide some test data and examples ? J. -----Original Message----- From: "adrian.baceanu@gmail.com" <adrian.baceanu@gmail.com> To: informix-list@iiug.org Date: 17 Dec 2005 07:59:02 -0800 Subject: Re: complex duplicate row But how to select duplicate rows (identical …

RE: weird happening with Money field in view

John Adamski

Jonathan, We are running IDS 9.4 on a HP-UX 11i box, using dbaccess to create the stored procedure and the view that calls the stored procedure. I missed typed the select statement from the paper the developer gave me with their results and the code. Select NVL(SUM(amt),…

Re: complex duplicate row

On 17 Dec 2005 07:59:02 -0800, adrian.baceanu@gmail.com <adrian.baceanu@gmail.com> wrote: > But how to select duplicate rows (identical in all the columns, except > codfisc) and in the same time the result also to include this column, > codfisc? SELECT INDISTINCT ... ? :-) SEL…

Re: Validating sqlhosts and services

On 17 Dec 2005 13:38:56 -0800, david@smooth1.co.uk <david@smooth1.co.uk> wrote: > > Errm.. What if people do not have perl installed? > > With C I can provide binaries that have no external dependencies. > > I just want to validate ontlitcp or onsoctcp connections with this > too…

Re: Upgrading from 9.21 to 10 planning

Can you give us an example that breaks it?…

Re: complex duplicate row

adrian.baceanu@gmail.com said: > > But how to select duplicate rows (identical in all the columns, except > codfisc) and in the same time the result also to include this column, > codfisc? SELECT * FROM f103; -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ` dire qu'il fau…

Re: IBM URLs (http://www.ibm.com/ vs.

Mark Townsend said: > > Obnoxio The Clown wrote: >> Superboer said: >> >>>well i do not know which idiot came up with SOA >>>(Service-Oriented Architecture) >>> >>>in dutch soa is short for sexual overdraagbare aandoening... >>> >>>sex disease..... >>> >>>they offer their custome…

Re: chunk failed sanity check

Victor Miramontes

Can you physically access to the chunk ? If you can you shoud solve the problem using onspaces. onspaces -s dbspace -p /bd/RAW/dbspace -o 0 -O -y Regards, -----Original Message----- From: forum.subscriber@iiug.org To: ids@iiug.org Sent: Fri Dec 16 17:32:21 2005 Subject: chunk …

Re: weird happening with Money field in view

On 15 Dec 2005 12:51:04 -0800, jda <adamski@graceland.edu> wrote: > We are having a weird situation with a money field that hopefully > someone can shine a light on to why it's happening and how to fix or > code around it. Which product? Which version? Which platform? > We ha…

Re: Validating sqlhosts and services

On 15 Dec 2005 19:59:43 -0800, david@smooth1.co.uk <david@smooth1.co.uk> wrote: > Does anyone know how I could write code to check the services past of > sqlhosts? > > Something that checks a servicename is valid on the current machine? > What calls does IDS use to check? > > Sam…

Re: complex duplicate row

adrian.baceanu@gmail.com said: > > I have the following table > > create table "contav".f103 > ( > codc char(5), > codfisc char(20), > nrprezi integer, > nrprezf integer, > buc integer, > taxa float, > fel char(1), > numeex char(50), > adrex …

Re: IBM URLs (http://www.ibm.com/ vs.

Superboer said: > > well i do not know which idiot came up with SOA > (Service-Oriented Architecture) > > in dutch soa is short for sexual overdraagbare aandoening... > > sex disease..... > > they offer their customers a soa??? > > WOEHA.. Yep, via a poxy server. :o) -- Bye now…

Light Scans Notes

Bob Kruse

Greetings All, We're doing some performance tuning on an XPS 8.50.FC2 server on an AIX platform and I saw the output below when I ran "onstat -g scn." Can anyone provide some feedback on what the "Forward row lookup, Must copy," notes mean? Is this indicating something detri…

Posting from the Informix-list

Bob Kruse

Greetings All, We're doing some performance tuning on an XPS 8.50.FC2 server on an AIX platform and I saw the output below when I ran "onstat -g scn." Can anyone provide some feedback on what the "Forward row lookup, Must copy," notes mean? Is this indicating something detrime…

Re: Informix Gateway with DRDA connection to V5R2 iSeries...

Manas Dadarkar

Hi, Can you provide more information as to what is the message text of SQLCODE -29000? The Gateway is designed such that any errors returned by DB2/iSeries are encapsulated inside Gateway SQLCODE -29000 Thanks, -Manas On 12/16/05, iSeriesDude <nowhere@nowhere.com> wrote: > >…

chunk failed sanity check

Alejandro Mtz Mejia

Hi all! I have a big problem. I was create an IDS2000 V 9.21 Intance database 10 days ago over UnixWare 7.1.3 OS. A database dbspace was damage by power failure and I have no backup. There is a way to recover the damaged dbspace?? I hope anybody help me! List errors during …

Re: Another Datetime/Interval question

=?iso-8859-1?Q?Omar_Mu=F1oz_Perez?=

Umm, I don't know if IDS 7.31UC8 support casting... But IDS 9.x and 10 does. If IDS 7.31 supports casting then you can do something like this: select "2005-12-21 15:27:33"::datetime year to second as tend, "2005-12-21 17:57:33"::datetime year to second …

RE: Another Datetime/Interval question

Ford, Andrew G

How do I select the number of different dates for which records exist? select date (tanf), count(*) from <tablename> group by 1; Will give you the number of records for each date that exists and select distinct (date (tanf)) from <tablename>; Will give you the dates for…

RE: IDS New Feature Requests

Gentsch, Sam

That is great news that you got the approval to continue to share your utilities with us! >The next release of dostats implements these optimizations and automatically detects server versions to turn them on and off (also an override option). >I'll be uploading the next release…

Re: complex duplicate row

Hi. try this: select codc, nrprezi, ...., count(*) --all columns except those which you wish exclude. from "contav".f103 group by 1,2,3, ... --group by all your non-aggregate columns having count(*) > 1 But beware, this kind of quer…

complex duplicate row

adrian.baceanu@gmail.com

I have the following table create table "contav".f103 ( codc char(5), codfisc char(20), nrprezi integer, nrprezf integer, buc integer, taxa float, fel char(1), numeex char(50), adrex char(50), locex char(30), judex char(2), data …

RE: solaris IDS 9.4 wont start after patch install

Everett Mills

David- You could have a c program that calls a script that includes something like this: fgrep sqlexec /etc/services > my_test_file if test -s my_test_file then read in1 in2 in3 < my_test_file echo $in2 > my_out_put else echo 0 > my_out_put …

Re: dbexport - exclusive locking

Both messages refer to the same, someone is using the database so you can't do the unload. You could do some onstat -u to test if there are users remaining. When there isn't you can di the dbexport. Other approach is to shutdown your instance. Then bring it up online and inmedi…

Re: Fw: begin work without replication in .NET

Sathyanesh Krishnan

Hi All, Look like I made a mistake not fully understanding the question. This code snippet is to create a transaction by using Informix .NET provider. It will not help creating a "transaction without replication". And the Informix .NET don't have support for the later one. Rega…

Informix Gateway with DRDA connection to V5R2 iSeries...

iSeriesDude

Looking for some details on what is necessary on the AS/400 side to support Informix? We have a Unix server running Informix Gateway with DRDA that is trying to connect to the system however we keep getting this generic -29000 error and I can find no good documentation detailing …

Another Datetime/Interval question

Richard Spitz

Dear Informixers, I'm stuck with a datetime/interval problem again. Database is IDS 7.31UC8 on Linux. I'm presently working with plain old dbaccess, although ODBC might be needed in the future. I have a table whicht contains(among others) two DATETIME columns: tanf datetime yea…

Re: IDS New Feature Requests

Richard Harnden said: > > david@smooth1.co.uk wrote: >> Added. >> >> Folks, >> >> I still can't see peoples full email addresses in this crappy google >> groups. > > Then use a proper news-reader to read usenet. > > Unless, that is, your PHB is scared that you'll immediatly subsc…

dbexport - exclusive locking

gary.cobden@nhs.net

Morning all I'm running the following script to export an informix database:- INFORMIXDIR=/usr/informix export INFORMIXDIR INFORMIXSERVER=ONLINELIVE ONCONFIG=onconfig.live PATH=$PATH:$INFORMIXDIR/bin export INFORMIXSERVER ONCONFIG PATH /usr/informix/bin/dbe…

INFORMIX 4GL MASTER DETAIL

calyanram@hotmail.com

I AM HAVING DETAIL SCREEN LIKE THIS NO DATE S NAME RES.DT STATUS 10001 12/12/98 1 SCOTT 12/01/98 y 10002 12/12/98 2 NEILL 12/02/98 Y DATABASE NAME AUSS CONTACT NAME SCOTT WHENEVER I MOVE THE CURSOR IN THE DETAIL UPPER PART IT SHOULD AUOTOMATTICALLLY FE…

AW: number of extents

Model-Bosch, Tilman

Bill Hamilton asked: > Should I try to get the number of extents down on system tables? > Also, on automatic indexes, when should you worry about how many extents > they are in? Art S. Kagel responded: > Not to worry. All system catalog tables are cached in the data dictionary …

Re: Informix in the news! Part Deux... RANT TIME

Davorin Kremenjas said: > > OK, people, please tell me what "FOC" means, so I can understand what > you're > talking about :) > Thanks! Free Of Charge. > "Maelwys Filidh" <lleu@hotmail.com> wrote in message > news:dns2ha$6b8$1@news.xmission.com... > >> I did hear from a US cont…

FreeBSD unixODBC -> Informix

Tim Jones

Hi, I'm using an FreeBSD 5.4 machine and am wondering it it's possible to connect to Informix IDS versions 7 and 10. Has anyone managed to get unixODBC, or any other client, to talk to an Inforimix instance? Any help appreciated! Cheers, Tim…

IDS Upgrade from 7.30 to 7.31 / 9.30

Lloyd S

Dear All, We will be upgrading IDS 7.30 to 7.31. Can you please let me know the steps for the same. Pre-upgrade steps, Upgrade steps, Post upgrade steps. Thanks in advance. Regards, Lloyd…

Can I use my DVD writer like a Tape Backup

JOSE DLEON

Hi my friends, i want to ask something, Can i use my DVD writer like one TAPE Backup Unit on my Informix-9.4 Database? If i can, how i should configure that...?…

RE: Question regarding global variable.

Feng Huang (huangcf)

Jonathan, Thank you very much for your reply. I have tried to implement the code to use global variable. It works for different connections. But I run into one problem. Actually my previous example wasn't accurate enough. The function contains some insert/update for several tab…

Re: IDS New Feature Requests

Added. Folks, I still can't see peoples full email addresses in this crappy google groups. I want to present this list to IBM but I can't without proper email addresss (and preferably company names). If we want this to be taken seriously I'm going to need help here! I can't …

Fw: begin work without replication in .NET

Sathyanesh Krishnan

Hi All, Here is a using Informix .NET provider code snippet that creates transaction in the application. String ConnStr = "server=ids; database=mydb;"; IfxConnection Conn = new IfxConnection( ConnStr ); Conn.Open(); IfxTransaction Txn = Conn.BeginTrans…

Re: solaris IDS 9.4 wont start after patch install

Does anyone know how I could write code to check the services past of sqlhosts? Something that checks a servicename is valid on the current machine? What calls does IDS use to check? Same for the hostname? Can someone give us code to parse sqlhosts and check? Preferably in C th…

Re: IBM branding

I have a snail mail address and will be sending this at the weekend.…

Re: Old INFORMIXSERVER name from onstat -g env

So you have restarted and onstat -g env still shows the old value? And this is not in the environment of the server when it is started Add to the startup file env > /mydir/env.$INFORMIXSERVER.date '+whatever gives to the second accuracy' since I assume you will not start 2 insta…

Re: Brilliant IDS documentation page

Well the first 2 links on that page are:- IBM Database Winback Pricing .. to DB2 Universal Database or Informix Dynamic Server ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ and "Trade-ins from qualified competitor products to IDS V9"…

Re: Informix in the news! Part Deux... RANT TIME

Well I was suggesting these people and they could a) realise what is going on. Imagine if they get 10 of these calls per day, every day. I think they'll get the message and fix it! b) pass "Maelwys Filidh" on to the right person. PS Christine Nomilee is the IDS Product Manager…

Re: Moving from IDS Version 7.21 to 9.21

Mark D. Stock

david@smooth1.co.uk wrote: > Err I think 9.30 has the most bugs but it was not around for long... 9.21 surely? After 6 of course. ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolution…

How to do a constraint to reference a view?