HDTenEightyP/NetNews huggingface dataset:
From: wolfgang@fraser.sfu.ca (Wolfgang Richter)
Subject: Re: Multiple Connections for temporary tables
Organization: Simon Fraser University, Burnaby, B.C., Canada
Distribution: comp
Date: Fri, 9 Oct 1992 18:28:18 GMT

reb@punch.EBay.Sun.COM (Bob Brown) writes:



>I'm using DBLIB and have come across a challenge. Maybe you SYBASE gurus can
>solve it.


>In my program I am reading each row in the table with dbnextrow(). The
>table is a temporary table. WHILE STILL in the while loop of dbnextrow(),
>I want to make another connection to the temporary table so I can get
>some data from another row to help with the processing on the current
>row. On a regular table, no problem. With the temporary table, the
>second connection doesn't recognize the existience of the newly
>created temporary table.

>The table needs to be a temporary table. I cannot do a self-join.

>I tried getting the object id and finding the table name in the tempdb
>database, but selecting on THAT resulting name gives an invalid selection.

>Any ideas?!

>                                
>--
>--Bob
>Systar Technologies, Inc.		   Sun: robert.brown@EBay.Sun.COM
>1712 Picasso Avenue, #B & #C            Office: reb@systar.com
>Davis, California  95616		 Phone: (916) 753 - 2611
Would it be possible to have a stored procedure that performs the
above-described operation and returns result rows. dbnextrow can
pick up data from a stored procedure as easily as from a table.
-- 
-- 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: jja@fnbc.com (Joseph Alotta)
Subject: Re: Selecting Sybase - Would you do it again?
Organization: First National Bank Of Chicago, Chicago IL, USA
Date: Thu, 8 Oct 92 19:10:27 GMT

*If you were going to choose a
*UNIX database today, would you buy Sybase again? 
*Why or why not?

i'd buy interbase from borland.  it seems ever bit as good, perhaps a bit  
more modern, and it's cheaper.

i'd also look at some of the object-oriented databases real hard.  got  
some material from versant and i was impressed.

joe.
--
==============================================================
! joe alotta                                    jja@fnbc.com !                                               
!                                             (312) 732-3439 !
!                                                            !
! "The main thing is to keep the main thing the main thing." !
! Dr. George Sweeney                                         !
==============================================================
From: lmcgee@bondo.corp.sgi.com (Lee McGee)
Newsgroups: comp.databases.sybase
Subject: Re: Trigger to do cascading updates?
Date: 15 Oct 92 14:54:51 GMT
Reply-To: lmcgee@sgi.com
Organization: Silicon Graphics
NNTP-Posting-Host: bondo.corp.sgi.com

In article <Bw3z63.Mqo@shakti.ncst.ernet.in>, shobhana@shakti.ncst.ernet.in (Shobhana) writes:
|> How can I write a trigger for A to update k1 and k2 in B whenever
|> it is changed in A? This was my attempt:
|> 
|> create trigger upd_trig
|> on A for update as
|> begin
|> 	if update(k1) or update(k2)
|> 	begin
|> 		update B
|> 			set k1 = inserted.k1,
|> 			    k2 = inserted.k2
|> 		from inserted, deleted
|> 		where
|> 			B.k1 = deleted.k1 and
|> 			B.k2 = deleted.k2
|> 	end
|> end
|> 
|> However, this does not work when a *SET* of rows in A are updated in a
|> single statement. Any suggestions?

Shobhana, it looks like the problem is that you forget to join the
inserted and deleted "tables" when looking for the update situation.  So,
what you are "updating from" is a cartesian product of the two; perhaps you're
getting the "deleted" updates after the "inserted" updates and this is 
undoing the update.

Try:

 create trigger upd_trig
 on A for update as
 begin
 	if update(k1) or update(k2)
 	begin
 		update B
 			set k1 = inserted.k1,
 			    k2 = inserted.k2
 		from inserted, deleted
 		where
		   /* correlate the update	*/ 
			B.k1 = deleted.k1 and
 			B.k2 = deleted.k2 and
		  /* make sure that inserted and deleted are joined */
			inserted.k1 = deleted.k1 and
			inserted.k2 = deleted.k2
 	end
 end

