HDTenEightyP/NetNews huggingface dataset:
From: lawrence@combdyn.CombDynLtd.MedicineHat.AB.CA (Lawrence Chen)
Subject: Bullet Proof Network Database Wanted
Summary: Wanted: UNIX Network Database, capable of surviving power outages
Keywords: network database unix reliable
Organization: Combustion Dynamics Ltd.
Date: Mon, 5 Oct 1992 17:14:49 GMT

I'm looking for either a Network Database product or a way to make
Raima Data Manager for UNIX that's capable of surviving powerfailures.

Our application is in use by the Military which have a requirement that the
systems be able to survive random power outages.  Aside from the fact that
not having at least one outage a day is considered a miracle.

If its not possible to have the database bullet proof to this kind of failure,
at least have enough redundancy that its auto-recovery can fix the damage....
even if it means losing the current transaction, just as long as the system
remains usable.

-- 
 --EMAIL-----------------------------------------PHONE-----------FAX-------
 | WORK: lawrence@CombDynLtd.MedicineHat.AB.CA | (403)529-2162 | 529-2516 |
 | HOME: dreamer@lhaven.uumh.ab.ca             | (403)526-6019 | 529-5102 |
 --------------------------------------------------------------------------
  disclamer = (working_for && !representing) + (Combustion Dynamics Ltd.);
Newsgroups: comp.databases
Subject: Manipulating File Structures
From: paulm@steelmel.bhp.com.au
Date: 1 Oct 92 12:04:03 +1000
Reply-To: paulm@steelmel.bhp.com.au
Distribution: world
Organization: BHP steel - Melbourne
Keywords: Database, File Structures, Index

I am writing a data processing program in Pascal (THINK Pascal for the Mac.),
and I am a bit short in expertise on the manipulation of file structures. 
Specifically, I am interested in efficient methods of sorting files too large
to read into RAM, and in creating indexes on disc (or indices, I suppose is the
correct grammar).

I have been to the local book store, and they were unable to help me.  Is
anyone able to reccommend any *good* books on the subject ? (I found one or two
pretty poor ones).  Perhaps there are journal articles, or some alternative
sources?.  

I don't really want to get bogged down in the subject; I would like to get
started on a few algorithms fairly shortly.  



Thank you for any assistance.



Paul Murcott.


Newsgroups: comp.databases
From: kevinb@utopia.resntl.bhp.com.au (Kevin Black)
Subject: Re: Advanced Revelation Users?
Organization: BHP Research - Newcastle Laboratories
Date: Wed, 30 Sep 1992 04:45:06 GMT

Yes there are AREV users read this news group, count me in.

-------------------------------------------------------------------/\/\---
Kevin Black     Computer Systems Group Leader                     / / /\
                BHP Research - Newcastle Laboratories, Australia / / /  \
Snail   :       P.O. Box 188, Wallsend 2287                     / / / /\ \
Tel     :       +61 49 510434 Fax: +61 49 513740                \ \/ / / /
Internet:       kevinb@resntl.bhp.com.au                         \  / / / 
------------------------------------------------------------------\/\/\/--
Newsgroups: comp.databases,comp.object
From: skow@cs.utwente.nl (Jacek Skowronek)
Subject: WANTED: Fax number of O2 Technology
Organization: University of Twente, Dept. of Computer Science
Date: Thu, 1 Oct 1992 13:42:36 GMT

Does anybody know it? Can You send it to me?

Jacek
-- 
-------------------------------------------------------------------
Jacek Skowronek				e-mail: <skow@cs.utwente.nl>
Department of Computer Science
Twente University
Enschede, The Netherlands
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 22:25:45 GMT

In article <1992Oct1.193731.10882@glv.uucp> bob@bobsled.glv.com  (Bob Lunney)  
writes:
> I should talk to Rob more often.  

