HDTenEightyP/NetNews huggingface dataset:
From: jgordon@ssf-sys.DHL.COM (Jim Gordon)
Newsgroups: comp.databases.informix
Subject: Re: tracking data changes (a request for advice/information)
Date: 17 Nov 1992 19:38:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: jgordon@ssf-sys.DHL.COM (Jim Gordon)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1615>

>
> I need the ability to track any changes to a large OnLine database, to the
> table/row/column level*, without having to constantly scan all of the tables,
> and without building any special abilities into the applications doing the
> adding/deleteing/updating.
>
> The former is no good because:
>
> 1) It would use up too many resources, and
> 2) It wouldn't give me the changes in the order they happened (fairly important)
>
> The latter is no good because:
>
> 1) Too much existing code would have to be changed, and
> 2) doing batch adds/updates/deletes with isql would screw things up
>
> The most obvious solution I can think of is having transaction logging turned
> on, and monitoring the logical log.  I guess my questions are:
>

I can't comment on the Online Log idea but another solution would be
to wait for Online 5.01 and use the Triggers to write records to log
files after every insert/update/delete on the tables and columns you
need to monitor.

This would avoid any necessity to play with the online logs and would
not require any changes to the applications.  It would also allow you
to more easily tailor the logging to only those parts of the database
you need to check on and allow for building a simpler database query
process rather than a (probably) C extraction process from the logs.

It is not possible to access the performance hit this will have on the
application.  But the Stored Procedures seem to work fine in 5.0.
Also you run the risks of bugs in the Trigger system.  Against this
Informix have given themselves considerable extra time to get Triggers
reasonably clean.  They were supposed to be in 5.0 but at release time
were not stable enough so they left them out.

Cheers - Jim
--------------------------------------------------------------------
Name:     Jim Gordon               Internet: jgordon@ssf-sys.DHL.COM
Company:  DHL Systems Inc          Phone:    (415) 358-5911 (Work)
Address:  1700 S. Amphlett Blvd.             (415) 882-9728 (Home)
          San Mateo, CA 94402      Fax:      (415) 571-6429
--------------------------------------------------------------------
Newsgroups: comp.databases.informix
From: chriss@sam.amgen.com (Chris Silvester)
Subject: Re: Row locks
Organization: Amgen
Distribution: usa
Date: Tue, 17 Nov 1992 22:57:28 GMT

In article <1992Nov17.041550.11286@panix.com>, clay@panix.com (Clay Irving) writes:
> 
> We've written a program that updates several rows in a table. We assumed that
> we may run into locking problems since these rows may be updated by another
> program. So... We test for the lock and if we can't lock the row, we issue
> an error message to inform the user that one of the rows can not be locked --
> someone else has it. Now, how can we find who's locking the row? Tbmonitor
> shows me users with locks, but it doesn't indicate what the lock is...
> 
> There has to be a better way?...
> 
> -- 
> Clay Irving           Personal: clay@panix.com   {...uunet, cmc12}!panix!clay 
> New York, New York        Work: clay@garpac.com  {...uupsi3, 4gen}!garpac!clay
> --
> 

Back in August, someone posted an article about a script that a gentlemen
named Dave Schmitt wrote called "listlocks" that uses tbstat, isql, awk, sort,
join, and tr to produce a listing of locks held by users.  I got a copy of it
from somewhere, modified it slightly for our environment, and it works great.
I believe his email address is daves@csg.gss.mot.com if you want to try to
contact him about his script...

Good luck!

Chris S.

Newsgroups: comp.databases.informix
From: lei@mtcdev.MEDIATECH.COM (Charles Lei)
Newsgroups: comp.databases.informix
Subject: Seeking On-Line Consultant
Date: 18 Nov 1992 20:53:08 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: lei@mtcdev.MEDIATECH.COM (Charles Lei)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1619>

Hello Netland:

We purchased On-Line several months ago and its about time that
we dusted it off our shelves.  No one here has gone to the Informix
On-Line School so we're a little hesitant about installing it by
ourselves (call us chicken, but it seems to me that there are a
lot of problems associated with an incorrectly configured On-Line
Engine.)

We have been developing applications under 4GL RDS/SE engine with 
the FourGen CASE tools for about two years now so we are familiar 
with the Informix product but not the guts of the actual engine 
or the bowels of Unix.

We're currently looking for a consultant to come in and install 
and configure an Informix 4.1 On-Line engine on our 486 Box running 
SCO Unix 3.2.4 within the next few weeks.

