HDTenEightyP/NetNews huggingface dataset:
From: aldridge@netcom.com (Jacquelyn Aldridge)
Subject: Re: database expert systems?
Keywords: database expert system inference
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Tue, 12 Jan 1993 07:24:41 GMT

lanceo@cs.utexas.edu (L. Lance Obermeyer) writes:

>Does anyone know of any expert systems that can inference on data
>existing in a database, particularly a SQL type database.

>Thanks,
o>	Lance		(lanceo@cs.utexas.edu)

	Yes. VP-Expert does. It's easy to use also.

-Jackie Aldridge-

	Also see my note on Finding Information/Software.
From: GOLLMAN@dmswwu1a.uni-muenster.de (Laurenz Goellmann)
Newsgroups: comp.databases
Subject: "case-ignoring" retrieval method within DB2's SQL
Date: 5 Jan 93 17:09:39 GMT
Organization: Westfaelische Wilhelms-Universitaet, Muenster, Germany
NNTP-Posting-Host: dmswwu1a.uni-muenster.de


 
Hello world!
I'm concerned with the problem to generate SQL-queries for a DB2-database
which contains mixed case strings as its data-rows.
Unfortunately DB2 offers no way (IMHO) to built a SELECT - WHERE - LIKE
command in order to retrieve mixed-case-tables by means of just a single
lower case string pattern after the LIKE clause in the SQL command above.
Having used a lower (upper) case string pattern one obtains only lower
(upper) case results since DB2 differs between lower and upper case Characters.
Hence the question: How to make DB2 ignoring that difference for retrieval?
Can anybody help me?
Thanx in advance
 
-----------------------------------------------------------------   !!!
L a u r e n z  G oe l l m a n n, Rechenzentrum der Univ. Muenster  !/o\!
Hittorfstr.27, D-W4400 Muenster, Germany * Phone: +49-251-83-2687  !AAA!
GOLLMAN@DMSWWU1A.BITNET (pref.)  & gollman@obelix.uni-muenster.de  !AAA!
Newsgroups: comp.databases
From: durai@ortta.umn.edu (Durai Venkatasubramanian)
Subject: Re: dBase programming question
Organization: U of Mn
Date: Fri, 8 Jan 1993 14:26:13 GMT

