HDTenEightyP/NetNews huggingface dataset:
From: joser@gfimda.uucp (Joe Rodriguez)
Subject: Re: Ingres - inserting date & time values
Date: Tue, 1 Sep 1992 21:49:54 GMT
Organization: Kraft General Foods

From article <1992Aug28.203902.25709@desktalk.desktalk.com>, by eric@desktalk.com (Eric Lieber):
> I am posting this because I do not have Ingres yet and therefore I cannot try itout myself.
> 
> I want to insert a datetime value into a table. The format I have to use is:
> 	"yyyy-mm-dd hh24:mi:ss"
> where hh24 is the 24 clock , (13:00 = 1:00 pm)
> 
> After reading the manual, I assume that the  II_DATE_FORMAT varable must
>  be to set to  'SWEDEN/FINLAND'.
> 
>  The question is will Ingres  accept the following:
>  insert into test_table (date_col)
>            values (	"1992-12-31 13:45:59");
> 
> 
 I am currently using INGRES 6.3 on an HP9000 system under HP-UX 8.0.  I 
 have tried the following and it works:

     1.  Set II_DATE_FORMAT to SWEDEN
     2.  created test_table with the date_col column of type date.
     3.  entered the following SQL command:
	       insert into test_table (date_col)
		   values ('1992-12-31 13:45:59')

         which resulted in the row being inserted with the appropriate value.
	 I also tried the value of 'now' in place of the above time, and
	 the current system date and time was entered in the above date 
	 format.

Hope this is helpful.

+--------------------------+------------------------------------+
| Joe Rodriguez            |    ||   //    /====\    +=======   |
+--------------------------+    || //     ||         ||         |
| Kraft General Foods      |    |</       ||  ====   ||====     |
| General Foods-USA, IMD   |    || \\     ||    ||   ||         |
| Mailcode:  T12-1         |    ||   \\    \====/    ||         |
| 555 South Broadway       |------------------------------------+ 
| Tarrytown, NY  10591     | joser@gfceb   - ICES INGRES Host   |
| (914) 335-6059           | joser@gfimda  - IMD System         |
|                          | INTERNET/UUCP:  gfimda!joser@uunet |
| Pager: (212) 356-5116    |                 uunet!gfimda!joser |
+--------------------------+------------------------------------+
-- 
+--------------------------+------------------------------------+
| Joe Rodriguez            |    ||   //    /====\    +=======   |
+--------------------------+    || //     ||         ||         |
| Kraft General Foods      |    |</       ||  ====   ||====     |
From: lzk60@jasmine.ccc.amdahl.com (Lakshmankumar Mukkavilli)
Newsgroups: comp.databases
Subject: Re: Temporal Database
Date: 31 Aug 92 17:53:08 GMT
Organization: Amdahl Corporation, Sunnyvale CA

In article <1992Aug29.080944.5806@nuscc.nus.sg> engp2190@nusunix3.nus.sg (ZENG YONGNING) writes:
>
>I need technical reports, thesises on temporal database. If anyone 
>has some or know how to get them, please send me a mail. your
>help is highly appreciated.
>
>-----------------------------------------------------------------------
>zeng yongning                        
>dept. of computer science                 zengyong@iscs.nus.sg
>faculty of science
>national university of singapore
>lower kent ridge rd
>singapore 0511

ACM Computing Surveys (second  issue of 1992 ) has a survey of Temporal
Databases.

                          Lakshmankumar Mukkavilli
                          (lzk60@ras.amdahl.com)
From: i15@cs-acad-lan.Lakeheadu.Ca
Newsgroups: comp.databases
Subject: FOXPRO 2 - TOTALLING COLUMNS IN A BROWSE WINDOW ???????????
Date: 4 Sep 1992 17:52:18 GMT
Organization: Lakehead University

Can this be done?  I am useing a browse window as a data input screen.  Due 
to the nature of the input a browse window makes the most sense.  At the 
bottom of each column in the browse window I need to be able to see the 
current total of that column (field).  It is not necessary to be able to see 
these total at all times - it's good enough to see them when you reach the 
bottom of the window.  Is this possible, or is there a way to open an 
additional window under the browse window to display these totals?  This one 
is kind of stumpping me.

