HDTenEightyP/NetNews huggingface dataset:
From:  hgpeach@ms.uky.edu (Harold G. Peach, Jr.)
Subject: Program Rights in NetWare?
Organization:  University of Kentucky
Date: Fri, 22 Jan 1993 16:27:30 GMT

I am designing a database for use on a NetWare 386 LAN.  What I would like
to setup is a system where users enter information into a temporary file
stored in a directory they have RW access to.  Then after validation,
have the entry program append the transaction file to a master file
kept in a subdirectory that only the supervisor has RW access to.  Is
there a way to give a program file/subdirectory access that the user using
the program does not have?  I know this can be done under UNIX and several
other platforms, but don't see anything in my Novell reference about how
to do it in NetWare.
---
Harold G. Peach, Jr.                              Home Phone:  (606) 271-6393
University of Kentucky, Lexington               Campus Phone:  (606) 257-3335
hgpeach@ms.uky.edu                                       FAX:  (606) 258-5842
  (Opinions above are expressed as a student of the University of Kentucky)
Newsgroups: comp.databases
From: rohrernl@helix.nih.gov (Nathan Rohrer)
Subject: Phone number for Powerbuilder?
Organization: National Eye Institute, National Institutes of Health
Date: Thu, 28 Jan 1993 13:21:38 GMT

Does anyone know a number I can reach to get some information on 
Powerbuilder?  By the way,  what is the Net consensus on Powerbuilder?  
Thanks.

Nathan



/*********************************************************************/
/*                       --- Nathan Rohrer ---                       */
/*  NATIONAL EYE INSTITUTE, OFFICE OF SCIENCE POLICY AND LEGISLATION */
/*              MANAGEMENT INFORMATION SYSTEMS SECTION               */
/* BITNET: NLR@NIHNEI31                  BETHESDA, MD 20892-0031     */
/* INTERNET: rohrernl@helix.nih.gov      NIH 3Com: NLR:NEI31:NIH     */
/* CompuServe: 70670,3164                PHONE: 301 496-2194         */
/*                                                                   */
/* Disclaimer: Did you really think my views represented those of    */
/*             the United States Government?                         */
/*********************************************************************/
From: torbecvs@ucbeh.san.uc.edu
Newsgroups: comp.databases
Subject: Re: dBASE executables
Date: 26 Jan 93 20:05:20 GMT
Organization: Univ. of Cincinnati

