HDTenEightyP/NetNews huggingface dataset:
From: widener!uunet.UU.NET!mic0!eric@emory.mathcs.emory.edu (Eric Lukas MIC-Atlanta)
Newsgroups: comp.databases.informix
Subject: Informix and FourGen CASE Tools for Sale
Date: 5 Nov 1992 14:33:08 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: widener!uunet.UU.NET!mic0!eric@emory.mathcs.emory.edu (Eric Lukas MIC-Atlanta)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1568>

This message is posted for a friend of mine:

For Sale:

Informix Version 4.1 for SCO Unix including paid up maintenance
through 5/14/93. Originally paid $4,590 and willing to negotiate
sale price. Software in 3.5" diskette format. Software and
all documentaiton in its original Informix shipping containers,
unopened.
 Includes:

-Informix SE Development Version
-Informix SQL Development Version
-Informix 4GL RDS Development Version
-Informix Interactive Debugger

Also FourGen CASE Tools for SCO Unix including maintenance through
4/24/93. In 3.5' diskette format. Originally paid $5,599.10 for it.
Includes:

-Version 4.01 Screen painter for SCO Unix
-Version 4.01 Menu for SCO Unix
both are paid up maintenance through 4/24/93.

Contact:

Michael Leahy
Tempus Systems
875 Old Roswell Rd., Suite D-300
Roswell, GA  30076
Tel:  404-587-4904
Fax:  404-594-7174

-- 
Newsgroups: comp.databases.informix
From: IMAGING.CLUB@OFFICE.WANG.COM ("Imaging Club")
Subject: Re: Wang "Technetron '92 storms Boston"
Organization: Mail to News Gateway at Wang Labs
Date: Fri, 6 Nov 1992 22:01:48 GMT

Regarding the interest in attending this RDBMS seminar, I called
up the organizers of the half-day seminar sponsored by the
Americas PACE special interest group.  (Tel. 708-652-3888)
They indicate that for people attending the full $995 conference,
this seminar is $200 and for other people it is $350.  It
starts at 1:30 PM and goes through 5:00.  The events are taking
place at the Sheraton Boston Hotel & Towers.

                       Wang in the News...
         The Independent Newspaper for WANG Computer Users

                 Technetron '92 storms Boston

RELATIONAL DBMS,
open systems
key topics

An in-depth three-hour exploration of relational database
theory and practice by the relational model guru, Chris Date,
headlines Technetron/Pace '92 in Boston Nov. 9-12, but that's
not the only hot topic.  The keynote address by Wang CEO Rick
Miller may eclipse the database presentation in importance for IS
managers....

Michael.Willett@OFFICE.Wang.com
From: gaukur@rhi.hi.is (Kristjan Gaukur Kristjansson)
Newsgroups: comp.databases.informix
Subject: defer interrupt.
Date: 6 Nov 92 18:33:12 GMT

I'm currently trying to figure out how to properly use 'defer interrupt'
and 'options sql interrupt on' to stop sql queries.

I know I have to check on int_flag everywhere but when I try to use it
with 'foreach' loops then I don't seem to have much control over when
it's detected.

Are there any guidelines out there on the best use of this feature or
something that helps me better to understand this.
(F.ex. should I rather use open,fetch,close than foreach.  Shall I use it
after every possible SQL-statement or just some.)


				With thanks in advance,

					Kristjan Gaukur Kristjansson
					gaukur@rhi.hi.is
From: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
Newsgroups: comp.databases.informix
Subject: Gateway OK.
Date: 10 Nov 1992 16:13:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1582>

TO: Walt Hultgren, Emory University

Walt,

No need to pass my message any further.  Everything now works fine.

Thanks very much for your quick response.  And thank you for providing
this medium for the Informix Users, the mail may be frustrating at times,
BUT nowhere near the frustration of Informix without everyones help.  Even
the Informix Inc. Staff.



					Michael S. Gordon
					Foreman, Gyroscope Section
					Avionics Division 

 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 *                                                                           *
 *  Michael Gordon                           Sacramento Army Depot           *
 *  Foreman, Gyroscope Section               Directorate For Maintenance     *
 *  E-Mail: maint72@saad-emh1.army.mil       Attn: SDSSA-MAV-320             *
 *  DSN:    839-2367                         Michael S. Gordon               *
 *  Comm.:  (916) 388-2367                   Sacramento, CA 96813-5036       *
 *                                                                           *
 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
