HDTenEightyP/NetNews huggingface dataset:
From: an662@cleveland.Freenet.Edu (Michael Leach)
Newsgroups: comp.databases
Subject: Clipper and record locks
Date: 13 Nov 1992 23:57:26 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


After reading the discussion on how Clipper implements it's 
record locks, I can't agree or disagree completely, nor do I 
know (beyond all doubt) how Clipper handles them, but I can
state several things:

1.  The EXE does NOT store the record locks internally.  If it
did, how would clip1.exe know what records clip2.exe has locked
if both are accessing the same file at the same time.

2.  The DOS SHARE command (and similar type things on networks)
do not all use the same method for locking ranges of bytes.
Most do hook into the same DOS interrupt (I don't remember whick
one).

3.  Clipper does not tell the server (or pc or whatever) to lock
a range of bytes, the way some database managers do.  If they
did, 3Com's 3Share network would be able to detect it, and it
doesn't.

I remember a discussion about a year and a half ago at a user's
group meeting on this subject, and the only answer that anyone
could get from Nantucket on the subject was that Clipper locks
a record by telling the system that a single byte (or bytes)
is (are) locked.  This byte is outside the range of the offset
of the actual record.  Nantucket wouldn't say where or how
this info was stored, or what was stored in it beyond the fact
that it indicated what record was locked.  The general consensus
at the group was that it was stored (somehow) within the database
(we didn't agree on where).  Since DBFSIX allows multiple record
locks within a single workarea that are Clipper compatible,
I would assume that Successware has figured out (or coaxed it
out of CA/Nantucket) what it does.

Mike Leach
an662@cleveland.freenet.edu
leacmj@morekypr.bitnet
leachmj@uc.edu
Newsgroups: comp.databases
From: timmer@fwi.uva.nl (Ralf Timmer (I89))
Subject: Clipper 5.01a FIX
Organization: FWI, University of Amsterdam
Date: Thu, 12 Nov 1992 12:47:27 GMT

Hi,

I know this has been asked earlier, but:
Where can I ftp the latest clipper 5.01a fix?

I read that there was also a new version of the NanForum Toolkit (v2.1).
Is it already on ftp?
Is there an update from v2.0?

I also want to know if clipper 5.01 (with the 5.01a fix) is stable
with Windows 3.1. So, can I use programs made with clipper 5.01a
under Windows 3.1 without the risk they crash?

Thanks in advance, Ralf
-- 
Ralf Timmer                                     Department of Computer Science
Email: timmer@fwi.uva.nl                        University of Amsterdam
--
Newsgroups: comp.databases
From: ifenton@crc.ac.uk (I. Fenton)
Subject: Re: Clipper S'87 TO 5.01a - Have You Done It ???
Organization: MRC Human Genome Resource Centre
Date: Fri, 13 Nov 1992 16:34:52 GMT

In article <BxnMys.A2F@NeoSoft.com> freyder@NeoSoft.com (Rob Freyder) writes:
>
>I am at the end of a long Clipper Summer '87 development cycle and have 
>started to look into the 5.01a release of clipper.
[...]
>Trying to adopt the next generation development platform with all the various
>choices available today is VERY CONFUSING!! (FoxPro, SuperBASE, Code BASE C++,
> etc.) 

i seriously considered visual basic and codebase 4.5... but i'm better now.

>Must be Royalty FREE, and continue DBF file support....
[other questions deleted]
>
>1. Did you migrate to Clipper 5.01a from S'87 ?? Were you able to produce 
>"industrial strength" applications in EXE format just like good ole' S'87...?
>What about all the nasty rumors about 5.01a crashing all over due to internal 
>memory conflicts, etc....

i went from s87 to 5.0, then 5.01.  i *didn't* like 5.0, but i've found 
5.01 to be fine (haven't got 5.01a yet).  i find 5.01 great, yup, industrial
strength.  the best thing is the range of add-ons i can add.  i get the
very occasional internal error, but it always turns out to be a disk-related
problem (index file is corrupt etc.) so no real probs there.

>2. Did you switch from Clipper Summer '87 to some other product besides 5.01a ??
>Why and again, were you able to deliver robust software..... ?? 

nope.  considered dbase and fox, but neither could gimme free exe files at
the time.  dont know if they can do it now... especially on a network...

>3. How many issues, compared to the list I mentioned above, were of concern to
> you when you selected your "next generation" dev platform..... 

my main issue was solid network support.  i now run on a novell 386
netwwork, and net support is fine.  if i wanted to i could buy all sorts
of novell libraries for clipper to do neat tricks, but i dont.

>Please email your responses to: "arthur@marley.aws.waii.com"
>
>arthur 8^)
>Houston, Texas

good luck...
=============================================================================
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) wmgif@uk.ac.cardiff  | his colour.
   (or) ifenton@uk.ac.crc    |