In article <1993Jan26.010720.8478@gmuvax2.gmu.edu>, twallace@gmuvax2.gmu.edu (Todd Wallace) writes:
> Does anyone here know how to turn dBASE applications into
> standalone executables for DOS?
> Thanks.
> ----------------------------------------------------------------
> |    Todd Wallace               |  "A pessimist is surprised   |
> |    twallace@gmuvax2.gmu.edu   |   as often as an optimist,   |
> |                               |   but always pleasantly."    |
> |                               |            - Robert Heinlein |
> ----------------------------------------------------------------
Clipper is one route to take.
Scott
Newsgroups: comp.databases
From: jonm@Ingres.COM (Don't Judge a book by your cover)
Subject: Re: Counting Null Values in an SQL Query
Summary: 
News-Software: VAX/VMS VNEWS 1.41    
Keywords: I am a Beginner
Organization: University of Arizona MIS Department - Mosaic Group
Date: 21 Jan 93 09:28:11 GMT

In article <1993Jan20.233912.13272@mnemosyne.cs.du.edu>, afadel@nyx.cs.du.edu (Ayman Fadel) writes...
> 
>The problem is I'm also supposed to count the
>number of patients in each unit form whom no
>value of acuity was entered, ie. level is null.
> 
>This is what i got
> 
>select   station,
>         level,
>         count(level)	   
>from ag_medical                      //the name of the table
>where in_house='YES'
>group by station, level
>order by station, level
> 
>Everything is good except that I cannot get a count for the
>number of patients without an acuity.

That is because aggregates ignore NULLS.  If you do count(*) it should work.

Jon

+---------------------------------------------------------------------------+
|Jon Machtynger (jonm@ingres.com)                                           |
|Ingres Technology Centre. Wharfedale Rd,                                   |
|Winnersh, Wokingham. Berks UK.   (0734)-496525                             |
+---------------------------------------------------------------------------+
| Ahhh Brisbane, people actually get paid to work there... in the sun with  |
| all that fresh air and cheap petrol.... Or so legend has it               |
+---------------------------------------------------------------------------+
From: natola@coos.dartmouth.edu (Mark A. Natola)
Newsgroups: comp.databases
Subject: dbase III+ color screen software
Date: 26 Jan 93 20:28:41 GMT
Organization: D.M.S. Section of Neurology

I am looking for software which will display dbase III+ in color on my 
monitor.  I saw a shareware version for dbaseII, but it did not work with 
III+.  Any suggestions?

Mark
Newsgroups: comp.databases
From: rkng@rd.hydro.on.ca (Ron Ng)
Subject: Re: Paradox: table and index with different sort orders
Organization: "Ontario Hydro - Research Division"
Date: Fri, 22 Jan 93 14:43:27 GMT

gordon@chmeds.ac.nz writes:
: One of our users has many tables which he cannot access because of a common 
: error: "table and index have different sort orders". This is probably because 
: the files have been moved between different PCs with differently configured 
: Paradox setups.
: 
: Is there an easy way to fix this problem?  The only suggestions I have so far 
: involve reentering many sets of data manually. That has been described as 
: character-building. 
:
This problem was caused by two different PARADOX.SOR (or PDOXRUN.SOR if
you are using the runtime version) files residing in the two machines.
I recommend you to ask the user to remove the current PARADOX.SOR file
(or renaming it) and copy one of ASCII.SOR, INTL.SOR, NORDAN4.SOR, 
NORDAN.SOR and SWEDFIN.SOR as PARADOX.SOR depending on which sort order
were used when installing Paradox in the machine where the tables are 
copied from.

Ron.K.Ng@hydro.on.ca
From: ken.lundberg@tfd.coplex.com (Ken Lundberg) 
Newsgroups: comp.databases
Subject: Help with a structure and
Date: 21 Jan 93 21:22:00 GMT
Distribution: world
Organization: Ky/In PC User's Group - Louisville, KY - 502-423-8654
Reply-To: ken.lundberg@tfd.coplex.com (Ken Lundberg) 

TO: jdrew@ucsvax.sdsu.edu

FR: ken.lundberg@coplex.com

On Wed, 20 Jan 1993, Joe Drew of San Diego State wrote:

>...I'd like to set-up a database application where a user could request a
>specific data series as well as have the option to select it for only a
>specific time period.  For example:the consumer price index  from 1980 to
>the most current period.  Moreover, the user would most likely select
>other series that may start and end at different times.  I'd like them to
>be able to end up with ONE table that includes all the data they selected...

 Joe, any PC database package will do the trick so far as you've described
 the system. A few of points from personal experience may save you time:

 1. Proper design will keep hair on your head, and users out of your face.
    Put MUCH time into design, and don't start coding too soon.
 2. Proper Indexing = Easy data retrieval. By "proper," I mean effective.
    Database systems live or die by indices.
 3. Multiuser considerations come to mind, but that's for another article.

 Your users need to select data by:  a (user defined) range (ex: date)
                               and:  meeting (user defined) criteria...

 This is a normal request for any database system. How 'bout this for a
 record layout?

 date *   (other data fields)    CPI      (other data fields)
 ------- --------------------- ------- ---------------------------------
 ------- --------------------- ------- ---------------------------------
 ------- --------------------- ------- ---------------------------------
 ------- --------------------- ------- ---------------------------------
      * this field would be indexed.

 If you set up this simple data file, indexing on date, and storing the CPI
 that was effective on that date, any user could easily use a query
 facility to extract a data "series" that meets their criteria. This could
 be stored in a table, printed, sent to Lotus, etc. Does this help?

 * SLMR 2.1a * ------------------------------------------Ken-in-Kentucky
                  
Newsgroups: comp.databases
From: an5802@anon.penet.fi (The Inquisitive One)
Subject: Comparison of OODBs
Organization: Anonymous contact service
X-Anonymously-To: comp.databases
Date: Sat, 23 Jan 1993 06:20:26 GMT


Does anyone know of any work on comparison of two or more OODBs for effiency, speed, etc ? Any sources would be welcome.
I do know of the existence of the OO1 benchmark developed at Wisconsin in March 1992.

Thanks 

P.S. Has there been any comparative study of the various OODBs in the market, in general, in terms of implementation and other features available to the programmer ?

-------------------------------------------------------------------------
To find out more about the anon service, send mail to help@anon.penet.fi.
Due to the double-blind system, any replies to this message will be anonymized,
and an anonymous id will be allocated automatically. You have been warned.
From: mattias@tse.uucp (Mattias Hembruch x0830)
Newsgroups: comp.databases
Subject: Re: WANTED: dBASE IV/FoxBase+/Recital
Date: 27 Jan 93 17:35:37 GMT
Organization: Toronto Stock Exchange

In article <C1Fqu3.vJ@techbook.com> jamesd@techbook.com (James Deibele) writes:
>Have you gone on to a "real" database?  Do you have a copy of dBASE IV,
>FoxBase+, or Recital sitting around your SPARC (preferred) or System V
>Release 4 box?  Wouldn't you like to sell it so that you can spend the
>money on Codd's book?
>
>If so, please let me know and we can arrange terms.
>
>Oh, yeah: FoxPro for UNIX has been "real soon now" for about 2 years.
>Anybody want to get a pool going on when it's going to come out?  Or 
>does everybody think the sun will have cooled before Microsoft releases
>something that might interfere with  Windows NT?

I agree that MS is pushing NT, BUT, in their latest adds, featuring Access &
FP2.5/WIN, they DEFINITELY state that FP2.5 mac&unix ARE coming..

Mattias


-- 
Mattias Hembruch
>> My views do not necessarily reflect those of the TSE. <<
E-mail: mattias@tse.asd.tse.ca
Newsgroups: comp.databases
From: mcdonald@aries.scs.uiuc.edu (J. D. McDonald)
Subject: Paradox question
Organization: UIUC SCS
Date: Sat, 23 Jan 1993 18:41:30 GMT

I'm a very novice Paradox user, like about 36 hours. We (here at the
huge U of I) seem to have nobody who knows about Paradox (despite,
one might add, have a group of folks contracted to Borland to
support a site license for it).

