HDTenEightyP/NetNews huggingface dataset:
From: millia@athena.cs.uga.edu (David W. Millians)
Subject: db_vista database? What is it, and are there any report gens. for it?
Organization: University of Georgia, Athens
Distribution: na
Date: Fri, 8 Jan 1993 18:58:18 GMT

Where I work, we are using a custom database that I believe is written
using a db language called "DB Vista." It uses SQL I know. Anyway, the
report writer that they have written for us to make custom reports bites
big time. DOes anybody know if there's a report generator that's compat-
ible? Oh yes- I THINK (I'm not sure) that it is a btrieve format database.
I do know data is in binary format....
Thanks in advance. Our shop foreman will be most appreciative.
-- 
David W. Millians, millia@athena.cs.uga.edu  
Geekizit of the 1996 Olympics.-
Newsgroups: comp.databases
From: g9utxu@fnma.COM (Tanin Uthayanaka)
Subject: Re: Foxpro 2.0 Index Searches
Reply-To: g9utxu@fnma.COM
Organization: Fannie Mae
Date: Wed, 6 Jan 1993 21:51:09 GMT

In article 726343853@tps.COM, thomasd@tps.COM (Thomas W. Day) writes:
>Three questions:
>
>1) How do you do a multiple field indexed SEEK?  Meaning, I have an index 
>that was created using three (3) fields, now I want to seek data on those 
>fields.  Everything I try seems to bring back EOF without locating any 
>related data.  A single field search (the first field of the index) works 
>OK, but that's all I've managed.  Until I get this right, I'm doing all my 
>data searches with LOCATE and they are slow.
>
How was the data indexed in the first place ?

 For example, you could say:

 INDEX ON FIELD1+FIELD2+FIELD2 TO FILE

As far as I know all three fields must of one consistent type but becareful when 
you convert to all numeric or all date because what you'll end up doing is ADD 
number or date together. So it is probably wise to convert all fields to characters.

 then all you have to do is 

 SEEK VAR1+VAR2+VAR3

 You must use the same convert function, if there is any, when you issue the above 
command.

>2) If I create several indexes, how do I keep them all current?  Are they 
>all automatically updated if they are opened with SELECTs?  Or do I have to 
>REINDEX after a change is made in the database with one index and then a 
>search is required on a different index?
>
The best way to keep index updated is to open the file with all the indicies.

For example, you could say:

USE FILE
SET INDEX TO FILE1, FILE2, FILE3

if you don't want the file indexed, then type SET ORDER TO 0.


>3) Can you recommend an after-market book that details data search methods?
>
Tons out there. Can't remember one of the top of my head. May be someone else 
can help.


>4) Is there a reasonable way to perform math functions on 4-digit time 
>data?  The data is derived by the TIME() function but is stored 
>in a character field as 99:99 (hour:minute) character data.  What I want to 
>do is subtract two fields stored this way in each record and obtain the 
>average time between each of these fields.  Obviously, 15:01-14.58 should 
>equal something other than 00:43.  Is there a convert-text-to-time (CTOT?) 
>function?


Have you heard of the function ELAPTIME() and TSTRING() ? I'm sure you can use the 
two functions to do what you want. They are both Clipper functions.
From: dtb@otto (David Bath)
Newsgroups: comp.databases
Subject: Re: simple SQL dbms for MS-DOS
Date: 8 Jan 93 04:34:37 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

cortes@enuxva.eas.asu.edu (Enrique Cortes-Rello) writes:

>Hi,

>I will be teaching a short database seminar in 
>Bolivia, and I am looking for a cheap
>(or FREE!) SQL-DBMS for instructional
>purposes. Said seminar would be useless
>without some hands-on experience for the
>participants. 

>Unfortunately, my hosts don't have a DBMS to
>play with. 

>It seems that the host university has 
>MS-DOS machines only (I am not sure if
>they have windows).

On SIMTEL or OAK or archie.au (if you are in OZ) MSDOS archives
look at database/ssql23.zip.


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
Newsgroups: comp.databases
From: ddking@dante.nmsu.edu (Dwight King)
Subject: Automatic Account Allocations
Organization: New Mexico State University
X-Newsreader: TIN [version 1.1 PL6]
Date: Tue, 5 Jan 1993 16:00:12 GMT


