HDTenEightyP/NetNews huggingface dataset:
From: salomon@seas.gwu.edu (A. Lee Salomon)
Subject: how to get SSQL23.ZIP
Keywords: ssql, simtel
Organization: George Washington University
Distribution: usa
Date: Tue, 29 Sep 1992 20:17:25 GMT

to get SSQL23 from simtel, you FTP to simtel20.army.mil

cd pd1:<msdos.database>
get SSQL23.ZIP.1




-- 
| Machines take me by surprise with   |     A. Lee Salomon             |
| great frequency.    - Alan Turing   |     salomon@seas.gwu.edu       |

Newsgroups: comp.databases
From: chanhc@iscs.nus.sg
Subject: Re: Simple? SQL query??
Reply-To: CHANHC@NUSDISCS.BITNET
Organization: Dept. of Information Systems and Computer Science, National University of Singapore
Date: Mon, 28 Sep 1992 02:52:30 GMT

>	I've seen a few follow-ons to this question, and would like to add
>	my two-cents. Several people have pointed out that the formating issue
>	is a reporting front issue rather than a SQL query problem. SQL, though,
>	is capable of generating this report (don't try this at home, this
>	should be only attempted by theoreticians...).
>
>		SELECT 'Student Number', 'Surname', 'Subject', 'Subject Name'
>			FROM student  /* title line */
>			WHERE student_no = max(student_no) /* arbitrary */
>		UNION ALL
>		SELECT student_no, surname, sub_no, subj_name
>			FROM student...
>			WHERE subj_no = max(subj_no) 
This assumes that every student is taking the "max" subject.
>				/* I'm resorting to a trick: get only one
>				   row with full qualification */
>			  AND <join criteria>
>		UNION ALL
>		SELECT '       ', '        ', sub_no, subj_name
>			FROM student...
>			WHERE subj_no < max(subj_no) 
>				/* I'm resorting to a trick: replace the
>				   offending data with literals   */
>			  AND <join criteria>
The student's details are not captured in this query
>
>	With a little clean-up, (e.g. qualify the nonunique column names,
>	add an ORDER BY) and the job is done.
I don't see how the clean-up can be done when the student details are missing.
>
>		Aaron
I'll really like to hear from anybody who try this with any SQL systems.
Newsgroups: comp.databases
From: chow@slug.ssc.gov (Ivan Chow)
Subject: Sybase DB-library problems
Reply-To: chow@slug.ssc.gov
Organization: Superconducting Super Collider
Date: Thu, 1 Oct 1992 16:31:21 GMT

Hi,
   I am writing a program which works like isql* from Sybase
(plus many other things not from Sybase).  My program works fine
with all select/compute SQL statements.  However, when I send
some non-select SQL statements, e.g. set showplan on, if...else...,
etc.... It executes that and it "stops".  What I mean is I can't send
any SQL after this kind of commands.
The error I get is always:

DB-Library error:
        Attempt to initiate a new SQL Server operation with results pending.
dbsqlsend failed  <-- my own debug statement.

Is there any way to solve this kind of problems?
Thanks for any info.

Ivan
Newsgroups: comp.databases
From: jch@netcom.com (Jack Hwang)
Subject: Need info on xBase development tools
Organization: Netcom - Online Communication Services (408 241-9760 guest)
Date: Mon, 5 Oct 1992 17:27:04 GMT

After separating from dBase for four years, I find that I need to be
back to do some quick jobs.  However, since I am nearly as naive now,
I would like to ask for some helpful infos.

1. What is the best code generator for xBase?
   I've used Genifer before, but figuring out it might be obsolete.

2. What is the best compiler for xBase?
   I seemed to remember the early FoxBase+ had a compiler with it.  Do
   I need to use a third party compiler?

3. How about the libaries or tools which uses C directly?
   Actually, one thing I am looking into is DataBoss.  Is it as good as
   the Ad says?