I've constructed a moderately elaborate 3-table data base for my rock
collection. I can do everything I want, including makeing upo forms
and reports, but there are three things that seem horrible klunky.

1) I can't get the "modify" or "data-entry" things on a table to
come up automatically with the proper form for that table ... I
have to change it manually every time with Image. How does one do this?
Some sort of simple macro? 

2) I can Ask to my heart's content and it works fine, but getting a 
report on the result is a pain .. I have to COPY a report type to
the Answer table by hand every time I create a new Answer .. is there some 
way to make this stick .. I tried copying Answer over an old table to
which I had already attached a report, but that seems to lose the report 
already attached.

3) Is it possible in one Ask operation (not two in a row, that's obvious)
to query a table like

F1    F2
1      a
1      b
1      c
2      b
2      d
3      c
4      e
5      c
6      a
6      d

where both F1 and F2 are keyed so that I generate an Answer table
with all the records that have the same F1 number as any F1 that
has a "b" in f2?

Doug McDonald
Newsgroups: comp.databases
From: viking@iastate.edu (Dan Sorenson)
Subject: Re: Dbase III question
Organization: Iowa State University, Ames IA
Date: Sun, 24 Jan 1993 20:31:42 GMT

In <19992@mindlink.bc.ca> John_Carson@mindlink.bc.ca (John Carson) writes:

>@ 12,12 "Enter Firstname:"  get x                  PICTURE "!XXXXXXXXXXX"
>@ 13,12 "Enter Lastname: "  get y                  PICTURE "!XXXXXXXXXXX"

>mname = trim(x)+" "+y
>REPLACE FIRSTNAME WITH x
>REPLACE LASTNAME WITH y
>REPLACE FULLNAME WITH mname

	@12,10 say 'Enter Name:'
	@12,20 get fullname picture '!XXXXXXXXXXXXXXXXXXXX'
	read
	store 1 to x
	store .f. to caps
	do while x<=20
		store substr(fullname,x,1) to temp
		if temp<>' ' .and. caps
			store substr(fullname,x-1,1)+upper(temp)+;
			substr(fullname,x+1) to fullname
			store .f. to caps
		endif
		if temp=' '
		store .t. to caps
		endif
		x=x+1
	enddo
	@12,20 get fullname picture 'XXXXXXXXXXXXXXXXXXXX'
	read

It's a simple little loop which I've used before.  The last GET allows
the user to correct any problems my routine creates, such as what might
get caused by initials being entered (eg: i.m. customer = i.m. Customer),
but of course such things can be used above (if temp=' ' .or. '.' .or.).

Anyway, this is a simple routine that might do what you want without
having extra fields and the like introduced.

< Dan Sorenson, DoD #1066 z1dan@exnet.iastate.edu viking@iastate.edu >
<  ISU only censors what I read, not what I say.  Don't blame them.  >
<     USENET: Post to exotic, distant machines.  Meet exciting,      >
<                 unusual people.  And flame them.                   >
Organization: Arizona State University
Date: Tuesday, 26 Jan 1993 13:57:54 MST
From: <IDAZS@ASUACAD.BITNET>
Newsgroups: comp.databases.sybase
Subject:    Developing OpenClient/DB-Lib applications in THINK C

Hi..
     The OpenClient/DB-lib library provided by Sybase for the
Macintosh is in MPW format. I believe Sybase does not officially
support THINK C. If there are any application developers using
THINK C, I would like to hear from you.

     I am trying to do the same. I have not been successful in
converting the object file from MPW to THINK C format. I am
still new to Macintosh programming, so would appreciate any
help on converting the object file.

     Thanks,

     Ajay Surana
     Data Administration
     Arizona State University.
     (602) 965-5959
Newsgroups: comp.databases.sybase
From: francois@welchgate.welch.jhu.edu (Francois Schiettecatte)
Subject: Re: Sybase Motif Interface
Organization: Welch Medical Library
Date: Thu, 21 Jan 1993 13:12:40 GMT


In article 10558@chpc.utexas.edu, xxaj547@chpc.utexas.edu (Carmen Rusu) writes:
>Hi Sybase-ers !
>
>I am a beginner user of Sybase SQL Toolset Release 5.2. and I would like to
>run it under X11 on SunOS.
>I've set up SYBASE_TERM=xterm.sun
>
>When I run say Data Workbench I get exactly the interface you see in pictures
>in the manual "Data Workbench Guide, except that the window border is "Motif"
>style.
>
>My question is: inside my Motif window, the Sybase menus look to me like 
>"character mode" ie the Menus /, Queries, Reports, or the "buttons" like 
>functions (Data Entry !) dont have the Motif "look and feel"; is this what
>is supposed to look like ? I have set up OPENWINHOME to point where the X11
>fonts are in our system too.
>


Yes it is, however you do have control of the fonts and geometry of the 
window. Sybase does have plans for a GUI version of APT for motif
and OpenLook, but I dont know if data workbench will get converted to a
'real' GUI application.


francois


Francois Schiettecatte
Software Engineer
Advanced Technology Group
Welch Medical Library
Johns Hopkins University
Internet: francois@library.welch.jhu.edu
Phone	: (410) 955-7581



Newsgroups: comp.databases.sybase
From: gpmenos@firestone.Princeton.EDU (Gerard Philippe Menos)
Subject: how to retrieve rows > X bytes (sortof)
Originator: news@nimaster
Reply-To: gpmenos@firestone.Princeton.EDU (Gerard Philippe Menos)
Organization: Princeton University
Date: Thu, 21 Jan 1993 22:05:09 GMT

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
Newsgroups: comp.databases.sybase
From: ken@sdc.com (Ken Marks)
Subject: Serial integers in SYBASE
Keywords: NOVICE-ALERT
Organization: Systems Development Corporation
Distribution: usa
Date: Mon, 25 Jan 1993 20:30:05 GMT

Does SYBASE support serialized integers like the Serial data type
available with Informix?
-- 
Ken Marks 				 "We did not receive this earth as a 
PADI OWSI 48762       			  gift from our ancestors, but borrowed 
e-mail: ken@sdc.com  -or-		  it from out descendents."
        ...!uunet!tellab5!sdc!ken			 -African Proverb
Newsgroups: comp.databases.sybase
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: Sybase Developers Conference
Organization: Lehman Brothers
Date: Tue, 26 Jan 1993 22:47:14 GMT

In article <1993Jan26.031741.8515@manitou.cse.dnd.ca> pburry@manitou.cse.dnd.ca (Paul Burry) writes:

>   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
       ^^^^^
       APRIL

>   SYBASE but have only got the run-around.

1-800-767-2336

FAX
1-508-470-0526
--
warren finnerty      | 388 Greenwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com
From: ken@oscar.welch.jhu.edu (Ken Fasman)
Subject: Re: Recursive Triggers ?
Followup-To: comp.databases.sybase
Summary: No, sorry
Keywords: triggers
Organization: Genome Data Base, Johns Hopkins University
Date: Fri, 22 Jan 1993 02:56:50 GMT

In article <1jh22bINNmhn@meaddata.meaddata.com> hth@meaddata.com (Hirendra Hindocha) writes:
>I have a hierarchical database structure.  What I wanted to do was - 
>an insert,update or a delete in a table should fire off a trigger which 
>would perform some calculations for the hierarchy above the inserted one.
>i.e a change affecting a child should start off a trigger , which would
>then update the parent in the same table.  Now since this is again an
>update, this should again start off the trigger to update the parent's 
>parent and so on , till it reaches the top of the tree.
>
>Is it possible to do this ?  If it is , please let me know how ?
>I tried a trigger , but that seems to be updating , only one level up.
>It does not propagate all the way up the hierarchy as I expected.  

Sybase triggers cannot accomodate recursive operations, since they will not 
fire more than once on the same insert/update/delete.  You must figure out 
a way to accomplish the same task programmatically in one pass of the 
trigger.

Triggers on one table can cause triggers on other tables to fire, if the 
nested triggers configuration variable is set to 1.  They can also invoke 
stored procedures.  The total number of trigger and stored procedure calls 
on the stack (the "nesting level") must not exceed 16.

Ken Fasman,
Genome Data Base
Johns Hopkins University School of Medicine
2024 E. Monument St.
Baltimore MD  21205

ken@library.welch.jhu.edu
From: robert@sybase.com (Robert Garvey)
Newsgroups: comp.databases.sybase
Subject: Re: Right Justify Char strings
Keywords: right justification, char data, functions
Date: 19 Jan 93 23:19:26 GMT
Organization: The Upstate Sadistics

In article <Dave_Wetzel-140193110749@dwetzel.mis.stratus.com>, Dave_Wetzel@vos.stratus.com (David Wetzel) writes:
|> Okay, it may be brain-damage, but can anyone tell me how to right justify a
|> character string with Sybase (4.8).  There's got to be an easy way,
|> right??

There is a way.  Its ease is a matter of opinion.  Using the functions
that are part of Transact-SQL will allow you to do it, like this:

1> SELECT
2>  col1 = CONVERT( varchar(8),
3>       REPLICATE(" ", COL_LENGTH("test", "col1") - DATALENGTH(col1))
4>       + col1 ),
5>  col2 = convert( varchar(8),
6>       REPLICATE(" ", COL_LENGTH("test", "col2") - DATALENGTH(RTRIM(col2)))
7>       + rtrim(col2) )
8> FROM test
9> go

 col1     col2     
 -------- -------- 
        1        1 
       22       22 
      333      333 
     4444     4444 
    55555    55555 
   666666   666666 
  7777777  7777777 
 88888888 88888888 
 
(8 rows affected)

Both col1 and col2 are eight character columns.  The col1 column is
varchar(8).  The rtrim string function is needed for col2 because it is
char(8), so every value is the full eight characters.  There are
probably other ways to accomplish this same result.

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

If Sybase were to pay employees for their opinions, they couldn't afford me.
Newsgroups: comp.databases.sybase
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: Sybase 4.9.1 Returns the Wrong Rows
Organization: Lehman Brothers
Date: Thu, 21 Jan 1993 04:19:14 GMT

>In article <1993Jan19.134419.27020@eplrx7.es.duPont.com> hanafey@eplrx7.es.dupont.com (Mike Hanafey) writes:

>    Sybase returns the wrong result for the following simple query:
>
>	   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)
>
>   Given the tables below, the correct result should be zero rows selected:

	
   [ tables deleted ]

   This type of query *DOES* work in 4.0.1. 
   First make sure you have the latest 4.9.1 EBF.
   Second add a "group by b.c1" to the subquery that might well fix it.