Yes you should.  Didn't know about that one, thanks Bob!
--
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,comp.databases,comp.sys.novell,comp.databases.[ktheory
From: susan@moo.org (Susan Dean)
Subject: Please Help!
Reply-To: susan@moo.org (Susan Dean)
Organization: Datanet Communications Company
Distribution: na
Date: Sun, 27 Sep 1992 22:05:19 GMT

 
I posted this message sometime ago, but I didn't receive any answers
so I am trying again in case it did not make its way around.

I have a question that maybe someone can help me with. We are working in a
client/server environment with Novell 3.1, Novell LAN WP,TCP/IP (ethernet), 
Sybase and Power Builder. Sybase is on
a RISC 6000 V 3.1.6 of AIX. After running a Power-Builder Application on a
386 running windows 3.1, we sometimes receive the following error messages:

Write to SQL server fail
Db process dead or not enable

The errors are being reported from the Sybase Netlib DLL's on the client.

 The RISC Sybase server will sometimes report a error # 1608
"Network error was encountered while sending results to front end"

But then at other times
the program will run without errors. In trying to find the problem we took
and put only two RISC 6000's and a PC on their own network. Still the same
problem. So it appears network traffic is not the problem.  The connection
appears to fine and then the connection just gets dropped by someone.

Does anyone have any ideals that may be the cause or something else we can
try doing/looking at? Right now ANY ideas will be helpful, as we are near
the end of the line. A post of email replies are ok, as I check this group
daily. Thanks!!!

susan@moo.org
-- 
"susan@moo.org"
Newsgroups: comp.databases.sybase,comp.databases,comp.sys.novell,comp.databases.theory,comp.unix.aix,comp.windows.misc,comp.protocols.tcp-ip
From: mike@uunet!tellab5!odgate (Mike J. Kelly)
Subject: Re: Sysbase/Aix/TCP/IP/Windows
Organization: Odesta Corporation
Date: Sat, 26 Sep 1992 19:53:06 GMT

susan@moo.org (Susan Dean) writes:

> 
>I have a question that maybe someone can help me with. We are working in a
>client/server environment with Novell 3.1, Novell LAN WP,TCP/IP (ethernet), 
>Sybase and Power Builder. Sybase is on
>a RISC 6000 V 3.1.6 of AIX. After running a Power-Builder Application on a
>386 running windows 3.1, we sometimes receive the following error messages:

>Write to SQL server fail
>Db process dead or not enable

>The errors are being reported from the Sybase Netlib DLL's on the client.

> The RISC Sybase server will sometimes report a error # 1608
>"Network error was encountered while sending results to front end"

>But then at other times
>the program will run without errors.

Sounds like a Net-Library bug in the Novell LAN WorkPlace Net-Library for
Windows.  We have found similar problems in both the FTP TCP/IP and Wollongong
PATHWAY Net-Library and gotten patches from Sybase.  What seems to happen is
some TCP/IP timeout or error condition causes the windows net-library to 
shut down (hence the Write to SQL Server failed).

Call Sybase Tech Support with this problem.  Be insistent, we had to be to
get the other Net-Libraries patched.  We eventually had to send them a test
program demonstrating the problem which they could run in Emeryville to 
reproduce the problem there.
-- 
--
Mike Kelly               Odesta Corporation, Northbrook, Illinois, USA
...!clout!odgate!mike    - Until odesta.com is registered.
odgate!mike@clout.uucp   - From the Internet.
Newsgroups: comp.databases.sybase
From: mef@Unify.com (Marvin Fenner)
Subject: Re: C++ and DB-lib?
Organization: Unify Corporation (Sacramento)
Date: Fri, 2 Oct 92 20:11:32 GMT

In article <6HwVRB1w165w@bluemoon.rn.com>, miller@bluemoon.rn.com (John Miller) writes:
] > Using Borland C++ 3.1 and Sybase DBLIB for MSDOS is another story.
] > We're having problems resolving some undefined symbols during linking.
] > It appears that the DBLIB library was created with MSC which has
] > different low-level library functions than Borland.  Consequently,
] > all of the DBLIB function calls are resolved, but functions such
] > as chkstk, ldiv, fdiv, etc. are not.  We're still working on it, but
] > if anyone has suggestions, please let us know
] > (pas@informatics.wustl.edu).
] DBlibrary was compiled with MSC and is NOT compatible with other C 
] compilers.  However, Windows DB-Lib is a DLL and is open to ALL compilers. 
]  Therefore, my suggestion would be to build "quickwin" programs which do 
] MSDOS I/O but can call the Windows API (read DLL's).
] 
We have successfully built a Windows app with Watcom C which uses
DB-Library 4.2. email me if you're interested in the details.