Thanks a million

Dan Sullivan
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Newsgroups: comp.databases
Subject: Re: Help with Clipper5.01!!
Keywords: Clipper, Read
Date: 31 Aug 92 00:23:45 GMT
Organization: Genasys II, Sydney, Australia

In article <1992Aug29.161928.1@cc.newcastle.edu.au> john@pleiades.newcastle.edu.au writes:
...
>	I am new to clipper and have one major question. How can I perform
>  a multiple read and still be able to obtain the variables that are read?
>
>  Example:    @ 1,1 SAY "Enter first variable:" COLOR "w+/b"
>	      @ 1,20 GET M->var1 PICTURE "XXXX" COLOR "bg+/b"

Actually, you can not receive the value of var1 before 
you 've issued a READ statement

>	      
>	      IF M->var1 == "TEST"

You do not know the var1

>	         @ 2,1 SAY "Enter second variable:" COLOR "w+/b"
>	         @ 2,20 GET M->var2 PICTURE "9999" COLOR "bg+/b"
>              ENDIF
>

>	      READ
ONLY READ STATEMENT (actually, readmodal() in GETSYS.PRG) input the 
data. Before that you do not know what was input.

>
>	All I want to do is to be able to check each variable as it is entered
>  in the respective field. Is there an easy way?
>

Use VALID clause with a codeblock.

>	I tried LOOPER() in the super.lib, but although it will give the effect
>  of multiple reads with a single read statement, it still does not allow you
>  to obtain the entered value before terminating the complete read.
>

Why use something else? Standard Clipper lets you do all the things.

>	If anyone knows of an easy way of doing this I would appreciate it if
>   they could tell me how, or even better show me some source code.
>

May be I do not understand what do you really want but this is a
standard thing in Clipper (look for GET description).

>	Thanks for any help.
>
>		Jonathan Coombes

My 0.02
Michael

-- 
Michael Haldey  |  Genasys II Pty Ltd
                |  13th Level, 33 Berry St, North Sydney, NSW, Australia
                |  Phone:    +61-2-954-2878 (-9930 FAX)
                |  Internet: michaelh@g2syd.genasys.com.au
From: rds@goanna.cs.rmit.oz.au (Rowan D. Stevens)
Newsgroups: comp.databases
Subject: MetaModelling
Date: 27 Aug 92 10:38:39 GMT
Organization: Comp Sci, RMIT, Melbourne, Australia

G'day netlanders,

I'm studying for a PhD in metamodelling and would be interested in speaking
with anyone from the database area who may be involved in metamodel projects.

I have made some contacts with researchers in Europe/USA who are working on
metamodelling, but these are all from a software engineering viewpoint.  I would
be very intrested in talking further with people from the database community.

One database reference I have come across, describes the data model compiler
project:

HONG, S., and MARYANSKI, F. (1990) "Representation of Object-Oriented Data
Models".  Information Sciences 52, pp 247-284.

Does anyone have the e-mail addresses for either of these authors?

Any help greatly appreciated.


Best Regards ---> Rowan Stevens


--
Rowan D. Stevens; e-mail: rds@goanna.cs.rmit.oz.au; Phone: +61 3 660-3216.
RMIT, Dept. Computer Science. GPO BOX 2476V Melbourne VIC 3001. Australia.
From: carl.pedersen@dartmouth.edu (L. Carl Pedersen)
Newsgroups: comp.databases
Subject: Re: Informix vs. Oracle
Date: 31 Aug 92 21:38:04 GMT
Followup-To: comp.databases,comp.databases.informix
Organization: Dartmouth College

In article <randall.714956052@seashore>, randall@informix.com (Randall
Rhea) wrote:
> 
[stuff deleted]
>
> I can tell you also that after working with Informix on a UNIX
> platform, trying to develop applications with Oracle under VMS
> was an eye-opening experience.   Not only is VMS an inferior
> operating system for programmers (what?  No 'grep'?  No pipes?),
> Oracle was a very complex, buggy, and frustrating product to
> work with.  Their biggest weakness is the lack of a useful
> 4GL programming language.  We were left with only Oracle Cobol.