>  Sybase also returns incorrect results for a query with a "group by" that includes
>  the Transact-SQL extension that not every column in the select list must be an
>  aggregate, or a grouped by column:
>
>	   1> select b.c1,b.c2,a.c1,count(a.c2) from a,b where a.c1=b.c1 group by a.c1
>	   2> go
>	   c1          c2          c1                      
>	   ----------- ----------- ----------- ----------- 
>		    1           0           1           3 
>		    2           0           1           3 
>		    3           0           1           3 
>		    1           0           2           3 
>		    2           0           2           3 
>		    3           0           2           3 
>	   (6 rows affected)
>
>   The first column here contains "3", a curious result considering that this column was
>   equi-joined to the third column, which has no "3". Here are the input tables:
>
>	   1> select * from b
>	   2> go
>	   c1          c2          
>	   ----------- ----------- 
>		     1           0 
>		     2           0 
>		     3           0 
>	   (3 rows affected)
>
>	   1> select * from a
>	   2> go
>	    c1          c2          
>	    ----------- ----------- 
>		    1           1 
>		    1           2 
>		    1           3 
>		    2           1 
>		    2           1 
>		    2           1 
>	   (6 rows affected)

Answer: Include all the non-aggr cols in the select list in the "GROUP BY"
        or use COMPUTE.

        Despite documentation to the contrary, attempts to do otherwise
        ( esp. with joins ) result in BUG-city.


>   Mike Hanafey
>   Dupont Experimental Station
>   hanafey@suncity.es.dupont.com
>   -- 

Good luck.
--
warren finnerty      | 388 Greenwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com