=============================================================================


Newsgroups: comp.databases,comp.databases.theory,comp.databases.sybase,comp.databases.informix
From: mikell@cactus.org
Subject: UNIX-DATABASE SIZE
Followup-To: poster
Keywords: size, database
Organization: Capital Area Central Texas UNIX Society, Austin, Tx
Date: Thu, 5 Nov 1992 12:55:08 GMT

 		   * UNIX DATABASE SURVEY *

My company maintains serveral large UNIFY databases.
As such, the database product we use must allow
for such sizes without too many negative side effects.

	Many if not all of the UNIX-BASED Database
	products we've looked at claim that their development is
	geared toward large databases, BUT how large is LARGE.

In an effort to determine a current WORKING DEFINITION of LARGE,
I'm collecting info on currently running large databases
that are AT LEAST 800 MegaBytes in size. This definition pertains
strictly to the actual size of the database file alone IN BYTES
{not indexes}.

TO PARTICIPATE:
fire-off a one line mailer consisting of the following:

[machine type :: OS version :: database :: database release:: FILE SIZE]

MULTI-VOLUME
Please indicate if you are utilizing multi-volume distribution on
several disks by adding up the volumes and appending [MV::n]
where n == the number of volumes, to the end of the mailer line above.

		///////////////////////////////////
		/// MAIL TO                     ///
		///				///
		///	mikell@cactus.org 	///
		///				///
		///////////////////////////////////
If you have already mailed per my last request, please
remail. To few people followed the format above and therfore
made it difficult to use the data.
I will summarize and REPOST results to this GROUP.

///////////////////////////////////////////////////////////////////////////
///          /////////////////Mikell F. Vander Laan////////////////////////
///  ///////////  /////////////////////////////////////////////////////////
///  ///////////  ////////////         ////////////////////////////////////
///  ///////////  ////////////  ///////////        ////////////////////////
///          ///  ////////////  ////   ////  //////  ////EMAIL :///////////
////////////////          ////  ////// ////        //////mikell@cactus.org/
//////////////////////////////        /////  //////////////////////////////
/Calame Linebarger Graham & Pens///////////  ///////////////Austin, Tx/////
///////////////////////////////////////////////////////////////////////////

-- 
///////////////////////////////////////////////////////////////////////////
///          /////////////////Mikell F. Vander Laan////////////////////////
///  ///////////  /////////////////////////////////////////////////////////
///  ///////////  ////////////         ////////////////////////////////////
Newsgroups: comp.databases
From: ortiz@susan.cs.andrews.edu (Victor Ortiz)
Subject: ATTN: JAMES TODHUNTER
Organization: Andrews University
Date: Thu, 5 Nov 1992 16:52:33 GMT

To James Todhunter:

Can you send me your e-mail address?  I lost and I want to respond to your 
mail.

Victor Ortiz
[ortiz@susan.cs.andrews.edu]
From: an662@cleveland.Freenet.Edu (Michael Leach)
Newsgroups: comp.databases
Subject: sharing violations and Clipper
Date: 13 Nov 1992 23:58:48 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


Try ATTRIBing your EXE file to read-only (attrib myexe.exe +r).
If this still doesn't work, see if your network os has some
equivalent.

Mike Leach
an662@cleveland.freenet.edu
leacmj@morekypr.bitnet
leachmj@uc.edu
From: moursand@lonestar.utsa.edu (Bowen M. Moursund)
Newsgroups: comp.databases
Subject: Re: Reading dBase III+ Files
Date: 9 Nov 92 18:23:16 GMT
Article-I.D.: ringer.1992Nov9.182316.2212
Distribution: usa
Organization: University of Texas at San Antonio

>I am trying to export data from a dBase III+ file into a text file or into
>my own data file.  The export feature only makes a "PFS file."  If I can find
>any information on how to port the data to a text file or getting the
>variable record structure so I can read it in Pascal or C data structure
>format.

Howsabout:

use mydbf
copy to mydbf.sdf type sdf

This'll get you an ASCII file in System Data Format: fixed length fields with
each record terminated with a CRLF.

- Bowen -
From: rick@bcstec.ca.boeing.com (Richard Hall)
Newsgroups: comp.databases
Subject: Re: Paradox 4.0 speed (?)
Summary: Sorts in Paradox 4.0 - Why are you performing sorts on a table in the
	 first place???