And that should work.

Caveat - I didn't have a lot of time to look at this so there could
be errors!

Good luck and safe computing.


Lee 

-- 
________________________________________________________________

Lee McGee
Silicon Graphics, Inc		"Simplicity, then add lightness"
lmcgee@sgi.com			   
PHONE (415) 390-2403	        
FAX   (415) 961-9584	         
PAGE  (415) 807-2246
Organization: Arizona State University
Date: Thursday, 8 Oct 1992 13:07:19 MST
From: <IDAZS@ASUACAD.BITNET>
Newsgroups: comp.databases.sybase
Subject:    Sybase OpenClient v/s DAL

hi,

     I am evaluating Sybase OpenClient (Net-lib & Db-Lib) and Apple's DAL

for a client-server environment, with a macintosh client and a unix

server running Sybase 4.8. I would appreciate to hear about any

benchmarks, experiences or thoughts about the two.

     Thanks in advance.

     Ajay Surana
     Data Administration
     Arizona State University
Newsgroups: comp.databases.sybase
From: jzhang@prodigy.bc.ca (Jie Zhang)
Subject: Sybase login accounting?
Reply-To: jzhang@prodigy.bc.ca
Organization: Prodigy Technologies Corp.
Date: Thu, 15 Oct 1992 00:15:10 GMT


Hi Sybase netters,

Can anyone help me with a simple problem: how can you get the Sybase connection
accounting easily? That is, if I want to have a daily report on which users login
to which databases, that kind of information, what can I do?

Basically, all I want to have is to log every login session by the server. At least
for one (if not all) of the databases, I want to know who at what time used it.
I don't want each application which access the DB to do this themselves (e.g., write
a log record in a certain table which can be summarized later), which
seems impractical too. So how can one monitor the sessions, having something
like a 'trigger' to log the session info every time an access is made?

It seems there's no available utility for sys. admin. to do this, at least in
4.8 version which we have here. So I'm wondering if anyone had the similar problem
before or any suggested solution?

E-mail to me or post to the group (it might be interesting to the public).

Jie

---------------------------------------------------------
Jie Zhang
System Analyst
Prodigy Technologies Corp.
Vancouver, B.C.

E-mail: jzhang@prodigy.bc.ca
Phone: (604) 687-4636
Fax: (604) 687-6471
Newsgroups: comp.databases.sybase
From: bml@athena.mit.edu (Larry J Lennhoff)
Subject: Database renames and sp_depends
Summary:   How do you tell what procedures depend on data base name? 
Organization: Massachvsetts Institvte of Technology
Distribution: world
   I have what I hope are some simple sybase questionS.  I'm using sybase 4.2
Date: Wed, 14 Oct 1992 18:25:41 GMT

I have the following questions about this approach:
   1) Will it work?
   2) Is there a better method?
   3)  The System Admin manual warns that views, triggers, and stored
procedures that depend on the database name will cease to work when
recompiled.  It recommends using sp_depends to find out what the dependent
objects are.  Unfortunately sp_depends will not accept a data base as
a parameter.  I have scanned the text of the views, procedures, and
triggers to find anyplace the database name is referenced.  Is this
sufficent?  If not what more needs to be done?  Is there another way 
to do this?

Larry J Lennhoff


Newsgroups: comp.databases.sybase
From: tom@dtint.uucp (Thomas R. Kimpton)
Subject: asynchronous dblib calls
Organization: Digital Technology, International
Distribution: na
Date: Tue, 13 Oct 92 00:38:15 GMT


Is there anyone out there using DBLib from Macintosh's?

In order to speed up an application I have, to deal with
real-time input, I need to be able to do asynchronous
calls to the database.  I've looked through the manuals
but have only found VMS calls.  Does anyone know of a
way to get the Mac calls to run asynchronously?