This person must have extensive experience working with Informix
and optimizing Unix and the On-Line system.

If you fit this description, please e-mail me at the address below
or call me at the voice number listed below.

Oh yeah, we're located in the downtown Chicago area.

Charles Lei
Mediatech, Inc.
110 W. Hubbard Street
Chicago, IL 60610

E-Mail:  lei@mediatech.com
UUCP:    ..!{uunet,4gen}!mtcdev!lei
Voice: (312) 828-9223 x.202
From: widener!uunet!uunet!microc!eric@emory.mathcs.emory.edu
Newsgroups: comp.databases.informix
Subject: Re: Triggers in Informix?
Date: 18 Nov 92 16:48:04 GMT
Article-I.D.: emory.1eev94INNelk
Reply-To: widener!uunet!uunet!microc!eric@emory.mathcs.emory.edu
Distribution: world
Organization: Mailing List Gateway
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1620>


>From: uunet!informix.com!aland (Colonel Panic)
>Message-Id: <1992Nov13.101943.24076@informix.com>
>Subject: Re: Triggers in Informix?
>Date: 13 Nov 92 10:19:43 GMT
>Organization: Enterprise Technology Center, Informix Software, Inc.

>In article <1992Nov10.063200.2163@netcom.com> tssmith@netcom.com writes:
>>Are the 5.01 triggers "after statement" triggers, or do you support
>>the SQL3 standards for all trigger types (I think there are 12 of
>>them)?
>>
>>If not in 5.01, when?
>>
>>Thanks.
>>
>>--Tim (tssmith@netcom.com)

>Does it bother anybody else that this poster is an Oracle employee hiding
>behind a public-access account?
>--
>Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

Well Alan, it bothers me in a way: why hiding?  It's normal that you want
to know your competition.  Even asking them!  When I'm asked about Oracle,
I use what I read in the reports from Informix.  

On the other hand, you can't blame this guy.  This is the way they are
teached to do business at Oracle...  

+--------------------+--------------------------------------+----------------+
| Eric C. Leschhorn  | *MICROCOMPUTOS*    Fax:(809)688-6044 |                |
| Marketing Director | Dominican Republic Tel:(809)530-8506 +-----------+    |
| uunet!microc!eric  | Puerto Rico, USA   Tel:(809)250-8789 +---------+ |    |
+--------------------+--------------------------------------|   +-+   | |    |
|  I N F O R M I X   L A T I N   A M E R I C A N   T E A M  |   | |   | |    |
+-----------------------------------------------------------+---+ +---+ +----+
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: 386 vs. 486
Date: 24 Nov 92 01:20:48 GMT
Organization: Enterprise Technology Center, Informix Software, Inc.

In article <By5AyB.AxC@news.cso.uiuc.edu> pmaggs@uxh.cso.uiuc.edu (Peter B. Maggs) writes:
>Is there a difference (other than price) in 386 and 486 Informix.
>Will the 486 version run on 386 machines and vice versa?

Sometimes yes, soemtimes no.  Some 486 ports have dependencies on the
integrated coprocessor.  Note that "will it run" and "am I violating the
license agreement" are two different questions.


--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

I'm Pro-Anarchy...   and I Vote!
Newsgroups: comp.databases.informix
From: mtrotter@magnus.acs.ohio-state.edu (Mark L Trotter)
Subject: Any nice menu systems for Informix?
Organization: The Ohio State University
Date: Wed, 18 Nov 1992 20:12:09 GMT

Hi fellow netties:
    I have a rather large collection of 4gl, perform and ace programs
on our system and am having a hard time organizing for easy access for
our users.  Does anyone know of a menu system (or whatever) that will
do the following:

    1. the ability to restrict a users view to only those selections
      that he/she has permission to use
    2. supply a resonable size description field for each selection to
      describe what it does and when to use it
    3. includes a field for the full path name of the executable and
      command line arguements
    4. works on worthless, stupid, serial character based terminals

    The oranizational model I would like to see would give the ability
to assign each program into one or more groups, then assign the users
to one or more groups.  
    Thanks in advance for any advice!
