HDTenEightyP/NetNews huggingface dataset:
From: rys@apelc8.inf.ethz.ch (Michael Rys)
Subject: CfP: The VLDB Journal: Special Issue on Spatial Database Systems
Followup-To: comp.databases
Organization: Dept. Informatik, Swiss Federal Institute of Technology (ETH), Zurich, CH
Date: Fri, 2 Oct 1992 10:22:11 GMT


                        Call for Papers

    The VLDB Journal: Special Issue on Spatial Database Systems

The VLDB Journal is planning a special issue on Spatial Database 
Systems, which provide the underlying database technology for 
geographic information systems and other applications dealing with 
large collections of geometric data. Topics of interest include, but 
are not limited to, the following:

   * Spatial data models and query languages and their realization
   * Spatial data types: definition and implementation
   * Support for networks (highways etc.)
   * Maintaining geometric consistency of related spatial objects
   * Correct finite resolution implementation of spatial types and 
     operations
   * Spatial access structures and geometric algorithms
   * Query processing in spatial DBMS
   * Cost modeling and optimization for query processing with spatial
     data
   * Extensibility in spatial DBMS
   * Coupling external spatial computation services with extensible 
     database systems
   * Object-oriented and deductive techniques for spatial DBMS
   * User interfaces and UI construction tools for spatial DBMS
   * Graphical query languages
   * Map generation from spatial databases

Potential authors are encouraged to submit original, journal quality 
papers to the special issue editor:

     Ralf Hartmut Gueting           Fax: +49 2331 31794
     Praktische Informatik IV       E-Mail: gueting@fernuni-hagen.de
     Fernuniversitaet Hagen
     Postfach 940
     D-5800 Hagen
     GERMANY

Send 6 copies of a complete manuscript of no more than 35 type-
written, double-spaced pages. For more specific information see the 
Guidelines for Manuscript Preparation of the VLDB Journal which can be 
obtained through the special issue editor or the responsible editor-in-chief
Hans-J. Schek (schek@inf.ethz.ch). All papers will be reviewed through the
Journal's editorial board. Important dates:

     July 1, 1993                Due date for manuscript
     November 1, 1993            Notification of acceptance
     January 1, 1994             Due date for final version

A preliminary statement of your intention to submit a paper will be 
appreciated.

Newsgroups: comp.databases
From: weiss@cs.wm.edu (David W. Weiss)
Subject: dBASE problem
Organization: The College of William and Mary
Distribution: na
Date: Sat, 3 Oct 1992 12:51:49 GMT

Previously I posted this question.

> I have a single-user copy of dBASE which I have been trying
> to use.  Because there is no room on my hard disk I have tried to
> install it on a network drive (TCP/IP network using PC-NFS).  
> Installed on this drive any attempt at using or creating forms
> results in the error message "Too many files are open".  Does
> anyone know why this is happening and/or how to fix it.  The
> config.sys file is set to FILES=99 and the dbase default 99 
> files allowed is being used.

And thanks to some help I found out the problem is PC-NFS is not 
allowing enough files to be opened on the network.  And the answer
is to put a /f99 option on the PCNFS.SYS command that runs in 
config.sys on the PC.

Many thanks for the help.

Dave







Newsgroups: comp.databases
From: gregb@murphy.com (Greg Banschbach (Unigroup of New York))
Subject: Re: help! info. on public domain DBMS
Organization: Murphy & Durieu, NYC NY, USA
Date: Wed, 30 Sep 1992 00:11:04 GMT

In article <43036@ogicse.ogi.edu> yongyan@ese.ese.ogi.edu (Yongyan Wang) writes:
>
>
>I would like to know if there is public domain DBMS?
>If there is, what is the name and how can I get them?
>
>Thanks 
>-Yongyan
 	If you are on System 5 rel4, but preferrably on SUN's or 
	DEC's running ULTRIX, you can FTP, or beg a copy of 
	Postgres from  postgres.berkeley.edu

	Of course if FTP is not available, I have an OLDER version. 
	If you are a reasonably talented C programmer this will 
	do you service.

	If not,  I recommend getting your hands on something more
	commercial.  


	GOOD LUCK,  

	Greg (   gregb@murphy.com  )  


Newsgroups: comp.databases
From: mikes@ars2.uucp (Mike Schlosser)
Subject: Re: A Clipper 5.01 question
Organization: Automated Retail Systems, Seattle, Wa
Date: Mon, 28 Sep 1992 20:59:40 GMT

