HDTenEightyP/NetNews huggingface dataset:
From: cdkeen@probitas.cs.utas.edu.au (Chris Keen)
Subject: Sole server access (Q)
Organization: University of Tasmania, Australia.
Date: Wed, 11 Nov 1992 12:58:34 GMT

I am running an ABF application under Ingres v6.3.
As part of that application I want to extra the audit trails using
auditdb. When I attempt to do so via a system call from within ABF
I get a DB BUSY - Being Access by a Sole Server
error message. This only occurs when auditdb is called while ABF
is also accessing the same database.

Any suggestions on how to get auditdb to do its job from within ABF?

chris

--
Chris Keen				AARNet: C.D.Keen@cs.utas.edu.au
Dept of Computer Science		Phone:  002-202906    (Australian)
University of Tasmania			        +61-02-202906 (international)
GPO Box 252C, Hobart, Tasmania  7001    Fax:    +61-02-202913
From: walter@faber.faps.uni-erlangen.de (Stefan Walter)
Newsgroups: comp.databases.ingres
Subject: Embedded SQL/C-Procedures in Windows 4GL Applications???
Date: 11 Nov 1992 16:09:03 GMT
Organization: Institute for Manufacturing Automation, Erlangen, Germany
NNTP-Posting-Host: neumann.faps.uni-erlangen.de

Hi,

can anybody out there tell me if its possible to
call Embedded SCL/C-Procedures from Windows 4GL Applications.

If yes, how can we do that?

Any hint would be most helpful. 

Thanks in advance, 
 Stefan

P.S.: Please Email to following address, 'cause I dont read that
newsgroup regulary.
------------------------------------------------------------------------------  
  Stefan Walter                      |  EMail: walter@faps.uni-erlangen.de 
  University Erlangen                |  Mail:  Uni Erlangen, Egerlandstr. 7, 
   __                                |         W-8520 Erlangen, Germany
  /_  |   /                          |  Phone: *49 9131 857711
  __/ |/|/                           |  FAX:   *49 9131 302528
------------------------------------------------------------------------------  




Newsgroups: comp.databases.ingres
From: tfd@laurel.mit.edu
Subject: ABF Image building on Ultrix 4.2 - Ingres 6.4/02
Organization: National Radio Astronomy Observatory
Date: Fri, 6 Nov 1992 11:57:26 GMT


When running imageapp with the -f option to force recompilation of the
whole application a number of the compiles emit this warning message:

	Compiling 'perselct.osq' . . .

	uopt:	Warning: II02001persdisp: this procedure not optimized
		because it exceeds size threshold; to optimize this
		procedure, use -Olimit option with value >= 1095.
	Compilation succeeded.


The value specified (in this case 1095) is different every time the
warning is issued.

My question is (questions are):

	What is "uopt"? This seems to be the component or subsystem
	issuing the message. But what is it?

	How do I specify the "-Olimit" option whne doing imageapp or
	when building the image from within ABF?

Thanks for any help on this.

--Tim Dempsey
  MIT
Newsgroups: comp.databases.ingres
From: Angela.M.Wubbels@let.ruu.nl
Subject: ingres 6.4 and ultrix 4.3
Organization: Faculty of Arts, University of Utrecht, The Netherlands
Date: Tue, 10 Nov 1992 12:03:00 GMT

I have heard rumours that ingres 6.4 has problems with ultrix 4.3.
Does anyone know something more about this?

Angela Wubbels
University of Utrecht
Newsgroups: comp.databases.ingres
From: object@ibmpcug.co.uk (Ken Tough)
Subject: ESQL seems to affect blocking reception in TCP/IP
X-Disclaimer: The views expressed in this article are those of the author
	alone and may not represent the views of the IBM PC User Group.
Organization: The IBM PC User Group, UK.
Date: Fri, 6 Nov 1992 20:03:01 GMT
Keywords: esql, blocking, polling

