HDTenEightyP/NetNews huggingface dataset:
From: head@dorsai.com (Howard Pinsley)
Newsgroups: comp.databases.sybase
Subject: TCP Vendor for DB & Net Lib
Date: 2 Oct 92 12:06:59 GMT
Organization: The Dorsai Embassy +1.718.729.5018
X-Newsreader: Tin 1.1 PL4

I want to start developing MS-Window applications using Sybase's DB-Lib and
Net-Lib (using Borland C++ & Application Frameworks).  We have to choose 
a vendor for TPC/IP.  I'm also interested in SLIP support.

Are all the vendors the same with respect to their compatibily with Sybase?
I'd appreciate any recommendations?  Thanks.
Newsgroups: comp.databases.sybase
From: andersen@reality (Robert Andersen)
Subject: Re: Wanted: How to include a file?
Organization: Encompass
Distribution: usa
Date: Thu, 1 Oct 1992 19:14:40 GMT

In article <1992Oct1.164027.16212@gmuvax2.gmu.edu> jyoon@gmuvax2.gmu.edu  
(Jongpil Yoon) writes:
> How can I include a file containing a sequence of sql's inside the
> sybase and execute it?  

Here are the 2 ways I know how:

1) get into the server using isql, type edit <return> and it will bring into an
   editor.  Once inside the editor you can include the file.  When you exit the
   contents of the file will relayed to isql.  Not preferred

2) run this command:
isql -U<user> -S<server> -i<sql file> {UNIX}
isql /u="<user>"/serv="<server>"/input="sql file" {VAX}

if you want to see the file being processed add this to the above command:
-e
/echo

--
Robert John Andersen           
(919) 380-6523 (v,w)
andersen%reality@glv.com - NeXT mail!

Outside of a dog, a book is man's best friend.
Inside of a dog it's too dark to read.
Newsgroups: comp.databases.sybase
From: mike@uunet!tellab5!odgate (Mike J. Kelly)
Subject: Re: TCP Vendor for DB & Net Lib
Organization: Odesta Corporation
Date: Mon, 5 Oct 1992 20:09:02 GMT

head@dorsai.com (Howard Pinsley) writes:

>I want to start developing MS-Window applications using Sybase's DB-Lib and
>Net-Lib (using Borland C++ & Application Frameworks).  We have to choose 
>a vendor for TPC/IP.  I'm also interested in SLIP support.

>Are all the vendors the same with respect to their compatibily with Sybase?
>I'd appreciate any recommendations?  Thanks.

I've used Wollongong PATHWAY and FTP and found Wollongong (a) more helpful
with problems  and (b) much easier to install.  Combine this with the
fact that FTP sells a different product based on your physical connection
and the benefit clearly goes to Wollongong.  I've heard (but don't know
myself) that FTP is a memory hog, too.
-- 
--
Mike Kelly               Odesta Corporation, Northbrook, Illinois, USA
...!clout!odgate!mike    - Until odesta.com is registered.
odgate!mike@clout.uucp   - From the Internet.
From: lef@plsparc.UUCP (Lawrence E. Fitzpatrick)
Newsgroups: comp.databases
Subject: Phone/Mail address of Joe Celko
Keywords: help
Date: 29 Sep 92 19:14:39 GMT
Organization: Personal Library Software Inc., Rockville MD



Does anyone know the state, city, company, email address or phone
number where Joe Celko can be found?  Please reply by mail.

Thanks, lef


-- 
Regards, lef

Lawrence Fitzpatrick                    Voice:(301)926-1402/Fax:(301)963-9738
Personal Library Software               lef@pls.com
Newsgroups: comp.databases
From: mward@netcom.com (Michael Ward)
Subject: Re: Flat vs Relational ??
Date: Tue, 29 Sep 92 17:18:26 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 

rpatel@eniac.seas.upenn.edu (Rachana D Patel) writes:


>This is a simple question but could someone tell me the advantages
>of having a relational database versus a flat database.

just a few off the top of my head:

You need only have one instance of any particular piece of data, thus
minimizing opportunities for inconsistent data.

You need not use storage space for fields that are infrequently used.

You can build reports based on a greater number of "points-of-view".

You can build reports of far greater complexity, since the structure
of the data contains a lot of information about the data.

Newsgroups: comp.databases
From: robertp@carina.csis.dit.csiro.au (Robert Andrew Power)
Subject: Extensions to RDBMS REQUIEM
Organization: CSIRO Division of Information Technology
Date: Wed, 30 Sep 1992 23:51:25 GMT

