HDTenEightyP/NetNews huggingface dataset:
From: college@vivaldi.EBay.Sun.COM (Darrell Choy)
Newsgroups: comp.databases
Subject: Information about Progress requested
Date: 16 Oct 1992 15:41:06 GMT
Organization: Sun Microsystems, Inc.
Distribution: world
Reply-To: college@vivaldi.EBay.Sun.COM
NNTP-Posting-Host: vivaldi.ebay.sun.com
Keywords: Progress

I'm looking for information and your experiences with Progress, particularly 
in relation to Sybase/MS SQL servers in DOS or Unix environments.

Also, if you have worked with front-ends or utilities for Progress, I'd like
to know about those as well.

Thanks,

Darrell Choy



Newsgroups: comp.databases
From: mccon@ssdd475a.erim.org (Joe McConnell)
Subject: Re: RBASE:  Does is still exist as a development platform?
In-reply-to: jlg@naucse.cse.nau.edu's message of 13 Oct 92 17:06:25 GMT
Organization: Environmental Research Institute of Michigan, Ann Arbor, Michigan
Date: 13 Oct 92 16:16:58

A: Rbase still exists -- they just released a "32 bit" version on
   which they're gambling heavily for survival.
B: Rbase suffers from acute lack of market share with all the
   risks that poses -- I would have no qualms about developing
   in-house applications with it (I used to, in fact), but I would
   look to something with a bigger piece of the market if I 
   were considering building products.
--
Joe McConnell  | Opinions expressed are the   | Don't blame me!  I voted for
mccon@erim.org | author's, not the employer's.| Stephen Maturin!
Newsgroups: comp.databases
From: daf@wts.com (David A. Fox)
Subject: Has anyone heard of ZIM?
Organization: Wegmans Transaction Services
Date: Wed, 7 Oct 1992 13:28:37 GMT


I am looking for any information about a database language called ZIM.
Supposedly this runs on UNIX or UNIX look alikes.  Any information 
is appreciated.

Thanks in Advance

Dave Fox
daf@wts
And Remember:
	Anybody can win, unless there happens to be a second entry.
From: usenet@inesc.pt (USENET News System)
Newsgroups: comp.databases
Subject: Help on browsers
Date: 12 Oct 92 19:11:13 GMT
Organization: INESC - Inst. Eng. Sistemas e Computadores, LISBOA, PORTUGAL


Hello

I'm developing a class browser for an OO language called SOM
(Semantic Object Model) and I'm looking for articles and books
about browsers.

I would be grateful if you could send me some information on the matter,
namely, I'm interested in the following issues:

1 - Taxonomy of browsers.

2 - What kind of functions they should offer.

My principal concern is in Class Browser's, but information related with
Instance browser, both OO or Relational based are also wellcome.

Thanks in advance

                   Joao Damasio.


----------------------------------------------------------------------------
Joao Damasio                                     E-Mail:jcdam@tutor.inesc.pt
INESC Lisboa - Information Systems Group         Tel: +351 1 3100327
Rua Alves Redol 9-4E                             Fax: +351 1 525843
1000 Lisboa Portugal                             Telex: 15696 INESCP
----------------------------------------------------------------------------
Xref: sparky comp.databases:7141 comp.object:3898
From: mccon@ssdd475a.erim.org (Joe McConnell)
Subject: Re: Browse Table using Paradox Engine & C
In-reply-to: bgdg774@utxvms.cc.utexas.edu's message of 14 Oct 92 01:55:31 CST
Organization: Environmental Research Institute of Michigan, Ann Arbor, Michigan
Date: 14 Oct 92 16:26:12

Browsing is a user interface concept -- the Paradox Engine has no
user interface capabilities.  To do a browse, you will have to write
all the UI code in something else, then use the Engine for getting
and putting data.

On the topic of the Engine, I was just able to place an order for
Engine 3.0 -- to ship in a week, according to Paradox.  $69.95 as
an upgrade from 2.0.  Furthermore, the Paradox 4.0 runtime is now 
shipping -- $99.00.