It seems that C programs which use ESQL have troubles blocking on
TCP/IP port operations.  (Ingres 6.4xxx SCO UNIX 3.2v4.0).

If a program connects to a database, and also does some other reads/
writes on, for example, UDP (SOCK_DGRAM) ports, then the reads will
not block.  In fact, you get a E_WOULD_BLOCK error message.  If you 
then print something to, for example, stderr, the port will subsequently
block as you would expect.

After the next SQL operation, though, the port goes back to non-blocking
mode.  It seems Ingres is screwing up the blocking modes.  This is a big
problem when the programs run as handlers  "in the background", since they
end up polling on the UDP sockets (which are unrelated to the database
parts of the routine.)  This means CPU times for those processes steadily
climb, since they appear to be "busy waiting".

A workaround seems to be printing between database operations and port
read()s, but this is not nice.  
Does anyone have any experience on this?
Newsgroups: comp.databases.ingres
From: sieh@csn.org (David Sieh)
Subject: Case Studies of Distributed Databases in Ingres
Organization: University of Colorado, Boulder
Date: Thu, 12 Nov 1992 03:59:22 GMT


We are starting a project in which we must make a set of databases
available to users over a wide area network...
We are looking for help/advice in designs/implementations of
similar database systems...We are especially interested in case studies.

We are curious about designs/implementations of different architectures
such as:
1. Centralized database servers that users log into to run their
   applications...
2. Truly distributed databases...i.e. data distributed amoung several
   database severs with no redundant data....has the appearance of
   a single database....
3. Distributed databases with redundant data stored at some sites...
   ...strategies for keeping databases consistent and strategies
   for updating each db...
4. Other????

To give a few more specific characteristics of the system we are
working with:

* There is a possibility that Ingres might be used (especially if
  any successful distributed db case studies with Ingres)
* A wide area network is already installed 
* All machines over the network "talk" TCP/IP
* There is a near real-time data collection/distribution component
   (i.e. data collected about once an hour needs to be made 
    available to users over the network)
* Most of the data queries need to be through interactive
  data communications...i.e. not batch transfer of files or
  media transfer...

Responses sent directly to me would be greatly appreciated...
(unless you feel this would be of interest to other readers in
this news group)

Thanks -

David Sieh
sieh@cadswes.colorado.edu
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: Data Access Language for Ingres
Date: 9 Nov 92 01:55:50 GMT
Organization: Not Organized

In article <1992Nov7.212317.28663@sys.uea.ac.uk> sm@sys.uea.ac.uk (Shaun McCullagh) writes:
>
>
>Does anybody out there know if DAL is available for INGRES yet?
>

We have bought (but not received) the version for VMS...

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: macdonal@westford.ccur.com (Steve MacDonald)
Subject: ABFimage question
Organization: Concurrent Computer Corp.  Westford, MA
Distribution: usa
Date: Tue, 10 Nov 1992 19:09:46 GMT

I have a question regarding abfimage creation. When I attempt to create an
executable of my main menu selection, I get the following compilation messages.

abfimage eco main_menu -f
Concurrent INGRES APPLICATION/IMAGE -- Copyright(c) 1988,1989 Ingres Corporation
Compiling update_eco_data.osq
No errors
        ...
mv: /user/ingres_db/ingres/eco/main_menu/update_eco_data.o and /user/ingres_db/i
ngres/eco/main_menu/update_eco_data.obj are identical
Compiling main_menu.osq
No errors
        ...
Compiling retrieve_eco_data.osq
No errors
        ...
mv: /user/ingres_db/ingres/eco/main_menu/retrieve_eco_data.o and /user/ingres_db
/ingres/eco/main_menu/retrieve_eco_data.obj are identical
Compiling enter_eco_data.osq
No errors
        ...
mv: /user/ingres_db/ingres/eco/main_menu/enter_eco_data.o and /user/ingres_db/in
gres/eco/main_menu/enter_eco_data.obj are identical
Compiling enter_part_data.osq
No errors
mv: /user/ingres_db/ingres/eco/main_menu/enter_part_data.o and /user/ingres_db/i
ngres/eco/main_menu/enter_part_data.obj are identical
Compiling retrieve_part_data.osq
No errors
        ...
