f



RE: hi Cant load informix online 5.2 on linux -8 ( rpm file)

Hi RATHER.

Probably this is a rpm bug.
Upgrade your rpm or use rpm for Redhat 7.3 (rpm Version 4.0.4).
OR
Search google.

I do not test, but how about the following ?
Use rpm2cpio, un-rpm to /opt/informix.
Move /opt/informix to your targer directory.
Execute installonline.

Regards.

--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592





>From: "RATHER" <myzahoor@yahoo.co.uk>
>To: <informix-list@iiug.org>
>Subject: hi Cant load informix online 5.2 on linux -8 ( rpm file)
>Date: Sat, 27 Dec 2003 08:57:45 +0300
>
>Hello friends
>
>REcently i download Informix online5.2 ffrom iiug.org  site for Liunx.
>Now i am trying to load this online5.2 version on linux 8. I have already
>user informix created and am giving the followin coomand  from the root.
>
>rpm -i --relocate /opt/informix=$INFORMIXDIR 110197612040731.RPM
>
>THIS gives me the following error:
>
>ERROR: INFORMIXDIR doest match the target directry name provided in the  
>rpm
>command. If you are not  installing this product in the  default 
>INFORMIXDIR
>name for  Linux (/opt/informix), You must provide your INFORMIX dIRECTORY
>name with the -- prefix ( rpm 2.x Syntax) or -- relocated ( rpm 3.x Syntax)
>paramater in your rpm -i command line.
>then again  i used the following also but gives me the same error:
>
>rpm -i --prefix /usr/informix 110197612040731.RPM
>
>So pleaes anyone suggest me what t do next.
>
>REgards
>
>RATHORE
>
>
>
>sending to informix-list

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

sending to informix-list
0
Tsutomu
12/29/2003 1:03:07 AM
comp.databases.informix 16083 articles. 0 followers. Post Follow

0 Replies
324 Views

Similar Articles

[PageSpeed] 59

Reply:

Similar Artilces:

RE: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux #2
Christian Knappke wrote > > "Colin Bull" <c.bull@videonetworks.com> wrote: > > > Here is one I prepared earlier --- > > > > onbar/ontape whatever .. > > FORCEOL=n > > until onstat - | grep "On-Line" > /dev/null > > do > > echo "Off line" # ; sleep 20 > > onstat - | grep "[BQ][lu][oi][ce][ks]" > /dev/null && ( echo > > "\nServ blokd" > > if [ x$FORCEOL = "xn" ] ; then > > echo "Onlining.." ; onmode -m ; FORCEOL=y; > > sleep 240 > > else > > echo "waiting to online " ; sleep 240 > > fi > > ) > > onstat - # for comfort factor > > sleep 60 > > done > 'onstat -' sets the return code according to the server state -> > no need for boll*cking greps... > > >From the top of my head: > 255 = server is offline ("Shared memory not initialized...") > 5 = online > 4 = some error > 0..3 = several other states like quiescent, blocked etc. (don't > know exacly) > That will make it a lot tidier, should be able to use a case statement. I will revise next week sometime. Colin Bull c.bull@videonetworks.com sending to informix-list "Colin Bull" &...

Subject: hi all Cant load informix online on /usr/inormix
This is a multi-part message in MIME format. ------=_NextPart_000_0037_01C3CF78.CA4376F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello friends. I tried 1. - When you get the error message type 'OVERRIDE', (all caps and without > the apostrophe). > > 2 . > export RPM_INSTALL_PREFIX=/usr/informix > export INFORMIXDIR=/usr/informix > install without any relocation But got unpacked the rpm file in /opt/informix but got soem warnings messesages like this: WARBING: Group rd Doestnot exist using root WARNING: user muralis doesnot exist using root ------------------ ----------------- ---------------- ONLINE_PE_5.20 UC1-1 sh line 1 ./ installation no such file or directory installation failed fix the problem, then re install with rpm' "replacepkgs option. then i copied the contents from /opt/infomrix dirctory by usint tar command. then run ./installonline it did some work. but it seems it is not working and did not asked me the key and license information. If i want to remove this all how and what should i do to install it properly in /usr/infomix other than "opt/informix" Your help is appreciated. thanks RATHORE | | Junk E-Mail | Inbox Get the latest updates from MSN ------=_NextPart_000_0037_01C3CF78.CA4376F0 Content-Type: image/gif; name="i.p.previous.gif" C...