Date: 9 Nov 92 21:41:58 GMT
Organization: Boeing Computer Services, Seattle

In article <tim.5.721094115@tim.src.utah.edu>, tim@tim.src.utah.edu (Tim Ma) writes:
> 
> I have a simple script written in 3.5 that randomizes the order
> >>of records in a file.  All it does it import that file as a single TEXT 
> >>field, tacks on a random number in anothe field, sorts on the random number, 
> >>and then outputs the randomized file.  To my surprise, it runs almost 50% 
> >>slower in 4.0 thanit did in 3.5 (14 minutes vs. 10 minutes).  I'm running a
> >>386SX with 4M of RAM.  Any ideas or comments?
> 
Why are you sorting a data table anyway? If the reason is to print it in 
reports in a sorted manner, do that IN THE REPORT using GROUPINGS! If you need
to sort data in a table, you obviously are not using KEYS. Paradox nearly 
requires use of keys for optimum performance. Keys are the trigger to speed 
and performance in paradox. I find sorting seldom needed in a data table and I  have been building Paradox applications for 5 years. Sorting defeats the
purpose of keys and indexes and should not be used if a well designed database.
Use of INDEXES  create secondary keys which can increase searches and queries
performances substantially. Do not use sorts, use Paradox functions for earching tables. Sorts can be used for processing ANSWER tables prior to creating graphs, but that is the ONLY reason I would sort a table...
From: ferris@turtle.fisher.com
Newsgroups: comp.databases
Subject: Re: Reading dBase III+ Files
Date: 5 Nov 92 09:17:54 CDT
Organization: Fisher Controls International, Austin, TX

> I am trying to export data from a dBase III+ file into a text file or into 
> my own data file.  The export feature only makes a "PFS file."  If I can find
> any information on how to port the data to a text file or getting the 
> variable record structure so I can read it in Pascal or C data structure
> format.
> 
> If there is a program that does this, information would be very welcome!
> 
> 
You can use debug to load the dbf file and examine the header in the file.
The first part of the file is given over to the field definitions. This area
is then followed by fixed length records where the fields are in the
same order as the database structure. Look out for the formats of the
various field types. Numeric fields include a decimal point and I forget
where the sign will fall for a negative value, probably in front.

It takes a little ingenuity, but you can decode the records using C or
Pascal or even Clipper.
Newsgroups: comp.databases
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Subject: Re: FP 2.0  DELETE FILE on a LAN
Organization: Colorado Software Solutions, Inc.
Date: Tue, 10 Nov 1992 20:51:13 GMT


In article <BxDn6z.Cv2@acsu.buffalo.edu>, v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes...
>Hi all,
>	Im wondering what will happen if a user issues a 
>	DELETE FILE F:\Foxpro2\MyJunk\Foo.DBF while
>	another user was using F:\Foxpro2\MyJunk\Foo.DBF 
>	in his/her current workspace. This would be under a NOVELL Lan.
>        I'd try it myself but I dont have access to a LAN at the moment
>	and Im not sure when I will have my next opportunity.  
> 
>	Can anyone help me out...
> 
>		Thanks,
>		- Ami

I'm not on my Lan right now, or I'd try this.  But you should get some
kind of failure on the DELETE FILE command.  The network won't let you
delete a file while someone else is using it.  Many mainframe/mini systems
will let the delete succeed, but just flag the file for deletion when
the last user closes it.  No one else can open or see it in the meantime.

Randy
Newsgroups: comp.databases
From: switzer@alpha.uleth.ca (Dean Switzer)
Subject: Clarion language ver3
Summary: Discussion of verison 3 features
Keywords: Clarion
Organization: University of Lethbridge
Date:  9 Nov 92 09:15:22 GMT

Upon reading that Clarion ver3 was going to have mouse support and pull
down windows etc... I began wondering if a ms-windows version is about to
surface? Or possibly an interfacing LEM? I am rather happy to be able to
easily mix graphics and text finally.

Does anyone reading this have experience with any of the topspeed
products? I have used thier modula2 and have been quite happy with it.
If the new clarion environment has the flexibility the topspeed shell
has I think it will leave everything else in the dust!!!

Deano
--
Deano
* the guy with no sig *
Vc: (403) 329-3726
Internet: switzer@honte.uleth.ca
Newsgroups: comp.databases
From: dhepner@cup.hp.com (Dan Hepner)
Subject: Re: Need help with X/Open Distributed Transaction Processing Specs
Date: Mon, 9 Nov 1992 22:18:09 GMT
Organization: Hewlett-Packard
X-Newsreader: Tin 1.1scd1 PL4