t
--
Joe McConnell  | Opinions expressed are the   | Don't blame me!  I voted for
mccon@erim.org | author's, not the employer's.| Stephen Maturin!
Newsgroups: comp.databases
From: bgdg774@utxvms.cc.utexas.edu
Subject: Browse Table using Paradox Engine & C
Organization: University of Texas @ Austin
Date: 14 Oct 92 01:55:31 CST

Hi,

I am working on a project using Borland C++ 3.1 and Paradox Engine 2.0.
Also I will be using an add-on module TesSeRact CXL User Interface Developement
System by Innovative Data Concepts.
I wonder if I can do a browse on paradox table using Paradox Engine 2.0.
Or if it is possible, can anyone tell me how can I get more information e.g.
book, articles etc.

Thanks in advance

William Yiu
william@ccwf.cc.utexas.edu
From: banerji@andromeda.rutgers.edu (Ranjan Banerji)
Newsgroups: comp.databases
Subject: Paradox Help
Date: 13 Oct 92 18:33:32 GMT
Organization: Rutgers Univ., New Brunswick, N.J.

I am using a form in the Wait record loop. A part of the form is
marked using a bar.(To mark a choice). However when you move to next record
and then come to the one you just marked the marking is no longer there.
This is because the Wait record command clears the screen of any paint canvas
paint(if I may call it so). I cannot insert the paint canvas after the wait
record. So how do I keep the choice marked when I leave it and come back 
to it.

Thanks

Ranjan
Newsgroups: comp.databases
Subject: Alpha 4 Help
From: R.C.(Chuck) Solly <NU035609@NDSUVM1.BITNET>
Date: Wednesday, 7 Oct 1992 15:05:08 CDT
Organization: North Dakota Higher Education Computer Network

I'm using Alpha 4 V.2 to create a database with some unusual
characteristics (I think) and Alpha Tech Support is not helping
at all.
My problem is that I must post data from a transaction database
composed of daily invoices, to any of 25 Master databases. The post
is triggered by a line on the invoice that contains the "dealer id".

Alpha 4 contains a "trigger script" which allows me to do the posting
when the user saves the record. The problem is that I am not familar
enough with the Alpha 4 command structure to figure out how to set
each dealer id to a variable and then dump each line to the appropriate
database.
I figure that there MUST be an Alpha 4 expert out there somewhere who
can get me started...

Any help will be greatly appreciated!!

Chuck
Xref: sparky comp.databases:7247 bit.listserv.sqlinfo:253 comp.misc:4015
From: michaelb@wshb.csms.com ( WSHB Operations Eng)
Newsgroups: comp.databases,bit.listserv.sqlinfo,comp.misc
Subject: SQL classes
Date: 15 Oct 92 15:37:59 GMT
Followup-To: poster
Distribution: na
Organization: WSHB, Herald Broadcasting Syn., Inc., Cypress Creek, SC, USA

Hey gang,

I need some crash courses in SQL. I keep getting flyers in the mail from an
outfit named Learning Group International for seminars they offer. The
advertisements look good, but I'd really like a first hand opinion. Has
anyone ever been to any of these? How would you rate them? How about
someone else? Anything that's available in the Southeastern USA would be
acceptable. I can't really make a trip to a university seminar somewhere 
on the other side of the continent.

Thanks in advance.

Michael
-- 
Michael Batchelor--Systems/Operations Engineer #compliments and complaints
WSHB - An International Broadcast Station of   #   letterbox@csms.com
       Herald Broadcasting Syndicate, Inc.     #technical questions and reports
michaelb@wshb.csms.com         +1 803 625 5552 #   letterbox-tech@csms.com
From: aahz@netcom.com (Mean Green Dancing Machine)
Newsgroups: comp.databases
Subject: Re: PARADOX 4.0 - How can I print structures?
Date: 8 Oct 92 23:32:27 GMT
Article-I.D.: netcom.1992Oct8.233227.9154
Organization: Bill 'n' Opus for Prez

In article <92282.152553U15310@uicvm.uic.edu> Tom Ascher <U15310@uicvm.uic.edu> writes:
>Does anyone know how I can get printed output of the table structures
>that I've created in Paradox?  Not the data in the tables, but the
>structure definitions of the table itself.  Thanks!