RE: Change database mode online using onmode in Informix #2
onmode -m takes the database server from quiescent or single-user mode to online mode. To bring the server from off-line to on-line, you should just use the oninit command. You could use the oninit -s to initialise shared memory and bring the server to single-user mode and then use onmode -m to bring it to multi-user mode. By the way, you should not use onmode -ky to shut down the server unless you are in quiescent mode. This will not perform a checkpoint and can, in some situations, lead to data loss or corruption. I recommend shutting down with onmode -yuk. This brings the database server to quiescent mode without waiting for users to finish their sessions. Their current transactions are rolled back, and their sessions are terminated. A checkpoint is completed and then database server goes to offline mode and database server shared memory is removed. The order of parameters is unimportant, but I use "onmode -yuk" because of the mnemonic value, at least for English speakers; say it out loud with me: "onmode -yuk (yuck) can avoid a big mess." I know its silly, but it sticks in the head. Check the IBM Informix Dynamic Server Administrator's Reference: http://publib.boulder.ibm.com/epubs/html/25122680/25122680tfrm.htm Sincerely, Christopher Coleman Steering Committee President Kansas City Informix Users Group www.iiug.org/kciug Database Analyst Pharmacy Division Mediware Information Systems, Inc. -----Original ...

Re: get syntax error when loading data to a informix database #2
Umesh said: > Hi > I have ids 9.4 oon windows and csdk. l successfully connected > to the database using Visula Basic 6. > When l build a string for example > SQL1 = "select * from hse2 where field1 matches " & "'a*' > and execute using : DbaseConn.Execute (SQL1) it works fine. > > When l try to load data to a table : > SQL1 = "load from " & " 'd:\x.unl' " & " insert into hse2" > or > SQL1 = "load from 'd:\x.unl' insert into hse2 > > I get a syntax error -201. Anyone know why. Because the LOAD statement is specific to DBACCESS, not SQL. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list ...

Re: database restore with ontape -r on Informix Online Dynamic Server #2
Paul Watson wrote: > something like > > onstat -r <<EOF > y > n > n > n > EOF > > should work, but I wouldn't use it on a production system Which is exactly the same as the example given, except for the obvious command error and the missing initial <CR> to the enter tape and press RETURN prompt. However, I am not convinced of the order of the answers, and I don't have ontape to hand to test..., on dev or prod. So I agree, simply run ontape -r and answer the prompts manually. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list ...

RE: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux
David Williams wrote > > "Andy Kent" <andykent.bristol@virgin.net> wrote in message > news:a3525a11.0401080308.64a1ed12@posting.google.com... > > Why ever would you want to run a cold restore unattended? > > > > Great laxative ... > > > > To create a reporting database once per week... > > Once all the ontape stuff is finished don't forget to > > a) Sit in a loop running onstat - and check the return > code each time.Wait for the server to reach quiescent > mode. This can take 45 mins. > > b) onmode -m to move to Online mode. > > Otherwise a reboot means another restore! > > I had this working great for a customer a while back! Here is one I prepared earlier --- onbar/ontape whatever .. FORCEOL=n until onstat - | grep "On-Line" > /dev/null do echo "Off line" # ; sleep 20 onstat - | grep "[BQ][lu][oi][ce][ks]" > /dev/null && ( echo "\nServ blokd" if [ x$FORCEOL = "xn" ] ; then echo "Onlining.." ; onmode -m ; FORCEOL=y; sleep 240 else echo "waiting to online " ; sleep 240 fi ) onstat - # for comfort factor sleep 60 done This seems to work on our automated restore of live for testing. I know the grep line looks like a load of boll*cks. But it works. Tru64 5.1 and ...