In <Bv55rE.521@usenet.ucs.indiana.edu> tcheng@bronze.ucs.indiana.edu (Tony C. Cheng) writes:


>Hi, I am a Clipper novice.  Hope someone can help me in the following question.
>I have two functions and one procedure in a small program listed as following,
>GetUnique() will scan for unique elements in a database field and return those 
>elements in an array, ACHOICE() of course will return the element I selected,
>and TestFilter() is supposed to pass a database filename, a field index and
>the selected element for filtering and browing.  The problem I had is,  
>in TestFilter(), "SET FILTER TO..." will work only when I hardcoded 
>a string for comparison in this way:

>		SET FILTER TO &kidx="AB"

>If I used a variable, such as in:

>		SET FILTER TO &kidx=kword

>Then I'd get this error message:

>---------------------------------- MAKEARY.PRG is my program name
>Compiling MAKEARY.PRG
>MAKEARY.PRG(39)    Error C2050  Code block contains both macro and declared symb
>ol references
>1 error

stuff deleted

Try this.

Make your macro equal to your entire filter statment.

	mfilter = field(pos) + " = '" + kword + "'"
	SET FILTER TO &mfilter

If this don't work, I bet its darn close. You may need to reverse the " and '.
Let me know what happens. I often wonder if my suggestions/postings are
making it out of the building.

-- 
  Mike Schlosser <mikes@ars2.UUCP> |Voice:(206)325-8922| AI: The Art Of Making
  Automated Retail Sys., Seattle   |FAX  :(206)325-9127|     Computers As 
  R & D,  Programmer/Analyst       |Standard Disclaimer|     Stupid As Humans.
Newsgroups: comp.databases
From: jbennett@netcom.com (Joseph Bennett)
Subject: Data Admin and DP
Date: Mon, 28 Sep 92 20:37:32 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 

I would appreciate hearing from other organizations regarding a dilemna that
my organization is having.  We are trying to work on where Data Administration
would fit within our org.  We have an established DP group using Oracle and
their CASE tools (please don't look down on use for this and no flames
please).  We are trying to determine whether Data Administration would better
serve us as an integrated part of DP or as a separate entity, outside of DP
control.

If you would like to share with me what your org has done with Data 
Administration (good or bad), I would really appreciate it.  If there is
enough interest, I will post a summary.

Thanks in advance.....please e-mail responses to jbennett@netcom.com ....


-- 
------------------------------------------------------------------------------
*         Joseph Bennett, I can be reached at jbennett@netcom.COM            *
*           Netcom - Online Communication Services San Jose, CA              *
*                                                                            *
* "I have a fear of letting my mind wander, I'm afraid it won't come back"   *
*                "I don't do drugs, I don't have the time."                  *
------------------------------------------------------------------------------
Newsgroups: comp.databases.informix
From: thomasr@cpqhou.compaq.com (Thomas Rush)
Subject: Re: RowID Question (Part 2)
Reply-To: thomasr@cpqhou.UUCP (Thomas Rush)
Organization: Compaq Computer Corporation
Distribution: usa
Date: Tue, 29 Sep 92 20:21:25 GMT

In article <3888@copper.Denver.Colorado.EDU> klonz@copper.denver.colorado.edu (K Lonz) writes:
>Once again, my apologies to the veterans!
>
>Many thanks to the varied responses I got, the most reasonable 
>of which was that rowids are not sequential at all and don't 
>necessarily start with 1.  They are probably created by using 
>a memory paging scheme.
>
>
>Therefore, my simple question may not be so simple:
>
>	The current system uses SE. We are converting to Online 4.1.
>	Both systems run on an Amdahl on a Unix kernel.  I don't
>	know the rev number of the kernel.
>
>	We are 'enhancing' the system to use joins on Online. Some
>	tables will be modified to use joins to other tables instead 
>	of keeping the same data in two different places.
>
>	However, we need to compare records before and after the
>	enhancements to show all data was retained using the joins.
>
>	We need some mechanism to correlate records before and after.
>	Originally, we thought we may be able to use rowids, but that 
>	assumption appears to be bogus.
>
>	Does anyone have any suggestions on how to correlate
>	records before and after an 'unload' and a 'load'?
>
>
>Again, thank you in advance for any responses!
>
>
>							klonz


I think that what you want to be cdone can be done.  Here's
some pseudocode:
	
	alter table tab adding column id of type int;

	insert into tab(id) 
		select rowid from tab;
	
	alter table tab, modify id to type serial;

	create unique index ix on tab(id);

	unload tab from old_db;
	load tab into new_db;


