HDTenEightyP/NetNews huggingface dataset:
From: dalk@login.dkuug.dk (Lars Kalsen)
Subject: PATHWORKS and I-Net
Organization: DKnet
Date: Sat, 21 Nov 1992 14:41:12 GMT

Hi out there,

We have a serious problem. WE are having build a client-server solution 
which use INFORMIX I-net on Windows Client workstations. We are running
DIGITALS PATHWORKS for PC-integration. 

Now it seems like INFORMIX I-Net and PATHWORKS cannot work together.
We have then to change to PC/TCP for PC-integration and that is a big
change.

Please E-mail to me if you have heard about solutions or have ideas.


Greetings from Denmark

Lars Kalsen


SONOFON GSM, Skelagervej 1, 9000 Aalborg, Denmark

+45-99-367000, +45-99-367070 (fax)


Newsgroups: comp.databases.informix
From: chris@metter.fmpmis.metter.com (Chris Mathes)
Subject: Re: tracking data changes (a request for advice/information)
Organization: Metters Industries, Inc.
Date: Wed, 18 Nov 1992 14:58:24 GMT

jgordon@ssf-sys.DHL.COM (Jim Gordon) writes:
>[I wrote:]
>>
>> 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 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.

Ok, but how do the triggers work conceptually?  Can you give me a general
example of how they are set up, and what they do?

>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.

The sales rep says no 5.01 in sight.  Does anyone out there (maybe someone
from INFORMIX) have even a wild guess of when we should start looking
for 5.01?  Years?  A few months (hope, hope)?

>Cheers - Jim

Thanks Jim.

-Chris
-- 
Chris Mathes, Metters Industries, Inc.      UUCP: {..!}uunet!metter!chris
Tel:(703)418-0323                           INET: chris@metter.fmpmis.metter.com
"The Tao of Programming flows far away and returns on the wind of morning."-TToP
From: jparker@hpbs2776.boi.hp.com (Jack Parker)
Newsgroups: comp.databases.informix
Subject: Re: Help with antique Xenix/Informix on Altos Z-80
Date: 20 Nov 1992 11:38:05 -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.1630>

> 
> > 985 runs with a 80186.  Xenix provided by Altos.
> 
> Post this to the net, please. The original poster will want to know.

Already mailed to him directly.  Somebody else (was it you?) suggested
it was an 80286.  My memory is dim on the subject, but the I do remember
working on a 986 in late 83 early 84 when they were brand new - I seem to
remember this being the, albeit shortlived, age of the '186.  It is
entirely possible that Altos turned around and changed it to an 80286, but 
Altos has a habit of upgrading a lot of things when they go to a new chip
and coming out with a totally new box for it.

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: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: No subject 
Reply-To: shemminga@cix.compulink.co.uk
Date: Mon, 23 Nov 1992 13:26:00 +0000

UPDATE BY NAME

I was wondering if anyone else thought that having and update by name
function (or insert by name) would be worth while. If enough did
could we get Informix to at least consider it as an option.

I often have to Insert/Update large tables, sometimes with the fields
effected "spread" throughout the record. It is often the case that
the THRU operator cannont be efficiently used because of the
seperation of the fields in the record.

If, when working in 4GL, I could just:

        DEFINE rec RECORD LIKE big_record
        .
        .
        .
        UPDATE big_record BY NAME
                SET rec.field_1, rec.field_10....

this would be much quicker.

On the face of it I can't see why it *couldn't* be done. All of the
existing restrictions would still apply and things like
UPDATE..SET..WHERE should still work.

What does the panel think?

--------------------------------------------------------------
| Who cares whos opinions these are?!                        |
| Send me mail and I'll love you forever (Maybe)             |
|------------------------------------------------------------|     
| Stuart Hemming       | shemminga@cix.compulink.co.uk       |
| Tudor Labels Ltd     | uunet!cix.compulink.co.uk!shemminga |
| Roman Bank Bourne    | Tel :  (+44) 778 426444             |
| Lincs PE10 9LQ. UK.  | Fax :  (+44) 778 421862             |
--------------------------------------------------------------