I have a unique question. I have a program that is written in C. This
program is used by the Computer Center here on Campus to grant students
accounts on the systems that are available. The student simply logs on to
the machine that they wish to work on (UNIX, VAX, Mainframe) using the ID
of accounts. This is a captive account that asks them for their Social
Security Number and their birth date. Then with this information the
captive account verifies their enrollment as a student on a central
database. If they are enrolled then the captive account then creates them
an account on that system.

What I am interested in finding out is if there is a commercial product
that would do the same thing or something similar?

I thank you for the responses befor hand.
From: jvs@lester.appstate.edu (John V. Scalco)
Newsgroups: comp.databases
Subject: Questions which you think are FAQS Send me!
Date: 8 Jan 1993 11:57:00 -0500
Organization: Appalachian State University
NNTP-Posting-Host: lester.appstate.edu
X-Newsreader: TIN [version 1.1 PL7]

	hi Folks,

	For those who are following this group, you may already 
	know that I am trying to organize and put together the FAQ
	for here, since there isn't one.
	
	* First off, if anyone wants to *help* your welcome to.
		write me and let me know how you think you could help
		and what areas of information you can answer questions about.

	* Second, Suggestions are welcome

	** Finally, I know some of you have been reading this group for
		a good long time, and have seen frequently asked
		questions pop up.  Please send me a list (with the
		answers, if you have them) of what you believe to be
		FAQS and you feel might have value in the FAQ.
		   I will compile all the suggestions together, and
		all the questions, and use that as a source of FAQs 
		for the 1st version of the FAQ.

	If you have any Questions(about the faq) feel free to mail me.
	I look forward to hearing from you folks who have "the Faqs",

	sincerely,
			john v. scalco	
Newsgroups: comp.databases
From: jeb@fig.citib.com (James E. Bergman)
Subject: Paradox Engine 3.0
Originator: jeb@vulture
Reply-To: ibism!jeb
Organization: Citibank IBISM
Date: Thu, 7 Jan 1993 15:25:22 GMT



Does anybody have experience working with the new version of the Paradox Engine? I seem to be having trouble working with 'N' type fields and PXRawGet/PXRawPut.

Any advice would be appreciated.

Thank you.

James Bergman
Newsgroups: comp.databases
From: marcs@slc.com (Marc San Soucie)
Subject: Re: 500'000 records - who does best?
Organization: Servio Corp, Beaverton Oregon, US
Distribution: na
Date: Tue, 5 Jan 1993 22:39:45 GMT

Mike J. Kelly (mike@uunet!tellab5!odgate) writes:

> Hugh LaMaster (lamaster@pioneer.arc.nasa.gov) writes:

> > Mischa Sandberg (Mischa_Sandberg@mindlink.bc.ca) 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?

> As far as I know, no one has yet integrated content-based retrieval (CBR)
> with BLOBs and large text fields, which is what you really want.  Remember,
> though, that BLOBs are relatively new and I would expect that something like
> this will start happening in the next year or so.

BLOBs are not new to the Object-Oriented database community. An active
OODB, which allows you to write methods that are stored and executed in the
database engine, makes solution of this kind of problem quite routine. Such
solutions that can be easily customized and tuned to match specific problem
needs, and readily shared between applications.


> It might be interesting to the vendors who are reading this group if we
> were to start a thread on what a CBR-BLOB capability would look like.  The
> way I conceive it, at its simplest, it would involve a new type of index
> ("create text index"?) which would set up a varchar or BLOB column to be
> retrieved via CBR operators, along with some new CBR operators (at least
> contains, and probably more sophisticated stuff than that.)

Or use an OODB and save the need for a new syntax or a new set of 
operators. Most OODB's handle this kind of work with their built-in access 
mechanism.

    Marc San Soucie
    Servio Corporation
    Beaverton, Oregon
    marcs@slc.com
Newsgroups: comp.databases
From: thomasd@tps.COM (Thomas W. Day)
Subject: Foxpro 2.0 Index Searches
Organization: TPS
Date: Wed, 6 Jan 1993 18:10:53 GMT

I'm sure these are stupid questions, but the Fox manuals are no help.  
Several years ago (the Foxbase years) I was fairly good at this, I've lost 
it and don't know where to find it.  

Three questions:

