HDTenEightyP/NetNews huggingface dataset:
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Any FAME users?
Organization: U.S Dept. of Transportation
Distribution: comp
Date: Wed, 30 Dec 1992 14:26:10 GMT

Anyone out there using FAME for time-series data management?  I'd be 
interested in hearing about experiences with FAME -- either stand-alone
or tied to other statistical or DBMS software.

Seth Grimes, grimes@oecd.fr 


Newsgroups: comp.databases
From: cys@netcom.com (Cy Shuster)
Subject: Re: DBASE III/IV MDX,NDX, DBT
Organization: Netcom - Online Communication Services (408 241-9760 guest)
Date: Wed, 30 Dec 1992 16:22:34 GMT

In fact, for this kind of information (but not tech support), try
customer-support@borland.com. They have a Developer Partners program
that will give you the documentation for all the formats. 

--Cy--

DISCLAIMER: Still my opinions only.

--
Cy Shuster            Will Code For Food           NEW:  cys@netcom.com

-- 
Cy Shuster               Will Code For Food             cys@netcom.com

Newsgroups: comp.databases
From: umnoor@ccu.umanitoba.ca (Nasir Ahmed Noor)
Subject: TOOLKIT.LIB at BORLAND's BBS...
Organization: University of Manitoba, Winnipeg, Canada
Date: Thu, 31 Dec 1992 12:54:24 GMT


Hi,
I downloaded a file from Borland's BBS (408-439-9096). Its called ToolKit.zip
which yields ToolKit.Lib. Its a binary file and came from Paradox section
of BBS. Does anyone know what this file is for and what it contains (no doc
with file) and is it any usefull for a Paradox 4.0 user?

thanks.

--nasir
Newsgroups: comp.databases.sybase
From: spencer@med.umich.edu (Spencer W. Thomas)
Subject: Re: DUMP DATABASE ... - to Exabyte tapedrive ???
Date: Wed, 23 Dec 92 12:25:40 EST
Organization: University of Michigan

The trick is to declare the tape /dev/nrst? as a "disk" device.  Then
successive dumps will follow each other on tape.  Of course, you've
got to maintain your own directory of what's on the tape.

--
=Spencer W. Thomas 		|  Info Tech and Networking, B1911 CFOB, 0704
   "Genome Informatician"	|  Univ of Michigan, Ann Arbor, MI 48109
Spencer.W.Thomas@med.umich.edu	|  313-747-2778, FAX 313-764-4133
Newsgroups: comp.databases.sybase
From: scannon@bluemoon.use.com (Sam Cannon)
Subject: Curious about Sybase
Organization: Blue Moon BBS ((614) 868-998[024])
Date: Fri, 18 Dec 92 18:20:17 EST

My company has a customer who uses Sybase and I would like 
to learn something about it - from the 50,000 foot level.
What differentiates Sybase from other 4GL environments?
I'm familiar with several dbms products but not Sybase.
Are there some special qualities it has?  Thanks very
much for any passing information.

 
scannon@bluemoon.use.com        -----------------------------------------
Sam Cannon - CMHC Systems, Inc.  The Eupsychian Network - Abraham Maslow
Dublin, OH (614) 764-0143       -----------------------------------------
                                           
                "Support mental health or I'll kill you"
 
Newsgroups: comp.databases.sybase
From: esh@prague.tss.com (Edward S. Hirgelt)
Subject: Re: Using Views for data presentation
Organization: Teknekron Software Systems, Inc.
Date: Tue, 22 Dec 1992 01:24:35 GMT


On Monday, 21 Dec 1992 10:15:48 MST, Ajay Surana & John Rome ask about
conditionals in views.

The short answer is nope, can't do it.

However, consider doing the same thing with stored procedures. You may
have to do some careful thinking to decide on what to pass the
procedure as parameters, but you should be able to accomplish some of
what you want that way. The stored procedure can do some conditional
work and decide what to return.

The big problem will be many selects instead of a single one. Any client
will have to loop over dbresults as well as dbnextrow which they should
do anyway.

