HDTenEightyP/NetNews huggingface dataset:
From: S.K.Quinn@massey.ac.nz (S.K. Quinn)
Subject: Is there an archive for this group
Keywords: tools performance
Organization: Massey University Computer Centre
Date: Tue, 15 Dec 92 21:42:49 GMT

I recall some traffic about bad tools performance due to a missing
index on one of the extended catalogs. Can anyone provide more light?

Alternatively, is there an archive of this group that I can search.

Stephen Quinn
Systems Programmer 
Computing Services
Massey University

Newsgroups: comp.databases.ingres
From: tmack@cbnewsd.cb.att.com (thomas.p.mack)
Subject: How store/access historical information
Organization: AT&T
Date: Tue, 15 Dec 1992 19:05:54 GMT
Keywords: time based data

We currently use Ingres release 5 and have a database to track system/network
configuration changes.  We now have a requirement to track/display
what a particular system or network looked like a specific point in time.
Has anyone produced a databases schema or know of papers on this topic that
can deal with this type a requests.  I found some papers on Postgres that
deals with this topic but the solution was built into the DBMS itself. 

The things we have come up with thus far have been a kludge.
Please send any comments/suggestions to att!ihspb!tmack

Thanks in advance!

-Tom Mack  AT&T Bell Laboratories att!ihspb!tmack  708-979-6125
From: bill@praxis.co.uk (William Walker)
Newsgroups: comp.databases.ingres
Subject: Re: Dynamic Sql and Ingres Report Writer
Date: 15 Dec 92 14:03:32 GMT
Organization: Praxis, Bath, U.K.


In article <1992Dec10.204230.5570@brtph560.bnr.ca> you write:
>
>I would like to know if it is possible to have dynamic SQL statements
>in a report specification.
>
>There are large number of tables and columns, and I would like to 
>be able to prepare the select statements. But is it possible to 
>mix dynamic sql and report writer? If so, how do you pass the select
>string to the report function?

Yes, it is possible to use dynamic sql in Ingres report writer although
I have never seen it documented.

You can use input variables as part of the from and where clause eg:

	select q,w,e
	from a, b, $input1
	where x = 1 and y = 2 and $input2


 input1 is simply the name of a table(s) and 

 input2 could be any part of a normal where clause eg: 
	"z = 3 and col2 is not null"

I have NEVER tried using variables for the select clause but I would
expect it to work in the same way.

These variables can be entered at run-time - Ingres will prompt for
each variable or you can pass them as arguments when you run the
report.  

When I used them, the user entered selection criteria on a screen and
the 'from' and 'where' clauses were then built up by the code and
passed to the report.

Alternatively, you could build up the whole report in the code, write
it to a .rw file and then run report writer against this file.

I hope this is some help.


Bill.

-------------------------------------------------------------------------------
      Bill Walker, Praxis plc, 20 Manvers Street, Bath BA1 1PX UK.
  The software enginering division of Touche Ross Management Consultants
Tel:	+44-225-444700.   Email:   bill@praxis.co.uk 	Fax: +44-225-465205
Newsgroups: comp.databases.ingres
From: gnat@stein.u.washington.edu (L Boyd)
Subject: Re: Verifying DB integrity
Organization: University of Washington
Distribution: usa
Date: Thu, 17 Dec 1992 20:59:17 GMT


I haven't been following this thread, but I think that an article in
December, 1992, DBMS magazine on referential integrity will give anyone
with questions an idea about what to do.

The article is written for Oracle DBAs, but the same concepts and considerations
apply to Ingres or any other RDBM.

Lauren

******************************************************************************
Lauren Boyd					Department of Otolaryngology
Systems Analyst/Programmer			University of Washington, RL-30
*Go Huskies*					Seattle, Washington  98195
******************************************************************************
Newsgroups: comp.databases.ingres
From: vnaik@gmuvax2.gmu.edu (Vikram Naik)
Subject: unsubscribe
Organization: National Radio Astronomy Observatory
Date: Fri, 18 Dec 1992 07:08:43 GMT