1) How do you do a multiple field indexed SEEK?  Meaning, I have an index 
that was created using three (3) fields, now I want to seek data on those 
fields.  Everything I try seems to bring back EOF without locating any 
related data.  A single field search (the first field of the index) works 
OK, but that's all I've managed.  Until I get this right, I'm doing all my 
data searches with LOCATE and they are slow.

2) If I create several indexes, how do I keep them all current?  Are they 
all automatically updated if they are opened with SELECTs?  Or do I have to 
REINDEX after a change is made in the database with one index and then a 
search is required on a different index?

3) Can you recommend an after-market book that details data search methods?

4) Is there a reasonable way to perform math functions on 4-digit time 
data?  The data is derived by the TIME() function but is stored 
in a character field as 99:99 (hour:minute) character data.  What I want to 
do is subtract two fields stored this way in each record and obtain the 
average time between each of these fields.  Obviously, 15:01-14.58 should 
equal something other than 00:43.  Is there a convert-text-to-time (CTOT?) 
function?
Newsgroups: comp.databases
From: mancini@circle.cs.jhu.edu (Todd A. Mancini)
Subject: Paradox bug/feature in query form? (3.5)
Organization: Johns Hopkins Computer Science Department, Baltimore, MD
Date: Thu, 7 Jan 1993 18:38:02 GMT


Here's something I noticed in PDOX35, but have not yet tested in PDOX40...

  When I use a variable name in a query form from PAL (by using the
~variablename) notation, if the variable contains any wildcards they are
ignored.  Is this documented?

  For example, the query:

 cust | last_name | first_name |
      | check M.. | check      |
      |           |            |

