HDTenEightyP/NetNews huggingface dataset:
From: anderson@Software.Mitel.COM (David Anderson)
Newsgroups: comp.databases
Subject: Re: Q&A
Date: 23 Jul 92 11:40:59 GMT
Organization: Mitel. Kanata (Ontario). Canada.

In article <1992Jul22.030635.1738@trl.oz.au> thompson@titan.trl.OZ.AU (David Thompson) writes:
>Has anybody used Q&A by Symantic. I hear it is quite powerful but very easy to
>use. I have been using dBase for many years but need to find a simpler system
>for a small business. How does it compare to dBase IV? Any comments?
>

I have used Q&A and I have found that it is only good if the database is very
simple in structure. Dbase is a relational database which is very good for
combining different databases together; however, Q&A is only a "flat file"
database which does not lend itself nicely for relationships to other files.

Q&A does have a lookup feature which allows the developer to add a field in
the "current" database which its value is "looked up" in another database and
inserted into the current database. This means that Q&A is still a true "flat
file" database which, in my opinion cannot be compared to Dbase.

Don't get me wronng though, Q&A is a very easy to use package as long as you
are only creating simple "flat file" databases. If you need relational Db's
then use xBase etc...

Hope this helps,

/David
-- 
-------------------------------------------------------
David AR Anderson   Email: anderson@Software.Mitel.COM
Software Tools and Integration
Mitel Corporation   Disclaimer: My opinions are my own!
Newsgroups: comp.databases
From: costello@mbunix.mitre.org (Costello)
Subject: Embedded SQL in SQL2
Organization: The MITRE Corporation, Bedford, MA
Distribution: usa
Date: Tue, 21 Jul 1992 16:53:32 GMT

Hi Folks,
   I am involved in a project which involves a C program accessing a
relational database via embedded SQL calls. In the relational database
that we are using (Oracle) there is a feature provided which allows
fetching an array of records, rather than one record at a time. Of 
course such a feature is not present in SQL.  I was wondering if such
a feature was included in SQL2?  If not, is there any plans of it
being incorporated in SQL3?  It seems like a very useful feature.
(If it is not a useful feature, could someone explain why it is not?)

Second question: how can I get the SQL2 manual?

Thanks for any help.  Cheers!  /Roger

Please e-mail to me directly:

    costello@mitre.org



Xref: sparky comp.databases:5815 comp.databases.ingres:1012
From: rule@apple.com (Jeff Rule)
Newsgroups: comp.databases,comp.databases.ingres
Subject: Re: Looking for a USABLE database
Date: 28 Jul 92 22:19:56 GMT
Organization: Apple Computer

In article <4352@disuns2.epfl.ch>, baechler@liasun7.epfl.ch (Emmanuel Baechler) writes:
> _ The INGMENU environnemnt is a true horror to use. It is incredibly rigid
>   and poorly designed. Several menu levels do not even contain an abort
>   option (and when it exists, it is not displayed in the menu), which leaves
>   the ^C as the only option to cancel when you made the wrong choice in some
>   cases!
> 

This is generally true of any character-cell based query tool.  What you are longing for
is a GUI interface to the database.

> _ there's no environnment allowing "standard users", like lab people or doctors,
>   to to their searches and requests in a simple and intuitive way, what they find
>   on much simpler tools, like FileMaker on a MacIntosh
> 
>

For Ad-hoc queries there are a couple of really good tools that can be used to access a DB
from the Mac.  They will hide the ugly command line interface of the DBMS.  One
is GQL from Andyne corp.  The other is Clear Access from Fairfield Software

Both tools can use DAL (and a number of other middle-ware solutions SQL*NET, DBlib etc..) 
to access any number of DBMS engines (RDB, DB2, INGRES, Oracle, Sybase etc....) on 
any number of operating systems (VMS, Vax/Unix, AIX, MVS) and multiple transports
(TCP/IP, Local Talk,Token Ring, SNA, Async etc....).  What you will find is that you can plug 
and play most any  DBMS with these tools.  You are going to pay extra for the tools, but 
the are well worth it in user productivity and ease of use when accessing the database.

-Jeff Rule
Apple Computer/Database Resource Management
From: robert@sybase.com (Robert Garvey)
Newsgroups: comp.databases
Subject: Re: Sybase questions
Keywords: count, aggregates
Date: 22 Jul 92 23:02:51 GMT
Followup-To: comp.databases
Distribution: usa
Organization: Emeryville Tupleware

(Early attempt to followup was not successful, as far as I can tell.)

