HDTenEightyP/NetNews huggingface dataset:
From: bobb@netcom.com (Bob Beaulieu)
Subject: INFORMIX 4GL (DOS) FOR SALE
Keywords: Version 1.10.06B
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Thu, 31 Dec 1992 23:42:31 GMT


Anyone want to buy INFORMIX 4GL - DOS (legal registered vers 1.10.06B).
This is on 3.5 diskettes. 
I believe the current release is 1.10.06E.

This can be upgraded to the new 4GL when the NEW 4GL is released by 
Informix.

Make me an offer... 

I still need INFORMIX ISQL, ESQL/C, & CISAM (vers 4.1). Anyone want to 
trade? Or sell?

Thanks,

Bob Beaulieu
bobb@netcom.com
-- 
 =============================================================
 Bob Beaulieu                                 bobb@netcom.com  
 San Jose, CA                                 (408) 978-0818  
 =============================================================
Newsgroups: comp.databases
From: triantos@netcom.Netcom.COM (Nick B Triantos)
Subject: Re: INFORMATION WANTED ON DATABASE SOFTWARE USABLE ON BOTH MAC AND IBM PC
Followup-To: comp.databases
Organization: Netcom Online Communications Service
Date: Sat, 26 Dec 1992 19:39:09 GMT

The best-selling database on the Mac, FileMaker Pro, now has a version
available for Windows.  Databases can be shared across a cross-platform
network, the interface is the same, and the database is really easy to use
and set up.  I'm not trying to play salesman for Claris, but it is a really
cool database.  Demos of it should be available on America OnLine in the
Claris forum (keyword Claris), and hopefully soon here in Internetland.

I work at Claris, which may tint my perspective somewhat, but part of the
reason I choose to work at Claris is because I really do believe in their
products.

Anyway, hope this helps!

-Nick "At least I don't need a SoundBlaster to play nice music" Triantos

I may work in Claris Technical Support, but not when I'm logged in on
the Internet...
From: alen@panix.com (Alen Kalati)
Newsgroups: comp.databases
Subject: Foxpro under Unix
Summary: W H E N ? ? ?
Date: 24 Dec 92 19:05:29 GMT
Distribution: usa
Organization: PANIX Public Access Unix & Internet, NYC

does anyone know anything about the long awaited FOXPRO2.5 for UNIX?
I'm beggining to think it's just a dream...
Would it come true???
Alen Kalati
Kalcom Inc.
Newsgroups: comp.databases
From: ppaunio@cc.helsinki.fi
Subject: <None>
Organization: University of Helsinki
Date: Wed, 23 Dec 1992 18:58:24 GMT

I have recently bounced into problem of corrupted dBase IV files. They seem to
be quite normal but somewhere in the file fields are filled with garbage.
Rumour says that somewhere exists programs that are able to repare these kinds
of files.
Thanks in advance

Pekka Paunio
Newsgroups: comp.databases
From: umnoor@ccu.umanitoba.ca (Nasir Ahmed Noor)
Subject: Adding text editor to a Paradox Application
Organization: University of Manitoba, Winnipeg, Canada
Date: Tue, 22 Dec 1992 00:49:11 GMT


I am developing an application using PAL and want to give user access to
Text Editor as part of "Utilities". How can I invoke Text Editor from a 
PAL procedure or Application WorkShop? I tried "EDITOR OPEN" and other
script commands to invoke an editor, it does bring up editor but 
WorkShop gets aborted and I get a message "Paradox was not left in Main
or CoEdit Mode". I issued DO_IT! and/or Reset command before issuing any
editor invoking commands but same thing heppens. Any idea/solution would
be greatly appreciated.

Thanks.

Nasir
umnoor@ccu.umanitoba.ca
From: bhushan_a1@verifone.com
Newsgroups: comp.databases
Subject: Q PLUS E Library
Date: 30 Dec 92 20:34:41 -1000
Organization: VeriFone Inc., Honolulu HI

Hello,

	I don't know much about the DATABASES.My friend was asking for some
