HDTenEightyP/NetNews huggingface dataset:
From: mctrf@ccu.umanitoba.ca (Manitoba Cancer Treatment Mctrf Research)
Newsgroups: comp.databases.sybase
Subject: WordPerfect -> Sybase
Date: 27 Jan 93 17:48:46 GMT
Organization: University of Manitoba, Winnipeg, Manitoba, Canada

I am using APT-workbench 4.0.2 to write an application.  Our Sybase 4.0.1 server
runs on Sun stations.  We would like to create a menu in a APT form so that, by
menu, users will be able to view in an APT Window (view only, no modification) a
WordPerfect 5.1 file.  I understand that the file might have to be somehow
loaded into our database as SYBTEXT datatype.  The WordPerfect files will be 
modified frequently by other users using MS-DOS WordPerfect. The WordPerfect files are stored on a network drive using PC NFS. We need some hints for the following problems:

- How to convert and load WordPerfect files so that Sybase users can read (and
  hopefully scroll through) ?  

  Our plan is:
			      C program 	  DB lib.
	WordPerfect 5.1 file -----------> ASCII -----------> SYBTEXT in database
	
  Our WordPerfect files only contain text (plain, bold faced, underlined, italic
  and large sized.)  We are open to any other suggestions.

- What's the best way to view the file (or SYBTEXT) from an APT form?
  Our file size can be limited to 100 lines (worst case).  Do I create an 
  Entry field with Character datatype of Maximum length 9999 in the APT form?

- All the steps from WP to Sybase are combined as a menu processing in APT.  
  So the respond time should not be more than a few seconds for an on-line 
  application.

- As in the SYBASE tradition, all functions are required on-line.  So  
  whatever we do it will have to be quick. 
  
Any help is appreciated.  


Vincent Yin
mctrf@ccu.umanitoba.ca
Newsgroups: comp.databases.sybase
From: bob@MorningStar.Com (Bob Sutterfield)
Subject: Re: Sybase Support
Organization: Morning Star Technologies
	<1993Jan15.153127.14559@trdlnk.uucp> <28529@sybase.sybase.com>
Date: Wed, 27 Jan 1993 17:06:13 GMT

In article <28529@sybase.sybase.com> ben@sybase.com (Benjamin von Ullrich) writes:
   i'm writing to try to assuage any image that sybase technical
   support is less than professional and dedicated.

Thanks for your comments - a revealing look inside a typical company
in this industry.  I'm the tech support manager here, and your
comments ring true regarding the problems of engineering resource
allocation, problem and solution discovery methods, 3rd-party
interoperability testing, and all the rest.  It's hard hard to find
people who are technically competent, possess good interpersonal
skills, and are willing to devote their career path to answering
questions.  When I find people like that I snatch them up quick :-)

   PPP and SLIP, while stated clones of TCP, apparently are not in
   some critical way that seems to confuse Sybase.

As it turned out through further discussions in this newsgroup, the
problem was simply one of addressing.  The SLIP- or PPP-connected host
needed to be identified to Sybase's access control files by the IP
address of its SLIP or PPP interface, rather than the address of its
LAN interface, if those two differed.  It's simply a configuration
problem, not a fundamental incompatibility.

   It would be worthwhile, probably, to be compatible with these
   products, but i think such ventures into new capabilities are
   limited to specification by a marketing organization.  i know
   marketing has a pc certification lab for vendors to come through
   and test their products with our to insure compatibility; i'm not
   sure any SLIP or PPP software has been tested.  

Yes, Paul Beduhn has had our UNIX-based PPP/SLIP product running on a
Sun there for over a year, talking over dialup PPP links to SQL query
clients running on both UNIX systems and DOS boxes.  I don't know what
group he works with inside Sybase, but maybe you can track him down
using the company phone book.

   Since it is PPP's job to be compatible with applications running in
   your platform's TCP/IP driver, it would be worthwhile for you to
   ask your PPP vendor why this connectivity doesn't work.