In article <1992Jul17.124748.13088@glv.uucp>, bob@robjob@glv.com (Robert H. Lunney) writes:
|> In article <1992Jul16.220952.2833@asc386> mosmith@asc386 (Matt Smith) writes:
|> > 
|> > [...method of finding number of rows in a table...]
|> > 
|> 
|> This is true, but T-SQL will not count rows where the column contains a null.   
From the Commands Reference pages on aggregates:

  COUNT - finds the number of non-null values in a column.  When
	 DISTINCT is specified, COUNT finds the number of unique
	 non-null values.  COUNT can be used with numeric and character
	 columns.  Null values are ignored for the purposes of counts.

  COUNT(*) - finds the number of rows.  COUNT(*) does not take any
	 arguments, and cannot be used with DISTINCT.  All rows are
	 counted, regardless of the presence of null values.

An example:
 
select * from foo   select count(bar) from foo
 bar
 --------            -----------
 NULL                         10
 NULL
 AAAAAA             select count(distinct bar)
 aaaaaa             from foo
 BBBBBB
 CCCCCC              -----------
 CCCCCC                        8
 cccccc
 DDDDDD             select count(*) from foo
 EEEEEE
 eeeeee              -----------
 eeeeee                       12

-- 
Robert Garvey                                Sybase, Inc
robert@sybase.com                            6475 Christie Ave
{sun,lll-tis,pyramid,pacbell}!sybase!robert  Emeryville, CA 94608-1010

Anything related to an opinion may be attributed solely to the poster.
Newsgroups: comp.databases
From: kasvand@ccrs.emr.ca (Tony Kasvand)
Subject: ABF/4GL Help  
Organization: Canada Centre for Remote Sensing, Ottawa
Date: Tue, 28 Jul 1992 18:55:44 GMT


   Hi, 
        I have a small problem with the ABF/4GL (Ingres 6.4) language.

  In the 'where' clause of a callframe statement, I would like to simulate
the 'field' condition.

 Example - 
 
  look_for = 'Joe';     /*  varchar(10) */ 
  whclause = 'fixer';   /*  varchar(15) */ 
 callframe by_fixed_second(by_fixed_second.programs =
                        select distinct key_b = unique_bug#,
                                type_p = product_type,
                                prior = priority,
                                cond = condition,
                                name_p  =  product_name,
                                usrnm = username,
                                fix = fixer,
                                d_of_bug = date_of_bug,
                                name_sys = system_name,
                                des =details1
                                from bug_reports_table
                /* ****** -->*/ where :whclause = :look_for
                                order by prior );

      I am assuming from this code, this is what it should look like:
			 where 'fixer' = 'Joe'

**->
   What I really want is:  where fixer = 'Joe'

 ANY SUGGESTIONS TO AN AMATEUR ABF/4GL PROGRAMMER?

      Thanks in advance,

-- 
Tonis Kasvand      | "Patience is a virtue, only to one's opponent...  
Ottawa, Canada     |    and getting in the first shot. BOOT TO THE HEAD !" 
kasvand@ccrs.emr.ca|          - The Frantics 
                             
Xref: sparky comp.databases:5845 comp.databases.ingres:1032
From: baechler@liasun7.epfl.ch (Emmanuel Baechler)
Newsgroups: comp.databases,comp.databases.ingres
Subject: Re: Looking for a USABLE database
Date: 30 Jul 92 17:22:37 GMT
Followup-To: comp.databases
Organization: Ecole Polytechnique Federale de Lausanne

In article <28543@goofy.Apple.COM>, rule@apple.com (Jeff Rule) writes:

|> This is generally true of any character-cell based query tool.  What you are
|> longing for is a GUI interface to the database.

You are definitely right.


