HDTenEightyP/NetNews huggingface dataset:
From: rjmartin@extro.ucc.su.OZ.AU (Trilogy Business Systems)
Newsgroups: comp.databases
Subject: Re: Sybase and Interactive woes
Date: 22 Jul 92 00:28:16 GMT
Organization: Sydney University Computing Service, Sydney, NSW, Australia

mosmith@asc386 (Matt Smith) writes:

>We are currently using version 3.2 of Interactive and
>version 4.2 of Sybase.  As the subject implies, we seems to be having
>great difficulty keeping the Sybase server up.  If there is anybody
>out there using this configuration or could suggest a better one, I would
>really like to hear from you.

We are currently running 4.2 on SCO ODT 1.1 and SCO Unix 3.2., and while we 
have had our fair share of problems, the system is up around 99%+ of the time.
Our local sybase people are fairly helpful, although when we get really
hairy problems they are referred back to the U.S.

Something to be really careful about is the number of streams parameters 
configured in the kernal. The first set of release notes were ** WRONG ** 
about how many to set up (I think they just thought of some numbers that
would never be exceeded). You can use the crash command, and then use strstat
to see how these are going, also make sure you have a good reliable maths 
co-processor (387 compatable), apparently this can cause problems. One last
thing to look at is the amount of available free ram, and if all else fails,
try dumping the database, re-install, and start from scratch. We had some 
problems with a demo machine that used unix files as the database devices,
and occasionally it wouldn't be able to open the log device, thereby marking
the associated database as being hopelessly corrupt. I then manually changed
the database status. This happened a few times, and although DBCC came up
reporting no problems, we finally got to the point where the server would
crash at the least excuse. I re-installed with BCP'd data and re-loaded the
triggers etc, and no more problems. We ** think ** that the reason it was
crashing in the first place was because we were running NFS, or, that
we had changed NOFILES from 60, which is a bit of a No No in that release of
SCO ODT

Hope this helps.

John Martin
Software Manager
Trilogy Business Systems
Newsgroups: comp.databases
Subject: dBASE IV multiple index files
From: Alexandre Pechtchanski <APPMS@CUNYVM.BITNET>
Date: Friday, 31 Jul 1992 15:56:01 EDT
Organization: City University of New York/ University Computer Center
Supersedes: <92213.120846APPMS@CUNYVM.BITNET>

Hi, everybody:
I've heard a statement that seems pretty doubtful to me:
"... With .MDX files, all indexes are updated automatically, with
only one DOS File Handle, instead of one DOS File Handle for each index.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
This frees up RAM and ... to make program more efficient (read faster)."
^^^^^^^^^^^^^^^^^                              ^^^^^^^^^^^^^^^^^^^^^^
I was always pretty sure that no matter what you do you have to allocate
one DOS file handle (either explicitly or implicitly) for each file you
access.  For dBase it spells one handle for each .DBF + one for each
.NDX etc.  The only way (IMHO) to circumvent it is to use one handle
for different files at different time, but it sure will lead to
_in_efficiency of program!
Can anybody confirm/disprove the above statement? (I mean the quoted
one, also all are welcome to spill flames on me for my apparent
stupidity ;-) )

    Thanks in advance
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
ALEX PECHTCHANSKI, GCRC SYSTEM MANAGER   PHONE: (212) 241-1804
MOUNT SINAI MEDICAL CENTRE, NEW YORK  -------------------------
INTERNET: DESNICK@MSVAX.MSSM.EDU      #INCLUDE <STD.DISCLAIMER>
BITNET:   APPMS@CUNYVM                
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Newsgroups: comp.databases
From: steve@dmntor.UUCP (Steve Pozgaj)
Subject: Empress Server
Summary: Newest release seems buggy
Organization: Digital Media Networks, Toronto, Canada
Date: Wed, 29 Jul 92 13:38:38 GMT

We have been using the newest release of Empress DBMS for a month now.
This features the server-based DBMS, and significantly speeds up use vs.
the older NFS-based version.  However, it seems quite buggy.  Empress
staff are *extremely* helpful and dilligent in addressing the bugs, but,
nevertheless, this makes for a difficult development situation, especially
when the ultimate application is mission-critical to ouur company.