Re: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux #3
Thanks a lot ! My problem was the fact that I tried to restore on a Linux machine a backup made on a UNIX machine. The INFORMIX server version was the same. The problem was the OS, in fact. Backup with ontape is recommended only when the restore is made on the same machine. Carmen ----- Original Message ----- From: "S.Dhayanidhi" <sdhaya@hotmail.com> To: <informix-list@iiug.org> Sent: Monday, January 12, 2004 6:35 AM Subject: Re: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux > Here is my cute little code.. for unattended tape restore. > We do restore to our development everyday and it works fine. > > > # ------------------------------------------------------------------ > echo " ********************************************" > echo " * Tape Restore Utility (For Single Tape ) *" > echo " ********************************************" > # ------------------------------------------------------------------ > echo " " > echo " Press Enter to Continue or CTRL-C to Abort \c" > read con > echo "Please wait Shutting Down Engine..." > echo "y\ny\n" | onmode -k > echo "\nPlease wait Restoring..." > echo "\ny\nn\nn\nn\n" | ontape -r > while true > do > engstatus=`onstat - | awk '{ print $5 } &...

Re: Re: Informix and Linux opinions/who is running production #2
I know one. I've posted the name privately, as the last time I made the error of sharing information about a client on this list, a consultant (?) from this list cold called them. Nice behaviour. Pete _________________________________________________________________ Tired of 56k? Get a FREE BT Broadband connection http://www.msn.co.uk/specials/btbroadband sending to informix-list sending to informix-list Maelwys Filidh wrote: > I know one. I've posted the name privately, as the last time I made > the error of sharing information about a client on this list, a > consultant (?) from this list cold called them. > > Nice behaviour. Who was that? Try sharing the name of the thief now. ...

Informix User Forum 2006 - 2 day Informix Technical Conference for Users by Informix Users
A two-day Informix User Group Technical Conference - Friday and Saturday, December 8-9, 2006 The Washington Area Informix User Group (WAIUG) based in Washington, DC, and the Southeast Informix Users Group (SEIUG), based in Atlanta, GA, are teaming up once again to present Informix User Forum 2006. This will be the premiere Informix regional user group technical conference in the world. This is a user conference planned and run by Informix users for Informix users. I have been putting together the Washington Area Informix Users Group Forums since 1994 and last year's was the best event we have done to date. We had over 170 participants from 8 countries and 30 states in the US. There were 14 sponsors with products for the Informix user community. There were 32 technical presentations, by speakers who are Informix developers from IBM and DBA users from around the world. The message was very clear from IBM that Informix is a critical product and will continue to have a great future. The message from the users attending was also very clear, no other product does the job of Informix and we are loyal to what works. To view the results and presentations for last year's forum visit: http://www.iiug.org/waiug/present/Forum2005/Forum2005.html This years Forum looks to be even better then last year. We are very please to announce our Keynote Speakers --------------------------------------------------- * Friday, 8:00am December 8, 2006 � Ambuj Goyal, General M...

RE: [Maybe spam] Re: Relation of OS user to Informix database #2
You can only revoke a privilege that exists explicitly and you are the GRANTOR, if a user's rights are part of "public" then you cannot prevent the access unless you revoke connection privileges from public Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Gosney Simon" <GosneyS@axxia.com> >To: "Jonathan Leffler" <jleffler@earthlink.net>, <informix-list@iiug.org> >Subject: RE: [Maybe spam] Re: Relation of OS user to Informix database >user >Date: Thu, 25 Aug 2005 08:48:31 +0100 > >Jonathan... am I correct in thinking that you can't revoke rights from a >user who has those rights because they're a member of public? > >Ie, if they don't have the rights assigned with an explicit GRANT >statement, then you can't revoke their rights without revoking public's >rights and then granting permissions to all other users individually? > >Cheers > >Simon > >-----Original Message----- >From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] >On Behalf Of Jonathan Leffler >Sent: 25 August 2005 05:24 >To: informix-list@iiug.org >Subject: [Maybe spam] Re: Relation of OS user to Informix database user > >anupam.mukherjee@gmail.com wrote: > > I had just installed Informix Advanced Server version 10.0 f...

