HDTenEightyP/NetNews huggingface dataset:
From: Bruce_H_Ring@cup.portal.com
Newsgroups: comp.databases
Subject: Re: LOGGING turned off?
Date: Sun,  8 Nov 92 10:02:16 PST
Organization: The Portal System (TM)

Zhe Li <li@cs.columbia.edu> asks:
 
>> Does anyone know which relational database system allows user
>> to turn off logging? Oracle? Ingres? (I know SYBASE doesn't
>> support this).
 
SQLBase from Gupta Corporation lets you turn off logging.
 
>> Besides, which system has the enhanced SQL that supports
>> transitive closure operator?
 
Oracle SQL has a clause that supports transitive closure (I think it's
called CONNECT BY).
 
Bruce Ring
Gupta Corporation
bruce_h_ring@cup.portal.com
Newsgroups: comp.databases
From: derwin@mach2.wlu.ca (Daryl Erwin)
Subject: Foxpro2 & 10 Meg memory & DrDos - How best to configure?
Organization: Wilfrid Laurier University
Distribution: na
Date: Thu, 12 Nov 1992 03:19:59 GMT

I was wondering what people thought would be the best way to configure my
machine. 

Size of Expanded? Size of Extended? Sizoe of VDISK? Etc.

What are your configuration?
-- 
Daryl Erwin                                     Net Address: derwin@mach2.WLU.CA
Information Systems (woo-eee a new name!)       Surface Mail: P4-1, Main Campus 
Wilfrid Laurier University, Waterloo, Ontario 
Bus:(519) 884-1970 x2910                                          ... Go Hawks!
From: NIBMSCM@NDSUVM1.BITNET
Newsgroups: comp.databases.sybase
Subject: Design/Development Opportunity
Date: 9 Nov 92 20:06:18 GMT
Organization: North Dakota Higher Education Computer Network


Sybase Design/Development Engineer

Just a short posting for those of you that might be interested.  Great
Plains software is seeking an experienced Sybase Design/Development
Engineer to work with our staff on client/server extensions to our
existing GUI applications development tool.

If you would like further information on this opportunity, please e-mail
a response to my network id.

Thanks
 ___________
|           |   Regards,
|            c      Steve Malme
|   Fargo ->*|      Great Plains Software
|____________|      (nibmscm@ndsuvm1.bitnet)
From: rcsmith@anagld.analytics.com (Ray Smith)
Newsgroups: comp.databases.sybase
Subject: Hiding a password while dumping
Date: 7 Nov 92 00:10:40 GMT
Organization: Computer Sciences Corporation - Systems Engineering Division

Someone recently sent me the following message and I couldn't answer them so
I thought I would appeal to the collective wisdom of the net.  If you have
any suggestions please pass them on and I will make sure the originator gets
them.

Advance thanks,
Ray

=================
FORWARDED MESSAGE
=================
I'm trying to write a shell script executed through cron to perform a Sybase
dump.  The problem is as follows:

The Sybase dump command is a Transact/Sql command.  Therefore, it must be
invoked using the isql command.
The isql command normally prompts the user for their Sybase userid and
passwd.  However, this can be overridden by entering the -U and -P flags
when invoking isql.

The problem: The -P flag take the user's unencrypted passwd as argument.
This means that while the backup is running, any user can see/learn the
passwd because it is displayed clearly in the output of the ps command.

The question: Does anyone have any ideas how I can prevent the passwd from
being displayed?  I'd like to run the backup as a batch process using cron
(the data can fit on one tape), but don't want to compromise the passwd.
-- 
Ray Smith                                  Computer Sciences Corporation
One of these should work: rcsmith@sed.csc.com   - or -
uunet!anagld!rcsmith    - or -   rcsmith@aplcen.apl.jhu.edu
rcsmith@analytics.com   - or -   RCSmith@DOCKMASTER.NCSC.MIL 
Newsgroups: comp.databases.sybase
From: lhall@csfb1.fir.fbc.com (Lawrence Hall)
Subject: RE: locking flame 
Reply-To: uunet!csfb1!lhall
Organization: First Boston Corporation
Date: Mon, 9 Nov 1992 16:34:03 GMT