REQUIEM (RElational Query and Update Interactive systEM) is an 
extensible, relational DBMS developed in C with a query language
based on the relational algebra called RQL (Relational Query 
Language).  Descriptions of REQUIEM can be found in :

	`An Extensible DBMS for Small-Medium Scale Systems',
	 Papazoglou, M.P., IEEE Micro, April 1989.

	or the book :

	 Relational Database Management - A Systems Programming 
	 Approach, Papazoglou, M.P. and Valder, W.,
	 Prentice Hall International, UK, 1989.


The original version has been extended in the following ways :

	- to make it a multi-user system and 

	- a preprocessor to allow embedded queries 
	  in standard C programs.
 
These changes are as yet mutually exclusive.

The source code for these extensions have been made available by 
anonymous ftp to :

	dcssoft.anu.edu.au

The respective compressed and tar'ed files are 

	- REQUIEM.tar.Z (muli-user version)

        - Requiem.tar.Z (includes preprocessor)


Any queries with the embedded version of requiem can be directed   
to : 
 
robert.power@csis.dit.csiro.au
CSIRO Division of Information Technology
PO Box 664                                      tel: +61 6 275 0960
Canberra ACT 2601 AUSTRALIA.                    fax: +61 6 257 1052
 

The person who wrote the multi-user version is no longer at the ANU
and is in fact out of the country.  He will be starting a PhD at  
Queensland University of Technology in 93 (or so I'm told).  Any
queries regarding this version of Requiem will have to wait until
then.
 

Robert Power

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
robert.power@csis.dit.csiro.au                  
CSIRO Division of Information Technology
PO Box 664                                      tel: +61 6 275 0960
Canberra ACT 2601 AUSTRALIA.                    fax: +61 6 257 1052
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- 


Robert Power
From: davidm@consilium.com (David S. Masterson)
Newsgroups: comp.databases
Subject: Re: Flat file database for Unix?
Date: 5 Oct 92 01:30:19 GMT
Distribution: comp
Organization: Consilium Inc., Mountain View, California
In-reply-to: davidm@consilium.com's message of 30 Sep 92 16:59:06 GMT
X-Posting-Software: GNUS 3.13  [ NNTP-based News Reader for GNU Emacs ]

Since someone called me about my original post on this topic looking for more
information, I decided to repost (part of) an article I saw in comp.newprod to
help this person and others find more detailed information:

< /rdbX Release 2:  Simplified Distributed Graphical Database Access
< 		From Revolutionary Software

< Getting at database information can be difficult if you're not a database
< expert. The /rdbX distributed graphical interface makes it easy to get the
< data you want, when you want it, in your X window environment.

< Whether you're a database novice or expert, the /rdbX X window interface
< lets you point and click to query your database, perform updates and
< interactively create reports and new databases, increasing productivity
< dramatically.  You don't have to learn a complex query or report generation
< language. With /rdbX a database administrator can set up preformatted
< reports, or you can easily customize your own reports.  /rdbX provides one
< simple consistent look and feel to the leading relational database
< management systems. You can share database query results easily with other
< applications such as image processors, CAD/CAM packages and desktop
< publishers.

< Buy /rdbX Release 2 now at the special introductory price of $495
< for a single user license or $2495 for 8 windows and, in addtion
< to /rdb and its drivers, get one more database driver of your 
< choice (Ingres, Informix, Sybase or ORACLE) when available 
< (scheduled for November 1992).

< |  Revolutionary Software  |  Internet: rdb@rsw.com         |
< |  131 Rathburn Way        |  Voice:    (408) 429 6229      |
< |  Santa Cruz, CA 95062    |  Fax:      (408) 427 0342      |
--
====================================================================
David Masterson					Consilium, Inc.
(415) 691-6311					640 Clyde Ct.
davidm@consilium.com				Mtn. View, CA  94043
====================================================================
[May 1988] I was out of the loop.  [August 1988] I'm in on everything.
If our policies aren't working, I can't say `Wait a minute, I'm not to
blame' ... I feel I'm a full partner.
                -- George Bush, on Iran-contra.
Newsgroups: comp.databases
From: "Ronald C. Schultz" <p00058@psilink.com>
Subject: Client-Server Information Access Management
Organization: Berard Software Engineering, Inc.
Date: Mon, 5 Oct 1992 20:03:35 GMT
X-Mailer: PSILink (3.2)