The original inquirer was using a freely-available PPP implementation,
so he had nobody to turn to for help besides the net.  But, since a
dial-up point-to-point link (PPP or SLIP) just transports IP packets
exactly the same as any other network, it wasn't a matter of what link
software he was using.  Once he got the names and addresses
straightened out in the Sybase access authorization file, everything
worked correctly.
--
Bob Sutterfield, Morning Star Technologies            +1 614 451 1883
1760 Zollinger Rd, Columbus Ohio USA, 43221           +1 800 558 7827
bob@MorningStar.Com                                   +1 614 459 5054 (FAX)
From: spencer@med.umich.edu (Spencer W. Thomas)
Newsgroups: comp.databases.sybase
Subject: Restricting access to rows?
Date: 27 Jan 93 15:33:37
Organization: University of Michigan HSITN
NNTP-Posting-Host: guraldi.itn.med.umich.edu

Is there some easy way to do this?

I want to restrict access to a table according to the value of a
certain field, by user, according to a second "authorization" table.
I.e.,

create table base (
	category	int,	/* The field to restrict access by. */
	data		int
)

create table auth (
	uid		smallint,
	category	int
)

Each user who is allowed to see rows with a given value for 'category'
has an entry in the 'auth' table with his/her uid and the category:

uid	category
----	--------
2	1		User 2 can see categories 1&2
2	2
3	3		User 3 can only see category 3
4	1		User 4 can see categories 1,2&3
4	2
4	3

My thought was to use a view.  Try 1:

create view stuff_1 as 
	select * from base where category in 
		(select category from auth where uid=user_id())

This works fine for select, but can't be updated because it has an
aggregate (the 'in' in the select clause, I assume).

Try #2:

create view stuff_2 as
	select base.category,data from base,auth where
		base.category=auth.category and auth.uid=user_id()

This works for select, insert, and update, but not for delete.

Try #3:

As user 2:

create view stuff_3 as
	select * from base where category in (1,2)

This works, but ONLY IF user 2 has permissions on the base table.
Clearly, that defeats the whole purpose.

Any ideas?

--
=Spencer W. Thomas 		|  Info Tech and Networking, B1911 CFOB, 0704
   "Genome Informatician"	|  Univ of Michigan, Ann Arbor, MI 48109
Spencer.W.Thomas@med.umich.edu	|  313-747-2778, FAX 313-764-4133
Newsgroups: comp.databases.sybase
From: bob@bobsled.glv.com (Bob Lunney)
Subject: Re: patindex broken between 4.2 and 4.8
Keywords: patindex, bugs
Organization: Encompass
Date: Thu, 28 Jan 1993 19:51:04 GMT

In article <1993Jan28.154119@genethon.fr> stuart@genethon.fr (Stuart Pook)  
writes:
> 
> Has anybody noticed that patindex has been broken
> between Sybase versions 4.2 and 4.8?  The following
> scripts illustrate how patindex used to be correct
> (under 4.2) and how it now gives the wrong result.
> 
> Does the same problem exist under 4.9?
> 
> $ sql -SGENGDB
> 1> select @@version
> 2> go
>                                                                    
>  ----------------------------------------------------------------- 
>  SQL Server/4.2/P/sun4/os4/EBF632/OPT/Tue Aug 27 11:58:42 PDT 1991 
> 
> (1 row affected)
> 1> select patindex("%[^0]%", "000")
> 2> go
>              
>  ----------- 
>            0 
> 
> (1 row affected)
> 
> $ sql -SGENETHON
> 1> select @@version
> 2> go
>                                                                        
>  --------------------------------------------------------------------- 
>  SQL Server/4.8/P/Sun 4/SunOS 4.1.X/5/OPT/Fri Apr 24 10:15:10 PDT 1992 
> 
> (1 row affected)
> 1> select patindex("%[^0]%", "000")
> 2> go
>              
>  ----------- 
>            3 
> 
> (1 row affected)


