HDTenEightyP/NetNews huggingface dataset:
From: danw@netcom.com (Daniel Wasserman)
Subject: Converting Money to text strings
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Thu, 28 Jan 1993 17:40:13 GMT

Has anyone out there written a stored procedure that can convert
a money value to its written text equivalent (like what would
appear on a check)?  As an example, I would like to convert 
something like $1,600.32 to "One thousand six hundred and 32/100".


-- 
--------------------------------------------------------------------------
Dan Wasserman                                              danw@netcom.com
Soldier, Cola Wars
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Xref: sparky comp.databases.sybase:725 comp.sys.novell:11827
From: paul@eunet.co.at (Paul Gillingwater)
Newsgroups: comp.databases.sybase,comp.sys.novell
Subject: Re: Sybase NLM: TCP/IP or IPX/SPX?
Date: 22 Jan 1993 23:03:42 +0100
Organization: EUnet EDV Dienstleistungs GmbH A-1010 Wien Austria
NNTP-Posting-Host: hp4at.eunet.co.at

In article <1993Jan21.232944.29218@usage.csd.unsw.OZ.AU> troy@cbme.unsw.EDU.AU (Troy Rollo) writes:
>I'd go for plan B, unless you get unreliable service from that (some
>configurations of Win3.1 don't like the LWP DLL. The problem is,
>it's difficult to find exactly what causes the problem). In that case,
>plan a becomes the fallback position. Also, there is no reason you couldn't
>have *both* available.

We've decided to go for LWP for DOS, to connect our PC's running Windows
on a Novell network with TR adaptors, to a UNIX box with an Ethernet
adaptor.  Am I right in assuming that Novell's MPR 2.0 will support
routing for this scenario?

Another key question, which may be related to TCP/IP support for Sybase
clients -- I consider TCP/IP to be inherently insecure, unless run with
e.g. Kerberos. Question: will Kerberos work with LWP, and is anyone
using this in a client/server environment with Sybase?
-- 
Paul Gillingwater
Home system: paul@actrix.co.at (Waffle)
Newsgroups: comp.databases.sybase
From: jja@fnbc.com (Joseph Alotta)
Subject: anyone going to SF in  March 1-3,  or April 23-29?
Keywords: sybase,conference
Organization: First National Bank Of Chicago, Chicago IL, USA
Date: Wed, 20 Jan 93 22:41:28 GMT

hi,

i was thinking about going to one of the conferences
coming up, the one hosted by sybase or the international
user group.

which one do you think will be better?
and why?


joe.

--
==============================================================
! joe alotta                                    jja@fnbc.com !                                               
!                                             (312) 732-3439 !
!                                                            !
! "The main thing is to keep the main thing the main thing." !
! Dr. George Sweeney                                         !
==============================================================
Newsgroups: comp.databases.sybase
From: troy@cbme.unsw.EDU.AU (Troy Rollo)
Subject: Re: Sybase NLM: TCP/IP or IPX/SPX?
Organization: University of New South Wales
Date: Thu, 21 Jan 1993 23:29:44 GMT

From article <glenn.43.0@hup.ucla.edu>, by glenn@hup.ucla.edu (Glenn Scott):

This is more of a networking question than a Sybase one, but....