This gives you the tie between old and new databases, but requires
you modify inserts to have a 0 in the id column (this triggers an
insert of the next serial value).

Sorry, no manual handy, syntax stinks!



thomas rush				uunet!cpqhou!thomasr
compaq computer corporation		their employee,
deep in the hearth of texas		not their opinions.
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Unknown error message
Date: 1 Oct 92 16:03:25 GMT
Organization: Informix Software, Inc.

In article <9670@emory.mathcs.emory.edu> kristen.m.altman@ccd.harris.com (Kristen Altman) writes:
>Informix'ers
>
>When I try to bring up Informix during system initialization
>I get the message "Unknown error message number '32766'".  Now
>this message has also come up during regular operation. 
>The only way I've found to get rid of it is to bring Informix
>Offline and then Online.  

This is most often caused by not having your INFORMIXDIR environment
variable set. If you encounter it after a system reboot, trying to bring
OnLine up as part of the boot process, it is likely because you did not
set INFORMIXDIR (or didn't export it) in the command file before calling
tbinit.

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
The heart and the mind on a parallel course, never the two shall meet.
						-E. Saliers
From: dksl2vq@mt2.BELL-ATL.COM (Rory Martin)
Newsgroups: comp.databases.informix
Subject: Re: Error code 459
Date: 30 Sep 92 13:43:12 GMT
Reply-To: dksl2vq@mt2.BELL-ATL.COM (Rory Martin)
X-Informix-List-ID: <list.1496>

> 
> We got a -459 in one of our test domains, but the error code section of
> the manual skips from -456 to -461.  Does anyone know what a 459 is?
> 

-459    INFORMIX-OnLine was shut down.

The instance of INFORMIX-OnLine that your application was using
has been shut down by its operator. Your current transaction will be
rolled back automatically when the database engine starts up again.
Rerun the application at that time.


-- 
Rory Martin                        Internet:  dksl2vq@bell-atl.com
Bell Atlantic Network Services     
2221-L Broadbirch Drive            Voice:  1+ (301) 989-5075
Silver Spring, MD 20904-1985       "No matter where you go, there you are."
---------------------------------------------------------------------------
From: ijk@cbnewsh.cb.att.com (ihor.j.kinal)
Newsgroups: comp.databases.informix
Subject: Fix to back-end growth
Keywords: open/close of prepared cursor.
Date: 5 Oct 92 14:56:47 GMT
Organization: AT&T

Recently, I posted an article about the backend [sqlturbos]
growing in Online 4.10 UE1 and UE3P1.

Further investigation showed one specific case to be where
we had a cursor that had been prepared once [the specific
query was a join between two tables].  After about 50 open/closes,
we discovered steady growth in our backends.  

This problem was reproduced even on the stores db, so I'm surprised
that more people haven't come across this problem.

After sending a test program to Informix support, we have received
a fix to bug # 14071 in release 4.10 UE4P1.


Thanks to Informix for fixing the problem so quickly.
Further details upon request.

Ihor Kinal
att!cbnewsh!ijk [netnews]
att!trumpet!ijk	[real home].
From: jim@tiamat.fsc.com ( IT Manager)
Newsgroups: comp.databases.informix
Subject: SQL statement comparison
Date: 30 Sep 92 15:52:56 GMT
Organization: Ahlstrom Filtration - Chattanooga,TN

I was wondering just how "equivalent" the following two SQL statements
are?  E.g. I pretty sure they would produce the same results (I've only
actually used the first one), but I wonder if one is "more right" than the
other, or which one should be "faster".  We're using the SE on an HP 9000/835
at version 4.00 (or perhaps higher, but definitely not 5.0).

Thanks.

Statement 1:
unload to "finished.ul" select * from finished
	where finished.lot_no in
	(select lot_no from lot_info where lot_date <= "093091");

Statement 2:
unload to "finished.ul" select finished.* from finished, lot_info
	where finished.lot_no = lot_info.lot_no and
		lot_info.lot_date <= "093091";

Since I started out with Informix 3.3 (which did not have all the features
of SQL's select statement), I tend to fall back on things like Statement 2
becaause they "fell more familiar", but I have a feeling that statement 1
is probably the better way to do what I want.
------------- 
James B. O'Connor                                     jim@tiamat.fsc.com
Information Technology Manager                        voice 615/821-4022 x651
Ahlstrom Filtration, Inc.                             fax   615/821-0616
=========
	"Anyone who is capable of getting themselves made President,
	 should, on no account, be allowed to do the job."
	 Douglas Adams, _The Restaurant at the End of the Universe_
Newsgroups: comp.databases.informix
From: weik@PrakInf.TH-Ilmenau.DE (Weik)
Subject: Re: importing images
Reply-To: weik@PrakInf.TH-Ilmenau.DE (Weik)
Organization: Technische Hochschule Ilmenau
Date: Tue, 06 Oct 92 13:39:59 GMT

In article <9665@emory.mathcs.emory.edu>, dccrjc9@bpats (David Stockel) writes:
|> > Instead of storing these huge amounts of data inefficiently in the database,
|> >why not store the address (pathname) in the database and keep your GIF/RASTER file as an operating system  file. This will improve performance.
|> >If the picture has to be swapped out with another all u have to do is 
|> >update the  pathname and you are ready to go. 
|> 
|> Inefficently? Is there some serious problem that I haven't heard about?
|> Last year, I converted a system that was using UNIX files to BLOBs.
|> There were no BLOB related performace complaints that I heard about.
|> 
|> The conversion also solved some nagging problems with UNIX file
|> permissions and ownership. Handing a file off to another user was a
|> real messy process. This was greatly simplified by storing the data
|> rather than the path.
|> 
|> Using BLOBs also simplifies backups. All the data is on the same tape.
The most crucial point IMHO is that by using BLOBs you can fully benefit
from the DB inherent security mechanisms (transactions, noone can accidentially
delete your files via "rm -r ...", you can grant read/write priviledges to
other users, ... Thats what DBS are made for!!)

-- 
Thomas Weik
TH Ilmenau
Germany


   There is a theory which states that if ever anyone discovers
   exactly what the Universe is for and why it is here, it will
   instantly disappear and be replaced by something even more
   bizarre and inexplicable.

   There is another which states that this has already happened.

Douglas Adams: The Restaurant at the End of the Universe
From: johnl@obelix.informix.com (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re: Rowid Question
Date: 28 Sep 92 17:18:04 GMT
Article-I.D.: emory.9635
Reply-To: johnl@obelix.informix.com (Jonathan Leffler)
X-Informix-List-ID: <list.1485>

Exhibit A:
>From: uunet!copper.denver.colorado.edu!klonz (K Lonz)
>Subject: Rowid Question
>Date: 26 Sep 92 16:11:09 GMT
>X-Informix-List-Id: <news.1885>
>
>   If you 'load' a new table from a previously 'unloaded' file
>are the rowids always reassigned sequentially starting with 1? (i.e.,
>each added record will have rowid numbers 1,2,3,4,...,n).

Exhibit B:
>From: uunet!mt2.BELL-ATL.COM!dksl2vq (Rory Martin)
>Subject: Re: Rowid Question
>Date: Sun, 27 Sep 92 20:27:49 EDT
>X-Informix-List-Id: <list.1483>
>
>> ...
>
>The simple answer is...yes.  Rowids are simply physical positions within
>the table.  They have no other relationship with a record.  They are also
>reassigned within the same table if a record has been deleted and another
>inserted.

The simple answer isn't as simple as that -- it depends!

If you are using OnLine, the rowid consists of a page number and a slot number
and the lowest value will be something like 0x201.

If you are using SE, and if you never deleted anything from the table,
and if you inserted the data in the order in which it is unloaded, and you drop
the table and build a new one from scratch, then you will normally find that
the rowids are indeed in sequence.  If any of these conditions isn't met,
all bets are off.

You should only use rowid transiently -- it should never be relied on from a
run of one program to the next run of the same program, or any run of any
other program.  It may not even be safe to rely on it within a single program.
Consider the scenario:

ProgramA                                ProgramB
SELECT Rowid FROM TableA
   WHERE Column01 = "Value";
-- engine returns rowid = 23
                                        DELETE FROM TableA
                                            WHERE Column01 = "Value";
                                        -- deletes row including rowid 23
                                        INSERT INTO TableA
                                            VALUES ("Something-Else", ...);
                                        -- inserts new row with rowid 23
UPDATE TableA
   SET Column01 = "New-Value"
   WHERE Rowid = 23;
-- Oh dear; this isn't the row you thought it was because the SELECT was
-- not a SELECT FOR UPDATE.  Tut, tut.  You shouldn't use ROWID unless you
-- know it can't change behind the scenes!

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: johnl@obelix.informix.com (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  Informix bugs
Date: 28 Sep 92 18:38:08 GMT
Reply-To: johnl@obelix.informix.com (Jonathan Leffler)
X-Informix-List-ID: <list.1487>


}From: uunet!cix.compulink.co.uk!shemminga (Stuart Hemming)
}Subject: Informix bugs (Was ROWID bug i
}Date: 23 Sep 92 16:10:18 GMT
}X-Informix-List-Id: <news.1870>
}
}In article <9608@emory.mathcs.emory.edu> johnl@obelix.informix.com
}(Jonathan Leffler) writes:
}
}[Stuff deleted]
}
}>>Is there a bug fix for this ROWID - GROUP BY problem and if there is, is
}>>there an anonymous ftp site that we can get the fix?
}>
}> Informix does not distribute bug fixes like that. (I'm tempted to say
}> Informix does not distribute bug fixes period -- that is not quite true,
}> but is a reasonable starting point for the discussion.)
}
}Is this simple because Informix products don't have bugs (8-)) or is
}there some other reason?