library called Q PLUS E library .Any information regarding this will be
helpful.
	Thanks in advance.

Bhushan.
Newsgroups: comp.databases
From: steve.silverwood@filebank.cts.com (Steve Silverwood) 
Newsgroups: comp.databases
Subject: dBase IV for Unix
Date: 21 Dec 92 06:24:00 GMT
Distribution: world
Organization: The File Bank BBS - Fallbrook, CA  619-728-4318
Reply-To: steve.silverwood@filebank.cts.com (Steve Silverwood) 

 >From: thamilto@fnugget.intel.com (Tony Hamilton)
 >Newsgroups: comp.databases
 >Subject: dBase IV for Unix
 >Message-ID: <Bz4F8x.LMv@inews.Intel.COM>
 >Date: 12 Dec 92 00:41:18 GMT
 >
 >Does anyone know if Borland plans to release dBase IV v1.5 for Unix? We are
 >currently running v1.1 on Unix (AIX), and 1.5 on DOS, and would like to get
 >1.5 for Unix as soon as possible.
 >
 >Tony Hamilton
 >thamilto@pcocd2.intel.com

Thus far they've been pretty quiet on the subject, and haven't
announced plans either way.  I've been watching them closely on
dBASE-related matters, but no word.

//Steve//

/----------------------------+---------------------------------------\
|Steve Silverwood            |  Internet: 76703.3035@compuserve.com  |
|Computer Associates         |CompuServe: 76703,3035                 |
|300 Corporate Point, 2nd Fl.|     Voice: (310)348-4448              |
|Culver City, CA  90230      |       FAX: (310)348-7701              |
+----------------------------+---------------------------------------+
|The opinions expressed here are solely my own, mainly because nobody|
|else would want them....                                            |
\--------------------------------------------------------------------/

                                       
Newsgroups: comp.databases
From: rpeou@athena.mit.edu (Rith   Peou)
Subject: Need SQL BNF (grammar) ASAP!
Organization: Massachusetts Institute of Technology
Date: Wed, 23 Dec 1992 20:48:49 GMT


Hello.  I'm working on a project that requires me to write an SQL parser,
but I've found little information on the grammar of SQL.  Instead of 
starting from scratch, does anyone know where I can find (book or public
domain source) info on a BNF grammar of SQL?  I really need this as
soon as possible.  Thanks in advance for any information.

	-Rith

P.S.  Please email me a reply since netnews takes a long time to read.
Newsgroups: comp.databases
From: tranth@egr.msu.edu (Thanh Tran)
Newsgroups: comp.databases,comp.databases.informix,comp.databases.sybase
Subject: Shareware SQL base database for DOS.
Date: 23 Dec 92 20:35:32 GMT
Organization: Michigan State University, College of Engineering
NNTP-Posting-Host: frith.egr.msu.edu

Hi netter,  I was told by a friend of mine that there are some shareware
database that provide SQL access.  Can anyone give me more info on where
to look??  Thanks a lot!
.
From: DUSTIN@MAINE.MAINE.EDU
Newsgroups: comp.databases
Subject: Re: FoxPro problem with outer join
Date: 22 Dec 92 18:20:59 GMT
Organization: University of Maine System

Upon looking @ my manuals, the UPDATE command should work for your purposes

SELECT table1
UPDATE ON unique_key FROM table2 REPLACE table1.field2 WITH table2.field2 RANDO
M
This should update the fields in table1 with corresponding data in table2.
JD
Newsgroups: comp.databases
From: meulenbe@perlis.mcs.gvsu.edu (Joel Meulenberg)
Subject: ObServer/ENCORE Object Server (Help)
Organization: Grand Valley State University, Allendale MI
Date: Tue, 22 Dec 1992 21:56:46 GMT