In article <1992Oct29.015905.29380@panix.com>, dbenua@panix.com (David Benua) writes:
|> 
|> I'm having an interesting problem(?) with locking on Sybase 
|> What I'd like to do is (somewhat simplified for reasons of space):
|> Begin Tran
|>    Select 1 record (and acquire locks) 
|>    Display Dialog
|>    Allow user to change record contents
|>    Update record
|> Commit Tran
|> 
|> I'd rather find something like the Oracle select for update clause. 
|> Anybody have any brillant ideas? (Please, no kludges with timestamps
|> and/or shadow variables, I know about those already) Anybody know how
|> we knock some sense into Sybase? 


I could not believe the problem David was having with holdlock taking an 
exclusive table lock, so we did some experiments to verify this scenario - the
following are some of the results :

create table x ( a char(10), b char(10), c char(10))

Populate with 5000 rows - the unique key being a + b, but no index yet.

   select * from x holdlock where a = '1' and b = '2'
   This takes an exclusive table lock even though we only need one page out
	of 75.  

create unique clustered index z on x(a,b)

	select * from x holdlock where a = '1' and b = '2'
	With the unique index, this locks 2 page

	select * from x holdlock where a = '1'
	If "a='1'" covers 25 pages, then we lock 26 pages

	If the table were ten times as large then we would end up with a table
	  lock again since "a='a'" would require more than 200 page locks.

	Since I have said that "a='1'" is roughly 1/3 of the table, Sybase may
		decide to use a table scan rather than the index.  In this case, we would 
		get a table lock as in the case with no index.


I hope this is of some use to others on the net. 


----------------------------------------------------------------------------
Lawrence E. Hall
First Boston Corp.
5 World Trade Center 9th Floor                    uunet!csfb1!phantom!lhall
NYC, NY  10048                                    lhall@csfb1.fir.fbc.com
----------------------------------------------------------------------------
The Secretary will disavow all knowledge. 
Newsgroups: comp.databases.sybase
From: tpoind@teton ( Tom Poindexter)
Subject: Re: Hiding a password while dumping
Summary: a little shell magic
Organization: U S WEST Advanced Technologies
Date: Mon, 9 Nov 1992 14:48:59 GMT

In article <1688@anagld.analytics.com> rcsmith@anagld.analytics.com (Ray Smith) writes:
[...]
>The isql command normally prompts the user for their Sybase userid and
>passwd.  However, this can be overridden by entering the -U and -P flags
>when invoking isql.
>
>The problem: The -P flag take the user's unencrypted passwd as argument.
[...]

Try this:

echo "dump database xx to device" | cat /sybase.pw - | isql -Usa

where /sybase.pw is the sa password, and the file mode is -rw-------,
(600 for you octal types), owned by root.

The '-' in the cat command line causes stdin to be read.

Of course, you can stick the sybase password file anywhere, not 
necessarily in /.


Tom Poindexter		tpoind@uswest.com

Newsgroups: comp.databases.sybase
From: lbertoli@magnus.acs.ohio-state.edu (Lawrence E Bertolini)
Subject: Re: Hiding a password while dumping
Organization: The Ohio State University
Date: Mon, 9 Nov 1992 13:29:19 GMT

To supply a password to isql, without coding it on the command line, try:

isql -Usa -Sservername << !
`cat .x`
`cat $1`
!

where ".x" contains your password, and $1 is the name of the file
containing your dump database command.

The "<< !" is called a "here document", and redirects to stdin everything
until the "!" is found in column 1.  The two cat commands are enclosed in
grave's, so that the output of the cat commands (i.e. the contents of the
files .x and $1) are part of the "here document".
-- 
+-----------------------+-------------------------------------------------+
| Larry Bertolini       | "Patriotism is your conviction that this country|
| Ohio State University | is superior to all other countries because      |
| University Systems    | you were born in it." - George Bernard Shaw     |
Newsgroups: comp.databases.sybase
Subject: Re: Sybase/ Microsoft Server Differance
From: yair@huha.cs.huji.ac.il (Yair Friedman)
Date: 3 Nov 1992 19:34:40 GMT
Reply-To: yair@cs.huji.ac.il
Distribution: na
Organization: The Hebrew U. of Jerusalem, Computer Science Dep.
NNTP-Posting-Host: huha.cs.huji.ac.il

