HDTenEightyP/NetNews huggingface dataset:
From: dptom@endor.corp.sgi.com (Tom Arnold)
Subject: Re: Calling C programs from triggers
Reply-To: dptom@endor.corp.sgi.com (Tom Arnold)
Organization: sgi
Date: Wed, 11 Nov 1992 17:22:49 GMT

In article <92315.131244U31742@uicvm.uic.edu>, <U31742@uicvm.uic.edu> writes:
|> Hi,
|> We have sybase version 4 installed on sparc stations. Could someone tell us
|> how to call a C program, when a trigger is fired.
|>
You cannot make a system level call from a trigger or stored procedure, for that matter, without going through the open server. 

Your question exposes a system behavior that would be _very_ nice to have. It has been discussed at several meetings of the Sybase User group enhancement committee so that users could make asynchronous calls to outside applications (like E-mail, electronic pagers, and the like). I believe that Sybase's posture is that these types of "event" based routines should be entirely handled by their open server product.  Although the open server provides some very robust features and capablities, this seems like ov







er kill to me when all I want to do is send E-mail to a data administrator because some user tried to post an improper update. 
  

-- 
****************************************************************************
*       Tom Arnold                    | "Lead...                           *
*       dptom@sgi.com                 |   follow...                        *
*       Silicon Graphics, Inc.        |     or, get out of the way!"       *
*       (we do it in three            |                                    *
*        dimensions)                  |             Ted Turner             *
****************************************************************************
Newsgroups: comp.databases.sybase
Date: Fri, 13 Nov 92 14:52:55 EST
From: Zhe Li <li@cs.columbia.edu>
Subject: logging turned off?


Hi there:

I wonder whether the newest version of Syabse supports turning off
logging.(such as "set nologging")

thanks!

--lee

pls email to :
li@cs.columbia.edu
Newsgroups: comp.databases.sybase
From: ogborn@kaos.corp.sgi.com (Geoffrey S. Ogborn)
Subject: Re: How can I capture SQL going to Sybase?
Reply-To: ogborn@corp.sgi.com	
Organization: Silicon Graphic Inc.
Distribution: usa
Date: Wed, 11 Nov 1992 02:03:47 GMT

In article <1992Nov10.190430.9668@glv.uucp>, bob@bobsled.glv.com (Bob Lunney) writes:
|> 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

I know using APT as the front-end you can 

setenv RECFTOS filename 

and all the sql hitting the server will get written to the file with execution time.
I do not know if this will work for other front-end.
Newsgroups: comp.databases.sybase
From: eedksc@teamos50.ericom (Klaus Schniedergers)
Subject: How to connect APT-Form to different database?
Organization: /home/teamos/1/eedksc/.organization
Date: Wed, 11 Nov 1992 11:35:57 GMT

Hi!
I have the following problem with the behated APT-Forms:
 I want my form to be able to connect to different databases, i.e. defining
a database name in an environment variable then starting the form
without any recompiling or interactive input.
 
When creating the form, the database name is encoded in several places:
- the form-preprocessing-procedure (as ' sqlbegin use <db-name> sqlend ')
- the sql column connected to fields (<db-name>.dbo.table)
 
A dirty solution would be running the <name>.frm file through an sed-script,
changing the database-name to the new one. But I would like a more
elegant solution.........
 
There is a 'Migrate Application' entry in the 'DB Objects' menu in APT-Edit.
You can specify a new database there, but doing 'Migrate' has no effect (or
at least I couldnt notice one). I could not find anything in TFM about
this menu entry. Help!
Klaus
 
--
----------------------------------------------------------------------
Klaus Schniedergers, Ericsson Eurolab, Dept. B, Herzogenrath, Germany,
eedksc@aachen.ericsson.se  Ph:+49 2407 575 147  Fax:...575 150
From: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases.sybase
Subject: Re: need help on user groups
Date: 10 Nov 1992 23:00:02 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