Re: Re: I want to open a doc file in window dir using informix #2
If you download the V4.2 you will see an example of what you want in the demo program. https://www.querix.com/cgi-bin/refreshprog?login On 21 Sep 2005 at 12:57, Jean Sagi wrote: > Thanks, > > Very interesting indeed. > > I would be more intertested in option 1) you give. I need to have MS Word in orther to view the document, isn't it? > > > J > > -----Original Message----- > From: mehdi2@querix.com > To: Jean Sagi <jeansagi@myrealbox.com>, informix-list@iiug.org, calyanram@hotmail.com > Date: Wed, 21 Sep 2005 11:25:20 +0100 > Subject: Re: I want to open a doc file in window dir using informix 4gl > > Hi Jean, > > Lets look at the following scenarios, > > 1) You have a BLOB / CLOB file (which may be anything including a > .doc file) in the database. > > You can display and edit it as you will with any other data when you are > using Querix, so if the file is sent to an Input field for update this is > exactly what you can do with it. > > 2) You have a document file stored some wher on a network, you are > only keeping the information about the place wher it is stored and you > only display the link in field. > > Here again you can open the file and if the file is not a read only you > can edit it. All you need is to clik on the link. > > 3) You have some information on the database you want to send to a ...

Re: Difference between Informix connect and Informix Client SDK #2
Hi Francisco. Client SDK is a developer's kit. You can create and compile program using ESQL/C (it is bundled.) Connect is a runtime of Client SDK. HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Francisco Roldan <froldan@5b.com.gt> >To: informix-list@iiug.org >Subject: Difference between Informix connect and Informix Client SDK >Date: Tue, 8 Jul 2003 12:18:35 -0600 > >Does Somebody would tell me the difference between >those Informix products? > >And the estimated cost of each one (for Linux) ? > >...

Re: Start informix database #2
Hi.. This is an example INFORMIXDIR=/opt/informix PATH=$PATH:$HOME/bin:$INFORMIXDIR/bin INFORMIXSERVER=coldecon_shm ONCONFIG=onconfig.coldecon export PATH INFORMIXDIR INFORMIXSERVER ONCONFIG oninit INFORMIXSERVER=opera_shm ONCONFIG=onconfig.opera export PATH INFORMIXDIR INFORMIXSERVER ONCONFIG oninit --- madiego <madiego@qf21.com> wrote: > Hello, > > I had an informix database in the unix server. The > server has been > restarted and now I can't start the database. > I execute 'oninit' and only can started the default > database but not > the database that I created.I haven't errors. > The configuration of INFORMIXDIR, INFROMIXSERVER, > sqlhosts and > onconfig is correct. > > What can I do? > > Regards, > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail sending to informix-list ...

RE: Informix database creation #2
Hi The existing chunk is already starting at offset of 500. Your new chunk should have the offset as 600501 . Regards Ravinder Bahadur _________________________________________________________________ Are you Unmarried? http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?4d Register in India's No 1 Matrimony. sending to informix-list "Ravinder Bahadur" <ravinder_b@hotmail.com> wrote in message news:bgsam4$i9q$1@terabinaries.xmission.com... > > Hi > The existing chunk is already starting at offset of 500. Your new chunk > sh...

How to copy a sun-database in one informix database to another informix database?
Hi, Sorry I am not an informix dba, and I was faced to copy a sub-database(sorry I don't know the clear name of such concept, as informix is like sql-server, which used multiple database) from one informix database system to another informix database. I know in oracle, we can use transportable tablespace, copy the datafile and transport the metadata, and do something else. How can I do it in informix then? Is there document which talk about the detail step? Thanks It would really help if you knew the versions of the Informix databases. Assuming Informix IDS 7.x or IDS 9.x If the two systems are binary compatible the fastest method is to use onunload/onload. If the systems are not binary compatible the easiest way is to use dbexport/dbimport. Everything is well documented in the manual "IBM Informix Migration Guide". This manual covers all Informix databases from Standard Engine and Online to IDS and XPS. See http://www.ibm.com/informix/pubs zhu chao wrote: > Hi, > Sorry I am not an informix dba, and I was faced to copy a > sub-database(sorry I don't know the clear name of such concept, as > informix is like sql-server, which used multiple database) from one > informix database system to another informix database. > I know in oracle, we can use transportable tablespace, copy the > datafile and transport the metadata, and do something else. How can I > do it in informix then? Is there...