I can't argue with your opinions of VMS.  It's a dog, imho.  So are some of
the other platforms ORACLE runs on.  I don't hold that against ORACLE.  In
fact, I'm very  glad they run on VMS, because we're stuck with VMS for at
least a few more years.

I've been working with ORACLE for several years on VMS and have found very
few bugs.  SQL is a complex language.  I agree that ORACLE has too many
buttons, knobs, switches and dials for the DBA to fool with, but any
product that supports full SQL is going to be complex.

What was it you found frustrating?  When did you use it?

As for 4GL's, I feel that term is very ill-defined, but they have had
SQL*Forms for a number of years - which is finally becoming a good product
and surely serves the purpose of a 4GL.  If it's a procedural language you
want, then PL/SQL (relatively new) may satisfy you, though I worry that it
encourages procedural solutions to problems that are better solved in pure
SQL.
Newsgroups: comp.databases
From: s36445d@saha.hut.fi (Petteretteri Kurki)
Subject: Disappearing key fields in Paradox 3.5...
Organization: Helsinki University of Technology, Finland
Date: Fri, 4 Sep 1992 05:36:58 GMT


	HI!


	Here's my problem in its whole nakedness:

	From time to time, key fields in my tables just disappear.
	My scripts do nothing unusual and certainly don't modify
	the table structures. What can cause key fields to disappear?

	My Paradox is version 3.5.

	-pete		s36445d@saha.hut.fi
From: domae@snow.nrtc.northrop.com (Terry Domae)
Newsgroups: comp.databases
Subject: A Query: ??Benchmark Figures for Databases??
Date: 2 Sep 92 16:29:41 GMT
Reply-To: domae@snow.nrtc.northrop.com (Terry Domae)
Distribution: usa
Organization: Northrop Research & Technology Center, Palos Verdes, CA

I'm looking for a summary sheet of performance figures for various databases.
Specifically, I am looking for TPC results for popular PC and UNIX based
databases (e.g., FoxPro, Dbase IV, Paradox, ...  Sybase, Oracle, Ingres,
Informix, ...).  

Also, if there exists some performance figures for Other DB's like 
ObjectStore, Ontos, etc.  I'd like those too.

Does anyone have such numbers available?

Thanks,
Terry Domae
| Northrop Research Center	|     Phone/Fax: 310/544-5203 310/377-4271 |
| One Research Park		|      Internet: domae@nrtc.northrop.com   |
| Palos Verdes, CA, 90274-5471	| Amateur Radio: KC6ROI			   |
Newsgroups: comp.databases
From: einhorn_d@apsicc.aps.edu (E. Drew Einhorn)
Subject: Re: FOXPRO 2 - TOTALLING COLUMNS IN A BROWSE WINDOW ???????????
Date: Fri, 04 Sep 92 20:04:00 GMT
Organization: Albuquerque Public Schools - Career Enrichment Center
News-Software: VAX/VMS VNEWS 1.41    

In article <i15.1@cs-acad-lan.Lakeheadu.Ca>, i15@cs-acad-lan.Lakeheadu.Ca writes...
>Can this be done?  I am useing a browse window as a data input screen.  Due 
>to the nature of the input a browse window makes the most sense.  At the 
>bottom of each column in the browse window I need to be able to see the 
>current total of that column (field).  It is not necessary to be able to see 
>these total at all times - it's good enough to see them when you reach the 
>bottom of the window.  Is this possible, or is there a way to open an 
>additional window under the browse window to display these totals?  This one 
>is kind of stumpping me.
> 
>Thanks a million
> 
>Dan Sullivan

Check out Example in FoxPro Developer's Guide (One of the thick books in
the FoxPro 2.0 Documentation Set) starting on page D2-89.
From: mcalame@sun.com (Matthew Calame - SE Sacramento)
Newsgroups: comp.databases
Subject: ? SQL front-end
Date: 26 Aug 1992 17:10:33 GMT
Organization: Sun Microsystems, Inc.
Distribution: world
Reply-To: mcalame@sun.com
NNTP-Posting-Host: servant.west.sun.com

Are there any SQL front-ends that a university can use for free ?

Does anyone know if the big database vendors will provide their 
products at no cost if the software will be used for instructional
purposes only?

