HDTenEightyP/NetNews huggingface dataset:
From: terrya@MCES.MsState.Edu (Terry Arnsdorff)
Subject: Re: Text retrieving system
Organization: Mississippi Cooperative Extension Service
Date: Tue, 14 Apr 1992 21:22:54 GMT

In article <1992Apr14.004041.5223@vlsi.polymtl.ca> rouet@vlsi.polymtl.ca (Marc Andre Rouet) writes:

>Monday April 13 1992.


>I will be responsible for the implantation of a database server for text
>retrieval and I don't have a big knowlage of commercial products, neither
>of general dbase system nor specialised ones (I suppose that a text oriented
>system must be different from one that manages fixed lenght records).

>The system will contain 10000 documents of a few pages and will have to serve
>very few simultaneous users (under 10).

>The pages will contain text and graphics, I don't need to be able to
>retrieve a page from it's graphical information but the system must be able
>to store both so that when a document is retrieved, the graphical information
>can (optionnaly) be displayed as well.

>Althought the input process I am considering may be more in the field of
>those registered to Comp.Graphics.ImageProcessing, I hope to get
>more down to earth advices here :

>I am interested in scanning the documents, have the image processed by an
>OCR system (character recognition) so that I have the text in an ASCII file
>and the graphics in another file.

>The database system will have to store informations concerning
>the formating of the document (text and graphics), so that reconstruction of
>the original pages is possible.

>I would prefer an integrated system, althought I am prepared to interface
>several products. I hope to find commercial products that fits my needs and
>that interface well.

>Wednesday, I am supose to see a demonstration of XEROX DSR system witch is
>suppose to solve my dbase and input process problems.

>I would like to have suggestion FAST!! ( because I have to make choices by
>the end of next week) on possible solutions to my problem, some comments
>on XEROX's system, some general suggestions concerning commercial products
>in that particular field.

>                        My only limit is a budget of 130 000 $ (Canadian).

>Please also mail a copy to:       rouet@info.polymtl.ca

>                                                                                               thanks! :)

Check out Folio Views from the Folio Corporation.  (801) 375-3700.  We use 
the software and think that it's great.

Terry