-- 
Marv Fenner           | Mine. All mine.
Unify Corporation     | Sacramento, CA
Voice: (916)928-6266  | FAX: (916)928-640[23]  | Email: mef@unify.Com 
Newsgroups: comp.databases.sybase
From: garyng@netcom.com (gary )
Subject: Re: C++ and DB-lib?
Organization: Netcom - Online Communication Services (408 241-9760 guest)
Date: Sat, 3 Oct 1992 09:32:11 GMT

In article <vxzd0u1@Unify.Com> mef@Unify.com (Marvin Fenner) writes:
>We have successfully built a Windows app with Watcom C which uses
>DB-Library 4.2. email me if you're interested in the details.
>

Have you tried to build DOS apps using Watcom C with DB-Library 4.2 ?
I have some trouble doing that.

-gary

Newsgroups: comp.databases.sybase
From: e3urje@FNMA.COM (Robert Emerick)
Subject: Sybase Report Writer Needed						
Reply-To: e3urje@FNMA.COM
Organization: Federal National Mortgage Association
Date: Wed, 30 Sep 1992 22:26:56 GMT

I am in need of information about report writing packages on the market that 
are compatible with Sybase 4.8

I would appreciate any references to articles or actual experiences with 
any such report writers.

please feel free to e-mail to:  e3urje@fnma.com

Thanks much!!!

Bob



Newsgroups: comp.databases.sybase
From: bob@bobsled.glv.com  (Bob Lunney)
Subject: Re: Wanted: How to include a file?
Organization: Encompass
Distribution: usa
Date: Thu, 1 Oct 1992 19:37:31 GMT

In article <1992Oct1.191440.10808@glv.uucp> andersen@reality (Robert Andersen)  
writes:
> 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
> 
> --
I should talk to Rob more often.  Get into isql, and at the prompt type:

1> :r filename
27>

Notice that the colon-r (:r) must be in the *first* column to execute  
correctly. (I am the shade of FORTRAN past!  Actually, this is very similar to  
vi.)  Note that the next isql prompt shows you the number of lines that you  
read in.  At this point you can edit the sql using vi (Unix) or edit (VMS), or  
simply type "go" and execute the sql.

Bob Lunney
bob%bobsled@glv.com		NeXT mail preferred!

Disclaimer:  My company doesn't allow me to have opinions.
From: esg@pyuxd.uucp (25235-gokhman)
Newsgroups: comp.databases.sybase
Subject: Re: C++ and DB-lib?
Summary: Interfacing DB-library in C++ is easy and hard
Date: 29 Sep 92 19:13:17 GMT
Distribution: comp
Organization: Bellcore, Livingston, NJ

In article <SPENCER.92Sep25135617@guraldi.med.umich.edu>, spencer@med.umich.edu (Spencer W. Thomas) writes:
> Has anyone tried using C++ with DB-library?  Was it easy, medium hard,
> or a real pain-in-the-anatomy?  Any hints?
> 

C++ by itself does not create additional problems in comparison with C.
All you have to do is to encapsulate header-files into the extern "C"s.
For example:

	extern "C" {

	#	include	<sybfront.h>
	#	include	<sybdb.h>
	#	include <syberror.h>

	}

C++, however, creates a challange of implementing the DB-Lib interface
using principles of object-oriented design.