---

Regards,
Matt

----------------------------------------------------------------
Matthew B. Calame         Proverbs 3:14
                          Happy is the man that findeth wisdom,
Systems Engineer          and the man that getteth understanding.

Sun Microsystems          Phone: 916-362-3201
8880 Cal Center Drive     Email: matthew.calame@West.Sun.COM
Suite 200                 Fax: 916-362-3287
Sacramento, CA  95826     Sun Mailstop: USAC02
----------------------------------------------------------------


Newsgroups: comp.databases
From: olea@hal.nta.no (Ole J. Anfindsen FDA)
Subject: Persistent Eiffel?
Keywords: persistence ODBMS Eiffel
Organization: Norwegian Telecom Research
Date: Thu, 27 Aug 92 14:49:15 GMT

Can someone tell me whether or not an Eiffel-based ODBMS (persistent Eiffel)
is available?

-- 
Ole J. Anfindsen 
Norwegian Telecom Research
E-mail:  ole.anfindsen@nta.no

Newsgroups: comp.databases
From: jka@windshear.larc.nasa.gov (J. Keith Alston)
Subject: Inserting charcters in typeahead buffer, DBASEIV
Organization: NASA Langley Research Center, Hampton, VA  USA
Date: Thu, 27 Aug 1992 14:31:37 GMT

HI,
    I'm trying to insert characters into the typeahead buffer in a DBASEIV
    application. I'm looking for something that does what the "keyboard"
    command in clipper or foxpro does. Any ideas on this would be greatly
    appreciated. Thank-you.

-- 
************************      Don't just do it!     ***********************
Lockheed Eng. and Sci. Co./Nasa Larc|J. Keith Alston jka@windshear.larc.nasa.gov
From: proberts@informix.com (Paul Roberts)
Newsgroups: comp.databases
Subject: Re: Use of nvl
Date: 31 Aug 92 17:08:57 GMT
Organization: Informix Software, Inc.

In article <131600007@peg.pegasus.oz.au> mbrannigan@peg.pegasus.oz.au writes:
>
>                                                                                                                                      
>Hope this helps.
>Mark brannigan         Brannuiga    igan
>Pegasus Network

- a very Zen explanation of the use of Nulls!
Newsgroups: comp.databases
From: martin@sec.dom.uab.edu (Martin K. Jones)
Subject: Re: Disappearing key fields in Paradox 3.5...
Reply-To: martin@sec.dom.uab.edu (Martin K. Jones)
Organization: University of Alabama at Birmingham
Date: Fri, 4 Sep 1992 15:20:32 GMT


In article <1992Sep4.053658.23181@nntp.hut.fi>, s36445d@saha.hut.fi (Petteretteri Kurki) writes:
|>	From time to time, key fields in my tables just disappear.
|>	My scripts do nothing unusual and certainly don't modify
|>	the table structures. What can cause key fields to disappear?
|>
|>	My Paradox is version 3.5.
|>
Do you mean that the key attribute (*) on the field goes away, but the data
values remain? When I first started working with Paradox I remember that happening to me several times. Can't remember what caused it, or if I ever
found out what caused it. 

				Martin K. Jones
	   			University of Alabama at Birmingham
	   			MARTIN@ARU.DOM.UAB.EDU
From: DEVRIES@NAUVAX.UCC.NAU.EDU (Ernie DeVries)
Newsgroups: comp.databases
Subject: Re: Paradox Support/Developers Group
Date: 2 Sep 92 17:42:03 GMT

There is a Paradox discussion list.  You can send to the list at
Bitnet%"paradox@brufpb"
You can subscribe by sending a message to
Bitnet%"listserv@brufpb"
+========================================================+
|     /\                   Ernie DeVries                 |
|    /  \/\      Academic/Personal Computer Services     |
| /\/    \ \/\       DeVries@nauvax.ucc.nau.edu          |
|   Northern Arizona University   "The Mountain Campus"  |
+========================================================+
From: green@rwja.umdnj.edu (Cliff Green)
Newsgroups: comp.databases
Subject: Re: Help with Clipper5.01!!
Keywords: Clipper, Read
Date: 3 Sep 92 01:05:36 GMT
Organization: Robert Wood Johnson Medical School, Piscataway NJ