Hmmm, sounds like a case for select triggers (which don't exist).

Ed



--
Ex vitio alterius	|Ed Hirgelt			|esh@tss.com
sapiens emendat suum.	|Teknekron Software Systems, Inc|
(Publilius Syrus)	|Palo Alto, Ca.			|
Newsgroups: comp.databases.sybase
From: justice@dao.nrc.ca (Gerald Justice)
Subject: Can SYBASE Server listen on two ethernet interfaces?
Keywords: SYBASE server ethernet interfaces subnets
Reply-To: justice@dao.nrc.ca
Organization: NRC/DAO/CADC
Date: Fri, 25 Dec 92 01:40:46 GMT

We have two ethernet interfaces on our SS2 server and we would like to have
clients on both of the attached subnets be able to connect to the "direct"
interface rather than be routed through another sun server to get to the
SS2's primary ethernet interface.   For more remote clients we still want to
avoid the extra hop by going to the closest interface.  But apparently the
Sybase server only listens on one interface.  A call to Tech Support
seems to confirm this but it was not at all apparent that the person I
spoke really even understood what I wanted to do.  By the way this is not
a performance issue so much as a reliability issue, we don't want the
remote sites to have to depend on the third-party server having to be up just
to route the packets to the second sub-net.  If we turn it around then it
becomes a performance issue because we will be moving our local traffic which
is much more significant through this third-party server and that would be 
unacceptable.  We could reconfigure the topology so that the local traffic
and remote traffic appear on the same sub-net but it seemed so simple to
have two interfaces and after all whoever heard of a network application
which cared what interface the connections were arriving on?
---
Gerald Justice
Unix Systems (and Sybase) Manager
Phone:     (604) 363-0055  PDT      Fax:    (604) 363-0045    Telex:  049-7295 
Internet:  justice@dao.nrc.ca       Mail:   Dominion Astrophysical Observatory 
                                            National Research Council (Canada) 
BITNET:    justice@nrcdao                   5071 W. Saanich Road 
                                            Victoria, B.C.   CANADA  V8X 4M6

Newsgroups: comp.databases.sybase
From: wall@mcm.com (Steve Wall)
Subject: Warning - don't repeat my Open Client/C mistake
Organization: Mellon Capital Management Corp. San Francisco, CA.
Date: Wed, 23 Dec 1992 00:20:16 GMT

I just wasted quite a bit of time tracking down a bug in an Open
Client/C program that calls dbfcmd() to post data and/or errors
to various database tables.

The problem is that there is a limit of 16 (my experience - the
4.6 Open Client/C doc dated 8/92 [page 2-99] says 8...) arguments
that can be handed to each call to dbfcmd(). Well, of course I'm
cruising right along, add a new column to a table, add the column
to the Open Client/C program, and OOPS! - the new column doesn't
post correctly (seems to receive \0 values). No warning from dbfcmd()
or anything (would be nice...if it uses varags(3), it seems like
it *could* detect and notify when too many args are passed(?)).

Of course the fix is to split up the SQL to call dbfcmd() twice
with 16 (8?) or fewer args.

Can someone confirm that the limit is 16 args, not 8? If dbfcmd()
passes args directly to sprintf() (this is hinted at in the docs),
then the limit may be libc dependent (I guess).

Oh, and please no comments about not reading the documentation - I'm
well aware that I should have noted this limitation earlier.

Steve
-- 

Steve Wall (wall@mcm.com)
Mellon Capital Management Corporation
San Francisco, CA
From: ben@sybase.com (Benjamin von Ullrich)
Newsgroups: comp.databases.sybase
Subject: Re: Recovering from a log segment full condition (why model's log can fill up)
Date: 26 Dec 92 15:23:00 GMT
Organization: sybase, inc., emeryville-across-from-SF, ca

up to release 4.8, sql server stored tempdb's next object_id in the log
of the model database.  i don't remember exactly why this was
necessary, but i think it has something to do with avoiding re-issuance
of object_ids that may be in stored procedures and/or transaction logs
of all server databases.  since model is copied into tempdb at boot
time, it seemed logical to store the next object id in model.  all that
was logged was a 4-byte integer, so it could take months for the log in
model to fill up.

this problem was fixed in version 4.8 . the next object id is now stored
elsewhere.

--
..ben
------
Benjamin von Ullrich		 only i do the talking here -- not my employer.
ben@sybase.com			       {pyramid,pacbell,sun,lll-tis}!sybase!ben
Newsgroups: comp.databases.sybase
From: caw@gtech.com (Christopher A. White)
Subject: Re: Recovering from a log segment full condition
Organization: GTECH Corporation, West Greenwich, RI
Date: Thu, 24 Dec 1992 17:41:29 GMT

In article <VO!K2YHW3@linac.fnal.gov> kfreytag@mdtf14 (Kelley Trombly-Freytag) writes:
>Given this information, is there any reason not to have 
>`truncate transaction log on checkpoint` set for model??

Yeh, we've never gotten it to work.

Topher
-- 
 Christopher A. White                    | "Perfection is not optional."
 caw@gtech.com                           | 
 GTech Corporation, West Greenwich, RI   | from: Rules for sociopathic
 The opinions expressed are mine alone   |       obsessive-compulsives
Newsgroups: comp.databases.sybase
From: Thomas Weyer <TW9@CornellC.CIT.Cornell.edu>
Subject: re: MSW Excel to Sybase  over TCP/IP ?
X-Xxmessage-Id: <A75CC31C2D01F94C@tom-weyer.cit.cornell.edu>
X-Xxdate: Tue, 22 Dec 92 13: 05:32 GMT
Nntp-Posting-User: taw1@cornell.edu
Organization: Cornell University/Information Resources
X-Useragent: Nuntius v1.1.1d16
Date: Tue, 22 Dec 1992 18:00:37 GMT

In article <1992Dec22.162307.18192@samba.oit.unc.edu> Dave Laudicina,
dil.admin@mhs.unc.edu writes:
>>Are there products allowing the access of Unix Sybase 
>>servers from Excel for Windows over TCP/IP.
>>
>>Thanks
>>-Florian
>>
>Excel 4.0 includes Q+E which I believe comes with drivers for Sybase SQL
>Server. I think these drivers would work with Unix SQL servers. Have
never
>done it but is in documentation.
> Dave L


Unfortunately there is CURRENTLY no macintosh version of Q+E (to my
knowledge).  Does anyone know of something else to use other then
subverting to DAL?

Tom Weyer
Cornell Information Technologies
400 CCC, Garden Ave
Ithaca, NY  14853
From: ben@sybase.com (Benjamin von Ullrich)
Newsgroups: comp.databases.sybase
Subject: Re: Recovering from a log segment full condition (don't set model's truncate log on checkpoint!)
Date: 26 Dec 92 15:35:53 GMT
Organization: sybase, inc., emeryville-across-from-SF, ca

i can give you a very good reason not to turn on the database option
'truncate log on checkpoint' on the model database.  since this database is the
template for all databases at CREATE DATABASE time, setting this option on
model makes it be automatically set on all new databases as they are created.
aside from the simple fact that this may not be what you want on all new
databases, if you are in the midst of a frenzied recovery of a major production
database (say, in the middle of the day, while all your users are down), and
you load your database backup, the first gift your clever option on model will
give you is a truncated log in front of all the transaction log dumps you were
about to apply to bring the database you just loaded up to the time of failure.
truncating the log at any time between LOAD DATABASE and your last LOAD
TRANSACTION blasts a hole in the log chain and halts the recovery operation
then & there.

getting "out of sequence" errors from LOAD TRANSACTION while your boss
and users are staring you down is NO FUN, and causes you unneeded embarassment 
when you call tech support for help because you KNOW you're "in sequence."

avoid this potentially aggrivating situation and don't set truncate log on
checkpoint on model.  upgrade your sql server to 4.8 or 4.9.1 , and get
this and many other problems fixed.

--
..ben
------
Benjamin von Ullrich		 only i do the talking here -- not my employer.
ben@sybase.com			       {pyramid,pacbell,sun,lll-tis}!sybase!ben
From: dricejb@drilex.dri.mgh.com (Craig Jackson)
Newsgroups: comp.databases.sybase
Subject: Re: MSW Excel to Sybase  over TCP/IP ?
Date: 26 Dec 92 14:36:44 GMT
Organization: DRI/McGraw-Hill, Lexington, MA
NNTP-Posting-Host: bbn.com

In article <1992Dec22.162307.18192@samba.oit.unc.edu> dil.admin@mhs.unc.edu (Dave Laudicina) writes:
>>Are there products allowing the access of Unix Sybase 
>>servers from Excel for Windows over TCP/IP.

>>-Florian

>Excel 4.0 includes Q+E which I believe comes with drivers for Sybase SQL
>Server. I think these drivers would work with Unix SQL servers. Have never
>done it but is in documentation.
> Dave L

We have done this, using the Sybase Windows Netlib
and Novell's LAN Workplace for DOS.

It seems to work fine.
-- 
Craig Jackson -- cjackson@mgh.com (Straight Internet)
dricejb@drilex.dri.mgh.com (uucp-forwarded)
{bbn,alliant,redsox}!drilex!{dricej,dricejb}
Newsgroups: comp.databases.sybase
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: recovery time at start up
Organization: Lehman Brothers
	<1992Dec30.193144.26562@midway.uchicago.edu>
Date: Thu, 31 Dec 1992 16:19:28 GMT

In article <1992Dec30.193144.26562@midway.uchicago.edu> chris@cs.uchicago.edu (Chris Johnston) writes:

>   My server will recover quickly if I checkpoint my databases
>   before I shutdown.  A checkpoint only takes one second and avoids
>   several minutes of recovery time.

>       I try to checkpoint my databases often, others on this list have
>   warned against doing it too often.  I don't know why.

 
- A "shutdown" will checkpoint all the databases before shutting down.
- "shutdown with nowait" and UNIX "kill" will not.
- No harm in checkpointing often.
- A long recovery is usually related to rolling *back* a large transaction
  the max size of which is governed by the transaction log.

 
--
warren finnerty      | 388 Greenwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com
 
Newsgroups: comp.databases.sybase
From: caw@gtech.com (Christopher A. White)
Subject: Re: Recovering from a log segment full condition
Organization: GTECH Corporation, West Greenwich, RI
Date: Tue, 22 Dec 1992 16:27:39 GMT

In article <WFINNERT.92Dec21194611@larry.shearson.com> wfinnert@larry.shearson.com (Warren Finnerty) writes:
>>In article <1992Dec21.223620.26626@gtech.com> caw@gtech.com (Christopher A. White) writes:
>
>    [ stuff deleted on shutting down server ]
>
>>   Do NOT do this if master or model is full. The server cannot restart if the
>                               ^^^^^^^
>>   log segment of one of these two is full. We've never had a problem dumping
>>   them with 'no_log' however.
>
>Strange that model being full would be a problem.
>( I'll take your word for it. :) )
>Do any of you SYBASE types want to confess to what futz'ing around in model 
>goes on in conjunction with createing objects in tempdb. ( Not at startup )

EXACTLY! If you do a lot of work in tempdb on v 4.2, model will fill up.
Evidently, the creation of the table was logged in model and not in tempdb,
where the table was being created. Go figure. They were supposed to fix
this 'feature', does anyone know if they did?


Topher
-- 
 Christopher A. White                    | "Perfection is not optional."
 caw@gtech.com                           | 
 GTech Corporation, West Greenwich, RI   | from: Rules for sociopathic
 The opinions expressed are mine alone   |       obsessive-compulsives
Newsgroups: comp.databases.sybase
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: Recovering from a log segment full condition
Organization: Lehman Brothers
Date: Mon, 21 Dec 1992 18:57:01 GMT

> In article <dave.724703604@rincon> dave@ema.rockwell.com (Dave Emde) writes:

>   I've had the same problem myself.  Using dump tran database with no_log
>   works will but there have been several instances where I dumped my transaction
>   log only to find that I still received the "out of space in syslogs" message.

>   In this case you need to shutdown and restart the server and then issue
>   another dump with no_log.  This fixed my problem. If you have the Sybase
>   Troubleshooting Guide they have a good writeup about this type of problem. 

Be careful about shutting down a dataserver with a full transaction log. SYBASE
will want to write a checkpoint to the log after recovering the database. If 
the log is full this can cause problems ( unless "no chkpt on recov" is set ).
So try to empty the log first, and watch-out for segmap of 7 ( log & data ), 
because data might be eating up all of your log space.

--
warren finnerty      | 388 Greenwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com
 
Newsgroups: comp.databases.sybase
From: jkrauspe@whoi.edu (John Krauspe)
Subject: Re: MSW Excel to Sybase  over TCP/IP ?
Organization: Woods Hole Oceanographic Institution, Woods Hole, MA
Date: Wed, 23 Dec 92 04:24:17 GMT

	Just a couple comments. First, Q&E works OK from MS Windows
to Sybase if you are using Sybase's w3dblib.dll. Make sure you have
a current Sybase (not microsoft) dblib.
	On a Mac, I've been using DataPrism from Brio Technology for
doing queries. They support Open Client for Macs and MacTCP (and lots
others for both but I'm partial) and also export data compatible with
excel (ie, as an excel application, or with an excel fork, or whatever
it is), lotus and others (it's cute, you know, like the Mac ;-). Type
the export datafile name and it brings it up in excel.
	A version for MS Windows was to be released on 12/11 though I
do not yet have it. Presumably it will allow you to port queries from
Macs to Windows.

John  K.
From: robert@sybase.com (Robert Garvey)
Newsgroups: comp.databases.sybase
Subject: Re: NULL to NOT NULL
Keywords: nulls, rules, triggers
Date: 22 Dec 92 17:29:34 GMT
Distribution: usa
Organization: Emeryville Tupleware, Party Planning Division

In article <ESH.92Dec15103611@prague.tss.com>, esh@prague.tss.com (Edward S. Hirgelt) writes:
|>
|> 1. Create a rule for the particular column that forbids nulls.

    Null values are not checked against a rule of the column allows
    nulls, so this won't work as expected.

|> 2. Modify the insert and update triggers (or create them) to check for
|>    nulls in this column. If it finds any it can roll back the
|>    transaction.

    This will work.

Warren Finnerty's recommendation to put the data into another table with
a different schema, one that has that column disallowing nulls, may be a
better way to go, provided you don't have any rows with null in them.
It would also be prudent to heed Warren's caution about dependencies.

-- 
Robert Garvey robert@sybase.com {sun,lll-tis,pyramid,pacbell}!sybase!robert
	      Sybase, Inc   6475 Christie Ave   Emeryville, CA   94608-1010

Opinions here may be attributed to the poster and are not related to Sybase.
From: chris@cs.uchicago.edu (Chris Johnston)
Newsgroups: comp.databases.sybase
Subject: Re: recovery time at start up
Date: 30 Dec 92 19:31:44 GMT
Organization: AM Investors, Chicago


    My server will reboot quickly if I checkpoint all my databases
before I shutdown.  A checkpoint only takes one second and avoids
several minutes of recovery time.

    I try to checkpoint my databases often, others on this list have
warned against doing it too often.  I don't know why.

cj
312-786-4889
Newsgroups: comp.databases.sybase
From: sauvain@fandango.wrc.xerox.com (Richard Sauvain)
Subject: Archive of comp.databases.sybase?
Reply-To: sauvain@wrc.xerox.com
Organization: Xerox Corp.
Date: Mon, 28 Dec 1992 20:16:20 GMT

Is anyone archiving the traffic on this DL?  There's a lot of good stuff here; it would be a great public service for someone to save it and make it available by anonymous ftp.

Richard

---
Name:  Richard Sauvain               | Xerox Webster Research Center
Email: Sauvain@wrc.xerox.com         | Mail Stop 128-27E
Phone: (716) 422-3379                | 800 Phillips Road
Fax:   (716) 422-2126                | Webster, NY 14580  USA
Newsgroups: comp.databases.sybase
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: Recovering from a log segment full condition
Organization: Lehman Brothers
	<1992Dec21.223620.26626@gtech.com>
Date: Tue, 22 Dec 1992 00:46:11 GMT

>In article <1992Dec21.223620.26626@gtech.com> caw@gtech.com (Christopher A. White) writes:

    [ stuff deleted on shutting down server ]

>   Do NOT do this if master or model is full. The server cannot restart if the
                               ^^^^^^^
>   log segment of one of these two is full. We've never had a problem dumping
>   them with 'no_log' however.

Strange that model being full would be a problem.
( I'll take your word for it. :) )
Do any of you SYBASE types want to confess to what futz'ing around in model 
goes on in conjunction with createing objects in tempdb. ( Not at startup )
--
warren finnerty      | 388 Greenwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com
From: gpmenos@firestone.Princeton.EDU (Gerard Philippe Menos)
Newsgroups: comp.databases.sybase
Subject: Troubleshooting Guide?  Was-Re: Recovering from a log segment full condition
Date: 21 Dec 92 15:40:07 GMT
Reply-To: gpmenos@firestone.Princeton.EDU (Gerard Philippe Menos)
Organization: Princeton University
Originator: news@nimaster

In article <dave.724703604@rincon> dave@ema.rockwell.com (Dave Emde)  
writes:
> If you have the Sybase
> Troubleshooting Guide they have a good writeup...

Can you tell me where I can obtain this Guide, please?  I can use any  
help I can get...

Phil

-------------------------------------------
G. Philippe Menos    
Systems Administrator
Princeton University Libraries
gpmenos@firestone.princeton.edu
voice:  609-258-5183
  fax:  609-258-5571
-------------------------------------------
-- 
-------------------------------------------
G. Philippe Menos    
Systems Administrator
Princeton University Libraries
Xref: sparky comp.databases.sybase:555 comp.databases.oracle:2616
Newsgroups: comp.databases.sybase,comp.databases.oracle
Subject: Re: Dynamic DBMS server Monitor
From: M.W.Stern@massey.ac.nz (M.W. Stern)
Date: Wed, 23 Dec 92 01:50:22 GMT
Organization: Massey University, Palmerston North, New Zealand
X-Reader: NETNEWS/PC Version 2c


>If you know of something that fits the following description,
>whether commercial or public domain, please drop me an e-mail
>note or post it.  I will summarize (FAQ-it) and post.

>Description:
>A updatable display monitor of Sybase or Oracle state and
>runtime statistics.

>Display Platform: PC/DOS Windows, X-Windows

>Statistics can include: raw i/o, number of connections, 
>lock dependencies, log entries, etc.

>Thanks,

I think there were several products of this nature advertised in the 
latest Oracle magazine. I dont have this readily available so I can't
comfirm this.

Regards

==================================================
Mark Stern              | Internet:
Analyst/Programmer      |  M.W.Stern@massey.ac.nz
Massey University       |  
NEW ZEALAND             |  
==================================================
Organization: Arizona State University
Date: Monday, 21 Dec 1992 10:15:48 MST
From: <IDAZS@ASUACAD.BITNET>
Newsgroups: comp.databases.sybase
Subject:    Using Views for data presentation


Dear Netters,

        We here at ASU are trying to create Views for mailing labels.

First and last names are stored in separate fields in upper

case. We have been partially successful in combining them to display

in upper-lower case, using "substring" and "rtrim" functions. Names

that have spaces or dashes, like "James Mc donald" or

"Carol Terry-peplow" have been a problem. It seems that we cannot use

conditionals ('if', 'else') within a view.

       If anyone has solved this problem or has a recommendation

please let us know. We are running SQL Server 4.8, and accessing the

data with views through client tools such as DataPrism.

       Thanks.

       Ajay Surana
       John Rome
       Data Administration
       Arizona State University
       Tempe, AZ
       (602) 965-0857


Newsgroups: comp.databases.sybase