In article <Bx3AqE.3xx@ga.com>, gps@ga.com (Pat Sand) writes:
|> lcc5@cs.columbia.edu ( Eric Chang) writes:
|>
|> >(3) MS SQL Server runs on OS/2 1.3 with LAN MAN, and it's upgrading to NT, not OS/2 2/0. Sybase runs on everywhere else :-) As far as fron-end app is concerned, there're very few differences, if you d
|>
|> Just wanted to add my $0.02...
|> Talking with Microsoft SQL Server tech support (Yes, I did find them after 4
|> hours of ... <flame off>), they indicated that MS SQL Server 4.2 now runs on
|> OS/2 2.0 (is certified and supported!).  This information is about 1-2 weeks
|> old...
|>

I had succeed to install MS SQL Server 4.2 os OS/2 2.0 under Novell network.
Now I try to write utility that would manage both Sybase dblib and MS SQL dblib.

--
					Yair Friedman.
yair@cs.huji.ac.il
From: jbaron@higgs.ssc.gov (Jeff Baron)
Newsgroups: comp.databases.sybase
Subject: RE: locking flame
Date: 9 Nov 92 18:58:29 GMT
Article-I.D.: sunova.1992Nov9.185829.19395
Reply-To: jbaron@higgs.ssc.gov (Jeff Baron)
Organization: Superconducting Super Collider Lab

Lawrence Hall writes:

- create table x ( a char(10), b char(10), c char(10))
- 
- Populate with 5000 rows - the unique key being a + b, but no index yet.
- 
-    select * from x holdlock where a = '1' and b = '2'
-    This takes an exclusive table lock even though we only need one page out
- 	of 75.  

This locks all of the table in order to prevent another process 
from inserting data into the table that might somehow change the 
results of this query while the transaction that this query is embedded
in is still active.

- create unique clustered index z on x(a,b)
- 
- 	select * from x holdlock where a = '1' and b = '2'
- 	With the unique index, this locks 2 page

You should be able to see that now, Sybase can prevent someone from
inserting an 'a=1, b=2' record by locking only the pages in the table
where that record would be located, since it is *known* where
that record would be.  (I wonder, in fact, if the 2nd, or even both,  
pages are higher-in-the-index-tree index pages of some sort, presumably the
ones that sit "above" the record(s) in question.  The net result would
be identical.)

--
Jeff Baron
jbaron@gauss.ssc.gov
Newsgroups: comp.databases.sybase
From: bob@bobsled.glv.com  (Bob Lunney)
Subject: How can I capture SQL going to Sybase?
Organization: Encompass
Distribution: usa
Date: Tue, 10 Nov 1992 19:04:30 GMT

Like the subject line says:  How can I capture SQL going to Sybase?  I am sure  
there is a dbcc traceon() argument for this.  For instance, dbcc traceon(3604)  
sends dbcc output to the screen.  dbcc capture_tds spid used to work for 4.0.1.   
What is it under 4.8?

Bob Lunney	bob@bobsled.glv.com	NeXT mail preferred!
Encompass	919-460-3274
Newsgroups: comp.databases.sybase
From: Ronny G. Nordvik <nordvik@edb.uib.no>
Subject: Omnis7 with SQL and Sybase/Oracle
Organization: Edb-senteret, UiB, Norway
X-Useragent: Nuntius v1.1
Date: Fri, 13 Nov 92 12:28:53 GMT

OMNIS 7 WITH SQL DATABASE - SYBASE OR ORACLE


I want information about Record Locking on rows and tables for
updating.... in a multiuser Omnis apllication, because we don't want
problems with many persons updating the same record(row). In Omnis i want
to lock the record(row) begfore I go into enter data mode, and release
the record lock when leaving enter data mode.