Works fine on our VAXes:

1> select @@version
2> go
                                                              
 ------------------------------------------------------------ 
 SQL Server/4.8/EBF1068/VMS/5.4-1A+/5/30-SEP-1992 14:08:42.15 

(1 row affected)
1> select patindex("%[^0]%", "000")
2> go
             
 ----------- 
           0 

(1 row affected)
From: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases.sybase
Subject: Re: APT Busy Signal
Date: 21 Jan 1993 14:44:17 GMT
Organization: Baylor College of Medicine, Houston, Tx
Distribution: world
NNTP-Posting-Host: fleming.csc.bcm.tmc.edu
Originator: mparsons@fleming.csc.bcm.tmc.edu


In article <1993Jan20.211753.27206@exu.ericsson.se>, exuptidw@exu.ericsson.se (Paul D. Tidwell, T/FOD, 6743) writes:
> 
> 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

We persevere with APT here, too!! ;-)

From what I've read, heard, and seen in practice, the '@' appears
during submits to the server.  If your fpl's aren't doing any
submits to the server, i.e., it's all local/front-end processing, you
won't get the '@' flashing.  Also, if you have a 'fast' connection
to the server and/or the server returns your request fast(not
many users banging on the server?) you may not notice it flash?

Mark

p.s. ---- This is a bunch of nothingness here in this p.s. since
	  this current version of xrn(at least on our machines)
	  requires that I have more new text than 'included' text.
	  Give me a break! Arrrrrrrrrrrggggggggg!! OK, let me
	  try this again . . . 
Newsgroups: comp.databases.sybase
From: kdomb@ctp.com (Kevin Dombroski)
Subject: loading data, triggers, bcp, etc.
Keywords: triggers, bcp
Organization: Cambridge Technology Partners
Distribution: usa
Date: Wed, 27 Jan 1993 15:11:59 GMT


Folks,

	How do you load a flat text file into a Sybase database table that will
utilize the triggers and indices set up for that table? The documentation is a
bit misleading, and some preliminary tests show that the triggers are not used
with 'bcp' (although indices are updated). What is the "slow version" of 'bcp'
that is supposedly used? Any information would be greatly appreciated.
Thanks.


				KevinD
-- 
================================================================================
Kevin M. Dombroski                  | "One good thing about music,
Cambridge Technology Partners       |  When it hits, you feel no pain...." 
================================================================================
Newsgroups: comp.databases.sybase
From: jja@fnbc.com (Joseph Alotta)
Subject: performance decrease with 4.9.1
Keywords: performance
Organization: First National Bank Of Chicago, Chicago IL, USA
Date: Tue, 26 Jan 93 19:30:31 GMT

greetings,

we recently updated to 4.9.1 and found that the
performance has markedly decreased.

we don't really know why.  neither does sybase tech
support.

we've seen some processes running with a sp_who that
appear to be dumping the transaction files, but we don't
know if this is the cause or something else.

we have a sun sparc2 with 64MB, but i've seen 4.2 run faster
with 4MB.

did anyone out there experience this same sort of performance
hit?  any suggestions on what i might try?  please.....

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: pburry@manitou.cse.dnd.ca (Paul Burry)
Subject: Sybase Developers Conference
Organization: Canadian System Security Centre
Date: Tue, 26 Jan 93 03:17:41 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.

Any information would be appreciated,
	Paul
-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Paul Burry			
Voice: (613)-991-7325		Internet: pburry@cse.dnd.ca
Fax:   (613)-991-7323		UUCP:	  ..!{uunet,cunews}!cse.dnd.ca!pburry
Newsgroups: comp.databases.sybase
From: kkurk@ctp.com (Kendra Kurk)
Subject: Why won't select into work?
Organization: Cambridge Technology Partners
Distribution: us
Date: Fri, 22 Jan 1993 00:25:12 GMT


While creating a stored procedure, I ran into a problem that
I can't seem to solve; perhaps someone out there can lend a hand!

