HDTenEightyP/NetNews huggingface dataset:
From: brad@hawk.adied.oz.au (Bradley Edelman)
Subject: Secure databases
Keywords: Secure CMW
Organization: Australian Defence Industries
Date: Thu, 28 Jan 1993 00:22:32 GMT

What databases are Multi-Level Secure (MLS) and run on CMW?  I know there is 
Trusted Oracle, Secure Ingres and Informix-OnLine/Secure that are supposed to 
be MLS, but do they run on Sun CMW?

Brad. [brad@hawk.adied.oz.au]
Australian Defence Industries Ltd,
Enterprise Unit 3, Technology Park,
Bentley, WA 6102, Australia.
Tel: (09) 333 8888.  Fax: (09) 333 8889.
From: johnboyd@ocdis01.oc.aflc.af.mil (John Boyd)
Newsgroups: comp.databases
Subject: ANSI moves forth on XBase standard
Date: 26 Jan 93 20:33:01 GMT
Organization: Tinker Air Force Base, Oklahoma

Printed without permission from Infoworld, January 25, 1993
==========================================================================
by Doug Barney

A misunderstanding that had slowed the American National Standards
Institute's (ANSI) effort to create a standard, open XBase language has
been resolved.  Participating vendors, including Borland International
Inc., had been told they would lose copyright protection on materials
submitted to the committee -- which brought sumbissions to a halt.
	ANSI now says companies retain the rights to materials they submit.
As a result, Borland has agreed to submit its dBase Language Reference
Manual, which may be used as a "base document" that defines the XBase
standard.
----------------------------------------------------------------------------
Two wrongs don't make a right, but three lefts do..
Disclaimer: My opinion represents only me, and sometimes not even that.
Newsgroups: comp.databases
From: timmer@fwi.uva.nl (Ralf Timmer (I89))
Subject: Re: What is an OODBMS?
Organization: FWI, University of Amsterdam
Date: Fri, 22 Jan 1993 10:49:18 GMT