I'm looking for information pertaining to the "ObServer/ENCORE" Object Server 
developed at Brown University.  Based upon the dates on the source which I
FTP'ed from wilma.cs.brown.edu, it looks as if development stopped sometime
near the end of 1990.  Does anyone know if further work has been done on
"ObServer" since then?  Also, if you have any experience with ObServer/ENCORE
that you could share, I would really appreciate hearing from you.  Please
direct responses to the email address listed below.
--
Joel Meulenberg     meulenbe@perlis.mcs.gvsu.edu
Xref: sparky comp.databases:8632 comp.sys.mac.databases:1621 comp.os.msdos.programmer:11562 comp.sys.mac.programmer:20158 comp.os.msdos.apps:5910 comp.sys.mac.apps:18877
From: robertj@tekgen.bv.tek.com (Robert Jaquiss)
Newsgroups: comp.databases,comp.sys.mac.databases,comp.os.msdos.programmer,comp.sys.mac.programmer,comp.os.msdos.apps,comp.sys.mac.apps
Subject: INFORMATION WANTED ON DATABASE SOFTWARE USABLE ON BOTH MAC AND IBM PC
Date: 21 Dec 92 23:16:16 GMT
Followup-To: comp.databases
Organization: Tektronix, Inc.


     I am looking for a database package that has Mac and
IBM-PCversions.  I am working with a church group.  In order to
maximize the available talent pool,I would like to be able to do
development on either platform.  Idon't care whether the user
interface is the same just as long asthe files move easily from one
system to another.  Any informationwould be appreciated.  Thank
you.
     Robert Jaquiss


Internet: robertj@tekgen.bv.tek.com
Newsgroups: comp.databases
From: joet@dcatlas.dot.gov (Joe Trott)
Subject: Re: CASE > PARADOX CODE
Organization: U.S Dept. of Transportation
Date: Tue, 29 Dec 1992 20:17:25 GMT

0031@pnet16.cts.com (Capt G. Carradini) writes:

>...  Does anyone know if there is a CASE TOOL that will generate
>PAL?  OR, is there a utility that will port dBASE or other CASE output to PAL?
>Any suggestions would be appreciated (posting here or e-mail is fine).

You can always start with the Personal Programmer, PPROG, that comes with
Paradox.  Basically, it prompts you through the design of an application
and then writes the PAL for it.  Obviously, it doesn't have every option,
and is [admittedly] not suited for multi-user applications, but it can be
used to write a framework, to be filled in by a human programmer.

-JTT

Newsgroups: comp.databases
From: yab@cs.brown.edu (Yashesh Bhatia)
Subject: Re: RDBMSes for text management??
Organization: Brown Computer Science Dept.
Distribution: comp
Date: Wed, 30 Dec 1992 15:17:06 GMT

I know of a company that specialises in document publishing software. Here is a
brief description of them.



Electronic Book Technologies, a fast growing company based in
Providence, is looking for several software engineers to assist with
the development of their electronic publishing system. All code is in
C++ or Ansi C with products delivered on all major Unix workstations,
IBM PCs and compatibles under Windows, and by year-end the Macintosh.

If interested, contact Bill Smith at (401) 421-9550.

--------------------

Let me add a few things. First of all, for those of you who don't
know, SGML stands for Standard Generalized Markup Language (or
something pretty similar). SGML is a document-specification standard
that lets one specify both a hierarchy and the actual text of a
document. There are several companies around who do text indexing, but
I'm pretty sure EBT is the only one whose product does it for SGML
without first translating it into some other format (and thereby
usually losing some of the hierarchy information). This is a big win
for them since SGML is starting to become a widespread standard--the
aircraft manufacturing industry and some branches of the government,
for example, have already standardized on SGML. EBT's product,
DynaText, is used by government contractors and other big-name
companies.



-- 
- Yashesh Bhatia yab@cs.brown.edu

Newsgroups: comp.databases
From: dodd@dodd.UUCP (Mike Dodd)
Newsgroups: comp.databases
Subject: Paradox Engine - Groups/Listservers/Books/Magazines
Date: Sun, 03 Jan 1993 05:28:46 GMT
Reply-To: dodd!dodd@seq.uncwil.edu
Distribution: world
Organization: Not
X-Newsreader: Arn V1.00 beta rel2