Sorry to bother you guys.  But you see, in Unix world, you get the
chances to test drive software most of time; it is not the case in
DOS world.  I can't help but asking your helps.  Thanks in advance.

Jack Hwang
Xref: sparky comp.databases:7016 comp.infosystems.gis:3182
From: U46837@uicvm.uic.edu
Newsgroups: comp.databases,comp.infosystems.gis
Subject: WANTED: zipcode/county/state cross-ref data
Date: 30 Sep 92 22:13:21 GMT
Article-I.D.: uicvm.92274.171322U46837
Organization: University of Illinois at Chicago


Someone please help me.

I'm trying to find a file listing counties (preferably the county
FIPCODES) and all of the zipcodes within each county for the states
of Illinois, Indiana, Michigan, Minnesota, Ohio, and Wisconsin.

This information is to be used in a database that helps locate areas
with elevated radon measurement readings for public outreach purposes.
We're using dBASE IV on a PC and are receiving data from commercial
radon measurement vendors.

The US Post  office has such information available, but it costs $900 for
a CD-ROM disc covering the entire country.  We neither have a CD-ROM
player nor the funding or inclination to spend $900 onn such a disc.

If anyone has information on a reasonable source for state/county/
zipcode cross-referenced information in .DBF, Lotus, or ASCII
formats, please E-mail me directly.

Thanks in Advance   :-)  :-)

Gene Jablonowski
u46837@uicvm.cc.uic.edu
From: mendonza@apple.com (Jeff Mendonza)
Newsgroups: comp.databases
Subject: Re: HELP! experience in Client/Server DBMS
Date: 30 Sep 92 19:38:54 GMT
Organization: ASS  Inc.

Hi:

I've been using INGRES RDBMS. Ingres DBMS tools allow you to monitor 
invididual transactions, hots spots, etc, possible future transaction 
bottlenecks, etc....

If you need more info, email me.

Jeff M

>    "In a client/server DBMS where a database resides in the server system,
>    is it possible for the clients to have different application programs
>    which show different workload for transactions (such as, update probability,
>    internal (processing) delay, hot spot region, inter-transaction data
>    locality)? Or, is it possible even for the same application to have
>    different workload in each client?"



In article <1992Sep24.031118.26304@kum.kaist.ac.kr>, skseo@dbserver.kaist.ac.kr (Seo Sang-Koo) writes:
> 
> Hi,
> I'd like to listen your experience in client/server DBMS.
> 
> The question I have is as following.
>    "In a client/server DBMS where a database resides in the server system,
>    is it possible for the clients to have different application programs
>    which show different workload for transactions (such as, update probability,
>    internal (processing) delay, hot spot region, inter-transaction data
>    locality)? Or, is it possible even for the same application to have
>    different workload in each client?"
> 
> I'm not sure, but especially in a new area of applications (e.g., CAD/CAM,
> CASE, etc), I think the above situation won't be uncommon.
> 
> I'd very appreciate any real experience or opinion. Mail me please.
> 
> Thanks in advance,
> 
> --
> Sang-Koo Seo
> 
> Database Systems Lab. 		    
> Computer Science Dept., KAIST        | Internet: skseo@adam.kaist.ac.kr
> 373-1 Kusong-dong, Yusong-gu, Taejon | Phone   : +82-42-869-5570
> 305-701, Korea			     | FAX     : +82-42-869-3510
From: gst@stiatl.salestech.com (Greg Tucker)
Newsgroups: comp.databases
Subject: INGRES Windows 4GL - Question?
Summary: Can I link in other libraries?
Keywords: INGRES
Date: 6 Oct 92 14:12:41 GMT
Organization: Sales Technologies, Inc.


    I'm in the RS6000, AIX 3.2 envirronment with 
INGRES 6.4 and am new to INGRES Windows 4GL.
    The INGRES documentation is not clear on linking 