In article <1992Nov10.183141.20481@cognet.ucla.edu>, yeo@inherit2.dna.ucla.edu (Simon Yeo) writes:
|> The SQL server gives the current user name if you type "select user_name()".
|> Is there a way I can get the group name of the current user?
|> 

I don't have my DBA guide handy right now . . but look up info on
the sysusers table.  It has your user entries as well as group
entries . . you should be able to hit against this table to get
the name of the associated group.

Let me know if you still can't find it . . . by then I should 
have found my book . . . . . 

Mark "Is it Friday, yet!??!" Parsons
Organization: University of Illinois at Chicago
Date: Tuesday, 10 Nov 1992 13:12:44 CST
From: <U31742@uicvm.uic.edu>
Newsgroups: comp.databases.sybase
Subject: Calling C programs from triggers

Hi,
We have sybase version 4 installed on sparc stations. Could someone tell us
how to call a C program, when a trigger is fired.

thank you,

Harish Butani.
From: ohayon@jcpltyo.JCPL.CO.JP (Tsiel Ohayon)
Newsgroups: comp.databases.sybase
Subject: Re: Hiding a password while dumping
Date: 9 Nov 92 23:33:17 GMT
Organization: James Capel Pacific Limited, Tokyo Japan


After recieving a few E-mails, I'm posting the following C program
which dumps a Sybase database. It is not optimal but works
great.

------------->8------------------  CUT HERE ----------------------------8<--

#include <stdio.h>
#include <time.h>

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

/* This is the main flaw, since you need to write your login or password in
   the C program. But you have the advantage of just needing to leave a
   compiled version on your server
*/

#define	DATABASE	"database_name"
#define	LOGIN_NAME	"sa"
#define	PASSWORD	"sa_password"
#define	APP_NAME	"dump"

void
main(argc,argv)
        unsigned int    argc;
	char            **argv;
{
	long	t;
	struct tm 	*period;
	DBPROCESS       *dbproc;
	LOGINREC        *login;

	time(&t);
	period = (struct tm *)localtime(&t);

	/* INITIALIZE SYBASE	*/
	if (dbinit() == NULL) {
		printf("Error opening the DB\n");
		exit(ERREXIT);
	}

	if ((login = dblogin()) == NULL) {
	 	(void)printf("dblogin() error, exiting \n");
	 	exit(1);
	}
	DBSETLUSER(login,LOGIN_NAME);
	DBSETLPWD(login, PASSWORD);
	DBSETLAPP(login, APP_NAME);

	if ((dbproc = dbopen(login,NULL)) == NULL) {
		(void)printf("dbopen() error, exiting \n");
		exit(1);
	}

	/* show time at which dump started		*/
	(void)printf("DUMPING DATABASE at %.2d:%.2d ...\n",period->tm_hour,
		period->tm_min);

	dbfcmd(dbproc,"dump database %s to tapedump",DATABASE);
	dbsqlexec(dbproc);
	while (dbresults(dbproc) != NO_MORE_RESULTS);

	if ((period->tm_wday == 1) || (period->tm_wday == 4)){
		(void)printf("DUMPING TRANSACTION ...\n");
		dbfcmd(dbproc,"dump transaction %s to tapedump\n",DATABASE);
		dbcmd(dbproc,"with truncate_only");
		dbsqlexec(dbproc);
		while (dbresults(dbproc) != NO_MORE_RESULTS);
	}

	/* show time at which dump finished		*/
	time(&t);
	period = (struct tm *)localtime(&t);
	(void)printf("FINISHED DUMPING DATABASE at %.2d:%.2d ...\n",
		period->tm_hour,period->tm_min);
	dbexit();
	exit(0);
}
------------->8------------------  CUT HERE ----------------------------8<--