Hi,
Please unsubscribe this account from your list.

Thank you.

vnaik@gmuvax2.gmu.edu

Newsgroups: comp.databases.ingres
From: zamper@slc5 (Andreas Zamperoni)
Subject: Problems with 'FIELD' function in Windows4GL-Scripts
Organization: Department Of Mathematics and Computer Science
Date: Wed, 16 Dec 92 10:41:37 GMT

I have a problem with the class returned by the 'FIELD' function, causing
that I can't apply the method I want, because 'FIELD' returns another
class than expected/desired.

I have an 'EnumField' within a 'SubForm' within a 'TableField', and I want to
use 'ValueList.AddTextItem(...)' to manipulate the 'EnumField' (list) of a specific
row of my 'TableField'.

The command should be something like:

 FIELD (table[row].subform.enumfield).ValueList.AddTextItem(...)

but I get a message like "... ValueList is not a field of the specified class ...".
I looked in the manuals and I read that a command
 
 FIELD (tablefield[n].column) 

returns an object of class 'CellAttributes' and not - as I need - an object of 
class 'EnumField'. How can I add items to my list (maybe directly, using 
array-like notation, as I read in the manuals too, but which didn't work)?
 
Please e-mail me any suggestions for solutions. Thanks in advance,

 A. Zamperoni

o--------------------------------------------------------------------------o
|                           Andreas Zamperoni                              |
o-----------------------------------o--------------------------------------o
| Rijksuniversiteit te Leiden       |TNO Environmental and Energy Research |
| Department of Computer Science    lInstitute of Applied Geoscience       |
| Niels Bohrweg 1                   |Schoemakerstraat 97                   |
| P.O. Box 9512                     |P.O. Box 6012                         |
| 2300 RA Leiden                    |2600 JA Delft                         |
| The Netherlands                   |The Netherlands                       |
o-----------------------------------o--------------------------------------o
| email: zamper@rulwi.leidenuniv.nl | email: zamper@igg.tno.nl             |
| phone: *31 - (0)71 - 27 7103      | phone: *31 - (0)15 - 69 7720         |
| fax  : *31 - (0)71 - 27 6985      | fax  : *31 - (0)15 - 69 7193         |
o-----------------------------------o--------------------------------------o


Newsgroups: comp.databases.ingres
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re: Windows 4GL vs. ESQL interfaces
News-Software: VAX/VMS VNEWS 1.4-b1  
Keywords: ESQL, Windows 4GL, database interface.
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Date: Wed, 16 Dec 1992 01:10:00 GMT

In article <1gkudhINNalc@hayaku.protocol.zycad.com>, dominick@protocol.zycad.com writes...

	(stuff deleted)

>I may be true that Inges Windows/4GL is tied (heavily) to the GUI, but for 
>someone who needs to rapidly develop an X based database application it's 
>probably the best way to go.  I've also found it to be a good way to
>rapid prototype an application (you get functional windows very quickly).
>However, given enough time and money, I would have to say I would develop
>my application using ESQL/C and and a good GUI development package.  I think
>(IMHO) the later would produce a much more maintainable application 
>than one written in W4gl.

You start by saying how good W4GL is, and then you say you'd rather not use it.
Could you expand on why you end up with that conclusion?

Bill Thompson
From: steve.silverwood@filebank.cts.com (Steve Silverwood)
Newsgroups: comp.databases
Subject: CA-ASPEN
Date: 17 Dec 92 12:43:00 GMT
Reply-To: steve.silverwood@filebank.cts.com (Steve Silverwood)
Organization: The File Bank BBS - Fallbrook, CA  619-728-4318


 >From: ch966@cleveland.Freenet.Edu (Jose M. Febus)
 >Newsgroups: comp.databases
 >Subject: CA-ASPEN
 >Date: 23 Nov 1992 13:31:02 GMT
 >Message-ID: <1eqmemINN8b5@usenet.INS.CWRU.Edu>
 >
 >
 >Hi...
 >	I want to know some info about CA-ASPEN i am plannig to buy
 >Clipper 5.01, but i want to be sure that i won't lose my money...
 >Thanks...
 >--
 >	Jose Febus
 >	"Drinking at Yagrumo"

Jose:

"Aspen" is the code name for the project that will hit the shelves as
"CA-Visual Objects for Clipper."  FYI.

I don't have much information about the product in terms of
specifications, etc., as it's still not yet in beta, but I will be
happy to send you a copy of the Statement of Direction, which spells
out in general terms what the plans are for the Xbase line of products
at CA.  Drop me a note at 76703.3035@compuserve.com with your USPS
mailing address and I'll send it off to you.

//Steve//

/----------------------------+---------------------------------------\
|Steve Silverwood            |  Internet: 76703.3035@compuserve.com  |
|Computer Associates         |CompuServe: 76703,3035                 |
|300 Corporate Point, 2nd Fl.|     Voice: (310)348-4448              |
|Culver City, CA  90230      |       FAX: (310)348-7701              |
+----------------------------+---------------------------------------+
|The opinions expressed here are solely my own, mainly because nobody|
|else would want them....                                            |
\--------------------------------------------------------------------/

   
Newsgroups: comp.databases
From: ntruelove@aardvark.ucs.uoknor.edu (STEP OUT OF THE CAR PLEASE)
Subject: Showdialog Buttons on Forms
Originator: usenet@midway.ecn.uoknor.edu
Date: Tue, 15 Dec 1992 19:09:00 GMT
News-Software: VAX/VMS VNEWS 1.41    
Organization: University of Oklahoma - University Computing Services

Has anyone else gotten fed up with Paradox40's decision to make ShowDialog a
stricly modal function, ie you must select an item in the ShowDialog Box before
returning to the workspace.

I have found a simple solution - put the buttons on your forms.  By creating
colored buttons in the same locations on every form, if you trap for mouse
events to the window coordinates of the buttons using Localizevent in your
global-waitproc you essentially have buttons on your forms that can be used at
any time.  The process is fairly straightforward and simple.

I made a Pg-up button, a Pg-dn button, and a condensed-view button on every
form in my latest application.  ;-)