> Should I:
> 
>     a)  IP-Tunnel each of the five servers to the database server and 
>         use IPX/SPX (NetWare's native protocol) from the workstations,
>         or
>         
>     b)  Use Lan Workplace (since it's there already) and do everything

>         via TCP/IP, thus forgetting about tunnelling?

I'd go for plan B, unless you get unreliable service from that (some
configurations of Win3.1 don't like the LWP DLL. The problem is,
it's difficult to find exactly what causes the problem). In that case,
plan a becomes the fallback position. Also, there is no reason you couldn't
have *both* available.
       
> I'm sure there are many other factors to consider, but
> 
>     -   will the TCP/IP connection give me better performance?  Worse?  

Probably worse, especially if it means things get dumped onto the same
physical cable twice.

>     -   If I go IPX/SPX, will the tunnelling at the server cause a big 
>  	performance hit?

	It will cause some. Some will also be caused with TCP/IP if
	the server is also a bridge or a router.

>     -   Is there any special difficulty setting up the NLM to service
>         concurrent IPX/SPX and TCP/IP connections, in case I want to mix
>         and match?

There shouldn't be. *This* is a Sybase question. Presumably it's just a
matter of specifying both in an interfaces file.
--
_______________________________________________________________________________
troy@cbme.unsw.EDU.AU	      Overworked, overcommited and always multitasking.
Opinions expressed are not those of the CBME or UNSW, but are my opinions only.
You are free to adopt them.   I suggest you adopt them.    You will adopt them!
Newsgroups: comp.databases.sybase
From: bmyers@fmrco.COM (Brad Myers)
Subject: Re: how to retrieve rows > X bytes (sortof)
Organization: Fidelity Management and Research Co., Boston, MA
Date: Mon, 25 Jan 1993 16:01:52 GMT

In article <1993Jan21.220509.17962@Princeton.EDU> gpmenos@firestone.Princeton.EDU (Gerard Philippe Menos) writes:
>Anyone know if it's possible to create a report showing the rows  
>(e.g., list values of key field) where the size (in bytes) of the row  
>is greater than X (e.g. 500K) [--we're dealing with images].
>
>Or, we could also solve our problem if dbcc (or some other approach)  
>could report the size of each row --then we'd find the rows we need on  
>a case-by-case basis. [The database is not large enough to preclude  
>this approach.]
>
>[What happened is that some images were accidentally scanned and  
>stored at a higher dpi than we would like to use;  we would like to  
>identify which rows are holding images at the higher dpi, in order to  
>re-scan and re-store the images.]
>
>Thanks for any tips.
>Phil
>-- 
>-------------------------------------------------------------
>G. Philippe Menos [gpmenos@firestone.princeton.edu]
>Systems Administrator,   Princeton University Libraries
>voice:  609-258-5183     fax:  609-258-5571

Phil,

Try using the datalength() function of TSQL on the column you are looking for.

Example:

     select <blah>, <blah> from <table>
     where datalength(image_column) > 500000

This should find the offending rows.  I don't know of any easy way to get the
total row size for each row, however, unless you wanted to add the datalength
of each column together...

Hope that helps...
Brad

-- 
 Bradley Myers                                  | "Why me, John Big Boote?"
 bmyers@fmrco.com                               | "It might be booby-trapped"
 Fidelity Investments, Boston, MA               | "Oh. Okay"
 The opinions expressed don't belong to anybody |     -- TAoBBat8D
Newsgroups: comp.databases.sybase
From: hanafey@eplrx7.es.dupont.com (Mike Hanafey)
Subject: Re: Sybase 4.9.1 Returns the Wrong Rows
Keywords: SQL
Organization: DuPont Central Research & Development
Date: Fri, 22 Jan 1993 10:36:57 GMT

After getting a few responses to my initial posting, I still believe Sybase returns the
wrong result for the query below. I think some confusion comes from it appearing that
the select in the "where" clause is a join. In fact it is a correlated subquery (table
"c" is not listed in the "from" clause of the second select). For each row in "c", the rows
in "b" that have the same value in b.c1 as the current row's c.c1 are counted, and  if this
count is > 1 the row is selected. Since "b" has no duplicates in "c1", no rows should ever be
selected, regardless of what is in "c".

I tried this same query on VAX rdb, and got the expected result of "0 rows selected".

The Sybase result is repeated below:

     1> select c.c1 from c where (select count(*) from b where b.c1 = c.c1) > 1
     2> go
      c1          
      ----------- 
                2 
                2 
                3 
                3 
                3 
     (5 rows affected)
 
 
     1> select * from c
     2> go
      c1          
      ----------- 
               1 
               2 
               2 
               3 
               3 
               3 
     (6 rows affected)
 
     1> select * from b
     2> go
      c1          c2          
      ----------- ----------- 
               1           0 
               2           0 
               3           0 
 
     (3 rows affected)
--
From: exuptidw@exu.ericsson.se (Paul D. Tidwell, T/FOD, 6743)
Newsgroups: comp.databases.sybase
Subject: APT Busy Signal
Date: 20 Jan 93 21:17:53 GMT
Reply-To: exuptidw@exu.ericsson.se
Organization: Ericsson Network Systems
X-Disclaimer: This article was posted by a user at Ericsson.
              Any opinions expressed are strictly those of the
              user and not necessarily those of Ericsson.


We have many applications using APT forms (we like to suffer).

There are no major problems, however, we do not consistently
get the busy indication to appear (the '@' above the scroll arrows).

If it does appear, it does so consistently.  But for some functions
it just doesn't show up.  

Does anybody know when it will appear, or how to force it to appear?

Please help!

Thanks,

Paul Tidwell
Newsgroups: comp.databases.sybase
From: danw@netcom.com (Daniel Wasserman)
Subject: Converting Money to text strings
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Thu, 28 Jan 1993 18:13:14 GMT

Has anyone out there written a stored procedure that can convert
a money value to its written text equivalent (like what would
appear on a check)?  As an example, I would like to convert 
something like $1,600.32 to "One thousand six hundred and 32/100".


-- 
--------------------------------------------------------------------------
Dan Wasserman                                              danw@netcom.com
Soldier, Cola Wars
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Newsgroups: comp.databases.sybase
From: bryan@alex.com (Bryan Boreham)
Return-Path: <news@alex.com>
Subject: Re: Sybase Motif interface ?
Organization: Alex Technologies Ltd, London, England
Apparently-To: mail2news@demon.co.uk
Date: Thu, 21 Jan 1993 17:59:35 +0000

In article <ESH.93Jan20121937@prague.tss.com>, esh@prague.tss.com (Edward S. Hirgelt) writes:

|> There is no, to the best of my knoweledge, Motif or OpenLook compliant
|> interface.

I would like to correct this.  Quoting from information published at the time 
of the APT 5.0 launch:

	"The new APT workbench release features the APT-GUI graphical
	extensions that allow developers to build portable applications
	for both character-based and graphical displays.  The APT-GUI
	component will initially support MOTIF and Open Look ..."
	"Sybase licensed key technology to develop the APT-GUI graphical 
	extensions from ALEX Technologies Ltd. of London, England."

You should ask Sybase for more details.

Bryan Boreham
Senior Developer
Alex Technologies Ltd
From: sommar@enea.se (Erland Sommarskog)
Newsgroups: comp.databases.sybase
Subject: 4.8 and 4.9.1 availability
Date: 22 Jan 93 18:14:27 GMT
Organization: Enea Data AB

Some month ago someone from Sybase in this newsgroup told us to upgrade 
to 4.8 or 4.9.1 which would solve many problems recently discussed in
this group, he said.

Well that's fine, except for: where are the beasts? When I briefly
discussed it with Sybase Sweden the other week I got an answer of
the kind "mumble, it's probably not available yet". At least before
when they didn't carry the name Sybase, Sybase Sweden were not known
to be quick on getting upgrades which had been released a long time
ago, but I like to imagine now that when Sybase is lending them their
name, that they get the stuff the quicker, so I figured that the versions
*we* need may not yet be available. But I thought I should check it out 
from some other channel.

So here it goes: is 4.8 or 4.9.1 available for HP 9000/800 and
IBM RS 6000? And if so, together with which versions of HP-UX and
AIX respectively? Presently, we and our customers are running are
running HP-UX 8.00/8.07 and AIX 3.2.
-- 
Erland Sommarskog - ENEA Data, Stockholm - sommar@enea.se
Newsgroups: comp.databases.sybase
From: jja@fnbc.com (Joseph Alotta)
Subject: Re: Sybase Developers Conference
Keywords: conference
Organization: First National Bank Of Chicago, Chicago IL, USA
Date: Tue, 26 Jan 93 19:23:47 GMT

> Could anyone tell me how to register for the SYBASE developer's  
conference
> in March?  I've tried to get the numbers to call for registration from
> SYBASE but have only got the run-around.
> 

the vp who's putting it together says they won't be mailing out
exact info until mid feb.  that gives one only a few days to 
put together travel arrangements.

because of this i decided it wouldn't be well attended, so i'm 
going instead to the int'l user group in april.

at least they've done it before and know how to organize a
conference.

i also think the march conference will be more of a hype session.

joe.


==============================================================
! joe alotta                                    jja@fnbc.com !                                               
!                                             (312) 732-3439 !
!                                                            !
! "The main thing is to keep the main thing the main thing." !
! Dr. George Sweeney                                         !
==============================================================
Newsgroups: comp.databases.sybase
From: ddruker@agsm.ucla.edu (Daniel Druker)
Subject: Looking for Jeannie Malone of SQL Solutions
Followup-To: sender
Organization: Anderson Graduate School of Management, UCLA
Distribution: usa
Date: 26 Jan 93 13:32:12 PST


Sorry for the wasted bandwith but...

Can any of the Sybase people monitoring this group please forward 
the internet email address for Jeannie Malone ? She works for SQL Solutions
out of New York. 

Thanks, 
 
- Dan

Daniel Druker
Anderson Graduate School of Management at UCLA
                   

----------------------------------------------------------------------------
| Dan Druker                                                               |
| agsm mail 	: ddruker                                                  |
| internet 	: ddruker@agsm.ucla.edu                                    |
| oracle*mail	: unix:ddruker@agsm.ucla.edu                               |
----------------------------------------------------------------------------

Disclaimer:  None. I'm a student now and I don't care what you think. 





Newsgroups: comp.databases.sybase
From: skumar@sybase.com (Shiva Kumar)
Newsgroups: comp.databases.sybase
Subject: Re: syslogs
Date: 19 Jan 93 22:39:04 GMT
Organization: Sybase, Inc.

Sybase log formats are SYBASE CONFIDENTIAL. As far as the auit trail feature
goes it is rumoured it would be a part of the SYSTEM 10 release.


Thankx

Siva

Sybase Tech Support

******************************************************************************
MY OPINIONS MAY OR MAYNOT REFLECT MY EMPLOYER'S
*******************************************************************************
From: lindah@darkover.EBay.Sun.COM (Linda Halloran)
Newsgroups: comp.databases.sybase
Subject: High CPU utilization on 4.9.1 Sybase dataserver
Date: 22 Jan 1993 22:37:13 GMT
Organization: Sun Microsystems, Inc.
Distribution: world
Reply-To: lindah@darkover.EBay.Sun.COM
NNTP-Posting-Host: darkover.ebay.sun.com

We have a  C/Dblib application that runs against 4 dataservers, each on
its own Sun4/490. 3 of these machines are involved in 2 phase
commit transactions.  I just upgraded 2 of these machines to Sybase 4.9.1. 
(The 3rd is text and will be converted to something else.)
One of the newly upgraded machines seems to always be 
running between 85-95% CPU on the machine (it's the only process running on
the machine, even when it looks idle, CPU util is at least 80%.)
I'm wondering if anyone else has noticed the same problem and/or has a solution 
or idea of what might be going on.

---

Linda Halloran
Unix DBA Group/AIS
x31464
		    0
		 _ /-_   
		(*)>(*)
From: jja@fnbc.com (Joseph Alotta)
Newsgroups: comp.databases.sybase
Subject: Re: how poratble is embedded SQL across ORACLE, SYBASE, INGRES?
Date: 27 Jan 93 15:08:23 GMT
Organization: First National Bank Of Chicago, Chicago IL, USA

In article <28547@sybase.sybase.com> black@sybase.com (Chris Black)  
writes:
> All of us at Sybase recognize the drawbacks with the 4.0 and pre-4.0
> precompilers.  The new version coming out later this year is a 
> complete re-write and should answer Gerald's concerns.
> 

are you saying system 10 will have a c precompiler as you
describe?

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: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases.sybase
Subject: Re: Sybase Support
Date: 28 Jan 1993 18:15:55 GMT
Organization: Baylor College of Medicine, Houston, Tx
Distribution: world
NNTP-Posting-Host: fleming.csc.bcm.tmc.edu
Keywords: support
Originator: mparsons@fleming.csc.bcm.tmc.edu


In article <1993Jan27.151851.25486@fnbc.com>, jja@fnbc.com (Joseph Alotta) writes:
> 
> i still am waiting on tech support with an answer to my problems, a
> week and 3 days now.  (i installed 4.9.1 and performance is crap.)

Well, I've had some problems solved while I'm on the line, some 
within a couple hours . . . and one that is still outstanding
after 5 weeks!  Yep, more than a month.  It's a server problem/question
which is either stumping them . . . or they've put it on the 
back burner.

Any way, I think a lot of the problem is who you get hold of
at Sybase Tech Support.  My favorite person there moved onto a
new department . . . so now I gotta start looking . . again!!!!
Arrrrrrrggggggg!! ;-)

Mark

Newsgroups: comp.databases.sybase
From: s4uhkm@fnma.COM (Howie Michalski)
Subject: Re: Sybase Developers Conference
Reply-To: s4uhkm@fnma.COM
Organization: Fannie Mae
Date: Tue, 26 Jan 1993 15:04:11 GMT

If I'm not mistaken the conference in March is "by invitation only"...  There
is a users group meeting coming up this summer, I think.
---
#include <Std_Disclaimer>  /* Howard Michalski,    howie@fnma.COM   *
#define OPINIONS "My own"   * Fannie Mae, Unix Technical Services   *
 			    * 3900 Wisconsin Avenue NW              *
main(){for(;;);}	    * Washington, DC, USA           20016   */

Newsgroups: comp.databases.sybase
From: Dave_Wetzel@vos.stratus.com (David Wetzel)
Newsgroups: comp.databases.sybase
Subject: Re: Problem with 4.0.1 user Permissions, SGI
Date: 27 Jan 93 16:50:23 GMT
Followup-To: comp.databases.sybase
Organization: Stratus Computer
NNTP-Posting-Host: dwetzel.mis.stratus.com

In article <1993Jan27.220429.110@iwsd01.itwol.bhp.com.au>,
phil@eedwsa.itwol.bhp.com.au (Phil McMillan) wrote:

> when I type (as "sa" user)
> 
> 	revoke all from user
> 
> it doesnt change the permissions, ie the "user" can still insert.
> 
> However, when I type (as "sa")
> 
> 	revoke all on table from user
> 
> The changes take effect. ie can no longer insert.

This is pretty easy.  The grant/revoke command not only works for
permissions on objects it also manages permissions on commands (like create
table, create default, etc).  So if the server sees "revoke all from user"
with no object refered to it will assume that you're talking about revoking
commands.

The way to test it is this:

   grant create proc to user
   go
   grant select on table to user
   go
   revoke all from user
   go
   sp_helprotect user
   go

This will show the user still has access to select from the table, but no
longer has create proc access.  Next do:

   revoke all on table to user
   go
   sp_helprotect user
   go

Now the user should have also lost access to select from table.

Thanks,
Dave_Wetzel@vos.stratus.com
Newsgroups: comp.databases.sybase
Subject: Problem with 4.0.1 user Permissions, SGI
From: phil@eedwsa.itwol.bhp.com.au (Phil McMillan)
Date: 27 Jan 93 22:04:28 +1000
Distribution: world


I have noted what I think is a bug with 4.0.1 SGI Sybase.

If I grant a "user" in a database permission to select and insert on a "table",
when I type (as "sa" user)

	revoke all from user

it doesnt change the permissions, ie the "user" can still insert.

However, when I type (as "sa")

	revoke all on table from user

The changes take effect. ie can no longer insert.

Can anybody help with this.  Im sure it was working before (we use files
of isql code), and as far as I can tell the only option we have changed is
"select into/bulkcopy"

Thanks,

Phil

-- 
   /\/\     :  Phil McMillan - Software Engineer 
  / / /\    :  Engineering Technology Department
 / / /  \   :  BHP Steel - Slab and Plate Products Division
/ / / /\ \  :  P.O. Box 1854 Wollongong NSW 2500 AUSTRALIA
\ \/ / / /  :  Phone    +61-42-75-3839
 \  / / /   :  Fax      +61-42-75-7897 
  \/\/\/    :  E-mail   phil@eedwsa.itwol.bhp.com.au

Newsgroups: comp.databases.sybase
From: mctrf@ccu.umanitoba.ca (Manitoba Cancer Treatment Mctrf Research)
Subject: NULL value
Organization: University of Manitoba, Winnipeg, Manitoba, Canada
Distribution: na
Date: Wed, 27 Jan 1993 21:45:09 GMT

	"When you compare a null value with another value the result is 
	 never true; a null value does not match anything, not even another
	 null value"
				--- Chapter 2, Transact-SQL User's Guide

Fine.  But I didn't really expect the following.

	1> if convert(int, NULL) = convert(int, NULL)
	2>      print '*** YES ***'
	3> else
	4>      print '*** NO  ***'
	5> go
	*** NO  ***
	1> if NOT (convert(int, NULL) = convert(int, NULL))
	2>      print '*** YES ***'
	3> else
	4>      print '*** NO  ***'
	5> go
	*** NO  ***

To solve the "contradiction" between the two IF's, I have to really
understand next quotation.

	"Computations involving NULL evaluate to NULL, because the result
	must be unknown if any of the factors is unknown."
 				--- Chapter 2, Transact-SQL User's Guide


So, conceptually at least, a Boolean expression evaluates to TRUE, FALSE
or NULL, and neither NULL nor (NOT NULL) is TRUE! 

I'm using Sybase SQL server 4.0.1.

Vincent Yin
mctrf@ccu.umanitoba.ca