Cheers,
-- 
----8<--------------------------------------------------------------->8------
Tsiel:ohayon@jcpl.co.jp	   | If you do not recieve this E-mail, please let me
Employer may not have same | know as soon as possible, if possible.
opinions, if any !         | Two percent of zero is almost nothing.
Newsgroups: comp.databases.sybase
From: stuart@genethon.fr (Stuart Pook)
Subject: insert of null into non-null field
Originator: stuart@genethon.genethon.fr
Organization: Genethon, Paris, France
Date: Tue, 10 Nov 1992 17:17:30 GMT


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
From: dptom@endor.corp.sgi.com (Tom Arnold)
Newsgroups: comp.databases.sybase
Subject: Re: Sybase contact fee unfair?
Date: 12 Nov 92 22:46:47 GMT
Reply-To: dptom@endor.corp.sgi.com (Tom Arnold)
Organization: sgi

Could someone explain Sybase's pricing strategy in this case. To illustrate this, let's consider a case: 

License Fee (one time) CLASS A SQL-Server     $3,750  
Yr 1 Support & Maint, Fee 7.5% of lic fee        282      
                         ---------------------------------
Total                                         $4,032

Note: Annual support and Maint. fee may escalate 10%/year

Not completely un-reasonable at this point. But let's say this is a new primary license...   Add $7,000 / year for two contacts!  And here's the way it looks over 5 years:


Year 		Lic Fee		Annual Support	   Contacts 	Annual total

1		3,750		    282		     7,000        11,032
2				    310              7,000         7,310
3				    341		     7,000         7,341
4				    375              7,000         7,375
5				    413              7,000         7,413

This is a fairly simple analysis, but it doesn't take much to see that this strategy makes Sybase less financially attractive. The problem is not so much the license fee or the annual support, but the *annual* contact fees. 

One solution: Would Sybase consider selling a secondary license where no primary exists, or where primary licenses on other platforms or classes already exist? This might make the product much more financially attractive. 
-- 
****************************************************************************
*       Tom Arnold                    | "Lead...                           *
*       dptom@sgi.com                 |   follow...                        *
*       Silicon Graphics, Inc.        |     or, get out of the way!"       *
*       (we do it in three            |                                    *
*        dimensions)                  |             Ted Turner             *
****************************************************************************
From: hanson@pogo.fnal.gov (Steve Hanson)
Newsgroups: comp.databases.sybase
Subject: Re: Sybase contact fee unfair?
Date: 13 Nov 92 16:54:42 GMT
Organization: FERMILAB, Batavia, IL
Reply-To: hanson@pogo.fnal.gov
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
From: dave@ema.rockwell.com (Dr. Dave)
Newsgroups: comp.databases.sybase
Subject: Netlib for any Public Domain TCP/IP Drivers?
Date: 12 Nov 92 22:13:02 GMT
Organization: Rockwell International

Is there a net-lib for any of the Public Domain TCP/IP Drivers?
(.e.g Clarkston)

Thanks
-- 
-------------------------------------------------------------------------
Dave Emde
Rockwell Intl. (Space Systems Div.)
Downey, Ca.
dave.emde@rockwell.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Bush, Clinton, Perot .... I'll just vote for my Sun.
-------------------------------------------------------------------------
Newsgroups: comp.databases.sybase
From: chris@tartarus.uchicago.edu (Chris Johnston)
Subject: Re: Hiding a password while dumping
Organization: AM Investors, Chicago
Date: Thu, 12 Nov 1992 17:16:29 GMT

    I use a sun sparc.  On my system 'ps -eww' will display all the
environment variables including the one with the dump passwd.  However
 'isql -Ppassword' will show up in ps as
 'isql -P        '.  This is because isql replaces the password with 
blanks.  This only lets the bad guys see the length of your password.

    Something like 'isql -Usa -P`cat /.secret/sydumppw`' would
probably be most secure.

    I wouldn't trust the following since it creates a file in /tmp
isql -Usa << ReDiReCt
`cat /.secret/sdumppw`
use DB
 etc...
ReDiReCt

cj
312-786-4889
From: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases.sybase
Subject: Re: Sybase training courses
Date: 9 Nov 1992 18:55:44 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