mv: /user/ingres_db/ingres/eco/main_menu/retrieve_part_data.o and /user/ingres_d
b/ingres/eco/main_menu/retrieve_part_data.obj are identical

E_AB0124 Application build compilation errors.
    There were compilation errors for at least one of the source files for
    the application.  These problems must be corrected before the
    application can be run or before an application image can be built.

E_AI0002 The application image was NOT built.
    An earlier error prevents the application image from being built.
    Correct the cause of the earlier error and then run abfimage again.

The text is clear as mud regarding the error messages. Now when I manually
compile each application, they compile fine. Has anybody had any previous
experience with this problem?


					Thanks,
				       Steve MacDonald

Newsgroups: comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: Finding all tables and table definitions.
Keywords: SQL, Windows4gl, tables
Organization: U.S Dept. of Transportation
Date: Wed, 11 Nov 1992 18:18:36 GMT

To list Ingres table names and columns, all you gotta do is query the
Ingres System Catalogs.  In particular, in the terminal monitor, execute
the command   help iicolumns   .  The query to do (minimally) what you
want is   select table_name, column_name from iicolumns   .  You might
want to tack on    where table_owner!='$ingres'    to exclude system
tables from the list.  Of course, you can stick this query into an
embedded C program of W4GL or whatever.

Seth Grimes, dcatlas!sethg@uunet.uu.net
Automated Sciences Group (U.S. Dept. of Transportation)
Newsgroups: comp.databases.ingres
From: hkau@jyu.fi (Harri J Kaukovuo)
Subject: Re: Ingres Advisor
Organization: University of Jyvaskyla, Finland
Date: Thu, 12 Nov 1992 17:35:46 GMT

In article <ASH.92Nov12100700@ulysses.mr.ams.com> ash@ulysses.mr.ams.com (Alan Harder) writes:
>
>I have had some good experiences with Advisor lately that I'd like to
>share.  First, Ingres has entered the 20th century by making Internet
>access available.  Just "telnet advisor.ingres.com".  This is much
>easier (for me) than dialing the 800 number or even using Compuserve
>for access.  It was not published in the last Advisor document that
>was sent out.
>
>
>Also, the new TSConnect feature is really nice.  I was able to log a
>call, get an answer, check on the status of my call, and ask for
>further information, all without having to pick up a phone.
>
>
>All in all, a good job done on this by Ingres.
>
>
>
>-Alan Harder
> 
>These opinions are mine.  You can't have them.  Stop, thief!

What is this Advisor stuff? I don't know anything about it.

---
Harri Kaukovuo		hkau@tukki.jyu.fi


-- 
---
Harri Kaukovuo					hkau@kalikka.jyu.fi


Newsgroups: comp.databases.ingres
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Subject: Re: Sole server access (Q)
Organization: Columbia University
Date: Wed, 11 Nov 1992 14:09:12 GMT

In article <cdkeen.721486714@probitas> cdkeen@probitas.cs.utas.edu.au (Chris  
Keen) writes:
 ...
> Any suggestions on how to get auditdb to do its job from within ABF?

Not that even if you could get auditdb to work from within your application,
the next problem you will discover is that it lags behind in reporting recent
database activity (see the manual).  What's happening is auditdb only tells
you what's in the journal files.  However, recently-committed transactions
have not yet made it from the transaction log file to the journal as this
is done asynchronously by the archiver and only periodically (based on
a logging system tuning parameter).  So, auditdb may not show you what you
want to know.  If you have KME, you might want to hang a procedure off each
table you want to audit and have it automatically write records to a history
table.

/a
Newsgroups: comp.databases.ingres
From: chou@csd.hku.hk (Chou Sui Lin)
Subject: Ingres errors
Organization: National Radio Astronomy Observatory
Date: Fri, 13 Nov 1992 07:15:31 GMT