I hate to repeat, but I was looking for any outlet, inlet, information
about Paradox Engine.  Are there any books relating the use of Multiple
Tables for instance, or Indexing techniques.  Examples using various
programming languages.  Classes using the Engine functions would be
interesting, (I know that Borland has its own 'Application Framework' but
from what I understand it is not the most intuitive, and for $100.00 I
can probably write my own.

If anyone knows of any ftp sites, mail lists, books please either post the
info or sent to me.  

Thanks much!

			    -Mike

+-----------------------------------------------------------------------+
|   Michael E. Dodd		Internet:  dodd!dodd@seq.uncwil.edu     |
|   219 Pershing Court		Voice:     919/799-9453                 |
|   Wilmington, N.C. 28412	(Answering Machine on between 4-10PM)   |
+-----------------------------------------------------------------------+
From: riepjr@ucunix.san.uc.edu (Josette R. Riep)
Newsgroups: comp.databases
Subject: Oracle DB Looking
Date: 23 Dec 92 05:20:12 GMT
Distribution: usa
Organization: University of Cincinnati


		I have been looking for the Oracle Database in third
	party software catalogs. But My search has been unsuccessful.
	I was wondering if anyone knew where I could get the Oracle
	Database and/or a network version of the Oracle Database.  I
	would also like to know the price range of the these Databases.
	

		Thankyou in advance !!

		Todd Sims

	p.s. I would rather recieve answers by email if possible...
Newsgroups: comp.databases
From: krubin@Xenon.Stanford.EDU (Kenneth S. Rubin)
Subject: Fox Consultant wanted
Organization: CS Department, Stanford University, California, USA
Distribution: ba
Date: Tue, 29 Dec 1992 01:13:50 GMT

I apologize if this is inappropriate for this group...

A friend of mine is looking for some consulting assistance using Fox 
and/or FoxPro.  If you are an expert with these tools and are looking 
to start a business relationship with a company in the 
San Francisco / Mill Value area, please contact:

Abraham Chador @ 

Abraham Chador and Company Incorporated
760 Market St., Suite 300
San Francisco, CA  94102
(415) 781-6835

Please do not respond to me...

Good luck.
Newsgroups: comp.databases
From: derek@pooky.cs.mun.ca (Derek Gould)
Subject: Re: <None>
Organization: CS Dept., Memorial University of Newfoundland
Date: Wed, 30 Dec 1992 18:25:42 GMT

In article <1992Dec23.205824.1@cc.helsinki.fi> ppaunio@cc.helsinki.fi writes:
>I have recently bounced into problem of corrupted dBase IV files. They seem to
>be quite normal but somewhere in the file fields are filled with garbage.
>Rumour says that somewhere exists programs that are able to repare these kinds
>of files

In my experience, this is more than likely a hardware problem rather than a 
dBASE problem. It could happen through something like a power outage or spike,
but is more likely caused by the File Allocation Table (FAT) being mucked up andallowing writes to an area that is being used by your database file. Copy the files to a different area of the hard drive or to a backup (tape or floppy, say)
and run a utility such as chkdsk or norton disk doctor. This may identify cross-linked clusters or the like, and will prompt you to repair them. 

I don't know of any simple utility that will automatically remove corrupted data like this, since the definition of what constitutes corruption depends on what
you were trying to store in the file in the first place.

The newer versions of Norton Utilities include a routine that can analysze and troubleshoot dBASE files. This may be of some help.
.
Newsgroups: comp.databases
From: les@chinet.chi.il.us (Leslie Mikesell)
Subject: Re: FoxPro problem with outer join (Really UPDATE)
Organization: Chinet - Public Access UNIX
Date: Tue, 22 Dec 1992 19:23:01 GMT

In article <1992Dec21.205208.39096@datamark.co.nz> david@datamark.co.nz (David Rowland) writes:

>>The key is common to the two tables, but table2 has only a subset of the
>>key values that are present in table1.  I would like to do is replace the
>>field2 values in table1 for which there is a corresponding key in table2,
>>leaving the rest of table1 untouched.
>>
>
>SELECT 0
>USE table2 ORDER unique_key
>
>SELECT 0
>USE table1 ORDER unique_key
    >SET RELATION TO unique_key INTO table2
    >GO TOP
    >
    >SCAN FOR table1.unique_key = table2.unique_key
    >     REPLACE table1.field1 WITH table2.field1
    >ENDSCAN

Instead of the indented section, why not just:
UPDATE ON unique_key FROM table2 REPLACE field2 WITH table2.field2

Les Mikesell
  les@chinet.chi.il.us
From: ychen@csd4.csd.uwm.edu
Newsgroups: comp.databases
Subject: DB2/SQL books
Date: 22 Dec 1992 19:51:01 GMT
Organization: Computing Services Division, University of Wisconsin - Milwaukee
Distribution: usa
NNTP-Posting-Host: 129.89.7.4
Originator: ychen@csd4.csd.uwm.edu



Any recommendation on good books of DB2, SQL (not intro. books
but very detailed)? Thanks.
From: alex@aureus.sublink.org (Sandro Doro)
Newsgroups: comp.databases.informix
Subject: ESQL/C + GX ?
Date: 21 Dec 92 14:19:18 GMT
Organization: Sublink Network, Venice - Italy


Ciao, I am using r6000 with Aix 3.1 and Informix 4.1
I am interesting in using ESQL/C with the forms of 4GL/GX (with
X-window plus Motif). It's possible ?
Please e-mail replies, I'll post a summary if asked

Thanks in advance

--
Sandro Doro    (alex@aureus.sublink.org)

DON'T worry about rutgers' ***"Waiting mail"*** warnings, your mail WILL
get here UNLESS you get a ***"Failed mail"*** message from them!!!
From: promdist!bill@uu.psi.com (Bill Foote)
Newsgroups: comp.databases.informix
Subject: comp.databases.informix
Date: 1 Jan 1993 18:08:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: promdist!pds.com!bill@uu.psi.com
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1748>


Please put me on the e-mail distribution list for comp.databases.informix.

The preferred form of my e-mail address is:

bill@pds.com
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: Calculating Extents
Date: 23 Dec 92 20:52:18 GMT
Organization: Informix Software, Inc.

In article <1992Dec23.170729.20715@informix.com> davek@informix.com (David Kosenko) writes:
>Naomi Walker asked:
>>
>>Can someone please tell me a reliable way to calculate extents
>>on tables with TEXT BLOBS?  I've tried using the formula in
>>the book, but that doesnt work well...
>
>>How do you calculate extents on varchars?  
>
>...[good suggestions omitted]...  The rest of the calculation
>is the same as in the book.

Could you guys be more explicit about what "book" you mean?
Because in The Informix Guide to SQL:Tutorial, Chapter 10,
we tried hard to produce accurate estimation formulas.  And
that chapter definitely distinguishes between the case of
varchar and non-varchar rows.

Check the headings "Estimating Fixed-Length Rows," "Estimating
Variable-Length Rows," "Estimating Index Pages," and others.

I'm sure these formulas could be made more accurate. Please post
corrections or comments here, and/or email them to "doc@informix.com"

Thanks.
   Dave Cortesi
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Newsgroups: comp.databases.informix
Subject: Re: INF4.1 -1 ERROR ?? problem
Date: 27 Dec 92 17:49:00 GMT
Reply-To: shemminga@cix.compulink.co.uk


TITLE: Re: INF4.1 -1 ERROR ?? problem


In <1992Dec23.161421.17027@informix.com> David Kosenko writes:

>Rigby writes:
>>
>>HELP !!!
>>We have just started getting a new error which is described nowhere
>>in the INFORMIX literature (whats new): -1. This happens when we
>>install our package on UNIX . In one of our package-installation-scripts
>>we start tbinit and straight afterwards try a drop database in a 4GL
>>program. This gives us an error -1.
>>
>>Any ideas ?? Is it something to do with tbinit not being quite
>>finished ?
> 
> Any error code less that 100 are Unix errors that are propagated back to
> the user.  The reason they are undocumented in Informix literature is that
> they are not necessarily the same across different platforms, so we would
> have to have the definitions for each platform we support, which could
> wind up being a lot of dead trees ;-0.
> 
> Generally, a -1 error means "Not owner." Is the 4gl program executable by
> the id running the install (presumably root)?

Surely this should be user informix?

| I'm not bad, I'm just drawn that way -- Jessica Rabbit     |
|------------------------------------------------------------|     
| Stuart Hemming       | shemminga@cix.compulink.co.uk       |
| Tudor Labels Ltd     | uunet!cix.compulink.co.uk!shemminga |
| Roman Bank Bourne    | Tel :  (+44) 778 426444             |
| Lincs PE10 9LQ. UK.  | Fax :  (+44) 778 421862             |


Stuart
|8-)
Newsgroups: comp.databases.informix
From: pao@wam.umd.edu (Nikos Strifas)
Subject: Informix & Softbench
Keywords: Informix,Softbench
Organization: Workstations at Maryland, University of Maryland, College Park
Distribution: usa
Date: Sat, 26 Dec 1992 23:44:04 GMT