Please send me information and keep on with further discussion about
Omnis and SQL.

Greetings from

Ronny G. Nordvik

The Computing Centre
HighTechnlogy Centre in Bergen
N-5020 BERGEN
NORWAY

Tlf. 47 5 544100
Fax. 47 5 544299

E-mail: edorn@alf.uib.no   or.  nordvik@edb.uib.no
Newsgroups: comp.databases.sybase
From: chris@tartarus.uchicago.edu (Chris Johnston)
Subject: Re: Hiding a password while dumping
Organization: AM Investors, Chicago
Date: Tue, 10 Nov 1992 17:08:12 GMT

>The problem: The -P flag take the user's unencrypted passwd as argument.
>This means that while the backup is running, any user can see/learn the
>passwd because it is displayed clearly in the output of the ps command.

On my machine (sun sparc) the isql program overwrites the password
with spaces.  So ps does not dislpay the password.  Did you try this?
What machine are you using?  We use the isql that came with 4.0.1.

cj
312-786-4889
From: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases.sybase
Subject: Re: Sybase contact fee unfair?
Date: 13 Nov 1992 21:30:13 GMT
Organization: Baylor College of Medicine, Houston, Tx
Distribution: world
Reply-To: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
NNTP-Posting-Host: fleming.csc.bcm.tmc.edu
Originator: mparsons@fleming.csc.bcm.tmc.edu


*** stuff about bad response times, etc. deleted ***

We're in Houston, TX.  And in the past few months while I've
been more into 'talking' with Sybase I haven't had any problems
with them calling back and/or giving me a status on ongoing
cases.

I understand that they just hired several more people to
beef up their tech support . .. maybe it's getting better?

As for the costs associated with tech support . . . I
don't know exactly what we're paying here . . 

Mark
Newsgroups: comp.databases.sybase
From: bas@mh.nl (Carel Bast)
Subject: UNATTENDED Backup on tape (DUMP)
X-Md4-Signature: d84f2e56074c36a397b7961430b0286f
Organization: Multihouse Automation, the Netherlands
Distribution: comp
Date: Tue, 10 Nov 1992 09:01:44 GMT


Dear netters,

We are running SYBASE (Release 4.2) on an ULTRIX/Risc (4.3) machine.

- Is it possible to make an UNATTENDED backup on a tape dump-device ?

- Is it possible to make a dump of several databases on ONE tape,
  without using the console program ?

- Is it possible to dump databases on the SAME tape on which we also
  do our regular (file-system) backups ?

- Do you have a sample program/procedure to do this ?

Please Help,

Carel Bast

--
Carel Bast				      bas@mh.nl via internet backbones
Multihouse Automatisering bv		      uucp:..!{uunet,sun4nl}!mh.nl!bas
Doesburgweg 7, 2803 PL Gouda, The Netherlands phone/fax:  +31 1820 62911/62500
~~~~~~~~~~~~~~~~~~~~~~~ Keep on kissing the frog ... ~~~~~~~~~~~~~~~~~~~~~~~~~
From: usenet@transfer.stratus.com (Mr. Network News)
Newsgroups: comp.databases.sybase
Subject: Re: database full? /NOT? - Help
Date: 6 Nov 92 17:12:40 GMT
Reply-To: Dave_Wetzel@vos.stratus.com
Organization: Dave_Wetzel

It could be the log space that is full?  How much have you allocated?  Do 
you do dump trans regularly?

--------------
Dave_Wetzel@vos.stratus.com
From: jordan@warped.pnl.gov (Randy Jordan)
Newsgroups: comp.databases.sybase
Subject: Re: Sybase contact fee unfair?
Date: 13 Nov 92 17:32:46 GMT
Article-I.D.: oracle.1992Nov13.173246.12638
Reply-To: jordan@warped.pnl.gov (Randy Jordan)
Organization: Battelle, Pacific Northwest Laboratory