I have been tasked with developing an architecture that will allow end 
users to download 'information' from a 'data warehouse.'  The location 
and access to the data will be hidden from the end user in a 'Data 
Access Manager' or 'Rules Manager', while the semantics of the data will 
be defined in a data dictionary.  Users will request information, (e.g., 
estimated sales or production volume), which will be received by the 
Rules Manager and interpreted.  Data will be gathered and procedures 
executed under the Rules Manager guidance, and the 'information' will 
then be delivered to the end user in some predefined forms (e.g., ASCII, 
WKS, .XLS,...).  Does anyone know of a product, or suite of products, 
that supports such an approach in a heterogeneous environment (multiple 
hosts running numerous protocols with many types of databases executing, 
as well as flat files).  In addition, I would be interested in 
corresponding with anyone currently doing this.  I believe the DoD 
embarked on a more sophisticated, but similar effort, a while ago called 
CALS.  I would be interested in any pointers to this research also.  

Thanx.

------------------------------------------------------------------------------
Ron Schultz 
Berard Software Engineering, Inc.
Columbus, Ohio Office                   Headquarters
5634 Claire Court                       101 Lakeforest Blvd.
Dublin, Ohio 43017-2440                 Gaithersburg, Md.  20877
(614) 798-0295 Phone                    (301) 417-9884 Phone
(614) 798-0296 FAX                      (301) 417-0021 FAX
ron@bse.com                             info@bse.com
------------------------------------------------------------------------------

Newsgroups: comp.databases
From: iqbal@cs.UAlberta.CA (Iqbal Goralwalla)
Subject: Distributed Rule Processing
Summary: Rule Processing for Distributed Databases ...
Keywords: Rules, Distributed, Databases
Organization: University of Alberta, Edmonton, Canada
Date: Thu, 1 Oct 1992 00:06:17 GMT

Hi everyone,

I am in the process of carrying out research on (distributed) rule 
processing in a Distributed Database environment. If anyone has any
information on the subject, i.e., pointers to publications and the
state of the research at present, I will be very grateful if you could
spare a couple of minutes and send me (or post to the news group)
whatever info. you have on the subject. 
Thanks a lot ... (iqbal@cs.ualberta.ca)

Hoping to hear from some of you soon ...

Iqbal


Newsgroups: comp.databases
From: jnm@ornl.gov (Jamey Maze)
Subject: Security standards & databases
Followup-To: comp.databases
Organization: Oak Ridge National Lab
Date: Tue, 29 Sep 1992 14:05:45 GMT

I'm involved in an effort at my site to define a strategy for client-server
computing. Actually, I'm involved specifically in the security aspect,
where we're looking at three key areas for emerging standards:
authentication, authorization, and accounting (auditing, logging, etc.).
For the past couple years, I've been looking at potential solutions for
some of these problems. My intuition is that in the next 2-3 years OSF's
DCE, which includes a Kerberos-based authentication service, will become a
very component. But I don't follow the database scene too closely so I'd
really appreciate some input from this group. My assumption is that today
commercial database vendor employ their own proprietary security
mechanisms. Is that true? Does anyone believe vendors will actually migrate
to standard mechanisms such as those provided in OSF DCE? What are the
security standards that are likely to be winners in regards to commercial
database products over the next 5 years? Who are the key players? I've
heard of something called SQL2 and SQL3. Do these standards involve
security? Will they be winners?

Your input will be appreciated. Please respond via e-mail (jnm@ornl.gov). I
will be happy to summarize if it appears there is broad interest.

Thanks!

--
Jamey Maze, Oak Ridge National Lab
From: ch966@cleveland.Freenet.Edu (Jose M. Febus)
Newsgroups: comp.databases
Subject: Nanforum Library
Date: 28 Sep 1992 14:33:44 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


Hi all.
	I want to know where i can find the lastest version
of Nanforum Library. 
	Thanks..
	Jose Febus.
-- 
	Jose Febus
	"Drinking at Yagrumo"
From: paul@csir.co.za (Paul Nash)
Newsgroups: comp.databases
Subject: Foxbase decompiler?
Date: 1 Oct 92 13:39:17 GMT
Article-I.D.: tantrum.paul.717946757
Organization: Infotek, CSIR

Foxbase seems to compile to a slightly tokenised form, which then goes
through a run-time interpreter.  If this _is_ the case, it should not
be too difficult to build a Foxbase de-compiler.  Before I start on this
(to salvage a databane system where the source got badly trashed), I
would like to know whether anyone else has done this.  If so, can I
ftp a copy from somewhere?  If it is commercial, please give me a 
price plus address (e-mail or snail), so that I can purchase it.