RE: [Informix][Informix ODBC Driver] Database locale information mismatch
You could try issuing the following statement and see what the engine is configured for. onstat -g env This will give you the environment of the engine. I believe it is listed there what the locale is set to. David -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of bobkot@gmail.com Sent: Tuesday, May 23, 2006 7:28 AM To: informix-list@iiug.org Subject: [Informix][Informix ODBC Driver] Database locale information mismatch I have download ClientSDK 2.90.TC4 I am trying to connect to an IDS10 database. My iLogin works fine, but I cannot set up the ODBC driver, I keep getting the message "[Informix][Informix ODBC Driver] Database locale information mismatch" I cannot leave it blank, under environment, and I cannot find any matching pairs. Can somebody help. XP client and Linux server _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list Version 10.00.UC4E is what I am running. How do I determine what the database was created with ? I have no customer support - that is me - so where to for the patches ? Would that be for the IDS or the SDK This is a multipart message in MIME format. --=_alternative 0023D97D65257178_= Content-Type: text/plain; charset="US-ASCII" To find out what's the database locale in your environment go to the server in...

Re: ERROR -11048 [informix][informix ODBC driver] unable to load
--0__=08BBE4B7DF9175EE8f9e8a93df938690918c08BBE4B7DF9175EE Content-type: multipart/alternative; Boundary="1__=08BBE4B7DF9175EE8f9e8a93df938690918c08BBE4B7DF9175EE" --1__=08BBE4B7DF9175EE8f9e8a93df938690918c08BBE4B7DF9175EE Content-type: text/plain; charset=US-ASCII There could be couple of reasons for this error message : 1. Your INFORMIXDIR environment variable is not pointing to the correct location. 2. If you have multiple CSDKs installed in one Windows box then you might want to check that the one which you want is listed first in the PATH environment variable traversing from left to right ( for example : set PATH=%Informixdir_I_want%\bin;%etc_etc%;%PATH%). 3. Your Client and DB locales are not matching as per the conversions supported parameters. HTH -Shesh laboratorio@eldia rio.net (Luis To: informix-list@iiug.org Camacho) cc: Sent by: Subject: ERROR -11048 [informix][informix ODBC driver] unable to load ...

Re: Load testing tool for Informix #2
LoadRunner and QAtools come to mind ... Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi kalpanapai@hotmai l.com ...

Re: Moving Informix TableSpaces between databases #2
I think your best bet would be to use HPL to unload data from the logged db and load it into the non-logged db as long as they both have the same schema(=table definition). Regards, Uday. "Aashish Ramsinghani - ASDC, Chennai" To <Aashishsr@hcl.in informix-list@iiug.org > cc Sent by: owner-informix-li Subject st@iiug.org Moving Informix TableSpaces between databases 12/09/2005 07:01 AM Hi I am using Informix for one of my DW projects. We are loading data from the source system into the staging area both are separate Databases. Source has logging enables and staging has it disabled. The problem comes when I try to access data across both these databases. I cannot link tables between these databases because of their logging properties. So I am dumping the data into a CSV file and loading it again but for my initial load which consists of 40+ million records it is a problem. In oracle I know we can make a separate table space and dump the data there then load the table space to another database. I don't know if such a thing is possible in Informix. Any help will be appreciated. Th...