Stuart
|8-)
From: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
Newsgroups: comp.databases.informix
Subject: Re: your mail
Date: 23 Nov 1992 10:13:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1635>

} 
} In article <1eit8cINN5ta@emory.mathcs.emory.edu> you write:
} >> 
} >> In the good old days of SE, a table with a high level of activity
} >> (i.e. deletions/inserts) became riddled with old data row slots 
} >> which were available for re-write, and the index began to look like
} >> swiss cheese.  To correct this periodic unload/loads or cluster
} >> manipulation or ALTER TABLE (same as an unload/load but more user-friendly)
} >> were needed to keep index and data table efficiency at peak.
} >> 
} >> Is this also true of Online?  Or does Online do this automagically?
} >> 
} >Raw Online space does get very fragmented, especially if you are short
} >of room in the partition.  Table extents become very small and numerous
} >and it causes performance problems.  Tables can generally have about
} >240 extents, and it is possible to reach that value and come to a grinding
} >halt.  
} 
} Whoa!  Informix STRONGLY recommends that you try to keep the number of 
} extents at 8 or below to keep performance up.  I personally have seen
} performance begin to fall off when a table reaches more than 10 extents.
} Also, there is a limit to the number of extents per table (it is hard-
} ware and OS dependent -- for a Sun 4/470 running SunOS 4.1.1 and Online
} 4.1 the limit is 213) and if this is exceeded CORRUPTION will result.
} >
I agree *wholeheartedly*, and always try to keep my extents to a minimum.
I'm interested in your statement about corruption.  When we accidently 
exceeded the number of extents, I got errors returned, but I have not
seen corruption.  What have you experienced?

} >We regularly monitor all our production systems extents and partition
} >fragmention.  Tbunloading and tbloading the database back typically puts
} >all the data for each table in the first extent (if there is enough 
} >contiguous room).  We then carefully set all the next extents on the
} >tables, to accomodate future growth.  If tbunloading is unreasonable
} >because of the database size, we will create an empty new table, with
} >the first extent set, and copy the data from the old table to the
} >new table.
} >-- 


-- 
  Naomi Walker  (aka N7FSA)     naomi%anasaz.UUCP@asuvax.eas.asu.edu

  Enthusiasm is caught,         In tennis, 
  not taught.                   love means nothing.
Newsgroups: comp.databases.informix
From: chris@metter.fmpmis.metter.com (Chris Mathes)
Subject: tracking data changes (a request for advice/information)
Organization: Metters Industries, Inc.
Distribution: usa
Date: Tue, 17 Nov 1992 00:16:40 GMT

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:

1) Is this the best way to do what I want?
2) How would one monitor the logical log if one wanted to?
2a) Will it be extremely painful to get the information I want?
2b) Are there any library functions available for looking at logical logs, or
	will I have to parse tblog output?

You get the idea.

Oh, the system in question is an HP something-or-other (near top of the line)
running the most up to date versions of HP-UX and INFORMIX OnLine.  If you
guessed that the machine isn't here yet, you are right, although I do have all
of the INFORMIX manuals.  I need to get a head-start on this project, but I
don't have a machine to play with to see if I am headed in the right direction,
so any suggestions or pointers will be very much appreciated.

Thanks,

Chris

*I don't need to know before and after values, just what column(s) changed, and
what their current values are.
-- 
Chris Mathes, Metters Industries, Inc.      UUCP: {..!}uunet!metter!chris
Tel:(703)418-0323                           INET: chris@metter.fmpmis.metter.com
"The Tao of Programming flows far away and returns on the wind of morning."-TToP
From: clay@panix.com (Clay Irving)
Newsgroups: comp.databases.informix
Subject: Row locks
Date: 17 Nov 92 04:15:50 GMT
Article-I.D.: panix.1992Nov17.041550.11286
Organization: PANIX Public Access Unix, NYC

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
--
Newsgroups: comp.databases
From: dtodd@titan.ucc.umass.edu (David M. Todd)
Subject: Revelation ghost files after tradeup
Organization: University of Massachusetts, Amherst
Date: Sun, 22 Nov 1992 13:14:59 GMT