From: johnl@obelix.informix.com (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  ISOLATION LEVEL...
Date: 12 Nov 1992 05:28:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: johnl@obelix.informix.com (Jonathan Leffler)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1589>

>From: uunet!sam.amgen.com!chriss (Chris Silvester)
>Subject: ISOLATION LEVEL...
>Date: Tue, 10 Nov 1992 00:29:58 GMT
>X-Informix-List-Id: <news.2099>

>I'm working with 4gl and Online and I was wondering if there is any internal
>variable that indicates the current isolation level, or some other way of
>checking the current isolation level.  Any help would be appreciated.

To the best of my knowledge, no.

Of course, you could arrange to have a subroutine which you called which set
isolation levels, and stoed the current value.  Yu could have a second routine
to ask for the current level.  And, provided you always used it to set the
isolation level, you could always find out what the current level is.
But you can't find out except by some such devious means.

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: defer interrupt
Date: 9 Nov 1992 19:43:07 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: dave.snyder@snide.com (Dave Snyder)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1578>

Quoting Kristjan Gaukur Kristjansson...
} 
} I'm currently trying to figure out how to properly use 'defer interrupt'
} and 'options sql interrupt on' to stop sql queries.
} 
} I know I have to check on int_flag everywhere but when I try to use it
} with 'foreach' loops then I don't seem to have much control over when
} it's detected.
} 
} Are there any guidelines out there on the best use of this feature or
} something that helps me better to understand this.
} (F.ex. should I rather use open,fetch,close than foreach.  Shall I use it
} after every possible SQL-statement or just some.)
} 
This is how I write my query functions.  It seems to work pretty good too.

Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip
FUNCTION qry_address()
    DEFINE  q_txt CHAR(512)
    DEFINE  w_rowid INTEGER

    DISPLAY "QUERY:  ESCAPE queries.  INTERRUPT discards query.  ARROW keys move cursor.", "" AT 1,1
    DISPLAY "Searches the active database table.", "" AT 2,1
    MESSAGE ""

    CLEAR FORM
    LET int_flag = FALSE
    CONSTRUCT BY NAME q_txt ON address.* HELP 2

    IF int_flag THEN
        RETURN
    END IF

    LET q_txt = "SELECT address.ROWID FROM address WHERE ", q_txt CLIPPED

    WHENEVER ERROR CONTINUE
    OPTIONS SQL INTERRUPT ON
    MESSAGE "Searching ..."

    PREPARE q_sid FROM q_txt
    IF STATUS THEN
        CALL err_print(STATUS)
        OPTIONS SQL INTERRUPT OFF
        RETURN
    END IF

    DECLARE q_curs CURSOR FOR q_sid
    IF STATUS THEN
        CALL err_print(STATUS)
        OPTIONS SQL INTERRUPT OFF
        RETURN
    END IF

    LET q_cnt = 0
    FOREACH q_curs INTO w_rowid
        LET q_cnt = q_cnt + 1
        IF s_rowid_s(q_cnt) != 0 THEN
            ERROR " Memory allocation error, out of memory  "
            OPTIONS SQL INTERRUPT OFF
            RETURN
        END IF
        CALL w_rowid_s(q_cnt, w_rowid)

        IF int_flag THEN
            EXIT FOREACH
        END IF
    END FOREACH

    OPTIONS SQL INTERRUPT OFF
    WHENEVER ERROR STOP

    MESSAGE ""
    IF int_flag THEN
        ERROR " Statement interrupted by user  "
        SLEEP 1
    END IF

    IF q_cnt = 0 THEN
        ERROR " There are no rows satisfying the conditions  "
        LET q_cur = 0
    ELSE
        MESSAGE q_cnt, " rows(s) found"
        LET q_cur = 1
    END IF
END FUNCTION


Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Triggers in Informix?
Date: 5 Nov 92 17:13:59 GMT
Organization: Informix Software, Inc.

Ian Franklin writes:
>>Current release plans I believe (take this with a grain of salt, please) 
>>call for
>>a trigger implementation in a future Informix release (6.0, 7.0, ???).
>>
>I heard that a version of 5 was comming out in a few weeks for
>trigger but am not to sure hiw reliable that is.

