Threads from 1994
calx.per for generator
database formonly screen { Date [f000 ] } end attributes f000 = formonly.in_date, reverse; end…
Informix Code Generator
This is a code generator I wrote for Informix 4GL back a few years ago. It is very simplified but very helpful when writing screens with a single table plus a few or with a header/detail (parent/child) screen setup. Check it out by decoding it and then enter: fglgo generate rea…
Re: Informix and Windows
What about ISQL?…
using systables in table constraint
-> I tried a constraint that references tabname -> in systables, but I get error 297. I looked in the -> sys admin manual and determined that there was no unique -> index on tabname therefore I cannot place a reference -> on the column. I tried placing the constraint on tabname…
random number generator
-> I have need in a 4GL program to aquire some random numbers. -> I have tried to use the UNIX random number generator and I am -> getting off the wall numbers in return. Does anyone out there -> have an informix random number generator that they would be -> willing to share? I…
Informix Perf Question
-> 0% - 30% cache reads and 80% - 95% cache writes. On the other servers the -> cache read and write range from the high 80% to 90+%. Is it possible that -> the applicationbs software is negatively impacting the cache %?? Well, yes, I would imagine that the application could …
C-ISAM Limits - Big Systems
-> Does anyone have some success stories they're willing to share or some well -> reasoned arguments we may use to convince this customer that our software -> can handle the load? Your help would be very much appreciated. Sjoe! I'm afraid I don't have anything useful to contrib…
[C] Oracle and Informix
-> What are the ramnifications of running an Oracle RDBMS and an -> Informix RDBMS on the same machine? Are there any perils or -> pitfalls to beware of? Presumably this will be a Unix box, yes? I can't imagine any problem, even though I've never heard (before) of someone want…
Re: Checkpoints problems
Lopez Francisco Javier (javier@patora.mrec.ar) wrote: : Hi : Process Aborted Abnormally: pid=NNNN user=NNNN us=NNNNN flags=XXXX : If you extract only unique lines (without considering the hour) you get only : 154 lines. It seems that they are retries of the same users. : In fac…
Cannot write log record
Hello, I'm having a problem with updating tables where the update affects hundreds, or thousands of rows. I got this message with this statement ( In ISQL) update cuf set title = "MS" where title in ("MRS","MRS.","Mrs") Here's the error 346: Could not update a row in the t…
Re: Connecting Informix to html
Dror Matalon (dror@dnai.com) wrote: : I'm trying to connect html forms to an Informix backend. I've seen : the gsql stuff, but it only talks about Sybase and Oracle. Doesn't : look to hard to convert it to Informix, but if someone else has : done the work I'd rather not do it ove…
Re: Informix and Windows
This product will be Informix SE 6.0 for Windows. Look for it in Feb '95 == Joe ==…
ER Tools
}We're evaluating some data modeling tools, and would really like to hear }some input about those that some of you have used or tried. }The desired features we would like to see: } * It must be Windows-based } * It must be able to generate physical schemas for the major DB's } …
PERL interpreter for HTML Forms?
Does anyone know of a interpreter for Informix to HTML? i.e. Oraperl and syperl?…
Job Opportunities
Dear Serge: Thought you might know of some people who might be qualified and interested in several Oracle related jobs we have available at Xircom. I've attached job descriptions for the available jobs. Would appreciate it if you would pass them along to potential leads/candid…
Re: Load Command Quirks in 4gl.
From Ted RephT: * * Sample code: * define file_name char(80) * define foo char(160) * let file_name = "a_file_name" * load from file_name insert into a_table * let foo = file_name, " TEST" * display foo * * results from displaying foo: * a_file_nam…
Re: Optimizing Many-Table Joins
Michael Mueller RD writes: -> ->Can anyone tell me the tactics that the query optimizer uses for ->optimizing joins, especially queries joining a large number (e.g. >4) ->of tables? What is the max number of tables allowed in a query? ->How does this compare to Sybase's handling…
Re: Informix Net for Windows NT?
Jessica Kung (jesskung@technet.sg) wrote: : Hello Informix users, : Does anyone know if there is any Informix Net for Windows NT shipped from : Informix? We have a customer who is dying to purchase the product. : The group in Asia Pacific said that there is no such plan for th…
RE: Load Command Quirks in 4gl.
On 12/29 Ted wrote: >Sample code: > define file_name char(80) > define foo char(160) > let file_name = "a_file_name" > load from file_name insert into a_table > let foo = file_name, " TEST" > display foo >results from displaying foo: >a_file_name I ha…
Data Modeling Tools
Hi folks... Another "faq" for you all: We're evaluating some data modeling tools, and would really like to hear some input about those that some of you have used or tried. The desired features we would like to see: * It must be Windows-based * It must be able to generate phy…
4GL Latin Lookup
To all you lovers of Latin. This morning I spotted an announcement of a list of latin words with definitions, word endings, and usages being loaded onto an ftp site (ukanaix.cc.ukans.edu). As I spend a fair amount of time lurking on ansax-l, which is often rife with latin phr…
Terminal Emulation Problem, Help!
I used ICE.TCP in my office, our main db is with Informix 4gl, plus Accounting all using the Fourgen's menu as main screen control. Users are using Windows 3.1 & some wfwg 3.11 mixed with Netware 3.12, all functioned well under common TCP/IP connection via 10B-T ethernet. The ICE…
Load Command Quirks in 4gl.
> > Sample code: > define file_name char(80) > define foo char(160) > let file_name = "a_file_name" > load from file_name insert into a_table > let foo = file_name, " TEST" Try: let foo = file_name CLIPPED, " TEST" > display foo > > results from…
Load Command Quirks in 4gl.
Sample code: define file_name char(80) define foo char(160) let file_name = "a_file_name" load from file_name insert into a_table let foo = file_name, " TEST" display foo results from displaying foo: a_file_name I am running 4gl version 4.10UC4 o…
Checkpoints problems
Hi A friend of mine is running informix online 5.01 ud3 in aix 3.2.5. The workstations are running inet 5.01 and q+e odbc library. At some time (generally during heavy load), users begin to complanit that they can't connect to the database server. But logged users still works…
using systables in table constraint
In my database, I have a table (foo) which has a column (footable) that stores table names. The tables listed in column footable are used as lookup tables by my application. Is there a way to place a constraint on on footable such that the table name must be a valid table? I t…
Re: Systables.npused < 0
Poul, You have discovered a bug in online. Call Informix and get an upgrade. If this is not possible, I have a script that will recalculate the npused values to the proper value. I had this same problem..... Christopher Cale…
Testing gateway
Testing Newsgroup Gateway -- Bob Smith Supreme Court of Virginia 75151.765@compuserve.com…
Optimizing Many-Table Joins
Can anyone tell me the tactics that the query optimizer uses for optimizing joins, especially queries joining a large number (e.g. >4) of tables? What is the max number of tables allowed in a query? How does this compare to Sybase's handling? Thanks! --Michael mmueller@bella…
re: Informix and Windows
Jay Aymond Asked If if Informix were going to release SE and ISQL for Windows The last time I asked Informix here in the UK they said that SE for Windows was due for release 4th 1/4 1994 so I assume it must be real soon now !. With regard to ISQL I dont have a clue but gut feelin…
DBA Survival Guide Table of Contents
Bill Zhu wrote: >Could you post (or ask the authur to post) the table of contents, so we know >if we need the book too. I wrote: > > > Hi there, > > I've been seriously contemplating buying your DBA Survival Guide, but I haven't > been able to find anyone with a copy that I coul…
random number generator
Greetings all. I have need in a 4GL program to aquire some random numbers. I have tried to use the UNIX random number generator and I am getting off the wall numbers in return. Does anyone out there have an informix random number generator that they would be willing to share? …
ODBC w/I-NET yet?
Did Informix ever make good on their promise to include an ODBC driver with I-Net? Last I checked, Informix and Intersolv were discussing including an old ODBC driver with I-Net. No recent news though. Now I have a project which depends on not having to spend $200.00 per clien…
Performance problem - Upgrade from 4.0 to 5.03 SE
The performance of the system took a nose dive after we upgraded the system from 4.00 SE to 5.03 SE. The system is configured as follow: Hardward. IBM RS6000 7013-560 512 M of memory 656 M of page space ( usually < 50% used ) A 7G RAID box. Software. AIX 3.2.…
REMINDER: Informix is coming to the Web on January 3rd
REMINDER: ********************** Informix Opening its Doors on the World Wide Web Informix is coming to your desktop. We're establishing a new on-line service on the World Wide Web opening on January 3, 1995. In the meantime, we'd like to invite you to a sneak preview of our si…
HELP - No more locks
HELP! I insert a row in tables, ON-Line return the error -134. In 'tbconfig' I have LOCKS = 2000 and in use there is 13 locks. The ovlock = 78. -------------------------------------------------------------------- Message Log File: /usr/informix/online.log 15:58:00 Lock tabl…
[Q] Sybase & Informix
Hi, I am in the process of porting C,XMotif code, running on Sybase DBMS, to Informix DBMS. Both the system are on Unix. Sybase is on Sun OS using C shell while Informix is accessed via NEC terminal & uses K shell. I am new to Informix and would appreciate any information regardi…
V5 SQL question
I've got a quick sql question having to do with expression fields. I'm sending a sql statement through ODBC to a sql server. I'm calculating age in yrs from a dob field in a table. In doing this calculation informix figures that the expression can be 30 chars wide and all i need…
Re: Loading an Informix table with data created from a mainframe extract.
Edward (Nick) Nobbe (nnob@loc.gov) wrote: : On Fri, 23 Dec 1994, L Deckard wrote: : > This question is in two parts: : As for 1): : Try creating table2 with the same structure as table1. : Load table2 with the data from your flatfile. Index key2. : Run a delete …
Re: Informix SQL/4gl Nary Tree Explosion
} } > } > As the title suggests, has anybody tackled such a beast. } > that is, given a employee table } > emp# manager_emp# other columns... } > --- ----------- } > -- } > Burzin N. Engineer |Tel. (310) 524 1800 | email: burzin@twinsun.com } } This method WILL work…
Binary explosion
After Dennis pointed it out I went and looked: Chapter 28 of the 4gl by example deals with a recursive explosion. Example code lives in $INFORMIDIR/demo/fglbe. I've tried it out, but haven't converted it to do our stuff. Will let you know which works best. j. _______________…
Informix and Windows
Does anyone know when (or if) Informix is going to release ISQL and SE for Microsoft Windows?…
ATTN MacWorld Expo '95 Attendees
ATTENTION ALL San Francisco MacWorld '95 Expo ATTENDEES Join us in San Francisco Jan. 4-7, 1995 at MacWorld Expo. EveryWare Development Corp. will be demonstrating the latest version of Butler SQL and the entire suite of Enterprise Products. Below is the schedule of pre…
Re: 4gl: need help on help
Cathy Kipp (ckipp@vth1.vth.colostate.edu) wrote: : Jean Van Loan writes: : -> : ->To any programmers working this holiday week: : -> : ->When I run my program and hit the help key for : ->a menu choice, and then hit "resume" to get out : ->of help, the text "You have reached the …
Looking for Searchable Databases
howdy, i am trying to compile a list of searchable databases and their subject matter. if you administer, maintain, or know of any database that can be accessed by people (free or commercial) via the internet or dial-in connections, i would appreciate some input. ideally, i wo…
Informix SQL/4gl Nary Tree Explosion
> > As the title suggests, has anybody tackled such a beast. > that is, given a employee table > emp# manager_emp# other columns... > --- ----------- > > For a particular emp# (node) I want to find all employees/managers > under him whether directly or indirectly (all i…
Re: Loading an Informix table with data created from a mainframe extract.
> On Fri, 23 Dec 1994, L Deckard wrote: > > This question is in two parts: > > 01) < question 01 and answer deleted> > > 02) Currently, I am manually signing on to the IBM mainframe, via ftp > > <mainframe TSO IP address>, to download the extract file to the RISC 6000 box…
Re: Informix SQL/4gl Nary Tree Explosion
burzin@twinsun.com (Burzin Engineer) writes: > As the title suggests, has anybody tackled such a beast. > that is, given a employee table > emp# manager_emp# other columns... > --- ----------- > >For a particular emp# (node) I want to find all employees/managers >under him…
DBA Survival Guide
Hi there folks, To Joe Lumbley, thanks for the table of contents! Your book sounds fabulous! I'm just wondering, to any of you that have his book, I noticed in the table of contents there isn't a specific mention of SE..Is this just buried in the rest of the book somewhere? I'…
test
This is a test. Please ignore. -- Diem-An K. Le…
test
-- Diem-An K. Le…
ESQL/C: Insert data into BYTE column from BYTE host variable
In the Informix Guide to SQL: Reference December 1991 Page 3-5 mentioned that "You can insert data into BYTE column from BYTE host variable (INFORMIX-SQL, ESQL/C)" I got the impression that we need locator structure to handle binary large objects (blobs) (TEXT, BYTE) ? Does t…
Informix NET PC 5.01 WF1 & Gupta SQL Windows
Hello all, I have a problem with I-NET PC 5.01 WF1 and Gupta Sql Windows Informix router I am using the new feature of NET-PC to translate the codepages between a UNIX host (437) and Windows (813) for localisation. The problem appears when I am trying to insert a blob. It seems t…
HELP!!! Problem about INET-PC with FTP PCTCP
I have a problem about I4GL for Windows, I-Net PC and I-Star on UNIXserver!!! Lines: 59 I use FTP PCTCP 2.3 and there are no problem with communiation from PC to UNIX (ping, login are OK). Installations of I4GL for Windows and I-Net PC were O.K. both into C:\\INFORMIX directory…
How to find the FAQ...
In article <3dfepa$5ni@panix3.panix.com>, sal@panix.com (Salvatore Denaro) wrote: > I am looking for the informix FAQ. Anyone have it? > Where can I get a copy? Can someone send it to me? > THE INFORMIX FAQ ---------------- Here's th…
Comparing Ingres and Informix
Dear sir, I need some information involving with benchmark test performance results between these two DBMS, Ingres vs. Informix. Whoever has comments , knowledge, and sources I can find directly, please do me a favor. Thank you for your generosity…
HELP!! System Lockup
I have a DECStation 5000/240. There are about 7 to 10 users logged on during the day and several cron jobs running also. The machine has 32MB of memory and 2 450MB hard drives. The OS is ULTRIX 4.3 and the database is Informix SE. We experience a situation intermittently wher…
Re: My previous SELECT integer post
I want to thank everyone who responded to my question and I want to say that the TRUNC function given by Rodney (rodney@worf.infonet.net) solved my problem WITHOUT needing a temporary table and without the use of any temporary character field. The simplified select that works is …
Informix SQL/4gl Nary Tree Explosion
As the title suggests, has anybody tackled such a beast. that is, given a employee table emp# manager_emp# other columns... --- ----------- For a particular emp# (node) I want to find all employees/managers under him whether directly or indirectly (all its children). H…
Re: 4gl: need help on help
Jean Van Loan writes: -> ->To any programmers working this holiday week: -> ->When I run my program and hit the help key for ->a menu choice, and then hit "resume" to get out ->of help, the text "You have reached the end ->of this help text...." has an unpleasantly ->long after l…
Re: Anyone have Informix running under linux?
Jeffrey Sturm (jsturm@garnet.msen.com) wrote: : Colonel Panic (aland@informix.com) wrote: : : In article <3cprie$at1$1@heifetz.msen.com> jsturm@garnet.msen.com (Jeffrey Sturm) writes: : : >Yes, I have been successful running both Informix-OnLine and SE engines, as : : >well as 4G…
4gl: need help on help
To any programmers working this holiday week: When I run my program and hit the help key for a menu choice, and then hit "resume" to get out of help, the text "You have reached the end of this help text...." has an unpleasantly long after life in the error line. According to the…
recommended esql/c style and coding standards
If anyone has any documents concerning recommended ESQL/C style and coding standards, I would appreciate your sending them to me. We are producing a standards document here, and I would appreciate any suggestions. Thanks, Patsy Hunley patsyh@summitis.com…
Re: WORDWRAP bug
Paolo, We have a wordwrap field running under 4gl 4.11.UC4 on IBM AIX that handles the control functions correctly. Good luck -- Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; cwoodall@vth1.vth.colostate.edu On Thu, 22 Dec 1994, Paolo Fantoni wrote: > It looks like the W…
Re: Systables.npused < 0
> Subject: systables.npused < 0 > ------------------------------------------------------ > > I have a problem..... If you can help, then please mail me ! > > Thanks from > -------------------------------------------------…
Re: Loading an Informix table with data created from a mainframe extract.
On Fri, 23 Dec 1994, L Deckard wrote: > This question is in two parts: > 01) I am using the Informix utility (LOAD) to load a flatfile (that was >created from the mainframe then ftpped to the UNIX box) to a table. If the key > in the flatfile does not exist in the table, I load i…
IO bad request chunk 4
27-Dec-1994 Subject: I/O bad request chunk 4, pagenum 108, pagecnt 1 --------------------------------------------------------- The 27. December is a bad day to get problems - I could not get any help from Tech. Support, so I try this n…
ODBC causing UNIX server to hang
I'm using Microsoft Access and I-NET to connect to Informix running on a SCO box. Everything was working fine until I installed the Novell conectivity for Window for Workgroups. Now in the middle of executing queries UNIX hangs and the system needs to be restarted. It's not co…
Re: I-Net
In article <3dclf0$t1n@emory.mathcs.emory.edu>, johnson@hqcso.attmail.com says: > Any more suggestions? Anyone run I-NET with MS TCP/IP? I don't have > MS TCP utilities, does this matter? This is apparently a low level > error. I am not making to the UNIX box at all. > …
Re: Q:Code generation by Informix 4GL Forms
The attributes are set in the Defaults for the form. This is the same screen where you setup the compatibility mode and the window size and position. ---- original message from Postmasters ---- ++ ++ I work with Informix 4GL Forms 4.10 (ISC Unix). ++ Where Code Generator keeps …
Re: Client/Server for Informix
gcraven@epix.net wrote: :Is there anybody out there who has built or is building a graphical front-end :(Windows based, not X windows) application for Informix. Our current :environment has UNIX servers running 4glRDS, ISQL, SE (ver. 4.12) using :terminals and PCS for access. (…
Connecting Informix to html
I'm trying to connect html forms to an Informix backend. I've seen the gsql stuff, but it only talks about Sybase and Oracle. Doesn't look to hard to convert it to Informix, but if someone else has done the work I'd rather not do it over. If someone found a way to convert perform…
Re: definning table key
adel@q8petroleum.com.kw (Adel Al-jouhar) wrote: >I 've created a table with 8 columns, 6 of them to define >one record (key), this table updated once a year >the second table contains 7 columns (the same above 6 columns + 1) >now this table is updated weekly >can I do better…
Re: Pension Fund Administration
Hi, My company are providers of Life & Pension systems for individual and as of next year corporate pensions systems as well. If your interestd e can also talk about the provision of pension fund softare. Is it fund managament ? Is it policy management ? is it both ? G.K. Twad…
Re: Unsatisified symbols
Hi, > Whenever I get an error such as: > c4gl masters.o prvdeg.o ad_cmte.o usr_functions.o -s -o masters.4ge > /bin/ld; Unsatisfied symbols: > _FMad_cmte (data) > *** Error code 1 to find the symbol simply run the command nm $file where $file is each object…
Re: -218 error
Hi, > > SQLEXPLAIN message file problems > 90% or more of thse are causd by the installation of the tools after the ngins or the engine after an istar ... so 1) free up some disk space 2) e-install the products into the new free disk space 3) make ure the ordr is tools, engi…
Re: Problem with SP
Hi, > > installation order Networking Engines Tools should be Tools Engines Networks or TEN G.K. Twaddle Technical Director Beta Computers (Europe) Ltd West of Scotland Science Park Maryhill Road Glasgow G20 OSP Scotland. tel 44-41-945-3855 beta@cix.compulink.co.uk { ask n…
Re: comp.databases.kerry.sainsbury and tbtape question
Hi, > DEFRAG ON UNLOAD there is no defrag when using tbtape as it is a page mirror image, however unload and re-load will help also ask informix when the new product BULK LOADER will be available for you port, this is a parallel version of load,unload. G.K. Twaddle Technic…
Re: Inet, err -932 , WSAENOBUFFS
Hi, > PCNFS and WSA*BUF* problems ! This is almost certainly a winsock.dll problem and could well be simply chcking the PATH env variable in dos. I've had this several times and just keep trying different winsock.dll stuff until I find one that works ! G.K. Twaddle Technic…
Informix perf problem
} } ----- Transcript of session follows ----- } 550 wlyle@PROBLEM_WITH_INEWS_DOMAIN_FILE... Host unknown } } } > } > I have setup an informix database on a Sparc10. 5.00.UC3. The } > configuration is generally the same as other servers I have but it runs } > different applic…
integrated 4gl/c word processor
A couple of weeks ago I had indicated that our company had developed a rudimentary word processor and e-mail package using 4gl. From your responses and suggestions we have pulled many resources and now have mostly completed a product that is well beyond rudimentary. Though it u…
Re: Stored Procedure
On Fri, 23 Dec 1994, Cathy Kipp wrote: } Kalyanaraman.L writes: } -> } ->Is there any way to use Stored procedure and triggers under informix-4GL. } } Yes. 4gl doesn't understand them itself, since the sql parser for 4gl was } written for earlier engines, so you need to send th…
Re: tbtape question
Question: Will unloading a database using tbunload, then dropping it, and loading it back in using tbload defrag the tables?…
Re: Tab key option?
jerryk@mtcdev.mediatech.com (Jerry Kruzel) writes: > I wrote a labeling system in 4gl for SCO UNIX. The label editing >screen consists of 14 fields , 57 characters long. When the end user >edits the label they obviously want this done A.S.A.P. Is there any way they >can tab o…
Re: Stored Procedure
>>Is there any way to use Stored procedure and triggers under informix-4GL. dberg@informix.com (David I. Berg) writes: >Triggers operate upon an event which occurs to a table. They are >not at all specific to any client tool. >Stored Procedures are executed through 4GL by prepa…
Re: Another DATETIME, INTERVAL type problem
kcchow@technet.sg (Chow Keng Choon) writes: >Hi There, >This is another DATETIME, INTERVAL type problem. I am writing an ESQL/C >program which I want to plot a graph based on the data I capture over >a period of time. The problem is that I need to divide an INTERVAL >with an IN…
Re: Stored Procedure
Kalyanaraman.L writes: -> ->Is there any way to use Stored procedure and triggers under informix-4GL. Yes. 4gl doesn't understand them itself, since the sql parser for 4gl was written for earlier engines, so you need to send the request to your engine (5 or 5.01 and up) which d…
FAQ? Where is it?
I am looking for the informix FAQ. Anyone have it? Where can I get a copy? Can someone send it to me? Thanks. -- sal@panix.com Yes, I use PGP. Salvatore Denaro Live fast, Die young, Hack C++ My heart is broke/but I have some glu…
Re: Pension Fund Administration
Try BETA computers in Glasgow - they do a lot of work in this area. Their number is (+44) 41-945-3855. Ask to speak to Alasdiar Brodie…
Re: Another DATETIME, INTERVAL type problem
How about DEFINE inputdate interval day to second DEFINE outputdate interval second to second LET outputdate=inputdate Surely that would work! Malcolm Weallans OnLine Database Consultancy…
Re: Searching for a trim() function
If you are returning the variables to 4GL why not wait until they are in 4GL and then do LET newstirng=string1 CLIPPED," ",string2 But I suspect that stored procedures do not support CLIPPED Malcolm Weallans OnLIne Database Consultancy…
Re: comp.databases.kerry.sainsbury and tbtape
> In article c0d@newsbf01.news.aol.com, inxutil@aol.com (Inxutil) writes: > >Here's a legitimate question: > > > >If the data base is fragmented as it sits physically on the disk, does > >the tbtape PROCESS unfragment the data as it is streamed to the > >tape? > > > >Or is it st…
Loading an Informix table with data created from a mainframe extract.
This question is in two parts: 01) I am using the Informix utility (LOAD) to load a flatfile (that was created from the mainframe then ftpped to the UNIX box) to a table. If the key in the flatfile does not exist in the table, I load it. If the key in the flatfile exist in the t…
Re: C-ISAM reestablish position
(Roy Hasselman) writes: >Because points of return are >virtually infinite, I can't see how multiple channels can help me there. >I apologize if I bring up a well-known C-ISAM limitation, but I am new to >working with C-ISAM and was hoping to be able to do the same type of thing…
DIFFERENCE BETWEEN 4.
A> From: aland@informix.com (Colonel Panic) A> If it's winter solstice here and summer solstice there, what is it on > the equator??? Hot. :) --- ~ SPEED 1.30 [NR] ~ SPEED READ does everything but think up new taglines!…
Re: Stored Procedure
shanke11@merlion.singnet.com.sg (Kalyanaraman.L) writes: >Is there any way to use Stored procedure and triggers under informix-4GL. Triggers operate upon an event which occurs to a table. They are not at all specific to any client tool. Stored Procedures are executed through 4…
Re: comp.databases.kerry.sainsbury and tbtape question
Jack Parker writes: -> ->> ->> What did I do? What did I say? Any hints at all? ->> Was it my suggestion that Informix might be the best people to ask ->> about ports to particular platforms? ->> ->> Help! I'm feeling all sad and unloved )-; -> ->Don't sweat the little stuff. I…
Monthly Posting From SNIDE Computers
Last-Modified: Fri Dec 23 09:26:58 EST 1994 This is the last monthly posting from Dave Snyder, keeper of db4glgen (Don't ask why). Although this is probably old information for alot of you, I find that about once a month or so, I'm asked, "What is db4glgen?"... "Where can I get…
Q:Code generation by Informix 4GL Forms
I work with Informix 4GL Forms 4.10 (ISC Unix). Where Code Generator keeps pieces of code to put them together at source code generation time? Can I change the pieces to modify default value of ATTRIBUTE keyword for all generating by Code Generator CONSTRUCT, INPUT and DISPLAY st…
Re: ODBC Drivers
Alex, I have tried both Intersolve and Openlink drivers. I am using Informix 6 on an IBM RISC/6000. The Intersolve driver do not work, even working with their tech support extensively, they could not make it happen. I sent their "software" back. Openlink drivers are much bet…
Re: Anyone have Informix running under linux?
Colonel Panic (aland@informix.com) wrote: : In article <3cprie$at1$1@heifetz.msen.com> jsturm@garnet.msen.com (Jeffrey Sturm) writes: : >Yes, I have been successful running both Informix-OnLine and SE engines, as : >well as 4GL-RDS and SQL tools under the Linux IBCS2 module. All…
Re: C-ISAM reestablish position
Wayne Williams (compus@mv.com) wrote: : I'm using the C-ISAM library and have been unable to determine a method of : saving and restoring the current positioning within a file. I want to traverse : a file by key, but be able to "reposition" at a known point in the file where : t…
Re: InformixLink on the Internet?
> I understand that maybe a couple of months ago someone > posted information here about Internet access to InformixLink. > > If it bears repetition, would you be able to post it again? > If not, would you email the information? Thanks! Two days ago, I went the www.informix.com…
Re: Informix DBA Problem
This seems to be a recurring problem. Different network protocols - same problem. Maybe we should all quote error 932 in the title. As to the cause - it always seems to be different solutions that are suggested. I still haven't resolved mine. In my case I have a working FTP …
Re: Data deletion in Informix
Whan you delete records from a table the space is not released. Instead the records are flagged as deleted and can be used by subsequent inserts. So, the records are logically deleted. If this is a problem, i.e. you delibertaly delete the records to free up disk space and don'…
US-WA-Seattle Sr. P/A - Informix/Neuron
ASIX, Inc., is a leading-edge open systems consulting practice based in Seattle, Washington. We provide advanced solutions using current open systems technology to meet the needs of major Pacific Northwest companies. We are seeking to fill the following position: Position Titl…
Re: Row Level Locking
calvin@florida.nynexst.com (Calvin Chen) writes: >Dear Informixer: > I have a question on informix row level locking. > I have two tables: department and account > table department table account > dept char(3), dept char(3), > amount integer account integer, > amou…
Re: comp.databases.kerry.sainsbury and tbtape question
> > What did I do? What did I say? Any hints at all? > Was it my suggestion that Informix might be the best people to ask > about ports to particular platforms? > > Help! I'm feeling all sad and unloved )-; Don't sweat the little stuff. I am sure I speak for many when I say we…
Project Management Software using Informix
Does anybody know of any project management software that is available that uses informix as its database, or written for informix? Thanks Peter peter@miller.cs.uwm.edu…
Emory U. systems moving
As I mentioned in a posting earlier this week, a number of systems are being relocated at Emory University. The two Emory systems of interest to this forum are rmy.emory.edu and mathcs.emory.edu. "rmy" is the home system for the Informix mailing list (informix-list). "mathcs" …
Re: -218 error
kmart!bminnick@uunet.uu.net writes: >Re: >>Wild! I just logged on to ask about a problem we are having with the >>SET EXPLAIN ON command in Informix 4.1. >>When the statement is executed, we the following message >> -218 unable to load messge file The unable to load messag…
I-Net
Help! I have posted a similar note once before, but an trying again. I have Hyperscript Tools 2.0 and I-NET TCP/IP 5.02.UC2 installed on my 486 running WIndows 3.11. I wish to access an informix 4.11.UC database on an NCR 3450 running UNIX. Have AT&T's Starg…
Re: Searching for a trim() function
> Chuck Ludwigsen so eloquently writes > > Okay, I give up! How can I return a character string without trailing > spaces in order to concat it with another character string? Mind you, > I have been able to do this using varchar columns but I've been told > that varchars cost b…
makefiles
I recently saw makefiles for i4gl and RDS(?). Could someone repost those entries. I was cleaning up and got carried away.:^) Thanx…
Re: Informix Perf Question
Wayne Lyle (wlyle@PROBLEM_WITH_INEWS_DOMAIN_FILE) wrote: : I have setup an informix database on a Sparc10. 5.00.UC3. The : configuration is generally the same as other servers I have but it runs : different applications. I have noticed that this server generally has : 0% - 30%…
Re: Informix/ODBC - what's needed
PS we run informix 4 (FOXBORO IA)…
Informix Perf Question
I have setup an informix database on a Sparc10. 5.00.UC3. The configuration is generally the same as other servers I have but it runs different applications. I have noticed that this server generally has 0% - 30% cache reads and 80% - 95% cache writes. On the other servers th…
ODBC for C-ISAM
I am thinking, does anybody out there know any company have an ODBC driver for access C-ISAM on UNIX and any utility for management C-ISAM. I am not sure whether have or not. If no, can anybody please enlighten me. Please e-mail me. Thank in advance. Jason Leong…
C-ISAM for OS/2?
Is C-ISAM available for OS/2? If not, is a there a C-ISAM clone that is available for OS/2?…
WORDWRAP bug
It looks like the WORDWRAP option in a multiline screen field causes the system to hang up when used with some editing keys like CTRL-X (Unix, Informix ver. 4.1) .Did anybody experience that problem? Thanks…
Re: Parameterizing Hyperscripts
In article <1994Dec20.234152.1638@srs.loral.com> bwt@srs40cm.scf.loral.com (Barbara Wang Tolentino) writes: I am trying to create a parameterized hyperscript, that is invoked with parameters passed in directly from my application software. Is there any way to do this? …
Re: ODBC Drivers
In article <3csdjs$4e@xap.xyplex.com> dlaskey@xyplex.com writes: > Is anyone using any ODBC drivers to access Informix database? > (Intersolv vs. OPENlink) I repeatedly see questions like this - even I have asked it a few times. And although there is very helpful information…
Re: update question
In article <3d7ruh$8fk@emory.mathcs.emory.edu> inf_bb@hermes1.sps.mot.com "Bob Baskett" writes: > netters, > > given that you have two tables that are defined exactly that same, > table1 and table2. where table1 has 5 million rows and table2 has > 50000 rows of data. …
C-ISAM Limits - Big Systems
We're a software house trying to convince a skittish customer (who has been burned by a failed COBOL conversion onto a SUN platform) that C-ISAM is a robust file management system whose locking mechanism's (we're talking OLTP here) can easily handle hundreds (thousands?) of users…
Re: C-ISAM reestablish position
Wayne Williams (compus@mv.com) wrote: : I'm using the C-ISAM library and have been unable to determine a method of : saving and restoring the current positioning within a file. I want to traverse : a file by key, but be able to "reposition" at a known point in the file where : t…
[HELP!] Information about banking systems needed!!!!
Hi everybody:-) Lines: 25 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Length: 1241 My name is Kudruashov Sergey (Serge). I'm the student of the second course of the International Academy of Business and Banking, Togliatti,…
Re: A separate newsgroup for applications issues?
Don't mix it up with other vendors - the AOL is big enough on its own. If developers knew about it, it would be used.…
New 6.0 user charge policy?
I received notice today from one of my employees that Informix was going to be changing the way they do licensing. We pay for support from Informix year to year to keep up to date with the current releases of the software. At one point in the past we didn't buy the maintenance …
Re: Problem with SP
In article <3d6qhq$dcv@emory.mathcs.emory.edu>, ckipp@vth1.vth.colostate.edu (Cathy Kipp) wrote: > This looks like the same problem you have with trying to turn set explain on > when your Informix products have been installed in the wrong order. Now, if > I remember Jonathon Le…
Re: Upgrade for Informix 7.1 on Solaris
>I am talking with my sales rep on migration plans from Informix 6.0 >running on Solaris 2.3 to Informix 7.1. He tells me that 7.1 is >checked out only on Solaris 2.4, so I should upgrade the operating >system and the database software at the same time. That isn't a >reasonable…
select problem with integer field
I need to do a SELECT where I match only the last (rightmost) 7 digits of an integer field. If you imagine that field xyz is an integer or serial type field I want to do the following: SELECT * FROM a_table WHERE xyz LIKE '%8765432'; I would like to find all records where xyz h…
A separate newsgroup for applications issues?
>> In article <D05x6A.K6x@ozemail.com.au> rwright@ozemail.com.au writes: >> > >> >Is anyone interested in the idea of a new group for Oracle appliactions >> >eg Financials ? >> >> A newsgroup such as this would be helpful as I would then not have to wade >> through a million mess…
Online installation error msg
I keep getting this message on my console, why ?? " Cannot connect to license server " Can anyone help ?? I have only Informix Online 5.01 UD version, I-4GL ver 4.11 & I-SQl 4.11 only. I don't have any Informix networking software, like I-STAR or I-NET running. Regards, …
[Q] Oracle and Informix
[ Article crossposted from comp.databases.oracle ] [ Author was Byron Pearce ] [ Posted on 22 Dec 1994 00:12:16 GMT ] What are the ramnifications of running an Oracle RDBMS and an Informix RDBMS on the same machine? Are there any perils or pitfalls to beware of? Thanks! =====…
OSF DCE User & Developer Conference (GPCQM04)
OSF announces the next OSF DCE User & Developer Conference. It will be held April 11-13, 1995 in San Jose, CA. Featured Speakers Include: David Tory, OSF Joe Maloney, OSF Dick Mackey, OSF Donald A. Haile, IBM Richard Wilkie, Hewlett-Packard Nathan Morton, Open Environment Davi…
Onstat -g ses in 6.0
Hi everyone, Does anyone know what each of the fields below from the output of onstat -g ses "SESNUMBER" represent: name free used name free used overhead 28 120 scb 0 40 opentable 0 …
Re: Data deletion in Informix
In Article <3d3v5v$lkc@raffles.technet.sg> Alan Chen writes: >If I have done a mass deletion on tables, when I do a tbstat -d , I don't see >the space being free up. Is it the space was free logically but not >physically ?? When you delete a row from an Informix table, it is mar…
Informix SE v6 Error
When compiling forms through R4GL I get the following message: SQL server terminated. See error number -2999 The description of this error mentions a killed engine process of OS restriction. Everything else works fine, including command line compiling. Anyone have any ideas? …
Re: Database engines, Transaction Processing, and Licensing
In article <3cndoj$4og@stargate.promus.com> jburks@promus.com (Jim Burks) writes: >We have a large transaction processing environment, similar to >Top End, Tuxedo or Encina (but homegrown), which funnels a large >number of end users into a small number of worker processes. > >We …
Re: Is anybody using Sun RAID/Informix?
Disk E Systems writes: >....(above question) This question has expired here. Would someone have the original question? We have lots of high speed, I/0-accelerated RAIDs installed on SPARC systems, using a variety of databases. Michael Willett Storage Computer Corp. 11 Rivers…
Tab key option?
I wrote a labeling system in 4gl for SCO UNIX. The label editing screen consists of 14 fields , 57 characters long. When the end user edits the label they obviously want this done A.S.A.P. Is there any way they can tab over within a field (at least 5 spaces at a time, or more…
Informix/ODBC - what's needed
I have Informix running on a Sun workstation running OS 4.1.?. I have VB on a PC and have the Q+E ODBC Pack. What (if any) client software for my PC do I need from Informix? I am already connected to Sybase on a HP9000 using the Q+E ODBC pack and Sybases' open client software. …
Re: Searching for a trim() function
In article <1994Dec21.142044.29392@fsl.noaa.gov> stimmel@fsl.noaa.gov (Carol Stimmel) writes: >no answers, but I'm interested as well. Please post >your solution! > >Thanks >Carol /* a trim function */ #include <ctype.h> trim(str) char *str; { int x; for(x=strlen(str)-1;x>=0;…
Re: ITW Paslode Chooses FourGen and Informix
Natalie Hadfield (natalieh@fourgen.com) wrote: : **FOR IMMEDIATE RELEASE** : ITW PASLODE CHOOSES FOURGEN SOFTWARE OVER 54 OTHER VENDORS : (SEATTLE) - December 20, 1994 - After a six-month evaluation of 55 software : vendors, ITW Paslode chose FourGen software to provide distri…
Informix Net for Windows NT?
Hello Informix users, Does anyone know if there is any Informix Net for Windows NT shipped from Informix? We have a customer who is dying to purchase the product. The group in Asia Pacific said that there is no such plan for these products. Thanks in advance, and looking forwa…
Re: Searching for a trim() function
no answers, but I'm interested as well. Please post your solution! Thanks Carol…
Re: SET EXPLAIN ON problem
In article <3d4rpo$5dg@athos.cc.bellcore.com> foxj@moscow.cc.bellcore.com (fox,james p) writes: > Hi, > We're currently having a problem with INFORMIX On-line Release 6.01 on > Pyramid. When we do a "SET EXPLAIN ON" in ISQL or ESQL/C we get > the following message: > > 534:…
Upgrade for Informix 7.1 on Solaris
I am talking with my sales rep on migration plans from Informix 6.0 running on Solaris 2.3 to Informix 7.1. He tells me that 7.1 is checked out only on Solaris 2.4, so I should upgrade the operating system and the database software at the same time. That isn't a reasonable plan…
Re: Difference between 4.12 and 6.0 frontend tools
In article <Pfezkq4b9$6Q075yn@kcbbs.gen.nz> kerry@kcbbs.gen.nz (Kerry Sainsbury) writes: >The 6.0x tools are just 4.1x tools compiled to use the new communications "just", says he. If he ONLY knew how much this really took to pull off... several of us are facing decades of ther…
Pension Fund Administration
Does anyone know of Pension Fund Administation systems. Suitable for administering PF members, withdrawals and pensioners. Any ideas will be appreciated. Thanks in advance Kelvin Shuttleworth…
Re: trick for setting isolation dirty read in an Ace report
In article <protz.2.2EEFA0AF@hookup.net> protz@hookup.net (Mike Protz) writes: >DATABASE sales END >SELECT set_isol_dirty() a FROM systables > WHERE tabid = 1 > INTO TEMP dummy_temp_table; >... I missed the beginning of the thread, but perhaps people have missed the new feature …
Re: I-STAR spawns child problem
In article <D0pux7.C0A@vcd.hp.com> kenm@vcd.hp.com (Ken Miles) writes: >Mike Johnson (mikehunt@algonet.se) wrote: >> Like what problems Ken? We are using just that release here and as we are >> about to take the system into production it would be nice to know what >> we might be …
Re: ISQL in INFORMIX 6.0
In article <3ciffn$6es@hpuerci.atl.hp.com> johnbr@atl.hp.com (John Bria) writes: >Starting with 6.0 (and DSA), all products will be rev'd simultaneously. Not necessarily. Core server products (SE, DSA, ESQL/C) are moved together, core tools products (character-mode 4GL, ISQL) a…
Re: Informix 3.61 (msdos version) and OS/2
In article <3d4lgu$vf@news.xs4all.nl> marks@xs4all.nl (Mark Stuurman) writes: >At my work we're using informix 3.61 running on on a novell 3.12 network, I suspect you *really* have Informix <something> version X.10.06_, and 3.61 is the DOS/16M version that underlies it (DOS/16M …
Re: Books on Informix-SQL 6.0?
In article <1994Dec15.153936.8070@midway.uchicago.edu> krb1@midway.uchicago.edu writes: >I particularly would like to know if there's an edition of >Prentice Hall's _Informix Guide to SQL: Reference_ for version 6, but >I'm interested in finding out about any other books as well.…
Re: Anyone have Informix running under linux?
In article <3cprie$at1$1@heifetz.msen.com> jsturm@garnet.msen.com (Jeffrey Sturm) writes: >Tony Peterman (automata@netcom.com) wrote: >: title says it all. If so what version, and what options aside from the engine. >: I am mainly interested in I-Start, and esql/c. > >Yes, I have…
Re: DG/UX 5.4R3.10 Compatibility?
In article <3clcgf$oof@mnemosyne.cs.du.edu> aburt@mnemosyne.cs.du.edu (Andrew Burt) writes: >>On 13 Dec 1994, Mickey Baker wrote: >>> Can someone tell me the versions of Informix products that >>> work and are supported under Data General's DG/UX 5.4 product, >>> revision 3.10? >…
Re: Inet, err -932 , WSAENOBUFFS
You've probably checked but look at the winsock.dll you are using and ensure it is the one supplied with PCNFS and not the one in the Windows directory. Paul Watson MIS Manager compans@cix.compulink.uk.com Tel ++121 604 1199…
Stored Procedure
Is there any way to use Stored procedure and triggers under informix-4GL. Thanks in advance Kalyanaraman.L…
tbtape question
Bill Glidden wrote : >No defragmentation occurs. Tbtape copies page images from disk to tape. >Included with each page image is the page address, which translates to >a physical location on disk. So, after restoring from tbtape, your chunks >will look exactly the same. >If you …
update question
netters, given that you have two tables that are defined exactly that same, table1 and table2. where table1 has 5 million rows and table2 has 50000 rows of data. table2 holds data that is to be inserted or used to update the data in table1. using ISQL only, what is the best way…
Parameterizing Hyperscripts
I am trying to create a parameterized hyperscript, that is invoked with parameters passed in directly from my application software. Is there any way to do this?…
Re: SET EXPLAIN ON problem
On 19 Dec 1994, Gosutton wrote: > Jim, > Wild! I just logged on to ask about a problem we are having with the > SET EXPLAIN ON command in Informix 4.1. > When the statement is executed, we the following message > -218 unable to load messge file > Of course it is not in our …
Re: Difference between 4.12 and 6.0 frontend tools
At 09:31 AM 12/16/94 GMT, spitz@ana.med.uni-muenchen.de wrote: >Hi, > >I just received a CD-ROM from SNI with all the latest versions of >their ports of Informix products. Now I have a choice to upgrade >to either their newest version of the 4.1x frontend tools (probably >4.12) o…
Re: Recommendations? Need image-capable DBMS for Sun
Mark McWiggins (markdmc@netcom.com) wrote: : Sorry for the wide crosspost, but I'm a bit blank on this ... : I'm working on an online catalog (WWW) application to run on a Sparc 2. : I need something that will: : * smoothly handle image data : * work reliably : * have a progra…
Unsatisified symbols
Whenever I get an error such as: c4gl masters.o prvdeg.o ad_cmte.o usr_functions.o -s -o masters.4ge /bin/ld; Unsatisfied symbols: _FMad_cmte (data) *** Error code 1 I think I have figured out that it has something to do with the form but after that I am at a lo…
Searching for a trim() function
Okay, I give up! How can I return a character string without trailing spaces in order to concat it with another character string? Mind you, I have been able to do this using varchar columns but I've been told that varchars cost big on performance. Our tables often exceed 5M ro…
C-ISAM reestablish position
I'm using the C-ISAM library and have been unable to determine a method of saving and restoring the current positioning within a file. I want to traverse a file by key, but be able to "reposition" at a known point in the file where the program had previously read - and resume tra…
-218 error
Re: >Wild! I just logged on to ask about a problem we are having with the >SET EXPLAIN ON command in Informix 4.1. >When the statement is executed, we the following message > -218 unable to load messge file >Of course it is not in our manual. Gordon, This is the explanti…
Informix and NIS
We have Informix 5.0 running here on HP-UX 9.04. The problem is that Informix does not want to check to see if users are in NIS. Does Informix have their own routine for checking the passwd file? If so, WHY?!?! Any info would be appreciated. Thanks. -- Tom Charles tom@delcoele…
ITW Paslode Chooses FourGen and Informix
**FOR IMMEDIATE RELEASE** ITW PASLODE CHOOSES FOURGEN SOFTWARE OVER 54 OTHER VENDORS (SEATTLE) - December 20, 1994 - After a six-month evaluation of 55 software vendors, ITW Paslode chose FourGen software to provide distribution and financial information systems to manage its b…
Cust. Service Center Scheduling SW?
A manager at my site requested help in locating a software tool which he can use to develop work schedules for a large phone center. What he's looking for is something which can maintain a staff database, take STAFFING REQUIREMENTS as input and generate SCHEDULES/SHIFTS as outpu…
Job: Informix Skills Needed
My company Computer Answers International produce EPPIX the leading open systems software for the international cellular market. We currently seek Design Analysts and Analyst Programmers working in the UK, South Africa or Australia. Informix skills are essential. Th…
Re: Data deletion in Informix
> > If I have done a mass deletion on tables, when I do a tbstat -d , I don't see > the space being free up. Is it the space was free logically but not > physically ?? > There are now empty spots for rows in your tables, like swiss cheese. To de-fragment the holes, sometimes "alt…
Re: Data deletion in Informix
> Subject: Data deletion in Informix > Date: 19 Dec 1994 12:43:43 GMT > Reply-To: sgs@technet.sg (Alan Chen) > Organization: Technet, Singapore > > If I have done a mass deletion on tables, when I do a tbstat -d , I don't see > the space being free up. Is it the space was free lo…
Pathnames in Wingz 1.1 HyperScript
Does anybody know how to get the pathname of the current script, i.e. the one that you are currently running. I would be most appreciative of a quick replt. Malcolm Weallans OnLine Database Consultancy…
Re: Informix on NT
Jack, I haven't heard of OnLine for NT. But I do know that you can buy a bundled Microsoft NT w/ Informix OnLine. I have not seen it running, but it is available. Regards -- ----------------------------------------------------------------------------- Robert J. Cline II …
Re: SET EXPLAIN ON problem
In article <3d512s$577@newsbf02.news-fddi.aol.com> gosutton@aol.com (Gosutton) writes: >Wild! I just logged on to ask about a problem we are having with the >SET EXPLAIN ON command in Informix 4.1. >When the statement is executed, we the following message > -218 unable to loa…
Data deletion in Informix
In Message-Id: <3d3v5v$lkc@raffles.technet.sg> sgs@technet.sg (Alan Chen) writes: > If I have done a mass deletion on tables, when I do a tbstat -d , I don't see > the space being free up. Is it the space was free logically but not > physically ?? The space is still allocated f…
Re: Data deletion in Informix
In article <3d3v5v$lkc@raffles.technet.sg> sgs@technet.sg (Alan Chen) writes: >If I have done a mass deletion on tables, when I do a tbstat -d , I don't see >the space being free up. Is it the space was free logically but not >physically ?? > As far as I know, space is not freed…
Re: Informix DBA Problem
Borg Boy (borgboy@aol.com) wrote: : I had a similar problem when I first installed View Point and the other : tools. I found that if I put an exact copy of my UNIX services file in my : pathways directory (my TCP/IP transport program directory) I could connect : without incident…
Re: Informix DBA Problem
Edwin Babadaglian (edwinb@panix.com) wrote: : In <3d4gc7INNjii@afshub.boulder.ibm.com> naomi@cyst.glta.ibm.com (Naomi Mitsumori) writes: : > SQL (-932) : Error on network connection. : > getservbyname (WSANO_DATA) system called failed. : I had the same problem with NewEra. Th…
Re: Data Deletion in Informix
Alan wrote: >If I have done a mass deletion on tables, when I do a tbstat -d , I don't see >the space being free up. Is it the space was free logically but not >physically ?? Alan, the answer to your question is that when you perform a mass delete on a Informix table, the tables…
InformixLink on the Internet?
I understand that maybe a couple of months ago someone posted information here about Internet access to InformixLink. If it bears repetition, would you be able to post it again? If not, would you email the information? Thanks!…
Monthly Posting from Snide Computer Services
Last-Modified: Tue Dec 20 07:25:14 EST 1994 This is a monthly posting from Dave Snyder, keeper of db4glgen. Although this is probably old information for alot of you, I find that about once a month or so, I'm asked, "What is db4glgen?"... "Where can I get dbinfo?" Well here are…
RE: DATE feature
> Can anyone confirm that when a DATE for a Leap day e.g 29/0feb has > years added to it the result is garbage, but if the addition of years > is multiples of 4 then everything is OK. We had this problem under 4GL v4.1 SCO Unix. It was not just Feb 29th. Any date that had …
Re: HELP: ESQL/C Update Cursor Error
At 01:28 AM 12/16/94 GMT, aewhale@emi.lm.com wrote: >I am trying to implement database locking in a Production application >which currently only implements locking via application. In order to >do this I am first implement (or trying to) implement cursor stability >with lock mod…
Another DATETIME, INTERVAL type problem
Hi There, This is another DATETIME, INTERVAL type problem. I am writing an ESQL/C program which I want to plot a graph based on the data I capture over a period of time. The problem is that I need to divide an INTERVAL with an INTERVAL; which is a no-no. Is there a way to conver…
informix-list distribution and Usenet gateway
A number of systems are being relocated at Emory University, and the process of moving them may affect the distribution of the Informix mailing list. It will definitely affect the gateway that transfers list messages to/from the Usenet newsgroup comp.databases.informix. I had t…
Informix on NT
Jack Parker <jparker@hpbs3645.boi.hp.com> posted: > Pholks, > > Any word on the possibility of such an animal (Informix on NT)? As a server? > Comments, jokes, and flames all welcomed. > > cheers > j. > <clipped> I have seen such an animal... Informix was nice enough …
Re: Problem with SP
Robert Velter writes: -> ->Trying to execute the following statement i found in the ->'Guide to SQL, Reference book' on page 8-7 using 'dbaccess' ->produces: ->... -> ->Dbaccess stops with error number 581 and the cursor is ->blinking at lastname. This looks like the same proble…
4tags - C version of 4gltags
Are you looking for a tag generator for Informix 4GL, look no further. Are you unsatisfied with the speed for 4gltags in shell version(s) ?. Well here's the solution, C version of 4gltags. I was tired of the poor performance of other 4gltag programs, so I wrote this one i C. '…
Row Level Locking
Dear Informixer: I have a question on informix row level locking. I have two tables: department and account table department table account dept char(3), dept char(3), amount integer account integer, amount integer If I execute the following update statement …
Re: Database tuning.. any hints?
jockc (jockc@netcom.com) wrote: : Thanks to all the people who responded; I got quite a few responses : and some good ideas for things to try. The Quintus application seems : to be running better already after the few changes I've made so far. Let us know what changes you finall…
Re: Recommendations? Need image-capable DBMS for Sun
In article <markdmcD136F1.BCJ@netcom.com> markdmc@netcom.com (Mark McWiggins) writes: > * smoothly handle image data > * work reliably > * have a programmatic interface via perl, gcc, or g++ > * not overwhelm this machine running a dataases of 15K > records (maybe 300 bytes of…
Re: Difference between 4.12 and 6.0 frontend tools
In article <3crmph$qgp@arcadia.informatik.uni-muenchen.de>, spitz@GANS1X.ana.med.uni-muenchen.de (Richard Spitz) wrote: > > I just received a CD-ROM from SNI with all the latest versions of > their ports of Informix products. Now I have a choice to upgrade > to either their newes…
Unix Guru Job Opportunities
UNIX GURUS Business Systems Support Group, Inc., (BSSG) is a supplier of UNIX/Informix based accounting systems for medium to large sized law firms. We are seeking experienced HP-UX, DEC, and SCO Unix administrators for permanent and contract positions. Duties will include, bu…
Informix Programmers
INFORMIX PROGRAMMERS Business Systems Support Group, Inc., (BSSG) is a supplier of Informix based accounting systems for medium to large sized law firms. We are seeking experienced Informix 4GL programmers for permanaent and contract positions. Duties will include, but are not…