Do: Tools | Info | Structure | <table>, then Alt-F7 to print it out.
There are also 3rd-party tools (e.g. ParaLex) that will perform this
operation automatically across groups of tables.
-- 
                         --- Aahz (the *other* Dan Bernstein)
                             @netcom.com 

Hugs and backrubs -- I break Rule 6

Who needs Lime Jello [tm]?  We had lasagna.....
From: eb@felix.Sublink.Org (Enrico Badella)
Newsgroups: comp.databases
Subject: Entry level CASE for unexperienced users
Date: 7 Oct 92 17:00:43 GMT
Organization: Soft*Star s.r.l, Torino, Italy

We have instilled in one of our customers (very looooow level, maximum
experience IBM S/36) an interested for a CASE tool to mantain an
INFORMIX based DB.
My personal experience has been with IDE STP and Cadre Teamwork but
both of these tools are TOO difficult for this kind of customer.
I'd like to find some upper-CASE maybe just to draw some ERE and DFD;
generation of SQL code is not important because the tool would
be used mainly to document the DB that has grown in the years and
has absolutely no docs or specs.

Has anyone come across this kind of tool?

-- 
Enrico Badella				Internet: eb@felix.sublink.org
Soft*Star s.r.l.			          eb@icnucevx.cnuce.cnr.it
Via Camburzano 9			Phone:    +39-11-746092
10143 Torino, ITALY			Fax:      +39-11-746487
From: jbestwic@sunrise.Berkeley.EDU (J. Bestwick)
Newsgroups: comp.databases
Subject: Re: Integrating text retrieval with DBMS ?
Date: 15 Oct 92 08:35:27 GMT
Reply-To: user@machine.domain
Organization: Oracle UK.
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.


In article <1992Oct14.122852.27591@eagle.lerc.nasa.gov>,
sshws@convx1.lerc.nasa.gov (Herb Schilling) writes:

>Hello,
>
> We are looking to create a database in which some of the fields will be 
>full text searchable. Since DBMS do not have all the sophisticated 
>capabilities of a full text retrieval package ( like Fulcrum , Verity )
>we would like to use one of these packages to do the searching in the
>text fields and let the DBMS do the querying in more structured fields
>such as date, time,etc... 

You might like to take a look at Oracle's SQL*TextRetrieval product, which
does integrate full text retrieval functionality with the DBMS.  It's not
my field personally, but information should be available from Oracle HQ on
(415) 506-7000 or from our Cleveland office on (216) 328-9100.

Thanks.

John Bestwick,
CASE Development, Oracle Corporation
From: frank@smartstar.com (Frank Dziuba)
Newsgroups: comp.databases
Subject: Adding an exact equality operator to SQL based product
Date: 15 Oct 92 18:50:58 GMT
Organization: SmartStar Corp. / Signal Technolgy Inc.


We have a 4gl product which is closely tied to SQL. Because of this,
the 4gl string comparison operator ("=") ignores trailing blanks  when comparing
2 strings. 

We would like to add an "exact equality" operator to the 4GL which would NOT
ignore trailing blanks, and are considering using the token
"==" for this purpose. Does anyone know if there exists any de-facto
standard for this operator?  Also, are there similar products which have 
already adopted an operator that does this?

Please reply by E-mail with any information.

Thanks,
	frank dziuba

frank@smartstar.com
From: a434amid@cdf.toronto.edu (Rudy Amid)
Newsgroups: comp.databases
Subject: SQL question
Date: 13 Oct 1992 02:45:00 -0500
Organization: University of Toronto Computing Disciplines Facility
NNTP-Posting-Host: cs.utexas.edu

Hi,

   I've been trying to figure out a way to do arithmetic on two counts
from two different relations.  For example, counting the percentage or
average of the # of things in both relations.

ie: select attr0, count(attr1)/count(attr2)*100
     from table1, table2
    where ...
    group by attr0;

This query is not right.  Is there a correct way to do this?