!------------------------------------------------------------------------!
!        Mark Trotter @ The Ohio State University Graduate School        !
!     voice 614/292-6031  FAX 614/292-3656  BITNET trotter.1@osu.edu     !
!------------------------------------------------------------------------!
From: pp@q8.dk (Poul Pedersen)
Newsgroups: comp.databases.informix
Subject: Tbunload&archive in online
Date: 19 Nov 1992 11:03:02 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: pp@q8.dk (Poul Pedersen)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1622>

        Hey experts

        Can you see any problems if tbunload is running when tbtape is
        active with an archive ?

        Online - unix.

        Thanks
        -----------------------------------------------------------------
        Databaseadministrator Poul Pedersen
        Kuwait Petroleum (Denmark) A/S
        Hummeltoftevej 49                         Mail:   pp@q8.dk
        2830  Virum                               Voice:  +45 45 98 45 94
        Denmark                                   Fax:    +45 42 85 14 18
        -----------------------------------------------------------------
From: curley!dtmod@uunet.UU.NET (Modde)
Newsgroups: comp.databases.informix
Subject: Embedded SQL in WingZ
Date: 19 Nov 1992 09:23:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: curley!dtmod@uunet.UU.NET (Modde)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1621>

 
 We are just getting our feet wet with Wingz in order to access an
 On-Line database. One of our objectives was to be able to embed SQL
 queries into a range of cells in order to create standard applications
 for information retrieval, where a re-calc of the spreadsheet would
 fetch new numbers and totals from the on-line database. We would want
 to use the values contained in one or more cells as variables for the
 query. So far in my limited reading of the manuals, I have not been
 able to figure out how to accomplish this without writing Hyperscript
 code. Once we put together several "applications" together using such
 a technique, we would want to idiot proof it by driving it with
 Hyperscript, but we are not there yet. At this point, we are simply
 trying to sell the concept of Wingz to project management, so we just
 want to create something simple, yet powerful examples to prove this
 capability. Any suggestions or examples are appreciated. I would also
 like to hear some recommendations on Hyperscript training.
 
 -- 
 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
 
 ||||||||||||     Dean T. Modde                 Systems Administrator
 ||| \            Fru-Con Engineering Inc.      Voice: (314)391-4404
 |||__|||||||     Ballwin, Mo. 63022            Fax:   (314)391-4513
 ||| \               
 |||  |||||||          UUCP Mail:    !uunet!fcemoe!curley!dtmod
 |||  |||||||          Internet:     dtmod@frucon.com       \-------
 F R U - C O N                                               \-----
  Corporation                            "Let's go Blues!"    \--   
                                                             (()
 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
From: gt2768b@prism.gatech.EDU (JENGLUNG LIN)
Newsgroups: comp.databases.informix
Subject: Can Informix run on MS-Windows
Date: 16 Nov 92 15:33:42 GMT
Organization: Georgia Institute of Technology

We are in the process of chosing a database which offers speed and ease of
use. Some folks recommand Informix. Our first consideration is Windows
compatibility. Can Informix run under Windows?

Also, if we want to write a deliverable product, how does Informix handle
this situation - do we deliver a runtime version w/ our product? 

Any suggestion is highly appreciated!
From: dccrjc9@bpats (David Stockel)
Newsgroups: comp.databases.informix
Subject: Re: Update By Name
Date: 23 Nov 1992 14:08:14 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: dccrjc9@bpats (David Stockel)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1636>

>I was wondering if anyone else thought that having and update by name
>function (or insert by name) would be worth while. ...

I like the idea. Here's my vote for it.

Something else that might be useful:

    CREATE TEMP TABLE tab LIKE rec.*

This could cut down on a lot of redundant definations in my code.

>                                               ... If enough did
>could we get Informix to at least consider it as an option.

Well, anybody can get a feature request number from tech support. I
have a couple. However, I found this to be a very discouraging
experence. A few of my suggestions got lost somewhere along the way.
Other were decided against, but I was never informed. When I did hear
the reasons for the negitive decision, I thought they were a little
weak. It seemed like they didn't really understand my suggestions.

My complaints are that: 1) As far as I can tell, there is no appeal
process. 2) The user community in general is not consulted about their
interest in new features. The end result is that I was pretty much
discourged from submitting feature requests.

Still, I should try and put this into a positive light. Informix execs
made a big deal at the IWUC about wanting to be the source of all
database tool. Maybe it is a good time to try again. Speak up netword.
Get you suggestions in early, and you may be able to affect the design
of 4GL++.
------------------------------------------------------------------------
David Stockel                        Internet: dccrjc9@unix.bell-atl.com
 of  ADIA Information Technologies      Voice: (215) 466-3216
 at  Bell Atlantic                        Fax: (215) 665-1329
     1717 Arch Street 4-N-8
     Philadelphia, PA 19103         Proudly serving my corporate masters