In article <1992Nov6.153457.13168@jax.org>, csb@jax.org (Carolyn Blake) writes:
|> I'm interested in any information on or comments about Sybase
|> training courses. I only know of one. Are there others? Are
|> they any good? We need both Sys Ad & programming training.
|> The 'trainees' have DB experience in Ingres & Informix...

They offer training in Report and APT workbench, Sys Admin,
Tuning, Open Client, etc.  I've been through the APT and
Sys Admin classes and I can't really complain.  In both cases
they have a manual that you follow along in, with lots of
examples.

Depending on your 'expertise' with Sybase products, or databases
in general, your people may find some of the classes slow . . 
or maybe tough . . . just gotta look at the pre-requisites.

As for the classes they offer, I suggest you call their education
dept at 1-510-596-4501(Emeryville, CA) and ask for their current
catalog, and dates, of classes.

Mark
From: head@dorsai.com (Howard Pinsley)
Newsgroups: comp.databases.sybase
Subject: Re: Calling C programs from triggers
Date: 11 Nov 92 18:29:47 GMT
Organization: The Dorsai Embassy +1.718.729.5018
X-Newsreader: Tin 1.1 PL4

U31742@uicvm.uic.edu () writes:
: Hi,
: We have sybase version 4 installed on sparc stations. Could someone tell us
: how to call a C program, when a trigger is fired.
: 
: thank you,
: 
I believe this can be accomplished with Open Server.
-- 

Howard Pinsley                                             Voice: (212) 836-8322
head@dorsai.com                                              Fax: (212) 836-8689
Newsgroups: comp.databases.sybase
From: yeo@inherit2.dna.ucla.edu (Simon Yeo)
Subject: need help on user groups
Organization: UCLA Cognitive Science Research Program
Date: Tue, 10 Nov 1992 18:31:41 GMT

The SQL server gives the current user name if you type "select user_name()".
Is there a way I can get the group name of the current user?


-- 
----
	/____ |		Simon Yeo	University of California, LA
	|o o ||		--------------------------------------------	
	| <  |/		yeo@inherit2.dna.ucla.edu	yeo@seas.ucla.edu
	| ^  |		
	 \__/		"To be a true poet is to become God."
Newsgroups: comp.databases.sybase
From: wolfgang@fraser.sfu.ca (Wolfgang Richter)
Subject: Re: Sybase contact fee unfair?
Keywords: contact, maintenance, fee, support
Organization: Simon Fraser University, Burnaby, B.C., Canada
Date: Mon, 9 Nov 1992 17:40:01 GMT

allenm@sfu.ca (Allen Mar) writes:
>I work for a large company, and frankly,
>we're not getting good vibes that lead to more business with them...
>They're not doing their homework...

>allenm@wizard.sfu.ca

Funny you should mention it. Like other Sybase customers, we sometimes
get calls from people thinking of buying the product. I just had a call
the other day and told the person at the other end that though Sybase
was a good product (with compiled procs, triggers, etc), make sure to
watch out for the contact fee. As he was from a small company, I wonder
if he is going to become a customer? I kind of doubt it.
-- 
-- 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: khayden@seb.compass.fnma.com (Ken Hayden)
Subject: dblib vs. dbkit
Reply-To: khayden@fnma.com (Ken Hayden)
Organization: Fannie Mae
Date: Mon, 9 Nov 1992 15:59:09 GMT

I need information about sybase dblib calls versus NEXT dbkit calls.

I really need to know why it is better to use dbkit calls with NEXT, and 
not dblib call  to access data in the sybase database.  This data is  
needed for a white paper titled "dbkit vs. dblib".


Thanks in advanced for any help!!!!

ken
Newsgroups: comp.databases.sybase
From: allenm@sfu.ca (Allen Mar)
Subject: Re: Sybase contact fee unfair?
Keywords: contact, maintenance, fee, support
Organization: Simon Fraser University, Burnaby, B.C., Canada
Date: Sat, 7 Nov 1992 06:19:51 GMT

wolfgang@fraser.sfu.ca (Wolfgang Richter) writes:

>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