Thanks, Tom.

-- 
---
Tom Kimpton                            tom@dtint.dtint.com
Digital Technology Int.                (801)226-2984	
500 W. 1200 South, Orem UT, 84057      FAX (801) 226-8438
Newsgroups: comp.databases.sybase
From: yoram@frcs.Alt.ZA (Yoram Tal)
Subject: open server and sockets 
Organization: M*N*E*T Pay TV
Date: Mon, 12 Oct 92 11:28:09 GMT
Summary: sockets and open server
Keywords: open server


Hi !!!!

I am new to the sybase world and have been given the task of
interfaces open server code and some TCP/IP sockets stuff. 
I have written a 'client' and 'server' socket program which accepts
commands of the format:
cmd,key,data:filename.

for instance :
S,1,junkdaata:file.

There are 2 sun servers involved here 1 runs my 'server' and the other
the client... so that I pass the above string to my server which
responds with a retrival of some data from 'file'. What I need to do
is incorporate the 'open server' code with the client portion of the
socket stuff I wrote. Thus, using an rpc of the form:

myserver...cmd "Select",1,file,30 would create a string of the above
format and would send the stuff to my server which returns the desired
information to the rpc in a table format which an open client would
then process. Is this at all possibble and if so any ideas... I have
taken the utility code that comes with sybase and would like to modify
the the rpc sections of code ... but when I call the socket read and
write the server hangs ??? what gives ? thank you in advance for help
on this subject. 

please excuse the typos !!!!

cheers,


yoram 
 
yoram tal 
standard disclaimer applies            
yoram@frcs.alt.za   phone: (home) +27 11 783-2433  (Johannesburg,South Africa) 
-------------------------------------------------------------------------------
Newsgroups: comp.databases.sybase
From: akrumsee@magnus.acs.ohio-state.edu (Art Krumsee)
Subject: Re: MS SQL Server and Visual Basic
Organization: The Ohio State University
Date: Sat, 10 Oct 1992 01:23:22 GMT



In article <1b2e9fINN691@male.EBay.Sun.COM> college@vivaldi.EBay.Sun.COM writes
:
>I have a friend who is using the Microsoft SQL Server (Sybase server for OS/2)
 with
>Microsoft's Visual Basic as a front-end development tool.  Since I have never
>worked with Visual Basic, I'd like to know if anyone has had experience with
>this setup.
>
We are using Visual Basic now to develop front-ends to Sybase and MS SQL Server
apps.  I find Visual Basic a very effective and productive environment for 
developing with SQL Server.  You might check in back issues of Data Based 
Advisor (perhaps a year ago) there was an article from Microsoft that included 
a series of VB functions to handle the typical functions of a VB/SQL Server app
such as logon, execute query, fill list box, etc.

Performance is more than adequate with this combination.  The only limitation 
would come with very large applications (dozens of forms) where the current 
version of VB starts to slow down.  As with any development environment there 
are limitations but the payback in productivity is tremendous.
-- 
===============================================================================
Art Krumsee
Art.Krumsee@osu.edu
Ohio State University
From: lmcgee@bondo.corp.sgi.com (Lee McGee)
Newsgroups: comp.databases.sybase
Subject: trace flags
Date: 13 Oct 92 23:19:40 GMT
Reply-To: lmcgee@sgi.com
Organization: Silicon Graphics
NNTP-Posting-Host: bondo.corp.sgi.com

Can anyone send me a copy of the file "trace.h", which contains
a list of all the available trace flags for DBCC and dataserver?
This file was referenced in the DBCC Commands manual.

Thanks in advance if anyone has this.


Lee

-- 
________________________________________________________________

