HDTenEightyP/NetNews huggingface dataset:
From: aberkson@mbsdev41.shearson.com (Alan Berkson)
Subject: Time Zone on 4.2 on HP
Organization: Shearson Lehman Brothers
Date: Wed, 6 Jan 1993 18:37:46 GMT

Runing getdate() on Sybase version 4.2 running on and HP gives you a different
time then the system time on the HP. 

Ex. Sybase says 9:00am, HP says 12:00pm

The same is true after restarting the server.The server seems to think it's on 
PST or something.

Any ideas?
--
Organization: Arizona State University
Date: Tuesday, 12 Jan 1993 17:05:29 MST
From: <IDAZS@ASUACAD.BITNET>
Newsgroups: comp.databases.sybase
Subject:    Microsoft Access 1.0 client w/ Sybase SQL Server

Dear Netters,

We have been looking at Microsoft Access 1.0 as a client tool in
a client-server environment with Sybase SQL Server.

So far we have only been able to get a list of the databases from
the Server. The list of tables never come back. The application
freezes and never returns. We have installed the Server piece that
is required for Sybase SQL Server and available at COMPUSERV. We
are running SQL Server 4.9. We have also tried recycling the Server.

If anyone has a similar experience or any suggestions we would
appreciate hearing from you.

The tech support of Microsoft are too busy and rather unhelpful.

Thanks.

Ajay Surana
Data Administration
Arizona State University
Tempe, AZ 85281

(602) 965-5959
Newsgroups: comp.databases.sybase
From: hst@mh.nl (Klaas Hemstra)
Subject: Re: how poratble is embedded SQL across ORACLE, SYBASE, INGRES?
X-Md4-Signature: 53bc6fa063ab63020995471020cb5191
Organization: Multihouse Automation, the Netherlands
Date: Tue, 12 Jan 1993 10:25:01 GMT

There are some problems in embedded SQL.
First the way variables are described is different in some versions.
Sometimes ":var" is used sometimes "@variable" or "?" is used.
Sybase does NOT support embedded SQL !! (as far as i know).

As a matter of fact i already made the choice of building my own API
in C for C programs. This was also chosen because our database table
names should be variable (we use Uniface, where each table name can be
prefix-ed for easy shared development). I also have build it for
Ingres and Sybase.  The Ingres version is based on embedded SQL
(partly dynamic embedded SQL) and the sybase version on the sybase
API. The oracle version will be built in future too, probably based on
the ingress version.

It works ok.