Release 5.01 of Informix servers will include support of triggers.  This
release is due on major platforms before the end of the year (1992).  See
your local sales rep for a more specifi date for your plaform.

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Informix logs read-only queries? can't handle 'not-exists'?
Date: 13 Nov 92 17:05:08 GMT
Organization: Informix Software, Inc.

Ron Choi writes:
>>I agree wholeheartedly that a query should not corrupt the database.  What
>>exactly become corrupted and how?
>
>after i ran the query above the system could not restart (or recover).  that
>is, i tried to restart it using tbmonitor/mode/startup, but it spent over
>5 hours printing out "recovering. please wait...." message.  i had to restore
>the database from the tape.  i don't know what exactly got corrupted.  i 

While you could argue the definition of "corrupted", in this case your
database was not corrupted; your logs were full, thus the system being
stuck in recovery mode. 

Now, unless this happened due to a long transaction (LTX), you should be 
able to get around this by running a tbtape while the system is in
recovery mode (this works).  That will free up any logs possible and
allow recovery to continue, hopefully to completion.  If, however, an
active transaction spans all the logs, then recovery from tape is the
only alternative.

Dave

-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
From: raguayo@hpprdeb.HP.COM (Radames Aguayo Soto)
Date: Mon, 2 Nov 1992 14:13:48 GMT
Subject: Re: Database Backup
Organization: HP Puerto Rico Manufacturing Operation
Newsgroups: comp.databases.informix

How about this?

I am using Informix Online 5.0.  How I do automatic backups?  I mean from a
script that does the backup at nigth.

---
Radames Aguayo, Manufacturing Development Engineer
Hewlett Packard, Puerto Rico Manufacturing Operation

HP Telnet: 882-6445
Outside HP: (809) 882-6445

HPDESK: Radames AGUAYO/HP5600/00
Internet: raguayo@hpprdea.prd.hp.com
AT&T Mail: mhs!hp/pn=Radames_Aguayo/o=hp/ou=corp/ou=unix/ou=x400/dda.hpmext1=raguayo@hpprdea.prd.hp.com
From: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
Newsgroups: comp.databases.informix
Subject: Automatic Backups.
Date: 12 Nov 1992 13:58:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1597>

FOR: Radames Aguayo

Radames,

You did not state what operating system you have or what type of backup
you need to make.  Please enlighten us as to what your requirements are
for system and after hours backups.

Michael Gordon
Sacramento Army Depot
From: klonz@copper.denver.colorado.edu (K Lonz)
Newsgroups: comp.databases.informix
Subject: *** HELP - Index Locks are creating DEADLOCKS ***
Date: 7 Nov 92 14:50:31 GMT
Organization: University of Colorado at Denver


Subject: INDEX LOCKS are creating DEADLOCKS
         Index Lock conflicts

Background:

    We're running Informix 4.1 on an Amdahl UTS.
    We're enhancing and modifying a system which was originally
    developed and used on 2.1.

Problem Summary:

    We are experiencing a deadlock and subsequent abort with users
    who are adding/modifying data in the same table.  The table is indexed
    on sequential numbers.  The users are adding/modifying data records
    where the sequential numbers are close to each other.  We suspect that
    the indexes are using page locking - which is causing our problem.

    The error messages are ISAM 154 and isql -271, -245

Problem (Step-by-step):

    1.  User 1 begins a Multi-Statement Transaction (mst) which takes
        several minutes to perform, and navigates through several screens.

        Note: The (mst) modifies and adds data in a row-locked table,
              indexed on sequentially assigned integers.

    2.  User 1 acquires an index lock (in a transaction) which will
        last several more minutes.  (tbstat -u, flag 2 changes from B to T).

    3.  User 2 begins another (mst) to add/modify data in the same table.
        The record has the next sequential number (or a very close number).

    4.  User 2 attempts to do work but waits for the index lock to be freed
        up from User 1.  (The add/modify row is different)

    5.  User 2 aborts after the deadlock time limit is exceeded.

Desired Behavior:

    The users must be able to add/modify records without encountering
    the deadlocks.  We would like to retain the (mst)'s and not implement
    a major revision of the code.

