HDTenEightyP/NetNews huggingface dataset:
From: cpetersn@iastate.edu (Clifton R Peterson)
Subject: Re: Looking for a good front end app
Organization: Iowa State University, Ames IA
Date: Sat, 3 Oct 1992 03:09:06 GMT

Look at Advanced Revelation from Revelation Technologies
				 Two Park Avenue
				 New York, NY  10016

Tech Support is (206)746-1629
Sorry, I don't have the Sales/Info number handy.

It is perhaps the the most powerful database frontend development package
out there for DOS.  It seamlessly bonds with most databases (if someone has
written the bond) and has a pretty good database structure of its own based
on linear hash files with B-Tree indexes on any data field, or symbolic of
any data field(s).

It gives the developer virtually unlimited power to create beautiful
user interfaces that have every from automatic popups of other data files,
security protection, on-line developer customizable/and plain out writeable
help.  It's fairly easy to startup, spend some time with included Tutor and
be ready to develop fairly simple applications, but the learning curve can
get a bit steep when you start really digging into the included programming
language to get the real power.  

I strongly recommend this package if you can get over the sticker shock.


Or, if you don't mind kicking out some bucks, I'm an independent developer
in AREV so maybe I could set something up for you.

cpetersn@iastate.edu

-- 
 _________________________________________________________________________
/ Clifton R. Peterson    1108 Burnett		(515)232-5254	    	  \
| B.S. Chem E            Ames IA  50010                                   |
\_______________"42"_is_one_hell_of_an_answer!!___________________________/
From: krb@hpuerca.atl.hp.com (Kevin Barnes)
Date: Wed, 30 Sep 1992 20:28:05 GMT
Subject: Re: Flat file database for Unix?
Organization: the HP Response Center, Atlanta
Newsgroups: comp.databases

I remember hearing about an ATT flat file db that was public domain, if 
I remember correctly the name was UNITY.
Sorry that is all I remember about it.
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: Multiple Ingres 6.3 servers on a Sequent
Date: 3 Oct 92 23:45:59 GMT
Organization: Not Organized

In article <ncourdy.718039747@Endor> ncourdy@endor.sim.es.com (Nabil Courdy) writes:
>We are running Ingres 6.3 on a 2-CPU Sequent/2000.  The system is configured
>to run with 2 Ingres servers (fast_commit, write_behind, and shared_chache).
>Lately we noticed a significant degradation in performance.  It is taking up
>to 30 seconds to enter the sql terminal monitor.  As a test, I started a 3rd
>ingres server and dedicated it to the development databases using the -dblist
>server parameter. Other parameters are (fast_commit,write_behind, and 
>sole_server).  Performance does not seem to have improved.  The log file is
>only at 13% usage when we notice the degradation.  Tables are structured and
>optimized and there are no overflow pages.  Does anyone have any clues please ?
>Also the 3rd server has no iislave processes associated with it (Why?)

How long has it been since you did a sysmod?  If the system tables for 
the databases have overflow pages, performance will be poor, even if the 
user/dba tables are all perfect in structure.

bob

--
RW Salnick, Spokane,WA  |  Home: salnick@dejavu.spk.wa.us
  Amiga 1000, WB 1.3    |  Work: mfgsys!salnick@kaiser.spk.wa.us
      WA9BVE            |
Newsgroups: comp.databases.ingres
From: mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney)
Subject: Re: Suche Ingres/Windows4GL Programmierer in Dortmund
Organization: Indiana University, Bloomington
Date: Thu, 1 Oct 1992 15:57:50 GMT

Raghu=Ram%Supplier%IM=Hou@bangate.compaq.com writes:
>Could someone translate this posting so that many of us who could 
>not comprehend, try to help the desparate soul if he / she is 
>really in need of something urgently !!

I think you're just curious :)

Seriously, though, if the desparate soul was that desparate, don't you think
he'd have had someone translate it into English, also?  He's looking for a
Ingres/W4GL programmer.  I assume that it's in German because he'd like
someone who knows German.

>   -------------------------- [Original Message] -------------------------
> Subject: Suche Ingres/Windows4GL Programmierer in Dortmund
Looking for an Ingres/W4GL programmer in Dortmund

>An alle Dortmunder (und Umgebung) !
To all Dortmunders (and foreigners?) !

>Wer hat Programmiererfahrung unter Ingres/Windows4GL?
Who has programmed under Ingres/W4GL?