From: jain@cs.cornell.edu (Neel K. Jain)

>The XA specifications give me the impression that the application
>program, the transaction manager and all resource managers (or their
>stubs) are statically linked. Is this really the case or am I missing
>the point (won't be the first time)?

It really is the case that the model describes interfaces within
a single process, but easy on that "statically".

This single process view does not however preclude any of the parts, 
including the AP, from utilizing other processes in accomplishing 
their goals.  It's just that there is a single process which contains 
the linkage of all; this process is the subject of the X/Open DTP model.  

One might wonder what is distributed about that.  Nothing is.
Using standardized transactional communication, two APs, and 
thus two instances of the model can participate in a distributed
transaction.  These are as yet unpublished, but are clearly
the next step.

There is nothing precluding dynamic linking however. Some "dynamically 
registering RMs" may well be linked, on demand, at run time; the essence 
is that they fit the notion of the model as focused on a single process 
where the interfaces are intra-process call based.

>Also, has anyone used their reference model publication? Is it any
>better than the specs?
>Neel Jain

The Reference Model attempts to answer your question, while the XA 
spec's primary purpose is to offer the details of the TM <-> RM interface, 
while referencing the Reference Model for the overall picture. 

Dan Hepner
Newsgroups: comp.databases
From: david@inform.co.nz (David Paulo)
Subject: Byte Designs Ltd.
Date: Wed, 11 Nov 1992 02:43:03 GMT
Organization: InForm Group Ltd.
Keywords: Contact

I want to make contact with Byte Designs Ltd.
Can anyone mail me a fax and/or phone number
or even better an email address?
Info that I have is 
Byte Designs Ltd, 810 Peace Portal Drive
PO Box F195-76
Blaine
WA 98230


  ----------------------------------------------------------------------
    David Paulo, InForm Group Ltd.,PO Box 1444, Wellington, New Zealand.
    Email: david@inform.co.nz  
    Phone: (64 4) 472 0996  Fax: (64 4) 473 2407
  ----------------------------------------------------------------------
(Be gentle - this is my first time)
 
Newsgroups: comp.databases,comp.databases.theory
From: gold@ilp.mit.edu
Subject: Simple SQL Join question
Organization: MIT Industrial Liaison Program
Date: Fri, 13 Nov 1992 20:28:35 GMT

Hi!
	I have a basic SQL question regarding joins. We are querying 
several tables in a database for our 2000+ employees.  A typical 
query would ask for:

        "List employee names and ids and each employee's
         department(s), publication(s), project(s),
         expertise keyword(s)
         for xxx number of employees."

where "xxx" is anywhere from 1 to 2500 employees select by the user.

Some employees have 10+ expertise keywords, 2-3 departments, 1-30 
projects, 1-500 publications.

The SELECT statement that I am using is listed below.  The problem 
with the SELECT statement's resultant table is that it produces SO 
MANY rows since every change in dept, project, publication, 
or keyword for each employee produces a new row, repeating the 
non-changed information.  I realize that the Cartesian product of all 
of these tables does produce a large amount of rows in the resultant 
table.

Is there a simplier, or less resource-consuming way of using SQL to 
answer the user's question (in quotes above) rather than using the 
SELECT statement below.  Thank you for any assistance!

SELECT  employee.employee_id, employee.employee_name,
        dept.dept_name, project.project_name,
        publication.publication_name, keyword.keyword_name
  FROM  employee,
        employee_dept,
        dept,
        employee_project,
        project,
        employee_publication,
        publication,
        employee_expertise,
        expertise
  WHERE employee.employee_id = employee_dept.employee_id AND
        employee_dept.dept_id = dept.dept_id AND
        employee.employee_id = employee_project.employee_id AND
        employee_project.project_id = project.project_id AND
        employee.employee_id = employee_publication.employee_id AND
        employee_publication.publication_id = publication.publication_id AND
        employee.employee_id = employee_project.employee_id AND
        employee_expertise.expertise_id = expertise.expertise_id
-----------------
Mark D. Gold
gold@ilp.mit.edu
(617) 253-0430
From: arzt@dccs.upenn.edu (Noam H. Arzt)
Newsgroups: comp.databases
Subject: Re: Request: Patch for ingres 8.9
Date: 9 Nov 92 03:06:32 GMT

In article <1992Nov6.161514.3013@nuscc.nus.sg> isc40004@nusunix1.nus.sg  
(TAN CHEE YONG) writes:
> Hi,
> 
> Can anyone mail me the ftp site that contains the patch for ingres 8.9?
> I am going to install on in a sun sparc.

Not quite sure what you mean. The current Ingres version on Sun is 6.4.  
What is 8.9 refering to?

--
Mr. Noam Arzt                            215/898-3029 (voice)
Director, Special Projects               215/898-9348 (FAX)
University of Pennsylvania               arzt@dccs.upenn.edu
Data Communications & Computing Services (NeXTmail is OK)  
Suite 221A, 3401 Walnut Street, Philadelphia, PA 19104
Newsgroups: comp.databases
From: jjfink@skcla.monsanto.com
Subject: Re: Paradox 4.0 form question...
Organization: Searle, Skokie, IL
Date: Thu, 5 Nov 1992 13:08:12 GMT

In article <92303.122721U15310@uicvm.uic.edu>, <U15310@uicvm.uic.edu> writes:
> In designing a Paradox form, I discover I can imbed a "child" table within
> a master form.  But, I can't imbed (nest) a "child" table within the
> child form.  In other words, I can't create a form that handles three
> levels of relationships.  This seems like a serious limitation of the
> form designer.  Any suggestions for a relatively easy way for getting
> around this limitation?

I've always found this to be one of the nastiest limitations of Paradox.
[however, just try to have a three-line-per-record scrolling area (multi-record
form) in FoxPro].

I haven't gotten a solution to work in 3.5, and I'm stuck with 3.5 until this
project is done.  However, it seems that it should be doable with two windows
in Paradox 4.0:  Top window links, for instance in my case, Patient to Visit,
and second form links Visit to Lab Test.  When you move to a visit on the top,
you sneak over to the other form and zoom to the right record.

--  
jjfink@skcla.monsanto.com
------------------------------------------------------------------------------
"I want peace on earth, and goodwill towards man." 
"We don't do that kind of thing, we're the United States Government!" 
   -- from _Sneakers_
From: lf@uk.ac.uea.sys (Luke Fitzgerald)
Newsgroups: comp.databases
Subject: Info on 'Express' wanted
Date: 5 Nov 92 09:50:23 GMT
Organization: School of Information Systems

An organisation I'm connected with is considering using a 'database' package 
called Express, from Information Resources in Waltham, Mass.

Has anyone used it?  and how does it seem?  At present, the organisation is 
using a rather creaky system on Ingres 5 running on a Vax, as well as dBASE/
Clipper applications under PC DOS.

Any comments gratefully received, by mail or on the board.

Luke Fitzgerald
From: moursand@lonestar.utsa.edu (Bowen M. Moursund)
Newsgroups: comp.databases
Subject: Re: Help: How can I page a dBase report on my screen?
Date: 9 Nov 92 18:33:20 GMT
Article-I.D.: ringer.1992Nov9.183320.2909
Distribution: usa
Organization: University of Texas at San Antonio

>When I use the Control Center in dBase IV and I select the report I
>want, then select Print Report, then select View report on screen,
>the report is presented to me on my screen.  After a the screen is full,
>I get a message that says: "Cancel viewing: ESC, Continue viewing: SPACEBAR".
>This is great, but How can I get the same effect when I use the REPORT
>FROM command directly in my own program?

Jonathan - To get a paged screen report from a PRG:

_pdriver="ascii.pr2"
_plength=24
_pwait= .t.
set printer to nul  && redirect output to nul device
report form my_rpt to printer
set printer to  && reset to default

- Bowen -
From: viking@iastate.edu (Dan Sorenson)
Newsgroups: comp.databases
Subject: Re: FP 2.0 DELETE FILE on a LAN
Date: 10 Nov 92 23:40:41 GMT
Organization: Iowa State University, Ames IA

> lindsey@tincup.enet.dec.com (Randy Lindsey) writes:

>> v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes...
>>	Im wondering what will happen if a user issues a 
>>	DELETE FILE F:\Foxpro2\MyJunk\Foo.DBF while
>>	another user was using F:\Foxpro2\MyJunk\Foo.DBF 
>>	in his/her current workspace. This would be under a NOVELL Lan.

>I'm not on my Lan right now, or I'd try this.  But you should get some
>kind of failure on the DELETE FILE command.  The network won't let you
>delete a file while someone else is using it.

	Correct.  You will get a share violation, and the delete will
not succeed, and under Novell it will not be deleted when the user
closes the database file.

< Dan Sorenson, DoD #1066 z1dan@exnet.iastate.edu viking@iastate.edu >
<  ISU only censors what I read, not what I say.  Don't blame them.  >
<  "This isn't an answer, it's a pagan dance around a midnight fire  >
<   written in intellectual runes." -- Rich Young                    >
Newsgroups: comp.databases