in 3GL objects. What if these objects make calls to
other objects? Are the standard libs linked in?
Can these objects open files and used other libraries
such as Informix C-ISAM?
    Thanks in advance for your help on this. Let
me know of your experiences with INGRES Windows.

    Thanks,
       Tuck
 
-- 
    \\\\\\\\            G. Tucker   gst@salestech.com 
    |(o)(o)|   
    |   >  | 
-----------------------------------------------------------------------------
Xref: sparky comp.databases:7050 comp.databases.ingres:1514 comp.databases.informix:2098
From: norton@csd4.csd.uwm.edu (Glenn A Norton)
Newsgroups: comp.databases,comp.databases.ingres,comp.databases.informix
Subject: QUEL query language
Date: 2 Oct 1992 20:20:43 GMT
Organization: Computing Services Division, University of Wisconsin - Milwaukee
Distribution: na
NNTP-Posting-Host: 129.89.7.4
Originator: norton@csd4.csd.uwm.edu


  Are there any QUEL references available on the network, or any books availableon the subject?
From: davidm@consilium.com (David S. Masterson)
Newsgroups: comp.databases
Subject: Re: RDB vs. OODB: Designing a queue
Date: 4 Oct 92 00:03:15 GMT
Followup-To: comp.databases
Distribution: comp
Organization: Consilium Inc., Mountain View, California
In-reply-to: mao@triplerock.CS.Berkeley.EDU's message of 2 Oct 92 17:00:20 GMT
X-Posting-Software: GNUS 3.13  [ NNTP-based News Reader for GNU Emacs ]

>>>>> On 2 Oct 92 17:00:20 GMT, mao@triplerock.CS.Berkeley.EDU (Mike Olson)
>>>>> said:

> if your database system is extensible, you can write code that can be
> linked into the dbms and executed there, and you can implement a queue.
> whether the dbms is object-oriented or relational (or, for that matter,
> network or flat-file) is irrelevant.

When you do this, though, have you broken the relational database system?  By
allowing the user to design and implement his own objects for the database to
store, what facilities is the database providing other than raw storage?  How
will allowing objects that have their own behavior into the database do to
Codd's 12 rules (for instance, the guaranteed access rule)?
--
====================================================================
David Masterson					Consilium, Inc.
(415) 691-6311					640 Clyde Ct.
davidm@consilium.com				Mtn. View, CA  94043
====================================================================
Remember, when Hitler's war ended, there were the Nuremberg trials.
                -- President George Bush, October 1990.
You can count on it.
                -- President George Bush, on Iraqi war-crimes trials,
                   January 1991.
Newsgroups: comp.databases
From: srawson@quip.eecs.umich.edu (Stephen Rawson)
Subject: Re: Gupta Client Server
Organization: University of Texas Medical Branch, Galveston
Date: Mon, 28 Sep 1992 15:34:47 GMT

In article <1992Sep9.060739.10651@constellation.ecn.uoknor.edu> cdblueth@essex.ecn.uoknor.edu (Chris D Bluethman) writes:
>
>Is anybody out there using Gupta's DBMS?  Gupta produces
>the SQLBase Client Server system with a developement 
>environment under Microsoft Windows.  I saw all the Clipper
>and Foxbase talk, but no Gupta...
>
>
>                         Chris Bluethman

We have just purchased Gupta's Novell NetWare NLM of SQLBase.  The
software has not arrived yet, but should be here soon.  I have been
evaluating a Single-user version of the product and the associated
tools (SQL Windows, Quest, also PowerBuilder).  So far I am impressed
with the stability of the product, but am by no means an expert.

I would be interested in seeing a newsgroup devoted to Gupta and other
client/server databases on the net, especially the Netware NLM-based
ones (Gupta, Oracle, Sybase SQL Server, and MS SQL Server).  Gupta
also runs on the Sun, while the other DBs mentioned above are much
more multi-platform compatible.

There is a good review of C/S databases for novell in the 9/15/92
PC Magazine.  Gupta SQLBase gets high marks for technology and value.

                  Steve Rawson