#include <disclaimer.h>

I fear it is some other reason...

I wouldn't want to have to try and handle a facility which supplied
patches for several hundred different machines, each with several versions
of the operating system, and for several versions of each of 20-odd
products.  First of all, the matrix of the possible patches doesn't bear
thinking about.  Secondly, the probablility is that someone would sooner or
later try patching their version of the software with the wrong patch.  And
making the patching process fool-proof wouldn't be easy.  And ...

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: brianc@jekyll.ucsf.EDU (Brian Colfer)
Newsgroups: comp.databases.informix
Subject: Re: ROWID Question
Date: 28 Sep 92 22:48:03 GMT
Reply-To: brianc@jekyll.ucsf.EDU (Brian Colfer)
X-Informix-List-ID: <list.1489>

On Sep 28,  4:59pm, Jonathan Leffler wrote:
} Subject: Re: Rowid Question
} 
} You should only use rowid transiently -- it should never be relied on from a
} run of one program to the next run of the same program, or any run of any
} other program.  It may not even be safe to rely on it within a single program.
} 
} Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
}-- End of excerpt from Jonathan Leffler

Jon, what do you think about setting up a serial type for any
application that relies upon ROWID.  My rational is that you should
always use explicit attributes of a relation rather than an implicit
attribute.


-- 
Brian  Colfer          | UC San Francisco        |------------------------|
                       | Dept. of Lab. Medicine  | System Administrator,  |