Mail would be preferred, as our newsfeed is fairly erratic.

--
 ---=---=---=---=---=---=---=---=---=---=---=---=---=---=---=---=---
 Paul Nash                                   (voice) +27-12-8413050
 Network Services, CSIR Infotek                (fax) +27-12-8414109

        "OS/2 will remain the operating system of the future"
From: mcastro@hp9k.lag.itesm.mx (Manuel Castro Trevino)
Newsgroups: comp.databases
Subject: To Walz:C-tree and Db-Vista
Summary: To Walz:C-tree and Db_Vista
Keywords: Ctree
Date: 1 Oct 92 21:57:10 GMT
Nntp-Posting-Host: hp9k.lag.itesm.mx
Path: hp9k!mcastro

Hi Walz.

I read your message asking for experiences about C-tree. We use C-tree to write our software (administrative packages) . We have plenty of trust on it. WE sold this software over all Mexico and problems with files are almost inexistent. it's very resistent to electrical fails or to corrupt data. Any question you have we'll try to help . You can mail us at mcastro@hp9k.lag.itesm.mx.

regards
Manuel Castro

Newsgroups: comp.databases
From: cpetersn@iastate.edu (Clifton R Peterson)
Subject: Re: Revelation 3.0 upgrade question
Organization: Iowa State University, Ames IA
Date: Mon, 5 Oct 1992 21:24:45 GMT

In <BvnH00.IuA@nic.umass.edu> dtodd@titan.ucc.umass.edu (David M. Todd) writes:


>I got the patch from CompuServe for the Rev 3.0 upgrade process and I
>have one dumb question.  I assume I run the patch AFTER I have run the
>upgrade/trade-up process.  Right?

I assume so.  That's what I gleaned from reading the patch's readme.  I just
got my upgrade today so I'll be working on it tonight.  I hope the patch is
not to fix something that can crash during the upgrade/tradeup.  Reading it
seems to indicate that it is mostly for fixing the file (table) names and
fields (columns) for different scenarios and some minor code for printers
and the such.

-- 
 _________________________________________________________________________
/ Clifton R. Peterson    1108 Burnett		(515)232-5254	    	  \
| B.S. Chem E            Ames IA  50010                                   |
\_______________"42"_is_one_hell_of_an_answer!!___________________________/
From: an662@cleveland.Freenet.Edu (Michael Leach)
Newsgroups: comp.databases
Subject: Borland C++ and Clipper
Date: 5 Oct 1992 00:09:51 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


It is possible to use Borland C++ with Clipper 5.01.  You have
to use the following compiler options:
 
-c  (compile only)
-ml (use large memory model)
 
You also have to declare any functions (including the one that Clipper
calls as 'extern C'  (e.g., extern C CLIPPER myfunc()).
 
When you link your app, link in CL.LIB from BC++.  All the
functions from the Extend system your C program uses have to be
declared as 'extern C' as well.  Any BC++ library functions
work normally as long as you link the proper libraries.
 
I've used this with RTLink (the one that comes with Clipper),
Blinker 2.0, WarpLink 1.95 and 2.0, and TLink (that came with
BC++).
 
Mike Leach
an662@cleveland.freenet.edu
LEACHMJ@UC.EDU
LEACMJ@MOREKYPR.BITNET
LEACMJ@MOREKYPR.MOREHEAD-ST.EDU
Newsgroups: comp.databases
From: esh@nitrogen.tekbspa.com (Edward S. Hirgelt)
Subject: Re: Sybase DB-library problems
Organization: Direct Interfaces Corporation @ Teknekron
Date: Fri, 2 Oct 1992 01:07:10 GMT


On Thu, 1 Oct 1992 16:31:21 GMT,
chow@slug.ssc.gov (Ivan Chow) said:

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

Ivan> Is there any way to solve this kind of problems?

I'm going to guess that you do something like:

	dbsqlexec(dbproc);
	dbresults(dbproc);
	while(dbnextrow(dbproc) != NO_MORE_ROWS)
	{	Process the row 	}

dbresults will bring back one set of results. If there is more than one
set, you won't see them and you won't process them. And you'll get that
error out of dblib.

You need to do something more like:

	dbsqlexec(dbproc);
	while(dbresults(dbproc) != NO_MORE_RESULTS)
	{
		while(dbnextrow(dbproc) != NO_MORE_ROWS)
		{
			Process row
		}
	}

This will work always even with a batch like 

	select * from foo
	select * from bar
	go

or something similar within a stored procedure.

I'm not 100% sure that set showplan and friends behave like this, but
the symptoms you've described make it sound that way.

Hope this helps,
Ed
--
Ex vitio alterius	|Ed Hirgelt			|esh@tss.com
sapiens emendat suum.	|Direct Interfaces Corporation	|
(Publilius Syrus)	|San Jose, Ca.			|
From: imn_ <lisa stewart <lisa@ux1.lbl.gov>
Date: 17 Sep 1992 20:06:39 GMT
Subject: Residential Forcasting Database
Newsgroups: comp.databases
Organization:  Lawrence Berkeley Laboratory
Keywords:  energy, database, forcast, residential
Summary:  Seeking energy related database info


Our group would like to expand our current Residential Forcasting Database.
We would like to receive information on the following issues:

	1) Related databases that already exist with which we could
	combine our information. This would include such information
	as current enegy technology, new energy technology, regional energy
	consumption, thermal shell and heating/cooling load data, etc.

	2) Information on the design of currently existing databases of
	this type.

	3) Suggested areas of interest by others in the area of Residential
	Energy Forcasting and related topics so that we may in the future
	expand our database to incorporate relevant information and/or
	corroborate with others in this area.

	Thank you for your attention. I can be reached at:

	lisa@hobbes.lbl.gov

	or

	Lisa Stewart
	Energy and Environment Division
	Lawrence Berkeley Laboratory
	1 Cyclotron Road, 90-4000
	Berkeley, CA 94720