RE: File Closing Problem in 2.3 and 2.4, Not in 2.5 #2
John: <<<snip>> >=20 > Hi Barry, >=20 > Please always reply on-list if the communication is non-private -- and > meaningful :-) Right. I noticed I hadn't "replied-to-all", so I resent the post to the mailing list. Slip of the mouse, no disrespect intended to the list ;^) >=20 > I don't know; here are some things you could check out: >=20 > (1) Windows XP versus *x: The limit on open file handles is 512 in > Windows XP; write yourself a reference-preserving [hint: append to a > list] multiple file opener on *x and see how m...

Re: How to run Informix as a normal/unprivileged "informix" user? #2
--0-1804522149-1193257177=:47469 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable > Making the IDS start with SYSTEM account is even worse than starting it w= ith as an administrator of the system=0A=0AWhy is it worse? =0A=0ASYSTEM is= not a real user. Many server programs choose to run their services as SYST= EM for security purposes so the real users can be taken out of Administrato= rs group. Can you elaborate on your specific concerns about running IDS as = SYSTEM user.=0A=0AGuy=0A=0A=0A----- Original Message ----=0AFrom: "kdobrev@= gmail.com" <kdobrev@gmail.com>=0ATo: informix-list@iiug.org=0ASent: Wednesd= ay, October 24, 2007 2:07:11 AM=0ASubject: Re: How to run Informix as a nor= mal/unprivileged "informix" user?=0A=0A=0AI'm using Windows Server 2003 Sta= ndart. I have tried to make Informix=0Amember of Users instead of member of= Administrators, but a user cannot=0Astart services. I have given the right= to login as service, but still=0Ano luck. Making the IDS start with SYSTEM= account is even worse than=0Astarting it with as an administrator of the s= ystem.=0A=0AAny other suggestions?=0A=0A___________________________________= ____________=0AInformix-list mailing list=0AInformix-list@iiug.org=0Ahttp:/= /www.iiug.org/mailman/listinfo/informix-list=0A=0A=0A=0A=0A=0A_____________= _____________________________________=0ADo You Yahoo!?=0ATired of spam? Ya= hoo! Mail has th...

Re: Moving Data from Informix SE 4 to Informix SE 7 #2
"DBEXPORT bombs out on certain databases because of corrupted system > > tables and/or bad data." I have found that nearly all instances of DBEXPORT "bombing" are due to invalid data in date fields, especially when the data originated in 4.x or earlier versions of the database. The best way around the problem is by first finding the offending rows with a where clause that includes <datefieldname> not between "01011800" and "12312099" and then updating or deleting such rows with the same where clause. If you delete such rows, or at least update the offending date fields to some unique valid date that you can later identify, your export should at least complete. John Fahey ----- Original Message ----- From: "scottishpoet" <dryburghj@yahoo.com> To: <informix-list@iiug.org> Sent: Tuesday, August 31, 2004 8:13 PM Subject: [iiug] Re: Moving Data from Informix SE 4 to Informix SE 7 > nlaods?? no thts not a special utility sorry its another typo > > wolphie@hotmail.com (Smitty) wrote in message news:<4f39af7f.0408301540.5de8ce63@posting.google.com>... > > I'm a programmer/analyst at a medical services company. At the core > > of our system is an Informix SE 4.x database - (c)1990, with all > > business software written in-house using Informix 4GL and FourGen (a > > CASE tool also from the early 90s). Everything runs from an R...

Re: Naming Convention for Informix Database Objects #2
Obnoxio The Clown wrote: > Christopher wrote: > > >>Can anyone recommend a good naming convention for database objects in >>Informix? >> >>Generally, I use my own variation on Hungarian, but I wondered if >>there is an equivalent of the RVBA (also known as Leszynski/Reddick) >>standard among Informix developers. >> >>I would also be thrilled to find a write-up I can reuse or just plain >>plagiarize. >> >>As an aside, this is to be implemented on IDS 9.4, so long identifiers >>are not an issue. > > > I generally prefix tables with this_is_a_table_called_, views with > this_is_a_view_called_, indexes with this_is_a_index_called_ ... ....And jokes with this_is_a_joke_ ... You shouldn't use your powers over the weak-minded for evil, Luke! I'm looking at a variable name in some 4GL code at the moment called g_f_or_p. Guess what values it generally contains? Now do you think I need to change it's name if I change it's contents?... Give people enough rope (chars), ... Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, wh...