|> For Ad-hoc queries there are a couple of really good tools that can be used to
|> access a DB from the Mac.  They will hide the ugly command line interface of
|> the DBMS.  One is GQL from Andyne corp.  The other is Clear Access from
|> Fairfield Software Both tools can use DAL (and a number of other middle-ware
|> [...]

Thanks for the information and sorry for the delay of my answer.

-- 
Emmanuel Baechler.                        | Tel.: ++41-21-693-2732
Laboratoire d'Intelligence Artificielle   | e-mail: baechler@lia.di.epfl.ch
Ecole Polytechnique Federale de Lausanne  |     or: baechler@liasun6.epfl.ch
MA-Ecublens                               | Standard Disclaimer
CH-1015 Lausanne	Switzerland

Ban the bomb. Save the world for conventional warfare.
Xref: sparky comp.databases:5805 comp.object:3024
From: lhu@pollux.usc.edu (Liyi HU)
Newsgroups: comp.databases,comp.object
Subject: requesting experience w/ OODBMS
Date: 27 Jul 1992 14:52:40 -0700
Organization: University of Southern California, Los Angeles, CA
NNTP-Posting-Host: pollux.usc.edu
Keywords: OODBMS, working experience

Hi,

Our group is planning to purchase an OODBMS.  We are asking for
working experience with OODBMS from your folks.

We are developing a data review, analysis and monitoring application
system.  The application is kind of an expert system.  Currently it's
implemented in Lisp using a knowledge representation language called
LOOM.  But we need to use an OODBMS for system scaling up and
persistence.  Now we looking at two OODBMS, Itasca and ObjectStore.
It's greatly appreciated if you can tell us your experience with
Itasca or ObjectStore, or any other OODBMS in the following aspects.

1. Application Programming Interface
   . host programming language (HPL), interaction of HPL and DB; 
   . object persistence mechanism; 
   . query; 
   . object manipulation.

2 Performance: Is it fast enough for your application?  Please also
specify your machine and your applicaiton scale.

3. Reliability: crashes and bugs?

4. Database facility/utilities, eg recovery, import/export;

5. after-sale support: they are responsible, prompt, and friendly?

Thanks a lot.

--- Liyi Hu ---
From: v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad)
Newsgroups: comp.databases
Subject: Foxpro 2.0 RQBE Grouping ??
Date: 25 Jul 92 00:52:00 GMT
Organization: University at Buffalo
News-Software: VAX/VMS VNEWS 1.41

Hi Guys!
	Can someone tell me what the Group By option in the RQBE window
does.  I've tried to group the data based on Job Code.  There are several
entries for each job code.  The problem is when I view the results of the
query, only the first record of each job code is displayed.  I was expecting
the grouping to behave similarly to that of the report writer.  Obviously
I was wrong.  So, can someone tell me what the Query grouping is supposed to
do.  The only examples in the Foxpro books use records that have no duplicates
on the grouping field.  Not hard to group 1 record!

Thanks in advance.
 Ami 
Xref: sparky comp.databases:5774 alt.sources.wanted:1270
From: me@dude.pcs.com (Michael Elbel)
Newsgroups: comp.databases,alt.sources.wanted
Subject: PD / Freeware / Shareware C-ISAM Package sought
Date: 24 Jul 92 13:46:50 GMT
Organization: PCS Computer Systeme GmbH

I'm in search of a non-commercial (shareware would be ok)
C-ISAM library that compiles on some sort of unix.

Any pointers would be welcome.

Michael
--
Michael Elbel 			|  No, I haven't lost my brain!
PCS GmbH, Muenchen, Germany	|  I just forgot it in the
   me@dude.pcs.com 		|  rush this morning.
From: rudomet@eltamin.usc.edu (Steve Rudometkin)
Newsgroups: comp.databases.ingres
Subject: TERMCAP for W4GL
Date: 23 Jul 1992 12:56:46 -0700
Organization: University of Southern California, Los Angeles, CA
Distribution: na
NNTP-Posting-Host: eltamin.usc.edu

I am developing in Windows4GL on Sun from an xterm|vs100.  We are using 
suntype4.kbd.  I need to change our user's TERMCAP file.  I would like to 
change the default key commands for moving around and editing a field.  I 
remember seeing something about this topic a while back, but the articles 
have expired.

I would like to change to emacs-like keystrokes such as:

<ctrl-f> to move one character to the right as opposed to <right arrow>.
<ctrl-b> to move one character to the left as opposed to <left arrow>.
<ctrl-d> to delete one character to the right as opposed to <delete>.
<delete> to delete one character to the left as opposed to <backspace>
etc,

Also, how can one move from a multi-line entry field to the next field in 
the tab sequence without using the mouse.

If anybody else has done this can you send me the file in e-mail, or post it
here, I am sure others would be interested.

Thanks,
-- 
Steve Rudometkin                       o          ,__o        o   /\/\
University Computing Services         <\        _-\_<,     []<\  /~~\ \/\
University of Southern California  ___/__,     (*)/'(*)      /> /    \ \ \
Los Angeles CA 90089-0251        (213)740-2870  rudomet@skat.usc.edu
From: chas@castle.ed.ac.uk (C Spencer)
Newsgroups: comp.databases.ingres
Subject: Re: Books on Ingres
Keywords: Books; Literature; Ingres
Date: 22 Jul 92 12:29:53 GMT
Organization: Edinburgh University