srawson@quip.eecs.umich.edu
srawson@beach.utmb.edu

Newsgroups: comp.dcom.isdn
From: stevef@wrq.com (Steve Forrette)
Subject: Re: isdn equipment
Organization: Walker Richer & Quinn, Inc., Seattle, WA
Distribution: usa
Date: Mon, 5 Oct 1992 23:03:37 GMT

In article <44784@ucbvax.BERKELEY.EDU> sklower@diva.Berkeley.EDU (Keith Sklower) writes:
>A Reliable Rumor has it that Pacific Bell submitted a tariff request
>to the California Public Utilities commission requesting residential
>ISDN service (1B+D) for $17/month.  It is also rumored that the CPUC
>is leaning towards approving it, but requiring that anybody who obtains
>this service MUST also have at least one POTS line for the very
>reason you mention.  So, at least the CPUC noticed!

Since the CPUC does not require every household to have a POTS line generally,
this seems like a silly requirement.  Also, in general I think it could be 
said that someone ordering ISDN service is more than able to take care of
themselves in such matters.

Steve Forrette, stevef@wrq.com
From: finns@hal.nta.no (Finn Stafsnes FBA)
Newsgroups: comp.dcom.isdn
Subject: Use of HLC in the US
Date: 6 Oct 92 12:53:49 GMT
Organization: Norwegian Telecom Research

Use of HLC in the North America.

I am participating in ISDN terminal standardization in Europe, 
within ETSI. So far we have been told that HLC cannot be used for  
calls to North America because the North American networks will not 
support the transmission of HLC. I must admit that I do not know 
the origin of this information.

However, a posting from deej@cbnewsf.cb.att.com (david.g.lewis), 
that the above mentioned assumption is not valid.

D G Lewis writes:

>>Bellcore requirements (specifically TR-268 and TR-444) specify 
>>that HLC should always be passed end-to-end.  AT&T's network 
>>supports transport if it's received from a LEC.  I don't know 
>>implementation information about any switches, however.

And later:

>>It is supposed to be passed transparently by the switch, which 
>>means it *should* be consistent across switch types, if only 
>>because the switch ignores it.  Of course, then you've got to 
>>make sure the CPE on both ends agree.

To me this says that an HLC-element which is sent from the 
originating ISDN terminal, will be presented at the destination 
interface if we have end-to-end ISDN. This applies even if the 
destination is in the US.

Will anybody please confirm my assumption (or tell me it is wrong)?

My next question concerns the terminal equipment. 
Is there any terminal standards that specifies which values for HLC 
that a terminal (eg. fax 4 or videophone) shall consider as compatible?


Finn Stafsnes
Norwegian Telecom, Research
From: malexand@aludra.usc.edu (Michael Alexander)
Newsgroups: comp.dcom.isdn
Subject: Good News from National ISDN-1
Date: 28 Sep 1992 21:54:58 -0700
Organization: University of Southern California, Los Angeles, CA
NNTP-Posting-Host: aludra.usc.edu

From :
newsbytes: National-ISDN Moves Forward 09/28/92                28 Sep 92 19:52

ARLINGTON, VIRGINIA, U.S.A., 1992 SEP 28 (NB) -- The National 
ISDN standard took a step forward as Northern Telecom installed 
its first phone switch meeting the National ISDN-1 standard. 

ISDN, which stands for integrated services digital network, is a 
system of digitizing phone networks which has been in the works 
for a decade. Under the system, a single phone line would be 
transformed by digital switching technology into two 64,000 
bit/second data streams and a signaling stream of 16,000 
bits/second. Local phone networks, especially the regional Bell 
operating companies, have long hailed the system, but they have 
been criticized in recent years for being slow to implement it. 