Lee McGee
Silicon Graphics, Inc		"Simplicity, then add lightness"
lmcgee@sgi.com			   
PHONE (415) 390-2403	        
FAX   (415) 961-9584	         
PAGE  (415) 807-2246
From: usenet@transfer.stratus.com (Mr. Network News)
Newsgroups: comp.databases.sybase
Subject: Re: Sybase login accounting?
Date: 16 Oct 92 15:30:07 GMT
Reply-To: Dave_Wetzel@vos.stratus.com
Organization: Dave_Wetzel

This isn't exactly what you asked for but...

Modify the macro that starts the server (it's called something like 
RUN_SQL.cm on the Stratus) change the line that actually runs the 
dataserver; it should look something like this:

dataserver.pm  -d<master.dat> -s<server name> -i<interface file>  -e<error 
log>


Add at the end -T4013.  This turns on the trace flag 4013 which will add a 
line to the error log everytime someone logs in.  The line might look like 
this:

00: 92/10/16 10:24:09.27 server: login: sa #m3, spid: 24, kpid: 289865798 
(0x11470046)

This will let you know who got in and what spid they were assigned.  
Unfortunately, there's no "logout" trace flag, so it's not really complete.

Hope that helps a little anyway...

--------------
Dave_Wetzel@vos.stratus.com
From: gspencer@bucknell.edu (Gene Spencer)
Newsgroups: comp.databases.sybase
Subject: Sybase and APT
Date: 15 Oct 1992 13:02:00 GMT
Organization: Bucknell University
NNTP-Posting-Host: sphene01.bucknell.edu

We are seriously looking at Sybase and APT as the platform for all of our
administrative systems.  We were surprised when the three references supplied 
by the vendor either did not use APT or was very unhappy with it.  What is
the general concensus of the APT toolset?  

Is APT a reasonal basis for development of a complete suite of administrative
applications or is it too structured and limiting?

(we must develop applications for a wide variety of desktop devices, including
dumb terminals, DOS devices, Macintoshs and Unix workstations).

Please resond to me directly <gspencer@bucknell.edu> and I'll summarize to 
the net.
 
Thanks!
From: jjames@baseball.Eng.Sun.COM (John James - Sun Corporate Software Engineering)
Newsgroups: comp.databases.sybase
Subject: Does Update Table Reach View?
Date: 16 Oct 92 02:28:19 GMT
Reply-To: jjames@baseball.Eng.Sun.COM
Organization: Sun Microsystems
NNTP-Posting-Host: baseball

On the 4.8 server:

I created a view that does a select against two tables and makes them appear
as one. I only granted select permission for this view. Later I made updates
to the tables, but the view did not get updated. This is not at all what I
expected, as the view is strictly for convenience in reporting!

While I'm new to SQL in general, this is not at all what I expected from a view's
functionality. Assuming this is not how things should work, did I fail to set an
attribute on the view? Is there something about my setup on the actual tables or
database that could be wrong?

	john
From: veit@Unify.com (Veit Irtenkauf)
Newsgroups: comp.databases.sybase
Subject: ndisks = 10
Date: 13 Oct 92 17:15:29 GMT
Organization: Unify Corporation (Sacramento)

Sybase set the number of disks (ndisks) in 4.0.1 back to 10 from 50 in
Release 4.0.  What's the reason for it?  Scripts/installmaster says that
it took too much memory for disk service process stacks.  Too much memory
internally in Sybase?  In the master database?  Too much main memory while
running Sybase?  Therefore less performance?

And why shouldn't you create a separate disk for every development
project or every deployed application?  If you run out of disk space for
one disk, this affects only one development project, but not all.  All
you do then is dropping the database and the disk and recreate it again.
No big deal at all.  What are the Sybase internal drawbacks, if you use
this approach?

Any help is very much appreciated

-- Veit


-----------------------------------------------------------------------
Veit Irtenkauf    Technical Marketing Manager  |  email: veit@unify.Com
Unify Corporation                              |  voice: (916) 928-6322
3901 Lennane Drive, Sacramento, CA 95834-1922  |    fax: (916) 928-6406
From: henri@sundsvall.trab.se (Henri L~bke)
Newsgroups: comp.databases.sybase
Subject: Monitoring several processors
Date: 15 Oct 92 13:00:05 GMT
Distribution: comp
Organization: Telia Research Sundsvall AB