Naren    

P.S. - Could someone explain again why CoEdit is so much better than Edit?  I
       missed the point.
From: thamilto@fnugget.intel.com (Tony Hamilton)
Newsgroups: comp.databases
Subject: dBase IV for Unix
Date: 12 Dec 92 00:41:18 GMT
Organization: INTEL.FOLSOM

Does anyone know if Borland plans to release dBase IV v1.5 for Unix? We are
currently running v1.1 on Unix (AIX), and 1.5 on DOS, and would like to get
1.5 for Unix as soon as possible.

Tony Hamilton
thamilto@pcocd2.intel.com
Newsgroups: comp.databases
From: dporter@rat.csc.calpoly.edu (Diana Porter)
Subject: Paradox vs. Access
Date: Sun, 13 Dec 92 21:15:39 GMT
Organization: The Rat's Nest
Distribution: us

I have been Beta testing both Access and Paradox for Windows and here's
my initial impressions - I'd be interested in hearing other's comments or
corrections if I am wrong...


Access's strength is in it's ease of use. Wizards, Cue Cards and the Graphical
QBE stand out.  But you begin noticing Accesss's weaknesses once you go beyond
simple database creation and begin some advanced application development. My
guess is that Microsoft wanted to get Access out the door before Paradox/Win
and on people's desktops (hence the $99 bait).  I'm hoping that Microsoft will
work on the language and developer's issues in future upgrades and add more
Wizards for end users.  Specifically what I don't like is that you call a
macro from a button (with few options: On Push...etc) and then you have to
go to the macros section to write the macro. Not the object oriented feel
I would have liked to see. The language is lacking fundatmental things...you
do not have a Create Table or Drop Table statement -- it must be done in the
interface.  This is a severe limitation for a module which needs to create
and drop temporary tables. Access has a 4MB transaction limit (meaning that 
if you have a transaction that requires more than 4MB, forget it.)  We 
came across this testing a global replace on a text field with a 100,000
row table). With ODBC (as it is now) you must create your
table in Access and then export to SQL Server -- you cannot create a table
on SQL Server via Access directly.  We're beginning our performance tests
of the products, but my guess is that Access will be slower.  Also, I still
don't understand why everything is bundled into one .MDB file - reminds me
of R:Base and the corruption problems we had. I hope I'm wrong about this
with Access, but we'll be testing the reliability as well.