Thanks
-- 
!Rudy Amid              ///
a434amid@cdf.toronto.edu//
amid@r-node.gts.org   ///
Netrek/IRC: Radix  \\X//
Newsgroups: comp.databases
From: eravin@panix.com (Ed Ravin)
Subject: Approach for Windows (xbase etc. front end)
Date: Thu, 8 Oct 1992 19:16:54 GMT
Organization: Not Just Another Pretty Face

Just got a flyer in the mail for a product called "Approach for Windows",
which claims to be a user-friendly front end for Dbase, Paradox, Alpha 4,
and other databases, letting you cross reference difference databases,
write your programs with Windows GUI, and similiar.  It's "only" $129 and
promises lots.  Anyone out there have any experience with Approach and can
advise on its merits?
-- 
Ed Ravin            | I like to think (it has to be!) of a cybernetic ecology
eravin@panix.com    | where we are free of our labors and joined back to nature
philabs!trintex!elr | returned to our mammal brothers and sisters,
+1 914 993 4737     | and all watched over by machines of loving grace
Newsgroups: comp.databases
From: fyl@ssc.com (Phil Hughes)
Subject: Re: Alpha Four V2 or Paradox 4.0
Organization: SSC, Inc.,  Seattle, WA
Date: Thu, 08 Oct 1992 15:25:39 GMT
X-Newsreader: Tin 1.1 PL3

snowden@cray.com (Jim Snowden) writes:

: I am looking to get a database system that makes it easy to write
: my own applications (like a library cataloguing system, membership
: database).  I'm not a programmer, but I can write some programs
: in BASIC.
: 
: Now, I have two special offers for databases.  One for Alpha Four V2
: and one for Paradox 4.0.  I am fairly familiar with Paradox, but does
: anyone have any opinions on Alpha Four V2?

I have worked with Alpha Four.  It is real easy to get something running
but I quickly ran into the "you can't do this" of it.  If you want to do
anything fancy (like update display fields from different files) I
recommend Clarion.  It is as easy as Alpha for simple applications but
allows you to do most anything.  It has a 4GL called Designer that you use
for building applications but also a programming language (like FOCUS)
that you can use if necessary.

As for special deals, you can get Clarion for under $200 if you upgrade
from Dbase, Alpha or a few others.  And one real nice thing: you can build
and redistribute binaries with no royalties.
-- 
Phil Hughes, SSC, Inc. P.O. Box 55549, Seattle, WA 98155  (206)FOR-UNIX
>>> Publishers of pocket references for UNIX, C, VI, Emacs, Ksh, MS-DOS, ... <<<
     ...!ssc!fyl or fyl@ssc.com            (206)527-3385
From: rkwdp@pukvm1.puk.ac.za (MNR D PRETORIUS       )
Newsgroups: comp.databases
Subject: Clarion
Summary: Any Clarion users out there/When will Clarion 3 be released
Keywords: clarion
Date: 14 Oct 92 10:29:51 GMT
Article-I.D.: pukvm1.rkwdp.2
Organization: Rhodes University, Grahamstown, South Africa

Clarion users:

Does anybody know when the new version of Clarion Prof. Developer will be 
released?  I am using Clarion 2.1 but am looking forward to the new version 
of Clarion as I am about to start with a new application - I want to 
develop it with Clarion 3.  I have seen the demo-version of it and it looks 
very good.  The local distributors of Clarion in here in South Africa doesn'
t exactly know when the release will be..

I heard rumours of the end of Sept - but still nothing as yet...

Will be glad to hear any comments...

Danie Pretorius
rkwdp@pukvm1.puk.ac.za	
Dept of Computer Science and Information Systems
Potchefstroom University for Christian Higher Education (PU for CHE)
Pothefstroom
South Africa
Newsgroups: comp.databases.informix
From: M21520@mwvm.mitre.org
Subject: Wingz DataLink question
Organization: The MITRE Corporation, McLean VA 22102
Date: Tue, 13 Oct 1992 15:55:09 GMT

Hello Informix-users!
 