would find every customer whose last name begins with `M'.  However,

 LNAME = "M.."

 query

   cust | last_name    | first_name |
        | check ~LNAME | check      |
        |              |            |

 endquery

 DO_IT!

does NOT find these customers.  I have been able to get around this by using
the TYPEIN command, but this is not elegant.  Any hints?

  -Todd
(mancini@cs.jhu.edu)

Newsgroups: comp.databases
From: "Lance R. Bailey" <lrb@ctrg.rri.uwo.ca>
Subject: Welcome to the SiR mailing list
Organization: Relayed-by-Sendmail
Date: Thu, 7 Jan 1993 20:17:04 GMT
X-Mailer: ELM [version 2.3 PL11]
To: datamgt@ctrg.rri.uwo.ca, comp.databases@newshost.uwo.ca, rob@innovus.com

Forwarded message:
From sir@ctrg.rri.uwo.ca Thu Jan  7 15:13 EST 1993
Message-Id: <9301072013.AA00136@alex.ctrg.rri.uwo.ca>
From: "sir mailing list" <sir@ctrg.rri.uwo.ca>
To: sir@ctrg.rri.uwo.ca
Date: Thu, 7 Jan 93 15:13:22 EST
Subject: Welcome to the SiR mailing list
Errors-To: lrb@rri.uwo.ca
Article-No: 6
Originator: lrb@ctrg.rri.uwo.ca


A mailing list has been set up to discuss matters pertaining to
the database system SiR. SiR is a product of SiR (Australia) Inc.


WHAT IS A MAILING LIST

Mailing lists are a method of electronic communication.  The concept is that
by mailing to one "person" a letter is distributed to many, many people with
the one action.  Replies to a "posting" are again distributed to many
people.  This allows many people to carry on a discussion on a particular
subject matter.  Mail lists are often used in place of BBS (Bulletin Board
Systems) some popular or widely used mailing lists are often merged into a
BBS.
-----------------------------------------------------------

TO POST TO THE MAILING LIST 

To send a letter to all members of the list, send mail to 
	sir@ctrg.rri.uwo.ca
The mail will then be distributed to all members of the list.


    Replying
    --------
When you reply to a letter, or posting, the reply goes to all the members of
the list and NOT the person who originated the letter.  If you wish to talk
to ONLY that person, there should be an Originator:  line stating who sent
the message.

If you wish the mail to be private then addresss your reply to the person
listed on the Originator:  line.


    Help
    ----
To speak directly to the list administrator (problems, new address &c.),
send mail to :
    sir-request@ctrg.rri.uwo.ca


-------
Lance R. Bailey  System/Network Manager         Robarts Research Institute
     NeXT/email: zaphod@ctrg.rri.uwo.ca    box: Clinical Trials Resources Group
            fax: +1 519 663 3789                P.O. Box 5015, 100 Perth Dr.
            vox: +1 519 663 3787 x4108          London, Canada N6A 5K8
Probability: If you have five dogs, three will be asleep.
From: mhinds@bt-sys.bt.co.uk (Mike Hinds)
Newsgroups: comp.databases
Subject: yacc/lex for SQL ?
Date: 6 Jan 93 12:26:23 GMT
Reply-To: mhinds@bt-sys.bt.co.uk
Organization: British Telecom

Has any one got a yacc/lex for SQL, I am not really looking
for a complete syntax, any basicly working yacc/lex for simple(ish)
sql will do ?

+-------------------+-------------------+-----------------------+
| Mike Hinds        |   Parallel and    | Software Research Div |
|                   |Distributed Systems| Room 140, B81,        |
| hinds_m at        |   as an aid to    | British Telecom Labs  |
| bt-web.bt.co.uk   |Data Visualisation | Martlesham Heath,     |
| Tel +44 473 643404|       and         | Ipswich, Suffolk      |
| Fax +44 473 647410| Virtual Reality   | IP5 7RE, UK.          |
+-------------------+-------------------+-----------------------+

-- 
+-------------------+-------------------+-----------------------+
| Mike Hinds        |   Parallel and    | Software Research Div |
|                   |Distributed Systems| Room 140, B81,        |
| hinds_m at        |   as an aid to    | British Telecom Labs  |
Newsgroups: comp.databases
From: news@massey.ac.nz (USENET News System)
Subject: Arev 3.0 woes
Summary: Missing @ variables in Arev 3.0?
Organization: DSIR, Palmerston North, New Zealand
Date: Tue, 5 Jan 93 19:12:29 GMT

Happy new year everyone!

We've recently installed Arev 3.0 as a tradeup and have noticed (amongst 
other problems) one that's rather curious. Some @-variables appear to be 
missing, although they are described in the books. These are, as far as I 
have looked, @Atrbt, @Atrbt.ptr, @SW and @VW.

Has anyone seen these lost children?

Thanks in advance...

David Apimerika
cfpdea@pnv.palm.cri.nz

Newsgroups: comp.databases
From: umnoor@ccu.umanitoba.ca (Nasir Ahmed Noor)
Subject: Couple of questions about Paradox Query and Reports
Organization: University of Manitoba, Winnipeg, Canada
Date: Wed, 6 Jan 1993 23:54:09 GMT


Hello,
I am having trouble with achieving a few results in Paradox query and report.
I would appreciate any help on it.

1. Pertaining to Query...
I have a table giving sale figures. There is a "date of sale" and customer
field in every record--along with the "sale" figure (in dollars). For a report
I want to know the total sales for every customer for last month and same month
in last year (for comparison purposes, so e.g. for Dec-1992 and Dec-1991). I
link Sales table with Customer table using example elements. Right now I am 
using two queries--one to find "calc sum" for 'sales' for Dec-1992 and other 
for finding "calc sum" for 'sales' for Dec-1991. But I want to do it in one
query so that Paradox finds sum of sales (calc sum) for a given date range
and in the same query finds sum of sales (calc sum--in the same field!) for
another date range and displays both results in different columns.
How can I do that. I tried to work along the example
query in Paradox users manual pp.77, Example 5-28. I do get results in two
columns but for some weird reason every sale figure gets added up TWICE. i.e
if the total for customer 100 is $1000, it will show up to be $2000. I would
really appreciate any help I can get on this.

2. Pertainig to Report...
How can I find sum of the calculated fields? I mean how do I refer to a
calculated field in another calculated field? I have two columns of 
sales figures in the report. First column is sale figures for this month
and second column is sales figures for last year. There is a third column 
that contains calculated fields and lists the difference in figures in 
each of row of previous tow columns ([first col] - [second col]). Now
as the end of report I want the sum of each column. Each column whose
fields came from a table can be easily summed up using summary function but
how can I add up a column of calculated fields (as the 'difference' col
described above).

I thank you for your help in advance.

regards,
--nasir
umnoor@ccu.umanitoba.ca

Newsgroups: comp.dcom.isdn
From: bob1@cos.com (Bob Blackshaw)
Subject: Re: Newbie Q
Organization: Corporation for Open Systems
Date: Thu, 7 Jan 1993 14:56:39 GMT

In <5d69f117.cb12@dabo.citi.umich.edu> rees@dabo.citi.umich.edu (Jim Rees) writes:

>In article <1605@b1.babss.UUCP>, wadswort@babss.UUCP (John H. Wadsworth) writes:

>  Does anyone have a beginners guide
>  they could post?

>I'd like to recommend Fred Goldstein's book, "ISDN In Perspective."  It
>covers the essentials of both the technical and the political issues.  He
>hangs out here so if you don't understand something you can ask him.

>Something I'd like to see is a more practical, equipment oriented guide,
>that would cover what's available today.  That sort of info changes fast
>enough that it's hard to keep up with.

That's why it doesn't get published. :-/ However, as we get CPE folks
to come in for conformance tests, the ones who pass will be publicized,
and if we get the equipment we may be able to get a data-base on-line
here that you can access from the net. Just wish us luck.

Bob.
Newsgroups: comp.dcom.isdn
From: sfrazier@norstan.com (Superuser)
Subject: NT1 - Where to get?
Organization: Norstan Communications - Columbus, Ohio
Date: Fri, 8 Jan 1993 22:11:00 GMT

I understand that AT&T, Northern Telcom, and Motorola make NT1.  Can someone
give me a phone number, fax number, or email for a distributor who sells
the NT1?

Thanks.

Steve


-- 
Norstan Communications, Inc.        | Steven E. Frazier
8101 N. High Street Suite 100       |---------------------------------------
Columbus, OH   43235                | Local : sfrazier
Voice 614-785-7335 Fax 614-785-7337 | Remote: sfrazier@norstan.com
Newsgroups: comp.dcom.isdn
From: ketil@edb.tih.no (Ketil Albertsen,TIH)
Subject: Re: 23B+D (PBX) & 2B+D (Home)
Organization: T I H / T I S I P 
Posting-Front-End: Winix Conference v 92.05.15  1.20 (running under MS-Windows)
Date: Sun, 10 Jan 1993 16:57:04 GMT

In article <C0n63t.GBM@norstan.com>, sfrazier@norstan.com (Superuser) 
writes:

>Would the following work?
>
>Install a 23B+D T1 into an ISDN compatible PBX from the local Telco.
>From the local telco install 23 2B+D to 23 individual homes.
>
>The pbx would supply the "dial tone", if you will, the phone number would
>be a DID on the PBX.  The individuals could wwork out of their home.  All
>23 people could make and receive calls at the same time due to a 1:1 
>ratio.

Sure, this is exactly what an NT2 does. Except there need not be exactly
23 home lines - our PABX has a 30B+D (Europe, you know) T but 300 S-lines 
with 2B+D. (Well, actually we have 300 TAs to old analog phones right
now, but the TAs have S interfaces so they can be replaced with true
TE1s as the price of digital phones drop.) 

If I were living next to my office, there would be no principal difference 
between my office and home phones. There is a problem of maximum cable 
lengths etc., but those are solved for PABXs of large corporations and
distributed campuses, like ours. It might as well be extended to private
homes.

Of course only 30 of the 300 can simultaneously get an external B-channel.
Notice that in your "23 individual homes", each home can occupy *one* B
channel - if any of them occupy both channels provided, the last one(s)
of the 23 would fail in allocating a B. Also, each of the 23 homes may
in principle use 1/4 of the capacity of the D channel of the 23B+D, so
four homes may block all others from setting up a connection -- even if
there are free Bs. (In practice they won't ever get close to using the
full 16 Kbit D.) But that is the way PBXs work, even in analog systems.
Newsgroups: comp.dcom.isdn
From: sfrazier@norstan.com (Steven E Frazier)
Subject: ISDN TCP/IP Routers
Organization: Norstan Communications - Columbus, Ohio
Date: Fri, 8 Jan 1993 12:50:11 GMT

Please excuse this way of getting back to someone, but I tried to email
him back and it bounced.

Paul, thanks for your help.  I tried to email you back at your "reply"
address and your address on your signature file and both of them bounced.

Could you email me again and give me an address I can get to you on?

Thanks.

Steve


-- 
Norstan Communications, Inc.        | Steven E. Frazier
8101 N. High Street Suite 100       |---------------------------------------
Columbus, OH   43235                | Local : sfrazier
Voice 614-785-7335 Fax 614-785-7337 | Remote: sfrazier@norstan.com
Newsgroups: comp.dcom.isdn