So ... I was wondering if there's anybody else out there with this newest
release.  What type of success are you having in using it?

Please email responses (or post, if generally significant), as we are
continuing to evaluate our options.

P.S. We run on a SUN platform.
-- 
Steve Pozgaj (signature in postmark; cute remarks in comics section)
From: gt2768b@prism.gatech.EDU (JENGLUNG LIN)
Newsgroups: comp.databases
Subject: How to disable Ctrl+break in clipper application?
Date: 31 Jul 92 14:15:22 GMT
Distribution: usa
Organization: Georgia Institute of Technology

There are no INKEY() value listed in reference manual of Clipper about
ctrl+break which stops my program deadly.

Is there any way to disable it? Thanks in advance for helping me out.
-- 
LIN,JENGLUNG
Georgia Institute of Technology, Atlanta Georgia, 30332
uucp: ...!{allegra,amd,hplabs,seismo,ut-ngp}!gatech!prism!gt2768b
ARPA: gt2768b@prism.gatech.edu
Newsgroups: comp.databases
From: viking@iastate.edu (Dan Sorenson)
Subject: Re: FoxPro and Foxbase
Organization: Iowa State University, Ames IA
Date: Wed, 22 Jul 1992 03:56:26 GMT

In <1992Jul21.183200.27181@CAM.ORG> robert@CAM.ORG (Robert Masse) writes:

>  Can I compile my Foxbase v2.00 program and run it on a FoxPro v2.00 copy?
>Ie: Compile a database program under foxbase 2.0 and give it to someone who
>has Foxpro.

>  Does this work?  Or would I need to buy a development kit for FoxPro 2.0?

	I've seen this question a couple times locally, so figured I post
for all the world to see.  FoxBase and FoxPro do not really compile.  It
might be easiest to think of it as tokenizing things for a really fast
interpreter to follow.  This isn't it exactly, but close enough for our
purposes.  To truly compile, you need the development kit.  That makes a
stand-alone .EXE file, which will run on any compatible machine.

	If you want to run FoxBase code under FoxPro, include your source
code and compile it under FoxPro.  You can do the reverse operation, but
FoxPro has a few nifty functions that FoxBase doesn't and you'll have to
work around these.  Normally there is little problem.

	The source is the common link here -- give it to your friend and
he should be able to run it without problem.

	Side Note: I took a FoxPro application on a clone to a Mac, using
the same database files.  It compiled and read the data files fine under
FoxBase on the Macintosh.

<Dan Sorenson, DoD #1066 |"There'll be angels on Ariels in leather>
<z1dan@exnet.iastate.edu | and chrome, Ridin' down from heaven    >
<viking@iastate.edu      | just to carry me home." -- R. Thompson >
< ISU thinks I need more education, which they provide for a fee. >

Newsgroups: comp.databases
From: jrg@mtl.mit.edu (john gilbert)
Subject: Objectivity & OODBs
Organization: MIT  EECS Dept
Date: Wed, 29 Jul 1992 23:52:20 GMT

I've been looking into OODBs lately.  I tried to get information on
Objectivity from them and ran smack into a request to sign a rather
excessive non-disclosure agreement.  I did NOT want source code, or anything
other than whatever is in the standard release.  Is this the common
experience with Objectivity?   What about other OODB vendors?  I certainly
found it easier to get information from Versant.

john
From: drew@netcom.com (Drew Wade)
Newsgroups: comp.databases
Subject: Re: Objectivity & OODBs
Date: 30 Jul 92 20:57:17 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

John,

sorry you were dissapointed.  i can't comment on versant's or others'
policies, but we do protect our documentation, product, and certain internal
design concepts under  non-disclosure and otherwise.  (i believe this is
common in the database and software industries).  however, we do give
out product literature discussing the capabilities, invite prospective
customers to demos, arrange for training programs, evaluations, consulting
and joint projects, present articles and oral presentations (e.g., at last
sigmod we spoke in some detail about our fully distributed and heterogeneous
architecture, unique in the databse world).