u9048979@cc.uow.edu.au (glen eastment) writes:
[stuff about presumed prevalidation deleted]

>>I haven't actually tried it, but isn't that what the WHEN clause is for?
>>(e.g., @ x,y say "Blah" get blah when m->fubar =="TEST")

>Actually the VALID clause would be better.
>WHEN is for pre-validation, but VALID is for post-validation.
>Post-validation is handy, because it waits till the user enters the
>data in the current get. Pre-validation is handy when determining whether
>to activate that get at all.
Yeah, I knew that.  :)

>eg. get customer number only if (WHEN) customer number has not allready been 
>entered. Check if customer number has been entered correctly (VALID).
I was under the impression that that was what the original request was
about:  prevalidation.

Anyway, you could probably skin this particular cat in a number of ways.

c-- 
Clifford Green               Internet:   green@rwja.umdnj.edu
Academic Computing Services     voice:   908-463-4436
UMDNJ-RWJMS                       fax:   908-463-5252
#include <fineprint.h>
Newsgroups: comp.databases
From: dhepner@cup.hp.com (Dan Hepner)
Subject: Re: Hot Standby DBMS's
Date: Sun, 30 Aug 1992 00:56:35 GMT
Organization: Hewlett-Packard
X-Newsreader: Tin 1.1scd1 PL4

From: rcbc@fafnir.cs.cornell.edu (Robert Cooper)

>Let's say we are updating bank account A at the primary and backup.
>I was envisaging something like this:

 [totally parallel execution at the replicates, yielding Wrong Answer]

>Instead we could do this:
 [do primary, then secondary, yielding correct answer]

>I presume this is Dan Hepner's point, and he's right. Distributed nested
>transaction systems look like they will allow people to program this
>solution. My only comment would be that this doesn't look much easier than
>the solutions people are coming up with using Isis and non-distributed
>transactions. 

Shall we agree that there would be ample opportunity for optimization,
including perhaps the most important, making it transparent to the
application programmer?

In any case, the difference, as compared to the Isis approach is that
this does in fact guarantee perfect synchronization.  This is not
in any sense a claim that most people would find the Isis-style solution
inadequate based solely on this criterion.

>Has anyone actually implemented a primary-backup database using distributed
>transactions in this way? Are nested transactions (or at least some
>conditional commit mechanism) part of Tuxedo, Encina, etc?
>       -- Robert

Encina supports nested transactions, Tuxedo does not (at last check), 
no common DBMS products do.  However:

Why do you believe nested transactions necessary?  Simplistically,
your example could be reworded:

     transaction begin
     send input to primary
     if (success)
       send input to replicate
       if (success)
         transaction commit
     else abort

Not a nested transaction in sight. 

Dan Hepner
Newsgroups: comp.databases,comp.os.msdos.apps,comp.os.msdos.misc
From: goldrick@ug.cs.dal.ca (Majeed  Goldrick)
Subject: BIG PROBLEM WITH OBJECTVISION!!!
Organization: Math, Stats & CS, Dalhousie University, Halifax, NS, Canada
Date: Thu, 27 Aug 1992 00:27:45 GMT

Hi All

HELP!!!!!

This is for anyone out there who is familiar with Borland's Objectvision.
I have spent all of today working on an OV (2.0) application.  I didn't get any
error messages while I was doing so, and I saved my changes to a file.
I went to open this file just now, and i got the folllowing message:


"Inconsistent Data in (Filename).  Will not be able to open and run this
application."


When, in my disbelief I tried again to open it, I got another error message
that looked alot like Windows' dreaded "General Protection fault" message
on the screen:

	"Internal error encountered.  Please report error code
	 8-688-V-2.04"

And then after clicking the OK button, it threw me out of OV completely...