Borland has really done their homework with Paradox/Windows and ObjectPal.
The developer can really create some awesome applications. Lots of events
(methods) to choose from and there is a definite OO feel to this application.
Since Pdox/Win is not out yet, I'll just give an overview of my impressions
without too much detail but the areas that need definite improvement is the
QBE!  Access is outstanding in comparison. Borland needs to focus on the
ease of use and beef up the QBE. If they do that over the next upgrades, I
see Paradox/Win as a really full database application environment. IDAPI is
their equivalent to ODBC and proposed as a SAG CLI. Anyone have more info
on IDAPI vs ODBC? IDAPI apparently addresses a navigational data access 
method wheras ODBC doesn't (?)  Overall, I like Paradox except for beginning
users and simple applications, Access wins. 

Anyway, in summary I see that one product excels where the other doesn't.
I'm waiting for Pdox/Win to come out before jumping into Access just 
because they came out earlier. Borland has quite a competitor now, though....

I'm interested in any thoughts others have on this topic....

Diana Porter
Cal Poly State University
San Luis Obispo, California
From: dhunt@infocom.UUCP (David Hunt)
Newsgroups: comp.databases
Subject: Public Domain or Shareware
Date: 11 Dec 92 23:01:26 GMT
Organization: INFOCOM Public Unix Server, +44 [0] 734 340055
X-Newsreader: TIN [version 1.1 PL7]


Hi Netters,


I am looking for a good Relational Database to run on System V Release 3.xx, 
which is relatively easy to use/grasp and that is well documented, 
preferably it should be Shareware which has good support through its author, 
but unsupported Public Domain programs will also suffice if they fit the 
bill.

Any help or information can be emailed to save on bandwidth (I will 
summarize for the net)

Regards and festive greetings
--
dhunt
Newsgroups: comp.databases
From: derek@pooky.cs.mun.ca (Derek Gould)
Subject: Re: dBASE IV color attributes
Keywords: DBASE
Organization: CS Dept., Memorial University of Newfoundland
Date: Thu, 17 Dec 1992 17:34:38 GMT

In article <1992Dec10.182521.18077@polaris.utu.fi> arto@polaris.utu.fi (Arto Bothas) writes:
>
>Hi,
>
>Is there any way to change color attributes of FMT files in dBASE IV
>runtime environment?

You have a file (likely in the dBASE subdirectory) called CONFIG.DB. In this
file you will notice color settings for the standard screen colors, which can
be changed. FoxPro gets around this by using defined color sets, which are much
easier to work with.>