the address, telephone, fax and email (info@objy.com) for product information
is shown below, including your local office (boston area).  feel free to 
contact me or the boston office and we'll do our best to help you.
i hate to see an alumnus of my alma mater left out in the cold!  :)

-Drew Wade
Objectivity, Inc.
800 El Camino Real
Menlo Park, CA  94025 USA
drew@objy.com
l1(415)688-8000 voice
l1(415)325-0939 fax
admin ass't:  Vickie Clements (vickie@objy.com)
information:  info@objy.com

67 South Bedford St., Ste. 400W
Burlington, MA  01803
(617) 229-5817
(617) 272-0558 fax

11050 Strathmore Dr., #316/300B
Los Angeles, CA  90024
(310) 208-6117
(310) 208-5677 fax




In article <1992Jul29.235220.27901@athena.mit.edu> jrg@mtl.mit.edu (john gilbert) writes:
>I've been looking into OODBs lately.  I tried to get information on
>Objectivity from them and ran smack into a request to sign a rather
>excessive non-disclosure agreement.  I did NOT want source code, or anything
>other than whatever is in the standard release.  Is this the common
>experience with Objectivity?   What about other OODB vendors?  I certainly
>found it easier to get information from Versant.
>
>john
>
From: amigan@cup.portal.com (R Michael Medwid)
Newsgroups: comp.databases
Subject: dBase IV output question
Date: Thu, 30 Jul 92 17:45:46 PDT
Organization: The Portal System (TM)
Distribution: na

dBase IV questi

I would like to import some data from a dBase program into Lotus 1-2-3
so I can use the fancy printing features of its ""Impress" add-in.  In
my dBase program I create a bunch of variables e.g.

SUM COST FOR TERR="1111" .AND. PROD="VOL" .AND. TYPE="MLS" TO MVAR1
SUM COST FOR TERR="1112" .AND. PROD="VOL" .AND. TYPE="MLS" TO MVAR2
SUM COST FOR TERR="1113" .AND. PROD="VOL" .AND. TYPE="MLS" TO MVAR3

(etc.)

I now want to take MVAR1, MVAR2 and MVAR3 and get them either into
a database or into cells of a spreadsheet.  I know how to write these
to a flat file.  But to bring a flat file to lotus requires you then
"parse" the data to get the data elements into individual cells, not
a lot of fun.

I would appreciate some insight on how best to accomplish this.

Thanks!

-Mike
amigan@cup.portal.com

 
Newsgroups: comp.databases
From: newson@eecs.nwu.edu (Bryan M. Newson)
Subject: FoxPro 2.0/PS-Print printing problem
Organization: EECS Department, Northwestern University, Evanston, Il., USA
Date: Sat, 25 Jul 1992 00:02:36 GMT

I am running FoxPro 2.0 on a Novell network and I am having problems sending
(or should I say ending) print jobs that are sent to the printer via PS-Print.
After every print job, the user has to manually queue the job by pressing
the hot keys to activate PS-Print and then recapturing the printer.  I also
have Wordperfect on the same network and it seems to end its jobs properly so
that these added steps aren't necessary.

Can anyone tell me how to alleviate this problem?

Thanks in advance for any help,

Bryan Newson
newson@delta.eecs.nwu.edu
From: v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad)
Newsgroups: comp.databases
Subject: Query Question:
Date: 25 Jul 92 22:05:00 GMT
Organization: University at Buffalo
News-Software: VAX/VMS VNEWS 1.41


	Under Foxpro 2.0, If The User makes a change to a record
	in a cursor.  What is the best/fastest way to make the
	change in the original database?  I Tried re-selecting the
	original database and seeking on the indexed expression, but
	since it is no longer unique, It is not always returning to 
	the correct one.

Thanks.

Ami
From: aahz@netcom.com (Aahzmandius)
Newsgroups: comp.databases
Subject: Re: Paradox "Multi Pack"
Date: 23 Jul 92 18:13:36 GMT
Organization: Bill 'n' Opus for Prez