The most typical approach and one that is suggested in most of the literature
is to capture the schema in C++ classes, with each
class implementing its access functions, e.g. bind and put. Very often the
base classes contain a static member pointing to a DBPROCESS*, which is
shared with a class implementing db-administrative functions including
dbopen, dberrhandle, and dbmsghandle. The level of derivation at which
the DBPROCESS * is defined depends on whether or not several db processes
are used. The base class for schema-classes may also contain special
overloads for associating application-specific aggregates and Sybase
types to simplify the implementation of virtual bind and put functions.

"Fancy goodies" may include overloading operator -> for "schema" classes
to verify whether the data in the class is acceptably new or must be
retrieved based on some criteria. 

In short, as far as DB-lib is concern, using C++ is easy, but OOA/D/P is
medium hard.

Ed Gokhman, Consultant
EDIX Information Services, Inc.
Leading Sybase and UNIX Systems Consulting Firm,
879 West Park Ave, Suite 290, Ocean, NJ 07712
(908) 699-4785(b), (908) 517-1391 (fax)
(Refer to misc.jobs.contract for current Sybase/C++/Motif openings)
Newsgroups: comp.databases.sybase
From: bmcllree@ad-server.naitc.com (Bob McLlree)
Subject: Forceplan through ESQL or DB Lib
Keywords: Optimizer
Organization: AC Nielsen Co.
Date: 29 Sep 92 17:33:14 GMT

My apologies if this might be an FAQ, but we're having a problem concerning
the forceplan optimizer that perhaps someone on the net might know about.

We have a number of queries with huge joins. They take forever to run with
our ESQL and DB library C-code, but relatively litle time in the isql
utility. The reason is that the "forceplan" optimizer is on during the
isql session. Evidently, this optimizer does some massaging of the
query before it hits the SQL Server. Without it, a ludicrous number of
table searches are performed, even with indexing and careful attention to
the order of joined tables in the statement.

We'd like to do this to our embedded and DB Lib code as well. However,
our statements to that effect, while not generating an error, seem to
have no effect.

