Threads from 1995
QELIB question
Help please: I am trying qeExecSQL with INSERT INTO table_name1 (field1, ...) SELECT * FROM table_name2 and have "Missing VALUES keyword" error message. What is wrong? Please, respond by e.mail Thank you, S.Vartanov…
Sperform question
I have a screen I'm trying to build with sperform, and can't figure out how to do it, so I turn to you good people for help. Table 1: Order order num customer num item 1 item 2 item 3 item 4 (*Note: normalization police, please don't shoot) Table 2: Items item num description p…
Re: Access Informix with Ms Query problem
I am also using 16bit msquery from excel 5.0c ( note that the c version ) via Intersolve 2.1 ODBC drivers to Inet 5.01 the on to Online 5.03 with no problems under windows 95. It is faster than windows 3.1 on any PC with 33Mhz 486 and 8 meg memory, I think this is mainly due to t…
Seeking BETA testers for new DBA tools
We are currently seeking beta testers for a set of tools for Informix DBA's. The tools include advanced table loaders, dbschema enhancement, html generators, archive tool, and much much more. If this sounds like something you are interested in, please check out the following we…
(no subject)
Hi, I'm trying to port my C applications to Informix 7 from Informix 5. The applications compiled without errors, but when I try to run them, I get the following errors : /lib/dld.sl: Unresolved symbol: ASF_Call (code) from $INFORMIXDIR/lib/esql/libsql.sl IOT trap (core …
bogus 710 error?
During testing, I ran into repeated 710 errors (running Online 7.10UC1 on SUN) for no apparent reason (that is, no tables are being renamed etc as 710 implies). Trying to track it down I noticed that this error can appear if my creation scripts raised any syntax errors in stored …
Re: Reading C-ISAM files
> kcj@netcom.com (Kate Juliff) writes: > > I have the file definitions of some C-ISAM files and I want to be able to > read them and to load the contents into INFORMIX SE tables. I can already > copy accross the C-ISAM files on top of the database files but this is > not sa…
DATABASE GURU -INTERNET
If anyone knows of a database expert who want to work with internal and external internet applications and would like to be part of an exciting new company with great pay and stock options, be kind enough to forward this message to them. -- Harvey Sax hsa…
Re: 1.5 TB Warehouse: Informix or DB2/MVS?
In <4c0f6p$dtd@news.informix.com> Dave Watson <dwatson@informix.com> writes: > >The new Informix parallel loader has loaded over 100GB/hr on MPP >and 30GB/hr on SMP. It does the translations of datatypes. Take a >look at a paper at www.dbintellect.com for real life experience. W…
Re: 1.5 TB Warehouse: Informix or DB2/MVS?
Peter Nolan <PNOLAN@ozemail.com.au> writes: >rharbus@rharbus (Bob Harbus) wrote: >> >> In <4b76n4$4ei@dub-news-svc-5.compuserve.com>, 100732.511@COMPUSERV.COM (Martin Kallenbach, aka Kalli) writes: >> >Hi, >> >One of my customers is planning to build a 1.5TB Warehouse containing…
Re: Client Server Connections w/INET
Mike Renda <mrenda@tribeca.ios.com> wrote: >I have been connecting to an Informix database (on a SCO >Unix server) using the INET software with the FTP TCP stack on a >Windows 3.1 workstation. >I recently converted to Windows for Workgroups 3.11 on an NT >domain and switched to…
Re: datawarehouse
Dyip95 (dyip95@aol.com) wrote: >Are there any newsgroup out there focus on Datawarehousing only ?? There is a high concentration of data warehouse discussion in comp.databases.olap. /b -- Bill Manry - Mainframe and Integration Technologies - Oracle Corporation Standard disc…
Re: 4GL Debugger ver. 4.14 bug
> I called up Informix with a problem. When I use the RUN RETURNING > statement in my 4GL code to run a unix script, it returns nulls for my > returning values. This is a known bug to Informix ( they actually said it > would core dump), their suggestion was--do not use the RETUR…
Re: 4GL Debugger ver. 4.14 bug
> I called up Informix with a problem. When I use the RUN RETURNING > statement in my 4GL code to run a unix script, it returns nulls for my > returning values. This is a known bug to Informix ( they actually said it > would core dump), their suggestion was--do not use the RETUR…
Re: 4GL Debugger ver. 4.14 bug
> I called up Informix with a problem. When I use the RUN RETURNING > statement in my 4GL code to run a unix script, it returns nulls for my > returning values. This is a known bug to Informix ( they actually said it > would core dump), their suggestion was--do not use the RETUR…
Re: Triggers in other databases
In article <4c1f84$k8r@redstone.interpath.net>, Mike Lemon <mdl@interpath.com> says: > > >Have question about the execution of trigger procedures in databases other than the >current one. > >I have an application which posts from two separate purchasing databases into a single >i…
Re: Access Informix with Ms Query problem
yes - we are using Microsoft Office 95 which is a 32 bit app. Problem is Informix is not shipping an I-NET for Win 95 at this time. They have it planned for mid-late 1st quarter 1996. They wont support you if you try to use 32 bit NT drivers on Win 95. The real issue is we hav…
Triggers in other databases
Have question about the execution of trigger procedures in databases other than the current one. I have an application which posts from two separate purchasing databases into a single inventory database. I have two triggers on the detail inventory table which simply maintain he…
Re: Licensing Question
Informix representatives recently visited our site regarding some 7.0 and New Era questions. We asked them this question and their response was: 1. Each sqlturbo process is considered one user. So, if I start 32 background processes on my HP terminal that access the database, …
Re: !!!INFORMIX 4GL PROGRAMMERS WANTED!
In article <4al9ma$2s0$1@mhafc.production.compuserve.com>, Nancy Pugliese <102677.3534@CompuServe.COM> wrote: >Innovative Information Systems, Inc. is a leading edge management >consulting firm in the Philadelphia suburbs. We are a $70 >million subsidiary of CDI COrp, which i…
US-IL-Chic Proj Mgrs, Prgms Informix
We continue to grow and are searching for experienced Informix Project Managers and Programmer Analysts to grow with our company. I am posting this in the hope that you may be able to refer a suitable candidate for one of these positions. As a leader in installation, configurat…
Re - Report Writer
We have one, send your fax number or address and I will send a brochure.…
Re: Help me,please! I am very poor student of Ukrain. If YOU have been dreaming of ... then YOU can understand me
In article <ABQnjtmaMH@krmen.nikolaev.ua>, root@krmen.nikolaev.ua says... > I'm very poor student from Ukrain ( former Republic of the USSR ). >For a long time I've been dreaming to get my own personal computer >(at least 286 make, this make still is of value at our state)…
Re: COUNT(*) with UNIQUE keyword
> adel@q8petroleum.com.kw writes: > ...deleted... > how would I count howmany cartype(S) that I have ...... (i.e. 2) > in 1 select statement...???? select count(unique cartype) from tablename Nils.Myklebust@ccmail.telemax.no NM-data, Aasesvei 71, 1300 Sandvika, Norway My …
Re: Informix Report Writer
hakins2@aol.com (HAkins2) wrote: >I am looking for a report writer to read Informix 4GL data. I am using a >SCO on PC server. Clients are connected via serial and network >connections. I am not using I-Star or I-Net. Any suggestions. E-mail >HAkins@aol.com. Thank You. You can h…
COUNT(*) with UNIQUE keyword
try SELECT cartype, count(*) FROM table GROUP BY cartype Good luck ================================================================ Terry Boyland :^{}) Proverb: Once a king always a king But once a knight is enough !…
Re: 1.5 TB Warehouse: Informix or DB2/MVS?
>> >(1) Has anyone expierience with handling 50 GB added data per day - >> >there won't be much cleansing / reformatting but the data has to be >> >loaded / moved to DB2/MVS and/or Informix? The new Informix parallel loader has loaded over 100GB/hr on MPP and 30GB/hr on SMP. It …
Re: Informix Report Writer
Look into SQR from MITI 310-424-4399 or 800-366-6484 or sqrgroup@miti.com SQR3 Workbench is a powerful language with 3GL like speed. It is a direct extension of ANSI.SQL. At the same time, the 4GL constructs of SQR3 Workbench make it so easy to use that it produces reports of …
Client Server Connections w/INET
I have been connecting to an Informix database (on a SCO Unix server) using the INET software with the FTP TCP stack on a Windows 3.1 workstation. I recently converted to Windows for Workgroups 3.11 on an NT domain and switched to Microsofts TCP stack. Now my client server conn…
Change owner
How to change owner of a table ?…
Re: Pages used per table
Russ Kahler (russell@oncontact.com) wrote: : >yes there is an easy answer. : run oncheck -pt <datbase>:<table> : this will show you complete table space info. : Russ.... : : From ellis.oncontact.com!rmy.emory.edu!informix-list-owner Mon Dec 18 10:25:44 1995 : > Date: Mon, 1…
Informix ISQL 1.10 and Linux
I am trying to port ISQL/I4GL (ver. 1.10) for SYS V to Linux (Caldera preview II) with iBCS. Is this possible?? I have created a user & groups for informix and untarred the files from my SYS V machine. What else needs to be done? Thanks in advance! -- =======================…
Recommendations for use of 2nd Machine
We recently moved our Informix platform from a Pentium-90 to a dual P-133 HP box. We're running SCO unix Open Desktop 3, BTW. I'm wondering if it is possible to use the old P-90 as a mirror for the Informix database space. Can I mirror across a network through NFS? If not, is…
Re: locking in 5.1 SE.
In article <4bgnl8$ic7@cssun.mathcs.emory.edu>, suresh@psi.ernet.in says... > >The process I have adopted for locking is : >DECLARE CURSOR FOR UPDATE; >OPEN CURSOR; >FETCH CURSOR; > >But, while I Fetch the next row, Lock on the existing row is removed. >Is there any other way to …
Re: [Q] How to trap FORMS Statement Errors?
Yagnesh (ren1999@harriet.rencorp.com) wrote: : This may be a FAQ, but I am not able to make the program execution stop : when a FORMS statement error like -1210 occurs. I tried using : "whenever any error stop", but it still reports the error message in errorlog : file and contin…
Informix and ANSI "SQL2" compliance
As a recent user of Informix Online 7.1, I'm finding several instances where Informix's implementation of SQL is at variance with my understanding of the ANSI SQL2 standard. For reference, I'm using the 3rd edition of "A Guide to THE SQL STANDARD" by Date & Darwen. An example of …
Re: TCP benchmarks
Sorry but I am just testing. mailto:rraj@msn.com http://www.wp.com/stg/ -- Resetting line and disconnecting NO CARRIER…
Informix Report Writer
I am looking for a report writer to read Informix 4GL data. I am using a SCO on PC server. Clients are connected via serial and network connections. I am not using I-Star or I-Net. Any suggestions. E-mail HAkins@aol.com. Thank You.…
Re: Access Informix with Ms Query problem
BILLKURUC wrote: > We were using MS Query to access the informix database with Intersolv > 16 bit ODBC drivers. > We upgraded to Win95 and Office95 . > When running MS Query under this environment we get access to only > 32 bit ODBC drivers. > > Any ideas on how to get MS Query g…
DBA-Informix-Tx
DBA Informix Unix Commercial experience US Citizen or Greencard Career Position Texas--No state tax To be considered---Fax resume or mail a hard copy. -- ehutch@norden1.com (419) 893-6367 [fax] Omni Search (419) 893-6334 [voice] 1310 Craig Maumee, Ohio 43537…
Informix/Career Position/N.Car
Programmer/analyst Informix Unix Commercial experience Career Position Full Benefits Relocation Assistance N. Carolina To be considered---Fax resume or mail a hard copy. -- ehutch@norden1.com (419) 893-6367 [fax] Omni Search (419) 893-6334 [voice] 1310 Craig Maumee, Ohio 4353…
New Era
I am trying to make a decision on proceeding with New Era, we seem to encounter alot of quirks and I would like to get feedback from some folks that have some experience using New Era... (strengths, weaknesses and would you choose it again?)…
Alternatives to VPPRO
I've been informed that VPPRO 2.1 will not be upgraded and there will be no more development. Any recommendations for an alternative are welcome. I am running under Windows for Workgroups 3.11, with our Informix engine running on a Sun server. Many thanks in advance.…
NYM/CT: NEED 6+ PEOPLE FOR HIGH PROFILE INFORMIX PROJECTS
KEYWORDS: HP9000, UNIX, Informix, Client Server LOCATION: NYM / CT TITLE: PA / Project Leader Large services company with many high profile Informix development projects needs to hire 6 permanent staff members. All development is client server with HP9000 UNIX servers. Must …
Access Informix with Ms Query problem
We were using MS Query to access the informix database with Intersolv 16 bit ODBC drivers. We upgraded to Win95 and Office95 . When running MS Query under this environment we get access to only 32 bit ODBC drivers. At this time, we need to access Informix with our 16 bit drivers…
Re: Stored Procedure Qn
Gururaj (gururaj@PROBLEM_WITH_INEWS_GATEWAY_FILE) wrote: : Hi Informix users, : : I am working on INFORMIX 5.03 Online version on HP-UX. : I am encountering the following problem when executing a stored : procedure from a ESQL/C program. : The stored proc is like this: : -----…
Re: 4GL and LaserJet Printers
In article <4bpght$qha@jan.et.byu.edu>, Alan Higley <alan_higley@byu.edu> wrote: >dwolt@cts.com (Dave Woltkamp) wrote: >>Good Morning! >> >>Hope everyone had a nice holiday! I have a client that has requested >>several reports that require a lot of page formatting. Things li…
Stored Procedure Qn
Hi Informix users, I am working on INFORMIX 5.03 Online version on HP-UX. I am encountering the following problem when executing a stored procedure from a ESQL/C program. The stored proc is like this: ------------------------------------------------- CREATE PROCEDURE xxx; ON …
COUNT(*) with UNIQUE keyword
Hi INFORMIX' er if I have this kind of table cartype MERC FORD MERC MERC MERC FORD select COUNT(*) = 6 select UNIQUE cartype = MERC FORD how would I count howmany cartype(S) that I have ...... (i.e. 2) in 1 select statement...???? thanks......…
Re: 1.5 TB Warehouse: Informix or DB2/MVS?
rharbus@rharbus (Bob Harbus) wrote: > > In <4b76n4$4ei@dub-news-svc-5.compuserve.com>, 100732.511@COMPUSERV.COM (Martin Kallenbach, aka Kalli) writes: > >Hi, > >One of my customers is planning to build a 1.5TB Warehouse containing > >telecommunication data. They want to keep abou…
Re: Looking for your opinion - Informix Users
I've used both Informix and Sybase. As for monitoring and maintenance tools Informix wins hands-down.…
Re: on key (CONTROL-O)
In article <4bfksm$9u3@news.informix.com> aland@informix.com (Colonel Panic) writes: From: aland@informix.com (Colonel Panic) Newsgroups: comp.databases.informix Date: 23 Dec 1995 01:09:42 GMT In article <4bcn1k$kc1@cssun.mathcs.emory.edu>, Sanjay Kumar <SOHO!dps…
connecting to informix 5.01.UC1 (?) database using odbc and ms-access
Has anyone tried connecting to an informix 5.01.UC1 (not sure if that's the exact version) from a pc (win95) using visigenic's odbc driver (or anyone else's) with ms access? If so, how well does it work and could you give me any tips on how to set up access to be able to update …
Re: Year 2000 Solutions Conference
In article <4bf8m7$82h@panix2.panix.com>, ro@panix.com says... > >In <4bet0v$ak1@grid.direct.ca> emvy@platon.com (Maarten Veerman) writes: > >>In article <uspdi-2112951633250001@uspdi.clark.net>, uspdi@clark.net says... > >>GIVE IT A FUCKING REST, ASSHOLE! > >>> The Year 2000 dat…
Re: Comparison of Client/Server Application Development Tools
The Right Reverend Colin James III wrote: > > Jay Prakash <jprakash@popd.ix.netcom.com> wrote with possible > deletions: > > | > | Strategic Focus, a market research/consulting firm based in Milpitas, California (USA) has > | conducted a detailed hands on laboratory evaluation an…
Accidental multiple posting
I am terribly sorry to have accidentally have posted the ad several times. We were not showing that it had been posted so we thought it was just being deleted. I only meant to offer an opportunity, not to cause any disturbance. Melissa Wauters Information Systems Resources…
Re: 4GL Debugger ver. 4.14 bug
In article <4bpp8i$f67@nn.fast.net>, "Chad R. Laity" <wick@pop.fast.net> writes: |> I called up Informix with a problem. When I use the RUN RETURNING |> statement in my 4GL code to run a unix script, it returns nulls for my |> returning values. |> Does anyone have a work around …
Need Informix Programmer inC
We are looking for 1-2 programmers with informix experience for fulltime positions in Salisbury, NC. We need one programmer with Informix-4GL 4.x experience, preferrably also with experience with FourGen's accounting software and CASE tools. This position would involve maintena…
INFORMIX Systems
comp.databases.informix…
INFORMIX Systems Analyst
Information Systems Resources - Job Posting Please visit our new website at http://www.isr-now.com to check all our possible job openings. Title: Systems Analyst Position: Permanent Location: San Antonio, TX Years Experience: 1+ years Information Systems Resources is a techni…
INFORMIX Systems Analyst
Information Systems Resources - Job Posting Please visit our new website at http://www.isr-now.com to check all our possible job openings. Title: Systems Analyst Position: Permanent Location: San Antonio, TX Years Experience: 1+ years Information Systems Resources is a techni…
INFORMIX Systems Analyst
Information Systems Resources - Job Posting Please visit our new website at http://www.isr-now.com to check all our possible job openings. Title: Systems Analyst Position: Permanent Location: San Antonio, TX Years Experience: 1+ years Information Systems Resources is a techni…
INFORMIX Systems Analyst
Information Systems Resources - Job Posting Please visit our new website at http://www.isr-now.com to check all our possible job openings. Title: Systems Analyst Position: Permanent Location: San Antonio, TX Years Experience: 1+ years Information Systems Resources is a techni…
INFORMIX Systems Analyst
Information Systems Resources - Job Posting Please visit our new website at http://www.isr-now.com to check all our possible job openings. Title: Systems Analyst Position: Permanent Location: San Antonio, TX Years Experience: 1+ years Information Systems Resources is a techni…
INFORMIX Systems Analyst
Information Systems Resources - Job Posting Please visit our new website at http://www.isr-now.com to check all our possible job openings. Title: Systems Analyst Position: Permanent Location: San Antonio, TX Years Experience: 1+ years Information Systems Resources is a techni…
Anyone using New Era with ODBC
We are interested in opinions from anyone who has tried New Era using ODBC Connectivity to databases, such as Informix. We have a need to use Informix database plus other "PC" databases simultaneously in a New Era program and have found New Era to NOT really be viable/usable und…
Re: Informix 7.11 Online on HP-UX 9.04 with RAID
In article <819631465snz@century.demon.co.uk> beaker@century.demon.co.uk "Simon Athelston Barber" writes: > We are going to install the following configuration and would very much > like to hear of your experiences (good, especially bad!). > > H/W: HP T500 3-Way, HP A…
INFORMIX SE 4.1
Marcos, Nao versao 4.1 nao tem esta facilidade so a partir de versao 5.00 Cumprimentos ================================================================ Terry Boyland :^{}) Proverb: Once a king always a king But once a knight is enough !…
[Q] How to trap FORMS Statement Errors?
This is not easy Do you have the Informix Debugger and RDS If so then stepping through the program until it bombs out will be one solution Any others ?? ================================================================ Terry Boyland :^{}) Proverb: Once a king always a king…
Evaluating VPPRO
I am curious about what the plusses and minuses of VPPRO. Any feedback is welcome.…
Data Warehousing conference
For Sybase folks: Sybase is helping put together the Data Access Tools shootout at the Data Warehousing Institute conference in San Francisco in January. Should be a good show. There will be a SYBASE Bof, too and ��several vertical industry data warehousing user groups are kick…
Licensing Question
We are about to buy informix version 5 and have licensing questions. What constitutes a user? At a previous employer we ran SCO and version 4.1 of informix. We had less that 30 people, but with background processes and multiple login screens, we had the Informix Shared Memory P…
Re: Comparison of Client/Server Application Development Tools
Jay Prakash <jprakash@popd.ix.netcom.com> wrote with possible deletions: | | Strategic Focus, a market research/consulting firm based in Milpitas, California (USA) has | conducted a detailed hands on laboratory evaluation and comparison of several Client/Server | application dev…
Re: Year 2000 Solutions Conference
r l reid wrote: > > Well, now it looks like that system was so well designed that it will > be operating well into the next century. And when the original designers > get together and marvel at how long it's lived, they say, "that was > real well designed. In fact, if we had to…
4GL Debugger ver. 4.14 bug
> Data Missing > > This document resulted from a POST operation and has expired from > the cache. If you wish you can repost the form data to recreate the > document by pressing the reload button. I called up Informix with a problem. When I use the RUN RETURNING statement in my …
US-Boston: rDBMS Programmer and DBA Wanted
My company is looking for an rDBMS programmer and a DBA for immediate contracts in the Boston area. Expected to be multi-year contracts. Looking for candidates with 2 or more years experience. Experience with Progress v6 desired, but will train the right candidate. Some backg…
Comparison of Client/Server Application Development Tools
Strategic Focus, a market research/consulting firm based in Milpitas, California (USA) has conducted a detailed hands on laboratory evaluation and comparison of several Client/Server application development tools. The tools evaluated so far include -- Visual Basic 4.0, Borland's …
Re: DBACCESS Impossibility?????
> > Mark, > > You're missing the mark table name in the where. Try something > > like this - > > > > update customer > > set number = 100 > > where name in > > (select mname from mark ) > > and cus_no in > > (select mcus_no from mark ) ; > > > > Hope this get…
Re: 4GL and LaserJet Printers
dwolt@cts.com (Dave Woltkamp) wrote: >Good Morning! > >Hope everyone had a nice holiday! I have a client that has requested >several reports that require a lot of page formatting. Things like >boxes, shading, proportional fonts, use of a few soft fonts, etc. > >Before I take on…
Re: DATETIME columns
Sally Woolrich (Sally@excelsis.demon.co.uk) wrote: : I would like to know how to interpret the 'syscolumns' entry for : DATETIME columns so as to be able to build the string defining their : type e.g. 'my_column DATETIME(YEAR TO SECOND) NOT NULL'. : If anyone can help it would b…
Re: Showing Written $ Amounts
Steven Jay Evans (sevans@vixa.voyager.net) wrote: : Any one know how to (Under Informix 4gl) chaanges ie. $24.50 into Twenty F four dollars and 50/100 : E-mail at sevans@vixa.voyager.net This is in the FAQ, but below is my version ==============================================…
Informix DBA/Career Position/N.Car
DBA Informix Career Position Excellent Opportunity Relocation assistance North Carolina Full Benefits To be considered---Fax resume or mail a hard copy resume. -- ehutch@norden1.com (419) 893-6367 [fax] Omni Search (419) 893-6334 [voice] 1310 Craig Maumee, Ohio 43537…
4GL and LaserJet Printers
Good Morning! Hope everyone had a nice holiday! I have a client that has requested several reports that require a lot of page formatting. Things like boxes, shading, proportional fonts, use of a few soft fonts, etc. Before I take on the task of trying to write my own, I thoug…
INFORMIX SE 4.1
I would like to know if INFORMIX SE 4.1 for Netware has stored procedures and triggers and if it runs on Netware 3.12 and 4.1. Thanks Marcos.…
client server ??
HI!! I'm korean. I'm doing informix - unix. client server programming. Could you tell me useful tips or know-how or know-where? thanks. I am twenty four years old univ. student majoring mechanical engineering.…
FL-Informix Online Administration
********************************************************************** TeamAlliance Orlando-Jacksonville (Miami) is a technical placement firm which is part of a National firm. Our focus is on contract & full time positions in Florida. *******************************************…
FL - Sr. Data Administrator Opportunity!
Sr. Data Administrator Opportunity! *Full time permanent position* RESPONSIBILITIES: ~ Full time position ~ Provide long term planning analysis & assistance to the informational needs of the organization. ~ Creation & transformation of information requirements int…
Re: OnLine 7.11 on HP K210 with 10.01
My client has just started to upgrade to K series machines, HP-UX 10.01 (?) and InformixOn-line 7.11.…
Help me,please! I am very poor student of Ukrain. If YOU have been dreaming of ... then YOU can understand me
Something You have been dreaming of. ----------------------------------------------------------------------- Hallo, Friend. Please think Your past over and I guess You would recall very moment of Your lifetime, when You was carried away by Your dream, …
Re: TRUNC Function Question
Try reassigning the variable like this: LET someint = somereal USING "<<<<<" Sean…
Re: Any way to encrypt data?
Pete, There is no native way of encrypting and decrypting character strings that I know of. You will need to write a pair of "c" functions and build these into you application (you do not say what language you are using). One function to call the crypt() with the string y…
Re: Need help on stored procedure language for 5.x ve
=========================< Original message subject >========================== Subject: [NEWS] Re: Need help on stored procedure language for 5.x ver On Dec 18, 1:11pm, praveen@qsun.ho.att.com wrote: > Subject: Need help on stored procedure language for 5.x ver > > ----- Begi…
Re: Rising to the bait
Malcolm Weallans (onlinedbc@cix.compulink.co.uk) wrote: : There has been a lot of talk on this newsgroup about the presence of : Oracle personnel making misleading claims about their software, licences, : and revenues. Might I suggest that somebody should write an editor which :…
Re: locking in 5.1 SE.
In article <4bgnl8$ic7@cssun.mathcs.emory.edu>, suresh@psi.ernet.in says... > >The process I have adopted for locking is : >DECLARE CURSOR FOR UPDATE; >OPEN CURSOR; >FETCH CURSOR; > >But, while I Fetch the next row, Lock on the existing row is removed. >Is there any other way to …
locking in 5.1 SE.
hai gurus, I am in the process of developing an application with INFORMIX SE 5.0 and ESQL/C. I am facing some problems with LOCKing. I don't want to LOCK the entire table. The process I have adopted for locking is : DECLARE CURSOR FOR UPDATE; OPEN CURSOR; FETCH CURSOR; But, w…
locking in 5.1 SE.
hai gurus, I am in the process of developing an application with INFORMIX SE 5.0 and ESQL/C. I am facing some problems with LOCKing. I don't want to LOCK the entire table. The process I have adopted for locking is : DECLARE CURSOR FOR UPDATE; OPEN CURSOR; FETCH CURSOR; But, w…
locking in 5.1 SE.
hai gurus, I am in the process of developing an application with INFORMIX SE 5.0 and ESQL/C. I am facing some problems with LOCKing. I don't want to LOCK the entire table. The process I have adopted for locking is : DECLARE CURSOR FOR UPDATE; OPEN CURSOR; FETCH CURSOR; But, w…
locking in 5.1 SE.
hai gurus, I am in the process of developing an application with INFORMIX SE 5.0 and ESQL/C. I am facing some problems with LOCKing. I don't want to LOCK the entire table. The process I have adopted for locking is : DECLARE CURSOR FOR UPDATE; OPEN CURSOR; FETCH CURSOR; But, w…
locking in 5.1 SE.
hai gurus, I am in the process of developing an application with INFORMIX SE 5.0 and ESQL/C. I am facing some problems with LOCKing. I don't want to LOCK the entire table. The process I have adopted for locking is : DECLARE CURSOR FOR UPDATE; OPEN CURSOR; FETCH CURSOR; But, w…
locking in 5.1 SE.
hai gurus, I am in the process of developing an application with INFORMIX SE 5.0 and ESQL/C. I am facing some problems with LOCKing. I don't want to LOCK the entire table. The process I have adopted for locking is : DECLARE CURSOR FOR UPDATE; OPEN CURSOR; FETCH CURSOR; But, w…
locking in 5.1 SE.
hai gurus, I am in the process of developing an application with INFORMIX SE 5.0 and ESQL/C. I am facing some problems with LOCKing. I don't want to LOCK the entire table. The process I have adopted for locking is : DECLARE CURSOR FOR UPDATE; OPEN CURSOR; FETCH CURSOR; But, w…
locking in 5.1 SE.
hai gurus, I am in the process of developing an application with INFORMIX SE 5.0 and ESQL/C. I am facing some problems with LOCKing. I don't want to LOCK the entire table. The process I have adopted for locking is : DECLARE CURSOR FOR UPDATE; OPEN CURSOR; FETCH CURSOR; But, w…
adminstration tools needed
I have used Desk Top DBA for Sybase, but did like it that much. I have used SQLProgrammer and love it, but there is no INFORMIX interface currently. I am looking for a PC platform GUI tool. Any alternatives? Buff Smith buffman@cinenet.net 818 706-0994 home office 310 280-3593 …
Re: Gateway to Progress
In article <173445@653.chatlink.com> Prosoft@sys653.chatlink.com writes: >Hello out there! I hope someone can help me with my problem. > >I'm trying to make a informix database server communicate with a >progress front end application & I'm having problems at the moment. If >anyo…
Re: Year 2000 Solutions Conference
In article <4bf8m7$82h@panix2.panix.com> ro@panix.com (r l reid) writes: >In <4bet0v$ak1@grid.direct.ca> emvy@platon.com (Maarten Veerman) writes: > >>In article <uspdi-2112951633250001@uspdi.clark.net>, uspdi@clark.net says... > >>GIVE IT A FUCKING REST, ASSHOLE! > >>> The Year …
Gateway to Progress
Hello out there! I hope someone can help me with my problem. I'm trying to make a informix database server communicate with a progress front end application & I'm having problems at the moment. If anyone out there can give me any helpful suggestion pls. do so. Thanks Prosoft…
Re: on key (CONTROL-O)
In article <4bcn1k$kc1@cssun.mathcs.emory.edu>, Sanjay Kumar <SOHO!dpsanjay@whitestone.raileurope.com> wrote: >We faced the same problem. We had to change to some other key. I had >called Informix Tech support ; I was told it was a bug. Probably not. It was originally logged as…
[Q] How to trap FORMS Statement Errors?
This may be a FAQ, but I am not able to make the program execution stop when a FORMS statement error like -1210 occurs. I tried using "whenever any error stop", but it still reports the error message in errorlog file and continues execution. Also, it does not report the line numb…
Re: Year 2000 Solutions Conference
In <4bet0v$ak1@grid.direct.ca> emvy@platon.com (Maarten Veerman) writes: >In article <uspdi-2112951633250001@uspdi.clark.net>, uspdi@clark.net says... >GIVE IT A FUCKING REST, ASSHOLE! >> The Year 2000 date problem is coming up fast, and you need a solution. >>To stay ahead of…
Re: TRUNC Function Question
I don't have source for TRUNC at hand, but I do have this old source for ROUND: /* @(#)File: round.c @(#)Version: 1.1 @(#)Last changed: 89/06/06 @(#)Purpose: I4GL: Round Informix Decimal Numbers @(#)Author: J Leffler */ /* -- Include Files…
Bah Humbug
Merry Xmas y'all. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ …
Southwest Informix User Group -- January 25th Meeting
The next meeting of the Southwest Informix Users Group (SWIG) is scheduled for January 25th at the Renaissance Hotel. The speaker for the meeting will be Phil White CEO Informix Software. For additional information contact Sandee Gilbert (310) 320-4300 or email at dgc@ix.netcom…
Re: Year 2000 Solutions Conference
In article <uspdi-2112951633250001@uspdi.clark.net>, uspdi@clark.net says... GIVE IT A FUCKING REST, ASSHOLE! > The Year 2000 date problem is coming up fast, and you need a solution. >To stay ahead of the problem you need to attend the > > 10th International Confe…
TRUNC Function Question
I've got what I hope will be a quick answer to an easy question: Does anyone have a 4GL equivalent of the TRUNC function handy? I have a client who doesn't have esql/c and doesn't know c, that needs to do truncation in his 4GL. Any help is always appreciated. Happy Holidays! T…
Re: DBACCESS Impossibility?????
Warning: It's highly unlikely that you want to do what is suggested by Nick. See below. > On 20 Dec 1995, Mark Truty wrote: > > } Is what I am trying to do impossible in DBACCESS?? No > } > } I have a file with two columns, (name, cus_no) > } > } I have a table with 50 c…
Re: shared memory resident??
Tracy Nedd writes: |> Albert, |> You must read the $INFORMIXDIR/release/ONLINE_5.X notes to see if |> the hardware you are on supports forced residency. If it does, |> then all one must do is to set the $INFORMIXDIR/etc/tbconfig |> parameter of RESIDENT to 1. Then bring…
Re: striping versus round robin
rtt writes: |> I am about to upgrade from online 5 to 7 and am sitting with a query. |> This is to be done on an HP K200 dual process unix box. |> Do I use HP's disk striping to create a raw logical volume accross |> my six disks or do I round robin my large tables across these d…
DB2 for Sun press release
SUN ANNOUNCES INDUSTRY-LEADING PRICE/PERFORMANCE RESULTS RUNNING IBM'S DB2 VERSION 2 RELATIONAL DATABASE SOLUTION MOUNTAIN VIEW, Calif. - December 21, 1995 - Sun Microsystems Computer Company (SMCC) today announced the industry's best-ever price/performance results for t…
Re: cgi_rds problems w/o esql/c
On Thu, 21 Dec 1995, Jonathan Leffler wrote: > To fix the problem, rename these files as .c files. Edit them, replacing > '$include xyz;' by '#include "xyz.h"'. Remove stray $ signs from variable > declarations. Edit the makefile lib4glcgi.mak: change the suffixes in the > ma…
Re: 1.5 TB Warehouse: Informix or DB2/MVS?
100732.511@COMPUSERV.COM (Martin Kallenbach, aka Kalli) wrote: >PLATINUM can deliver most of the components needed for a datawarehouse >project (from consulting to olap tools), but we do not have the staff >yet to provide a broad consulting support or really "drive" the >project…
Re: 1.5 TB Warehouse: Informix or DB2/MVS?
Martin, thanks for the input. I'd like to keep in touch since I'm an industry analyst trying to assess how large the data warehousing oppty really is for 1996. Sounds like to me most people designed and documented warhouses in 1995 and we should see some implementations in 1996…
Informix 7.1 cpu usage on AIX
Has anyone else experienced extremely high cpu usage when running Informix on AIX. For instance, running the TPC-C benchmarks, the cpu was pegged. I would have expected more I/O load. Is this typical? We tried dbx attaching to the informix process that was consuming the cpu cyc…
Re: 1.5 TB Warehouse: Informix or DB2/MVS?
It has been done with both products. You can either do it with Informix DSA on an open platform such as IBM SP2, Sun or HP. Or you could do it with DB2/MVS on a mainframe. The difference is probably in the system cost. Take a look at a 3TB warehouse project with Informix databas…
Re: 4gl strings
Con Woodall wrote: > > A little insight please. > > I am running on the online engine with > 4gl version 6.01.ud2. > > I have a program that prepares a statement from a lengthy > variable--char(700)-- This string is built from a serires of > logical expressions that combines two …
Looking for your opinion - Informix Users
Hi I'm in the process of selecting a database for a pilot project of a data warehouse and I'm evaluating a few companies. I'm looking for some opinions from the Informix User community on how they feel about the database, it's architecture, any short-comings/pit-falls or intere…
Informix 7.11 Online on HP-UX 9.04 with RAID
We are going to install the following configuration and would very much like to hear of your experiences (good, especially bad!). H/W: HP T500 3-Way, HP A3232A RAID with 2x10Gb RAID level 5 O/S: HP-UX 9.04 (but planning to go HP-UX 10.1) DBMS: Informix DSA Online V7.11.UC1, I-4G…
Any tuneable parameters for informix/unix
David, This is a good machine and should be giving high performance. I think before looking at the OS I would be making sure that the engine is prperly tuned first. Follow the Informix instruction manual for this and make sure that all required environment variables are set up …
Re: UNLOAD command in ESQL/C
Isn't this covered in the FAQ? If not, it should be. The UNLOAD command is not an ESQL/C command; it can neither be used as an ESQL/C statement nor can it be prepared. It is a bolt-on, fabricated command provided by ISQL, DB-Access, I4GL and NewEra. You either have to work ou…
Re: Oracle is KILLING INFORMIX...
Oracle has the best marketing and the highest listprices. Informix and Sybase have the best database in price/performance terms. > Oracle is Killing INFORMIX... > > Is it my imagination, or is Oracle winning the > marketing campaign against INFORMIX? > I see this happening in ma…
Porting ALLBASE/ESQLC Applications to INFORMIX
Hi, Is it easy to port ESQL/C programs from ALLBASE to INFORMIX? One ALLBASE ESQL/C command that I have in doubt working in INFORMIX is: EXEC SQL BULK SELECT BOXNO, PRODNO INTO :BoxNoStruct <--- Array FROM BOXDETL WHERE BOXNO = :m_BoxNo; The above state…
Re: cgi_rds problems w/o esql/c
I let you into a minuscule secret -- you don't really need ESQL/C after all, but you do have to fix the source code, file names and the makefile for the build to work without ESQL/C. As far as I can see, the files in question are: cgiprintblob.ec icgiencode.ec icgimimetype.ec…
Re: Schema comparison
I have encountered some situations where it is necessary to keep track of schema changes. Particularly during development, or where the application is DYNAMIC. i.e. the users can specify their own tables and formats. In such situations keeping track of the changes can be necess…
Re: on key (CONTROL-O)
After John's message, I checked on my system stty setttings. The discard was set to ^O. I set it to some thing else. Now I can use the control O in my application ____________ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. 226 Westchester Ave | Office : (914)…
Re: on key (CONTROL-O)
We faced the same problem. We had to change to some other key. I had called Informix Tech support ; I was told it was a bug. ____________ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. 226 Westchester Ave | Office : (914) 681 3296 White Plains, NY 10604 …
Re: on key (CONTROL-O)
Check what stty -a says. On my Sun Sparc 10 running Solaris 2.4, it says: peed 9600 baud; rows = 36; columns = 101; ypixels = 0; xpixels = 0; eucw 1:0:0:0, scrw 1:0:0:0 intr = ^c; quit = ^|; erase = ^h; kill = ^x; eof = ^d; eol = <undef>; eol2 = ^{; swtch = <undef>; start = ^q;…
on key (CONTROL-O)
Informix gurus: I am porting an application from I4gl v4 to v6.02. I was using Control-O to bring up an Options ring menu on my forms. Apparently I4gl is trapping control-o for some reason. It is not listed as a reserved control sequence in the documentation. My other on key seq…
Showing Written $ Amounts
Any one know how to (Under Informix 4gl) chaanges ie. $24.50 into Twenty F four dollars and 50/100 E-mail at sevans@vixa.voyager.net…
Re: DATA GETTING CORRUPTED
barbara@natick-amed02.army.mil wrote: : I'm new at working with Informix. We are running Informix Online For : some unknown reason every couple of days our data base seem to be : corrupted. Our hardware seems to be okay, for we don't show any kind of : error on the screen or wh…
Re: Down-grading :-) 5.05 -> 5.02
Paul Mahoney (ptm@xact.demon.co.uk) wrote: : We have a large (5G) database (Online) that we recently upgraded to version : 5.05. This version appears to have a number of serious problems (on SCO at : least). Is it safe simply to change back to the 5.02 binaries? All I can get : …
Year 2000 Solutions Conference
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * The Year 2000 date problem is coming up fast, and you need a solution. To stay ahead of the problem you need to attend the 10th International Conference on Software Maint…
cgi_rds problems w/o esql/c
I downloaded the latest versions of the Informix WWW Freeware. I followed the instructions and read the Informix CGI.FAQ. We only have the Informix-4GL/RDS and do not have esql/c. The makefile that comes with the package appears to expect esql regardless. There are 6 .ec file…
Re: Pages used per table
Bill, I should have been alittle clearer. By "tablespace info" I meant that you would get the total pages allocated for the table. But with the capital T option, Russ could then tell how many pages were allocated to data, how many were allocated for the indexes and how many…
Re: 1.5 TB Warehouse: Informix or DB2/MVS?
chasp@morgan.com (Charles Phillips) wrote: >Martin, what role is platinum playing in this implementation? Are you providing the repositiory or data migration >tools? Or is the database vendor driving the project? just curious as to how these projects are coming together. Hi …
WTB: Informix for PC Unix
Anyone have an older version of Informix for PC based Unix (or Dos)? Version 4 is fine. Looking for SQL, ESQL/C, and 4GL. Thanx!! -- Saul Rubin |*| Nynex Science & Technology 1342 East 31st Street |*| 400 Westchester Avenue - Room T-1B Brooklyn, …
US-OR-Portland -- Senior Informix 4GL Developer Needed
##################################################### SENIOR INFORMIX 4GL DEVELOPER NEEDED IMMEDIATELY ##################################################### Meridian Technology Group, Inc. is looking for heavyweight Informix 4GL Developers to work with us in the Portland, Oregon…
Re: shared memory resident??
Albert, You must read the $INFORMIXDIR/release/ONLINE_5.X notes to see if the hardware you are on supports forced residency. If it does, then all one must do is to set the $INFORMIXDIR/etc/tbconfig parameter of RESIDENT to 1. Then bring ONLINE to offline and back to o…
OpenLink ODBC for Informix?
Hi, Anybody uses Openlin ODBC form Informix? Currently I test it, but I can only logon to the server as root. Openlink support can't figure out the prolem. Any help is appreciated. yanyan@jhunix.hcf.jhu.edu…
Re: Informix-NET and Windows 95
In article <4aki91$o69@mojo.europe.dg.com>, Michael Kelly <Michael_Kelly@dge.ceo.dg.com> wrote: >I have been told by an Informix distributor that Informix-NET for Windows >has not been ported to Windows 95 and there is no guarantee that it will >be. >What options do I have if I w…
DATETIME columns
I would like to know how to interpret the 'syscolumns' entry for DATETIME columns so as to be able to build the string defining their type e.g. 'my_column DATETIME(YEAR TO SECOND) NOT NULL'. If anyone can help it would be most appreciated - I can't find it in the manuals we have…
shared memory resident??
Hi all, Anabody knows, wheter it is possible to indicate informix 5.1 on a CGI-Indy to have the shared memory resident in the ram, so it won't be swapped? Pls an answer, so I can defend Informix for a new project. ---------------------------------------------------------------…
Re: general informix wierdness
Terry Boyland (Terry@century.demon.co.uk) wrote: > Has this problem been fixed in subsequent releases of On Line ?? No idea. I've informed Informix of the resolution to this problem but I don't know if they have or will be doing anything about it. This striping problem could b…
Any tuneable parameters for informix/unix
I have recently installed informix 7.0 on a SNI/Pyramid/MIPS box. The system has 64 MB of real memory, about 180 MB of swap and is running SINIX flavor of 5.4x unix. There are only 4 informix users running a finance package developed by a third party. I have noticed some real p…
Re: Performance problems with Online 5.03.UC1
In article <4b76v9$mki@cssun.mathcs.emory.edu> m.mejia@server1.codetel.net.do "Melvin Perez Cedano" writes: > I have Informix-Online 5.05.UC1 running on UNISYS/SVR4, recently I have been > several performance problems. I have a table with 85,000 rows aprox. and all > …
Re: Pages used per table
dd (tracyn@asd.banctec.com) wrote: : Bruce, : Russ' answer is partially. If you want the index info too, then : run 'oncheck -pT <database>:<table>' : This will give you the info you require, the lowercase 't' option just : gives the tablespace info. Have fun, : : Tracy o…
Re: Using from PC without Inet?
William Wesley Gray wrote: > > Is there any way to access an Informix server from a PC without loading > Inet on the PC? Will ODBC do this? > > Thanks for any info, > > -WesODBC is using INET. Try PC-NFS (I prefer INET) Yours Johan Andersson…
PRESS: INFORMIX TO ACQUIRE ILLUSTRA INFORMATION TECHNOLOGIES
INFORMIX TO ACQUIRE ILLUSTRA INFORMATION TECHNOLOGIES Combination to Give Significant Technology Lead In Database Market MENLO PARK, Calif., (December 20, 1995) -- Informix Corporation (NASDAQ:IFMX), the leader in parallel processing database technology, today announced an agre…
Re: Using from PC without Inet?
Intersolv ODBC still needs I-NET to talk to Informix There are other "server" based ODBC drivers that bypass I-NET but must be loaded to server.....and they will give you client software also... FYI…
Anyone using I-Net for NT on Win95
We need to use I-NET under Win95 ....but Informix is not shipping that product until 1st or 2nd quarter 1996 Is anyone using I-NET for NT on the Win 95 platform if yes, does it work ? Thanks bill…
LOCAL: MIUG - Michigan Informix User Group
Michigan Informix User Group (MIUG) NOTICE OF MEETING Tuesday, January 16, 1995, 6:00 PM Kmart International Headquarters, Troy, Michigan The next Michigan Informix User Group meeting w…
Re: Help!
CREATE VIEW can be compiled -- see the code below (using a stores database). If you can't get this to work, then let me know. If you get this to work, you need to discover what is wrong with your code. I got the list of names shown below when I did 'SELECT * FROM JollyGood' on…
Re: a little help please...
In article <4b9q4h$q3r@news.informix.com>, junet@informix.com says... > >... Check your kernel parameters, >something like NLOCKS. > Actually you should look for FLCKREC. -- ------------------------------------------------------------------------- -------------- Joao Natal …
Re: Unbelievable Opportunity!!
Tell Jack I said hello. Tom Rieger…
PRESS: INFORMIX, HP and EMC DELIVER LEGACY WAREHOUSE MIGRATION
INFORMIX, HP AND EMC DELIVER A COMPREHENSIVE LEGACY WAREHOUSE MIGRATION PROGRAM Joint Solution Offers Safe, Cost-Effective Alternative to Legacy Warehouses MENLO PARK, Calif., (December 20, 1995) -- Informix Software, Inc. (NASDAQ:IFMX), Hewlett-Packard Company and EMC Corpora…
Re: Error message printing
bonk@positron.med.ge.com (Frank Bonk) wrote: > >We currently use rgetmsg to print out error messages but could use a >little help. Some error messages are printed in the form - > >" Key value for constraint (%s) is still being referenced ". > >What do I need to do to also decode …
OnLine 7.11 on HP K210 with 10.01
I'm looking for someone who's running OnLine 7.11 on an HP machine under HPUX 10.x to bounce some questions off of. Please reply via e-mail if you'ld care to assist. Thanks in advance. Carlton -- Carlton Doe "It's not *over* until I win!" -- Les Brown DBA Resources, Inc. …
4gl strings
A little insight please. I am running on the online engine with 4gl version 6.01.ud2. I have a program that prepares a statement from a lengthy variable--char(700)-- This string is built from a serires of logical expressions that combines two other variables. The first contains…
Re: Archives to disk with Online 7.1?
> > Clem Akins (cwakins@leia.alloys.rmc.com) wrote: > : See my example script at: http://www.access.diges.net/~waiug/iugnews.html. > > Could you please verify that address? I always get an error message about > a "non-existent domain". The address is: http://www.access.digex.net…
Re: Archives to disk with Online 7.1? and more...
> Clem Akins (cwakins@leia.alloys.rmc.com) wrote: > : See my example script at: http://www.access.diges.net/~waiug/iugnews.html. > > Could you please verify that address? I always get an error message about > a "non-existent domain". and > > When I try to access "www.access.dig…
Help!
Hi Everybody, I am using esql/c to build programs. I would like to know how could i use the "create view" statement into programs. I know that neither "prepare" or "$create view" can be compiled. The manuals i have does not explain nothing about it. Could somebody out ther…
Prog/Anal-Informix-Az
Programmer/Analyst Informix Unix Career Position Relocation assistance Full benefits To be considered---Fax resume or mail a hard copy. -- ehutch@norden1.com (419) 893-6367 [fax] Omni Search (419) 893-6334 [voice] 1310 Craig Maumee, Ohio 43537…
NewEra List?
Hi, Is there a mailing list for Informix NewEra? I would like to find a list focusing on NewEra. Thanks yanyan@jhunix.hcf.jhu.edu…
Re: a little help please...
Marisa A. Giardina (magiardi@hamlet.uncg.edu) wrote: : running Informix 2.10.xxx (pretty old i'm sure!) under : SCO UNIX v3.2.4 and we are getting a pretty strange message : that we never used to get before... : logon.4gl line #47 : SQL Error -211 : Can not read system catalog …
Re: DBACCESS Impossibility?????
Mark Truty (marktrut@ix.netcom.com) wrote: : Is what I am trying to do impossible in DBACCESS?? : I have a file with two columns, (name, cus_no) : I have a table with 50 columns, three of which are ( name, : cus_no,number) : I want to update the rows in the table with a number …
Re: EXPLANATION FOR TERMS - SELF REFERENCING AND CYCLIC QUERIES
See "Informix Guide to SQL: Tutorial" Chapter 3, "Composing advanced SELECT statements", Page 11, "Self Joins". -- Bobby +---------------------------------------------------------------------------+ | Informix Software Inc. 4100 Bohannon Drive, Menlo Park, California 94025 | |…
Re: makefile for esqlc source
Siva, You didn't indicate what your problem is. There are too many "ifs" to really give you a good answer. For starters, what are CC and OBJ set to? You should probably make sure that you always use esql to compile, not cc, that way required libraries are a…
Re: Help - Help on SQL
If you can live with a substitute character, the following, although it is not pretty, seems to work. I used the tilde "~" because it sorts high. select "~", colb, colc from reseq where cola is null and colb is not null and colc is not null union select colb, "~", colc from res…
INET 5.0 for Win - Over SLIP
SUBJECT - INET over SLIP/PPP ----------------------------------------------- hello all we are running inet 5.0 for windows connecting to a HP server running 7.11 online we are also using chameleon nfs 4.5 for our net software. inet works fine when using a token ring card. i c…
NYM/CT: NEED 6+ PEOPLE FOR HIGH PROFILE INFORMIX PROJECTS
KEYWORDS: HP9000, UNIX, Informix, Client Server LOCATION: NYM / CT TITLE: PA / Project Leader Large services company with many high profile Informix development projects needs to hire 6 permanent staff members. All development is client server with HP9000 UNIX servers. Must …
Re: Good Buffer Size For Tuning Informix?
Chris Jenkins (chrisj@informix.com) wrote: : The only really important factor in determining the number of buffers is : the read and write cache hit ratios reported by tbstat -p. Keep : increasing the number of buffers until these cache hit rates do not : increase when the system…
Re: DBACCESS Impossibility?????
> Mark, > You're missing the mark table name in the where. Try something > like this - > > update customer > set number = 100 > where name in > (select mname from mark ) > and cus_no in > (select mcus_no from mark ) ; > > Hope this gets the wheels turning, > …
Re: HELP! My log is gone and I can't get up
In article <DJMxpo.vo@cuug.ab.ca> kniver@cuug.ab.ca "Roy Knive" writes: > :crp: (chips@eskimo.com) wrote: > : The transaction log file that the dbms was using got wiped. > : Now when I try to open this SE 4.1 dbms the error messages: > : 224 can not open transaction log fi…
Re: Query - Two Phase Commit
Hi Suchitra, If you need Two Phase Commit implemented within the DBMS you need to use OnLine, not SE. SE does not have any built in support for distributed transactions. OnLine fully supports distributed transactions, with 2PC. Chris Jenkins Suchitra Rao wrote: > I wish to de…
Re: Performance problems with Online 5.03.UC1
In article <4b76v9$mki@cssun.mathcs.emory.edu>, m.mejia@server1.codetel.net.do� says... >I have Informix-Online 5.05.UC1 running on UNISYS/SVR4, recently I have been >several performance problems. I have a table with 85,000 rows aprox. and all >the indexes look right for me. I al…
Re: makefile for esqlc source
In article <4b6im4$6bh@hpcc48.corp.hp.com>, pwalden says... >Try this rule in your makefile: > >SUFFIXES : .ec > >ec.o : > esql -e $(CFLAGS) $< > $(CC) $(CFLAGS) -c $*.c > @-rm -f $*.c > >The makefile should then automatically handle esqlc files. The only pro…
Re: 1.5 TB Warehouse: Informix or DB2/MVS?
In <4b76n4$4ei@dub-news-svc-5.compuserve.com>, 100732.511@COMPUSERV.COM (Martin Kallenbach, aka Kalli) writes: >Hi, >One of my customers is planning to build a 1.5TB Warehouse containing >telecommunication data. They want to keep about 700 million 80 byte >record per day, summari…
Re: sessid and pid
Hi Lin, Lin-Chuan Lee wrote: > can someone explain the relation between sessid and pid ?? > tbstat -u generates (among other things) unix pid > while onstat -u gives sessid. New to V7 ... The 'pid' that tbstat -u gives is the Unix pid of the sqlturbo *process* that is the engi…
Re: Online config for I-NET PC 5.01 to Online 7.1
Hi Mark, This setup is quite straighforward. First lets make a few assumptions for the purposes of this example. Unix machine where OnLine is running has a TCP/IP hostname of 'server1' in /etc/hosts (or NIS database) TCP/IP port number to use (c.f. OnLine 5.0) is defined in /e…
Re: Good Buffer Size For Tuning Informix?
Hi Michael, The only really important factor in determining the number of buffers is the read and write cache hit ratios reported by tbstat -p. Keep increasing the number of buffers until these cache hit rates do not increase when the system is running a 'normal' workload. This …
Re: Multiple concurrent connections per client
Hi Theo, You can do exactly this with ESQL/C 6.0 and later, talking to SE or OnLine 6.0 or later. You can also do it with ESQL/C for Windows 5.01 or later. It is not possible to do this with 5.0x Unix ESQL/C. Regards, Chris Jenkins Theo Kramer wrote: > I am working with onli…
Re: Archives to disk with Online 7.1?
Clem Akins (cwakins@leia.alloys.rmc.com) wrote: : See my example script at: http://www.access.diges.net/~waiug/iugnews.html. Could you please verify that address? I always get an error message about a "non-existent domain". Regards, Richard -- +----------------------------+----…
Re: How big can a dbs be?
} }The INFORMIX-OnLine Dynamic Server 7.1 Tech Brief gives the following figures: } }Maximum size of table.........64 terabytes (64,000 gigabytes) }Maximum number of defined databases per OnLine } Dynamic Server system.......21 million. If I am allowed to have 21,000,000 datab…
Re: SE7.1 - SLOW!
Thanks for your comments, but we've discovered, that when we use our programmes with the debugger that all queries are as fast as they used to be under 4.xx/5.xx Could it be, that INFORMIX just slowed down their products(ISQL, FGLGO) and just forgot the FGLDB utility? I suspect …
Re: Market Share
jwalters@igate.iohk.com (Jay Walters) writes: >Distribution: > >That's all good and fine, but isn't the biggest relational database >vendor in the world IBM? I know not that long ago that they had the >largest market share in the RDBMS world with MVS/DB2. But then that must >h…
Immediate Informix Vacancy CA
We need an experienced Unix RDBMS person to join our Systems Support team in beautiful West L.A. We are a highly successful company, market leaders in providing legal accounting and administration solutions internationally and offer a stimulating, fast-p…
Re: DBACCESS Impossibility?????
On 20 Dec 1995, Mark Truty wrote: } Is what I am trying to do impossible in DBACCESS?? } } I have a file with two columns, (name, cus_no) } } I have a table with 50 columns, three of which are ( name, } cus_no,number) } I want to update the rows in the table with a number if the…
Re: 1.5 TB Warehouse: Informix or DB2/MVS?
Martin, what role is platinum playing in this implementation? Are you providing the repositiory or data migration tools? Or is the database vendor driving the project? just curious as to how these projects are coming together. On Tue, 19 Dec 1995 20:21:03 GMT "Martin Kallenba…
MICHIGAN Informix UNIX
Detroit area company seeks qualified professionals for Unix system administration as well as Informix programming. Lotus helpful, Marketing company that supplies BIG 3 Maybe this position sounds good for you...maybe not. If you would like to find out more details call Mike McC…
Using from PC without Inet?
Is there any way to access an Informix server from a PC without loading Inet on the PC? Will ODBC do this? Thanks for any info, -Wes…
Archives to disk with Online 7.1?
> I am archiving to /dev/null. I want to archive to disk, not tape. > How does one set the parms in onconfig (or make appropriate symbolic > links) to do this? > -- > Adrian Blakey > Big Book Inc. See my example script at: http://www.access.diges.net/~waiug/iugnews.html. Lester …
Re: Schema comparison
> I heard that there maybe a way in cron to diff schemas > every night for changes. > I am not sure if it is a shell script or something Informix has > available. It is trivial to write a shell script to perform this task: mv schema_filename old_schema_filename dbschema -d dbn…