>Unternehmer sucht jemanden, der ihn in das System einarbeitet, 
>bei guter Bezahlung.       
(I'm not real good with this stuff) We're searching for a person who
can work with this system, for good pay.

>Systemumgebung:
>
>IBM R6000 / AIX 3.2
>Ingres 6.4
>
>Interessenten bitte melden unter Tel.: 0231/818154
>Herrn Bohlmann verlangen.

Interested people should call 0231/818154 (numbers seem to be easy to
translate :), and ask for Mr. Bohlmann.

Oh well, I don't know much German, but you get the drift.

	Darrin
-- 

mdchaney@iubacs mdchaney@bronze.ucs.indiana.edu mdchaney@rose.ucs.indiana.edu

"This is a .signature."
From: doug@news.cis.ohio-state.edu (Doug Kerr)
Newsgroups: comp.databases.ingres
Subject: Access to iidbdb
Date: 6 Oct 92 13:49:00 GMT
Article-I.D.: bear.9210062149.AA04493
Organization: The Ohio State University Department of Computer and Information Science

We have just started using Ingres on DECstations.  The documentation
says that all information about the databases is stored in the iidbdb
database, which is owned by the user $ingres.  However I am unable to
access any of those tables even with ingres user privileges.  I can
access the database, but am told it contains no tables.

 Douglas S. Kerr, Department of Computer and Information Science
 The Ohio State University; 2036 Neil Ave. Columbus OH USA 43210-1277
 doug@cis.ohio-state.edu                    614/292-1519
From: cxh@arsenic.berkeley.edu (Christopher Hylands)
Newsgroups: comp.databases.ingres
Subject: updating dynamic cursors with esqlc
Date: 6 Oct 92 16:03:32
Organization: University of California, ERL/Microlab
Distribution: usa
NNTP-Posting-Host: arsenic.berkeley.edu


I'm trying to use the UPDATE embedded sql command with a dynamic
cursor and not having much luck.

I want to use host variables in the UPDATE (and DELETE) commands, but
I get syntax errors.  I'm writing a general interface to sql, and
things like tablenames and columns are not known at compile time.

The syntax of the UPDATE command is:
	EXEC SQL UPDATE tablename
		SET column = expression {, column = expression}
		WHERE CURRENT of cursor_name

The problem is that one cannot use a variable name for 'tablename' or
'column'.  The docs (p7-265 of INGRES/SQL Reference Manual) say:

	"* Host variables can be used only for the cursor names or for
	expressions in the SET clause."

How does one do an update on a dynamic cursor if one does not know the
tablename or column names in advance?


Eventually, by hacking the output of esqlc by hand, I was able to 
use variables for table_name and cursorname.  I realize that this is
not good practice, but . . .


After hacking the output of esql, I had to change the way cursors are
declared. Before I changed the cursor declaration, I got an error
because the cursor has not been opened for update:

	SQLupdate tcust_info curs: SQL Error:
	E_US08A9 Cursor 'curs' has not been opened for update.
	    (Tue Oct  6 11:33:16 1992)


If UPDATE is to work, then the cursor must be declare like:
	EXEC SQL        DECLARE:Cname CURSOR FOR
		select * from tcust_info for update of name;

instead of:
	EXEC SQL        DECLARE:Cname CURSOR FOR Sname;


If, at compile time, one does not know the select or the column names,
then how does one use a dynamic cursor and update the table?  Trying
to use a host variable for the select produces a syntax error.


The docs for DECLARE state that the syntax is:

	EXEC SQL DECLARE cursor_name CURSOR
		FOR SELECT [ALL|DISTINCT]
		result_expression {,result_expression}
		FROM table [correlation] {, table [correlation]}
		[WHERE search_condition]
	stuff deleted . . .
		[FOR [DEFERRED | DIRECT] UPDATE OF column {, column}]

	Dynamic SQL form:
	EXEC SQL DECLARE cursor_name CURSOR
		FOR statement_name;

Note that there is no UPDATE phrase in the dynamic SQL syntax.

Any pointers would be appreciated.
--
Christopher Hylands			University of California
cxh@argon.berkeley.edu			ERL/Microlab  406 Cory Hall
ph: (510)642-2716 fax:(510)642-2916	Berkeley, CA 94720-0001
Newsgroups: comp.databases.ingres
From: gfowler@javelin.sim.es.com (Gary Fowler)
Subject: Those Forking Cursors!
Organization: Evans & Sutherland Computer Corporation
Date: Tue, 29 Sep 1992 18:38:06 GMT

I need some help with an ingres problem.  I hope some of you guru's can
help me.  I wrote an embedded sql program in C which acts as a server
to a number of clients.  Depending on the request it performs the
appropriate query and returns the data to the client.  Usually the query
can be served in a couple of seconds but there is one case where the client
needs a lengthy report.  This can take over a minute, depending on the
set of data being requested.  In order to be more responsive, I decided
to take advantage of the multi-processing capability that UNIX offers.
If the request is time consuming I decided to do a fork and let the child
process service the lengthy request.  The parent process is then free to
handle other requests.  First I found that I had to disconnect from ingres
before the fork and then reconnect in the parent and child processes.  The
child process then performs the ingres functions which include nested cursors.
The child process exits after it has completed it's job.  

This all works fine most of the time.  The problem arises when the parent
process services another request which involves a cursor.  The child processes
cursor gets stepped on by the parent processes cursor.  It manifests itself with
an ingres error 1303 "Read error on cursor reportcrsr."  I found that a cursor
uses a temporary file, and ingres controls the temp file name.  Part of this
file name is the process ID in hex.  When the process forks, both child and
parent have the same copy of the next file name to use, which includes the
process ID of the parent.  Therefore one process will over write the other
processes cursor file.

I hope this explaination is clear enough.  I would really appreciate it if
someone could give me some insight on how to solve the problem.  I would like to
avoid "exec"ing a new process.  I just don't understand why ingres doesn't
reinitialize it's temp file name to use the child's process ID when I reconnect.

********************************************************************************
*     Gary Fowler                     *     The storm starts when the drops    *
*     gfowler@esunix.sim.es.com       *     start dropping.  When the drops    *
*     Evans & Sutherland              *     stop dropping then the storm       *
*     600 Komas Drive                 *     starts stopping.                   *
*     Salt Lake City, UT              *     -Dr. Seuss                         *
********************************************************************************
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Reportwriter parameters
Organization: Palmer & Associates, Inc.
Date: Tue, 29 Sep 1992 20:56:55 GMT

Please include more specifics, such as operating system type, version, etc.
Many operating systems impose command line length limits.  For example, the
VMS command line (and in fact the VMS input line) length is limited to 255
characters.  This may be the limit you are bumping into.

-- 

Steve Caswell           |   (404) 448-7727    |  "The opinions expressed are my
Principal Consultant    |   sfc@tpghq.com     |   own.  They may not be perfect,
The Palmer Group        |   uunet!tpghq!sfc   |   but they're all I've got."
Newsgroups: comp.databases.ingres
From: DELFT UNIV OF TECHNOLOGY/COMP CENTRE +31 15 784821 <Jan.vanSetten@RC.TUDelft.NL>
Subject: Re: Problem with $ckpdb in 6.4/02/00
Organization: National Radio Astronomy Observatory
Date: Tue, 29 Sep 1992 10:03:41 GMT

Hi Lloyd & Mark,

Running earlier INGRES versions 6.* on VMS we found that failing
of CKPDB depends on the privilige of the user performing the CKPDB
command for the _first_ time in the database life time. The reason
seemed to be: file ownership.

result      |               user running CKP_#
            |            #1                            #2
------------+----------------------------------------------------------
Error       |        ($)INGRES               DBA/non_Ingres_superuser
No problems |    DBA/non_Ingres_superuser          ($)INGRES
------------+----------------------------------------------------------

We tested 6.4 on a SUN SPARC and found no troubles at all.

Jan.

>----------------------------------------------------------------------<
 A. van Setten                   | post to:  Post Office Box 354
 Delft University of Technology  |           2600 AJ DELFT
 Computing Centre                |           The Netherlands
 Campus Ingres Support           | ship to:  Julianalaan 134
 Phone   :  +31 (0)15-78 4821    |           2628 BL DELFT
   "     :  +31 (0)15-78 5012    |           The Netherlands
 Fax     :  +31 15-78 3787       | visitors: Michiel de Ruyterweg 10-12
 E-mail  :                       | RC-
     Jan.vanSetten@RC.TUDelft.NL | Helpdesk: Info@RC.TUDelft.NL
>----------------------------------------------------------------------<

========================================================================
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: SQL TM \nocontinue
Organization: Palmer & Associates, Inc.
Date: Mon, 28 Sep 1992 21:41:49 GMT

x
>Subject: SQL TM \nocontinue
>
>Am I doing something wrong, misunderstanding something, or does \nocontinue
>not actually work as documented in the SQL terminal monitor:
>
>DAG# sql sid                         
>INGRES TERMINAL MONITOR -- Copyright (c) 1981, 1992 Ingres Corporation
>INGRES SunOS Version 6.4/01 (su4.u42/01) login Sat Sep 26 14:44:14 1992
>
>continue
>* \nocontinue
>go
>* xxx\g
>Executing . . .
>
>E_US09C4 Syntax error on line 1.  Last symbol read was: 'xxx'.
>(Sat Sep 26 14:44:21 1992)
>
>continue
>* select count(*) from todosteps\g
>Executing . . .
>
>
>+-------------+
>|col1         |
>+-------------+
>|            5|
>+-------------+
>(1 row)
>continue
>* \q
>Your SQL statement(s) have been committed.
>
>INGRES Version 6.4/01 (su4.u42/01) logout
>Sat Sep 26 14:44:33 1992
>
>I got the same behavior setting II_TM_ON_ERROR=terminate.
>
>/a

I believe 'nocontinue' is only effective for statements within the same
\g grouping.  Once the tm sees \g, it resets its continue scope.  For example,
the second statement would not be executed from the group below:

   * xxx;
   * select column from table;   (nocontinue causes this one to be skipped)
   * \g

, but as your sample shows, the second statement is executed when group as:

   * xxx;
   * \g
   * select column from table;   (this statement is not skipped)
   * \g

So \nocontinue is not an effective way of skipping the remainer of an
include script when the commands are separated by \g

-- 

Steve Caswell           |   (404) 448-7727    |  "The opinions expressed are my
Principal Consultant    |   sfc@tpghq.com     |   own.  They may not be perfect,
The Palmer Group        |   uunet!tpghq!sfc   |   but they're all I've got."
Newsgroups: comp.databases.ingres
From: bernward@rcc.de (Bernward Averwald)
Newsgroups: comp.databases.ingres
Subject: Windows 4GL problems (screen refresh)
Date: 6 Oct 92 13:08:05 GMT
Organization: Home

After converting my Windows 4GL application for running on
multiple platforms (see Programmers Guide for INGRES/Windows 4GL:
Creating a Portable Form; that is grouping fields to stack/matrix fields), 
I have some problems with the number of screen refreshs after 
event blocks.
The form is updated several times after an event block is executed.
I suppose that the form gets an refresh event after every event block,
even after user events that are triggered by other event blocks.
Now my question: how do I disable unnecessary screen refreshs?

Any help is appreciated!

Bernward
-- 
        Bernward Averwald, Heinrichstr. 42, 4600 Dortmund 1, Germany
        Voice: +49 231 144048, FAX: +49 231 144047,  email: b@rcc.de
	               Der mit dem Golf fdhrt.
Newsgroups: comp.databases.ingres
From: "Larry Deni @ Computer Center" <DENI%canisius.bitnet@CUNYVM.CUNY.EDU>
Subject: Re: database locations/areas in UNIX
Organization: National Radio Astronomy Observatory
Date: Fri, 25 Sep 1992 15:55:00 GMT

>However, under UNIX, everything is different.  It seems that each area
>is hard-wired as a particular directory, with no level of indirection as
>what we get from the VMS logicals.  I know that the UNIX equivalent of
>logicals (for this purpose) are symbolic links.  However, I read
>somewhere (the INGRES I & O Guide?) that you shouldn't use symbolic
>links with INGRES for a variety of reasons.
>
>What schemes are people using?
>
>--Mark Jaeger                          internet: cs_mj@gsbvax.uchicago.edu
>Graduate School of Business            yellnet:  (312) 702-0328
>University of Chicago                  faxnet:   (312) 702-0233
>

Under VMS we pretty much follow what you describe.  When I first installed
Ingres under unix (Ultrix) I tried to implement the same techniques.
I was not able to do it.  The following convinced me to stop trying
at least until ASK/Ingres improves the situation:

    DUMP one of your VMS aaaaaaaa.cnf files and note that the disk names
    recorded in the file are your logical names.

    Dump (od -a) one of your unix aaaaaaaa.cnf files and note that the
    disk names are hardwired into that file.

That is, not only are the AREAS in ACCESSDB hardwired, but the cnf file
is additionally hardwired with the translation of the area name.

What I tried at the time, and was hoping would work, was using ingset
to set up an Ingres environment variable pointing to the disk area,
and then use the environment variable in ACCESSDB to define the
location of the area.  ACCESSDB would not accept the environment variable,
it only wants a physical disk location.  It seems to me that if ASK/Ingres
wanted to implement this technique, using an Ingres environment variable
would be the place to do it.

Larry Deni                                   BITNET: deni@canisius
Canisius College, Buffalo, NY              INTERNET: deni@canisius.edu
Newsgroups: comp.databases.ingres
From: rayt@rtsl.demon.co.uk (Ray Turner)
Subject: RFI: INGRES under DOS 
Distribution: world
Organization: Ray Turner Systems Ltd
Date: Sat, 26 Sep 1992 07:37:35 +0000


In article <1992Sep24.154653.1@gsbacd.uchicago.edu> cs_mj@gsbacd.uchicago.edu writes:

>
>RFI: INGRES on DOS
>
>Does anyone out there have experience with using DOS machines for INGRES
>front ends?  I'm interested in knowing how it works/performs not only
>for production front-end work (QBF, report writer, ABF or ESQL/C
>applications, etc.), but also as a development environment (ABF, ESQL/C,
>VIFRED, etc.).
>
> Stuff deleted...
>
>Any comments?  TIA for help.
>
>--Mark Jaeger                           internet: cs_mj@gsbvax.uchicago.edu
>Graduate School of Business             yellnet:  (312) 702-0328
>University of Chicago                   faxnet:   (312) 702-0233
>
>
Mark, The standard front end tools do seem to work, but are subject to
a number of restrictions, and incompatibilities. This is however true
of most PC software <g>

I have used the tools and ESQL/C a lot but not ABF, so perhaps someone 
else will mention that. However,  the problems I have had are as follows:

1. You have to link your esql/c with an Ingres supplied DOS extender to
   allow it to break the 640K barrier. This is not always compatable with
   other DOS software. I had problems with QEMM and with Windows 3.1.

2. All of your esql/c progs need to include a file called compat.h which
   typedefs all ints to long. This is so that Ingres can use 32 bit ints
   everywhere. This is *very* dangerous if you call other libraries!!
   You also need to use %ld rather than %d in printfs etc. It is easy to
   forget this as you think you are using ints.

3. Ingres/Net for DOS is very slow. A retrieval that takes 10 seconds on
   a HP 9000/720 (4000 rows) takes 90 secs on a 486/33. This problem 
   applies to all of the DOS tools as well.

4. You are stuck with the debugger supplied with the DOS extender which
   with the verion we had was undocumented and only at the assembler level.

   However, that said I have ported a number of medium sized esql/c
   progs to DOS and they do work, so what Ingres say is true but it 
   is not without problems.


   Ray Turner.


--------------------------------------------------------------------------
Ray Turner                               Internet  : rayt@rtsl.demon.co.uk
Ray Turner Systems Ltd,                  Compuserve: 100016,160
Leatherhead, Surrey KT22 9NS England.    Cix       : rayt
--------------------------------------------------------------------------
Newsgroups: comp.databases.ingres
From: ncourdy@endor.sim.es.com (Nabil Courdy)
Subject: Multiple Ingres 6.3 servers on a Sequent
Summary: Multiple Ingres 6.3 servers on a Sequent
Organization: Evans & Sutherland Computer Corporation
Date: Fri, 2 Oct 1992 15:29:07 GMT

We are running Ingres 6.3 on a 2-CPU Sequent/2000.  The system is configured
to run with 2 Ingres servers (fast_commit, write_behind, and shared_chache).
Lately we noticed a significant degradation in performance.  It is taking up
to 30 seconds to enter the sql terminal monitor.  As a test, I started a 3rd
ingres server and dedicated it to the development databases using the -dblist
server parameter. Other parameters are (fast_commit,write_behind, and 
sole_server).  Performance does not seem to have improved.  The log file is
only at 13% usage when we notice the degradation.  Tables are structured and
optimized and there are no overflow pages.  Does anyone have any clues please ?
Also the 3rd server has no iislave processes associated with it (Why?)

Thanks, Nabil
-------------

********************************************************************************
* Nabil Courdy							               *
* EMAIL: ncourdy@zephyr.sim.es.com				               *
*								               *
********************************************************************************