I am working on a system which uses Wingz DataLink to integrate Wingz on the
Mac with Informix Online on a Sun Sparcstation.  Our programming team has
created a spreadsheet-like interface to the database using the documented
DataLink functions.
 
In prorotyping a new function, I wrote the following SQL statement:
 
  select category, sum(fy92) from data_table group by category
 
to obtain a roll-up of the data in the fy92 column for each category.  This
returns 13 rows of data (as expected) if I enter the command in the DataLink
"Direct Entry" window.  Fine.  I want to program a button script to execute
the same command (so my end-user doesn't have to worry about SQL).  I have
tried the following script:
 
  define err, status, rows
 
  select range "categories"  {select region for output}
  DB:force_flow = 1
  status = DB:DBState()
  if status <> DB:A_NOTCONN
    call DB:ExecuteCommand("select category, sum(fy92) from data_table
                            group by category")
    status = DB:DBState()
    rows = DB:DBDescribeRowset()
    if status = DB:A_READY
      if rows > 0
        call DB:WingzOutput()
      else
        message "No rows selected for this query"
      end if
    end if
  end if
 
Running this script, I only get the first 4 of 13 rows of data.  I checked the
value of the "rows" variable before the call to WingzOutput and it says that
there are only 4 rows.  My suspition is that the database is still processing
the query when it returns the first 4 rows, and I have to add more code to
fetch the additional rows (not sure how to do this).  Any thoughts or
suggestions on the problem will be appreciated!
 
Kindly e-mail responses to: M21520@mwvm.mitre.org
 
Thanks in advance for any help!
 
  Brian O'Sullivan       standard disclaimers apply
  MITRE Corp.
  Washington DC
Newsgroups: comp.databases.informix
From: eric@desktalk.com (Eric Lieber)
Subject: Re: Wingz DataLink question
Reply-To: eric@desktalk.com
Organization: Desktalk Systems Inc.
Date: Wed, 14 Oct 1992 17:09:16 GMT

I have ran into simular problems with Wingz and DataLink.
( Selecting computed columns, using column aliases, etc..)
Try calling Informix Wingz support at 800 753 6396 0r
 Fusion SW in New York. They are the people who
developed DataLink.

eric lieber
desktalk systems
From: baskett@hermes1.sps.mot.com (Bob Baskett)
Newsgroups: comp.databases.informix
Subject: Re:  sqlca.sqlcode error -522
Date: 8 Oct 92 03:18:09 GMT
Reply-To: baskett@hermes1.sps.mot.com (Bob Baskett)
X-Informix-List-ID: <list.1509>


-522	Table table-name not selected in query.

The table shown appears at some point in this query, but it does not appear 
in the FROM clause. Review the uses of this name: if it is spelled as you 
intended, then add it to the FROM clause.

-----------------------------------------------------------------------------
Bob Baskett
Motorola, Inc
From: billd@informix.com (William Daul)
Newsgroups: comp.databases.informix
Subject: Re: Question: Can I embed SQL in C++
Date: 8 Oct 92 23:16:29 GMT
Organization: Informix Software, Inc.
Originator: billd@cheetah

From: (Jennifer Heggie)
To: uunet!snide.com!dave.snyder
Date: Wed, 7 Oct 92 17:11:04 PDT

The grocery chain Kash 'n Karry, located in Florida,
uses the C++ development environment provided by 
ObjectCenter from CenterLine Software to develop C++ 
code with esql/c from Informix--successfully.

Send me email if you'd like an article on the subject.

Jennifer Heggie
Informix Software
(jenh@informix.com)
 
> Quoting Low Chee Meng (KSL)...
> } 
> } I would like to know if anybody has any experience/success writing
> } embedded SQL statements inside a C++ program.
> } 
> } We have an Informix database and a ESQL pre-processor meant
> } for C. According to the local agent from Informix, the SQL
> } pre-processor works only on C files, not C++ files. 
> } We intend to use GCC as our C++ compiler, but we do not know
> } how to make the pre-processor work with GCC.
> } 
> } Is there any way to work around the abovementioned problem? 
> } 
> To make the ESQL/C pre-processor work with gcc, do this:
>  1) vi $INFORMIXDIR/bin/esql
>  2) Change the "cc" near the bottom of the file to "gcc"
>  3) save your changes
> 
> As for the C++ thing, you're on your own.
> 
> DAS
> -- 
> David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
>                                                                is db4glgen-3.7
> UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
> 