create proc foo
(
	@id1	int,
	@id2	char(2)
)
as

select
	name,
	dollars
into
	#tmp
from
	DATABASE_1..Record
where
	id1 = @id1
and	id2 = @id2

This returns an error 'implicit conversion from datatype int to datatype
char not allowed.'  HOWEVER, when I declare the table and insert into,
there is no trouble - WHY?!!!  This is very frustrating, and we can't
seem to figure out why it occurs.

create proc foo
	@id1 int,
	@id2 char(2)
as

create table #tmp
(
	name char(10),
	dollars int
)

insert into #tmp
select
	name,
	dollars
from
	DATABASE_1..Record
where
	id1 = @id1
and	id2 = @id2


Thanks in advance . . .
Kendra

PS Running Sybase, version 4.9.0 on an HP

Kendra Kurk
CTP Inc.
(617) 374-9800
kkurk@ctp.com

-- 
Kendra Kurk
kkurk@ctp.com
Cambridge, Mass
From: lmcgee@bondo.corp.sgi.com (Lee McGee)
Newsgroups: comp.databases.sybase
Subject: Re: syslogs
Date: 22 Jan 93 18:04:12 GMT
Reply-To: lmcgee@sgi.com
Organization: Silicon Graphics, Inc., Mountain View, CA, USA

In article <28244@sybase.sybase.com>, skumar@sybase.com (Shiva Kumar) writes:
|> 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

What Siva and others in Sybase technical support use, at least in release 4.2 and previous, is the "DBCC LOG" command, which prints out formatted log records for analysis. 

Why this command is not available to users is a _mystery_ to me.  It is extraordinarily useful for analysis of the update behavior of application SQL -
(what?  inserting 10 rows causes HOW MUCH physical IO? WHY?) - somehing that every Sybase database administrator in the land ought to have access to. 

(saw/heard on the phone a Sybase/SQL Solutions technical rep "perform" this command once, a long while ago... I put the command into my notebook for future use!)

This group ought to demand to Sybase that "dbcc log", and any other benign technique that might by highly useful to the user community, be published for general use.  It does not matter whether Sybase log formats are confidential or not, and frankly the log format should be of no concern to the user.  What does matter is that we are able to report on log contents, for problem analysis.

BTW the transaction log would not be very useful for auditing a user.  It shows
what data pages were changed and what physical commands happened to change them, but not necessarily what happened logically.


-- 
           Your Data Base Administrator:  LEE MCGEE

	   	   --    safe       -- 
		   --   reliable    --
	           --  courteous    --
From: jimj@meaddata.com (Jim Johnstone)
Newsgroups: comp.databases.sybase
Subject: RE: WANTED: Software to draw ER diagrams for Sybase
Date: 22 Jan 1993 23:16:35 GMT
Organization: Mead Data Central, Dayton OH
Distribution: na
Reply-To: jimj@meaddata.com
NNTP-Posting-Host: moose.meaddata.com

We used ERwin/SQL from Logic Works (609-243-0088). It runs under
Windows 3.1 (about $1400)

It is a great tool for logical design and data dictionary construction.
It will even generate the SQL to create the database exactly like the 
logical model. It was real easy to learn and use. Your mileage may vary
when using it for *hundreds* of tables. We only have about 50 tables.

I have also used System Architect from Popkin Systems for DFD & FSM.
The new release of that has some ERD capabilities that might be useful.