RE: How long can an Informix database name be? #2
The database name on SE is limited to 10 characters. This is an historical anomaly based on the fact that the database name was used as the directory name where that database will be stored. Directory names in early versions of unix were restricted to 14 characters, but that was including any extension, and as informix used dbname.dbs that restricted the database name to 10 characters. And beware - on some versions that ran on DOS it was further restricted to 8 characters - but that's another story. Regards Malcolm -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Sebastian, Norma J. Sent: 11 January 2005 04:18 To: informix-list@iiug.org Cc: Mark Scranton ; Sebastian, Norma J. Subject: How long can an Informix database name be? Hi all, I have a customer with a "how long can a database name be?" question. The story is they have a standard engine, and lots of small databases, and they follow a certain naming standard for database names. They are using the informix engine as an embedded product, and he(customer) did not know the root or informix password on this system. First issue is... What IDS version.... Well.... I found tools like selog and secheck in $INFORMIXDIR/bin. When run, they show: Selog DBLOG: Transaction Log File Display C-ISAM Version 7.25.UC1 Secheck BCHECK C-ISAM B-tree Checker version 7.25.UC1 When I go into Isql,...

Re: Informix and Linux opinions/who is running production #2
And... are there any linux-informix shop runing 4GL RDS applications on linux? Which informix versions, which linux platform? It seems to me that the answer to this question is NULL. (I hope I am wrong) Mario R. Canto Andrew Hamm wrote: > > Gary Quiring wrote: > > I would like to know if we have any shops out here running IDS 9.x on > > Linux in a production environment where you have at least 300+ users > > connected at one time. We had a visit from our Informix var today and > > they are trying to convince me that Linux on IBM hardware is more > > stable than Solaris on Sun hardware. I want the real story from shops > > that know.... > > Yes. In a cosmic join to another thread, one of our departments has replaced > dozens of HP's (when their time is due) with Intel Linux boxes, and the > customers couldn't be happier. The department has standardised on RH7 and > lately RH8 but are not yet offering RH9 or the new-fangled RH AS or ES > ports. > > One of their very largest customers is about to move to Intel Linux if I > read the grapevine properly, and that site will exceed the 300 users limit > by a few times, let alone a few dozen -- Ing. Mario R. Canto e-mail: mcanto@4m.com.ar 4M Consultores Informaticos Asociados URL:http://www.4m.com.ar Director - Consultor Senior Tel/Fax:(0342)455-6566 25 de Ma...

Web resources about - RE: hi Cant load informix online 5.2 on linux -8 ( rpm file) - comp.databases.informix

IBM Informix - Wikipedia, the free encyclopedia
IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system ...

IBM Informix (@IBM_Informix) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Informix - News, Features, and Slideshows
Latest news, features, and slideshows on Informix from Computerworld

Informix Database Administrator / Developer
Defining Technology for Australia's IT Leaders.

Informix technology whiz bails out for Andromedia
San Francisco, CA News - View Daily Local Business News, Resources & more in San Francisco, California. Informix, the Menlo Park-based database ...

S&P Stock Reports: Informix Corp.
Revenues in the first quarter of 1997 declined over 30%, owing to sluggishness associated with product transition uncertainties stemming from ...

Informix says Oracle is "sleazy"
... A CNET article by CNET News.com Staff, . Published on January 24, 1997 12:30 PM PST. No love has ever been lost between database makers Informix ...

IBM Acquires Informix
IBM took a major step today in its effort to strengthen its software business and take down Oracle by agreeing to acquire Informix Software's ...

The Four HundredIBM Buys Other Half of Informix with Ascential Acquisition
IBM Buys Other Half of Informix with Ascential Acquisition by Timothy Prickett Morgan Four years ago, in April 2001 to be precise, IBM bought ...

IBM's Informix buya billion dollars worth of benefit?
So IBM is buying Informix Software, Informix Corp.'s database unit and the heart of the company.

Resources last updated: 3/2/2016 6:03:13 PM