In article <Jul.22.17.12.11.1992.5169@dimacs.rutgers.edu> magarell@dimacs.rutgers.edu (Christopher Magarelli) writes:
>
>     Is there anybody out there who knows anything about the Paradox
>"Multi Pack"?  I have heard some references to it, but am not sure
>what,exactly, it is and the university purchasing department is not
>much help.  
>     I'm pretty sure that it's not the same thing as the "Lan Pack",
>which is ok.  Is it something like one set of manuals and 5 rights to
>copy or what?

Actually, it is identical to the LAN Pack, except that the MultiPack has
5 licenses instead of one.
-- 
                         --- Aahz (the *other* Dan Bernstein)
                             @netcom.com 

Hugs and backrubs -- I break Rule 6

Babbage's Birthday Bargain Bash -- December 26th, 1992
Newsgroups: comp.databases
From: scairns@is.morgan.com (Scott Cairns)
Subject: KNOWLEDGEWARE ?
Organization: Morgan Stanley - IS
Date: Wed, 29 Jul 1992 13:07:24 GMT

A friend is pursuing a position with a local firm (Westchester County
in New York) where she is qualified in every respect except the
position lists a "plus" as knowing something called KnowledgeWare
ADW or something like that.  (Is this Fran Tarkenton's company?)

She doesn't know the product but would like to at least seem
knowledgeable (pardon the pun) about it and hope the balance of
her skills will win out.

Is this the right place to post this question?  I'm not even sure
if this product is a database and it's definitely related to 
the mainframe world (gag!).

Any info would be appreciated.

-- 
+-----------------------------------------------------------------+
| Scott Cairns           	|   email: scairns@is.morgan.com  |
|                     		|      or: scairns@fsg.com	  |
+-----------------------------------------------------------------+
| Standard disclaimers apply.   				  | 
+-----------------------------------------------------------------+
| Standard satirical comment/quote in test phase. 		  |
| Beta release forthcoming.					  |
+-----------------------------------------------------------------+
From: Jim_Sollows@mindlink.bc.ca (Jim Sollows)
Newsgroups: comp.databases
Subject: text > dbase.dbf
Date: 28 Jul 92 00:23:44 GMT
Organization: MIND LINK! - British Columbia, Canada
Distribution: world

Is there any way to take a text file of data and transfer it into a dbase IV
DBF file?

Newsgroups: comp.dcom.isdn
From: deej@cbnewsf.cb.att.com (david.g.lewis)
Subject: phone numbers (was Re: Develcon, on the net? any experiences?)
Organization: AT&T
Date: Thu, 30 Jul 1992 13:44:39 GMT

In article <157creINNdd6@nigel.msen.com> emv@msen.com (Edward Vielmetti) writes:

(actual topic of discussion deleted...)

>Phone #s (FYI) are
> +1 800 667 XXXX
  ^^^^^^
> +1 306 933 XXXX (Saskatoon, SK, Canada)
> +1 800 423 XXXX (Atlanta, GA, USA)
  ^^^^^^
> +1 708 452 XXXX (Chicago, IL, USA; regional sales, George Bodnar)

Note that use of the "+1 NXX" notation when NXX= 800 or 900 is not precisely
correct.  +1 implies that the call is dialable from non-World Zone 1 (WZ1)
locations (the "+" represents the nation-specific international access code,
and the "1" the country code).  North American 800 and 900 calls are not
generally dialable in this manner.

David G Lewis                              AT&T Bell Laboratories
david.g.lewis@att.com or !att!houxa!deej     Switching & ISDN Implementation
Newsgroups: comp.dcom.isdn
From: etxorst@eos.ericsson.se (Torsten Lif)
Subject: Re: The D channel: how is it used & billed?
Reply-To: etxorst@eos.ericsson.se
Organization: Ericsson Telecom AB
Date: Thu, 23 Jul 1992 08:05:07 GMT

In article nkrqajs@rhyolite.wpd.sgi.com, vjs@rhyolite.wpd.sgi.com (Vernon Schryver) writes:
>Do I understand this right? $0.60/(1000*128Bytes)  Or $8*.6 = $4.80/MByte?
> [...]
>So a long distance B channel is about 17 times as cheap as a D-channel.
>A v.32bis modem is about 8 times as cheap as a D-channel.
>
>What have I computed wrong?  Why is anyone even slightly interested in
>buying D-channel bits?

Mainly because they don't use up the B-channels. The D-channel is a
low-speed resource and to make things worse, anything you send through
it probably gets routed through the CO's CPU (as opposed to the
B-channel which is handled by dedicated switching circuitry). If it's
ONLY 17 times more expensive than B-channel data you're getting a
bargain! I'd guess a cost difference of 50 - 100 times would be more
appropriate. Why do you suppose several readers have reported that in
their regions, D-channel data is not available at all?