> From: paul@eunet.co.at (Paul Gillingwater)
> Subject: WANTED: Software to draw ER diagrams for Sybase
> Date: 21 Jan 1993 21:42:23 +0100
> Lines: 20
> 
> Hi,
> We have a large existing database in PACE that we have to migrate to
> Sybase.  I've undertaken to redraw all the entity-relation diagrams, but
> would like a software tool to do this (and maybe generate some of the
> code necessary to build the tables?)
> 
> Primarily it should be a documentation tool, but if it can output
> schemas then that would be great.  I've heard of DEFT, but believe this
> only runs on the Mac.  What experiences have folks had with other tools,
> and what about generic "drawing" packages like Corel?  Can they handle
> this type of drawing easily?
> 
> Since our database has several *hundred* tables in 3nf, we would need
> something that can handle the linkages and the rat's nest of lines
> connecting boxes.
> 
> Thanks in advance!
> -- 
> Paul Gillingwater
> Home system: paul@actrix.co.at (Waffle)

-- 
Jim Johnstone              jimj@meaddata.com                           
Mead Data Central          
P.O. Box 933               I do not speak for Mead Data Central
Dayton, Ohio  45401       
Newsgroups: comp.databases.sybase
From: s5ucgp@fnma.COM (Charles Pavelka)
Subject: Re: Accessing MS SQL Server from Unix
Reply-To: s5ucgp@fnma.COM
Organization: Fannie Mae
Date: Thu, 28 Jan 1993 22:32:14 GMT


The best thing you can do now is using SQL BRidge from MS.

TCP/IP ....>SQL BRIDGE <....Named Pipes

Good luck!
tle@sybase.com
From: ch140@cleveland.Freenet.Edu (Jeffrey G. Brown)
Newsgroups: comp.databases
Subject: Looking for List of Clipper Consultants
Date: 23 Jan 1993 03:18:46 GMT
Organization: Case Western Reserve University, Cleveland, OH (USA)
Reply-To: ch140@cleveland.Freenet.Edu (Jeffrey G. Brown)
NNTP-Posting-Host: hela.ins.cwru.edu