In article <hanson.721673682@pogo>, hanson@pogo.fnal.gov (Steve Hanson) writes:
|>Path: pnl-oracle!ogicse!uwm.edu!linac!mp.cs.niu.edu!fnnews.fnal.gov!pogo!hanson
|>Reply-To: hanson@pogo.fnal.gov
|>Organization: FERMILAB, Batavia, IL
|>Lines: 27
|>NNTP-Posting-Host: pogo.fnal.gov
|>
|>In <Bxn1DK.L7n@shakti.ncst.ernet.in> shobhana@shakti.ncst.ernet.in (Shobhana) writes:
|>
|>>In article <1992Nov10.211840.1577@gamelan> thf@zelator.in-berlin.de (Thomas Funke) writes:
|>
|>>Yes, Sybase does not sound like a company which does it's homework
|>>well. It is a real pity considering that the SQL server is such a good
|>>piece of work.
|>
|>>Not only are they ridiculously overpriced, but they don't seem to be
|>>bothered about returning calls. I was trying to buy a copy of Sybase from
|>>their local representative in Bombay---who suddenly seemed to lose all
|>
|>>Really ridiculous if you ask me.
|>
|>Well, if it makes you feel any better I work at a major computing
|>installation just outside of Chicago, and we can't get Sybase
|>to sell us anything either.  In our case we'd be perfectly happy
|>to spend the high support fees, but we have never been able to get
|>Sybase to give us the support OR to bill us for it.  They seem
|>to have a lot of trouble with either returning calls, getting us
|>quotes, or selling us anything.
|>
|>This is the major reason we are using Oracle for most stuff.  Oracle
|>will at least sell us things.
|>-- 
|>Steve Hanson - FERMILAB, Batavia, Il.
|>hanson@pogo.fnal.gov or hanson@fnal.fnal.gov
|>
--
	I'm convinced... everyone outside the Pacific time zone gets
	bad responses from SyBase. Fotunately I am here. I get regular
	calls from SyBase in Seattle (WA). They have even come here to 
	present new stuff (We are in central Washington). And I get quick
	response from the support center in Emeryville.
RJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	To Thyne Own Self be true...
	                             myne opinions are.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Newsgroups: comp.databases.sybase
From: jia@cis.umassd.edu (Ruoming Jia)
Subject: DBLIB vs Embeded SQL
Organization: University of Massachusetts Dartmouth
Distribution: usa
Date: Tue, 10 Nov 1992 02:52:20 GMT

	The title says everything.
	We are going to make some decision to use DBLIB or EMBEDED
SQL on our project.

	DBLIB seems to be very powerful.
	And EMBEDED SQL seems to be quite portable.

	Thanx
JIA
Newsgroups: comp.databases.sybase
From: jziner@csfb1.fir.fbc.com (Jeffrey A. Ziner)
Subject: RE: insert of null into non_null field 
Reply-To: uunet!csfb1!jziner
Organization: First Boston Corporation
Date: Wed, 11 Nov 1992 17:08:48 GMT

 

In article <1992Nov10.181730@genethon.fr>, you write:
|> 
|> It turns out that it is possible, under Sybase 4.2 on a Sun, to insert
|> NULL values into fields that are declared NOT NULL.  Has anybody else
|> seen this problem?  Does this problem exist under 4.8, which we will
|> install soon?  (I was expecting the substring to return an empty string
|> forgetting that empty strings do not exist.)
|> 
|> Stuart
|> 
|> create table t(f varchar(20) not null)
|> insert into t select substring("X", 2, 255)
|> (1 row affected)
|> insert into t values("F")
|> (1 row affected)
|> select f from t
|>  f                    
|>  -------------------- 
|>  NULL                 
|>  F                    
|> 
|> (2 rows affected)
|> select f from t where f = f
|>  f                    |>  -------------------- 
|>  F                    
|> 
|> (1 row affected)
|> select distinct f from t
|> Msg 530, Level 16, State 1:
|> Line 1:
|> Attempt to insert NULL value into column 1 in work table (table id
|> -81); column does not allow NULLS.  UPDATE fails.
|>  f                    
|>  -------------------- 
|> 
|> (1 row affected)
|> select @@version
|>                                                                    
|>  ----------------------------------------------------------------- 
|>  SQL Server/4.2/P/sun4/os4/EBF632/OPT/Tue Aug 27 11:58:42 PDT 1991 
|> 