Hello world!

1. Has anybody out there written software to monitor a Sybase environment
   with more than one processor.

   I find 'sp_monitor' to simple because it only divides eg cpu_busy
   by the number of engines running. I'd like to be able to analyze
   how each of the engines are running, instead of some average numbers.

2. I have been scanning through the manuals to find out what is really
   meant by the term 'idle' that is presented in the sp_monitor
   command. Since I haven't found anything useful I' be glad
   if someone could comment on that.

Any comments/pointers are appreciated!

Best regards
henri lubke

-- 
Henri Lubke                           E-mail: Henri.Lubke@sundsvall.trab.se
Telia Research AB
Box 883                               Tel:    +46 60 161028
S-851 24 Sundsvall, Sweden            Fax:    +46 60 122944
Newsgroups: comp.databases.sybase
From: jzhang@prodigy.bc.ca (Jie Zhang)
Subject: Re: Sybase login accounting?
Reply-To: jzhang@prodigy.bc.ca
Organization: Prodigy Technologies Corp.
Date: Sat, 17 Oct 1992 01:40:02 GMT

In article 92Oct8022955@punch.EBay.Sun.COM, usenet@transfer.stratus.com (Mr. Network News) writes:
>
>
>I'm using DBLIB and have come across a challenge. Maybe you SYBASE gurus can
>solve it.
>
>
>In my program I am reading each row in the table with dbnextrow(). The
>table is a temporary table. WHILE STILL in the while loop of dbnextrow(),
>I want to make another connection to the temporary table so I can get
>some data from another row to help with the processing on the current
>row. On a regular table, no problem. With the temporary table, the
>second connection doesn't recognize the existience of the newly
>created temporary table.
>
>The table needs to be a temporary table. I cannot do a self-join.
>
>I tried getting the object id and finding the table name in the tempdb
>database, but selecting on THAT resulting name gives an invalid selection.
>
>Any ideas?!
>
>                                
>--
>--Bob
>Systar Technologies, Inc.		   Sun: robert.brown@EBay.Sun.COM
>1712 Picasso Avenue, #B & #C            Office: reb@systar.com
>Davis, California  95616		 Phone: (916) 753 - 2611


Thanks, Bob. It worked. It does partially solve my problem.

So this is another undocumented feature of Sybase? Our 4.8 document doesn't mention
this.

Jie
-----------------------------------------------
Jie Zhang
System Analyst
Prodigy Technologies Corp.
Vancouver, B.C.

E-mail: jzhang@prodigy.bc.ca
Phone: (604) 687-4616
Fax: (604) 687-6471

Newsgroups: comp.databases.sybase
From: jim@highyld.pilot.dmg.ml.com (Jim Anderson)
Subject: runtime space monitoring
Keywords: sybase space monitor watchdog
Organization: Merrill Lynch Debt Markets Group
Date: Tue, 13 Oct 1992 19:09:31 GMT


Does anyone have code to monitor free space availability
at runtime for a Sun Unix environment. I need to create a watchdog
process to monitor a production system.

I would also welcome suggestions as the best way to track
space usage.
Newsgroups: comp.databases.sybase,com.databases,comp.databases.oracle,comp.databases.informix
From: eric@desktalk.com (Eric Lieber)
Subject: Hot links & Joins across DB's 
Keywords: Oracle,Sybase,Informix,Spreadsheets,Graphers
Reply-To: eric@desktalk.com
Organization: Desktalk Systems Inc.
Date: Fri, 9 Oct 1992 17:00:57 GMT

I have software that can
 * Query and do joins across Oracle, Informix, and Sybase.
 * Display the results in a spreadsheet, including hot links
 * Display the results in a graph

Does anyone want to Beta test this software?  If so, please send me e-mail.