You may distribute the runtime library with your applications if desired. 
Check the runtime sectino in the manual for more information.
From: steve.silverwood@filebank.cts.com (Steve Silverwood)
Newsgroups: comp.databases
Subject: DBase IV memo field quest
Date: 17 Dec 92 12:43:00 GMT
Reply-To: steve.silverwood@filebank.cts.com (Steve Silverwood)
Organization: The File Bank BBS - Fallbrook, CA  619-728-4318


 >Newsgroups: comp.databases
 >Subject: DBase IV memo field question
 >Message-ID: <1992Dec1.094950.3967@mcl.saic.com>
 >From: pcohen@mcl.saic.com
 >Date: 1 Dec 92 09:49:50 EDT
 >
 >Greetings:
 >
 >Is it possible to import ASCII text into a "memo" field ?  The manual says no
 >but someone told me it is possible.  Please send your replies to me directly.
 >
 >Thanks for your help
 >
 >--
 >-------------------------------------------------------------
 >|    SAIC                               PETER M. COHEN      |
 >|    (703)749-5989                 pcohen@cseic.saic.com    |
 >-------------------------------------------------------------

Yes, it is possible.  See the APPEND MEMO command in the dBASE IV
language reference manual.

//Steve//

/----------------------------+---------------------------------------\
|Steve Silverwood            |  Internet: 76703.3035@compuserve.com  |
|Computer Associates         |CompuServe: 76703,3035                 |
|300 Corporate Point, 2nd Fl.|     Voice: (310)348-4448              |
|Culver City, CA  90230      |       FAX: (310)348-7701              |
+----------------------------+---------------------------------------+
|The opinions expressed here are solely my own, mainly because nobody|
|else would want them....                                            |
\--------------------------------------------------------------------/
From: bernard@cpio1.fr.mugnet.org (Bernard Fouche)
Newsgroups: comp.databases
Subject: Seeking EMPRESS distributor or alternative solution
Date: 16 Dec 92 13:34:05 GMT
Organization: CPIO S.A.


My company is using the EMPRESS RDBMS for 3 years. Technically, we are
rather happy with it. Unfortunately, we are suffering from the
commercial policy of the French distributor :

1) the price of the runtime was multiplied by 3 in 2 years (!). So our
price policy (our products are based on EMPRESS) can not continue
any more the way it is now.

2) It seems impossible to make them understand than a $4000 (!)
difference (end user prices) between a 386 and 486 version is stupid
in 1992: the price difference between two systems of this kind can be
of $500 and the user will understand to pay $500 more to a computer
manufacturer to have a quicker system with a different processor.
However, having to pay $4000 more to EMPRESS to use the same binary
distribution coming from the same tape now make the gap between a 386
and a 486, a $4500 jump!  Anyway, who now buy a 386 to run a RDBMS ???

I can't stand this short term strategy ("let's pump money as much as
we can and those who do not like the way we do it can go to hell").

So I'm desperately seeking a foreign (i.e.: non-French!) EMPRESS
distributor with a better understanding of the market to solve these
problems or a product conceptually near from EMPRESS (especially the C
interface as we do not use the 4GL at all). We don't need any technical
support as we will change of version only to have some EMPRESS bugs
corrected and we know well the product.

I hope that Microsoft, Borland and others will soon come to this market
to shake it a bit.

Any hint or help welcome !
-- 
--------------------------------------------------------------------------
Bernard Fouche  VOX   : +(33) (1) 48.04.56.30  FAX :  (33) (1) 48.04.98.95
Email : bernard@cpio1.fr.mugnet.org
Postal Mail : CPIO S.A., 13-15 Rue de la Verrerie, 75004 Paris, France
Newsgroups: comp.databases
From: francois@welchgate.welch.jhu.edu (Francois Schiettecatte)
Subject: Paradox 4.0 information
Organization: Johns Hopkins Univ. Welch Medical Library
Date: Fri, 18 Dec 1992 13:21:10 GMT

Hi

I apologize in advance if this is a FAQ, but I am looking
for some information about Paradox 4.0:

- I would like to know if there is a mailing list anywhere.

- I would like to know if there is an anonymous ftp site
where I can pick up public domain code examples, in 
particular I am looking for a routine which will allow
me to select a file much like the script editor dialog 
box which allows me to open a file, the 'showfile'
procedure is too limited for what I want.


thanks


francois


