Threads from 1997
Informix 3.30.14 Conversion
I have a client using UNIX Informix 3.30.14 on Altos UNIX, and we just "tar"ed it over to a SCO box running Rel 5. When I type dbmenu, I get "memory fault - core dumped". Will this version run on the new box? If not, what are my upgrade options? TIA -- e-mail: bstew…
4gl TEXT variable insert
Does anyone know how to: a.) Assign a TEXT variable a value not from the database...I can't use the LET statement. or b.) Insert a CHAR variable type into a TEXT column. I've tried using LET v_notes = icgi_getvalue("WWW_NOTES") and it returns a -4323 error. It won'…
informix and oracle
hi all: I am a newbie to database servers. my company needs to decide between informix or oracle server, could some one give me a list of pro and cons of informix vs oracle? Thanks a bunch. please email to yan@wwisp.com yan…
Re: Point/Pitch sizes when printing from Informix
On Tue, 30 Dec 1997 mikeh@bitsnpcs.co.uk wrote: > Firstly I do not know Informix at all. > > We have a client that wants to buy a laser printer to replace their line > printer. Seems reasonable. > They want to be able to print small (8 point), and their ask what laser > printer…
Re: Secrets to Quitting Smoking Easy http://www.quitsmokingforever.com
In article <34a95e84.0@208.212.139.3>, QUIT SMOKING NOW <dcmqez@qqqq.com> wrote: >Quit Smoking Now with LifeSign >http://www.quitsmokingforever.com For those who want to voice their displeasure with this spam, they provide a handy toll-free number: (888) 557-7249…
Re: Year 2000 compliant 4gl code
On Wed, 31 Dec 1997 Kate_Tomchik@homedepot.com wrote: > Is it true that the Year 2000 compliant version of 4gl code for the > version 7.X Informix environments (i.e. the one that will use the > DBCENTURY value) is 6.10, Yes. > and that this is STILL NOT AVAILABLE for HP 10.20 o…
Re: DBCENTURY Still gives wrong date
On Tue, 30 Dec 1997, R. Kirk Waterhouse wrote: > I saw something like this on the Informix TechInfo web site. Please can you quote me a URL which will allow me to get it fixed. > It said that the date 02/29/2000 returned an invalid date error code even > with the DBCENTURY set…
Q: "onstat -g ppf" output
Could someone please explain the first column in the "onstat -g ppf" output? The partnum does NOT correspond to anything that I can find either in my user defined database or in sysmaster. I have checked sysmaster:syschunks, sysmaster:systabnames, sysmaster:systables, <userdb>:s…
Re: fragmentation and sqexplain
Siebe, Sorry if this has been answered already, but I missed the original posting apparently. The 'fragments: 0' vs. 'fragments: 1' only means that in the first query, the data will be found in the first fragment (no. 0) and in number 1 in the second. A quick scan of the data …
Data Warehouse Skills Needed in Atlanta and Virginia
>We have a client company who needs candidates with RDBMS/Data Warehouse skills for positions in Northern Virginia (Greater DC area), and Atlanta, GA. Requirements: 2+ years experience and excellent communications skills are required. Company has stock options, and pays relo…
a simple wish
hi all, WISH YOU ALL A VERY HAPPY, PROSPEROUS AND A GRRREEAT NEW YEAR 1998. Vj…
Management change for informix-list
Some months ago I announced that informix-list will be moving to the IIUG home system, iiug.org. The move didn't happen as soon as I had anticipated, but work has progressed well and things are about ready for the actual move. One of the reasons that we have not gone ahead with…
Re: DBCENTURY Still gives wrong date
You have it wrong, there is no leap year for years evenly divided by 100 UNLESS they are evenly divided by 400, which 2000 is. YEAR 2000 IS A LEAP YEAR!! Please respond to rkirkwNo_Spam@mindspring.com To: informix-list @ rmy.emory.edu cc: (bcc: Kate Tomchik/IS/SSC/THD) Su…
Year 2000 compliant 4gl code
Is it true that the Year 2000 compliant version of 4gl code for the version 7.X Informix environments ( i.e. the one that will use the DBCENTURY value) is 6.10, and that this is STILL NOT AVAILABLE for HP 10.20 operating systems? Please let me know that this isn't true, we have …
Re: Secrets to Quitting Smoking Easy
Mike Segel wrote: > > QUIT SMOKING NOW wrote: > > > Quit Smoking NO COLD TURKEY GRADUAL & PAIN LESS > > NO DRUGS - SAFE & NATURAL > > [SNIP] > > Wow! I guess Informix has been smoking all those TPC/C benchmarks far too long! > I never realized that high performance RDBMS were haz…
Re: Secrets to Quitting Smoking Easy http://www.quitsmokingforever.com
QUIT SMOKING NOW wrote: > Quit Smoking NO COLD TURKEY GRADUAL & PAIN LESS > NO DRUGS - SAFE & NATURAL [SNIP] Wow! I guess Informix has been smoking all those TPC/C benchmarks far too long! I never realized that high performance RDBMS were hazardous to your health. No wonder I …
Re: Good User Guides for Informix Online DS 7.23 and NewEra
Billy Wheeler screamed as he came crashing out of the jungle like a wounded wildabeast: > On 31 Dec 97 at 0:53, Mike Segel wrote: > > } Here's a tip. > } Don't use New Era. (Damn I'm gonna catch flack for that one. :-) > > Nothing wrong with NewEra. > Ahh, but I disagree. Here'…
Re: Printing BLOB image via Crystal Reports or others?
Dennis Pimple wrote: > > I have a BLOB column in the database that is an image file (.jpg or > .bmp) that I maintain via NewEra interface. Does anyone have any > experience/sample code that shows me what I need to do to get the image > to print as part of a report? > > I have no …
Re: Ontape 7.10 - Alpha box - Can Not Restore
As I understand it, the only stable Informix/DEC combination (before OSF 4) is 7.20.UC4 with OSF 3.2e; when I was contracted to a DEC site, a couple of Informix support engineers said that there were a few DEC OS bugs prior to 3.2e that caused the Informix software a lot of probl…
Re: DBCENTURY Still gives wrong date
Oh GOD, not again. Where's Sam Leffler when you need him!!! :-D } From: "R. Kirk Waterhouse" <rkirkw@mindspring.com> } Subject: Re: DBCENTURY Still gives wrong date } Date: Tue, 30 Dec 1997 23:17:02 -0500 } Reply-to: "R. Kirk Waterhouse" <rkirkwNo_…
RE: When and when not to create SP/triggers
Beg pardon. I meant to say at most one SP _per_ trigger. I can also see the benefit of modularizing stored procedures, but it can make debugging a bit more difficult, so there's something of a trade-off there. } ---------- } From: Felix Koshy Mathews[SMTP:fmathews@systems.DHL…
Re: Extremely slow connect process and setnet32 processing
Well it's not the long filenames.. INFORMIXSQLHOSTS means something different on Win32 and Unix on Unix: a path to the file containing the sqlhosts on Win32: a name of an NT-Computer whose registry contains the Sqlhost ( in HKEY_LOCAL_MACHINE\\Software\\Informix\\Sqlhost) so you …
Re: Printing BLOB image via Crystal Reports or others?
4gl? No, the closest to that I got to was putting PCL or ESC/P blobs in reports, and of course, the jpg/bmp to pcl is the tough bit. :-) But since you are talking about Crystal Reports, the following might be a worthy alternative: Do you have a Apache (or other suitable HTTP se…
Re: FW: Informix 4gl question
In article <19971230072500.CAA15407@ladder02.news.aol.com>, Razer99 <razer99@aol.com> writes >>} Okay My question, can the above scene/job be simulated in a 4gl >>} front-end, i.e. thru 4gl screen If I press Ctrl-C, the program > >Check out the command OPTIONS SQL INTERRUPT…
RE: Ontape 7.10 - Alpha box - Can Not Restore
We use DEC too (ODS 7.23 and 7.24) and we already had problems using = ontape and onarchive. For security reasons, we do a dbexport every night = after the ontape.( I can't even back-up using onarchive...) and I = suggest you continue doing your unload.(Remember how problematic …
Re: Informix for Linux Initiative
You two guys haven't left much for me to say, have you? :-) However, if Kent wants to give a shot at running Informix product under iBCS emulation, careful examination of my sig might be of help :-) Ciao, Marco ____________________________________________________________________…
Dallas Strategic Consulting
StratCon, Inc. has requirements for the following skills: Informix Oracle Client/Server Developers Networking NT/Unix C/C++ Jam (Prolifics) open VMS If you are interested in a contract or full time position please send your resume and salary requirements to: resume@St…
Re: Good User Guides for Informix Online DS 7.23 and NewEra
On 31 Dec 97 at 0:53, Mike Segel wrote: } Here's a tip. } Don't use New Era. (Damn I'm gonna catch flack for that one. :-) Nothing wrong with NewEra. } BUT, if this is not an option, } do the following: } } 1) Place all of your business logic in C functions. (It makes them } p…
Re: Online comes with update statistics
Dilip Allam/MSI/SEEPZ wrote: > > Hi there, > > I am running Informix Online Dynamic Server 7.1 on a SunOS 5.5.1, the > problem I am facing is that the Informix Online system comes down > (database is shutdown) when I perform the folowing Update statistics - > > update statistics …
Re: Extremely slow connect process and setnet32 processing
On 30 Dec 97 at 17:10, Jerry Flood wrote: } I've answered my own question and thought that others may run into } the same problem. When I configured my client to access the 7.2 } server, I set INFORMIXSQLHOSTS variable to a file name on my pc } (C:\\informix\\etc\\sqlhosts). I s…
Re: Good User Guides for Informix Online DS 7.23 and NewEra 3.0
Here's a tip. Don't use New Era. (Damn I'm gonna catch flack for that one. :-) BUT, if this is not an option, do the following: 1) Place all of your business logic in C functions. (It makes them portable.) You should be creating functional layers as much as possible. 2) Do not…
Re: Informix for Linux Initiative
Hi Kent, Tim and I are a couple of the insane individuals who are trying to strongarm informix into doing a port. (Lower case I is intentional. IFMX is too close to 4 to deserve an upper case I :-) Yet I digress. Please feel free to contact me at Mikey (at) Segel (dot) Com and I…
Re: DBCENTURY Still gives wrong date
I saw something like this on the Informix TechInfo web site. It said that the date 02/29/2000 returned an invalid date error code even with the DBCENTURY set properly. This is the correct response from the engine since leap years do not occur in years that are evenly divisible by…
Re: Informix for Linux Initiative
Kent, McNall wrote: > > Our company is a long-time Informix developer. We are extremely interested > in the initiative to get Informix engines and tools ported to Linux. I have > spoken with Informix executives (including Mr. Finocchio) and representatives > on this subject. > …
Ontape 7.10 - Alpha box - Can Not Restore
We have problem on restoring data from tape (using ontape -s L0) ..... once we have a restore test and work fine .... later when we had a power failure and want to restore the data (ontape -r) and none of our 5 set back-up can be restored ... Media corrupted msg. (all the tape ha…
Re: When and when not to create SP/triggers
Thomas J. Girsch wrote: > <snip> > there should be at most one SP called. > <snip> Hi-Thomas, I won't agree with that "at most one SP for every trigger", when you implement business rules using triggers & SPs, you could avoid duplication of common logic by designing/coding …
Informix DBA and P/A's needed
Hi, I have 2 positions in the San Francisco Bay Area which require strong Informix skills. The first is located in the East Bay and is a 3 month assignment for an Informix DBA. The consultant will be working alone trying to enhance/tune and existing database used to support a …
Re: Informix for Linux Initiative
Our company is a long-time Informix developer. We are extremely interested in the initiative to get Informix engines and tools ported to Linux. I have spoken with Informix executives (including Mr. Finocchio) and representatives on this subject. I would greatly appreciate any …
Sales engineer needed, Midwest USA
My organization is looking for a system engineer / analyst to aid in the sales cycle for a large software tools company. Roughly forty percent travel, based in Midwest. Good personal and written communication skills VERY helpful. The ideal candidate would live somewhere in the …
Sales engineer needed, Midwest USA
My organization is looking for a system engineer / analyst to aid in the sales cycle for a large software tools company. Roughly forty percent travel, based in Midwest. Good personal and written communication skills VERY helpful. The ideal candidate would live somewhere in the …
Enabling NLS in informix
We are using Informix Ver 5.0 (server and ESQL/C) on Solaris 2.x and Sun OS 4.x running on a Sun workstation. The informix database on the server is accessed by multiple clients. We are looking into internationalizing our product for support of languages besides English. For this…
Re: De-fragmenting tables. Some questions
Download my "dbreorg" program from the IIUG archives. It generates all the SQL code needed to unload, drop, create, & load data. It also rebuilds constraints, views, triggers, etc. DAS -- David Snyder @ Snide Computer Services - Folcroft, PA EMAIL: (h) dave@snide.com (w) sn…
Re: Extremely slow connect process and setnet32 processing
I've answered my own question and thought that others may run into the same problem. When I configured my client to access the 7.2 server, I set INFORMIXSQLHOSTS variable to a file name on my pc (C:\\informix\\etc\\sqlhosts). I suspect that Informix doesn't expect such a long fil…
Re: Extremely slow connect process and setnet32 processing
Thanks for the responses. It did turn out that I had an invalid DNS server as the first in my list. I removed it and now it only takes 15-20 seconds to start up setnet32. I used LAN analyzer software to figure out that Informix is first trying to resolve a host name 'informix' an…
Informix users - are they NT users?
Hello, We run Informix ODS7.23 on NT4.0 and this may seem like a simple question but: Does Informix get its "users" from NT's users database? And it's passwords? It would seem so, but the volumes of documentation never really come out and say it. This would be case as opposed…
WebDatablade & Javascript: strange behaviour
Hi everybody: I just want to report a strange behaviour with the Webdatablade mixed with Javascript: If we have a portion of code like this: Webdatablade code mixed with Javascript: i.e. test if a given value exists and output as a table column, then test if it is a mail addres…
Re: De-fragmenting tables. Some questions
Dave Otto wrote in message <68b897$p8p$1@uxas10.themoneystore.com>... >Note that if there are any dependencies (FKs, Multi-table views, >etc.) you will need to drop these also and re-declare them. Be warned, however, that dropping and re-adding keys (foreign keys especially) wil…
Re: De-fragmenting tables. Some questions
This is what I use; set indexes,constraints on table_name disabled; alter fragment on table table_name init in dbspace_name; set indexes, constraints on table_name enabled; I usually move it to a different dbspace when i do this, but I recall that = it does work when being writt…
Re: When and when not to create SP/triggers
> I think stored procedures are ok but triggers NO! How do you debug > code where an insert,update or delete does not just run but can also > run other code which is not obvious from looking at the source code > to the original program? > I would disagree with that. Triggers…
Re: De-fragmenting tables. Some questions
This is a multi-part message in MIME format. --------------EBDAD2FB2963F407A1C5580D Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Volker: I think that if you have referential constraints created on the table, droping it will cause that all of them w…
Sales engineer needed, Midwest USA
Organization: InterAccess, Co. - Chicagoland's Full Service Internet Provider Reply-To: whizbang@interaccess.com Summary: Keywords: My organization is looking for a system engineer / analyst to aid in the sales cycle for a large software tools company. Roughly forty percent tra…
Detecting LONGTX SQL??
Is it possible at all to detect a NewEra application that does LongTX? Because all I have information is the online message log which has the tx-id and userid. I've asked Informix about it and they prompt me to look at onlog. I could even have onlog to run _at_ the time long tra…
Re: When and when not to create SP/triggers
In article <19971230.13184939@ff>, Volker Fraenkle <VFraenkle@earthling.net> writes >You can only reduce network traffic, when you have a client/server >application. But if application and database server are running on the >same machine, this is no effect. > >You should use trig…
Re: creating stored procedures using ISQL
Hey Guys, If you are interested in doing alot with stored procedures I really recommend using Informix Relational Object Manager. It is used in an NT/Win 95 environment and will use ODBC to connect to the database. It is a graphical Database Manager Environment, you can work in…
Printing BLOB image via Crystal Reports or others?
I have a BLOB column in the database that is an image file (.jpg or .bmp) that I maintain via NewEra interface. Does anyone have any experience/sample code that shows me what I need to do to get the image to print as part of a report? I have no experience with Crystal Reports or…
RE: How to change DBID
What version of SAP are you using? I had to do a similar procedure, and I used the unsupported DBCopy method. I believe the method you chose is also unsupported, you can check OSS note # 89698. The problems you have is that since there is a PRD on the network, you cannot bring…
Year 2000 discussion group
For those who have an interest in the year 2000 - please feel free to subscribe to our new e-mail discussion group. The focus is on software compliance and we welcome everyone's 2 cents worth. Reply to admin@millenniumwatch.com with join in the subject box. Hope to hear from y…
ESQL/C-All Routines
Hi All, Do we have any ESQL/C-All routines like dbadd, dbalias, dbbegin, dbcommit, etc. running on INFORMIX-Online 7.10.UC2. Please help me to find out. Thanks a million. -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ …
Re: Utility to Pull a Single Table off an Archive Tape
Peter Tashkoff (TashkoP@kiwi.co.nz) wrote: : Hi Renata : Jake is right. there is such a utility, called arcunload, and written by = : the redoubtable June Tong. : the URL is as under; : http://www.iiug.org/software/special_software/special_software_top.html : It is a beta relea…
Re: How to change DBID
If you are talking about the NAME of the database, then yes. dbaccess sysmaster - rename database tst prd; [CRTL-C to exit] Dave Otto Sr.. Database Administrator TMS, Mortgage Division Richard Moldovan wrote in message <34A91730.2ED419FB@mmsi.com>... >I have trans…
Re: De-fragmenting tables. Some questions
Typically, it is substantially faster to do this entirely within Informix. create table tmp_t1..... (^ unindexed ) insert into tmp_t1 select * from t1; rename table tmp_t1 t1; create index/procedure/etc. Depending on you table fragmentation and temp DBsp…
Re: OpenIngres API
Steven Belbin (steven.belbin@consyst-sql.com) wrote: : GODS <gods@sky.net> wrote in article <34A20002.50F0@sky.net>... : > Has anyone done any Visual C++ / OpenIngres API examples besides what : > comes with the demo cd? : > : Yes (by the way some of their examples do not even co…
How to change DBID
I have transfered an Informix 7.21 database from one to another (SAP on Solaris) system using an ontape archive. The problem I now have is the new system expect the DBID to be one thing ('prd') and the 'old' systems DBID was 'tst'. When SAP tries to connect to the system using …
Re: Sample SQL needed for DateDiff(minutes, Date1, date2)
A simple stored procedure should do the trick: create procedure minutediff (dt1 datetime year to fraction,dt2 datetime year to fraction) returning interval minute(9) to minute; return (dt2-dt1); end procedure; Note that the values passed to dt1 and dt2 can be any datetime o…
Re: Sample SQL needed for DateDiff(minutes, Date1, date2)
define m as interval minute to minute m=datetime1 - datetime2 Holp helps Ken. scummings@idesign.com wrote in message <883424476.1040515073@dejanews.com>... >For example, if datetime1 = 1/1/1997 11:10:05 and datetime2 = 1/1/1997 >12:30:45 then the result I'm looking for is 80 m…
Re: RE:Row Locking
Yes, this is good idea to reduce lockes, but it also raise another problem, that in case an application is terminated unexpectedly before it reset the record to 'none', the record is never released. :) If this is the only choose, we may need an additional field to record the dat…
Re: De-fragmenting tables. Some questions
The easiest way to defragment a table is: - unload table to disk - drop table - create table - load table from disk - create indexes If you do not drop the table, then the reserved pages of your table=20 will not be freed. You can not build a table in a special chunk. You…
Re: When and when not to create SP/triggers
You can only reduce network traffic, when you have a client/server=20 application. But if application and database server are running on the=20= same machine, this is no effect. You should use triggers, to manipulate data depending on other data=20 manipulation (e. g. updating …
Point/Pitch sizes when printing from Informix
Firstly I do not know Informix at all. We have a client that wants to buy a laser printer to replace their line printer. They want to be able to print small (8 point), and their ask what laser printer will do. We believe anything will do, and all that would be required is a pr…
Re: Assert Failure and onstat
"Juan R. Guzman" <jguzman@remove_this_transre.com> wrote: >I know there is a problem with onstat -z on 7.11uc1, because once tech >support told me to do it and then my engine crashed. Then he apologized >because he had forgotten about a bug with the onstat -z. Again this is …
I-CLI error with SQLPrepare
Hi! I have Informix Online server 7.22 with Informix-CLI on unix (AIX) When I try to use SQLPREPARE function whith my C program , I-CLI return an error 61 : [INTERSOLV][ODBC 20101 driver] [0] Too many or too few host variables given But I think all parameters are OK Any help…
R: Extremely slow connect process and setnet32 processing
---------- > Da: Jerry Flood <jflood@qsun.ho.att.com> > Newsgroup: comp.databases.informix > Oggetto: Extremely slow connect process and setnet32 processing > Data: luned� 29 dicembre 1997 15.37 > > I had I-CLI 2.5 working fine on an NT 4.0 client to an Informix > 5 server. I con…
Good User Guides for Informix Online DS 7.23 and NewEra 3.0
It's the first time we're using Informix Online DS 7.23 and NewEra Vers. 3.0. Can anyone give us some tips about good books for Developers (if possible in German) Many thanks Dirk Schuette eMail: IPV-Varel@T-Online.de…
Re: FW: Informix 4gl question
>} Okay My question, can the above scene/job be simulated in a 4gl >} front-end, i.e. thru 4gl screen If I press Ctrl-C, the program Check out the command OPTIONS SQL INTERRUPT If you have version 4.x or above look at the manuals: Informix4GL supplement(approx page S-29) o…
Re: Corrupt sysindexes.
Be warned - I'm under the influence of influenza and the associated medication! On 29 Dec 97 at 19:48, Mike South wrote: > I have a database that was rarely used but recently when I tried to > access it, it owuld immediatetly crash the server on connecteing. > > The problem tur…
Re: Utility to Pull a Single Table off an Archive Tape
Hi Renata Jake is right. there is such a utility, called arcunload, and written by = the redoubtable June Tong. the URL is as under; http://www.iiug.org/software/special_software/special_software_top.html It is a beta release. i have tried it and it worked. rgds Peter Tashkof…
Sales engineer needed for Midwest
My organization is looking for a system engineer / analyst to aid in the sales cycle for a large software tools company. Roughly forty percent travel, based in Midwest. Good personal and written communication skills VERY helpful. The ideal candidate would live somewhere in the …
use Active Server Pages to access Informix On-Line 5.x Database, Error=-406
I want to use Active Server Pages to query data from Informix. I Install Informix On-Line 5.x on IBM RS6000, AIX version 4.2 IIS on Microsoft NT 4.0 with SP3 When I create ServerObject in ASP to connecto to Informix Database, It shows the following error code: Microsoft OLE DB P…
Utility to Pull a Single Table off an Archive Tape
Hi there.. I am new to this group....my colleague Jake has mentioned a utility in the IIUG archive that can extract a table from an archive tape. He has been unable to find a reference to this utility in the IIUG newsgroup itself. Can anyone post or email me the complete URL for…
RDO problem with IUS
I'm using RDO to access the Informix Universal Server DB. Every time I try to edit record in a resultset I get an error at the 'update' statement. The error message says "Optional feature not implemented". I have checked the permissions settings in NT and there is nothing wrong…
Re: Assertion Failure dump file
In article <689i3e$4lk$1@sparky.wolfe.net>, SteveS <ssilva@prestongates.com> writes >Has anyone had any experience using the dump file created with an assertion >failure? I would like to understand what happens during such a failure and >how I can pinpoint what is causing the fa…
Re: Utility to Pull a Single Table off an Archive Tape
In article <34A8667D.E7BBD808@garpac.com>, Renata Bergman <renata@garpac.com> writes >Hi there.. I am new to this group....my colleague Jake has mentioned a >utility in the IIUG >archive that can extract a table from an archive tape. He has been >unable to find a reference to thi…
Re: FW: Informix 4gl question
In article <6899ui$ce8@cssun.mathcs.emory.edu>, "Kirpane, Ravindra" <KirpanRM@Maritz.com> writes >} Let me start with a background. >} Scenario : I've a form called xyz.per generated on table xyz. >} I run this form using sperform. press 'Query' and 'Escape'. >} …
Re: Corrupt sysindexes.
In article <34a7fd24.1225524408@news.mindspring.com>, Mike South <msouth@mindspring.com> writes > > >I have a database that was rarely used but recently when I tried to >access it, it owuld immediatetly crash the server on connecteing. > >The problem turned out to be a corrupt in…
Assertion Failure dump file
Has anyone had any experience using the dump file created with an assertion failure? I would like to understand what happens during such a failure and how I can pinpoint what is causing the failure. I believe you can use onstat -g ses with the dump file (something like shmem.1…
Error 451 Locator Buffer Size too small?????
Hello, I'm a novice Informix user and I'm using the Online Server that ships with Netscape Enterprise Server 3.0 (LiveWire). When I try to unload a table that contains blobs, I get an ERROR 415 locator buffer size too small. Does anybody have a solution to this one?? I've che…
Error 451 help (during unload)
Hello, I'm a novice Informix user and I'm using the Online Server that ships with Netscape Enterprise Server 3.0 (LiveWire). When I try to unload a table that contains blobs, I get an ERROR 415 locator buffer size too small. Does anybody have a solution to this one?? I've che…
RE: [?]Date validation ...
Max (pyz@panix.com) wrote: > Greetings, > > I'm working on a Unix shell script which calls an isql $DBNAME routine. > The script prompts the user for several input variables, among those a > date. > > Would anyone have recommendations on how to do date validation (as in > possib…
Error 451 help (during unload)
Hello, I'm a novice Informix user and I'm using the Online Server that ships with Netscape Enterprise Server 3.0 (LiveWire). When I try to unload a table that contains blobs, I get an ERROR 415 locator buffer size too small. Does anybody have a solution to this one?? I've che…
FW: Informix 4gl question
} Let me start with a background. } Scenario : I've a form called xyz.per generated on table xyz. } I run this form using sperform. press 'Query' and 'Escape'. } - To my horror I realize, it's going to retrieve 100000 rows. So } I decide to press Ctrl-C and smartly en…
Inexplicable -710 error with RS6000, OnLine 5.05, 4GL 4.14
Greetings, all. We have a site using an IBM RS6000 and OnLine vers. 5.05 and 4GL vers. 4.14. A FEW of our programs are OCCASIONALLY getting error # -710: -710 Table table-name has been dropped, altered, or renamed. After a statement has been prepared in the database server…
Re: fragmentation and sqexplain
Siebe, First of all, this is not a direct answer to your question. But if you want to search data faster using the tableschema you presented it would be better to alter the index to a clustered index. It might help, with kind regards, Vincent Schakel Siebe de Klaver schr…
Re: creating stored procedures using ISQL
Greg Laurin wrote:: > This is something that sounds to simple but I can't create a stored > procedure in ISQL > > I tried - > CREATE PROCEDURE test() > END PROCEDURE; > > and it works, OK I tried - > > CREATE PROCEDURE test(ltqty INT) > > let ltqty = ltqty / 2; -- I also t…
Sample SQL needed for DateDiff(minutes, Date1, date2)
I need to find the Informix equivalent of SQL Server's DateDiff(Minute, datetime1, datetime2) routine. Both dates will be defined as DateTime YEAR TO SECONDS and I want to know how many minutes date2 is from date1. For example, if datetime1 = 1/1/1997 11:10:05 and datetime2 = 1/…
Corrupt sysindexes.
I have a database that was rarely used but recently when I tried to access it, it owuld immediatetly crash the server on connecteing. The problem turned out to be a corrupt index on the systables table, tabname to be exact. Repairing the index would crash the server, OK I dont …
Re: log_full.sh script exits with code 139
I just dealt with this -- In our distribution IUS 9.12UC3 on IRIX 6.4 there is a no_log.sh script in the etc directory, replace the ALARM_PROGRAM entry with the full path to no_log.sh and that should do it. We just made that change, and we have not had a problem in 2 hours! Da…
[?]Date validation ...
Greetings, I'm working on a Unix shell script which calls an isql $DBNAME routine. The script prompts the user for several input variables, among those a date. Would anyone have recommendations on how to do date validation (as in possibly any day from now (t) going back ten day…
[?] Menu Building, porting from Informix 5 to 7
Greetings, Someone taught me a neat trick as to how to build a menu in Informix 5 using a "menu" command, syntax being: menu somesourcefile which creates a *.scr file. Is there a similar feature in Informix 7.2*? Thanks in advance! Max Pyziur pyz@panix.com…
ansi terminal emulation/termcap/mscreen
Background: I support/develop an Informix application (SE 4.10 on SCO System V). Input arrays are used extensively to return multiple search results to the user. To end the input array F5 selects a row and ESC cancels the selection. I use SCO's mscreen to provide multiple termin…
RE:Row Locking
This may be kind of late, as I caught this on Deja News. We had a problem like you are talking about on a 3-tiered system using Informix as the back end. Concurrency is about 800 - 1000 users. We implemented a pseudo-locking scheme where an additional column was added to the tab…
Re: OpenIngres API
GODS <gods@sky.net> wrote in article <34A20002.50F0@sky.net>... > Has anyone done any Visual C++ / OpenIngres API examples besides what > comes with the demo cd? > Yes (by the way some of their examples do not even compile correctly !!!). The OpenIngres API is handful (as most …
DBCENTURY Still gives wrong date
Hello A while back there was a news message about a date that was not handled properly by INFORMIX even when DBCENTURY was set up correctly. I believe it was a leap year and it was definitely in or after the year 2000. I've misplaced the orignal post and need to supply the dat…
US - GA - Informix 4GL Software Engineers (Contract Positions: 6 months+)
PERFORMANCE Software Services, Inc. is a consulting company DEDICATED to client-server computing and OO technology. We offer mentoring, contract services, and remote development services. We are headquartered in Melbourne, FL and are hiring consultants in the major metro areas ac…
Extremely slow connect process and setnet32 processing
I had I-CLI 2.5 working fine on an NT 4.0 client to an Informix 5 server. I configured access to a 7.2 server. I now experience extremely slow connect times as well as an extremely long delay starting up setnet32. It is apparent that, during startup of setnet32 (and probably dur…
Re: Assert Failure and onstat
I know there is a problem with onstat -z on 7.11uc1, because once tech support told me to do it and then my engine crashed. Then he apologized because he had forgotten about a bug with the onstat -z. Again this is for 7.11uc1 for sparc solaris 2.4. jneugebauer@ameritrade.com…
test
test…
Access97: No primary keys
Problem description: If we want to connect Informix tables via ODBC, MS-Access in not able to get automatically the primary keys, which are declared in the Informix database. For each table connection via ODBC and MS-Access, we have to manually declare these keys. Any ideas? En…
Re: SQL to find out temp tables created by a session
The Informix (at least for SE 4.x) temp tables are created with a few letters (which seem to be date/time dependent) followed by the process id of the sqlexec process which created it. There will be a .dat and .idx pair of files for each table. So, temp tables for process 12345…
Re: Universal Data Option. Was: Oracle NVL equivalent ?
In article <34a00d34.22205369@gate.idg.no>, Nils Myklebust <Nils.Myklebust@idg.no> writes > >What should Informix do? >Obvious: >1. Charge the same for IDS/UDO as for the regular IDS engine. We would >probably accept the lack of 7.3 features for some time. At least we >would have…
test
test…
test
test…
Re: rename database and -710 errors
In article <01bd12ed$171f0560$d10c40c2@ebert.ppp.net>, Jens Ebert <ebert@mail.ppp.net> writes >Hi, > >renaming a database using "rename database ..." works fine, >but the application gets -710 errors indicating problems with >prepared statements. Any hint what to do (we try to av…
Re: Web Application : ActiveX vs Java
Xiangkui Chen wrote: > > I think you should use Java of course. Netscape doesn't support > ActiveX yet. > and dont use BIG Applets - small ones are good enough and MUCH faster. Our first JAVA Web-Application (13 months ago) had about 600 k JAVA. Actually, we need about 30 K J…
Re: Web Application : ActiveX vs Java
Siripa Sapsirin wrote: > > Hi everyone, > > We are going to develop web application accessing Informix database. I > have to decide between ActiveX and Java. Is there any suggestion about > them? We concern about performance, maintenance and openness. > > Thank you so much, > Sir…
Informix Jobs Mail List > Last Distribution sent last week
Thanks to all those who recently subscribed to our mail list for Informix Jobs. By now you should of received our latest edition that was distributed last night . If you did not receive it please re apply through our WEB site or if you are not using a browser please send email t…
rename database and -710 errors
Hi, renaming a database using "rename database ..." works fine, but the application gets -710 errors indicating problems with prepared statements. Any hint what to do (we try to avoid doing a dbunload etc). Thank you, Jens…
Re: COUNT (*)
The Rows Retrieved heading is sent to std error so redirect this to null to remove it, e.g. add "2> /dev/null" to the end of the command. The way I do it (SCO UNIX, Informix 4.10) is to throw away std error as above and pipe the script output through "grep" to get rid of unwante…
Oops!
This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---559023410-851401618-882997870=:9134 Content-Type: TEXT/PLAIN;…
Re: TRUNCATE statement for Informix exists?
Art S. Kagel wrote: } Glen Bayliss wrote: } > } > Jean-Francois DENIS wrote: } > > } > > Hello, } > > } > > With Oracle, you can use the statement TRUNCATE that deletes logically } > > all records of a table (while the table definition and indexes remain). } > > This is much mor…
Re: De-fragmenting tables. Some questions
An even easier way is to use the "ALTER FRAGMENT ... INIT ... " to rebuild the taregt table wherever you want. For a big table I'd do it at odd hours with logging off so you don't get bit by a long transaction. Greg Thomas J. Girsch wrote: > > Expanding on Art's expansion on …
Database Recommendation Request
We are looking for a database solution to build our website around. The site will be a high traffic online city guide similar to Sidewalk or Citysearch. We use the Mac for site design so a mac database product(like Tango) would be good. Any suggestions? Anyone know what Sidewalk…
Re: Informix Marketing
Michael Segel <Mikey@NOSPAM.KingOfMydomain.NOSPAM.Segel.com> wrote: : Informix bit the bitter pill when they bought Illustra. (Of course there was : Wingz too, but that was before most of you : *young* pups time.) [Now I know I'm gonna catch flack for that because I'm : only 31 …
name needed
I have an address for a home and would like to find out the name of the person. Where could I find that on the internet? (pennsylvania). Thanks so much!…
Assert Failure and onstat
Has anyone using Informix 7.22 UC1 seen assert failures while running onstat -z? We have had an assert failure several times which seems to be related to the onstat -z command. Both assert failures occured while running a script which is in a 60 second loop doing an onstat -p f…
Re: onstat -g ses
Dagmar Wartenberg wrote: > > Vic Goldberg schrieb in Nachricht <3496BD2C.74BB@cornell.edu>... > >dalink@west.com wrote: > >> > > > >Also, look at PSORT_NPROCS environment variable. Controls number of > >sort threads, and can really speed things up. > > Two weeks ago I participat…
MONEY! MONEY! MONEY! Do you want some ???
How would you like to make some REAL money, fast and PERFECTLY LEGAL? If your answer is a DEFINITE yes, then read on. With just a couple of hours, and a small investment of $7.92, you, too can make a "KILLING" !! A short time ago I was surfing through the news groups, as you a…
Re: TRUNCATE statement for Informix exists?
Glen Bayliss wrote: > > Jean-Francois DENIS wrote: > > > > Hello, > > > > With Oracle, you can use the statement TRUNCATE that deletes logically > > all records of a table (while the table definition and indexes remain). > > This is much more performant than DROP/CREATE statement…
Re: root dbspace full. Question?. Informix 5.00 UC3
Gabriel Leglise wrote: > > The aplications (Dbaccess) running on Informix 5.00 > UC3. > > In one moment the root dbspace is completed very fast > and > the others programs can=B4t run. > > Ej.: tbstat -d|grep rootdbs > > Space …
Re: memory pools
bala peddi wrote: > Could Any one Please explain me the memory Pools section of > onstat -g ses 12378 > Is this the normal in informix > INFORMIX-OnLine Version 7.23.UC2 -- On-Line -- Up 13 days 18:11:16 -- > 416472 Kbytes > session #RSAM …
Re: log_full.sh script exits with code 139
Hitesh Dave wrote: > > Hi Everybody, > > We are running sun solaris 5.5.1 with Informix 7.23. > > I am seeing following messagaes in my online.log file. > > 11:26:25 Checkpoint Completed: duration was 1 seconds. > 11:27:15 Logical Log 1701 Complete. > 11:27:18 Process…
Re: Cant Schedule a dbexport on NT
Hi! > Jeff Kalchik wrote: > On 10 Dec 1997 19:55:54 GMT, ttgchicago@aol.com (Ttgchicago) wrote: > >at 00:00 "cmd /c dumpit.bat". > The `at` command syntax can be a little arcane. :-) Try at 00:00 cmd.exe /c dumpit.bat (without "" enclosure). Must work. But ^^^^^ …
Re: Web Application : ActiveX vs Java
I think you should use Java of course. Netscape doesn't support ActiveX yet. Siripa Sapsirin wrote: > > Hi everyone, > > We are going to develop web application accessing Informix database. I > have to decide between ActiveX and Java. Is there any suggestion about > them? We c…
Informix-CLI 2.50 & Informix-Net trouble
Hi! I have: 1. Informix-SE 5.01.UD3 with Informix-Net 5.01.UD3 on HP-UX 10.20 2. Informix-SE 5.00.UD2 with Informix-Star 5.00.UD4 on SCO Unix 5.0.2 3. Informix WorkGroup Server 7.12 with Informix-CLI 2.50 on Windows NT 4.0 + SP3 4. Informix WorkGroup Server 7.22 with Informix-C…
Re: COUNT (*)
The way I do it (SCO UNIX, Informix 4.10) is to pipe the script output through "grep" to get rid of unwanted lines, e.g. z=`isql c2000 -qr t 2> /dev/null | grep -v count | grep .`; echo $z notes: 1 enclosing the sql in `` will (using SCO) put the result the variable on the left…
Re: COUNT (*)
The way I do it (SCO UNIX, Informix 4.10) is to pipe the script output through "grep" to get rid of unwanted lines, e.g. [preferred commands to execute script here] | grep -v retrieved | grep . ^ ^ |remove lines |&remove blank lines |with "retrieved" Ed…
Cannot use ipload with ODS 7.23.FC4
I am running Informix 7.23.FC4 on Digital UNIX 4.0B, I=92d like to load data using =91ipload=92. When I started ipload, added a new job then = run that job. I get this message =93Connecting to onpload, please wait = =85..=94 after a few seconds I get =93Timeout error trying to co…
Re: Onmonitor does not work
In article <67ofkb$mjd$1@columbine.singnet.com.sg>, Kenneth Xu <kennethxu@hotmail.com> writes >Hi, > >I have a problem >---------------------- >When I start "onmonitor", it keep giving follow >error message. > >Program stopped at "tb4_main.4gl", line number 521. >FORMS statement …
help to conver I4GL to Visual C++
Hi All, We are planning to use VISUAL C++ as a front end tool for Informix online engine. Basiclly, we need to replace our i4gl forms and codes into visual c++. For example, how do we do before field, after field, and other validations in Visual c++. Colu…
OpenIngres API
Has anyone done any Visual C++ / OpenIngres API examples besides what comes with the demo cd?…
Re: 4GL Error 4502 = 1319
I presume you mean by "have enough processes", you are sure your not exceeding the number of processes allowed to a specific user ID. This is a system configurable thing....and possibly user Informix is the one which is exceeding this. christian.winterhager@orbit.de wrote: > O…
Re: Informix/4GL REALLY SUCKS
Michael Segel wrote: > Daniel Wright wrote: > > > Well, the documentation was WRONG!!!! > > > > Well, now you know not to read the manuals. :-) > Silly Boy, you don't actually think *we* read those things. :-) > > We just tell everyone to RTFM so that they will leave us alone so…
Re: upper case in sql
In article <67nnem$sqq@cssun.mathcs.emory.edu>, Billy Wheeler <billy@west.co.za> writes >On 23 Dec 97 at 13:51, sychae wrote: > >} I use Informix 7.1 and visual basic. >} How can I see upper case data? >} You know, Oracle has a function for it - upper!, >} I don't know exactly na…
P-code Linker and Librarian
Hi, Merry Christmas and a Happy New Year. Here is the code (gzipped tar file) for a P-code linker and Librarian. It is an older version which provides RDSLIB and RDSLINK. RDSLIB uses the system provided ar command to maintain the library (unlike the NewEra-based FGLLIB which i…
root dbspace full. Question?. Informix 5.00 UC3
The aplications (Dbaccess) running on Informix 5.00 = UC3. In one moment the root dbspace is completed very fast = and the others programs can=B4t run. Ej.: tbstat -d|grep rootdbs Space Free dbspace …
How to install ILS??
Howdy everyone! Maybe someone can help me out here as I've exhausted many other avenues all ready. I'm trying to install the International Language Supplements for Informix(9.12MC1) for Online Dynamic Server(7.23.FC4) on DEC Alpha running Digital UNIX (4.0D). Now I'm fo…
Re: Online comes with update statistics
In article <67qrkh$qda@cssun.mathcs.emory.edu>, Dilip Allam/MSI/SEEPZ <dilipa@meghdoot.mastek.com> writes >Hi there, > >I am running Informix Online Dynamic Server 7.1 on a SunOS 5.5.1, the >problem I am facing is that the Informix Online system comes down What does your online…
Re: Lock HWM -- Informix 7.24UC1
In article <67oqsq$baj@cssun.mathcs.emory.edu>, Rick Bernstein <rbernste@alarismed.com> writes >We are running Informix 7.24UC1 on AIX 4.2.1. >Is there an Informix command or sysmaster query which will >identify the high-water mark of locks held. >"onstat -k|grep total" shows cu…
Informix Newsgroup question
Sorry for the silly question but: Does anyone know why the posts from 9/4 to 12/16 are missing? Steve -- Steven L Cooper Manager, Systems Engineering --------------------------------------- The views expressed here are mine and you can't have them...unless you agree!…
Re: Java interface to IUS
gmilner@panews.press.net (Graine Milner) writes: >We have IUS 9.1 running on SunOS5.5.1 (on a Sun Ultra Enterprise 1) and are >thinking of building a Java interface onto one or more of our databases >which we would envision being accessed from Windows 95 PSs. I am new to >Java, …
Re: Clipper to Informix
Dear Maribel, Try at htttp://www.openpath.com. Trilogy Technology International have a product called OpenPath Clipper that allows what you ask. Maribel Soto wrote: > I�m looking desperately for a product, driver o middleware, that allows > Clipper aplications to access Inform…
Online comes with update statistics
Hi there, I am running Informix Online Dynamic Server 7.1 on a SunOS 5.5.1, the problem I am facing is that the Informix Online system comes down (database is shutdown) when I perform the folowing Update statistics - update statistics low for table tt041000431f_002; update sta…
Re: KAIO on AIX
:-) Just a small point, kaio only works (on AIX certainly), if you=20 point your chunks to the character device, not the block device=2E =20 Whoops=2E =20 Davin ______________________________ Reply Separator ____________________________= _____ Subjec…
Re: KAIO on AIX
In article <67p05d$hj0@cssun.mathcs.emory.edu>, davin_harvey@dsti.co.uk writes > I just can't get this to work=2E I'm running 7=2E23 and AIX 4=2E2 (bu= >t it=20 > didn't work on either 7=2E12 or 7=2E22 under AIX 4=2E1=2E5 either)=2E=20= > I've done=20 > everything in…
Re: Informix/4GL REALLY SUCKS
In article <67p3lr$lob@cssun.mathcs.emory.edu>, Jonathan Leffler <johnl@informix.com> writes >On Mon, 22 Dec 1997, Daniel Wright wrote: >} Gee....my copy of K&R (vol. I) > >I mentioned K&R; I don't think David Williams did. > >} doesn't really allude to floats or doubles being an…
Re: Informix 5.x/7.x Backup
Tony, When you do a restore from an ontape in version 7.x you are asked if you want to restore a specific dbspace or the whole instance. When you do the ontape backup it is the same as version 5 you don't have to change tapes for each dbspace. Reg…
Re: QUESTION: INFORMIX STATE IX000 in an ESQL/C PROGRAM
cbolden wrote : >Randomly I recieve and SQLSTATE of 'IX000' and doing a get >diagnostics >reports MESSAGE_TEXT having a value of 'Success'. Is this a true >statement, did the previous sql complete successfully. If not ( a >true >statement ), how or what could I use to show a r…
RE: Fail to initialize Online
Dear David, Thanks for your clue. The file /dev/null is OK with the correct device minor and major. The problem was the permission of directory /dev Initially, I did not notice the error because I TOUCHed the file instead CAT it. Anyway, the problem is solved and thanks for yo…
Re: QUESTION: INFORMIX STATE IX000 in an ESQL/C PROGRAM
cbolden wrote : >Randomly I recieve and SQLSTATE of 'IX000' and doing a get >diagnostics >reports MESSAGE_TEXT having a value of 'Success'. Is this a true >statement, did the previous sql complete successfully. If not ( a >true >statement ), how or what could I use to show a r…
Re: how to display defined row data types?
Al Wang wrote: > Hi, > > Is there any way to manage row data types, as in, show which ones have > been defined, and provide a way to drop them? Either through ISQL or > dbaccess. > > Thanks, > > Al > Al Wang > http://www.seas.upenn.edu/~alwang > remove NOSPAM to reply A ver…
Web Application : ActiveX vs Java
Hi everyone, We are going to develop web application accessing Informix database. I have to decide between ActiveX and Java. Is there any suggestion about them? We concern about performance, maintenance and openness. Thank you so much, Siripa…
Re: Informix/4GL REALLY SUCKS
Daniel Wright wrote: > Well, the documentation was WRONG!!!! > Well, now you know not to read the manuals. :-) Silly Boy, you don't actually think *we* read those things. :-) We just tell everyone to RTFM so that they will leave us alone so we can play doom/quake all day! Sor…
Animating MF COBOL/ESQL UNIX w/ Informix Online
I'm trying to animate connecting to an Informix Online DB. I've called Informix Support. They say it is possible, but isn't supported. Evidently a change to the "makerun" script for "animating" will accomplish the task. But it isn't clear to me what I need to change. Figure s…
Re: De-fragmenting tables. Some questions
Expanding on Art's expansion on David's suggestion: A quick-and-dirty way I used to use to defragment tables was to do an ALTER TABLE NEXT SIZE to set the next extent size sufficiently high, and then do ALTER INDEX <pick-an-index> TO CLUSTER. Be warned, though, that this method…
Re: start ontape -c as non-dba
You could try creating a shell script that does the ontape -c, set the owner/group of the script to informix, and turn the sticky bit for the script on. >In our company we have a group of people who are responsible for >the productivity-process of our applications, which means t…
Re: Monitoring all SQL statements
Assuming you're running OnLine 7.X, there are several ways. As one person suggested, if you can control the SQL, put a "SET EXPLAIN ON" at the beginning of the SQL and it will give you the statements run, as well as optimizer info, in a file called sqexplain.out. But if you had…
Re: Informix 5.x/7.x Backup
ON-BAR is extremely flexible. Use can specify whatever backup strategy makes sense for your situation. You may group DBSpaces in save-sets or back them up individually. One caveat; you will need to get a 3rd party backup program to manage this. We use Legato, but I understand …
Re: Informix 5.x/7.x Backup
With OnLine 7.X, as in 5.X, all dbspaces can be saved to a single tape. The added functionality that 7.X gives you is that: a) You can specify that only certain dbspaces be saved to a tape b) You can specify that only certain dbspaces are restored from tape. In general, even…
Informix 5.x/7.x Backup
We are considering many backup strategies and I was wondering if anyone has similar needs. We are running Online 5.x presently with many unique databases. Using "tbtape" saves all spaces and databases and I was told it restores all spaces and databases. This is not satisfactory…
RE: change log size
If you are only seaching and comparing and not updating, deleting, or inserting. Why are your logs growing. Do you use dirty read? If the above is true your logs should not grow at all.... Russ... }-----Original Message----- }From: Matias [SMTP:munzel@iponet.es] }Sent: Tuesday…
SQL to find out temp tables created by a session
Does anybody know of an SQL script that would give me the names, size etc of all the temp tables that a session generates ?? One of our processess is really eating up temp space and I need to weed it out. Thanks Sujata **********************************************************…
Exit code 139 given by log_full.sh
Hi Everybody, We are running sun solaris 5.5.1 with Informix 7.23. I am seeing following messagaes in my online.log file. 11:26:25 Checkpoint Completed: duration was 1 seconds. 11:27:15 Logical Log 1701 Complete. 11:27:18 Process exited with return code 139: /bin/s…
Universal Data Option. Was: Oracle NVL equivalent ?
clem@informix.com (Clem Akins) wrote: :>> Peter inquires: :>> >We currently use NVL to return a value (0) in place of a null in a :>> >select statement. Is there any equivalent in Informix? :>Clem wrote: :>> There is an exact Oracle equivalent scheduled in version 7.3, available…
Re: Informix/4GL REALLY SUCKS
On Mon, 22 Dec 1997, Daniel Wright wrote: } Gee....my copy of K&R (vol. I) I mentioned K&R; I don't think David Williams did. } doesn't really allude to floats or doubles being anything other than } standard data types. Nor does mine. And I didn't say that it did. I did obse…
Re: INFORMIX tables into ACCESS?
Helmut Leininger (Helmut.Leininger@bull.net) said: : > Hi there, : > Anyone know if it's possible to open up Informix tables with MS Access in a : > Win95 environment? : : Sure it is. Basically, what you must do is the following: : : * set up Informix for client access (sqlhos…
memory pools
Could Any one Please explain me the memory Pools section of onstat -g ses 12378 Is this the normal in informix INFORMIX-OnLine Version 7.23.UC2 -- On-Line -- Up 13 days 18:11:16 -- 416472 Kbytes session #RSAM total used id use…
Re: Informix/4GL REALLY SUCKS
On Mon, 22 Dec 1997, Daniel Wright wrote: } Well, the documentation was WRONG!!!! OK, it was wrong. I've reported it to the doc alias. I'm sorry it was wrong; I didn't know it was wrong, and neither did anyone else because we would have fixed it before publication if we had k…
Re: JDBC -Informix connection
We have used the Informix JDBC driver based on ESQL/C from Weblogic with good success. For thin client access we use the T3 (now called Tengah) server from them also. One of the apps we have deployed is a 7x24 system that has about 60 critical users... it continues to run. Goo…
Re: Informix function call with JDBC
What JDBC driver are you using? We have not had problems calling stored procedures with Weblogic's JDBC driver for Informix. How you call the stored proc depends on if it returns a param or a result set. Good luck, Dirk Fromhein df@watershed.com http://www.watershed.com Scott …
KAIO on AIX
I just can't get this to work=2E I'm running 7=2E23 and AIX 4=2E2 (bu= t it=20 didn't work on either 7=2E12 or 7=2E22 under AIX 4=2E1=2E5 either)=2E=20= I've done=20 everything in the release notes, but still no KAIO threads=2E Anyone=20 got any ideas? …
log_full.sh script exits with code 139
Hi Everybody, We are running sun solaris 5.5.1 with Informix 7.23. I am seeing following messagaes in my online.log file. 11:26:25 Checkpoint Completed: duration was 1 seconds. 11:27:15 Logical Log 1701 Complete. 11:27:18 Process exited with return code 139: /bin/s…
Q: system-rowid table
For all you Informix guru's out there: I have a table that I can find by querying sysmaster:systabnames but I can't see it from <database>:systables. The table in question is system-rowid. What is it's purpose? It has a LARGE number of extents to it and I would like to get some…
Re: files in msg/ have moved problems for coompiled ESQL/C
On Tue, 23 Dec 1997, Jon Strabala wrote: > The *.iem files used to be right under msg/ in the informix > home directory, however a minor release of ODS and/or OWS > has moved some of the files into msg/en_us/... 7.20 introduced the change. > This messes up the runtime capabili…
Re: Creating Logical logs
PRAVEEN MOHANAN wrote: > > Hi users, > > Thanks for the solution. I created a database with log, and > could load the schema of another db. I know only few things of the DBA > stuff. But can anyone please tell me > > 1.how to know how many logical logs are there & …
Re: De-fragmenting tables. Some questions
David Williams wrote: > > In article <67cdtc$2hk@cssun.mathcs.emory.edu>, sujata_soman_at_omm- > la2-infotech-001@internet.omm.com writes > > > >Hi all, > > One of our heavily accessed tables is pretty badly fragmented and I need to > >de-fragment it ( if such a word exists ).…
Re: data-modeling question
Syed wrote: > The rules are, an Employee can also be a customer, a supplier can also > be a customer, but a supplier cannot be an Employee and vice versa. The > relationship between super and sub is a ISA relationship. > The reason i use ID as a primary key is to narrow down th…
Re: Lock HWM -- Informix 7.24UC1
Hi, Run onstat -p. It displays several overflow statistics of which locks is one (see ovlock). ex. onstat -p INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 01:24:13 -- 374120 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 503528 50…
Re: 4GL Error 4502 = 1319
christian.winterhager@orbit.de wrote: > > Our customer has Online 4.1 and 4GL 4.12; if more then 10 - 12 Users > connect to the database, then this error 4502 (now 1319) comes. The > machine has SCO-Unix 3.2.4.2, 128MB Memory, and the shared memory of > OnLine is about 40MB. So w…
Re: problem with changing logging mode
Try changing your log device to /dev/null and then do ontape command to change the logging mode. -- Paul Watson WF Software Ltd. Tel: +44 1436 674729 Fax: +44 1436 678693 Email: paulw@wfsoftware.co.uk Xu Dong <kenxu@mbox3.singnet.com.sg> wrote in article <01bd0f8a$ffca6680$fd01…
Lock HWM -- Informix 7.24UC1
We are running Informix 7.24UC1 on AIX 4.2.1. Is there an Informix command or sysmaster query which will identify the high-water mark of locks held. "onstat -k|grep total" shows current locks held. But we want to determine how close we come to exceeding the limit established in …
Java interface to IUS
Hello all, We have IUS 9.1 running on SunOS5.5.1 (on a Sun Ultra Enterprise 1) and are thinking of building a Java interface onto one or more of our databases which we would envision being accessed from Windows 95 PSs. I am new to Java, and would greatly welcome some very basic …
Re: Determine free space in Informix 7 database
The space reported as *used* includes extents allocated but not filled. This script reports data similar to onstat -d, but a tad more readable. #!/bin/sh /usr/informix/bin/onstat -b |egrep 'not initialized' >/dev/null 2>&1 if [ $? -ne 0 ]; then $INFORMIXDIR/bin/dbaccess sysm…
Informix SNMP Configuration under HP OpenView
We're starting to use HP OpenView to monitor Informix. I'm currently overwhelmed with the complexity of configuring all of the expressions, data gathering thresholds and events. Does anybody know of a 3rd party package which will do this work for me? I'd even be happy …
Re[2]: INFORMIX tables into ACCESS?
I am just now playing with this using access 97. It was really simple to link to an existing informix database and pull in the definitions and also as easy to export a new table to Informix from Access. I have not looked in detail at the changes in data types that may exist as …
Determine free space in Informix 7 database
Dear all, I'm having problems determining the exact amount of free space in an Informix Database. I don't think you can really rely on the command onstat -d. Is there anyone who can help me with this? Thanks and best regards, Bart De Groeve DHL Belgium…
Onmonitor does not work
Hi, I have a problem ---------------------- When I start "onmonitor", it keep giving follow error message. Program stopped at "tb4_main.4gl", line number 521. FORMS statement error number -1150. Window is too small to display this menu. p.s. I have tried vt100 (80x24), hp(111x…
Re: files in msg/ have moved problems for coompiled ESQL/C
The *.iem files used to be right under msg/ in the informix home directory, however a minor release of ODS and/or OWS has moved some of the files into msg/en_us/... this messes up the runtime capabilities of pre-compiled ESQL/C programs. Is there and environment variable I need …
Re: start ontape -c as non-dba
Use another c program to link it. Include following lines in the c program: setuid( id_informix ); system( "ontape -c" ); where id_informix is the informix user id in your system. set mode of this c program to 4755 and owned by informix. Kenneth JoSchneidr wrote in message <19…
First time using Informix Online DS 7.23 and NewEra 3.0
It's the first time we're using Informix Online DS 7.23 and NewEra Vers. 3.0. Can anyone give us some tips about good books for Developers (if possible in German) Many thanks Dirk Schuette eMail: IPV-Varel@T-Online.de…
First Time using Informix and NewEra
It's the first time we're using Informix Online DS 7.23 and NewEra Vers. 3.0. Can anyone give us some tips about good books for Developers (if possible in German) Many thanks Dirk Schuette eMail: IPV-Varel@T-Online.de…
4GL Error 4502 = 1319
Our customer has Online 4.1 and 4GL 4.12; if more then 10 - 12 Users connect to the database, then this error 4502 (now 1319) comes. The machine has SCO-Unix 3.2.4.2, 128MB Memory, and the shared memory of OnLine is about 40MB. So we have 80MB for the rest of system. Sometimes we…