In article <1993Jan21.152154.25684@let.rug.nl> welling@let.rug.nl (George Welling) writes:
>In article <1993Jan21.120320.5992@fwi.uva.nl> timmer@fwi.uva.nl (Ralf Timmer (I89)) writes:
>>Hi,
>>
>>My question is in the subject!
>>
>>-- 
>>Ralf Timmer                                     Department of Computer Science
>>Email: timmer@fwi.uva.nl                        University of Amsterdam
>>--
>Object Oriented Database Management System.
>             =                         =                           =
>          ___|_____                 ___|_____                   ___|_____
>         /         __|____         /         __|____           /        __|____
>      _|__        /      /     _|__         /      /      _|__         /      /
>    /    /_______/______/     /    /_______/______/      /    /_______/______/
>   /____/    | ______|__     /____/    | ______|__      /____/    | ______|__
>______|______|_\  o o o | ______|______|_\  o o o |  ______|______|_\  o o o |
>    \  o o o o o o o o  |     \  o o o o o o o o  |      \  o o o o o o o o  |
>     \                 /       \                 /        \                 /
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>     George M. Welling - dep.Alfa-Informatica HCI - University of Groningen
>     phone : +31 50 63 54 74  | fax : +31 50 63 49 00  | welling@let.rug.nl
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I know where the letters stand for, but what are the differences to
a (normal) DBMS. (Don't say it is object-oriented!)

-- 
Ralf Timmer                                     Department of Computer Science
Email: timmer@fwi.uva.nl                        University of Amsterdam
--
Newsgroups: comp.databases
From: chanhc@iscs.nus.sg
Subject: Re: Help with SQL statement
Reply-To: CHANHC@NUSDISCS.BITNET
Organization: Dept. of Information Systems and Computer Science, National University of Singapore
Distribution: na
Date: Tue, 26 Jan 1993 01:44:19 GMT

In article <1993Jan22.211051.4867@vpnet.chi.il.us>, mike@vpnet.chi.il.us 
(michael kamlet) 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
You need to union the normal answer with the answer from a query
that finds the customers with no orders, e.g.
	select cust_num, cust_name, order_num, order_item
	from customer, order
	where  cust_num = order.cnum
	union
	select cust_num, cust_name, '    ', '    '
	from  customer
	where not exists  (select  order_num
				from order
				where  order.cnum = cust_num)

>
From: francis_g@kosmos.wcc.govt.nz (gazza)
Newsgroups: comp.databases
Subject: Clarion users
Date: 26 Jan 1993 18:30:41 GMT
Organization: Wellington City Council (Public Access), Wgtn, Nz
Reply-To: francis_g@kosmos.wcc.govt.nz
NNTP-Posting-Host: kosmos.wcc.govt.nz

I was wondering how many folk use Clarion ?.

 And if so ho
And if so who konws any thing about the pending realise 
of the Version 3 product ?.

Gary
From: muench-philip@math.yale.edu (Philip Muench)
Newsgroups: comp.databases
Subject: Re: Help with SQL statement
Date: 23 Jan 1993 10:48:45 -0500
Organization: Yale University Mathematics Dept., New Haven, CT 06520-2155
Distribution: na
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
Newsgroups: comp.databases
From: des@helix.nih.gov (David E. Scheim)
Subject: Re: Paradox: table and index with different sort orders
Organization: NIH
Date: Fri, 22 Jan 1993 13:40:55 GMT

In article <1993Jan22.220157.181@chmeds.ac.nz> 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. 
> 
>Cheers
>Gordon
>---
>Gordon Findlay,  Computer Scientist, Christchurch School of Medicine
>                 Nuclear-free New Zealand         !System error: y
>Generic:  Gordon@CHMEDS.AC.NZ                     !hit any user to 
>JANET:    Gordon%NZ.AC.CHMEDS@UK.AC.NSFNET-RELAY  !continue.
>Paper:    PO Box 4345, Christchurch,  NEW ZEALAND !

Delete the .PX file with DOS, then go back into Paradox and restructure the 
table, starring the field(s) to be indexed.  Note: these kinds of 
corruptions, either easily recoverable as is this problem, or not 
recoverable, occur at times with all PC or network database products.  
Paradox has less frequent problems than most.  A chief advantage of client-
server systems, such as Microsoft SQL server, is that they guarantee data 
integrity and avoid such problems.  -- David Scheim

/*********************************************************************/
/*                      --- David E. Scheim ---                      */
/* BITNET: DES@NIHNEI31                                              */
/* INTERNET: desl@helix.nih.gov          PHONE: 301 496-2194         */
/* CompuServe: 73750,3305                  FAX: 301 402-1065         */
/*                                                                   */
/* DISCLAIMER: These comments are offered to share knowledge based   */
/*   upon my personal views.  They do not represent the positions    */
/*   of my employer.                                                 */
/*********************************************************************/
From: kraai4712@iscsvax.uni.edu
Newsgroups: comp.databases
Subject: Tall Order: DOS&Mac CrossDev Tools
Date: 20 Jan 93 16:43:45 -0600
Organization: University of Northern Iowa

Hello Netters!

Am looking for a database program that conforms to the following specs.:

        < $1000

        Able to generate standalone, executable code for Mac & MS DOS

        Unlimited distribution of generated code.

Please e-mail me, as I am not able to follow this group.

Thanks in advance.  --jim
Newsgroups: comp.databases
From: smj@jbecpor.demon.co.uk (Martin Jarvis)
Subject: Re: Help with SQL statement
Organization: John Brown E&C Ltd
X-Newsreader: Tin 1.1 PL4
Distribution: na
Apparently-To: mail2news@news.demon.co.uk
Date: Mon, 25 Jan 1993 17:59:08 +0000

Oh my god, dummy records !! Take it from me, any design that relies on dummy 
records is going to be more trouble than it's worth !! (No offence intended)

Yes, outer joins are what is required.

You do not state which RDBMS you are using. Oracle uses the 
following notation :

       SELECT CUSTOMER.NAME, ORDER.NUMBER
         FROM CUSTOMER, ORDER
        WHERE CUSTOMER.CUSTOMER_NO = ORDER.ORDER_NO(+)

I believe that INGRES uses the actual word OUTER in its syntax.
Xref: sparky comp.databases:9461 comp.lang.c++:19982 comp.sys.dec:7158 comp.unix.ultrix:9522
From: lilleyc@cs.man.ac.uk (Chris Lilley)
Newsgroups: comp.databases,comp.lang.c++,comp.sys.dec,comp.unix.ultrix
Subject: Re: CDA, Anyone?
Date: 26 Jan 93 20:50:14 GMT
Followup-To: comp.databases
Organization: Dept Computer Science, University of Manchester, U.K.

In article <1993Jan20.152943.21462@alf.uib.no>
iversen@vsfys1.fi.uib.no writes:

>In article <C15p85.IsM@wm.estec.esa.nl>, hevans@estwm0.wm.estec.esa.nl (Hugh D.R. Evans (ESA/ESTEC/WMA Netherlands)) writes:

>>In article <1993Jan19.153058.19842@pmafire.inel.gov>,
cdm@pmafire.inel.gov (Dale Cook) writes:

>>|>Howdy, DEC experts.  Does anyone out there actually make use of the CDA
>>|>stuff that comes with Ultrix?  Supposedly, there is a converter/viewer
>>|>for .tif files in the base system, but I can't get it to work on an
>>|>Ultrix 4.2 system.  

>>If the licensing for Ultrix is anything like that of VMS, then you will 
>>need to get the specific Tif->DDIF converter.  It doesn't come as in the 
>>standard VMS package, so we have purchased it here (just have to wait for 
>>the system manager to come back from a six week period of maternity leave 
>>before we can use it).
>>
>>On a similar topic: has anyone written a CDA converter for GIF-DDIF?

When your sys manager comes back, assuming she is installing CDA
library v2.0, you will find that GIF is also a supported type. 

The main strength of the CDA library is in text and compound document
conversions rather than image format conversions (IMHO) stuff like
wordperfect -> ODA, SGML -> Microsoft word, that sort of thing.

>Get libtiff from sgi.com and pbmplus from export.lcs.mit.edu. Then you can do
>things like this:
>
>% giftoppm test.gif > test.ppm
>% ppm2tiff -none test.ppm test.tif
>
>There is a gif2tiff in libtiff, but cdoc does not like the output and complains
>about unsupported compression type. Also I had no luck piping these commands
>together, thus the intermediary file. Note that DEC TIFF files have a strange
>date field and libtiff complains when reading them.

I thought TIFF readers were supposed to skip tags they didn't understand.

By the way does tifflib support TIFF 6.0 yet?



--
Chris Lilley
---------------------------------------------------------------------------
Technical Author, ITTI Computer Graphics and Visualisation Training Project
Computer Graphics Unit, Manchester Computing Centre, Manchester, UK
Internet:   lilley@cgu.mcc.ac.uk        Janet:   lilley@uk.ac.mcc.cgu
Voice:      +44 (0)61 275 6095          Fax:     +44 (0)61 275 6040
---------------------------------------------------------------------------
Newsgroups: comp.databases
From: thomasd@tps.COM (Thomas W. Day)
Subject: Foxpro File Crashes
Organization: Telectronics Pacing Systems
Date: Thu, 21 Jan 1993 15:05:16 GMT

I have a Fox database that lives on a server.  Occasionally, the server 
crashes (we use LANMAN, no surprise) and my database goes down with it if a 
record is being saved at the moment of the flameout.  I have found a cobbly 
way to save the database, up to the last record that was open when the 
system crashed, but I am unclear on what I'm really doing.  The following 
are the instructions I have written to myself:

   How to "bring back" a Foxpro database that was crashed
   by the network:

   The header record information can be altered to the last
   recoverable record.  The database structure information
   is located in the header (see page B-18 of the Foxpro
   Developer's Guide).  

   To step the database record back to the last complete record,
   decrement the fifth (5th) byte one record and test the database.
   The Guide says the 4th through the 7th bytes record the "number
   of records in the file," but for 10,000 record databases the 5th
   byte is the last digit.  

   Example: The database crashed leaving the following information in
   the header; F5 5C 09 1D 20 2D 00, changing 20 to 19 recovered
   the database (approximately 11k records in the database).

Here's my question, as you can see by the last paragraph, I don't have a 
clear idea of which hex bit is the least significant.  Does anyone know?

Thanks, 
Tom Day
Newsgroups: comp.databases
From: dant@microsoft.com (Dan Tyack)
Subject: Re: Information on Microsoft ODBC?
Date: 25 Jan 93 17:47:40 GMT
Organization: Microsoft Corporation

In article <138650001@hpcupt1.cup.hp.com> rlalwani@hpcupt1.cup.hp.com (Rajesh Lalwani) writes:
>Can someone please tell me if there is any book on Microsoft ODBC?
>Or can you please point me to where I can get information on ODBC?
>Thanks.
>
>-- Rajesh 

Email odbcsdk@microsoft.com and they will send you the SDK.  (Include
the usual information).  No cost.
From: cocks_d@kosmos.wcc.govt.nz
Newsgroups: comp.databases
Subject: Re: dBase 4v1.1:can I change directories on the fly?
Date: 26 Jan 1993 21:14:32 GMT
Organization: Wellington City Council (Public Access), Wgtn, Nz
Reply-To: cocks_d@kosmos.wcc.govt.nz
NNTP-Posting-Host: kosmos.wcc.govt.nz

In article <1993Jan26.163333.21242@bmers145.bnr.ca>, jfile@bmers3.bnr.ca (Jonathan File) writes:
>
>Does anyone have any suggestions on how to:
>- get two version of dbase running in a windows environment with share.exe
>  running? or,
>- change directories once I am in a dbase session?, or
>- something else that will get me out of this pickle?

I suggest to compile your code with Clipper or some other compiler and switch 
between 2 executable files.

Use the SET DEFAULT TO command to switch directories. This hasn't always worked
in the past so I shell to DOS with  DO CD \ New Directory.

I hope this helps.

Regards, Derryl.

________________________________________________________________________________
Mail: 	Derryl Cocks, Analyst/Programmer
	New Zealand Fire Service, PO Box 2133
	Wellington, New Zealand
Phone:	(4)4724969  Fax: (4)4781603  International: +64 4 47.... 
Email:	"cocks_d@kosmos.wcc.govt.nz"
________________________________________________________________________________
From: fakhouri@INRS-Telecom.UQuebec.CA (Elie Fakhouri)
Newsgroups: comp.databases
Subject: For Sale, PARADOX 4.0
Date: 22 Jan 93 15:58:32 GMT
Distribution: usa
Organization: INRS Telecommunications

I have a brand new Paradox 4.0 Package, 
Asking Price : $400 (or pls make me an offer)

EMF
-- 
============================================================================
Elie Michel Fakhouri
INRS-Telecommunications, Verdun , Quebec
E-Mail  : fakhouri@inrs-telecom.uquebec.ca
From: tio_on@tac.fi (Ossi Numminen)
Newsgroups: comp.databases.ingres
Subject: Ingres + Postgres?
Date: 22 Jan 93 09:34:50 +0200
Organization: City of Tampere


In Datamation (Nov 1, 1992), Mark Hanner, director of product
planning at Ingres, was told to have said that future releases
of the Ingres DBMS, beginning with next year, will incorporate
_the Postgres work_, plus ...

Can anybody tell something more on this? Is _the whole Postgres_
really going to be included in Ingres?

 -- 
*******************************
Ossi Numminen
City of Tampere
Dept. of Information Technology
P.O. Box 87
SF-33211 Tampere, Finland
e-mail: tio_on@tac.fi
fax:_-358-31-196044

Newsgroups: comp.databases.ingres
From: lung@venice.sedd.trw.com (Diane Lung)
Subject: W4GL 2.0 problem...nested tablefields.
Organization: TRW Systems Engineering & Development Division, Carson, CA
Date: Thu, 28 Jan 1993 16:32:25 GMT

We are running W4GL 2.0/01(su4.u42/00) with Ingres 6.4/02 (su4.u42/00)
and are experiencing different execution in part of an application which 
worked correctly under W4GL versions 1.0 and 1.1.

We have an "outer" tablefield which has one column, a tablefield ("inner").
The inner table has two columns, a radiofield (with 2 selections) and an 
entryfield (varchar 20). Based on CurMode passed in to the frame, the columns 
of the inner table are modifiable or read-only.

The problem is, in version 2.0 the entryfield (inner tablefield) cannot be 
modified at all (for any Mode/Bias settings) unless the Append (minimally) row 
operation is allowed on either the inner tablefield or the outer tablefield. 
When Append is allowed for the inner tablefield, we can only modify the first 
row (of the current scroll region) of the entryfield column (plus obviously, 
now rows automatically get appended).

When Append is allowed for the outer table, execution is close to what we
had under 1.0 and 1.1, except now additional rows (inner tablefields)
automatically get appended (not what we want).

The radiofield works fine. We added other widgets for columns on the inner
tablefield. All worked properly. The entryfield just doesn't want to work
right without having some of the row operations enabled.

Has anyone experienced this difficulty or know of a fix?

Thanks for any insight.

	Howie.


**********************************************************
Internet:    howie%ranger@venice.sedd.trw.com
Prodigy :    DBKX34A

All opinions are my own and not my employer's.
**********************************************************
-- 
lung@venice.SEDD.TRW.COM
Newsgroups: comp.databases.ingres
From: rayt@rtsl.demon.co.uk (Ray Turner)
Subject: Re: Windows/4GL with other DBMSes via SequeLink?? 
Distribution: world
Organization: Ray Turner Systems Ltd
Reply-To: rayt@rtsl.demon.co.uk
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.19)
Date: Sat, 23 Jan 1993 13:51:31 +0000

In article <1993Jan22.105235.7086@dcatlas.dot.gov> sethg@dcatlas.dot.gov writes:

>A short item in a French Ingres newsletter says that Ingres has teamed
>with TechGnosis (which, I believe, is in the process of being acquired
>by another company although I forget which one) to make any DBMS
>accessible through SequeLink -- i.e., any major RDBMS -- useable from
>Ingres Windows/4GL.  Anyone out there know anything about this?  
>
>                        Seth, grimes@oecd.fr 
>
>
>

	There are a number of products that do this, SequelLink is one
	which I have looked at, the other is QELIB from Pioneer Software
	and SQL Retriever from Visionware. However at present these are
	only available for use with the DOS/W3 version of W4GL. In truth
	they are simply DLLs that can be called from any Windows 3 
	application, and hence from W4GL/DOS. Several versions are
	available for different backend servers, including Dbase!

	All the DLL procedures need to be defined to W4GL and they arn't
	really that well integrated, although SequelLink is perhaps the
	best.

	You still need an Ingres server for development though.

	I am also not sure of the Ingres support issues when you call
	third party routines. I had quite a few problems with General
	Protection violations, there is little help with parameter
	validation passed to external routines.

	I think SequeLink may provide a set of unix callable routines
	in the future.

Ray.
-- 
--------------------------------------------------------------------------
Ray Turner                               Internet  : rayt@rtsl.demon.co.uk
Ray Turner Systems Ltd,                  Compuserve: 100016,160
Leatherhead, Surrey KT22 9NS England.    
--------------------------------------------------------------------------
Newsgroups: comp.databases.ingres
From: jwt@ulysses.att.com (Wen-Hu Tseng)
Subject: Need help on Ingres
Date: Tue, 26 Jan 1993 07:06:39 GMT
Organization: AT&T Bell Laboratories, Murray Hill


Our Ingres DBA is on vacation, and we are not able to find him
at this moment, we got into a very deep trouble,

this is the message we got when we try to run sql:

INGRES TERMINAL MONITOR -- Copyright (c) 1981, 1992 Ingres Corporation
E_US0026 Database is inconsistent. please contact the
    ingres system manager
    (Tue Jan 26 01:21:59 1993)

it's a very common problem, it happens like once a month,
usually he can solve the problem in 10 mins, but we really
don't have anybody here know how to do it.
we try to shutdown ingres and restart it, didn't work,
is anybody out there can help us?

Thanks for any help

Jim Tseng

--
Jim Tseng
jwt@ulysses.att.com
Newsgroups: comp.databases.ingres
From: thomasl@mtl.mit.edu (Thomas J Lohman)
Subject: Ingres error handling
Organization: MIT Microsystems Technology Laboratories
Date: Tue, 26 Jan 1993 19:44:22 GMT

I am having some difficulty unearthing all of the different ways
you can trap Ingres EQUEL/ESQL errors for the C language.

I will try to summarize my thoughts and would like people to tell me
how they think it works (I am most likely wrong anyhow).

Ways to capture/get errors in EQUEL
-----------------------------------

(1) Use the IIseterr function to define an error handler which will be
    called by Ingres if there is an Ingres error.

(2) Issue the inquire_ingres (inquire_equel) command to find out the 
    error number and deal with it.  This option would have to be used
    in a case by case basis.

Now, my question is, will option (2) suppress msgs going to stdout, unless
I explicitly tell it to output error messages?

Ways to capture/get errors in ESQL
-----------------------------------

(1) Declare the SQLCA structure, and check the sqlcode member in a case
    by case basis.

(2) Declare the SQLCA structure and use the "whenever" statement deal with
    warnings, or errors.  This also enables you to call your a user
    defined function, and it is only valid for the SQL statements which follow
    it's definition inside the source module.

(3) Define an error trapping routine which can then be set using the 
    set_sql command. I think that the SQLCA shouldn't be defined.

(4) You can use the inquire_sql statement to find out the error, although
    it does say this does not suppress messages to the screen.

(5) You can use the IIseterr function, like above.


SQL seems to have more variety but the documentation doesn't really 
do a great job of defining what you can do.  It seems that under ESQL,
option (1) should really be used as well as option (2).  Option (3)
seems to the equivalent of (5) which seems to be the equivalent of 
EQUEL's option (1).

I would like to know what I've screwed up in the above ramblings, and 
I'd be interested in knowing how people handle error checking in 
ESQL especially for C.

thanks,


--tom



Newsgroups: comp.databases.ingres