In article <1993Jan7.185640.9973@ac.dal.ca> guruman@ac.dal.ca writes:
>From: guruman@ac.dal.ca
>Subject: dBase programming question
>Date: 7 Jan 93 18:56:40 -0400
>
>       I'm looking for some help on a dbase program I'm writing.
>It's a silly problem, nevertheless, I can't get by it.  I need to know how
>to assign inputted text to a text variable
>i.e.  input "employee name? " to name
>(oh sorry, this` is for dBase III+)
>I presume I have to define the variable "name" as a character variable,
>but my little reference book seems to have overlooked variable definitions.
>Any suggestions on the proper path to follow?
>
>	Thanks in advance.
>
>	Rob Scott.
>	guruman@ac.dal.ca
>	Halifax Nova Scotia
>


"get" and "read" commands will do the trick.

"get" the variable and then "read" it.

"read" *must* follow the "get"
From: adams@tnt.uni-hannover.de (Martin Adams)
Newsgroups: comp.databases
Subject: OOP and relational DBMS
Keywords: OOP ORACLE LISP CLOS
Date: 11 Jan 93 09:32:48 GMT
Reply-To: adams@tnt.uni-hannover.de
Distribution: tuc
Organization: Universitaet Hannover, Theoretische Nachrichtentechnik

We would like to store Informations on pictures, methods on these pictures 
and so on ( done in CLOS (object-oriented Common-LISP) on a 
Harlequin-LispWorks-Systems on Sun-SPARC ) in a relational database ( ORACLE ).

I'm just a beginner on OOP and relational DBMS, so I'm desperately looking for 
some Informations on a kombination of these topics !!

Please send your requests to my E-Mail, because I'm not frequently subscribing this Newsgroup.

Thanks in advance !!!


Martin Adams          ---  __o          Spinnereistrasse 1A
                   ----  _`\<,_         3000 Hannover 91 (Germany)
 ``Ride bike!''     --- (*)/ (*)        phone: 0511/454328 or 440651

-- -- -- -- --    adams@helios.tnt.uni-hannover.de    -- -- -- -- --
Newsgroups: comp.databases
From: g9utxu@fnma.COM (Tanin Uthayanaka)
Subject: Re: Help on CLIPPER DBEDIT()
Reply-To: g9utxu@fnma.COM
Organization: Fannie Mae
Date: Mon, 4 Jan 1993 16:35:31 GMT

In article 25824@cucs5.cs.cuhk.hk, ynwang@cuse1.se.cuhk.hk (Wang Ying Ngai (GA)) writes:
>Dear Clipper Programming experts,
>
>I am an new user to the CLIPPER 5.01 and recently I try to write my own
>version of DBEDIT() with TBrowse. However, a stone stop my road for that
>
>-- How can I implement the PICTURE option into the TBrowse?
>   (I try different ways with concept:
>      field:="QUANTITY"
>      column:=TBColumnNew(" ",{ || transform(fieldblock(field,"999,999")} )
>    but this concept cannot work)
>
>I would appreciate a lot if you can give any advice on this.
>
>Also, do you know whether there is any ftp site that has CLIPPER sources in
>internet?
>
>Regards
>
>Andrew Wang
>

I will try to help you but I can't say it will work because I don't have the time to 
write, compile and test the program.

   Lets evaluate your code block: { || transform(fieldblock(field,"999,999")}


First, fieldblock syntax is fieldblock(<cExp>) where cExp is a field name; therefore, 
your statement fieldblock(field,"999,999") would probably give you an error. 
You need to say fieldblock(field) instead. Keep in mind that fieldblock returns a 
block to be evaluated.

Second, transform(fieldblock(field),"999,999"), notice that I added ")" after 
"field". The above statement looks correct, syntax wise, but will probably generate 
an error because transform syntax is transform(<cExp1>,<cExp2>) where cExp2 is the 
picture template expression and cExp1 is an expression NOT block. I could be wrong 
but I believe an expression is not equivalent to a block. You would probably be 
better off using transform(FIELD->quantity,"999,999).

Third, I don't know if this will work but you might try the following:

TBColumnNew(" ",{|| transform(FIELD->quantity,"999,999")})

I hope I've been of some help

Tanin U.




Newsgroups: comp.databases
From: ifenton@crc.ac.uk (I. Fenton)
Subject: Re: HELP - HELP : CLIPPER BUG ???!!
Organization: MRC Human Genome Resource Centre
Date: Wed, 6 Jan 1993 10:43:31 GMT

In article <1993Jan5.160516.1@urc.tue.nl> rcrolf@urc.tue.nl writes:
>Dear Clipper Freaks,
>
>I stumbled across a most horrible Clipper bug (at least I
>think it's a bug .....).
>
>Look at the following source code :
>
>*================================================
>var1 = 2382.80
>var2 =  234.40
>var3 = 2617.20
>*-- THIS EQUATION EVALUATES TO FALSE !!!!!! (Totally wrong !)
>?(var3 == (var1+var2))
>*================================================
>var1 = 2382.80
>var2 =  234.20
>var3 = 2617.00
>*-- THIS EQUATION EVALUATES TO TRUE (Should be !)
>?(var3 == (var1+var2))
>*------------- End of code fragment ----------
>
>Does anyone out there has an explanation for this ???????
>
>Regard,
>
>Rolf.

i am a clipper user, and sometimes a freak as well.  to my naive mind it
simply appears to be rounding error.  remember that 0.1 (or multiples
thereof) are recurring numbers in binary.  hence doing == matching on
multiples of 0.1 is dangerous.  it could be as simple as that.  try :-

   if (var1 + var2) - (var3) < 0.00001 then
       the number are as near as damn-it the same
   else
       they are different
   endif

that is what i do....

=============================================================================
IAIN FENTON                             | All errors of spelling, grammar &
Institute of Medical Genetics           | fact are due to a missing <Del> key
University of Wales College of Medicine |====================================
Heath Park                              | "No man should marry until he has
Cardiff  CF4 4XN                        |  studied anatomy and dissected at
U.K.                                    |  least one woman" - de Balzac
=============================================================================
Voice = +44 - 222 - 744049   | In 1912, Jack Johnson, the first black world
Fax   = +44 - 222 - 747603   | heavyweight boxing champion, was refused
Email = fenton@uk.ac.cardiff | permission to board the Titanic because of
   (or) ifenton@uk.ac.crc    | his colour.
=============================================================================
Newsgroups: comp.databases
Subject: Re: RDBMSes for text management??
From: vsharma@idicl1.idi.battelle.org (Vijay)
Date: 4 Jan 93 14:23:07 EST
Distribution: comp
Organization: IDI-Dublin
Nntp-Posting-User: raudabaugh

In article <1992Dec30.095738.26842@dcatlas.dot.gov>, sethg@dcatlas.dot.gov (Seth Grimes) writes:
> I'd be interested in hearing from anyone with experience using an RDBMS --
> I'm particularly interested in Informix, Ingres, Interbase, Oracle, Progress,
> or Sybase -- for text management and retrieval.  I do know about products
> that are designed for this purpose like Topic, and if you link a dedicated
> text management product with an RDBMS I'd also be interested in hearing 
> about it.
> 
> Thanks for any tips.
> 
> Seth Grimes, grimes@oecd.fr
> 
> 

Seth,

I work for Information Dimensions and our product is called BASISplus.
BASISplus is a fully Relational Document Database which offers a 
comprehensive suite of content-based and conceptual retrieval capabilities.
BASISplus supports over 30 different word processing packages and also
supports Imaging.

Phone number at headquarters  is (614) 761-8083.

-- 
Regards,

Vijay

********************************************************************************
*                                                                              *
* Vijay Sharma    Mail ID : VSHARMA                                            *
* Toronto         Internet: IN%"VSHARMA@IDICL1.IDI.BATTELLE.ORG"               *
*                 Bus     : 416-368-7724                                       *
*                                                                              *
*                 "Do the unexpected"                                          *
*                                                                              *
********************************************************************************

Newsgroups: comp.databases
From: welling@let.rug.nl (George Welling)
Subject: Re: Foxpro and Insufficient Memory Errors
Organization: Faculteit der Letteren, Rijksuniversiteit Groningen, NL
Date: Fri, 8 Jan 1993 14:43:42 GMT

In article <1993Jan7.222734.20312@nntpd2.cxo.dec.com> scott@talguy.cxo.dec.com (Scott Johnson) writes:
>
>Is there a command I can run ocassionally during the execution of the program
>which will cut down and possibly reclaim unused memory?  I was hoping there
>was some sort of garbage collection routine that can be invoked once in a 
>while during the execution cycle of the application.
>   Scott Johnson
>   Digital Equipment Corporation
>   Colorado Springs, Co
>

I am not sure if this will solve the problem, but I have solved related
problems by using the FLUSH command after every READ: this keeps the buffers
as small as possible. You could also try SET AUTOSAVE ON (the default is OFF),
this does about the same.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     George M. Welling - dep.Alfa-Informatica HCI - University of Groningen
     phone : +31 50 63 54 74  | fax : +31 50 63 49 00  | welling@let.rug.nl
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: polk@Metaphor.COM (Ben Polk)
Newsgroups: comp.databases
Subject: Re: 500'000 records - who does best?
Date: 9 Jan 93 09:37:17 GMT
Reply-To: polk@Metaphor.COM (Ben Polk)
Organization: m4

In article <18971@mindlink.bc.ca>, Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg) writes:
|> > Michael Perry writes:
|> > >500,000 records, averaging 30K *each*. Forget Sybase and Oracle on Suns;
|> > >go for a Teradata.
|> > Hmmm... given the price/performance of a Teradata I can only say:  HUH?
|> >
|> > Makes _no_ sense [to me, anyways] to spend millions of dollars for Teradata
|> > stuff when a smaller SMP box would be a LOT more practical.
|> :-) Yes, it WOULD be a lot more practical, if it did the job. IF.
|> >
|> > >and what you are suggesting is probably outside the envelope already.
|> >
|> > Hmmm... outside the envelope.  Kinda hard to imagine a 30-40 user system
|> > being outside the envelope, at least without a LOT more data to gnaw on.
|> 
|> It isn't the number of users, it's the basic size of the tables.
|> One of our clients has pushed a table to 900k rows, 250Mb on an RS/6000
|> with 50Mb memory dedicated to the Sybase server. Working with it
|> feels like retiling the bathroom while an elephant uses the john.

900k rows, 250Mb?  That's not big for Sybase on an RS/6000, unless
you find yourself scanning tables...  I've talked to people that 
start to run into data load and index performance problems when 
their databases reach the multi-gigabyte range, but the query 
performance is still good even up to 10Gb.  Loading a 10Gb database 
at 250Mb per hour is the problem.

I have a 250Mb test database on the RS/6000 under my desk, and it
is fast fast fast.

Mischa, one thing you should check: if you have Sybase 4.2, you should 
never give it over 32Mb of memory, as performance will DEGRADE 
as you feed it more memory than this.  Sybase 4.9.1 is supposed 
to fix this.

If I had the 500,000 record requirement described above I'd probably
try to get one of the high end UNIX SMP vendors to run me some
Oracle benchmarks to see if I could avoid spending millions on
a Teradata system.  Don't trust that TPCA BS, unless you want to
buy the system to run nothing but TPCA benchmarks on it, and be sure
you have some data loading and indexing stuff in the benchmarks.
I bet Oracle 7 running on a high end Pyramid system would do fine
for this application, and cost far less than a Teradata system.

Good luck!

Ben Polk
polk@metaphor.com
From: crosby@cs.utexas.edu (Crosby M. Marks)
Newsgroups: comp.databases
Subject: Dbase File structure
Date: 12 Jan 1993 22:11:04 -0600
Organization: U Texas Dept of Computer Sciences, Austin TX
Distribution: world
NNTP-Posting-Host: earth.cs.utexas.edu

Can anyone tell me where to get a formal description of how Dbase III+
stores it's dbf files?  Either that or some source code that can read it.

Thanks.

Crosby.
-------------------------------
| He's back                   |
| He's bad!!                  |
| He's m&m!!                  |
| crosby@cs.utexas.edu        |
| crosdawg@ccwf.cc.utexas.edu |
-------------------------------

Newsgroups: comp.databases
From: lamaster@pioneer.arc.nasa.gov (Hugh LaMaster)
Subject: Re: BLOBS (was: 500'000 records)
Organization: NASA Ames Research Center, Moffett Field, CA
Date: Tue, 5 Jan 1993 01:42:13 GMT

In article <19085@mindlink.bc.ca>, Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg) writes:
|> > Hugh LaMaster writes:
|> >                                    With 30K records, you are dealing
|> > |> with blobs outside the normal record structure; you can run greater
|> > |> risks.
|> >
|> > Is there a "correct" way to deal with this problem yet?  It can show
|> > up in surprisingly simple DBMS applications, such as where you want to
|> > search through a bunch of trouble calls for matches to a particular
|> > problem.  1-2 years ago, when I inquired to this newsgroup, there was
|> > no RDBMS that could handle text searches efficiently.  (Efficiently,
|> > that is, compared to a text processing/retrieval system.)  Is this still
|> > the case?
|> 
|> Seems to be still the case, among the mainstream database products.
|> You might have some luck with middle-users (as opposed to end-users)
|> such as those providing db's for, say, the publishing industry ---
|> a wonderful source of solutions to problems that I, thank goodness,
|> seldom see 

Who are the vendors of this "middle-user" software?  

What RDBMS's do they use as the database part (or, do they do their own?)?  

What are the capabilities on the text side?

Is there a newsgroup on this, or a place where technical people and users
of such products post?

-- 
  Hugh LaMaster, M/S 233-9,     UUCP:      ames!lamaster
  NASA Ames Research Center     Internet:  lamaster@ames.arc.nasa.gov
  Moffett Field, CA 94035-1000  Or:        lamaster@george.arc.nasa.gov 
  Phone:  415/604-1056                     #include <usenet/std_disclaimer.h> 
Newsgroups: comp.databases
From: prs9k@brain.med.virginia.edu (Phil Scarr)
Subject: SIR and the HP9000, an unhappy couple
Organization: Neuroclinical Trials Center, University of Virginia
Date: Thu, 7 Jan 1993 21:32:32 GMT

We are (trying) to run SIR 3.1(beta) on our HP9000/827s system and are
having a HELL of a time.  None of the concurrency features function
properly.  The master program garbles our databases when we try to use
mforms or mdbms.  Has anyone had any luck running SIR on their Unix
system or on their HP9000?  The folks at SIR Australia (the development
group) cannot seem to get a handle on the problem even though we sent
copies of our schema along for them to analyze.  We have now sent them a
complete export database to analyze and given them an ultimatum: 2
weeks.  Fix it or give us our $$ back.  I am truly ticked.

	-Phil
-- 
(--)======================================================================(--)
 ||                                                                        ||
 ||  As evey cell in Chile will tell / The cries of the tortured men       ||
 ||  Remember Allende in the days before / Before the army came            ||
 ||  Please remember Victor Jara / In the Santiago Stadium / Es verdad     ||
 ||              Those Washington Bullets Again!      --The Clash          ||
 ||                                                                        ||
(--)== prs9k@virginia.edu === Phil Scarr === Department of Neurosurgery ==(--)
Newsgroups: comp.databases
From: beutel@chdasic.sps.mot.com (Jim Beutel)
Subject: Searchin for Karen Bishman
Reply-To: beutel@chdasic.sps.mot.com
Organization: Motorola SPS ASIC, Chandler, AZ
Date: Fri, 8 Jan 1993 20:08:51 GMT

Desparately seeking Karen Bishman...! Florida State grad.,
former Lockheed Burbank employee, former IMS-Consultant
assigned to ARCO account, former Mermaid Memorabilia owner
(Scuba dive stuff)


Regards,
Jim


---
-------------------------------------------------------
Jim Beutel	

Motorola SPS ASIC            beutel@chdasic.sps.mot.com
1300 N. Alma School Rd       Computer Operations 
M/S CH290  AZ50              office:  (602) 821-4967
Chandler, Arizona 85224	     telefax: (602) 821-4963
-------------------------------------------------------

The Surgeon General has determined that Skydiving is Extremely addicting. 



Newsgroups: comp.databases
From: scottm@intime.intime.com (Scott Michel)
Subject: Re: ODBC/IDAPI API specs
Organization: -- J/24 -- Racers Home for Programmers
Distribution: comp
Date: Tue, 12 Jan 1993 18:50:11 GMT
	<1993Jan12.073111.10170@nwnexus.WA.COM>
	<KJELL.93Jan12130056@conan.hut.fi>

>>>>> In article <KJELL.93Jan12130056@conan.hut.fi>, kjell@hut.fi (Kjell Ljungqvist) writes:

Kjell| In the vendor/microsoft/odbc-sdk directory at ftp.uu.net you
Kjell| can find the odbc.exe file. This is a self extracting zip-file
Kjell| that includes the odbc-sdk v. 1.0 and thus, I believe, includes
Kjell| the API spec.

Thanks much. Someone said that ODBC was also to be found in the SDK
docs. I looked (in the MSC/C++ v7 SDK), no suh luck. Will look into it
at ftp.uu.net.

-scottm
Newsgroups: comp.databases,misc.entrepreneurs
From: IMAGING.CLUB@OFFICE.WANG.COM ("Imaging Club")
Subject: Running an antiques business with an RDBMS
Organization: Mail to News Gateway at Wang Labs
Date: Thu, 7 Jan 1993 14:06:21 GMT

The current issue of the national Maine Antiques Digest has a
lengthy, practical article on how to run an antiques business
using an RDBMS.  If anyone would like me to airmail them
a copy of the article, please send me your US/International
airmail address.  (This article has nothing to do with
either the Wang RDBMS, OPEN PACE, or document imaging.)
The article is much too long to rekey, and I'm not using
intelligent character recognition at this workstation.

This article might be of interest also to people wishing to
do some part time RDBMS consulting.

Michael.Willett@OFFICE.Wang.com
Newsgroups: comp.databases
From: scott@talguy.cxo.dec.com (Scott Johnson)
Subject: Foxpro and Insufficient Memory Errors
Reply-To: scott@talguy.cxo.dec.com (Scott Johnson)
Organization: Digital Equipment Corporation, Colorado Springs, Co
Date: Thu, 7 Jan 1993 22:27:34 GMT


I have a program I wrote which ocassionally generates Insufficient Memory
errors.  Usually there are 6 databases open at the same time and ocassionally 
8.  They get the error when they are entering data after about 40 or so 
records get entered, they see the error.  After the 40 records get entered,
they have about 100 records in the different databases.  We are running dos 5.0
with foxpro 2.2 and 4 meg of memory on the one system.  The databases are being 
accessed on a non-dedicated, (we tried to tell them to get Lantastic) Novell
server.  

Is there a command I can run ocassionally during the execution of the program
which will cut down and possibly reclaim unused memory?  I was hoping there
was some sort of garbage collection routine that can be invoked once in a 
while during the execution cycle of the application.

Thanks for any and all replies.

----------------------------------------------------------------------

   Scott Johnson
   Digital Equipment Corporation
   Colorado Springs, Co
Newsgroups: comp.databases
Subject: SYBASE: Returning results over a network from a 'C' executable.
From: lundell@gumby.mgi.com
Date: 8 Jan 93 13:21:18 CST
Organization: Management Graphics, Inc.

Hi,

 We are using Sybase as our database server running on an RS6000. The clients are
 PCs running Microsoft Windows. We are able to call stored procedures from the
clients and receive the result sets just fine. (The client software is being
developed using Power Builder.)

However, I would like to be able to call a 'C' program directly (via an RPC?) 
from the client and have it return the result set identical to the stored 
procedure. Is this feasible?

My understanding is that Sybase's Open Client/SQL Server sits on top of Sybases
Net-Lib which is part of the Client/Server Interfaces (CS/I) which handles the
network connection. 
 
So my guess is that the 'C' program would use say use 'DBLib' to build a 
result set from Sybase. Then, call a net-lib API (w/ the result set in TDS
format) to control the communications with the client to pass the result
set back.

Can someone tell me if this (calling a 'C' program as an RPC and returning
the result back across the network) is even feasible??? 

Does SYBASE allow developers to interface with their CS/I libraries???

Has anyone ever attempted something similar to this??

Any feedback would be greatly appreciated. Thanks in advance!
Newsgroups: comp.databases
From: dsw0761@mcnews.mcdata.com (Donald Wuerfel)
Subject: picklists in paradox
Organization: McData Corporation
Distribution: usa
Date: Wed, 06 Jan 1993 00:53:48 GMT

I am looking for a way to exit a SHOWDIALOG that contains a picklist.  I do not
however want to use a PUSHBUTTON.

What I would like, is to have a hotkey (i.e. F2).  This would allow me to
continue selecting items from the picklist until the users presses F2.

Does anyone have any Ideas?  

Please email me at don@mcdata.com

Thanks, Don W.
Newsgroups: comp.databases
From: g9utxu@fnma.COM (Tanin Uthayanaka)
Subject: Re: UDF problem in FoxBase+
Reply-To: g9utxu@fnma.COM
Organization: Fannie Mae
Date: Fri, 8 Jan 1993 22:24:31 GMT

In article 1ikr8sINN5bq@mizar.usc.edu, lapworth@mizar.usc.edu (Bill Lapworth) writes:
>
>* I'm playing with FoxBase+ without a manual (it's coming, but not too
>* soon!) and I can't get a UDF to work in the valid clause.
>*
>* If I run the following code, I get a 'file not found' error message
>* upon exiting the get
>
>height = 100.0
>@ 0,0 clear
>@ 3,1  say "Height in CM: " get HEIGHT valid isok(HEIGHT)
>read
>cancel
>
>function isok
>    parameter value
>return iif( value > 150, .F., .T. )
>
>* I tried moving the UDF isok to it's own .prg file and added the following
>* line at line 1: set procedure to c:\spiro\isok
>* This time I got the error message 'No parameter statement found'
>
>* Anybody got any clues?
>
>


Try entering SET PROCEDURE TO <filename> in the beginning of your program. 
<filename> is the name of .PRG file.

Newsgroups: comp.databases