Ingres Guru:

Lately, we've seen quite a lot of these error messages in errlog.log.
But the RDBMS server seems to be running alright all but a bit sluggish.
We've configured two Ingres DBMS servers with following parameters on
a Sun 670MP with 128MB RAM and over 400MB swap space running SunOS 4.1.2
and Ingres 6.4.2.

      ::[3400            , 00562040]: Thu Nov 12 11:58:24 1992 E_SC022F_BAD_GCA_READ	SCF was unable to read a GCF block.
      ::[3400            , 00562040]: Thu Nov 12 11:59:09 1992 E_CLFE07_BS_READ_ERR	Read from peer process failed; it may have exited.
System communication error: Connection reset by peer.

As I understand SunOS 4.x has 256 max open file descriptor per process.
and I don't know if Ingres calculate its own max # of open files from
the no. of connected sessions set by "-connected_sessions".
      ::[2746            , 002CB248]: Tue Nov 10 14:39:30 1992 E_CLFE04_BS_ACCEPT_ERR	Unable to accept imcoming connection.
System communication error: Too many open files.

The parameter file for default DBMS server (where development users 
attached)
-names
-connected_sessions 48
-active_sessions 48
-cursors_per_session 16
-database_count 32
-stack_size 65536
-sole_server
-fast_commit
-write_behind 6
-psf.memory 12288000
-opf.memory 12288000
-qsf.pool_size 6144000

The parameter file for production server
-names
-connected_sessions 32
-active_sessions 32
-cursors_per_session 16
-database_count 32
-stack_size 65536
-sole_server
-dblist stpmdb01
-fast_commit
-write_behind 4
-psf.memory 8192000
-opf.memory 8192000
-qsf.pool_size 4096000

Thanks in advance
chou@csd.hku.hk

Newsgroups: comp.databases.ingres
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Subject: Re: Insert in ESQL/C
Organization: Columbia University
Date: Wed, 11 Nov 1992 14:15:49 GMT

In article <1992Nov11.132503.8082@mlb.semi.harris.com>  
cbh@opus.mlb.semi.harris.com (Cherie Slasor) writes:
> I was wondering if anyone could help me with a problem I'm having with
> ESQL using C.  I've used ESQL for a long time but had never tried doing
> an insert with it.  That's what I'm trying to do now and it isn't 
> inserting the data into the database.  The syntax I'm using is:
> 
> EXEC SQL INSERT INTO table_name (
> 			field_1,
> 			field_2,
> 			field_3
> 		   )
> 		   values (
> 			:variable_1,
> 			:variable_2,
> 			:variable_3
> 		   );
> 
> I can't find anything in the manuals that gives the exact syntax for an
> insert in ESQL so I'm assuming it's the same as for SQL.  When I run the
> debugger I find that it's definitely connecting to the database, because
> it retrieves the correct data in all the right places.  The variables
> are all being defined correctly.  The program runs very happily and never
> crashes or gives an error message or anything.  The SQLCA error codes
> seem to say that everything worked:
> 
> (dbx) p sqlca
> sqlca = {
>         sqlcaid = "SQLCA   "
>         sqlcabc = 136
>         sqlcode = 0
>         sqlerrm = {
>                 sqlerrml = 0
>                 sqlerrmc = "                                                                       
"
>         }
>         sqlerrp = ""
>         sqlerrd = (0, 0, 1, 0, 0, 0)
>         sqlwarn = {
>                 sqlwarn0 = ' '
>                 sqlwarn1 = ' '
>                 sqlwarn2 = ' '
>                 sqlwarn3 = ' '
>                 sqlwarn4 = ' '
>                 sqlwarn5 = ' '
>                 sqlwarn6 = ' '
>                 sqlwarn7 = ' '
>         }
>         sqlext  = ""
> }
> 
> But the data is not being added to the database.  Any ideas?
> 
> Cherie Slasor
> 			
> -- 
> ====================================================================
> Cherie Slasor			     |	Harris Semiconductor
> Phone:    (407) 724-7607	     |	P.O. Box 883, MS #62B-022
>           cbh@mlb.semi.harris.com    |  Melbourne, FL   32902-0883