We just purchased Sybase for a project, and the "contact fee" was sure a
shocker for me too.  Needless to say, we also were taken aback at that.
I budgetted for the figures in their Canadian price list, and then my
boss tells me that I was a wee bit low in the estimate!  For the platform
we're putting it on, that forced the total cost for the RDB to way over
the hardware by a long shot.  I work for a large company, and frankly,
we're not getting good vibes that lead to more business with them...
They're not doing their homework...

allenm@wizard.sfu.ca
From: davidvc@cosmo.sybase.com (David Van Couvering)
Newsgroups: comp.databases.sybase
Subject: Re: Open Server message Q problem
Date: 6 Nov 92 19:28:24 GMT
Distribution: na

In article <BwswD0.1MF@da_vinci.it.uswc.uswest.com>, twood@windward.it.uswc.uswest.com (Tim Woodward) writes:
|> 
|>  
|>    Anyone out there with experience using message queues in the Open
|>    Server version 2? 
[deleted]
|> 
|>    ex: if (srv_putmsgq(log_service, log_request, SRV_M_NOWAIT) != SUCCEED)
|> 
|>    This causes the error messge that the message logging process has corrupted 
|>    or overflowed its stack and the program exits. 
|> 
|>    ex: Fatal Oserver error: 16151:20:0: Server process '4' has overflowed or
|>    corrupted its stack -- aborting.
|> 

I would make sure that your message queue has been properly allocated
and you are passing in the pointers correctly -- the stack problem
usually is a result of memory being overwritten.

|> 
|>    Tim Woodward

David

-- 
davidvc@sybase.com | {pacbell,lll-tis,pyramid,sun}!sybase!davidvc
David Van Couvering Sybase 1650 65th Street Emeryville, CA  94608
- Opinions expressed here are mine and not necessarily those of Sybase -
From: ohayon@jcpltyo.JCPL.CO.JP (Tsiel Ohayon)
Newsgroups: comp.databases.sybase
Subject: Re: Hiding a password while dumping
Date: 9 Nov 92 03:43:48 GMT
Organization: James Capel Pacific Limited, Tokyo Japan

In article <1688@anagld.analytics.com> rcsmith@anagld.analytics.com (Ray Smith) writes:

[RS] FORWARDED MESSAGE

[RS] I'm trying to write a shell script executed through cron to perform a 
[RS] Sybase dump.  The problem is as follows:
[RS] The Sybase dump command is a Transact/Sql command.  Therefore, it must be
[RS] invoked using the isql command.
[RS] The isql command normally prompts the user for their Sybase userid and
[RS] passwd.  However, this can be overridden by entering the -U and -P flags
[RS] when invoking isql.
[RS] The problem: The -P flag take the user's unencrypted passwd as argument.
[RS] This means that while the backup is running, any user can see/learn the
[RS] passwd because it is displayed clearly in the output of the ps command.
[RS] The question: Does anyone have any ideas how I can prevent the passwd from
[RS] being displayed?  I'd like to run the backup as a batch process using cron
[RS] (the data can fit on one tape), but don't want to compromise the passwd.

I used a C program to do that. If you are interested, I can show how to do
it.

Cheers.
-- 
----8<--------------------------------------------------------------->8------
Tsiel:ohayon@jcpl.co.jp	   | If you do not recieve this E-mail, please let me
Employer may not have same | know as soon as possible, if possible.
opinions, if any !         | Two percent of zero is almost nothing.
Newsgroups: comp.databases.sybase
From: csb@jax.org (Carolyn Blake)
Subject: Sybase training courses
Organization: The Jackson Laboratory, Bar Harbor, ME 04609
Date: Fri, 6 Nov 92 15:34:57 GMT

I'm interested in any information on or comments about Sybase
training courses. I only know of one. Are there others? Are
they any good? We need both Sys Ad & programming training.
The 'trainees' have DB experience in Ingres & Informix...

Thanks for your help!

Carolyn Blake			csb@jax.org
The Jackson Laboratory
600 Main Street
Bar Harbor, ME  04609