From: root@rebell.rmt.sub.org (Gottfried Hamm)
Newsgroups: comp.databases.informix
Subject: Re: Can Informix run on MS-Windows
Date: Wed, 18 Nov 92 21:49:07 MEZ
Reply-To: root@rebell.rmt.sub.org (Gottfried Hamm)
Organization: rebell * +49 6249 8842 * D-6524 Guntersblum

gt2768b@prism.gatech.EDU (JENGLUNG LIN) writes:

> We are in the process of chosing a database which offers speed and ease of
> use. Some folks recommand Informix. Our first consideration is Windows
> compatibility. Can Informix run under Windows?
> 

The Informix V5.0 will run under Windows and you will have full
connectivity to Informix-databases on UNIX-hosts in the network.

Gottfried

+---------------------+------------------------------------+--------------+
| Gottfried Hamm      |  e-mail : root@rebell.rmt.sub.org  |     I'm      |
| Wormser Str. 36     |  Telefon: +49 6249 8997            |   awaiting   |
| D-6524 Guntersblum  |  BBS    : REBELL +49 6249 8842     | your mail... |
+---------------------+------------------------------------+--------------+
From: jma@shakespyr.db.pyramid.com (Jonathan Ma)
Newsgroups: comp.databases.informix
Subject: Re: Triggers in Informix?
Date: 18 Nov 92 18:03:20 GMT
Organization: Pyramid Technology Inc, San Jose CA

The new version 5.01 is FREE for OnLine 5.0 users according to an article
in OpenSystem Today, Nov 16 '92.

-- 
-Jon-  -#--------  Jonathan Ma, Database Engineering Group    FON: (408)428-7438
     ---###------  DataCenter Solution Division               FAX: (408)428-7290
   -----#####----  Pyramid Technology Corporation
 -------#######--  3860 N. First St.            Email: jma@shakespyr.pyramid.com
--------########-  San Jose, CA 95134
		   Disclaimer: Those words are mine, not my employer's.
Newsgroups: comp.databases.informix
From: chriss@sam.amgen.com (Chris Silvester)
Subject: Re: Can Informix run on MS-Windows
Organization: Amgen
Distribution: usa
Date: Tue, 17 Nov 1992 22:48:00 GMT

In article <74968@hydra.gatech.EDU>, gt2768b@prism.gatech.EDU (JENGLUNG LIN) writes:
> 
> We are in the process of chosing a database which offers speed and ease of
> use. Some folks recommand Informix. Our first consideration is Windows
> compatibility. Can Informix run under Windows?
> 
> Also, if we want to write a deliverable product, how does Informix handle
> this situation - do we deliver a runtime version w/ our product? 
> 
> Any suggestion is highly appreciated!
> 

I know that Informix does have runtime versions of their product.  As far as
the Windows compatibility, I have heard from a reliable source that version
4.2 for DOS and Windows will  be ready in Q1 '93.  I assume this means a
version for DOS and a seperate Windows version.  Also, this will apparently be
the last release to support DOS, but all future releases will support Windows.

Sorry if this is a little vague, but it's all I know right now.

Chris S.
From: jparker@hpbs2776.boi.hp.com (Jack Parker)
Newsgroups: comp.databases.informix
Subject: Re: Pretty-Printer for 4GL Programs
Date: 19 Nov 1992 14:13:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: jparker@hpbs2776.boi.hp.com (Jack Parker)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1625>

Just for the rest of us, what is a prettyprinter or a vgrind?  
Is prettyprinter in the eye of the beholder?
is vgrind a new dancefloor thing?

				j.

_____________________________________________________________________________
Jack Parker - Contractor               | 
Hewlett Packard, BSMC Boise, Idaho, USA|     These don't look like opinions.
jparker@hpbs2651.boi.hp.com            |       Are you sure they're mine?
(208) 323-5388 (W)  (208) 384-1623 (H) |
_____________________________________________________________________________
Newsgroups: comp.databases.informix
From: joe@smt_6.ingr.com (Joe Ryburn)
Subject: Re: What is a prettyprinter?
Reply-To: joe@smt_6.ingr.com (Joe Ryburn)
Organization: Intergraph Corporation
Date: Fri, 20 Nov 1992 14:18:56 GMT