One good reason for the delay is the fact that the two major 
switch-makers, Northern and AT&T, implement the technology 
differently. National ISDN-1 is an attempt to eliminate those 
differences, so service users would not have to know the brand of 
the switch they are connected to in order to buy equipment and 
software compatible with it. 

Bell Atlantic's C&P Telephone unit took possession of the 
National ISDN 1 software. The switch itself serves 44,000 lines, 
including Bell Atlantic's own corporate headquarters. A symbolic 
call using the standard in the network is due to be placed in 
November, with 74 ISDN companies and organizations, 149 locations 
in 26 states, four Canadian provinces, Europe, Asia and 
Australia, opening their doors to the public to showcase 
applications. 

(Dana Blankenhorn/19920925/Press Contact:Bell Atlantic, Nancy 
Murray, 703/974-1719)
From: jmreilly@ccvax.ucd.ie
Newsgroups: comp.dcom.isdn
Subject: Re ISDN in Ireland
Date: 29 Sep 92 14:12:40 GMT
Organization: University College Dublin

I'm working on an ISDN project in University College Dublin in Ireland. We have
recently purchased two ISDN PC boards. These are the Datavoice SO ISDN PC board
manufactured by SCII Telecom in France which comes with an API called PCDEV,
and the other is the PCSNET ISDN PC card manufactured by OST Telecom also in 
France.

Does anyone have any experience using either of these boards and the APIs 
associated with them. Any comments would be much appreciated.

There is no commercial ISDN service in Ireland at the moment unlike most
other European Countries but a service will be introduced next year that will
comply with the "Euro-ISDN" standard. The prototype network that the national
Telecommunications company Telecom Eireann has at the moment runs French VN2
software.

I'm also interested in the forthcomming ETSI (European Telecommunications 
Standards Institute) standard on a PCI (Programmable Communications Interface)
for Euro-ISDN which is currently in draft form. 

Does anyone have any information on whether equipment manufacturers are
interested in implementing this standard when it becomes available or what is
likely to happen when this standard becomes available?
                                  
                                      John Reilly

EMAIL: jmreilly@ccvax.ucd.ie


                                              
 
 
Newsgroups: comp.dcom.isdn
From: rees@dabo.citi.umich.edu (Jim Rees)
Subject: Re: Any experience of ISDN access from Sun SS10 Workstations yet?
Reply-To: Jim.Rees@umich.edu
Organization: University of Michigan CITI
Date: Tue, 6 Oct 1992 14:39:51 GMT

In article <1992Oct6.095601.19762@aber.ac.uk>, dap@aber.ac.uk (D E Price) writes:

  	Like many others, we have two SUN SS10 workstations on order...
  3/. Does anyone have information on the encapsulation that is being
  used to carry IP over the ISDN connections?

I asked about this earlier in this newsgroup and was told it would be ppp.
Newsgroups: comp.dcom.isdn,ba.internet
From: deej@cbnewsf.cb.att.com (david.g.lewis)
Subject: Re: Does ISDN use std phone numbers?  and what about forwarding?
Organization: AT&T
Date: Tue, 29 Sep 1992 14:00:47 GMT

In article <1992Sep27.094600.28073@informix.com> johng@informix.com (John Galloway) writes:
>If making a 2B+D ISDN call, do you just pass in (somewhere) a normal
>7 or 10 or 11 or whatever digit phone number?  

Yes.  Using overlap signaling, digits are passed in INFO messages.  Typical
use is one digit per INFO message.  Using en-bloc signaling, the full
address is passed in the SETUP message in the Called Party Number IE (and,
optionally in the US anyway, the Transit Network Selection and Operator
Service Information IEs).

>If so, then can a regular POTS phone line be forwarded to an ISDN line

yes

>and hence forward an ISDN 2B+D call?  

I'm not sure what you mean by a "2B+D" call, but assuming you mean two
64kb/s unrestricted digital information calls, probably not.  Bearer service
interworking kicks in here.  A call from an ISDN line to a POTS line must be
a voice or 3.1kHz audio bearer call.  I don't know for certain, but I would
guess the bearer capability compatibility check would be done before call
forwarding would be invoked - so your first 64k UDI call to the POTS line
would be cleared by the switch before it ever got to CF.