Have you set "exec sql whenever sqlerror sqlprint" and 
"exec sql whenever sqlwarning sqlprint" (or something close to that)?

Did you print the value of sqlca in dbx at the right point in time
(e.g. before a commit or far enough after the code generated by ESQL/C
had a chance to fill in the values in it)?  Doing the "whenevers" above
would obviate the need to check it with dbx.  Are your source code line
numbers in the debugger correct?  Sometimes the esqlc preprocessor makes the
line numbers off by a few lines for me when using gdb (also try and/or remove
the -p switch).

Exact syntax for ESQL/C is in the ESQL Companion Guide for C.  General
syntax is in the SQL reference.

/a
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Insert in ESQL/C
Organization: 
Date: Wed, 11 Nov 1992 22:35:25 GMT

In article <1992Nov11.132503.8082@mlb.semi.harris.com>, 
cbh@opus.mlb.semi.harris.com (Cherie Slasor) writes:
> I was wondering if anyone could help me with a problem I'm having with
> ESQL using C.  ...I'm trying to [insert] now and it isn't 
> inserting the data into the database.  The syntax I'm using is:
> 
> EXEC SQL INSERT INTO table_name (
> 			field_1,
> 			field_2,
> 			field_3
> 		   )
> 		   values (
> 			:variable_1,
> 			:variable_2,
> 			:variable_3
> 		   );
> 
> I can't find anything in the manuals that gives the exact syntax for an
> insert in ESQL so I'm assuming it's the same as for SQL.  When I run the
> debugger I find that it's definitely connecting to the database, because
> it retrieves the correct data in all the right places.  The variables
> are all being defined correctly.  The program runs very happily and never
> crashes or gives an error message or anything.  

I can think of two possibilities that might mislead you into thinking
that the insert failed to actually put something in the table:

1. You tried to select the data that was just inserted from another
session, but before the first session had committed its transaction. 
You can't do this, because database changes are visible _only_ to the
session that made them until after the changes have been committed.  So
you must either try to select the data from the same session, or commit
the transaction first and _then_ look for it from the second session.

2. Your table has an integrity on it and the input data violated it. 
When using integrities, it's important to realize that inserts and
updates may fail _silently_.  In other words, the violation of an
integrity causes no SQL error (sqlcode = 0), and the only indication you
get is that the rowcount doesn't match what you'd expect.  In your case,
you're safe:

> The SQLCA error codes seem to say that everything worked:
...
>         sqlerrd = (0, 0, 1, 0, 0, 0)
			   ^

The third element of the sqlerrd array gives the rowcount.

--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.

Newsgroups: comp.databases.ingres
From: liland@hsr.no (Trygve Liland)
Subject: Dateformat in 6.4
Organization: Rogaland University Centre
Date: Thu, 5 Nov 1992 17:53:19 GMT



I have a problem with the date datatype in Ingres. I use Embedded SQL from
my C program. Input to the database is OK, so is the data in the database, 
but when it comes to output from the db and into my C variable I have a problem.

I have tried to get the date as date_gmt, but it comes out 6 hours wrong, and
that is not only in my C program but also in ISQL. My platform is HP 730,
HP-UX 8.05. (That is 6 hours wrong GMT)

Is there a way to get the date, just as it is in the db ?? I have tried most 
off the possibillities in the manual, but it still doesn't comes out rigth.
Is it a familiar problem ?, AND is there a solution to it ??

Please respond by email, I rarly have the opportunity to read this group.
Thanks in advance
-- 
+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+|+
Trygve Liland 			e-mail : liland@hsr.no
SoftWare Engineer		    or : liland@ifi.hsr.no
Unique A/S
N-4300 SANDNES			Phone  : +47 04 662841 (home)
NORWAY				       : +47 04 624044 (Unique)	       

		"Steal a litle and they throw you in yail,
		  steal alot and they make you king" 
				Bob Dylan.