Thanx,
===========================================================================
Eric Lieber			!  Viva San Fermin, Gora San Fermin
DeskTalk Systems Inc.		!
Torrance, CA., 90502		!
Telephone:	(310) 323-5998	!
e-mail:	eric@desktalk.com	!
===========================================================================
			Standard Disclaimer
			___________________





Newsgroups: comp.databases.sybase
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: Multiple Connections for temporary tables
Organization: Lehman Brothers
Distribution: comp
Date: Thu, 8 Oct 1992 23:51:26 GMT

In article <REB.92Oct8022955@punch.EBay.Sun.COM> reb@punch.EBay.Sun.COM (Bob Brown) writes:

>   I'm using DBLIB and have come across a challenge. Maybe you SYBASE gurus can
>   solve it.


>   In my program I am reading each row in the table with dbnextrow(). The
>   table is a temporary table. WHILE STILL in the while loop of dbnextrow(),
>   I want to make another connection to the temporary table so I can get
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Enter paradox mode: temporary tables are tables that are unique 
*per connection*. So to make another connection to a table that
is unique per connection is non-trivial.  


>   some data from another row to help with the processing on the current
>   row. On a regular table, no problem. With the temporary table, the
>   second connection doesn't recognize the existience of the newly
>   created temporary table.

>   The table needs to be a temporary table. I cannot do a self-join.
    
>   I tried getting the object id and finding the table name in the tempdb
>   database, but selecting on THAT resulting name gives an invalid selection.

>   Any ideas?!

#1 It is quite simple to create table tempdb..name_NODE_PID such as:
   CREATE TABLE tempdb..widgets_wrkstn0001_12395
   (
   blah
   )

   process data

   drop table tempdb..widget_wrkstn0001_12395 

   The downside is that this syntax will not work with stored procs
   and if not explicity dropped the tables will hang around until 
   processed.
 
#2 Read the temp table down to the client side ( push it onto a queue )
   and *then* use original connection while popping the rows back out.
   ( FIFO )

Good luck
--
warren finnerty      | 388 Greenwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com
From: college@vivaldi.EBay.Sun.COM (Darrell Choy)
Newsgroups: comp.databases.sybase
Subject: MS SQL Server and Visual Basic
Date: 8 Oct 1992 22:55:43 GMT
Organization: Sun Microsystems, Inc.
Distribution: world
Reply-To: college@vivaldi.EBay.Sun.COM
NNTP-Posting-Host: vivaldi.ebay.sun.com

I have a friend who is using the Microsoft SQL Server (Sybase server for OS/2) with
Microsoft's Visual Basic as a front-end development tool.  Since I have never 
worked with Visual Basic, I'd like to know if anyone has had experience with 
this setup.

Thanks,

Darrell Choy




Newsgroups: comp.databases.sybase
From: jja@fnbc.com (Joseph Alotta)
Subject: senior database admin (chicago)
Keywords: sybase, database, admin
Organization: First National Bank Of Chicago, Chicago IL, USA
Distribution: usa
Date: Thu, 8 Oct 92 19:03:33 GMT


senior database administrator responsible for organizing, maintaining and  
enhancing the database services across a number of SQL servers.

we are seeking someone who really loves databases and loves hoarding lots  
of data.

support development groups, consult to in-house programmers,  
fault-tolerance planning, disaster recovery, synchronization of databases  
geographically dispersed.  

we use next and sum workstations, sun servers, some pc's.  

knowledge of financial markets, sybase, data communications, unix  
networking, vendor negotiations, perl programming.

enlightened management, laid-back friendly group, casual dress ok,  
internet access, many other perks.

work in downtown chicago, live nearby or commute from the suburbs via  
quick and reliable commuter rail system.  

respond by email only.  send resume or just write a few paragraphs about  
yourself.

again, please do not call.  
--
==============================================================
! joe alotta                                    jja@fnbc.com !                                               
!                                                            !
!                                                            !
! "reply by email only, no calls accepted, sorry."           !
==============================================================