During a tradeup from 1.16 to 3.0 one upgrade of a directory/location
bombed, leaving what I assume were temporary files in the following
format:  DICT.CASES.91226  Some of these were able to be deleted, but
several continue to show in LISTTABLES and reference real files on the
disk, but don't exist to DELETETABLE.  Suggestions?


|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ David M. Todd ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
|Department of Psychology, University of Massachusetts, Amherst, MA 01003 USA|
|Phone: 413/545-0158 ___ <DTodd@Titan.ucc.UMass.EDU> _____  Fax: 413/545-0996|
Newsgroups: comp.databases
From: cpetersn@iastate.edu (Clifton R Peterson)
Subject: Re: AREV MULTIVALUE Symbolics
Keywords: AREV MULTIVALUE SYMBOLIC
Organization: Iowa State University, Ames IA
Date: Sun, 22 Nov 1992 22:54:59 GMT

In <By4G07.1Jq@nic.umass.edu> dtodd@titan.ucc.umass.edu (David M. Todd) writes:

>In article <cpetersn.722406918@vincent2.iastate.edu> cpetersn@iastate.edu (Clifton R Peterson) writes:
>>This should be as simple as using the following oconv[ersion]
>>
>>"MD02" 
>>
>>which displays zero decimal points but divides the number by 100 before
>>applying the zero decimal place rule.
>>
>>Clif

>Right you are--almost.  Should be "MD20".  And it does work on
>multivalues.  I remember struggling with "scale" (the last digit in
>the conversion) when I was trying to figure out how to round off
>numbers.  I never figured out that 0 would maintain the decimal
>position from the original value.  This is such a common operation
>that it should at least be clearly and explicitly documented and
>indexed.

No, It should be MD02.  You are right that the last digit is the scale which
is the power of 10 to divide the data by before displaying it.  I did some
testing just after putting this message up and got the following

msg(oconv(123456,"MD02"))       => 1235
msg(oconv(123449,"MD02"))	=> 1234

At least, if I remember right, the problem was displaying DOLLARS type
data rounded up to the nearest dollar or using MD0 without having to do
the non-rounding divide of the data first.

>Thanks Clif.  I can simplify some of my routines now.

Glad I could be of help.  By the way, my code checking was in 3.01, so maybe
it's different in the older version?  <g>  I've never actually used this
functionality in code yet, but it just came to me when I saw the solutions
that showed a loop in a symbolic.

>|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ David M. Todd ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
>|Department of Psychology, University of Massachusetts, Amherst, MA 01003 USA|
>|Phone: 413/545-0158 ___ <DTodd@Titan.ucc.UMass.EDU> _____  Fax: 413/545-0996|
-- 
 _________________________________________________________________________
/ Clifton R. Peterson    1108 Burnett		(515)232-5254	    	  \
| B.S. Chem E            Ames IA  50010                                   |
\_______________"42"_is_one_hell_of_an_answer!!___________________________/
Newsgroups: comp.databases
From: John_Borchert@mindlink.bc.ca (John Borchert)
Subject: Foxpro mailing list
Organization: MIND LINK! - British Columbia, Canada
Date: Fri, 20 Nov 1992 17:50:15 GMT

Can someone give me the internet address of the Foxpro mailing list?  Thanks.

--
-----------------------------------------------------------------------------
John Borchert                   | Internet : John_Borchert@mindlink.bc.ca
Sierra Systems Consultants Inc. | Voice    : (604) 688-9069
Vancouver, BC Canada            | FAX      : (604) 688-8986
-----------------------------------------------------------------------------
-
Newsgroups: comp.databases
From: dtodd@titan.ucc.umass.edu (David M. Todd)
Subject: Transferring traded-up Arev application to new system
Organization: University of Massachusetts, Amherst
Date: Sat, 21 Nov 1992 13:08:13 GMT

I'm traded up a ARev 1.16 application to 3.0 and now I am going to
install the application at a new site where they have just bought 3.0.
To run correctly, the new site will have to have access to the
conversion routines that are included in the trade-up version, e.g.
attempting to convert periods in column or table names to underscores,
and some aliases for old table names.