sjlai@fcit-c1.fcit.monash.edu.au (SIMON LAI) writes:

>Are there any recent books on the Ingres.  Apart from the manuals,
>do any recent books deal with aspects of Ingres such as the Knowledge
>Management Extensions?

I'm currently reading (and working through, and thoroughly enjoying) a
book called "Ingres and Relational Databases", by David Rothwell,
published by McGraw-Hill. It's an introduction, though, and not advanced
- no mention of KME's.

Chas


-- 
Chas Spencer			email :	Chas@ed.ac.uk
Mon & Thur	Computing Officer,	Dept of Mechanical Engineering
Tue & Wed	User Support,		EUCS
University of Edinburgh
Newsgroups: comp.databases.ingres
From: kerry@Ingres.COM (Kerry Kurasaki)
Subject: VAX Cluster Lock Management
Reply-To: kerry@Ingres.COM (Kerry Kurasaki)
Organization: Ask Computer Systems Inc., Ingres Division, Alameda CA 94501
Date: 21 Jul 92 18:05:49 GMT

In article <1992Jul20.215108.18439@pony.Ingres.COM> kerry@Ingres.COM (Kerry Kurasaki) writes:
>
>Here's the technical scoop on INGRES on VAXclusters:
>
>  The second method is to configure INGRES in a cluster mode.  An
>  additional process, the Cluster Server Process, or DMFCSP, is
>  created to resolve locking between nodes of the cluster.  Each
>  node shares data on the cluster and updates are coordinated through
>  the CSP.  An additional benefit of the cluster mode is that node
>  failures are detected automatically, and partial transactions in
>  the failed node are rolled back automatically by the surviving node
>  allowing continuous access to the database.
>

To get to the next level of technical detail on this clustering issue.

INGRES resolves lock contention through the use of an INGRES supplied
device driver.  Actually, it is a memory only driver (does not manipulate
a real periperal).  Anytime you make a lock request, a call is made
to this driver.

In reality, two drivers are supplied on the tape even though only one
is installed at a time while the system is running.  The first driver
might be considered a "local" driver and only resolves locks within
that node, or CPU box.  This driver is installed on single-site
systems and may be installed on a single-node of a cluster.

The other driver is the "cluster" driver and is used when running
in clustered mode.  It works in conjunction with the Cluster Server
Process (DMFCSP) to resolve locks across the VAXcluster.  The CSP
takes out DLM locks and the driver adds the additional (finer)
granularity needed for lock ownership at the thread level.

Just because you are on a cluster, does not necessarily mean that
you are automatically using VAX DLM locking across all nodes.  Many
customers either do not need all nodes of a cluster, or do not want
to incur the DLM overhead so they only configure single-site INGRES.

If you have a DMFCSP running, then you have lock management across
all nodes of the cluster sharing the same installation that have
a DMFCSP running.

If you do not see a DMFCSP process and you have multiple nodes accessing
the same dataset, then there is a very good chance that you might be
corrupting your data.

As I recall, the "cluster" version of INGRES is an optionally priced
item.  Consult your INGRES representative for more information.

Kerry
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: iistartup: What does the cichkcap utility do?
Organization: 
Date: Tue, 21 Jul 1992 05:36:09 GMT

In article <18JUL199220213951@moose.cccs.umn.edu>, rao@moose.cccs.umn.edu
(Rao V. Akella) writes:
> (Of interest probably only to system managers and site admins...)
>
> I maintain a homogeneous VAXcluster on which I run clustered INGRES.  I'm
> trying to expand the cluster by adding a new node, but I'm having some
> trouble.  I've run iibuild and setup new log files and run dmfcsp to add
> the new node to the cluster, but iistartup aborts at the following point
> (note: ONLY on the new node; INGRES starts up fine on the old nodes):
>
>   ...
> $LOG_FOUND_CSP:
> $ cichkcap 30 OK_CLUSTER
> $ if f$trnlnm("OK_CLUSTER") .eqs. "FALSE" then goto ERROR_EXIT
> $ERROR_EXIT:
>  ...

The cichkcap program tests the authorization string to find out if you
are authorized to use a particular part of the INGRES product (e.g.,
Net, Star, Knowledge Manager, etc.).  In this case, "30" is the code for
the cluster bit, and "OK_CLUSTER" is the name of the VMS logical the
"cichkcap" sets to true or false.

Evidently the authorization string you have for your new node does _not_
give you the right to use INGRES in a cluster mode.