-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
 William Daul             Advanced Support      INFORMIX SOFTWARE INC.
 4100 Bohannon Dr.        (415) 926-6488 - wk
 Menlo Park, CA. 94025    uunet!infmx!billd  or  billd@informix.com
From: svb@svb.guug.de (Sebastian v. Bomhard)
Newsgroups: comp.databases.informix
Subject: ACE and ASCII
Date: 12 Oct 92 01:45:21 GMT
Reply-To: svb@guug.de
Organization: Brodersen + Bomhard EDV-Unternehmensberatung

A client of mine is writing a short application, a few reports. The data is
not only derived from tables, but also from ascii files. First he loaded
the data, ran the report and then destroyed the tables again. I recommended
the new ASCII READ-Feature of ACE, and it works well, but the name of
the dummy database is causing me pain, because on every machine there
is another database with another name.

I RTFMed a while and found the database ASCII, and i tried: (the file
passwd is a version of /etc/passwd with ":" at the end)

    1	DATABASE ascii END
    2	
    3	define
    4	ascii uname char(8), upasswd char(8), uid integer, gid integer,
    5	      kommentar char(30), home char(50), shell char(30)
    6	end
    7	
    8	read "passwd" delimiter ":" order by uname asc
    9	end
   10	
   11	format every row end

This doesn't work

Output:
The reading of the database will now begin.

The reading of the database has finished.


    Database not selected yet.
See error number -349.


Creating an empty database tralala on every machine does the job:
Replace line 1 with:

    1 DATABASE tralala END

What's going on there, am I blind or can't I read the manual? Or is it 
a buglet?

Well, I can live with it, but it was sort of embarassing for me... but my
client still trusts me :-)

 TIA, hope to hear from you soon :-)

  -svb
-- 
Sebastian v. Bomhard                               <svb@svb.guug.de>
Brodersen + Bomhard EDV-Unternehmensberatung       <postmaster@svb.guug.de>
St.-Anna-Str. 13, D-W-8000 Muenchen 22 (Lehel),     +49-89-298934
>>>>>>>>>>>     A neat desk is a sign of a sick mind.      <<<<<<<<<<<<<
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: char database types blanks and nulls
Summary: blanks are not nulls are not blanks
Keywords: null,esql/c
Date: 15 Oct 92 19:07:43 GMT
Organization: Informix Software, Inc.

In article <1992Oct12.225029.2143@advtech.uswest.com> yslas@riverauswest.com ( Rob Yslas) writes:
>Using Standard Engine
>
>This sometimes returns a blank field for the value of column1
>
>$string column1[20];
>
>$declare test_curs cursor for
>select distinct column1
>into $column1
>from test_table
>where column1 is not null;
>$open test_curs;
>$fetch test_curs;
>
>I know that the informix char data type will blank fill to the end of a field.
>If I am using the sting data type for the variable name the trailing blanks are
>removed from the value placed into the array.  If the field is blank doesn't the
>database treat this as a null value?

Your code shows retrieving data, so you have to ask what is in
the table.  In the database, the value "" is not the same as NULL.
An empty string is a specific value; NULL means "not known."

So if you do this:
   insert into test_table values ("")

you have inserted a non-null value. In fact the engine always
pads CHAR columns to their specified length, so the above is
the same as inserting "        " for however many blanks.

>  If not what situation will cause the 
>database to think there is a value in that field.

Any value other than the keyword NULL on insert/update.

> Does it fill with a different
>value for blank then when a user enters a blank character? If it thinks a
>blank field is null why would it return with this cursor?  Shouldn't the 
>where disallow the inclusion of this blank field with the other cursor values.

A blank column value is a specific column value and it is
appropriate to return that specific value in this query.
You could write the statement this way:
  ...where column 1 is not null AND column 1 NOT MATCHES "      "
Newsgroups: comp.databases.informix