Some reasons to use the D-channel anyway could be:

    Both B-channels are busy and it's more important to get through NOW
    than to wait for a B-channel to become available.
    
    You don't yet even know if a B-channel is at all available (i.e.
    you're in the call set-up phase) or you want to send data that
    might affect the outcome of the set-up attempt (it's quite feasible
    to use the User-info element in the Setup signal to provide a
    password or some other identification that the other party may
    require to accept the call). (The amount of data involved here is
    probably extremely small but the CO can still charge you for it.)
    
    The amount of information you want to send is so small it doesn't
    merit grabbing a B-channel.
    
    The data rate is VERY low but you still want it transmitted in
    fairly small packages and presumably over a long time. Since
    there's no time charge to a D-channel connection, you can keep it
    open as long as you want and only pay for the actual data. With a
    B-channel connection you'd need to accumulate data over a longer
    time to build up a package sufficiently large to merit a full
    setup-transmit-disconnect cycle. (I had to strain myself to come up
    with this one. I doubt if there is any real traffic situation that
    fits the bill.)

Personally, I'd say that the only application I can think of right now
where using D-channel connections is really merited is in
alarm/supervision/data-gathering where unattended equipment sends info
to a central server at un-scheduled times and where immediate access is
more important than data speed and/or price.

>Vernon Schryver,  vjs@sgi.com

---
 Torsten Lif
 Ericsson Telecom AB, EO/ETX/TX/ZD
 S-126 25  STOCKHOLM, SWEDEN
 Phone: +46 8 719 4881

From: spero@hpindda.cup.hp.com (Spero Koulouras)
Date: Wed, 22 Jul 1992 19:27:40 GMT
Subject: Re: ISDN cards for SBus (SUN SparcStations)
Organization: HP Information Networks, Cupertino, CA
Newsgroups: comp.dcom.isdn

It seems there is a good bit of confusion about the topics of D and 
B channel and how exactly to transport IP in an ISDN environment.  We
have implemented a product which does this and here is a rough outline
of how it works:

  When one computer wants to establish a TCP/IP connection with 
  another computer,  there are a few well-defined mechanisms in
  TCP/IP which allow it to do so.  Generally,  an IP router provides 
  connections between various networks using dedicated leased line
  facilities.  When ISDN comes into the picture,  the biggest change is
  getting rid of the leased lines and inserting "dial-up" services.
  The router needs to gain the intelligence to know how to make a 
  call when a connection to a machine not on the local net is
  requested.

  In the ISDN environment when a TCP/ISDN router detects a TCP/IP 
  request to a machine which is not on the local TCP/IP net,  the
  router can check a database to determine if that TCP/IP address
  can be accessed via ISDN.  If so,  the router uses the ISDN D
  channel to send a Call Setup request between one of its B channels
  and a B channel of the target network.  An ISDN device on the target 
  network must acknowledge the D channel message and establish 
  the B channel connection.

  The D channel uses STANDARD based protocol for setting up
  a call between the two B channels.  The D channel standards are Q.931
  and Q.932 at layer 3 with LAPD at layer 2.  

  Once the B channel is set up,  it acts like a 64KBPS serial line.
  ISDN does not impose any layer 2 or layer 3 protocol on the B channel.

  The ISDN router can monitor traffic across the B channel and 
  set up additional B channels if traffic demands and if the hardware
  is available at both ends.