Francois Schiettecatte
Software Engineer
Welch Medical Library
Johns Hopkins University
Internet: francois@library.welch.jhu.edu
Phone	: (410) 955-7581

Newsgroups: comp.databases
From: gregory@eos.arc.nasa.gov (Kevin Gregory)
Subject: ULTRIX Database Recommendations
Organization: NASA Ames Research Center
Distribution: na
Date: Wed, 16 Dec 1992 18:43:44 GMT


I'm looking for assistance/suggestions in selecting a new RDBMS. We're
attempting to upgrade from the antiquated package we have been using for years.
Our platform is a DECsystems 5100 running ULTRIX 4.2.

The two chief criterion I have are that the system is user-friendly/easy-to-use,
and that it is powerful enough to handle large sets of data effectively.

Any information/experiences/suggestions would be most appreciated.


Kevin Gregory
NASA Ames Research Center
From: dtb@otto (David Bath)
Newsgroups: comp.databases
Subject: Re: Information about ZIM and Empress?
Date: 12 Dec 92 10:12:35 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

shen@athena.cs.uga.edu (Mingzuo Shen) writes:

>Hi all,

>    I would appreciate ANY information on database programs
>called ZIM and Empress. I am aware that these are commercial
>products, so please reply by e-mail. The questions on my mind
>include: functionality, programmability, and customizability.
>any existing descriptions like a FAQ? Books or journals?

I understand that Empress is a full featured SQL based product under
VMS and UNIX that allows that user to add their own functions to the
SQL.

I have not used it but the specs look good.


David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
-- 
David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
From: price@helios.unl.edu (Chad  Price)
Newsgroups: comp.databases
Subject: Re: Advanced Revelation information request
Date: 14 Dec 1992 14:59:47 GMT
Organization: University of Nebraska--Lincoln	
Distribution: na
NNTP-Posting-Host: helios.unl.edu

clinton@acs.ucalgary.ca (Tim Clinton) writes:

>I would appreciate any leads on sources of information about Advanced
>Revelation. Mailing lists, code examples, reviews, etc. There was a
>little flurry a while back about their latest upgrade, but very little
>on-going discussion of the system. I'm involved with an organization
>which is considering buying a membership program which uses ARev. Coding
>practices of the original developers aside, we're concerned with ease of
>maintenance and difficulty involved in further enhancements.

Ask some specifics, and I'd be glad to answer. I've used Revelation in its
various incarnations since 1985. It is unsurpassed in flexibility and as a
powerful development environment in the PC world. (This is obviously a biased
opinion, so flames, as opposed to discussion > /dev/nul).

There are, however, (IMHO) management problems in the company which prevent the
product from becoming a mass market product.

Also, someday@u.washington.edu (alias Scott Johnson) seems to work for
Revelation Technologies, and may be able to provide more direct answers to
questions on an unofficial basis. Rev Tech itself does not have an Internet
address. 


--
chad
price@helios.unl.edu
cprice@molecular.unmc.edu
From: syd@dsi.com (Syd Weinstein)
Newsgroups: comp.databases
Subject: Re: Unify mailing list
Date: 17 Dec 92 03:02:58 GMT
Reply-To: syd@DSI.COM
Organization: Datacomp Systems, Inc., Huntingdon Valley, PA
NNTP-Posting-Host: dsinc.dsi.com

mireley@arnou.cem.msu.edu.brewery (John D. Mireley) writes:
>What is the address for the Unify Mailing list.

subscription requests to

uug-dist-request@dsi.com

(to add yourself, use the subject  ADD)

mailing list exploder: uug-dist@dsi.com
-- 
========================================================================
Sydney S. Weinstein, CDP, CCP          Elm Coordinator - Current 2.4PL17
Datacomp Systems, Inc.                 Projected 3.0 Release: ??? ?,1994
syd@DSI.COM or dsinc!syd      Voice: (215) 947-9900, FAX: (215) 938-0235
Newsgroups: comp.databases