Informix users,
We are using Informix & Softbench on our HP-700s. Any help on integrating
Softbench & Informix?
Thanx,
N.Strifas
Newsgroups: comp.databases.informix
From: rigby@patty.gud.siemens.co.at (Rigby)
Subject: INF4.1 -1 ERROR ?? problem
Date: Tue, 22 Dec 1992 13:54:01 GMT
Organization: SIEMENS Austria Corp., A-1100 Wien, Gudrunstr. 11
X-Newsreader: Tin 1.1 PL5


HELP !!!
We have just started getting a new error which is described nowhere
in the INFORMIX literature (whats new): -1. This happens when we
install our package on UNIX . In one of our package-installation-scripts
we start tbinit and straight afterwards try a drop database in a 4GL 
program. This gives us an error -1.

Any ideas ?? Is it something to do with tbinit not being quite 
finished ?

Thanx in advance
Andi Rigs.
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: ESQL C problem with sqlerrd[2]
Date: 18 Dec 92 03:11:13 GMT
Organization: You tell me, then we'll both know.

In article <brownlow.724615082@xanadu> brownlow@informix.com (Keith Brownlow) writes:
>>The sqlca.sqlerrd[2] value DOES NOT hold the number of rows found by opening
>>a cursor for a select statement (dynamic or otherwise).  The sqlerrd[2] value
>>is filled in only by the update and delete statements (maybe insert too), but
>>not by a select.
>
>>The only way to get the number of rows from a select statment is to
>>execute some type of "select count(*) into $cnt ..." statement with the same
>>from and where clause as the original select statement.
>
>
>A little clarification at this point;
>
> sqlca.sqlerrd[2] holds the values of the last SERIAL value inserted.

Nope.  The question was pertaining to ESQL/C, in which case sqlerrd[1] 
(in C, the second occurrence in the sqlerrd integer array) is used to hold 
the last SERIAL returned if the last SQL statement was a successful INSERT.  
Otherwise, it holds the ISAM/RSAM or O/S error code underlying an Informix 
error code (if any).  sqlerrd[2] is reserved for row counts, for those
situations where a row count is provided.

>sqlca.sqlerrd[3] will hold the TRUE number of updates and deletes but only
>the first of an insert or select.  This is because both insert and select 
>statements need cursors if they are to manipulate more than one row at a time, 
>while update or deletes will affect every row in the table unless some 
>criteria is specified.

Nope.  sqlerrd[2] is what you are after... and the rest of what you said 
implies that it will always be =1 for a SELECT, which I don't think is true.
The INSERT statement itself doesn't work with an INSERT cursor -- to add
to an open INSERT cursor, you use PUT, not INSERT.

>Hope this clears up any misunderstanding.

I think it caused more.   [-:


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

"People burn more calories while sleeping than while bowling."  
                                               - Rush Limbaugh, 12/17/92