>The final target of the call would
>of course have to be within whatever area was being served by ISDN for
>a 2B+D 128Kbps call, but you could make a 1B 56Kbps voice call 

There is no such thing as a "1B 56Kbps voice call".  A call can be voice,
3.1kHz audio, 64k RDI (Restricted Digital Information), or 64k UDI
(Unrestricted Digital Information).  64k UDI may, in addition, be
rate-adapted to 56kb/s, allowing interworking with non-ISDN switched 56kb/s
digital services.  But a voice call is not 56kb/s, and a 56kb/s call is not
voice.

>Can ISDN lines be arranged into a hunt group with a single number getting
>any of N lines?

Depends on the capabilities of the switch.  The 5ESS(R) switch enables all
sorts of capabilities on top of ISDN BRIs - multiple line appearances,
pick-up groups, hunt groups, you name it, it's got it.

Disclaimer: I'm not a 5ESS systems engineer, nor do I play one on TV.

David G Lewis                              AT&T Bell Laboratories
david.g.lewis@att.com or !att!goofy!deej     Switching & ISDN Implementation
Newsgroups: comp.dcom.isdn
From: husemann@camelot.informatik.uni-erlangen.de (Dirk Husemann)
Subject: Re: Any experience of ISDN access from Sun SS10 Workstations yet?
Organization: CSD., University of Erlangen
Date: Tue, 6 Oct 1992 12:31:40 GMT

dap@aber.ac.uk (D E Price) writes:


>Dear All,
>	Like many others, we have two SUN SS10 workstations on order
>here at Aberystwyth in Wales, UK. A few questions....

We got some delivered over here.

>1/. Does anyone have experience of using the ISDN connections?

No. Currently Sun Germany tells us that the ISDN device is unsupported for the
time being.

>2/. Does anyone have an on-line copy of information on the
>Applications Prograaming interfaces we are going to be
>offered.

No. At least we don't --- Sun probably has but we couldn't yet twist it out
of them ...

>3/. Does anyone have information on the encapsulation that is being
>used to carry IP over the ISDN connections?

This is still an open question --- not only for Sun as I gather it.

>4/. Does anyone have information about trhe 'Server' process
>that will be provided?

Vide supra.

>5/. Has anyone in the UK had one delivered?


	Dirk Husemann
---
From: nelson@crynwr.com (Russell Nelson)
Newsgroups: comp.dcom.isdn
Subject: isdn equipment 
Distribution: world
Date: Thu, 01 Oct 92 01:01:16 GMT
Organization: Crynwr Software

In article <1acpoeINNg8g@agate.berkeley.edu> cliff@garnet.berkeley.edu writes:

   In article <1992Sep27.032045.29386@xtcn.com>, lamb@xtcn.com (Richard Lamb)    writes:
   |> Geez . I didnt realize how many people wanted the NT1 outside.

   I'm pretty surprised by this myself.  My reaction is who wants to pay an
   extra $100-200 for an external device or two (the NT NT1 is two large
   pieces wasting space on my floor).

   In particular, I don't (yet) give a hoot about the passive bus.

I, also, was an advocate of the U interface at one time.  However,
consider that you can use the same phone number for FAX, voice, and
data.  If your device is using (up) the U interface, they can't hook
up anything else to that phone line (unless your device provides the
S/T interface).

Also consider that the US is the only place where the U interface
exists.  And consider the size of the US ISDN market vs. the rest of
the world.  U is a small market and may not even make sense...

-russ <nelson@crynwr.com>  I'm proud to be a humble Quaker!
Crynwr Software            Crynwr Software sells packet driver support.
11 Grant St.               315-268-1925 Voice
Potsdam, NY 13676          315-268-9201 FAX