Possible Answers:

    1.  Ignore the problem - obviously unacceptable.
    2.  Disable the indexes - :( - also unacceptable.
    3.  Rewrite application without (mst)'s - not enough time and
        undesirable at best.
    4.  Allocate integers non-sequentially in the hopes of not running
        into the page locks.  (We know - we're grasping!)


Can anyone help:

    1.  Most Importantly:
        Does someone have an alternative solution?

    2.  Do indexes use page locking exclusively or
        can indexes be 'tuned' to use row locking?

    3.  We know that solution #4 above is quirky, but we
        would like some feedback on it if there is any out
        there.

Thanks in advance!

-- 
Michael Klonecki                                     Life is a gift.
1391 S. Argonne Circle          
Aurora, CO  80017-4418                               Choose wisely what to 
klonz@copper.denver.colorado.edu                     do with your gift.
From: scottm@informix.com (A. Scott Myers SSE)
Newsgroups: comp.databases.informix
Subject: Re:  Updating with editing capability
Date: 11 Nov 1992 16:08:05 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: scottm@informix.com (A. Scott Myers SSE)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1587>

PERFORM allows for inserting and deleting of characters.  Typing CTRL A will
toggle in and out of insert mode.  Typing CTRL X will delete a single
character at a time.  Also, CTRL D will delete all characters to the end of
the field.

Help information pertaining to this can be brought up interactively while in
insert or update mode of PERFORM by typing CTRL W (the help key).

scottm (Scott Myers - Informix, Tampa)
-----------------------------------------------------------------------------
} From uunet!rmy.emory.edu!ilist Wed Nov 11 13:38:58 1992
} Received: from informix.com ([158.58.8.17]) by washington. (4.0/SMI-4.0)
} 	id AA20501; Wed, 11 Nov 92 13:38:53 EST
} Received: from uunet.UUCP by informix.com (4.1/SMI-4.1)
} 	id AA22064; Wed, 11 Nov 92 10:35:43 PST
} Received: from rmy.rmy.emory.edu by relay2.UU.NET with SMTP 
} 	(5.61/UUNET-internet-primary) id AA13705; Wed, 11 Nov 92 13:21:47 -0500
} Received: by
} 	rmy.rmy.emory.edu (5.65/Emory_rmy.3.3.20) via MAILPROG
} 	id AA00602 ; Wed, 11 Nov 92 13:23:18 -0500
} Return-Path: ilist@rmy.emory.edu
} From: uunet!thylacine.cs.wisc.edu!rchoi (Ron Choi)
} Message-Id: <1992Nov10.164807.7451@cs.wisc.edu>
} Subject: Updating with editing capability
} Date: 10 Nov 92 16:48:07 GMT
} Reply-To: uunet!thylacine.cs.wisc.edu!rchoi (Ron Choi)
} Organization: University of Wisconsin, Madison -- Computer Sciences Dept.
} Sender: uunet!rmy.emory.edu!informix-list-owner
} To: informix-list@rmy.emory.edu
} X-Informix-List-Id: <news.2101>
} Status: R
} 
} i've using perform for entering and updating records.  for updating,
} it would be nice if the user-interface supplies some sort of editing capability.
} only way one can update in perform is to type over the old entry.  can 
} we do better than that in 4gl or third-vendor user-interface?  in other words, 
} is there a way to insert characters and delete characters with out typing 
} over the original entry?
} 
} thanx in advance, 
} 
} -- 
} ---------------------------------------------------------------------------
} ron choi 				\\  #include <disclaimer.h>
} university of wisconsin, madison	\\
} 	"when i was your age, i walked ten miles to school, unarmed."
}
From: jerry@jerry.mendota.ingr.com (Jerry Jugovich)
Newsgroups: comp.databases.informix
Subject: Re: defer interupt
Date: 12 Nov 92 06:03:03 GMT
Article-I.D.: emory.1dtv7nINN5ra
Reply-To: jerry@jerry.mendota.ingr.com (Jerry Jugovich)
Distribution: world
Organization: Mailing List Gateway
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1592>


								Nov 12 92

Here is how I handle interupting screen reports by testing a variable in
the page trailer section of the report. I had the need to interupt long 
screen reports.

What I found was depending on the type of report by this a mean a single
pass report or a 2 pass report the placement of the call to c_waitcr()
was critical. If the report was a 2 pass report. By the way if you use
group by statements this is a 2 pass report. And the call also has to be 
placed in the group by clauses. 