I once saw a suggestion to move a complex application in the following
way:

1)  Copy the entire system to the new machine (including all the ARev
system files).

2)  Replace the old arev.exe file with the arev.exe file from the new
system to put the new serial number (and network counter) in effect.

Does this work?  Can this be accomplished just by replacing this one
file?


|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ David M. Todd ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
|Department of Psychology, University of Massachusetts, Amherst, MA 01003 USA|
|Phone: 413/545-0158 ___ <DTodd@Titan.ucc.UMass.EDU> _____  Fax: 413/545-0996|
Newsgroups: comp.databases
From: rgams@magnus.acs.ohio-state.edu (Richard A Gams)
Subject: Re: Which one to choose - Pioneer, DB Vista or Databoss 3.5??
Organization: The Ohio State University
Date: Wed, 18 Nov 1992 17:11:28 GMT

In article <1992Nov15.222503.27187@research.nj.nec.com> shm@syl.nj.nec.com writ
es:
>I need to implement a small relational in Windows 3.1 in a very short time
>period.  Since FoxPro 2.5 is not out yet, I am looking at Pioneer's Packages
>that go with VB Pro. I am also looking at brotures of Databoss 3.5 and DB
>vista in which I have no experience. Could someone share their experience
>with Databoss and DB vista or pass any suggestions please?
>

dv_Vista, now known as Raima Data Manager is "networked" model data base 
manager which links records in Owner-Member set relationships.  Since it 
doesn't require (but incidentally allows) relational links through Primary and 
Foreign keys, it yields databases that are more compact and faster than ISAM 
style "relational" models.  The downside is a fairly steep learning curve.  
WHen I'm allowed to choose my own tool, my choice is Raima.

-- Dick
Xref: sparky comp.databases:7880 aus.general:2218
Newsgroups: comp.databases,aus.general,melb.seminars,latrobe.general,pgrds,staff,rsch,hons,csiii,diploma,guests
Subject: Seminar
From: deborah@latcs1.lat.oz.au (Deborah Hewitt)
Date: Mon, 16 Nov 1992 00:45:20 GMT
Distribution: melb
Organization: Comp Sci, La Trobe Uni, Australia

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                          LA TROBE UNIVERSITY
          DEPARTMENT OF COMPUTER SCIENCE & COMPUTER ENGINEERING
                             PUBLIC SEMINAR
                                  AND
                  APPLIED COMPUTING RESEARCH INSTITUTE
                             JOINT SEMINAR

SPEAKER:	Professor Robert Meersman
		Director, INFOLAB, University of Tilburg, Nederland
		Chairman IFIP Working Group on Databases and
		IFIP Technical Committee on Artificial Intelligence

TOPIC:		Recent Developments in Information Modelling and
		Computer Aided Software Engineering

ONE DAY SEMINAR

COURSE OUTLINE:
Topics to be covered include: comparison of information modelling systems
including entity relationship, semantic data modelling, NIAM, object oriented
relational data models, RIDL and RIDL*, and computer aided software engineering.

WHEN:
Monday, 23 November 1992, 9.00 am to 5.00 pm.

VENUE:
Glenn College Lecture Thatre, La Trobe University, Bundoora 3083

COST:
The fee for the course is $350 and includes written materials, use of
software and hardware and refreshments.  Postgraduates and unemployed 
persons will be charged $150.

If you are interested in attending please contact:
Deborah Hewitt
Applied Computing Research Institute
Department of Computer Science and Computer Engineering
La Trobe University
Bundoora 3083
Telephone 479 2598
Fax       470 4915

                              ~~~~~~~~~~~~
From: ch966@cleveland.Freenet.Edu (Jose M. Febus)
Newsgroups: comp.databases
Subject: Report Generator...
Date: 18 Nov 1992 14:12:36 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


Hi...
	I am a clipper 5.01a programmer and i am tried of
beaing coding LONG, LONG, LONG reports. Please let me know
if there is a program that can create reports sources or a
library to help me.

	Thanks...