Hope this helps,

  Spero Koulouras
Newsgroups: comp.dcom.isdn
From: nbhandar@enuxha.eas.asu.edu (Narendra Bhandari )
Subject: Need Q931 Protocol -ftp site.
Organization: Arizona State University, Tempe, AZ
Distribution: usa
Date: Wed, 22 Jul 1992 01:44:04 GMT



We are trying to obtain an electronic copy of the Q931 protocol

documents(original). I have scavenged the ftp.uu.net only to

find that a few of the files are missing.

I looked under :

	/doc/standards/ccitt/1992/q

If anybody could suggest an alternative site/means of getting

a copy can mail to me directly

Thanx.

--
|-^-^-^-^-^-------------Narendra Bhandari-------------------^-^-^-^-^	|
o  Internet nbhandar@enuxha.eas.asu.edu	   				o
|  950 S Terrace Rd ,#c243 Tempe AZ 85281	(602) 921-3401	    -	|
	GENIUS IS 99% PERSPIRATION , 1% INSPIRATION
Newsgroups: comp.dcom.isdn
From: vjs@rhyolite.wpd.sgi.com (Vernon Schryver)
Subject: Re: The D channel: how is it used & billed?
Organization: Silicon Graphics, Inc.  Mountain View, CA
Date: Fri, 24 Jul 1992 06:12:24 GMT

In article <1992Jul23.215007.21963@cbfsb.cb.att.com>, deej@cbnewsf.cb.att.com (david.g.lewis) writes:
> In article <nkrqajs@rhyolite.wpd.sgi.com>, vjs@rhyolite.wpd.sgi.com (Vernon Schryver) writes:
> ...
> > A v.32bis modem will move about 1400*3600 Bytes/hr or 5MB/hr of
> > uncompressible (e.g. pre-compressed) data, and perhaps 20MB/hr of ASCII
> > text.
> 
> As has been said before, don't include compression in your comparisons,
> because if you can compress it to go over one channel, you can compress it
> to go over any other channel.  Stick with the pre-compressed numbers for
> comparison purposes - 5MB/hr.  (If you figure a consistent 14.4kb/s, it
> works out to ~6.5MB/hr; 9.6kb/s works out to ~4.3MB/hr.)

No, in this case compression must be included.  Until and unless there
are commonly available  protocols for compressing over ISDN, ISDN is
"incoopressable", while v.32bis always seems to come with v.42bis.
Apples should be compared to available apples, and the apples in this
case are "bits over the wire for $$$".

(Yes, I'm somewhat aware of the IETF PPP compression efforts.)

 
> ...
> > Long distance costs about
> > $0.11/minute anywhere in the U.S. if you're willing to pay a front-end
> > fee of about $10/month.
> 
> In general, LD doesn't cost "$0.xx/minute", it costs "$0.yy for the first
> minute, $0.xx for each additional minute".  This is relevant later on.

AT&T was not the only long distance carrier (or the one I chose--I'm
prejudiced against AT&T by having been around in the Caterphone
Decision and later DAA eras) that wanted to sell me a "~$10/month for a
flat rate anywhere in the US package."


> ...
>                                             Setting up and tearing down 240
> calls a day, assuming a 50% premium for the first minute and one-minute
> minimum billing periods, would cost $79.20 - the first-minute cost
> dominates.  Using the per-segment cost Fred cited, the total would be $11.52.

Are you sure about that?  I have not purchased switched-56.  I have
purchased vanilla long distance, and I'm paying the same for the 1st
minute as for the 2nd.

There is a "set-up penalty" even with flat rates if the calls
require << 1 minute.  Is that what you mean?


> So if you assume that the purpose of the channel is to pump as much data
> through in as little time as possible, you're right - D-channel packet isn't
> appropriate.  However, if you assume a different application - particularly
> anything that operates in a query-response mode, especially if it's a
> multipoint interface with, say, a half-dozen terminals hanging off it - the
> parameters change and things crossover.

Ok.


Vernon Schryver,  vjs@sgi.com