My company has a Clipper (S87) application that needs some work
to finish it up. The programmer [me... :-( ] has been pulled off
the project to assume other duties. I am looking for any lists
or directories of Clipper programmers or consultants that may
be out there. Thanks in advance....

Jeffrey G. Brown
ch140@cleveland.freenet.edu

Newsgroups: comp.databases
From: dirsolns@world.std.com (Bernard Farrell)
Subject: Re: Pdox/Win
Organization: Directed Solutions Group
X-Newsreader: Tin 1.1 PL3
Date: Fri, 22 Jan 1993 03:12:54 GMT

Well last night in Boston at the BCS, Mr. Kahn gave a fairly long
presentation on Pdox/Win and confirmed that the price for it was
$139.95 and $99.95 for Quattro-Pro.

ObjectPAL LOOKS impressive.  But then he was running it on a
notebook with 20MB of memory.  On an 8Mb system, it may be a tad
slower.

Now if only we didn't have to wait till Feb 1 to try it out.
I'm in the Paradox Developers Partners program and can't seem
to get the gamma version promised -- they're probably too busy
shipping the real thing (which I'd HAPPILY pay for if I could get
it today!).


-- 
|----------------------------------------------------------|
|      Bernard Farrell      |   Directed Solutions Group   |
|----------------------------------------------------------|
|   dirsolns@world.std.com  |       (617) 429-2306         |
From: jordan@warped.pnl.gov (Randy Jordan)
Newsgroups: comp.databases
Subject: Re: Help with SQL statement
Date: 27 Jan 93 00:16:58 GMT
Article-I.D.: oracle.1993Jan27.001658.7801
Reply-To: jordan@warped.pnl.gov (Randy Jordan)
Distribution: na
Organization: Battelle, Pacific Northwest Laboratory


In article <1jrpctINNbqk@CANTOR.MATH.YALE.EDU>, muench-philip@math.yale.edu (Philip Muench) writes:
|>Path: pnl-oracle!ogicse!psgrain!charnel!rat!usc!cs.utexas.edu!qt.cs.utexas.edu!yale.edu!not-for-mail
|>From: muench-philip@math.yale.edu (Philip Muench)
|>Newsgroups: comp.databases
|>Subject: Re: Help with SQL statement
|>Message-ID: <1jrpctINNbqk@CANTOR.MATH.YALE.EDU>
|>Date: Fri, 22 Jan 93 21:48:45 PST
|>Article-I.D.: CANTOR.1jrpctINNbqk
|>References: <1993Jan22.211051.4867@vpnet.chi.il.us>
|>Distribution: na
|>Organization: Yale University Mathematics Dept., New Haven, CT 06520-2155
|>Lines: 29
|>NNTP-Posting-Host: cantor.math.yale.edu
|>
|>In article <1993Jan22.211051.4867@vpnet.chi.il.us> mike@vpnet.chi.il.us writes:
|>>I'm having a problem writing an SQL statement for the following situation
|>>(and I'm not sure its really possible)
|>>
|>>I have 2 tables lets say I have a Customer table and an order table.
|>>I want to query the database for all customers and show their orders
|>>for the past month.  I may have more than 1 order for a customer.
|>>
|>>The problem is that if I don't have an order for a customer, the join will
|>>not find a match and that customer will be left out of the report.
|>>
|>>I still want to show the customer even if no orders are present.
|>>
|>>Is this possible with SQL ??  was my explanation clear enough ??
|>>
|>>Thanks 
|>>
|>>   Mike Kamlet
|>>   mike@vpnet.chi.il.us
|>>
|>>
|>
|>Put a false order that you can easily recognize as false in the order
|>table for every customer, or at least for every customer that has no
|>real order.
|>Joins, as you have found, are useless for finding records in one table
|>that do not have a corresponding record in the other table.
|>-Philip Muench
|> muench@cantor.math.yale.edu 128.36.23.26
|>
--
	select cust_ip, order_number = ''
        from customer 
	where cust_id not null
	union
	select cust_id, order_number
	from orders
	where cust_id not null
	order by cust_id

RJ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	To Thyne Own Self be true...
	                             myne opinions are.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Newsgroups: comp.databases
From: naja@egr.msu.edu (Naja Mohamad)
Newsgroups: comp.databases
Subject: Comparison between Informix and Sybase? Which one to use?
Date: 26 Jan 1993 05:38:17 GMT
Organization: Michigan State University, College of Engineering
Distribution: na
Reply-To: naja@frith.msu.edu
NNTP-Posting-Host: frith.egr.msu.edu
Keywords: RDBMS, Informix, Sybase

Take the following setting for example: We have a network of PCs and
workstations. Our applications involve heavy use of imaging (keeping
documents with pics/images in them/catalogging/...) and all have to 
be stored in the database. The question comes down to which of Sybase
or Informix would be a better choice?

Please be specific about the details of any comparison you may offer
(it will be hard to bore me on this one, so feel free and let your fingers
bang at it as much as you like).  I don't mean to start a war here and I
hope that doesn't take place. 

In order to minimize the possibility of wars/flamers, please direct all
your replies to my e-mail address (PLEASE do not followup on this). If
there is enough interest, then I'll summarize and post.

Thanks much.

Naja	naja@frith.msu.edu    uunet!frith!naja


Newsgroups: comp.databases,comp.databases.informix
From: corinne@dssmktg.uucp (Corinne Gregory)
Subject: Informix & Ingres coresident app's
Organization: Data Systems Support
Date: Thu, 28 Jan 93 19:01:55 GMT

Hello...

     I have a question about the feasibility of sharing data between two
applications -- one Informix-based, and one Ingres-based.  I'm not up on
Ingres and SQL-compatibility, but I'd like to make it easier than having
to do SQL unloads and loads on a periodic basis.  Is there an easier (and
more user-transparent) method?  I'm interested in efficiency as much as
I am in seamless-appearing integration.

    Thanks for your help.

- Corinne

-- 

Corinne Gregory (corinne@dssmktg.uucp; bangpath - uunet.uu.net!dssmktg!corinne)
Manager, Development & Support                           Data Systems Support   
Ph: 714.771.0454  Fax: 714.771.3028                          Orange, CA