Yes this does occur within the 4.8.1.1 (GA 3) release of Sybase. I suggest you report this as a problem and you might see it fixed in release 4.9.1 or 5.0. Good Luck. Jeff Ziner
Newsgroups: comp.databases.sybase
From: wolfgang@fraser.sfu.ca (Wolfgang Richter)
Subject: Sybase contact fee unfair?
Keywords: contact, maintenance, fee, support
Organization: Simon Fraser University, Burnaby, B.C., Canada
Date: Fri, 6 Nov 1992 21:12:49 GMT

I am surprised that no one has ever complained about Sybase
annual support costs. Last year Sybase introduced a new charge
called a "contact fee". It is a hefty annual charge of over $10,000.
(They try to temper it by offering a 50% discount the first year as
well as 5 free educational days). I have been told by people at Sybase
that this is to help Sybase pay for providing technical support (so
2 people at your company can phone Sybase to report bugs).

Two people in the Syabse support maintenance department tell me that
there is no choice in the matter. You don't have the option to say pay
a fee per call. You are to either pay the update + contact fee or you
get cut off from support. Whether you are a small site with say a 4
user copy of Sybase running on one machine or a Fortune 500 company
with hundreds of users, you pay the same.

Having never heard of this kind of customer-unfriendly approach
(who'd buy a 2 user copy of Sybase to try out if 2 years from now they
have to pay over $10,000 to get support for it), I contacted Oracle
(I thought Sybase might have got the idea from someone else). Nope,
Oracle does not charge this way. They charge a percentage based on
number of users, thus making their product more affordable for the
small user.

Conclusion: Sybase has mainly large customers and are leaving the
scraps (that is, 1000's of little customers) to their competition
such as Oracle, Ingres, Informix, etc.
-- 
-- Wolfgang Richter (e-mail: wolfgang@sfu.ca)
-- Academic Computing Services
-- Simon Fraser University
-- Burnaby, B.C.
-- Canada V5A 1S6
-- Phone: 604-291-4449
Newsgroups: comp.databases.sybase
From: shobhana@shakti.ncst.ernet.in (Shobhana)
Subject: Re: Sybase contact fee unfair?
Organization: CMIE, Bombay
Date: Fri, 13 Nov 1992 04:48:55 GMT

In article <1992Nov10.211840.1577@gamelan> thf@zelator.in-berlin.de (Thomas Funke) writes:
>I recently did a large project on a RS6000/AIX for a company which involved a  
>good database. I really recommended SYBASE to them, but after they have talked  
>to SYBASE sales-people, they wanted about 20000 US$ for a SQL-Server and  
>DB-Library. PLUS those expensive support fees.
>
>Finally, really to my regret, they decided to use INGRES which costed about  
>half the price and included telephone support. Sigh !

Yes, Sybase does not sound like a company which does it's homework
well. It is a real pity considering that the SQL server is such a good
piece of work.

Not only are they ridiculously overpriced, but they don't seem to be
bothered about returning calls. I was trying to buy a copy of Sybase from
their local representative in Bombay---who suddenly seemed to lose all
interest in selling. Soon after, I called Sybase, CA at least 3 times
and sent FAX messages asking them to let me know where to buy Sybase from.
Not *one* of these calls were returned. Instead I was sent on a wild-goose
chase all around the world (telephonically) and finally landed up in
Bombay again. I am sure some messages went back and forth between CA
and Bombay, but we, the potential customers, were left clueless.

Really ridiculous if you ask me.

If someone from Sybase is reading this, I would be really interested
in knowing what you guys are up to. I am beginning to get *very* bad
vibes. You just don't seem to care about small customers.

Rajappa Iyer.

p.s. I am using a friend's account---please reply at this address.
Newsgroups: comp.databases.sybase