In article <1ehaifINN1tq@emory.mathcs.emory.edu>,
jbaker@bluegrass-emh1.army.mil ("John Baker, Blue Grass Army Depot")
writes:
>Path:
>infonode!uunet!zaphod.mps.ohio-state.edu!wupost!emory!emory!not-for-mai
>il
>From: jbaker@bluegrass-emh1.army.mil ("John Baker, Blue Grass Army
>Depot")
>Newsgroups: comp.databases.informix
>Subject: What is a prettyprinter?
>Date: 19 Nov 1992 19:13:03 -0500
>Organization: Mailing List Gateway
>Lines: 16
>Sender: walt@mathcs.emory.edu
>Distribution: world
>Message-ID: <1ehaifINN1tq@emory.mathcs.emory.edu>
>Reply-To: jbaker@bluegrass-emh1.army.mil ("John Baker, Blue Grass Army
>Depot")
>NNTP-Posting-Host: emory.mathcs.emory.edu
>X-Informix-List-ID: <list.1627>
>
>Jack Parker asked Joe Ryburn:
>
>> Just for the rest of us, what is a prettyprinter or a vgrind?  
>> Is prettyprinter in the eye of the beholder?
>> is vgrind a new dancefloor thing?
>
>I second his questions.  I've never heard of a "prettyprinter" and none
>of
>our AT&T UNIX manuals have an entry for "vgrind."

OK, Folks, a 'pretty printer' is a program which formats source code into a
pleasing and useful form for study and documentation. Usually with options
like line and Page numbers, sometimes an Index, etc. 

Vgrind is a system on bsd (sources are available, 'cause my system didn't come
with vgrind) to format files of varying source formats.


>
>Just curious.
>---
>John 
>--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--
>John Baker,  Directorate of Infor Mgt.  Blue Grass Army Depot, Lexington, KY
>jbaker@bluegrass-emh1.army.mil    Phone: (606) 293-3644, 293-3743  DSN: 745-
>--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--
>
From: mlc@wupmon.wup.de (Michael Lechner)
Newsgroups: comp.databases.informix,comp.databases
Subject: Help needed ! Porting from SE to OL
Keywords: INFORMIX OL
Date: 20 Nov 92 11:04:17 GMT
Organization: Wiechers & Partner, Monheim, Germany

We actual use INFORMIX SE Version 4.0 and need to port to INFORMIX-ONLINE
(and to SE Version 4.1).
Does anybody know, how much changes we have to expect ?
Did anyone allready successfully changed from SE to OL ?
Is it possible to exchange data between SE and OL ?

thanks in advance


please reply to: Michael Lechner (mlc@wupmon.wup.de)
From: Anbarnes@letterkenn-emh1.army.mil
Newsgroups: comp.databases.informix
Subject: clipper
Date: 18 Nov 1992 08:48:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: Anbarnes@letterkenn-emh1.army.mil
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1617>

Pardon my ignorance, but could someone describe for me in 100 words or less
what Clipper is and what it will do for you? I keep seeing notes about
will Informix work with it. Thanks.
Ann Barnes
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: fecat.ec assertion failure
Summary: assert yourself with the catalog
Date: 24 Nov 92 01:17:39 GMT
Organization: Enterprise Technology Center, Informix Software, Inc.

In article <9211201444.AA00337@salmon.demon.co.uk> neil@salmon.demon.co.uk ("Neil S. Briscoe") writes:
>Platform:  Sun 4/330 SunOS 4.1.2 Informix/4GL compiler 4.10.UC1
>
>The problem is that when compiling any 4gl source I get the message:
>
>Assertion failed: fecat.ec line 1091 and the compilation, of course,
>aborts.
>
>I can't find the file fecat.ec anywhere.  Can someone tell me what
>this means?

It means somebody got sloppy in some code in the tools library...  what
you are seeing are results of an assert() call, which shouldn't be in
production code.  I reported this particular occurrence in March as bug
#12347.  In that particular case, the cause was that a strange out-of-sync
condition occurred in the database: the number of indexes for a given table
(as listed in the sysindexes catalog table) didn't equal the value of the 
nindexes column in systables.  You might try checking these figures for the
referenced table and update nindexes (carefully!  as informix) if necessary,
as you choked on the same line number that my case did.

fecat.ec is a tools library module which ends up in lib4gl.a.
Hope this helps.

>Neil S. Briscoe				Telephone: +44 252 376737
>System Administrator			Fax:       +44 252 376644
>                                        Email: neil@salmon.demon.co.uk
>                                               nbriscoe@cix.compulink.co.uk

--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

  Smith and Wesson: the Ultimate Point-and-Click User Interface.