Klaas
--
Klaas Hemstra  (hst@mh.nl)                      |   /  / ,~~~ ~~/~~
uucp: ..{uunet!}sun4nl!mh.nl!hst                |  /--/  `-,   / ___ |_/ |__|
Multihouse Automatisering B.V. Gouda,Netherlands| /  / ___/   /  --- | \ |  |
---- Incompatible: relation between two computer(software-)products. -----
From: robert@sybase.com (Robert Garvey)
Newsgroups: comp.databases.sybase
Subject: Re: Help on SQL query
Date: 7 Jan 93 21:36:12 GMT
Organization: Emeryville Tupleware, Party Planning Division

In article <27661@sybase.sybase.com>, I wrote:
|> [...method of expanding out an alias stored as alias/member pairs...]

An alternative is to handle all aliases in one loop, going through the
loop n-1 times where n is the maximum number of members in the aliases.

	SELECT	an, pn
	FROM aliases
	ORDER BY an, pn

	 an                             pn                             
	 ------------------------------ ------------------------------ 
	 dwarves                        bashful                        
	 dwarves                        doc                            
	 dwarves                        dopey                          
	 dwarves                        grumpy                         
	 dwarves                        happy                          
	 dwarves                        sleepy                         
	 dwarves                        sneezy                         
	 twain                          clemens                        
	 weapons                        fear                           
	 weapons                        surprise                       


	SELECT	a.an,
		pn_cnt = COUNT(*),
		cur_cnt = CONVERT(int, 1),
		last_added = MIN(a.pn),
		list = CONVERT(varchar(255), MIN(a.pn))
	INTO #exp_aliases
	FROM aliases a
	GROUP BY a.an

	DECLARE	@cur_count	int,
		@max_count	int

	SELECT	@cur_count = 2,
		@max_count = MAX(pn_cnt)
	FROM #exp_aliases

	SELECT	an,
		pn
	INTO #next_pns
	FROM aliases
	WHERE 1 = 0

	WHILE ( @cur_count <= @max_count )
	BEGIN

	    INSERT INTO #next_pns ( an, pn )
		SELECT	a.an,
			MIN(a.pn)
		FROM aliases a, #exp_aliases e
		WHERE a.pn > e.last_added
		  AND a.an = e.an
		  AND e.pn_cnt >= @cur_count
		GROUP BY a.an
		HAVING MIN(a.pn) IS NOT NULL
	    
	    INSERT INTO #exp_aliases ( an, pn_cnt, cur_cnt, last_added, list )
		SELECT	e.an,
			e.pn_cnt,
			@cur_count,
			n.pn,
			e.list + ", " + n.pn
		FROM #exp_aliases e, #next_pns n
		WHERE e.an = n.an

	    DELETE #next_pns

	    DELETE #exp_aliases
	    WHERE cur_cnt < pn_cnt
	      AND cur_cnt < @cur_count

	    SELECT @cur_count = @cur_count + 1

	END

	SELECT	an = SUBSTRING(an, 1, 8),
		list = SUBSTRING(list, 1, 50)
	FROM #exp_aliases ORDER BY an

	 an       list                                               
	 -------- -------------------------------------------------- 
	 dwarves  bashful, doc, dopey, grumpy, happy, sleepy, sneezy 
	 twain    clemens                                            
	 weapons  fear, surprise                                     

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

I'm the only one talking here.  Opinions are not necessarily those of Sybase.
Newsgroups: comp.databases.sybase
From: shafla@is.morgan.com (Sharon Flanagan)
Subject: Open Server problem
Organization: Morgan Stanley - IS
Date: Wed, 6 Jan 1993 15:17:09 GMT


Hello,

BACKGROUND:

I'm working with a Sybase open server based on the "utility" sample program.
I've written an RPC which allowes various clients to send and recieve
information.  When a client registers for information, it sends the name of
the RPC, a paramater that indicates it is a register message, its transaction
type, and some parameters to hold the information it wants.  The function
allocates space for a new srvproc, uses srv_bmove() to copy the srvproc and
this new srvproc is then added to a linked list which is indexed by
transaction type.  When a client notifies the open server that it has
information, it sends the name of the RPC, a parameter that indicates that
it is a notify message, its transaction type, and parameters which hold its
information. The code goes through the linked list - if it finds a matching
transaction type, it puts information from the current srvproc to a copy of the srvproc from the linked list.

PROBLEM:
The forementioned program works with the first notify.  I use the
srv_senddone() with the SRV_DONE_FINAL flag set when I return the information
to the registering client.  However, when another client notifies that it
has information, my program gets a SEGV error when it tries to find the number
of parameters in the linked list srvproc.  The srv_senddone() function
seems to clear out the parameters from the srvproc in the linked list -
I've used a srv_rpcparams() call after the srv_senddone() and its result is
-1 (perhaps no current RPC).  I've used srv_bmove to copy the srvproc from
the linked list into another area of memory - but it didn't help.

How can I send information back to the clients multiple times over the open
server - client connection?  Is there a way to circumvent the "flush" which
happens with a srv_senddone?  If I use the SRV_DONE_MORE flag, the client
doesn't get data.
I've tested the open server using functions which login to it and then
send information via the dbproc (dprpcparam(), dbrpcsend()).

Any ideas?????

 
Thanks in advance for any assistance.

Sharon Flanagan
shafla@is.morgan.com
Newsgroups: comp.databases.sybase
From: mharper@well.sf.ca.us (Michael J. Harper)
Subject: Accessible Databases & Objects
Organization: Whole Earth 'Lectronic Link
Distribution: usa
Date: Sat, 9 Jan 1993 01:01:42 GMT

I would like to issue a SELECT statment that will tell me what databases I
can USE.  Getting the complete list of databases is a cinch; how do I list
only those to which I have access?

Once I know which databases I can access, how can I list the tables and
views which I can access within a database?

Thanks for the advice!
-- 
Michael J. Harper
mharper@well.sf.ca.us
Newsgroups: comp.databases.sybase
From: jziner@csfb1.fir.fbc.com (Jeffrey A. Ziner)
Subject: Time Zone on 4.2 on HP 
Keywords: RE: Time Zone on 4.2 on HP
Reply-To: uunet!csfb1!jziner
Organization: First Boston Corporation
Date: Fri, 8 Jan 1993 14:41:48 GMT

I believe you problem has to do with the internal timezone setting on the HP server. We had a similiar problem here and had to change the GMT setting. SYBASE utilitizes this setting to report the time.

Aside Note: 4.2 SYBASE on HP 8.X UX OS has many known bugs...I would suggest testing 4.9.1 SYBASE with HP 9.X UX OS to avoid the many potential problems you will occur.

Good Luck

Jeff Ziner
Newsgroups: comp.databases.sybase
From: fosli@ifi.uio.no (\ystein Fosli)
Subject: Accounting of SYBASE
Organization: Dept. of Informatics, University of Oslo, Norway
Date: Fri, 8 Jan 1993 10:39:37 GMT
Originator: fosli@maud.ifi.uio.no

We need to run accounting on some major databases. However
there doesn't seem to be a trivial way to do this.

Is there someone out there that has any experience with running
accounting on the SYBASE SQL server?

One way is probably to poll the SYSPROCESS table regularly, but it
doesn't seem to be the best solution!

Any help would be mostly welcomed.
--

-----
Oystein Fosli	       			Phone:	   +472  441988        
Open Systems Consultants a.s            Fax:	   +472  441988             
Prinsessealleen 21               	Email: fosli@ifi.uio.no 
0275 OSLO               	        
Norway
From: dptom@powerplay.asd.sgi.com (Tom Arnold)
Newsgroups: comp.databases.sybase
Subject: Re: Ethernet and Token Ring
Date: 7 Jan 93 19:00:26 GMT
Distribution: usa
Organization: Silicon Graphics, Inc.

The SQL server will only listen to a single network port. You may be able
to achieve your desired result by installing an open server on say the
Token Ring network port and leave the SQL server monitoring the ethernet.
Unfortunately, this is not a clean solution since the user would have to
set the value of their DSQUERY environment variable to the correct server
depending on the network that they're on. 

-- 
***************************************************************************
**
*       Tom Arnold                    | "When you step in the ocean       
*
*       dptom@sgi.com                 |   you become a part of the        
*
*       Silicon Graphics, Inc.        |    food chain."                   
*
*       (we do it in three            |                                   
*
*        dimensions)                  |                                   
*
***************************************************************************
**
From: jeffl@houdini.sybase.com (Jeff Lichtman)
Newsgroups: comp.databases.sybase
Subject: Re: Max IN clause
Date: 8 Jan 93 20:21:12 GMT
Distribution: comp.database.sybase
Organization: Committee to Increase The Entropy

> Correct me if I'm wrong, but doesn't Sybase convert an expression with
> IN to a JOIN behind the scenes before executing the query? So you will
> not really be avoiding a JOIN.

There are two types of IN clauses:

	... where x IN (select a from ...)

	... where x IN (1, 2, 3, 4, 5, ...)

An IN that is followed by a subquery is usually converted to a join.
The latter type of IN, which is followed by a list of values, is converted
to the following form:

	... where x = 1 or x = 2 or x = 3 or x = 4 or x = 5 ...

---
Jeff Lichtman at Sybase
{mtxinu,pacbell}!sybase!jeffl  -or- jeffl@sybase.com
Newsgroups: comp.databases.sybase
From: andym@appsdir.noname (Andy Morley)
Subject: Re: MSW Excel to Sybase  over TCP/IP ?
Reply-To: andym@appsdir.noname
Organization: Sun Microsystems, Inc.
Distribution: world,na,us,ca,ba,local
Date: Tue, 5 Jan 93 18:06:52 GMT


> I-Bridge: Complete solution for accessing Oracle and Sybase from MS EXCEL

Can you provide me with more information on the I-Bridge product ?

We have been experimenting with using ClearAccess to link MS-Windows
applications via the SYBASE OPEN CLIENT on a PC using PC-NFS to link
with a SUN SPARC 2 running SYBASE 4.8.

Please e-mail response

Thanks,

Andy Morley
EXLOG Inc
(713) 744-3667
amorley@exlog.com


Newsgroups: comp.databases.sybase
From: mishra@hagar.bms.com (NARENDRA MISHRA)
Subject: How good are POWER BUILDER, SQL Windows etc ...
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: Bristol Myers Squibb Pharmaceutical Research Institute
Date: Fri, 8 Jan 1993 17:48:00 GMT

Hi Netters,

   We are Looking into application development Tools like PowerBuilder,
SQLWindows etc. to develop applications against ORACLE database. We would like
to get some input regarding capabilities, limitations etc. of such packages from
developers who have used them. Specifically we are looking for

   i) Ease of application Development
  ii) Reliability and Robustness of the products
 iii) Technical Support available from PowerSoft, Guptas etc.
  iv) Ability to aceess databases over SQL*Net ( using TCP/IP )
   v) Capabilities to produce Graphic output ( like drawing graphs, Charts
      etc.)
  vi) Any other critical features you may think of.
 vii) Do they Support ORACLE 7.0 and 6.0 ?  
viii) Performance of Applications Developed

Please post the replies over the Network or E-Mail to

   mishra@lavc01.bms.com

I will summarize the responses. 


Thanks

Narendra Mishra

Newsgroups: comp.databases.sybase
From: elinden@diana.cair.du.edu (Elwood Blues)
Subject: Query Question 
Organization: University of Denver, Denver, Colorado
 
Date: Fri, 8 Jan 93 20:42:49 GMT

I am querying a payroll table and want to list the year to date hours
by store for four different pay code (reg, OT, sunday, sundayOT)

Basically the query is as follows:

select store, paycode, sum(hours)
from payroll
where paycode in ('reg','OT','sunday','sundayOT')
group by store, ecode
go

This gives me the correct results in the form 
store  code    hours
---------------------
store1 reg     800
store1 OT      40
store1 sunday  30
store1 sundayOT 10
etc.

What I want is for one record per store and 5 columns as follows

store   reg   OT      sunday     sundayOT 
-------------------------------------------
store1  800   40      30         10
etc.

Any ideas would be greatly appreciated.  There are many circumstances in which
I would like to have a single field (hours) displayed in multiple columns.

Thanks

Eric Linden
elinden@diana.cair.du.edu
DBA/Safeway Inc./Denver Division
 
Newsgroups: comp.databases.sybase
From: wenzel@ncsa.uiuc.edu (Patricia Wenzel)
Subject: Re: SQL sort problems (group by?)
Originator: wenzel@pogo.ncsa.uiuc.edu
Organization: Nat'l Ctr for Supercomp App (NCSA) @ University of Illinois
Date: Tue, 5 Jan 1993 18:44:33 GMT


In article <1993Jan4.193801.25423@ctp.com>, sreit@ctp.com (Stefan Reitshamer) writes:
|> I need to sort data in a bizarre way and have NO idea how to do it (other
|> than looping through rows and assigning index numbers and then selecting
|> by ascending index number). Here's the data involved:
|> 
|> Claim #  Subscriber #  Date
|> -------  ------------  --------
|> 22402    111111111     10/10/92
|> 55600    333333333     04/04/92
|> 45200    222222222     09/15/92
|> 22404    111111111     08/08/92
|> 22400    111111111     09/09/92
|> 44900    111111111     08/30/92
|> 45202    222222222     07/01/92
|> 
|> The last 2 digits of the claim # are adjustment numbers (the 00 claim is the
|> original, others are adjustments of the original).
|> I need to sort this data by subscriber number, and by descending date 
|> within each sub #. BUT, if a claim has been adjusted, I need the adjusted 
|> claims to appear after the original (regardless of the date).
|> 
|> Basically, rows with the first 3 digits of the claim # in common should be
|> grouped together. These groups should then be sorted by sub # and descending
|> date.
|> 
|> So, the above data would be sorted as follows:
|> 
|> Claim #  Subscriber #  Date
|> -------  ------------  --------
|> 44900    111111111     05/05/92                     ]Group 1
|> 22400    111111111     02/02/92                          ]Group 2
|> 22402    111111111     03/03/92 <- Adjustment of 22400   ]Group 2
|> 22404    111111111     08/08/92 <- Adjustment of 22400   ]Group 2
|> 45200    222222222     01/01/92                   ]Group 3
|> 45202    222222222     07/01/92                   ]Group 3
|> 55600    333333333     04/04/92              ]Group 4
|> 
|> I was thinking something like:
|>     select *
|> 	group by round(Claim#/100,0)
|> 	order by Subscriber,Date desc
|> but I guess this is incorrect usage of the "group by" clause.
|> 
|> Does anyone know how to "select" this? (Hope this explanation makes some sort
|> of sense)
|> 
|> Thanks very much!
|>   Stefan
|> -- 
On the assumption that the claim # is an integer, the following might work:

  select *
   from table
    order by subscriber, claim #, date

Patricia Wenzel
Newsgroups: comp.databases.sybase
From: esh@prague.tss.com (Edward S. Hirgelt)
Subject: Re: SUMMARY - Notifying clients of table mods
Organization: Teknekron Software Systems, Inc.
Date: Fri, 8 Jan 1993 18:50:10 GMT


On Thu, 7 Jan 1993 14:52:00 GMT,
fgreco@shearson.com (Frank Greco) said:

[Nice summary of client's notification when a table is modified deleted.]

Frank> 	There are other places in dblib where the dataserver calls your
Frank> 	own specified routines (e.g., message/error handling); it'd be
Frank> 	nice if there was some mechanism to allow triggers (and
Frank> 	alerters ... hint... hint) to do this *directly* in Sybase.

Hmmm, let me try to clear up what seems to be a subtle point.

The dataserver does NOT call a routine in the client's process space.
Your message handler is invoked bu dblib when the server sends your
application a message using the standard TDS protocol (Tabular Data
Stream). This is a very synchronous operation. Your application issues a
query which results in some reply. The reply can be data (rows returned)
or informative or error messages. The latter trigger callbacks. DB
Library (OpenClient) in interpreting the data fires your callback, not
the server.

Like I said this is a subtle and pedantic point. However it makes clear
why no other client will be informed. The communication is point to
point. 

This is why the OpenServer or ToolTalk (very nicely done btw) or some
sort of polling in general is the solution. 

Hope this helps clarify things.

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: roder@mayo.edu (Mark N. Roder)
Subject: Help on SQL query
Reply-To: roder@mayo.edu(Mark N. Roder)
Organization: Mayo Foundation, Rochester MN. Campus
Date: Mon, 4 Jan 93 16:42:04 GMT




	I need help on a SQL query. I am working on a application to track  
SMTP mail aliases and need to convert a table of aliases to "/etc/aliases"  
file format.

What I have:

	an = alias name.  alphanumeric(i.e. last.first, sas_users,etc)
	pn = person name. alphanumeric(i.e. login_name@host, "|lpr  
-PsomePrinter"  etc)

Table list
--------------------------------
|  alias        |    person    |
--------------------------------
	a1		p1
	a2		p2
	a2		p1
	a2		p3
	a4		p3
	a4		p6
	a5		p8

What I want:("/etc/aliases" format)

a1:	p1
a2:	p2,p1,p3
a4:	p3,p6
a5:	p8


	Any thoughts on this?  I would like to keep this straight SQL on  
the Sybase server since it would make distribution of the information a  
lot easier.

Thanks for the help

--
Mark Roder
NeXT Consultant, Mayo Foundation
NeXT Mail: 	roder@mayo.edu
phone:		(507) 284-5306
Newsgroups: comp.databases.sybase
From: wolfgang@fraser.sfu.ca (Wolfgang Richter)
Subject: Re: Recovering from a log segment full condition
Organization: Simon Fraser University, Burnaby, B.C., Canada
Date: Wed, 6 Jan 1993 18:20:30 GMT

jeffl@houdini.sybase.com (Jeff Lichtman) writes:



>This change was implemented a long time ago.  No current version of the
>SQL Server should log object ids from tempdb in model.
>---
>Jeff Lichtman at Sybase
>{mtxinu,pacbell}!sybase!jeffl  -or- jeffl@sybase.com

Not true. We experienced this problem with the version of Sybase that
we run on a Silicon Graphics computer (SGI). Currently the latest
version of the Sybase server available for the SGI is version 4.0.1 .
As this is quite an old relatively buggy version of Sybase, I spoke to
Bill Smith of Sybase Inc. He is the product manager for Sybase on the
SGI. He stated at the time (summer of 1992) that a project was just
being started to upgrade Sybase for the SGI and that we could expect
an upgrade to be available sometime in the early part of 1993.

I guess that's what we get for using Sybase on uncommon hardware.

-- 
-- Wolfgang Richter (e-mail: wolfgang@sfu.ca)
-- Academic Computing Services
-- Simon Fraser University
-- Burnaby, B.C.
-- Canada V5A 1S6
-- Phone: 604-291-4449
From: jeffl@houdini.sybase.com (Jeff Lichtman)
Newsgroups: comp.databases.sybase
Subject: Re: Recovering from a log segment full condition
Date: 4 Jan 93 20:20:12 GMT
Organization: Committee to Increase The Entropy

In article <WFINNERT.92Dec21194611@larry.shearson.com>, wfinnert@larry.shearson.com (Warren Finnerty) writes:
> 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.

Usually, when you create an object, that object's ID is logged in the database
that the object is created in.  The server reads these object ids during
recovery and remembers the last one used, so that we don't re-use an object id.

This doesn't work for tempdb, because that database is re-created every time
the server boots.  We used to do the logging of object ids for tempdb in the
model database, instead, which worked because tempdb is created from model.
This created a bottleneck, however - when one user created a database, it would
lock model and prevent other users from creating temporary tables.  We changed
the server so that it doesn't log object ids for tempdb at all - instead, it
relies on the creation time of tempdb (which is the boot time of the server)
to distinguish when an object id is in danger of re-use, so that it can
recompile stored procedures when an object id in tempdb has been re-used.

This change was implemented a long time ago.  No current version of the
SQL Server should log object ids from tempdb in model.
---
Jeff Lichtman at Sybase
{mtxinu,pacbell}!sybase!jeffl  -or- jeffl@sybase.com
From: larryj@sybase.com (Larry Johnson)
Newsgroups: comp.databases.sybase
Subject: Re: DUMP DATABASE ... - to Exabyte tapedrive ???
Keywords: dump.database
Date: 5 Jan 93 18:23:22 GMT
Organization: Sybase, Inc.


Use care about dumping multiple databases to a single tape and
ABSOLUTELY TEST that if you do so you can get the individual databases
back again.

There is no tape positioning done by Sybase, to the best of my
knowledge.  The safest way is to TEST first --or-- dump the databases to
disk files and then use standard UNIX facilities to place them on the
tape.  Then, you can use those same standard utilities to retrieve the
one(s) you need to disk and load them from those files.
Newsgroups: comp.databases.sybase