brianc@labmed.ucsf.edu | S.F. CA, 94143-0134 USA | Programer/Analyst      | 
BRIANC@UCSFCCA.BITNET  | PH. (415) 476-2325      |------------------------|
From: marco@felix.Sublink.Org (Marco Penengo)
Newsgroups: comp.databases.informix
Subject: HELP! Problem handling screen refresh. HELP!
Date: 29 Sep 92 16:15:49 GMT
Organization: Soft*Star s.r.l, Torino, Italy

I'm using Informix 4GL 4.10 on SCO ODT 1.1 and when I work in terminal 
emulation (xterm,vt100,vt220,....) I have a refresh problem.
I have the following stack:
	form  1 (20 rows 80 columns)
	a window containing form 2 (8 rows 78 columns) smaller then form 1

When I close form 2 and the window that contains it so that only
form 1 is visible, the screen doesn't refresh itself and from that
point the screen contains some characters of form 2 and the borders
of the window. To clean up the garbled screen I must press <Ctrl-R>.
Even doing a `clear screen' the unwanted characters remain.

If I run my program using an ANSI (SCO console), Sun or Soroc terminal
everything works OK; it breaks when using terminal emulators like
Kermit, KA9Q, Telix, FTP Telnet or an X11R5 xterm.

Here is a simple program that demostrates my problem:
  
{
database zzzzzzzz

main

open form screen1 from "yy"               # Open the 1th form
display form screen1

sleep 5
  
open window wind002 at 10,2 with form "xx"      # Open 2th window and 2th form
    attribute(border)			  #THIS BORDER REMAINS!
open form screen2 from "xx"
display form screen2
            
sleep 5 

# Close the 2th form and the 2th window -> PROBLEMS !!!!!
close form screen2 
close window wind002 

sleep 5 

# Close the 1th form and the 1th window
close form screen1
clear screen

end main
}

Am I missing something or must I suspect a bug in SCO terminal handling
libraries or in Informix?

Thanks for any suggestions.