Threads from 1996
Re: 32meg 70ns 72pin EDO simm for $140
All deleted so not too waste to much space. Now I've had it. Blanket posting of your ads to newsgroups is a direct breach of usenet etiquette. Please find someone who has used the internet for more than a month and ask them. I now how to find alt.misc.computer.memory if I wan…
Stored procedure overhead
Informix documentation advises that using stored procedures can improve performance because the procedure is stored in the database in an executable form. (Which makes sense, since you avoid syntax-checking, creation of query plans, etc.) However, some recent experimentation ap…
=?iso-8859-1?Q?RE=3A_Support_for_e=F1e_=28spanish_letter=29?=
Hi Javier! There is a feature called GLS (Global Language Support), Informix = products no longer need to specify how to process this culture-specific = information directly. Culture-specific information resides in a GLS locale. When an = Informix product needs culture-specific …
=?ISO-8859-1?Q?Support_for_e=F1e_=28spanish_letter=29?=
I need to know if INFORMIX 4.1 or above can support many spanish cases, like � or �, or else. The display of this cases on any PC was sucesefull, but I can't read if I'm on a IBM RISC 6000 plataform. Does is Physicaly stored the ascii code of the spanish cases??? Are the INFOR…
Re: Symantec Cafe Pro (JAVA) Support for Informix
Although I haven't tested it yet you should be able to use the JDBC drivers from OpenLink. I don't think they need ODBC, but am not sure. Check out their web site (http://www.openlinksw.com). There are other JDBC drivers available as well, but I haven't checked which are direct a…
Re: SE performance
michelle Attaya Kelo wrote: > > We are running Informix SE 7.1 on Sco Unix 5.0. We have recently ported > to SE from Online and are experiencing a large degradation in > performance. > > One problem is querying a table which has about 23000 rows using a simple > select statement …
Re: db server & inet
Duc Nguyen wrote: > > Hi all, > > We use Informix ODS 7.1. I have 2 questions: > > 1. We're using multiple residency by running > multiple database server instances (each with > its own ONCONFIG file). Now how do I drop > a database server instance? I can't just > remove the conf…
Re: Opinions on NewEra
In article <32BA5D8E.4510@zip.com.au>, Oliver Townshend <oliver@zip.com.au> wrote: >Joseph Loutzenhiser wrote: > >> I don't think NewEra 3.0 is out yet. I found no mention of it on the >> Informix website yesterday. As for the current version of NewEra, >> Delphi runs ring arou…
Re[2]: re-creating .idx file
This can be done in a few steps: 1 - create a new table w/the exact same structure as the old one (column names, indexes etc) but w/a different name 2 - modify the row in systables for the old table to point to the new one. (i think the column is path …
TRANSACTION STATE
Hi Informix Gurus, Is it possible in Informix on-line 7.2 to find out the current state of a transaction. Is there something equivalent to @@transtate of Sybase. I am interested in finding if a transaction is in progress or not. We are executing the transaction in non-ansi mo…
Re: Stored Procedures and Serial Values -Reply
Sky Southwell <SOUTHWEL@smtpgw.maricopa.gov> wrote in article <5a8lt6$lst@cssun.mathcs.emory.edu>... > Try the following: > (from the Informix Guide to SQL: Syntax, for v7.1, > I don't know if this works in the 5.x/4.x world) > > let serial_value = dbinfo("sqlca.sqlerrd1"); > re…
Re: Stored Procedures and SQLCA record access
Peter J. Diaz de Leon <pdiazdeleon@infinityhealthcare.com> wrote in article <5a7ntb$20h@news2.alpha.net>... > > I just finished writing a stored procedure that inserts > a record into a table with a serial value column. > With 4gl to find out what serial value was assigned > to t…
Re: Shared memory connections
Neil Truby wrote: > > My site uses OnLine 7.13 on Solaris 2.4 > > I've noticed that one of our instances has only network connections > defined, no shared memory ones, so not even local utilities are using > shared memory connections. Does anyone have a feel for the effect this …
Re: OMNI REPLICATOR
------------6AC87A331120 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Daniel Carbajal Zavaleta wrote: > > Hi, > Anyone knows about Omni Replicator? Does it work fine for informix- > to-informix remote table replication? > Any help/advice will be gre…
Re: Symantec Cafe Pro (JAVA) Support for Informix
Yes, both Symantec and Informix are making a major blunder if they don't partner to interface each other's products. Symantec will be unable to sell Visual Cafe Pro to Informix users, and Symantec Java users will purchase other databases besides Informix. Richard --------------…
Informix data warehousing "breakthrough"
The December 23rd issue of Information Week has a big "Top of the Week" article entitled "Informix Breakthrough- Six financial firms sign deals for data warehousing". They are Fidelity Investments, First Union National Bank, Great Western Financial, Merrill Lynch, State Street B…
SQL Selection Set Questions
After performing a SQL select on a table, I need to then know how to work with the selection set to: 1. Step through each record (row) 2. Retrieve the value for a specific field in each row 3. Set the value of a specific field in each row 4. Run another SQL select with an "order…
INFORMIX DBA's
Attractive permanent positions are available now in numerous cities across the U.S. for Informix DBA's or UNIX System Administrators. Positions are in technical sales support with one of the premier database software companies in the country. This is one of the best opportunities…
Re: Raw space vs filesystem
------------768014FE76C17 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Dinesh Salegame wrote: > I wanted to find out what are the pros and cons of using raw vs regular don't use regular files. i personally can't think of a single reason to u…
any Dec Alpha Cluster users?
------------4DED2A983EB86 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii hi, i'm looking at doing a migration to two dec alpha servers, and the client wants to use their clustering setup. i'm not familiar with it yet and will start in on that, b…
Re: Informix On-Line Books
------------406E63DB253D5 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii > Does anyone have a recommendation for third-party books about > Informix database administration and/or Informix database performance and > tuning? The manuals that co…
Re: From INFORMIX 5 to 7 - where will the performance go?
------------4E2256614DAC4 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii > If we add the INFORMIX V7.0 only, where will the performance go? > What we have to do, for the same performance under 7.1 as under 5.0. > I can not belive, that we have to inst…
Re: From INFORMIX 5 to 7 - where will the performance go?
------------6F1626CC195F3 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii > If we add the INFORMIX V7.0 only, where will the performance go? > What we have to do, for the same performance under 7.1 as under 5.0. > I can not belive, that we have to inst…
Re: HELP! My Page Cleaners keep dying!!!
------------673325D547C2 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii > Running Informix OnLine 5.03 (ancient, I know) and > I continually have page cleaners to go into (E)xit > state and NEVER COME BACK! > > Kinda new to Informix, and I'm not sure …
Re: SPARCstorage Array & Disksuite software
------------23ED73D34EFB1 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii rcyrus@promarkone.com wrote: > > We are looking at purchasing these products! Anybody have any horror > stories or recommendations or experiences... > > robin cyrus > Sr. Informi…
Re: SPARCstorage Array & Disksuite software
------------5F6A5F884DFC0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii rcyrus@promarkone.com wrote: > > We are looking at purchasing these products! Anybody have any horror > stories or recommendations or experiences... > > robin cyrus > Sr. Informi…
Re: How to do it in SQL
On Mon, 30 Dec 1996, Toby Denbow wrote: > Say i have a table called 'company' with the following fields: > company_id > company_name > parent_company_id > > How can I get a listing of all of a Companies Parents without using a > FOR loop? > > Sample DATA: > Record 1: > company_i…
Symantec Cafe Pro (JAVA) Support for Informix
Which, at this point in time, is nonexistent. They have drivers for Oracle, Sybase, MS SQL Server natively. No Informix. I asked them, and they have no current plans to add Informix. Having had a *brief* play/look at the Java toolkits around, this one looks like the best availa…
Re: Do alarms work in 7.20 ?
Thanks to everybody who has offered suggestions. I have gotten past some of my problems by correcting the errors in the alarm handling script itself. I did not need to change permissions on the file. I am curious about something though. Mark said that in 7.10, all calls to th…
db server & inet
Hi all, We use Informix ODS 7.1. I have 2 questions: 1. We're using multiple residency by running multiple database server instances (each with its own ONCONFIG file). Now how do I drop a database server instance? I can't just remove the config files and chunks, because there s…
Re: re-creating .idx file
Note: usually you can unload the data since no indexes are required to dump data. Then drop the table and reload, creating indexes after the loading is completed. If you hosed your idx file shuffling files "usually" doesn't help because the system (Informix) still thinks there is…
Informix Version 7.20.UC3 Upgrade Question
I have two questions: Is anyone having any problems with this version on HP-UX 10.10? And second, Is anyone (reguardless of platform) using this version with data replication? Your responses are deeply appreciated. David Pavao Wall Data Inc.…
Informix Positions in Florida, Contract and Perm
Intelligent Software Strategies is currently recruiting for several Informix professionals for a central Florida assignment. we are currently seeking database administrators, data analysts, and data managers. we need contractors, permanent and right to hire candidates. excellent …
How to do it in SQL
Say i have a table called 'company' with the following fields: company_id company_name parent_company_id How can I get a listing of all of a Companies Parents without using a FOR loop? Sample DATA: Record 1: company_id = 1 company_name = Company one parent_company_id = 2 Sampl…
Shared memory connections
My site uses OnLine 7.13 on Solaris 2.4 I've noticed that one of our instances has only network connections defined, no shared memory ones, so not even local utilities are using shared memory connections. Does anyone have a feel for the effect this will have on administration p…
Re: creating a chunk
Dean Peddle wrote: > > system: sco unix 3.2.4.whatever > db: informix online 5.03 > usage: testing system > > Problem: system had recent disk problem. Reinstall started but no > recent system backups could be located - at least not complete. root > filesystem pieced backed…
US-NY/NJ INFORMIX DEVELOPERS Learn PowerBuilder
Outstanding opportunities exist for talented INFORMIX Developers to work on a data warehousing project. Excellent opportunity to learn PowerBuilder. Work with a great bunch of people in a relaxed casual atmosphere!!!!! Salary based on experience. For immediate consideration C…
Re: re-creating .idx file
I'm not sure this will work or not: - copy idx file from one of other table where there is no index. - go into dbaccess or isql, than try to create index Susik ______________________________ Reply Separator _________________________________ }Subject: re-…
Help! for informix-sql demo
Yan Qu <yq22+@andrew.cmu.edu> wrote: > > >Hello, I'm trying to install the informix-sql demo database using >"isqldemo". The version I'm using is Version 2.10.00B for unix >pmax_mach. > >I got the following error messages when runing "isqldemo": > >"INFORMIX-SQL Demonstration …
Informix
We used informix/unix for our applications and we are on the process in porting our applications to Window NT4. Does anyone know where I can get examples for converting the esql/c/unix version to Window NT, and examples for informix-CLI/ODBC using Visual C++? Thanks in advance fo…
Stored Procedures and Serial Values -Reply
Try the following: (from the Informix Guide to SQL: Syntax, for v7.1, I don't know if this works in the 5.x/4.x world) let serial_value = dbinfo("sqlca.sqlerrd1"); return serial_value; -- Sky +-------(southwel@smtpgw.maricopa.gov)-------+- Maricopa County -+ | Schuyler L. Sout…
SQL Selection Set Questions
WebMaster@HyperNetUSA.com (Larry W. Berman) wrote: Using cursors is covered fully in the Informix Documentation >After performing a SQL select on a table, I need to then know how to work >with the selection set to: > >1. Step through each record (row) >2. Retrieve the value for…
Re: re-creating .idx file
Kevin P. wrote: > > oops! i hammered an .idx file while trying to "fix" an indexing > problem with one of the tables in my system. yes, i know that > it says practically everywhere in the manuals not to do this, > but i figured if it was hosed already, what could it hurt. so, > w…
Please help! Is Informix JDBC ready yet?
Does anyone know about the promissed JDBC from Informix for the end of the year 1996? Is it ready? If so where can i download it? thanks a lot.…
Re: creating a chunk
On 29 Dec 96 at 14:56, Dean Peddle wrote: > Problem: system had recent disk problem. Reinstall started but no > recent system backups could be located - at least not complete. > root filesystem pieced backed together. Now missing cookedspace on > secondary (/u) filesystem which…
Stored Procedures and Serial Values
I just finished writing a stored procedure that inserts a record into a table with a serial value column. With 4gl to find out what serial value was assigned to the record just inserted I would access SQLCA.SQLERRD[2]. However, how do I find out what serial value was assigned fr…
Stored Procedures and Serial Values
I just finished writing a stored procedure that inserts a record into a table with a serial value column. With 4gl to find out what serial value was assigned to the record just inserted I would access SQLCA.SQLERRD[2]. However, how do I find out what serial value was assigned fr…
Stored Procedures and SQLCA record access
I just finished writing a stored procedure that inserts a record into a table with a serial value column. With 4gl to find out what serial value was assigned to the record just inserted I would access SQLCA.SQLERRD[2]. However, how do I find out what serial value was assigned fr…
[Fwd: I want find commercial datebases]
This is a multi-part message in MIME format. ------------394A55D87BCC8 Content-Type: multipart/alternative; boundary="----------391C143246659" ------------391C143246659 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Hi all, Can you help? We are new u…
JOB - 4GL P/A - Scottsdale/AZ
Growing company located in Scottsdale, Arizona is currently interviewing to fill a software development position. Must have two or more years experience with Informix 4GL. Please fax, mail, or e-mail your resume in confidence as soon as possible. If you would like to discuss t…
JOB - Informix DBA With Programming Exp. - Los Angeles/CA
Software development Corporation in Los Angeles, California is currently interviewing to fill an Informix specialist position. Qualifications: * A combination of Informix DBA and programming experience. * Experience with AIX, HP-UX, or SCO a plus. Please fax, mail, or e-ma…
JOB - 4GL P/A - Newport Beach/CA
Growing Orange County software development firm is currently interviewing to fill a software development position. Qualifications: * One or more years experience with Informix 4GL. Benefits: * Salary will vary with experience. * Flexible work week. * No dress code. * I…
JOB - NewEra P/A Southern Calif.
Growing company located in Southern California is currently interviewing to fill a senior NewEra software development position. Must have one or more years experience with NewEra. Great opportunity to work for a well known company with an above average salary, incentive program, …
JOB - 4GL P/A San Diego/CA
Growing company in San Diego, California is currently interviewing to fill an Informix 4GL software development position. Must have one or more years of experience with Informix 4GL. Please fax, mail, or e-mail your resume in confidence as soon as possible. If you would like t…
Informix and Java
Is there ESQL for java ( Or something simalar) I have been using the jdbc-odbc bridge so write a java server application but i would like to move the server to the UNIX box ( Currently on an NT box). We only have ODBC for Windows NT. Any sugestions? jk…
Re: Oracle/Sybase/Informix/MS-SQL Server
In article <59o4pp$1mp@cssun.mathcs.emory.edu> billy@west.co.za ("Billy Wheeler") writes: >On 23 Dec 96 at 17:09, Cynthia Merritt wrote: > >> We are going to be purchasing an RDBMS sometime in 1997. > >Well, choose a database first, and *don't* run on NT. NT Sucks. And Stop exag…
creating a chunk
system: sco unix 3.2.4.whatever db: informix online 5.03 usage: testing system Problem: system had recent disk problem. Reinstall started but no recent system backups could be located - at least not complete. root filesystem pieced backed together. Now missing cookedspace…
Re: Oracle/Sybase/Informix/MS-SQL Server
On 29 Dec 96 at 17:09, Joe Lumbley wrote: > I am probably the biggest UNIX bigot around, but I've been very > pleasantly surprised by Informix 7.XX on NT. I have AIX, HP-UX, > UnixWare, Stratus, and god-knows-what-else systems available, and my > NT Informix servers are amo…
Re: Oracle/Sybase/Informix/MS-SQL Server
Billy Wheeler (billy@west.co.za) wrote: : On 27 Dec 96 at 15:14, Scott P. Smith wrote: : > I know I'm asking for it, but here it goes: Saying things like "NT : > Sucks." really doesn't say anything. NT and UNIX both have there : > place. NT is great for small to midsized LANs …
Re: 4gl SELECT Statement Woes
On 28 Dec 96 at 21:27, John Cokos wrote: > Help.... > > Why doesnt this work: > > INPUT BY NAME cStuff Firstly, cStuff must be a CHAR. > { User will type in the following: 500,400,300 } > > SELECT count(*) INTO nCount FROM customers > WHERE cust_no IN(cStuff) If you PREP…
Re: 4gl SELECT Statement Woes
Another solution which has the benefit of preparing the select statement only once (a benefit if this section of code is executed more than once) would be to create a temp table (lets call it cStuff) to store the individual values of the user input, then prepare a statement like …
Re: Automate OnLine Archive on Windows NT
Im Artikel <32AFC577.6481@sni.de>, Dirk Schmidtpott <schmidtpott.pad@sni.de> schreibt: >> Hi all, >> >> Has anyone successfully used "at" command on Windows NT 3.51 to schedule >> "ontape -s" to run at a specified time? We keep get " Must be dbsa to run >this >> program.", and I…
Re: HELP! My Page Cleaners keep dying!!!
Im Artikel <32c3f758.0@pc162.abrfc.noaa.gov>, jbo@awips1.abrfc.noaa.gov schreibt: >Kinda new to Informix, and I'm not sure how to >figure out why this is happening. The log only >has a "ERROR: page cleaner # X has timed out" >message, and I haven't found a utility which will >g…
Re: 4gl SELECT Statement Woes
John Cokos wrote: > > Help.... > > Why doesnt this work: > > INPUT BY NAME cStuff > { User will type in the following: 500,400,300 } > > SELECT count(*) INTO nCount FROM customers > WHERE cust_no IN(cStuff) > > IF nCount > 0 THEN > ERROR "Duplicate Customer Number Found!"…
Re: Oracle/Sybase/Informix/MS-SQL Server
Cynthia Merritt <cynthia_merritt%compressor_controls@mcimail.com> writes: >We are going to be purchasing an RDBMS sometime in 1997. >Can anyone direct me to a good place to find out the differences between >these systems? Glad to listen to any opinions... thanks Cynthia, You…
Re: HELP! My Page Cleaners keep dying!!!
There are some old bugs that could be related to this. Have you contacted the support line? Also, it is possible that the cleaners are having to do too much work. Try increasing the number of cleaners in your TBCONFIG file. Madison Pruet…
Re: Limited Transaction Logging
In a word - no. However, turning on logging does not mean that you have to open every program and put in a begin work and end work in each of your programs. Let me explain. There are really two things that logging gives us - 1) the ability to recover the database to the point…
BestBook Reviews
I review books for CBooks, one of the nation's premier computer book stores (http://www.cbooks.com/) and I need your help. I'm looking for the best books in several categories: - Database - Web Programming perl, TCL, Python, Javascript, ActiveX, etc. - UNIX Operating Systems…
Re: Raw space vs filesystem
Im Artikel <59uu55$db2@flood.xnet.com>, dvs@flood.xnet.com (Dinesh Salegame) schreibt: >Hi, > > I wanted to find out what are the pros and cons of using raw vs regular > filesystems for dbspaces. We are using Informix 7.2 and HP UX 10.01. > Any comments on how to use the LVM in …
4gl SELECT Statement Woes
Help.... Why doesnt this work: INPUT BY NAME cStuff { User will type in the following: 500,400,300 } SELECT count(*) INTO nCount FROM customers WHERE cust_no IN(cStuff) IF nCount > 0 THEN ERROR "Duplicate Customer Number Found!" END IF If I (in the 4gl code) hard cod…
Checking the machine where app is running
Hello Dudes, I want to sell my aplications but i need to certify that the machine where the software is runing is that to which i sold it to. How can i do this ?? David Mendes…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Re: Informix 7.13 on HP 10.01
You don't need to use logical volumes if you don't want. Logical Volumes are only usefull for Online if you want to mirror with LVM-Mirror (only available if you have purchased HP-UX Mirror). So you can use the raw device "/dev/vg__/rvol__" or you can use the whole disk (maximum …
Re: Halt OnLine 7.14 with HP-UX 10.01
There a major patch bundles for Online from HP for your version. You should'nt use HP-UX 10.01. You have the possibility to upgrade from 10.01 to 10.20 now with the business release of HP. I don't know if this is exactly your problem buit might well be. Also you should then insta…
Re: HELP! My Page Cleaners keep dying!!!
There are some old bugs that could be related to this. Have you contacted the support line? Also, it is possible that the cleaners are having to do too much work. Try increasing the number of cleaners in your TBCONFIG file. Madison Pruet…
Re: Limited Transaction Logging
In a word - no. However, turning on logging does not mean that you have to open every program and put in a begin work and end work in each of your programs. Let me explain. There are really two things that logging gives us - 1) the ability to recover the database to the point…
Re: Raw space vs filesystem
Im Artikel <59uu55$db2@flood.xnet.com>, dvs@flood.xnet.com (Dinesh Salegame) schreibt: >Hi, > > I wanted to find out what are the pros and cons of using raw vs regular > filesystems for dbspaces. We are using Informix 7.2 and HP UX 10.01. > Any comments on how to use the LVM in …
BestBook Reviews
I review books for CBooks, one of the nation's premier computer book stores (http://www.cbooks.com/) and I need your help. I'm looking for the best books in several categories: - Database - Web Programming perl, TCL, Python, Javascript, ActiveX, etc. - UNIX Operating Systems…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Re: Informix 7.13 on HP 10.01
You don't need to use logical volumes if you don't want. Logical Volumes are only usefull for Online if you want to mirror with LVM-Mirror (only available if you have purchased HP-UX Mirror). So you can use the raw device "/dev/vg__/rvol__" or you can use the whole disk (maximum …
Re: Halt OnLine 7.14 with HP-UX 10.01
There a major patch bundles for Online from HP for your version. You should'nt use HP-UX 10.01. You have the possibility to upgrade from 10.01 to 10.20 now with the business release of HP. I don't know if this is exactly your problem buit might well be. Also you should then insta…
Re: Limited Transaction Logging
Jon Perelstein <loki173@worldnet.att.net> wrote: As far as I know logging is either on or off... It is not the programs that are usually converted, unless they were not written using for update cursors, it is the database that is logged. What exactly is happening at this point …
Re: Sequencers in Informix
"Ilya Liberman" <iliberman@teir.com> wrote: >hello, > >is there any way to automate unique key generation in Informix? >i am used to doing that by creating sequencer objects in Oracle. > >i did look at SERIAL datatype. It is not exactly what i had in mind That what the SERIAL d…
Re: DATETIME in Select
Bhupendra Patel (bsqlbp@wnhealth.co.nz) wrote: : adate char(6) yymmdd : atime char(5) hh:mm : select admno, : adate[1,2]||"-"||adate[3,4]||"-"||adate[5,6]||" "||atime[1,5] adms , : current Year to minute bif : from patmi1af : where adate = "961012" : INTO TEMP T1; : : se…
Re: Limited Transaction Logging
In <32C40EBD.64FD@worldnet.att.net> Jon Perelstein <loki173@worldnet.att.net> writes: >Is it possible to implement limited transaction logging in Informix? >We have a very large system (in terms of number of programs) that does >not use any transaction logging whatsoever. As a…
FW: Limited Transaction Logging
I don't know what database engine you are running but if it is DSA 7.12 or higher you may want to look into using temp dbspaces. If you setup a table space as a temporary table space any tables created in it are not logged (meaning all inserts,updates,deletes). As long as you …
Re: forms query?
: i'm using informix 4gl 6.2. while capturing data using forms i have the : foolng problem. : i want to capture numeric data declared with integer and when the user : enters the number i want to fill the space with zeros. so that : [ 1]if the user enters this my screen should …
FW: Oracle/Sybase/Informix/MS-SQL Server
I think this thread is getting way out of hand. The question was to compare NT and Unix as database servers, not to compare personal preferences. (Please don't blow up on this) I personally have worked with both as far as database servers and I think they both have their place.…
Informix in South Florida-Contract & Full Time
**** INFORMIX**** INFORMIX**** INFORMIX**** INFORMIX**** INFORMIX INFORMIX DBAs' AND DEVELOPERS NEEDED IN SOUTH FLORIDA *** MANY OPENINGS *** HIGH SALARY *** *** LOTS OF OVERTIME *** Computer Careers Inc., is actively seeking experienced INFORMIX DBAs' who are i…
Re: Oracle/Sybase/Informix/MS-SQL Server
I feel like I have to point out that vi as well as UNIX shells and utilities have been available for Windows/Windows NT for years. I've used MKS toolkit (contains awk, vi, make, etc.) on Windows and it's worked fine for me. I do have some complaints about Windows though. My bi…
Re: Oracle/Sybase/Informix/MS-SQL Server
On 27 Dec 96 at 16:59, Andrew Beattie wrote: > Microsoft puts a lot of time and effort into making things not > "user friendly", but *novice* friendly. As you rightly state, it's > easy to pick up... > Ah, where would we be without the erudite and the concise! :-) This is exac…
RE: KAIO error on DEC Unix v3.2
Hi Ray! Your NUMAIOVPS parameter is too high, DEC ALPHA uses Kernel AIO, and this parameter is super high in your case. We had a similar problem when we used the formula (OnLine Configuration Parameters 37-47) it gave me 16 and we had the error, so we had to reduce the number of…
Re: Oracle/Sybase/Informix/MS-SQL Server
On 27 Dec 96 at 15:14, Scott P. Smith wrote: > I know I'm asking for it, but here it goes: Saying things like "NT > Sucks." really doesn't say anything. NT and UNIX both have there > place. NT is great for small to midsized LANs were all the clients > are Windows/Win95. I kno…
Re: re-creating .idx file
On 27 Dec 96 at 16:06, Kevin P. wrote: > oops! i hammered an .idx file while trying to "fix" an indexing > problem with one of the tables in my system. yes, i know that it > says practically everywhere in the manuals not to do this, but i > figured if it was hosed already, what …
Limited Transaction Logging
Is it possible to implement limited transaction logging in Informix? We have a very large system (in terms of number of programs) that does not use any transaction logging whatsoever. As a short term fix to address our highest areas of risk, we would like to immediately impleme…
Sequencers in Informix
hello, is there any way to automate unique key generation in Informix? i am used to doing that by creating sequencer objects in Oracle. i did look at SERIAL datatype. It is not exactly what i had in mind please cc me via e-mail. thanks, - ilya…
Error: Database SQLcode = -406
I received the error message from Ilogin Demo when I tried to connect to stores7 database: Database SQLcode = -406. I run Informix Online Workgroup Server, version 7.12.TC5, Windows NT 4.0. Also, Database Explorer just quits after user ID and password are entered. Thanks for any …
Re: Oracle/Sybase/Informix/MS-SQL Server
>Any reasonably intelligent person who has >used Windows can set up and manage an NT server (manage user accounts, >manage print servers, etc.) with no additional training. In fact I didn't >even need to open a book. All the instructions are on-line in build-in >help files. I c…
KAIO error on DEC Unix v3.2
We are getting the following error in our informix log... KAIO out of OS resources, errno = 35 errrno 35 is described in errno.h as "Operation would block". I have a feeling we are running into a Unix kernel parameter that needs to be adjusted. If anyone has any idea which ke…
NYC: informix ESQL/c/unix & VB Programmer
If you have the following qualifications, you are just what we are looking for: - Self starter..works well independently in an entrepneurial environment - Good communication skills (dealing with clients) - Live in the Metro New York area and are a US Citizen - Experienced in cod…
Re: OMNI REPLICATOR
Yes, OmniReplicator does work for Informix-to-Informix, as well as replicating between Informix and a number of other DBMSs. Informix recently signed an OEM agreement with Praxis International, the vendor of OmniReplicator. There is a press release about the OEM agreement on Pra…
HELP! My Page Cleaners keep dying!!!
Running Informix OnLine 5.03 (ancient, I know) and I continually have page cleaners to go into (E)xit state and NEVER COME BACK! Kinda new to Informix, and I'm not sure how to figure out why this is happening. The log only has a "ERROR: page cleaner # X has timed out" message, …
re-creating .idx file
oops! i hammered an .idx file while trying to "fix" an indexing problem with one of the tables in my system. yes, i know that it says practically everywhere in the manuals not to do this, but i figured if it was hosed already, what could it hurt. so, while i sit here listening to…
Re: Oracle/Sybase/Informix/MS-SQL Server
I know I'm asking for it, but here it goes: Saying things like "NT Sucks." really doesn't say anything. NT and UNIX both have there place. NT is great for small to midsized LANs were all the clients are Windows/Win95. I know this from first hand experience. If you don't have …
Re: HELP! My Page Cleaners keep dying!!!
jbo@awips1.abrfc.noaa.gov wrote: > > Running Informix OnLine 5.03 (ancient, I know) and > I continually have page cleaners to go into (E)xit > state and NEVER COME BACK! > > Kinda new to Informix, and I'm not sure how to > figure out why this is happening. The log only > has a "…
Re: PHISICAL LOGS configuration
Im Artikel <59m9tq$6gh@cssun.mathcs.emory.edu>, mpisano@ed.gba.gov.ar ("Mauro G. Pisano") schreibt: > Here are my questions : > > 1. Is the disk space well managed ? > 2. wich is the On-line's space, is all the space or only the root >dbspace's space ? > 3.sh…
Re: SPARCstorage Array & Disksuite software
At one of my client sites we are using 4 SPARCStorage arrays and the Veritas Volume manager. So far no problems...Performance is excellent!! Partha Dutta pdutta@airmail.net rcyrus@promarkone.com wrote in article <851636452.30304@dejanews.com>... > We are looking at purchasing t…
Re: Raw space vs filesystem
I would strongly encourage the use of raw file space, if possible. This is especially true for OLTP systems. There is a performance hit in trying to work your way through the fat entries. Also, the unix io buffer cache is a mixed blessing. The engine expects all data to be ph…
Raw space vs filesystem
Hi, I wanted to find out what are the pros and cons of using raw vs regular filesystems for dbspaces. We are using Informix 7.2 and HP UX 10.01. Any comments on how to use the LVM in this context is greatly appreciated ! thanx Dinesh Comnet Int Co.…
SPARCstorage Array & Disksuite software
We are looking at purchasing these products! Anybody have any horror stories or recommendations or experiences... robin cyrus Sr. Informix DBA Promark 1 inc. Scottsdale AZ -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ …
Informix DBA Data Warehouse Project (Interim Technology)
Interim Technology, the Consulting Group, formerly Computer Power Group, is a leading provider of consulting services in the information technology industry. For nearly 30 years Interim Technology�s Consulting Group has consistently provided a full spectrum of consulting services…
OMNI REPLICATOR
Hi, Anyone knows about Omni Replicator? Does it work fine for informix- to-informix remote table replication? Any help/advice will be greatly appreciated! -------------------------------------------------------------- DANIEL CARBAJAL ZAVALETA (dcarbaja@sunat.gob.pe) Superintenden…
Informix Opportunities in Sacramento, California
I am currently looking for 3 Informix Programmer/Analysts to develop new applications using Informix On-Line on the back end. Required skills include Informix 4GL, ESQL, C, and UNIX. Experience with Informix NewERA is preferred. These positions are for…
Re: PB app, locking in Informix 5
Lana wrote: > > Hi, > I am developing a multiuser PowerBuilder 4.0.03 application with Informix > OnLine 5 as the back end database. > > In the application, one user will need to exclusively read/update a set of > rows in several tables at a time. Other users should be able to > …
Re: Upgrading from Informix 5.x to 7.x and AIX 3.x to 4.x
CSC CIS wrote: > > Hi All > > My client is planning to upgrade from AIX 3.x to 4.x and simultaneously = > from Informix 5.x to 7.x. The database is about 1GB and currently split = > across 4 disks. The system is an OLTP type of system, running on = > Informix 5.x and AIX 3.x. Cur…
Re: Oracle/Sybase/Informix/MS-SQL Server
Hi We are using both SQL Server and Informix ON-Line and both systems works fine. SQL Server is more "user friendly" and easier to operate for the dba. There are no significant difference in performance between these systems. The main reason to choose SQLServer is that it makes…
From INFORMIX 5 to 7 - where will the performance go?
For our new software, which has new features we have to change from INFORMIX ONLINE V5.0 to V7.1. If we add the INFORMIX V7.0 only, where will the performance go? What we have to do, for the same performance under 7.1 as under 5.0. I can not belive, that we have to install 7.1 o…
PB app, locking in Informix 5
Hi, I am developing a multiuser PowerBuilder 4.0.03 application with Informix OnLine 5 as the back end database. In the application, one user will need to exclusively read/update a set of rows in several tables at a time. Other users should be able to read/update the other rows …
Re: Does Informix 7.12 evaluation support locking?
Scott P. Smith <spsmith@ix.netcom.com> wrote in article <01bbf2bb$dfaec680$23ae20cc@none.ix.netcom.com>... > I'm using Intersolv's ODBC drivers for Win95 to access a table on Informix > 7.12 evaluation. The Intersolv libraries report that the database does not > support record l…
Informix Job Openings Mail List
Rather than fill this newsgroup up with Informix Job Openings. I will be happy to email them direct to your email address. My email dsitribution lists are private and your email address will not be given out to any other source. It is not a listserv so you won't get any unsubscri…
Re: 32 bit ODBC access to Informix 4.0
Hi John, there are links for other drivers but not any more for Informix. There are no files for ODBC-lite for Informix. Is this true ? cu Reiner…
Available... Visual basic, Visual C++/MFC/ODBC/DB2 PE/SP2/ORACLE PARALLEL SERVER
Following software professionals are available for immediate assignments. 1) Visual basic, C, C++ 2) Visual C++, MFC, ODBC 3)C++, C, RDBMS 4) Datawarehousing Architect 5) DataMining Architect 6) Decision Support Systems Architect 7) On-line transaction processing Architect 8) DB…
Re: Welcome to FINANCIAL INDEPENDANCE!
cog@solutions.mb.ca (CoG) wrote: pissoff... >Do you have more bills at the end of the month than you do money? >Worried about losing your current job? >Want to make more money and have more time to do the things in life that REALLY >matter? >What could you do with another $1000…
Oracle/Sybase/Informix/MS-SQL Server
billy@west.co.za ("Billy Wheeler") wrote: here, here well said. >On 23 Dec 96 at 17:09, Cynthia Merritt wrote: > >> We are going to be purchasing an RDBMS sometime in 1997. > >Well, choose a database first, and *don't* run on NT. NT Sucks. And >before everyone starts flaming m…
Does Informix 7.12 evaluation support locking?
I'm using Intersolv's ODBC drivers for Win95 to access a table on Informix 7.12 evaluation. The Intersolv libraries report that the database does not support record locking. Is this true for the eval copy, or is Intersolv's libraries in error? - Thanks. -- Scott P. Smith…
Re: Welcome to FINANCIAL INDEPENDANCE!
Perhaps there is an indication of the worthiness of this scheme in the subject line. The poster can't even *spell* 'financial independence'. cog@solutions.mb.ca (CoG) wrote: >Do you have more bills at the end of the month than you do money? >Worried about losing your current jo…
CICS and Informix TP/XA
Has anyone got information on how to get CICS 2.1 and Informix 7.2 talking to each other using TP/XA ? We had CICS 1.2 and Informix 5.03 working fine, but the IBM and Informix documentation is pretty inadequate regarding the new combination. Howard Kerr howardk@pavilion.co.uk…
Re: Welcome to FINANCIAL INDEPENDANCE!
this asshole has crossposted to 20+ newsgroups. i suggest that since he's so concerned with financial independence, he would be interested in receiving a copy of his own post. perhaps, the more times he gets a copy of this post, the more financially independent he'll get. you …
Need ODS start-up and shut-down files
Hello all, Does anyone have start-up and shut-down files for Informix ODS on SGI/Irix to share? These would normally be in /etc/rc2.d and /etc/rc.d. Thanks, Seth -- Seth Grimes Magnet Interactive Communications grimes@magnet.com 3255 Grace Street, NW grimes@access…
DBA Job Opportunities
DBA Job Opportunities Contact Jim D. Sullivan Staffing Services State Street 1776 Heritage Dr A1N No Quincy, MA. 02171 At State Street we offer a fast paced environment that challenges capabilities and inspires professional achievement. Additionally, we provide competitive sala…
Microsoft Foxpro & Visual Foxpro Accessing Informix
I am interested in knowing if Microsoft Foxpro for Windows and Visual Foxpro have the ability to access inforix databases. Also what abour these products on a Mac platform? Thanks…
$START DATABASE blocks pclose calls ??
Hello, maybe you have an idea for the following strange problem. I�m maintaining an application written with C and ESQL/C. We�re using a very old 2.1 Version of the Developement system (but it works) on PC hardware with SVR4 Unix.Everything works well. This application has to b…
Re: Welcome to FINANCIAL INDEPENDANCE!
Peter Jay Salzman wrote: > > this asshole has crossposted to 20+ newsgroups. i suggest that since > he's so concerned with financial independence, he would be interested in > receiving a copy of his own post. > > perhaps, the more times he gets a copy of this post, the more fina…
Re: CD Rom Dokumentation (a flop ?)
On Wed, 11 Dec 1996 12:25:49 +0100, Andreas Zeugswetter <andreas.zeugswetter@telecom.at> wrote: >Has anybody got the really "funny" Informix CD-Doc yet ? >I would like to hear some "funny" comments about it. >Has anybody used it yet ? I don't even want to try, since it is in an …
RE: 4gl Quesions (EASY, I hope...)
John: 1) Sorry, but you can't do it. LOAD is a 4gl statement (as opposed to an SQL statement), so you can neither prepare it nor supply char variables for tables names (etc, etc) 2) Be more specific with your error message. Who tries to access the table? Has he got any right on…
Welcome to FINANCIAL INDEPENDANCE!
Do you have more bills at the end of the month than you do money? Worried about losing your current job? Want to make more money and have more time to do the things in life that REALLY matter? What could you do with another $1000 a year? another $5000 a year? $30,000 a year? or M…
Ho! Ho! Ho!
Just a brief note to one and all: thank you for the information, interest, enthusiasm and spirited debate this year. I'd like to wish you all a very merry Chrismas and an appropriately inebriated New Year. Please take care over the festive season and let's all see each other in …
Re: Case-insensitive LIKE select - is it possible?
There is information in the FAQ about case insensitive searching, but try .... MATCHES *"[Ss][Pp][Gg][Hh][Ee][Tt][Tt][Ii]*" Peter Brueton…
Re: PHISICAL LOGS configuration
Mauro G. Pisano wrote: > > Hi: I am tryin to improve perfomance in our environment. We have On-line 5.0. > The On-line Administrator Guide recommends to define the phisical logs size > twice the logical logs size. Other rule is to define both size with a > relation 3:1 logic…
Re: [Q] Backup/Recovery suggestions needed for Informix Online DS.
Huy Vu wrote: > > Dear Informix Gurus, > > I'm new on Informix. I tried to search over FAQ from > http://www.iiug.org while hoping to find one article which can help me > to do a good backup/recovery with informix but unsuccesful. Could > somebody can give me some suggestions fo…
Re: Postings appearing to come from rmy.emory.edu
Walt Hultgren {rmy} wrote: > > In the meantime, if you see an obnoxious message that appears to be from > the rmy.emory.edu domain, it's probably an error of the type described > above. We don't allow obnoxious people on our system. :-) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^…
Re: DBACCESS parameters/environment variables
Seth Grimes wrote: > > Hello all, > > I need some help with DBACCESS on Unix. What are the command > line parameters or environment variables I can use to specify the username > and password to connect as? If none, is there a command I can put in a > file being processe…
Re: Do alarms work in 7.20 ?
ctreptow@aol.com wrote: > > Hi. I am trying to write an alarm program for Informix, but it doesn't > appear to work. We are on HP-UX 10.01 running Informix Online version > 7.20. I have written the following script, but it doesn't ever appear to > get called by Informix. Acco…
Re: Oracle/Sybase/Informix/MS-SQL Server
On 23 Dec 96 at 17:09, Cynthia Merritt wrote: > We are going to be purchasing an RDBMS sometime in 1997. Well, choose a database first, and *don't* run on NT. NT Sucks. And before everyone starts flaming me: get knotted! I don't care if Bill Gates has won the desktop war, a dat…
Case-insensitive LIKE select - is it possible?
Greetings all, I have a (simple?) problem which is causing a great deal of trouble. Is there any way to get Informix to do a case-insensitive comparison in the WHERE clause of a SELECT statement? (ie SELECT * FROM sometable WHERE detailfield LIKE %spaghetti%). I'm coding in N…
Re: Has anyone written a DB Size Estimate Calculator?
The following is an excel spreadsheet that I used in my last job. It is designed for 5.x using the size guidelines that were published in the 5.x documentation. It might be used as a starting point for this purpose. I, nor Informix can support this spreadsheet, nor can I help …
4gl Quesions (EASY, I hope...)
I have a couple of "simple" 4gl questions for the gurus out there... 1. If a user enters in a table name on a form ( into a variable called cTableName ), how can I do the following: LOAD FROM "converted.unl" INSERT INTO cTableName Informix tells me that the table cTabl…
Re: Oracle/Sybase/Informix/MS-SQL Server
I've used Informix and MS SQL, both on NT Server 4.0. I am new at RDBMS, but an old pro at Windows development. Coming from a Windows background, I found MS SQL much more comfortable and easier to install/configure. Also Informix still crashes on me when I try to use their GUI…
Re: 32 bit ODBC access to Informix 4.0
Peter Frantsen wrote: > > I have been searching for an 32 bit ODBC driver that can access an old > Informix 4.0 database but so far I have not been successful. > Does anyone know a vendor that have such a product ?. > If not, is it possible to use an version designed for ver. 5.x…
Re: Web datablade bbs
"John E. Beatty" <jbeatty@sprintmail.com> writes: >I'm looking for a canned solution for an Intranet bulletin >board application (AIX Server, Netscape clients, static, one-way >publishing; no discussion group or threads in this one..) using >the Web datablade. Any help is appre…
Re: Beginner SQL question (select statement)
On 19 Dec 1996 00:17:33 -0600, aak2@Ra.MsState.Edu (Atif Ahmad Khan) wrote: > >I have 2 tables. 1. Product 2. Warehouses. Products has the rows : >part_number, warehouse_id1, warehouse_id2, qty_available_1, qty_available_2 >values (123456, 100 , 200 , 500, …
[Q] Backup/Recovery suggestions needed for Informix Online DS.
Dear Informix Gurus, I'm new on Informix. I tried to search over FAQ from http://www.iiug.org while hoping to find one article which can help me to do a good backup/recovery with informix but unsuccesful. Could somebody can give me some suggestions for backup strategies for Inf…
Re: Microsoft SQL vs. Informix 7.12 OWS for Win NT
billy@west.co.za ("Billy Wheeler") writes: >> As I write this I still can't access Informix from a client. It only >> supports TCP access (as far as I can tell) and requires editing files >> manually on the client (the Services file). >Hm. It should, by default, set up a servi…
Re: PHISICAL LOGS configuration
The inconsistency that you are pointing out is because it's really impossible to exactly determine how much log space you really need. The determining factor is really how much your typical transaction is going to update. For performance issues, the total logical log size is no…
Web datablade bbs
I'm looking for a canned solution for an Intranet bulletin board application (AIX Server, Netscape clients, static, one-way publishing; no discussion group or threads in this one..) using the Web datablade. Any help is appreciated. John Beatty Sprint john.beatty.corpis42@igate.…
Re: PHISICAL LOGS configuration
Mauro, 1) More information is required, mainly, how many disks do you have? If you have have 1 disk, you don't have many choices regarding the layout, however 5 disks gives you far more scope. 2) If all the space has been created as Online chunks, then …
Some useful scripts
About a month ago I posted a response to a question regarding the query optimizer. The answer involved use of the UPDATE STATISTICS [HIGH|MEDIUM|LOW] commands and I mentioned a script that I had developed which performed the reommended sequence of these commands on the specified…
Oracle/Sybase/Informix/MS-SQL Server
We are going to be purchasing an RDBMS sometime in 1997. Can anyone direct me to a good place to find out the differences between these systems? Glad to listen to any opinions... thanks…
Happy Holidays
Happy holidays to everyone & wishes for a great '97. If you need anything from us, or have any questions regarding web/database stuff in general, feel free to call or e-mail. Monica Berndt Trilogy Technology International email: monicab@openpath.com Check out our tech forum at …
Re: PHISICAL LOGS configuration
> 1. Is the disk space well managed ? > 2. wich is the On-line's space, is all the space or only the root > dbspace's space ? > 3.shoul I prefer few and large logical logs or many and small ones ? 1. I'm not sure what you mean. In my opinion, Informix disk…
Re: Update question
If you have 4gl: declare c_upd cursor for select colA, colB from B foreach c_upd into store_colA, store_colB update A set colB = store_colB where A.colA = store_colA end foreach If do not have 4gl, the following should work: update A set colB = (select B…
Job posting: FTE, Seattle, Washington, US
World Vision, a Christian relief organization located in Federal Way, Washington, has an immediate opening for a senior level Informix DBA. Required qualifications include a thorough knowledge of Informix products, strong communications skills, and an outstanding knowledg…
Re: ESQL/C and C++
Maas Chops wrote: > > Forgive me if this has been answered here already. Can ESQL/C be used in > C++ code? I searched the Informix manuals that I have, but found no > mention of C++. I asked an Informix trainer, and she said she thought it > could. I should think so too. Any…
Re: Informix essential Monitoring tool
Juan R. Guzman <jguzman@transre.com> wrote: > rcyrus@promarkone.com wrote: > > > > We have over 15 Informix 5.03 instances and it is very hard to > > administrate them. Does anybody know of any shareware or home grown tools > > to check for Dbspace/chunk/online(up,down)/Long Txn/…
Re: Printing TOP OF PAGE character
print "\\^L" or print ascii(12) will work Mariusz Malogrosz Performance Analyst TECSYS Inc. "Hanno Pet" <HPet@svb.nl> wrote in article <59bh3i$qc3@cssun.mathcs.emory.edu>... > Hello, > > I try to print ^L in a the output section of a report as a formfeed > command. > When compi…
Re: help: Shared memory init error
Do you have mirroring turned on. 7.1.2 and 7.1.3 does not allow ontape restores when mirroring is turned on due to a bug.…
AIX4.1.4,Inf7.12(LWPRO), NS Ent2.01
After succesfully install: Enterprise 2.01, Informix7.12(LWPRO) and livewire. I've found a previously referenced problem: I can't connect to Informix from appmgr-dbadmin: "Unable to open libLWinf.so", In an article from netscape KB they say about putting environ LIBPATH, but afte…
Re: Can't Remove Update Lock
Alireza Assadzadeh wrote: > > Hello, > > We are in the process of designing/implementing a concurrent multiuser > databse system using Informix. > > I have gone through the Informix manuals but it seems that it is > not possible to allow one user to remove an update lock set on r…
Re: Question on Disk Arrays ???
Would you run the EMC Symmetrix as mirrored or EMC's RAIS-S? RAID-S requires more cache than mirrored but one gets 75% effective disk capacity rather than 50%. Nabil Courdy wrote: > > Can anyone offer me pros and cons on: > > A Symmetrix 3500 system (EMC) with 2 GB cache…
PHISICAL LOGS configuration
Hi: I am tryin to improve perfomance in our environment. We have On-line 5.0. The On-line Administrator Guide recommends to define the phisical logs size twice the logical logs size. Other rule is to define both size with a relation 3:1 logical logs vs phisical logs. If I follow…
Beginner Informix Question
I have inherited a Unix based Informix DataBase Server Version 4.10. I know it's really old but that's life. There is a nightly process that runs against the database which almost ramdomly produces a -408 error (Problem with library file communicating with the database.) I runnin…
Re: Informix 7.13 on HP 10.01
Steven Hansen wrote: > > Hello > > I'm setting up Informix 7.13 on a HP box running HP-UX 10.01. I have a > 'learning environment' set up using 'cooked' disk space. I want to use raw > disk access in my production environment. I'm wondering if anyone has any > experience with r…
Re: Beginner SQL question (select statement)
If you intend to do serious work with ORACLE (or any RDBMS, for that matter), I strongly recommend that you learn data modelling principles, especially data normalization. Your Products table is not even in First Normal Form (1NF) when it should have been in 3NF. In 3NF, the Prod…
Re: ESQL/C and C++
Jason Jonas wrote: > > Maas Chops wrote: > > > > Forgive me if this has been answered here already. Can ESQL/C be used in > > C++ code? I searched the Informix manuals that I have, but found no > > mention of C++. I asked an Informix trainer, and she said she thought it > > co…
Re: ESQL/C and C++
Maas Chops wrote: > > Forgive me if this has been answered here already. Can ESQL/C be used in > C++ code? I searched the Informix manuals that I have, but found no > mention of C++. I asked an Informix trainer, and she said she thought it > could. I should think so too. Any…
Re: understanding On-Line's Optimizer
Steve Romankiw wrote: > > I am new the Informix On-Line engine. I am looking for information on > On-Line v7.13 Cost Based Optimizer. We are migrating to Informix from > SQLBase and the optimizers work differently. In informix, we often get > sequential scans on queries that w…
Re: Opinions on NewEra
Salaam Yitbarek wrote: > > Hi, > We are considering NewEra 3.0 for developing a front-end > to statistical data. From what I have heard, the good > things about NewEra are the object-oriented 4GL, > GUI code generation (unlike VB, but like Delphi), data-aware > objects, and, …
Re: Problem with SQL TODAY
Chaiw Kok Kee wrote: > > I wonder if anybody can help me. I'm running ESQL-C on a client access > Informix On-Line 5.07 on another Unix Server. The following SQL, whether in > ESQL-C or DBACCESS returns yesterday instead of the system date. > > $select inv_date > …
Re: NewEra and Crystal Reports
Software Development wrote: > > NewEra Users, > > I want to use Crystal reports and launch from within NewEra. I have the > following questions: > > 1. Can you get a class library, similar to ixReport for ViewPoint Pro, > that can be used to launch a Crystal Reports report from w…
Re: help: Shared memory init error
In article <32BBFB3F.4109@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >My experience is that Online ALWAYS hangs in fast recovery mode after a >cold restore. You must use onmode -m to start it. If you don't, and >you stop the instance with onmode -ky, you can't s…
Re: NewEra Newbie - Problem using SuperTable Apply Buttons
Bill Bounds wrote: > > I've been playing around with NewEra for a couple of days and was > trying to make use of the built in Supertable buttons for Query, > Delete, etc and have run into a problem when using the Apply or Apply > All buttons. > > When trying to do an insert of a …
Re: User Limitation?
In 5.x the number of users was inforced within the software. I'm unaware of any code in 7.1x which is inforcing this. True we removed the number of configured users, but that was because we started dynamically allocating the user table in the virtural shared memory segment, inst…
Third party application with Informix 7.X as backend
Anyone in here implement an Application called "BAAN" on Informix in here? What kind of things were involved?…
Re: BUFFERS setting
In article <32BACDF0.3467@informix.com>, Dave Kosenko <davek@informix.com> writes >Bill Ennis wrote: >> >> You need to consider that you will be reading from the buffers as well >> as writing to them. >> >> I would be careful lowering since your read cache percentage is already >…
ESQL/C and C++
Forgive me if this has been answered here already. Can ESQL/C be used in C++ code? I searched the Informix manuals that I have, but found no mention of C++. I asked an Informix trainer, and she said she thought it could. I should think so too. Anyone know for sure? Thanks v…
Any comments on Forte use with Informix?
Has anyone used (or is using) Forte to develop applications for Informix? From reading their web site it seems like a good tool so we are planning to order one copy to try it. My concern is whether it will take advantage of Informix features and not just create generic code that …
Question on Disk Arrays ???
Can anyone offer me pros and cons on: A Symmetrix 3500 system (EMC) with 2 GB cache controllers OR A Digital Enterprise Storage Array (STORAGEWORKS), controllers here go up to 128 MB cache The system will be used for very large databases. I have completed my benchmarks …
US-DC #K24 Big Six Firm Needs Database Architects Oracle, Sybase, Informix 6-12 years Experience 70-100K, Sign On, Yearly
US-DC #K24 Big Six Firm Needs Database Architects Oracle, Sybase, Informix 6-12 years Experience 70-100K, Sign On, Yearly ID: #K24 Please include the above information line in your reply in some manner. DB Architects Sybase Oracle Informix Telecom Industry - Work Currently in …
Re: SEARH commercial access to databases
David Sherman wrote: > I wants to get finance information for money (approximately Lexis-Nexis and etc.) > Define the term "financial databases with commericasl access" better, > please. > > nikita@telekom.ru wrote: > > >I'm want find financial datebases with only commercial acc…
Re: Incompetence!
I don't know exactly what the problem you encountered is since you did not describe the error code that you received. However, I'm going to take a guess that you might have run out of space in the dbspace that the temporary table was being created in. Try creating a dbspace for…
Re: Informix 7.13 on HP 10.01
If you want to only use a part of the raw device, then size the chunk so that it doesn't use the entire device. The engine will not write outside the defined limits of the chunk, either on the front end (offset) of the back end (size). Madison Pruet…
Re: Microsoft SQL vs. Informix 7.12 OWS for Win NT
In article <01bbeedc$35ec1220$beae20cc@none.ix.netcom.com>, "Scott P. Smith" <spsmith@ix.netcom.com> writes >I've been evaluating MS SQL and Informix 7.12 recently and have >observations I thought I'd share. > >MS SQL installed with 0 problems. I was able to create a database an…
Re: avoiding huge globals files
In article <851093474.19834@dejanews.com>, frantz@centrum.is writes >I don't quite follow why it is better to put each cursor name in a separate >module. Is it realistic to be so concerned about the module size? I would have I had simplified the example, I there are lots of fu…
Re: SEARH commercial access to databases
Define the term "financial databases with commericasl access" better, please. nikita@telekom.ru wrote: >I'm want find financial datebases with only commercial access. >Please help me, I can't find it!!! >My chief want pay for informations from financial datebases. >If you know …
Can't Remove Update Lock
Hello, We are in the process of designing/implementing a concurrent multiuser databse system using Informix. I have gone through the Informix manuals but it seems that it is not possible to allow one user to remove an update lock set on row by another user. The first would lose…
Re: I-connect
On 21 Dec 96 at 16:25, zorin wrote: > I have loaded I-connect for W95/NT. I am wondering if this is a 16 bit or > 32 bit drivers. I am thinking that it is 32 since they call setnet32.exe to > set everything up. But I have a vendor telling me that it is a 16 bit > drivers. An…
Re: I-connect
On 21 Dec 96 at 16:25, zorin wrote: > I have loaded I-connect for W95/NT. I am wondering if this is a 16 bit or > 32 bit drivers. I am thinking that it is 32 since they call setnet32.exe to > set everything up. But I have a vendor telling me that it is a 16 bit > drivers. An…
I-connect
I have loaded I-connect for W95/NT. I am wondering if this is a 16 bit or 32 bit drivers. I am thinking that it is 32 since they call setnet32.exe to set everything up. But I have a vendor telling me that it is a 16 bit drivers. Anyone know what is going on? Thanks…