HELP!!!!  I don't want to have to re-do a day's work - is there ANY way
to open this file so I can at least correct my error(s)?  Does OV
do this a lot or am I just incompetant (don't answer that part).


Please E-mail me ASAP with any potential suggestions as to a possible cause for
this, or some kind of solution....I'd call tech support at Borland, but lately
it had been hard to get through to them, and I'm on the other side of the 
continent from them, so listeneing to muzak for an hour can get expensive...


Thanks in advance,

Majeed.




Newsgroups: comp.databases
From: tonja@rss.dl.nec.com (Tonja Hill)
Subject: RDBMS market share
Organization: NEC America
Date: Tue, 1 Sep 1992 14:14:40 GMT

Can someone please tell me where I can find information on the 
RDBMS market share?

Thanks,
Tonja
Newsgroups: comp.databases
From: mtaghavi@magnus.acs.ohio-state.edu (Amir Taghavi)
Subject: Re: Foxpro 2.0 ??
Organization: The Ohio State University
Date: Thu, 27 Aug 1992 21:15:12 GMT

In article <BtAqoy.FqJ@news.udel.edu> tedboone@freezer.cns.udel.edu writes:
>
>In article 2237@news.cs.brandeis.edu, rahul@chaos.cs.brandeis.edu (Rahul Chawla) writes:
>>Greetings :
>>
>>
>>After struggling with Dbase IV I am finally inclinded to choose
>>another package. I am interested in puchasing Foxpro 2.0 as I have
>>heard a lot about. I would appreciate any comments on the following :
>>
>>1). Can FoxPro create stand alone executionable files, if so, is the
>>compiler included with the regular version ?? ( I am interested in the
>>LAN version.)
>
>Yes, FoxPro CAN create stand alone executionable files, for both extended
>and non-extended memory users.  However, this is not included in the 
>normal package.  If memory serves me right, it runs about $150.  It works
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>nicely. 
 ^^^^^^

 Do you know the name of the package? I am interested to buy it.


 Thanks

 Ami
-- 
        (/          /////////         * *    * *            //    (M)  //
       (/          ((           (0)   (0)    //      ///////////////  //
 MY   (/            ///////     //////////////      //  * *          //
 TM   (///////////////////   ///                 ////               //
Newsgroups: comp.databases
From: jrusby@darkwing.uoregon.edu (Jim T. Rusby)
Subject: Business Filevision
Organization: University of Oregon Network Services
Date: Thu, 27 Aug 92 16:27:06 GMT


I've been using a special template for a Mac multilayered program called
Business Filevision, by Marvelin corporation. Does anyone know if this
publisher still exists and how I can contact them?

I cannot seem to determine if this program is still in publication and
would like to find out. 
Thanks- Please email me:

jrusby@darkwing.uoregon.edu

Jim Rusby
From: dflynn@aludra.usc.edu (Daniel Flynn)
Newsgroups: comp.databases
Subject: dBASE code
Date: 3 Sep 1992 04:53:58 -0700
Organization: University of Southern California, Los Angeles, CA
NNTP-Posting-Host: aludra.usc.edu
Summary: Searching for dBASE archive

I am looking for an archive site which house dBase 3+ & 4 code. I have looked
at SIMTEL20, but there is nothing which looks promising. I am looking for
apps and functions. Does anyone know of such a place?

Dan Flynn
dflynn@aludra.usc.edu

Newsgroups: comp.databases
From: gtoal@pizzabox.demon.co.uk (Graham Toal)
Subject: free text indexing algorithm refs wanted...
Distribution: world
Organization: Cuddlehogs Anonymous
Date: Tue, 25 Aug 1992 19:15:21 +0000

Having implemented a database using a really cool set of algorithms
and data structures, which let us do just about anything, we find it's
depressingly slow compared to some commercial systems.  We've have
worked out what they must be doing by treating them as a black box
and throwing queries at them, and working out the complexity of the
search algorithms they must be using.  Any pointers to papers or
articles on different data structures for free text systems?

We're not going to reimplement it now, we're just interested in why
people made particular decisions; where the tradeoffs are etc.  For 
instance, we have hierarchically structred SGML files and can search
for words between arbitrary start and end tags; some systems have
fixed numbers of fields and store the presence of a word in that
field in a bit vector.  It's things like that we're interested in.
Which tradeoffs for speed and size are considered worthwhile by the
users - eg would they be upset that such-and-such a structure doesn't
allow sentence or qualified proximity searching?

Replies either here or by email gratefully received.

Many thanks

Graham