-- 
	Jose Febus
	"Drinking at Yagrumo"
From: mgum@OAVAX.CSUCHICO.EDU (MARK GUM)
Newsgroups: comp.databases
Subject: Ride-Share Database
Date: 16 Nov 92 21:48:27 GMT
Reply-To: mgum@OAVAX.CSUCHICO.EDU
Organization: California State University, Chico
NNTP-Posting-Host: oavax.csuchico.edu

Hello;
  Does anyone know of a Ride-Share database package that works on Xenix.
Please respond to this message or send E-Mail to MGUM@OAVAX.CSUCHICO.EDU
Thanks.

**********************************************************
MARK GUM, CALIFORNIA STATE UNIVERSITY, CHICO
MGUM@OAVAX.CSUCHICO.EDU
From: elgaard@diku.dk (Niels Elgaard Larsen)
Newsgroups: comp.databases
Subject: Re: Normalizing 2NF -> 3NF
Date: 15 Nov 92 22:38:25 GMT
Organization: Department of Computer Science, U of Copenhagen

bonak@herky.cs.uiowa.edu (Esmail Bonakdarian) writes:

>E.g., given a relation with three attributes, A, B, and C, where
>attribute A is the PK, the following dependencies exist:

>+----+-----+----+
>| A* |  B  | C  |
>+----+-----+----+

>   A -> B
>        B -> C

>i.e, A determines B, and B in turn determines C.

>3NF would split this up into two relations:

>+----+-----+
>| A* |  B  |
>+----+-----+
>            and

>+----+----+            +----+----+
>| A* | C  |    OR      | B* | C  |
>+----+----+            +----+----+

>Which of these two latter relations is the "correct" one according to
>the theory? Or does it always depend on the given semantics of the data
>being modeled? It seems to me that I've seen both.

Both are correct since both (A,C) and (B,C) are on 3NF. That does of course
not mean that they are equally good. Depends on the queries on the database.  

>Could somebody please clear this up form me? Also, any references to
>material/articles (both on/off the net) that explain the normalization
>process clearly would be much appreciated.

@book{Date90,
	author = "C. J. Date",
	title  = "An Introduction to Database Systems",
	publisher = "Addison-Wesley",
	year = "1990",
        volume = "I",
	edition = "5"
	}
-- 
         Niels Elgaard Larsen          
         Institute of Computer Science,        
         University of Copenhagen      
         E-mail: elgaard@diku.dk
From: mallen@carla.Wichita (mallen)
Newsgroups: comp.databases
Subject: GUPTA'S SQLWINDOWS
Keywords: comp.database
Date: 23 Nov 92 05:46:35 GMT
Organization: wichita

Does anyone know of a way to scroll picture objects in SQLWINDOWS.  Please
email me directly.

Thanks in advance


Mark Allen   mallen@carla!ncrwic!ncrlnk!{uunet}.. 
Newsgroups: comp.databases
From: mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney)
Newsgroups: comp.databases
Subject: Re: Ingres questions followup
Keywords: byte
Date: 18 Nov 92 16:32:30 GMT
Article-I.D.: usenet.Bxx7A7.7xL
Organization: Indiana University, Bloomington

In article <5854@osc.COM> Joe Keane <jgk@osc.com> writes:
>In article <BxLBKH.2w0@usenet.ucs.indiana.edu>
>mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney) writes:
>>Traditionally, files under VMS are limited to 65534 byte records.  That's
>>because for normal variable length record files, the record length is stored
>>in the two bytes before the record.
>
>That is so dumb.  What kind of operating system is it?  It looks like a C-64.
>I mean, sometimes you can get away with using less bytes if you're clever.
>But having variable-length fields break when you get to 64KB is unacceptable.

So don't use them.  VMS doesn't make you.

BTW, it has nothing to do with the OS.  RMS is basically a separate entity
(a *record* manager) built on the file system.

	Darrin
-- 

mdchaney@iubacs mdchaney@bronze.ucs.indiana.edu mdchaney@rose.ucs.indiana.edu

"I want- I need- to live, to see it all..."
Newsgroups: comp.databases