Has anyone tried this successfully, or used another technique (other than
indexing or table order in the query, which we've already done)? Email
is fine, and I'll post solutions. 

Thanks for any assistance.

Bob McIlree
AC Nielsen Co.
From: curt@emory.edu (Curt Stauffer)
Newsgroups: comp.databases.sybase
Subject: Selecting Sybase - Would you do it again?
Date: 6 Oct 92 13:14:18 GMT
Organization: Emory University

[If you've already received this article my apologies - I tried to cancel 
the original but had some trouble with the 'cancel' command in our 
newsreader]

Emory University is looking for a UNIX database as part of a right-
sizing initiative. We would like to know what tools you are using to
develop applications to use with Sybase. What has your experience
been with this database and these tools? If you were going to choose a
UNIX database today, would you buy Sybase again? Why or why not?

Please reply to the following e-mail address rather than posting a
followup article.

Thank you in advance,
Curt
--
Curt Stauffer
Emory University Information Systems
Atlanta, GA
curt@emoryu1 (Bitnet)
curt@emory.edu (Internet)
Newsgroups: comp.databases.sybase
From: dino@alex.com (Dino Fancellu)
Subject: UNIX Spreadsheets with Sybase
Keywords: spreadsheet
Organization: Alex Technolgies Ltd
Apparently-To: mail2news@news.demon.co.uk
Date: Fri, 2 Oct 1992 16:45:37 +0000

Well, LOTUS 1-2-3 v 1.1+ for SUN OS has a Sybase Datalens driver inbuilt,
in order to access Sybase. It was our technology, the Alex language,
that put the X interface, Open Look or Motif, on Lotus. Without ANY code
changes to Lotus!!! We are also the same people putting Open Look and Motif
interfaces on all APT-EDIT and APT-LIB programs extant, an automatic converter
of said programs to X. This should be out in version 5.11, or so. 
Hence we are in a good position to answer this question. Hope this helps.


Dino
From: bm@bike2work.Eng.Sun.COM (Bill Michel)
Newsgroups: comp.databases.sybase
Subject: Re: In search of DB diagramming package
Date: 28 Sep 1992 21:43:15 GMT
Organization: Sun Microsystems, Mt. View, Ca.
NNTP-Posting-Host: bike2work
Keywords: front end diagrammming software

Toni,

Schema Research produces a tool that should satisfy your
needs & more...it's a case tool for sybase that runs
on the Mac, the NeXT, and the Sun.

Contact Lowell Schneider (lowell@lsc.com) or give Schema
Research a call @ 415-368-8477.

Bill

In article <1992Sep24.155749.7851@tc.fluke.COM> toni@tc.fluke.COM (Toni Eaves) writes:
>I am looking for a software package that will create graphical
>diagrams of a database and/or data dictionaries based on the system
>tables in a sybase (sun4 server) database.  The software would produce
>a picture of all database tables and the relationships (one to many,
>one to one, etc.) between them.  It may also let you create tables and
>objects graphically as well (but this is not necessary).
>
>Preferably the software would be X based on a sun4 platform, but if
>the package exists on any platform I would be happy to hear about it.
>
>Thanks,
>Toni Eaves
>John Fluke Mfg. Co., Inc
>toni@tc.fluke.com
>-- 
>
>Toni Eaves


--
Bill Michel			
bm@eng.sun.com		These views are my own, not Sun's.
Newsgroups: comp.databases.sybase
From: seth@welchgate.welch.jhu.edu (Seth Perlman)
Subject: APT4.x appl. using tvi955
Organization: Johns Hopkins Univ. Welch Medical Library
Date: Tue, 29 Sep 1992 14:15:13 GMT

Has anyone figured out how to trick a version 4.x[sic!] APT-Forms application
into running on a Televideo 955 terminal?

Thank you...
Seth Perlman                
Johns Hopkins Univ., Welch Lab Rm. 3022
1830 East Monument Street      (410)955-7198
Balt MD 21205                  seth@library.welch.jhu.edu (Internet)
Newsgroups: comp.databases.sybase
From: miller@bluemoon.rn.com (John Miller)
Subject: Re: C++ and DB-lib?
Organization: Blue Moon BBS ((614) 868-998[024])
Date: Tue, 29 Sep 92 18:33:16 EDT

> Using Borland C++ 3.1 and Sybase DBLIB for MSDOS is another story.
> We're having problems resolving some undefined symbols during linking.
> It appears that the DBLIB library was created with MSC which has
> different low-level library functions than Borland.  Consequently,
> all of the DBLIB function calls are resolved, but functions such
> as chkstk, ldiv, fdiv, etc. are not.  We're still working on it, but
> if anyone has suggestions, please let us know
> (pas@informatics.wustl.edu).
DBlibrary was compiled with MSC and is NOT compatible with other C 
compilers.  However, Windows DB-Lib is a DLL and is open to ALL compilers. 
 Therefore, my suggestion would be to build "quickwin" programs which do 
MSDOS I/O but can call the Windows API (read DLL's).

I haven't tried this, but I think it will work.

John Miller - 76467.1465@compuserve.com

 This is from
     miller@bluemoon.rn.com
who doesn't have his (or her) own obnoxious signature yet
Newsgroups: comp.databases.sybase
Date: Wed, 30 Sep 92 21:25:35 EDT
From: lcc5@cs.columbia.edu (Li-Chung Chang)
Subject: Re: C++ and DB-lib?
Organization: Columbia University Department of Computer Science

In article <1992Sep29.191317.11364@porthos.cc.bellcore.com> you write:


>	extern "C" {
>
>	#	include	<sybfront.h>
>	#	include	<sybdb.h>
>	#	include <syberror.h>

I also have to change the signatures of functions in sybdb.h ( don't know if I
can avoid doing that? ) in order to compile...

For example:	dbcmd(); // in original
		dbcmd( DBPROCESS*, char *);

( I'm using DB-lib 4.0 , using C++ to build a Mickey-Mouse object-interface on
top of DBPROCESS. (sun4/AT&T CC 3.0 ), took 2 day of programing but 1 week to 
decide what OO interfaces programmers like to see....)

Eric
From: kjb@moscom.com (Kevin Bierre)
Newsgroups: comp.databases.sybase
Subject: Internationalizing a Sybase Application?
Keywords: APT, International
Date: 30 Sep 92 18:46:30 GMT
Organization: Moscom Corp., Pittsford NY
X-Newsreader: Tin 1.1 PL5



	I am working on an APT based application that will be used
	internationally. The problem I'm having is determining how to
	best support the various forms in multiple languages.

	Unfortunately, it appears that each form will have to be replicated
	in each language, with each version using the appropriate language
	for it's prompts, help messages, etc. The same holds true for the
	processing attached to each form.

	We are running on Sun equipment, using version 4.2 of the SQL
	Server and 4.0.2 of APT, but will be upgrading to the new versions
	of the software (Real Soon Now).

	I'd like to hear how others have addressed this problem.

						Thanks,
						Kevin Bierre
						kjb@moscom.com

Disclaimer: All opinions expressed above are my own. 

----------------------------------------------------------------------------
                                                      | kjb@moscom.com
  "Always code as if the guy who ends up maintaining  | 
   your code will be a violent psychopath who knows   | Kevin Bierre
   where you live." - John F. Woods                   | MOSCOM Corp.
                                                      | Pittsford, NY
----------------------------------------------------------------------------
Newsgroups: comp.databases.sybase
From: dmenns@muug.mb.ca (Darren Enns)
Subject: Summary Tables -- when to use them?
Organization: Manitoba Unix User Group, Winnipeg, Manitoba, Canada
Distribution: comp.databases.sybase
Date: Wed, 30 Sep 1992 21:31:05 GMT

First, my thanks to all that responded to my 'Use of Nulls' question.

My new question has to do with any real-life experiences/suggestions/rules-
of-thumb that Sybase users have encountered to assist in the decision of
whether or not to create extra 'summary' tables (for performance reasons).
Any info would be greatly appreciated -- our shop is still in the position
of just 'starting out' and we have no 'real' experience with situations 
that may or may not warrant the creation of additional 'summary' tables
based on 'detail' tables.

I would imagine that some of the factors are:
- how many rows does the detail table have
- how many rows does one need to summarize at a time
- how often is the summarization required
- are summary columns not contained in the detail table required
- what types of summary functions of being performed
- etc.

Please help with any tidbits/numbers/answers you can.  Thanx!

Dare
DBA Under Pressure

Newsgroups: comp.databases.sybase
From: jyoon@gmuvax2.gmu.edu (Jongpil Yoon)
Subject: Wanted: How to include a file?
Organization: George Mason University, Fairfax, Virginia, USA 
Distribution: usa
Date: Thu, 1 Oct 1992 16:40:27 GMT

Hi, Sybase users;

Undoubtly being on a FAQ, my question as a novice sybase user is:

How can I include a file containing a sequence of sql's inside the
sybase and execute it?  

Thanks in advance,
jyoon@gmuvax2.gmu.edu

-- 
Jongpil Yoon
School of Information Technology and Engineering
George Mason University
Newsgroups: comp.databases.sybase
From: tc@xrxedds.UUCP (Thomas R. Corbin)
Subject: Msg 1203
Organization: Xerox EDDS, Herndon, Va.
Distribution: comp.databases.sybase
Date: Sat, 3 Oct 1992 15:17:26 GMT


	Has anyone seen "Msg 1203" when dealing with the image datatype?
--


                                        Thomas R. Corbin
                                        Xerox/EDMS
                                        tc@xrxedds.com
					(703) 787-2035
					607 Herndon Pkwy, Suite 301
					Herndon, VA 22070