.--------------------------------.---------------------------------.
|  Terry Arnsdorff               |                                 |
|  <terrya@mces.msstate.edu>     |                                 |
|  LAN Manager                   |  "When all think alike,         |
|  Mississippi Cooperative       |       No one thinks very much"  |
|    Extension Service           |             Walter Lippman      |
|  Mississippi State University  |                                 |
`--------------------------------'---------------------------------'
From: yk7m@uvacs.cs.Virginia.EDU (Young-Kuk Kim)
Newsgroups: comp.databases
Subject: Client-Server-based DBMS question
Keywords: SQL Server, API, Oracle
Date: 6 Apr 92 19:57:29 GMT
Article-I.D.: murdoch.1992Apr6.195729.20421
Organization: University of Virginia Computer Science Department

Hi, Database gurus:

I have some questions about client-server model of DBMS.
I am developing an experimental muti-user relational database management 
system, based on a single-user relational database management system.
I am going to make it a server and provide an interface to the clients.
My question is what kind of programming interface the database server
should provide for the clients.
Currently, the single-user version provides a CURSOR-based API (Application
Programming Interface) (OPEN, FETCH, PUT, GET, INSERT, UPDATE, and CLOSE).
Do you think I should (or can) provide the same interface for multi-user
version ?
How can I specify a transaction in a client program ?

Especially, I need some help from the people who have experience with
Oracle API (or other server-based commercial DBMS API). 
Oracle API seems to fit my purpose, but I don't have any document
about the system.

Thanks in advance for your reply.

--- Young-kuk Kim
    Dept. of Computer Science
    University of Virginia
 
Newsgroups: comp.databases
From: jcarter@sun419.nas.nasa.gov (John R. Carter Sr.)
Subject: Re: Public Domain DBMS on Unix???
Organization: Numerical Aerodynamic Simulation Facility NASA
Date: Wed, 15 Apr 92 18:59:28 GMT
Reply-To: jcarter@sun419.nas.nasa.gov (John R. Carter Sr.)

Charath Ram asks:
> public domain database packages that can run on Unix?

If you like Smalltalk, there's a public domain version of
Little Smalltalk available from _The C User's Group_, a magazine.
they also have a few other database packages in their listings.

------------------------------------------------------------------------------
John R. Carter, Sr.                          Programmer/Analyst - Informix DBA
Computer Sciences Corporation                jcarter@nas.nasa.gov
Numerical Aerodynamic Simulation             415/604-3662
NASA Ames Research Center, Moffett Field, CA 94035-1000   M/S 258-6
------------------------------------------------------------------------------
Newsgroups: comp.databases
From: wfinnert@larry.shearson.com (Warren Finnerty)
Subject: Re: Read Consistency
Organization: Lehman Brothers
	<1999@nlsun1.oracle.nl> <1992Apr3.234456.3310@informix.com>
Date: Mon, 6 Apr 1992 17:35:55 GMT

>In article <1992Apr3.234456.3310@informix.com> aland@informix.com (Colonel Panic) writes:

>   In article <1999@nlsun1.oracle.nl> snieuwen@nl.oracle.com (Sandor Nieuwenhuis) writes:
>   >...
>   >Oracle implements the transaction level read-consistency with the 
>   >set transaction read only statements, and, just like the statement level
>   >read consistency, NEVER uses any locks for that.
>   >
>  * Concurrency

> The Oracle RDBMS provides for concurrent access to data with locks.  Locks
> are used to achieve data consistency and integrity while allowing for the 
> maximum concurrent access to the data by an unlimited amount of users.

  BEGIN PONTIFICATION

  I think that all DBMS vendor types should make an effort not to start yammering 
  on about ANYTHING that is featured as a 'KEY' selling point against the other
  DBMS's. These items tend to be over-simplified technical sound bites designed
  to make a product seem appealing in a typical sales pitch. These are almost
  never very important features in the long run. This is esp. true when the thread
  is about a feature that is a tradeoff between concurrency and performance that
  is discussed in the abstract ( MEANINGLESS!!!!!!!!). There are theoretical 
  scenerios that will make any configuration shine/choke and all the vendors
  have customers that are able to meet their business objective with their
  product. I think more time should be devoted to getting the most out of each
  of the DBMS's.

  COMMIT PONTIFICATION  :-)
--
warren finnerty      | 388 Grennwich St.
Lehman Brothers      | NYC NY 10013
"Back off man!"      | wfinnert@shearson.com
From: mlw@gator.rn.com (Mike Willig)
Newsgroups: comp.databases
Subject: Oracle question (again)
Date: 14 Apr 92 20:05:46 GMT
Organization: The Gator Public Access Unix Site

Sorry for the repeat, I forgot to include my address
in the first posting and thought it might be helpful.

Anybody seen this before?
 
We are trying to bring oracle version 5.1.22 up
on a sun 3/160 running SunOS 3.5. Everytime that
we do an ior init we get the following...
 
ie0: spurious interrupt 
ie0: cmd not accepted
panic: iechkcca
syncing disks...
<< and a lot of other fun boot messages >> 
 
I know it looks like an ethernet problem, but we
swapped out the ethernet controller (cpu board)
and still get this. If we leave oracle down,
the 3/160 stays up and on the network just like
it sould.


Please email any response, as I don't subscribe to this
news group. Thanks in advance.

                                -Mike

                        Mike Willig
                        mlw@nstar.rn.com

--
Mike Willig
The Gator
219-289-0777/317-251-7391
internet: mlw@gator.rn.com
uucp: ..!uunet!trauma!mlw
Newsgroups: comp.databases
From: wsmith@isis.cs.du.edu (Walter Smith)
Subject: OODB questions
X-Disclaimer: Nyx is a public access Unix system run by the University
	of Denver for the Denver community.  The University has neither
	control over nor responsibility for the opinions of users.
Organization: Nyx, Public Access Unix at U. of Denver Math/CS dept.
Distribution: na
Date: Wed, 15 Apr 92 15:39:28 GMT

Greetings!

A couple of questions from a database neophyte...

What OODBs are available in UNIX (Suns)?
What OODBs are available for PCs (DOS or OS/2)?

Are OODBs the only solution for creating variable-length records (for
managing larges amounts of text)?

Any product names (commercial/shareware) or company names/numbers would be
helpful.

Please email me as I can't always access USENET at my site before the articles
expire. Thanks in advance.

Walter
wsmith@nyx.cs.du.edu
From: bemlbk@nuscc.nus.sg (Liew Beng Keat (Mr))
Newsgroups: comp.databases
Subject: oodb
Date: 7 Apr 92 06:57:13 GMT
Article-I.D.: nuscc.1992Apr7.065713.11743
Organization: National University of Singapore

Can anyone provide me with a list of oodb's currently available in the
market e.g oodb, company, address, price etc. In particular any info on
GEMSTONE. Thanks!
Newsgroups: comp.databases
Subject: RDBMS Opinions Wanted
From: luther_b@eis.dofasco.ca
Date: 6 Apr 92 16:06:43 GMT
Organization: Dofasco Inc, Hamilton, Ont. Can.
Nntp-Posting-User: luther_b

We are currently looking at RDBMS systems to try to 'standardize' on one vendor
which will support VMS, UNIX, OS/2, DOS (clients) environments. I'm looking for
opinions on the 'biggies' (SYBASE, INGRES, ORACLE, Rdb) with regard to the
products. Maybe a ranking of these ones in order of preference given that we
have a mixture of on-line (real-time process control) and decision support
applications in search of an RDBMS. We have SYBASE, INGRES, and Rdb in-house
but each group using these products has a soft-spot for them, making it hard
to get them to really look at the other RDBMSes. It would be nice to hear from 
others who have investigated these products and come to some conclusion on 
which is more appropriate for specific environments. Are we wrong in thinking 
that one will do? All opinions appreciated...

Please respond via e-mail.

Thanks,
Brian

-- 
/------------------------------------------------------------------------------\
| Brian Luther                                   Dofasco Inc.                  |
| (luther_b@eis.dofasco.ca)                      IAS - Beach Rd.               |
| (416)548-4610                                  1330 Burlington St. E.        |
|                                                Hamilton, Ont. L8N 3J5 Canada |
\------------------------------------------------------------------------------/
 \        The opinions expressed on USENET are mine, and mine alone.          /
  \                  I do not speak for DOFASCO Inc.                         /
   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
From: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Newsgroups: comp.databases
Subject: What is Multiversioning ?
Date: 2 Apr 92 17:36:17 GMT
Reply-To: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Organization: Microprocessor Component Group, Intel Corp., Santa Clara, CA

What is exactly meant by multi - versioning ?

Oracle Manual (DBA V 6) states that oracles read-model is called 
multiversioning because multiple versions of table data may appear to exist
simultaneously.

It handles it as follows -

1. Every transaction has System Commit Number (some Unique Id For Transaction)

2. Whenever any query requires read consistency then all transactions 
   with transaction Id less than the current Id are retrieved.
   (Either from data blocks or rollback segments) 
    Since this process of reconstructing from rollback segments may be 
    recursive the process is called multi versioning.


Is my understanding correct ? or am I missing something ?


Thanks In Advance.

Aniruddha Kortikar (kortikar@mipos2.intel.com)


-------------------------------------------------------------------------------
The views expressed here  are entirely mine.

Aniruddha Kortikar
-------------------------------------------------------------------------------
Newsgroups: comp.databases
From: campbell@redsox.bsw.com (Larry Campbell)
Subject: X/Open compliant ISAM package needed
Organization: The Boston Software Works, Inc.
Date: Thu, 16 Apr 1992 14:31:12 GMT

We need an X/Open compliant ISAM package with the following characteristics:

    1.	Rock-solid and robust

    2.	Available on a wide variety of platforms, minimally including
	RS 6000, HP 9000, Sun (SPARC), VAX/Ultrix, and eventually Alpha.
	(SCO also needed, but it comes with an ISAM library so it's
	covered.)

    3.	NO END-USER ROYALTY.

C-ISAM from Informix would meet our needs except that they charge some
ridiculous end-user royalty (something like $800 for a small HP 9000,
and it's per-user limited).  They also don't seem very excited about
selling it to us ("gee, wouldn't you rather use an RDBMS?"  "Bzzzzzt!")

Is there anything out there besides C-ISAM?  Public domain or commercial,
we don't mind paying a developer license but we must be able to bundle
the package with our products on a royalty-free basis.  Availability of
source code would, of course, be a big plus.
-- 
Larry Campbell             The Boston Software Works, Inc., 120 Fulton Street
campbell@redsox.bsw.com    Boston, Massachusetts 02109 (USA)
From: svb@svb.guug.de (Sebastian v. Bomhard)
Newsgroups: comp.databases.informix
Subject: Re: Table lookup function in isql?
Date: 10 Apr 92 12:54:21 GMT
Organization: Sebastian v. Bomhard, Unternehmensberatung

In article <62980009@col.hp.com> judym@col.hp.com (Judy Miller) writes:
>Problem:  I have a list of keys to 4000 records which I need to delete from
>          a table of 12000.
>
>I'm trying to avoid writing a program for this common function.
>(I do not have 4GL on this machine, but I do have ESQL/C.)

Try this one:
1. load the key list into a (temporary) table
   (create table, load from .. etc.)
2. Then delete records by executing:
   delete from orig_table
   where key_field in (
         select * from temp_table
   )

3. Then drop key list, if not created by create temp table ..

   -svb.

-- 
Sebastian v. Bomhard  <svb@guug.de>  Mathematiker und EDV-Journalist
St.-Anna-Str. 13, D-W-8000 Muenchen 22 (Lehel),        +49-89-298934
From: harry@.syssup.tds.philips.nl (Harry Weseman)
Newsgroups: comp.databases.informix
Subject: how to get the value of a typed-in field
Date: 7 Apr 92 16:23:51 GMT
Organization: Digital Equipment Enterprise bv

Hi!

In informix-4gl, (I have 1.10.03), I would like to inspect what the user
has typed in. I am using an INPUT statement, that gives me the value of
a field with the AFTER FIELD clause. However, with the ON KEY clause, and
then an IF INFIELD(field1) statement, I know that the user has typed something
into the field I want, but I cannot get it from the input buffer. Or is
there a way?

What I am trying to accomplish is to have an alternative for the user: either
what is typed in is accepted as is, or it is checked against a special file.
The program should make the difference by either having it terminated with
the accept key, or with a special function key, F5 or something.

I hope I made myself clear...

Thanks!


Harry



-- 
===============================================================================
Harry Weseman - Digital Equipment Enterprise bv - Apeldoorn - The Netherlands
UUCP  :  ...!hp4nl!philapd!cssnl!harry | "For a thing unknown there is no
NET   :  harry@syssup.tds.philips.nl   |  desire" - Ovid 
Newsgroups: comp.databases.informix
From: daves@techmpc.csg.gss.mot.com (Dave Schmitt)
Subject: Re: HELP use tbmonitor non-interactive way!
Organization: Motorola Cellular Subscriber Group MIS
Distribution: na
Date: Fri, 10 Apr 1992 07:44:21 GMT

In article <1650@das13.snide.com> dave@das13.snide.com (Dave Snyder) writes:
> 
>>     How can I have a cron task to execute tbmonitor tool to
>>     archive or unarchive or backup trans. log periodically?
>
>To the best of my knowledge, there is no way of performing a NON-INTERACTIVE
>archive, unarchive, or logical log backup.

However, with a little work you can use a tool like EXPECT to run an
interactive command (like "tbtape") non-interactively.  An extract from
the EXPECT docs:

...	EXPECT(1)						EXPECT(1)
...	
...	NAME
...	       expect -	programmed dialogue with interactive programs
...	
...	INTRODUCTION
...	       expect is a program that	"talks"	to other interactive pro-
...	       grams according to a script.  Following the script, expect
...	       knows  what  can	 be  expected from a program and what the
...	       correct response	should be.
...	
...	       In general, expect is useful for	running	any program which
...	       requires	interaction between the	 program  and  the  user.
...	       All  that  is  necessary	 is  that  the interaction can be
...	       characterized programmatically.
...	
...	expect may be ftp'd as pub/expect/expect.shar.Z from ftp.cme.nist.gov.
...	Request email delivery by mailing to "library@cme.nist.gov".  The
...	contents of the message should be (no subject line) "send
...	pub/expect/expect.shar.Z".
...	
...	The expect program requires Tcl.  (The expect library does not need
...	Tcl.)  Since you may already have Tcl, it is available separately.
...	Tcl may be retrieved as pub/expect/tcl.tar.Z in the same way as
...	described above for expect.
-- 
David Schmitt, Systems Administrator		Voice: (708)632-5562
Cellular Subscriber Group MIS			FAX:   (708)632-4421
Motorola, Inc., Room S356			Email: daves@csg.gss.mot.com
1475 W. Shure Dr., Arlington Hts, IL 60004
From: lhscmc@latrobe.edu.au (Craig Macbride)
Newsgroups: comp.databases.informix
Subject: Re: isrecnum bug in C-ISAM
Date: 13 Apr 92 03:49:33 GMT
Organization: La Trobe University

Just thought I would point out that there is a (nasty) fix to the problem
I pointed out with C-ISAM. Unfortunately, it will only work if the index
you are using doesn't have duplicate keys.

When you read ISNEXT or ISPREV (with ISSKIPLOCK) and get a return code
indicating that the record is locked, you know that isrecnum is junk, but
the data returned is correct. Therefore, issue a read ISEQUAL on the key
which the ISNEXT/ISPREV read returned. This second read will return not
only the correct data, but also the correct isrecnum!

-- 
 _--_|\		Craig Macbride	<lhscmc@luxor.latrobe.edu.au>
/      \			<s900387@minyos.xx.rmit.oz.au>
\_.--.*/
      v
From: mm@ssf.pt
Newsgroups: comp.databases.informix
Subject: Re: delimiters
Date: 17 Apr 92 13:08:10 GMT
Reply-To: mm@ssf.pt
X-Informix-List-ID: <list.1075>


>I need to be able to put a delimiter between the data fields returned from
>a select statement.  This data is being written to standard output.  An
> ...

Try this

	select field1, "|", field2, "|", field3, "|" from test;


I hope this helps

MM

-------------------------------------------------------------------------------
| Manuel Figueiredo Monteiro                                                  |
| S.S.F. - Servicos de Software Financeiro, Lda     VOICE: +351 (1) 727-0303  |
| Estrada da Luz, No 104 - Loja A                   FAX:   +351 (1) 727-0335  |
| 1600 Lisboa                                       E-MAIL: mm@ssf.pt         |
| PORTUGAL                                                                    |
-------------------------------------------------------------------------------
From: judym@col.hp.com (Judy Miller)
Subject: isql commands from shell prompt
Date: Mon, 13 Apr 1992 22:55:13 GMT
Organization: HP Colorado Springs Division

I have an Informix-SQL Version 4.00 in front of me.

How do I issue the following command from inside a shell script?

   load from "add_units.data" insert into fgistatus;

In which section is this discussed?  

I've never had an overview, and I can't seem to find what I need in the 
index or by browsing each section's table of contents.

Judy 
Newsgroups: comp.databases.informix
From: greg@halexv.uucp (Gregory F. Hogg)
Subject: Re: how to get the value of a typed-in field
Reply-To: greg@halexv.UUCP (Gregory F. Hogg)
Organization: HOGG'S SOFTWARE; Abingdon, MD
Date: Thu, 9 Apr 92 14:09:52 GMT

In article <1992Apr7.162351.9860@cssnl.syssup.tds.philips.nl> harry@.syssup.tds.philips.nl (Harry Weseman) writes:
>Hi!
>
>In informix-4gl, (I have 1.10.03), I would like to inspect what the user
>has typed in. I am using an INPUT statement, that gives me the value of
>a field with the AFTER FIELD clause. However, with the ON KEY clause, and
>then an IF INFIELD(field1) statement, I know that the user has typed something
Harry,

	I think you need 4GL 4.1 to do what you want.

                          
    +++++++++++++++++     
   +++++++++++++++++++    Greg Hogg
   +++             +++    
   ++               ++    HOGG'S SOFTWARE
   +++             +++    
   +++++++++++++++++++    
    +++++++++++++++++     
                          voice : 410-538-7241
   ++++ ++++ ++++ ++++    fax   : 410-538-6130
  ++++ +++++ +++++ ++++   uucp  : uunet!halexii!greg
 ++++ ++++++ ++++++ ++++  cis   : 74176,1320
-- 
                          
    +++++++++++++++++     
   +++++++++++++++++++    Greg Hogg
   +++             +++
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: Ownership of (temp)tables.
Summary: temp tables are always unique to an engine process
Date: 13 Apr 92 07:46:18 GMT
Organization: International Brotherhood of Geeks, Local 619

In article <4755@krafla.rhi.hi.is> gaukur@rhi.hi.is (Kristjan Gaukur Kristjansson) writes:
>I'm having a bit of a problem with temptables.
>I'm using temptables for storing of select-results to use further later,
>and that works just fine.
>BUT, if I want to do two things at the same time that use the same temptable
>name, and so start the 4gl program in two windows, I get a conflict between
>the temptable(s) since in both cases it gets the same owner name, and that,
>the good book says, is not allowed.

This can't be the problem -- all temp tables are strictly local to an
engine process.  That is, even if two independent sessions by the same user 
create temp tables of the same name, the names are known only by the engine
process; they are not inserted into the system catalogs.

Are you *sure* that you are creating them as temp tables?

>				Gaukur.  (gaukur@rhi.hi.is)

--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

"This song is a traditional bluegrass number, in the sense that 
 it's about dead ancestors."  
  - The Austin Lounge Lizards   (live, introducing "Grandpa's Hologram")
From: dave@das13.snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: how to get the value of a typed-in field
Date: 14 Apr 92 01:23:33 GMT
Organization: Snide Inc. - Folcroft, PA

In article <1992Apr11.221012.14683@fivegl.co.nz>, hugh@fivegl.co.nz (Hugh Grierson) writes:
-> Here's basically what we use.  Of course this is completely undocumented,
-> unsupported by anyone, not guaranteed to do anything, but it works for us...
-> 
-> 
->     #include "sqlfm.h"
-> 
->     extern _EFICB *eficb;
-> 
->     fgl_getbuffer()
->     {
-> 	if (eficb->_EFbuf)
-> 	    retquote(eficb->_EFbuf);
-> 	else
-> 	    retquote("");
-> 	return 1;
->     }

This is basically what Jonathan Leffler @ Informix Software told me.  BTW,
this does work beautifully but don't use it with Informix 5.0!  Now if we
can only find out how to read the OTHER icb's :-)

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.4
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com