Call the authorization string folks and tell them to give you a lifeboat
string for this node with the "cluster bit" set.  The reason I know
about this is that it happened to _me_ too.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.
From: roberts@g2syd.genasys.com.au (Robert Swan)
Newsgroups: comp.databases.ingres
Subject: Ingres library malloc nasties
Date: 22 Jul 92 10:00:52 GMT
Organization: Genasys II, Sydney, Australia

Greetings Netters.

We have been using Ingres 6.3 with ESQL/C on an HP-9000/847.  Since
upgrading to 6.4 and recompiling/linking our development applications
have been dropping like flies.  We scoped the crashing down to about
the most trivial ESQL/C program imaginable - CONNECT followed by
DISCONNECT.  Segmentation violation on the disconnect.

Pretty suspicious.

While programs are under development we use a memory allocation
debugging package (developed by us).  One thing that this debugging
package does is to clobber all memory that has been free(3)d.  It looks
very like the Ingres library is using a pointer after it has been freed.
Tut. Tut.

One thing that puzzles me: 6.4 has been out for quite a while on Sun
and, in my experience, the Sun doesn't let you away with using freed
memory nearly as easily as the HP.  Does this mean that the Ingres code
is all that different between the Sun and HP?

We would like to continue using the memory debugging package (to find
_our_ bugs).  Has anyone got any suggestions/experience on workarounds?

Have fun,

Robert.
===
I used to be indecisive,   | Robert Swan, roberts@g2syd.genasys.com.au
but now I'm not so sure.   | Genasys II Pty. Ltd., North Sydney.
-- 
I used to be indecisive,   | Robert Swan, roberts@g2syd.genasys.com.au
but now I'm not so sure.   | Genasys II Pty. Ltd., North Sydney.
Newsgroups: comp.databases.ingres
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Subject: Re: Example Ingres database program in C required
Organization: Columbia University
Date: Wed, 29 Jul 1992 20:47:27 GMT

In article <1992Jul29.180228.9980@ctr.columbia.edu> csc228@lancaster.ac.uk  
(Bruce Keeler) writes:
> I will shortly be writing an application using SQL embedded in C under  
Ingres
> (version 6.3). Never having done this before, and being one who learns a  
lot
> quicker with reference to example code, I was wondering if anyone had  
any
> such applications that I could have a copy of. Nothing huge required,  
just
> something to get the general idea from. Alternatively, pointers to any
> PD aplications would be greatly appreciated.
> 
> Thanks.
> 
> Bruce
> -- 
> Bruce J. Keeler	                       |   +44 524 68085 (after 8pm GMT)
> csc228@lancaster.ac.uk                 |
> Above address valid until 30th Sept 92 |     "Share and Enjoy"

There are a number of quite good examples in the Ingres manuals.
Newsgroups: comp.databases.ingres
From: horn@schaefer.math.wisc.edu (Jeffrey Horn)
Subject: Naming conventions
Organization: Univ. of Wisconsin Dept. of Mathematics
Date: Mon, 27 Jul 92 14:54:02 GMT

How do YOU name database objects and ingres application objects.  I am 
interested in naming conventions for:

    Databases
    Tables
    Forms
    Frames
    4gl procedures
    SQL Procedures
    Rules
    Database Events

Thanks for your input, 

Jeffrey Horn
Newsgroups: comp.databases.ingres
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Subject: select * with a 3-way join having same column names in ESQL/C
Organization: Columbia University
Date: Wed, 29 Jul 1992 00:02:02 GMT

I had a code segment which said:

 exec sql declare x cursor for
    select *
      from hosts h, hwaddr hw, ip i
        where h.hname=i.hname
          and i.ipaddr=hw.ipaddr;

.. where all three of the referenced tables have a column named hname.

I then fetched like this:

exec sql fetch x into :hosts,:ip,:hwaddr;

where hosts,ip, and hwaddr are structs generated via dclgen.

I got random wierd results under 6.3 and 6.4 include garbage data
and numeric type conversion error messages until I changed the code to
select explicit columns and fetch into explicit struct members in the
same order.

I assume this is because of the ambiguity of the hname column in the three
structs.  The question is whether what I did was incorrect usage or if
ESQLC is generating incorrect code to fill in those structs.  It is not
clear from the manuals which is the case.  Any pointers appreciated.

/a
PS: An syntax error from ESQLC would have been appreciate if this were
    in fact incorrect usage:-(
PPS: dclgen is the coolest thing since sliced bread and finally a real
     reason for me to unlearn EQUEL/C :-)
Newsgroups: comp.databases.ingres