function a_report_function()

	declare rep_cur cursor for select * from foo

	foreach rep_cur into rep_var.*		# global variable like foo #

  	    if rpt_c = 1 then
      	    	let rpt_c = 0
   	    	exit foreach
	    end if

	    output to report my_report ( rep_var.name ) # step into report #

	end foreach

        finish report my_report	                     # step into report finish #

end function

report my_report ( in_group )		# report using global variables  #
					# that were selected by a cursor #

                                        # must define variable even if passed # 
                                        # a global variable ugh....           #

define in_group like foo_table.foo_column 	

output
page length 22
left margin 0
right margin 132
top margin 0
bottom margin 0

format

page header
        print column 45,"THIS IS A PAGE HEADER",column 112,today

on every row

        print column 5, "* ", global_var CLIPPED

page trailer
    if rpt_c = 1 then 
        return 
    else
        call c_waitcr()
    end if

    clear screen
    display ""

before group of in_group
    if rpt_c = 1 then 
        return 
    else
        skip to top of page
    end if

end report

#     Function used to process all screen interupts #

function c_waitcr( )
    define
        rrwait  char( 1 )

    prompt "Press q to quit, any other key to continue.  "attribute(cyan)

           for char rrwait
               if ( rrwait matches "[qQ]" ) then
                   let rpt_c = 1
                   clear screen
                   return
               end if

           clear screen
           let rpt_c = 0
           return
end function


I used the debuger to follow a report. This is what worked for me.


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 Mail Path: jerry@jerry.mendota.ingr.com        Jerry Jugovich
 Phone:     612 681-4450                        TIM Application Engineer
                                                Intergraph Corporation
                                                Mendota Heights Minnesota
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
From: Root@letterkenn-emh1.army.mil
Newsgroups: comp.databases.informix
Subject: re: paul linton
Date: 12 Nov 1992 10:23:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: Root@letterkenn-emh1.army.mil
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1590>

Paul Linton writes he is "scared of what they can't see" re: using raw db
tape backups for on-line. I also agree, but have found every time I needed it
it was right there. We are using Turbo on a Unisys 5000, because our 
application programmers havent given us the go-ahead to go to On-Line. But
the db backup works reliably, regularly, etc. We have a dedicated tape drive.
All day the informix login is there writing Logical Logs out to it. At night,
the operator logs of the logger, and begins a full db backup to tapes using
that same drive. When done, the logger is back in use.

One undesirable side effect is that during the day, even if we log off the
logger, we cannot use that tape drive with cpio/tar etc. It always tells us
that shared memory has it tied up. So I assume because Turbo was brought to
multi-user mode with that device defined for its use, it wont let anyone else
use it. I hope On-Line will be more forgiving. 

I do agree that it would be nice to be able to "check" the readability of
tapes on another system, but so far no problem! Only problem we did have was
fixed when the tape drive was repaired.

Good luck!

Ann Barnes, Letterkenny Army Depot. Chambersburg, PA  17201
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: logfile format?
Date: 11 Nov 92 15:21:51 GMT
Organization: Informix Software, Inc.

paul linton writes:
>Does anyone have the format that the logfile for informix SE engine
>is in?

See the C-ISAM Programmer's Manual, Appendix D ppg 7-10.

>Also, is it something the changes from version to version?

The general format does not change, though new entries may be added when
features (such as new data types) are added.  There is no guarantee, though,
that it will *not* change in any future release.

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
From: jjolly@jjolly.b24b.ingr.com (Jack G. Jolly)
Subject: Backing up OE db files
Organization: Intergraph Corporation, Huntsville, AL.
Date: Fri, 6 Nov 1992 14:09:38 GMT

Is it necessary to back up the physical files associated with an
ONLINE db "outside of the environment"?

Consider "raw partitions" as well.

I always thought that backup of physical files was a necessity to
prevent against disk failure - that you would restore your old
files and apply the contents of saved transaction log files against
them to bring them up to date (at least that is how you're supposed
to do it with Oracle).

Does the "Archive" utility in tbmonitor eliminate the need to make copies
of the physical files??

JJ
-------------

  ^^^^^^^^^          Jack Jolly  @  jjolly@jjolly.b24b.ingr.com
 (| 0   - |)
  |   *   |             Intergraph Corporation, Huntsville AL
  \_______/                AEC Project Management Support