From: tjohn@ecst.csuchico.edu (Todd A Johnston)
Newsgroups: comp.databases
Subject: WANTED CORRESPONDENCE: Borland's Objectvision DBMS Front-Ends
Date: 6 Oct 92 16:34:25 GMT
Organization: California State University, Chico
NNTP-Posting-Host: cscihp.ecst.csuchico.edu


	We are in the process of developing a Client\Server DBMS with
NETWARE SQL 3.0.  We have opted to use Borlands Objectvision for some of our
front-end development in conjunction with Pioneers Q&E DLL library.  I would 
like to get some correspondence with other developers to share ideas and
problems.  Look foward to working with you! 

						

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

         /////////////////
         /  /---  ---\   /
         /    O \  O     /
         /       \       /
         /      __|      /                      Todd A Johnston
         /  |========|   /                      Method Engineering Data Systems 
         /      ()       /                      Chico Ca. 95928
         /////////////////                      (916) 894-1135
             CHIPHEAD                           (916) 894-1524 FAX
             SOFTWARE                           tjohn@cscihp.csuchico.edu

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Newsgroups: comp.databases
From: awerman@panix.com (Aaron Werman)
Subject: Re: Simple? SQL query??
Date: Sat, 26 Sep 1992 23:45:48 GMT
Organization: PANIX Public Access Unix, NYC

In <19t1sjINNdak@escargot.xx.rmit.OZ.AU> arthur@otto.bf.rmit.oz.au (Arthur Adamopoulos) writes:

>...  I've got tables similar to the following:

>  student(student_no,surname)
>  stusub(student_no,subj_num)
>  subject(subj_num,subj_name)

>  What I want to get is a listing that looks something like this:

>     Student Number  Surname  Subject  Subject Name
>                              Subject  Subject Name
>                              Subject  Subject Name

	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) 
				/* 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>

	With a little clean-up, (e.g. qualify the nonunique column names,
	add an ORDER BY) and the job is done.

		Aaron
-- 

Aaron Werman		awerman@panix.com
From: carl.pedersen@dartmouth.edu (L. Carl Pedersen)
Newsgroups: comp.databases
Subject: Re: Simple? SQL query??
Date: 28 Sep 92 20:25:45 GMT
Followup-To: comp.databases
Organization: Dartmouth College

In article <1992Sep28.025230.29537@nuscc.nus.sg>, chanhc@iscs.nus.sg wrote:
> 
>>[Ommitted (Censored) Horrible mess of SQL using UNIONs etc. in devious ways to >>produce a complex report.]
> I'll really like to hear from anybody who try this with any SQL systems.

I specifically advised against this technique for solving the original
problem (suppressing duplicate values in a column) in my posting on this
subject, since BREAK provides a much simpler solution.  

However, BREAK and the other formatting commands in SQL*Plus don't solve
all such formatting problems.  I have a number of messy reports that I do
using UNION.  Send me email if you want examples.

I'm sure Oracle Corp. would recommend using SQL*ReportWriter for this sort
of thing.
Xref: sparky comp.databases:7046 comp.databases.theory:505