Newsgroups: comp.databases.ingres
From: Marco Olivieri <OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT>
Subject: Re: Data Access Language for Ingres
Organization: National Radio Astronomy Observatory
Date: Tue, 10 Nov 1992 08:36:00 GMT

Hello,

We use DAL for VMS, it's a language for database query.
The interface can be a Hypercard-type, if you know the HyperTalk  language or
you can build a Macintosh Application in 3Gl using C or Pascal  language.
It is necessary to have a Network for Macintosh and a Server on Host.

   Marco O.
Newsgroups: comp.databases.ingres
From: fmn@nevada.edu (FRANK NEEDHAM)
Subject: INGRES FAQ???
Organization: University of Nevada System Computing Services
Date: Tue, 10 Nov 1992 06:29:03 GMT

Hi people,

Is there anyone out there who knows where a faq for ingres resides and would 
be able to show me where it is?

thank you much,
-frank
From: sm@sys.uea.ac.uk (Shaun McCullagh)
Newsgroups: comp.databases.ingres
Subject: Data Access Language for Ingres
Date: 7 Nov 92 21:23:17 GMT
Organization: University of East Anglia
X-Xxmessage-Id: <A721E49B5701042E@sm.sys.uea.ac.uk>
X-Xxdate: Sat, 7 Nov 92 21:24:43 GMT
X-Useragent: Nuntius v1.1.1d12



Does anybody out there know if DAL is available for INGRES yet?




Shaun McCullagh (RA)
School of Information Systems.,
University of East Anglia.,
Norwich
England NR4 7TJ

sm@uk.ac.uea.sys ( JANET )      	       	Tel +44 603 592307
sm@sys.uea.ac.uk ( Other Nets ) 	       	FAX +44 603 507720

*******************************************************************
Life is like sanscrit read to a donkey -- Lou Reed
*******************************************************************
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: ESQL to EQUEL filter
Organization: 
Date: Tue, 10 Nov 1992 19:50:21 GMT

In article <1992Nov9.224638.2895@cs.brown.edu>, san@cs.brown.edu 
(Sergio Antonio Nakai) writes:
> 	We are looking for a filter that translates ESQL code to EQUEL.  
> Does such a filter exist?  Any help will be greatly appreciated.

If there isn't such a filter, then there's certainly something like it,
and Ingres wrote it.  

In the old days of version 5 (remember that?), INGRES had only partial
support for SQL.  To compile an ABF application, it had to do several
steps:

1. compile x.osq to x.osl, translating SQL into QUEL
2. compile x.osl into x.qc, translating OSL code into EQUEL/C code
3. compile x.qc into x.c, translating EQUEL/C code into C code
4. compile x.c into x.obj, using standard C compiler

You're looking for something like the first piece.  Call your salesman
and see if they'll sell it to you.  I know they still sell version 5.

--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: arzt@dccs.upenn.edu (Noam H. Arzt)
Newsgroups: comp.databases.ingres
Subject: Re: Data Access Language for Ingres
Date: 9 Nov 92 03:09:00 GMT

In article <1992Nov7.212317.28663@sys.uea.ac.uk> sm@sys.uea.ac.uk (Shaun  
McCullagh) writes:
> 
> 
> Does anybody out there know if DAL is available for INGRES yet?
> 

Definitely. The original DAL server written by Apple for VMS supported  
Ingres. The new Unix DAL servers are developed by Pacer Software and  
support Ingres.

--
Mr. Noam Arzt                            215/898-3029 (voice)
Director, Special Projects               215/898-9348 (FAX)
University of Pennsylvania               arzt@dccs.upenn.edu
Data Communications & Computing Services (NeXTmail is OK)  
Suite 221A, 3401 Walnut Street, Philadelphia, PA 19104