HDTenEightyP/NetNews huggingface dataset:
From: cbh@opus.mlb.semi.harris.com (Cherie Slasor)
Newsgroups: comp.databases.ingres
Subject: Re: Insert in ESQL/C
Date: 11 Nov 92 14:06:12 GMT
Organization: Harris Semiconductor, Melbourne FL

Thanks anyway, but it's working now.  So ignore this request for help.....


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


-- 
====================================================================
Cherie Slasor			     |	Harris Semiconductor
Phone:    (407) 724-7607	     |	P.O. Box 883, MS #62B-022
          cbh@mlb.semi.harris.com    |  Melbourne, FL   32902-0883
Newsgroups: comp.databases.ingres
From: Gavin Trigg <gavin@asis.unimelb.EDU.AU>
Subject: Re: Sole server access (Q)
Organization: National Radio Astronomy Observatory
Date: Thu, 12 Nov 1992 23:18:45 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
> 
Chris,

Auditdb does not do its work through the server.  Moreover, it can't operate
on a database that is currently in use by a server configured as a Sole_server.
Therefore, unless the Sole_Server option is removed from the server, auditdb
cannot be run against databases currently in use in that server.  This applies
if there is *ANY* use of the database through the server NOT JUST ABF.
Presuming that application will eventually be run from a built image rather
than through ABF you'll need to reconsider your configuration.  That is, it
doesn't matter whether the database is being accessed through ABF or the
built image or some other method!

-- 
Gavin Trigg	Internet: gavin@asis.unimelb.EDU.AU
		Telephone: +61 3 344 6003 	Fax +61 3 347 4803
Data Base Administrator, Information Technology Services (ASIS),
The University of Melbourne, Parkville, Australia.  3052.
Newsgroups: comp.databases.ingres
From: joser@gfimda.uucp (Joe Rodriguez)
Subject: Re: ABFimage question
Date: Thu, 12 Nov 1992 03:41:11 GMT
Distribution: usa
Organization: Kraft General Foods

From article <1992Nov10.190946.24603@westford.ccur.com>, by macdonal@westford.ccur.com (Steve MacDonald):
> 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


Steve,

   We have gotten the same messages.  It is caused by the 4GL source files 
   (*.osq)  being too long.  Keep your source file within the standard Unix
   filename length of 14.  For example, change enter_eco_data.osq which is
   18 characters in length to entecodata.osq, which is only 14.  If possible,
   make them less than 14.  Keep the filenames short.  I know some platforms
   allow for long filenames for Ingres seems to stick to 14 as the max.  I
   believe they do this for Unix portability reasons.



+--------------------------+------------------------------------+
| Joe Rodriguez            |    ||   //    /====\    +=======   |
+--------------------------+    || //     ||         ||         |
| Kraft General Foods      |    |</       ||  ====   ||====     |
| General Foods-USA, IMD   |    || \\     ||    ||   ||         |
| Mailcode:  T12-1         |    ||   \\    \====/    ||         |
| 555 South Broadway       |------------------------------------+ 
| Tarrytown, NY  10591     | joser@gfceb   - ICES INGRES Host   |
| (914) 335-6059           | joser@gfimda  - IMD System         |
|                          | INTERNET/UUCP:  gfimda!joser@uunet |
| Pager: (212) 356-5116    |                 uunet!gfimda!joser |
+--------------------------+------------------------------------+
-- 
+--------------------------+------------------------------------+
| Joe Rodriguez            |    ||   //    /====\    +=======   |
+--------------------------+    || //     ||         ||         |
| Kraft General Foods      |    |</       ||  ====   ||====     |
Newsgroups: comp.databases.ingres
From: "Warren Spencer (613) 541-7068" <EV2WS1%MISX01@KINGSTON.ARPC.ALCAN.CA>
Subject: Re: Need info on Vigraf (or any charting tools ...)
Organization: National Radio Astronomy Observatory
Date: Thu, 5 Nov 1992 15:27:57 GMT

>Hello,

>  Has anyone use Vigraf before ?  I need to know what it does, as well as
>  the price for the product on HP 9000/700.

Hi,

I last used ViGraph in version 6.2, Vax/Vms.  It allows you to design simple 
line, bar and scatter graphs by specifying parameters to its front end.

In our case, we needed to create a scatter diagram, with dates along the X axis. 
Vigraph does not support dates on an axis, and provides a work-around in the 
manual.  I wrestled with the work-around for some time, but was not able to 
produce a graph to the users liking.  After working with technical support for a 
few hours, we determined that our requirements exceeded the capability of 
ViGraph.  We discontinued our license for the product at that point, since this 
initial exercise was an example of the least-complicated graphing requirement we 
were likely to have.

ViGraph is fine for _very_ simple graphing requirements, as long as they do not 
involve dates.  Anything more complicated would be better satisfied with a more 
sophisticated tool, such as SAS, RS-1 or PV-Wave.  These tools are most 
effective for ad-hoc usage, but are reasonably pricey.

We chose another route entirely - we code our graphs in C, and call GKS 
(Graphics Kernal System) primitives to draw the graph on the output device of 
the user's choice.  This approach is appropriate for standard graphs, as opposed 
to ad-hoc inquiries.

Regards,

Warren Spencer
Ingres Specialist
InCAD Corporation
Ottawa, Ontario
(613) 723-5452
From: Jan.vanSetten@RC.TUDelft.NL (DELFT UNIV OF TECHNOLOGY/COMP CENTRE +31 15 784821)
Newsgroups: comp.databases.ingres
Subject: local Ingres Meeting
Date: 4 Nov 92 11:19:05 GMT
Organization: National Radio Astronomy Observatory

On 2/12/92 will be held the 10th INGRES Users Group Benelux Meeting.
Location: Trade Fair Centre, Utrecht, the Netherlands. Time: 11 a.m.

The program has a variety of subjects:

          - INGRES/VisionPro, actual experiences
          - EXPRESS - a report generator for INGRES SQL
          - Experiences with workstations in an administrative environment
          - The distributed model
          - Technical Panel.

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: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: ingres 6.4 and ultrix 4.3
Organization: U.S Dept. of Transportation
Date: Wed, 11 Nov 1992 18:05:26 GMT

Angela.M.Wubbels@let.ruu.nl writes:

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

The scoop is that Ingres will not be "certified" to run under Ultrix 4.3
but that it should run all the same.  Ingres tech support told me 
personally and others as well that they will help users resolve problems
and will correct bugs.

Seth Grimes, dcatlas!sethg@uunet.uu.net
Automated Science Group (U.S. Dept. of Transportation)
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres errors
Date: 13 Nov 92 20:51:08 GMT

In article <9211121815.AA08359@csd.hku.hk>, chou@csd.hku.hk (Chou Sui Lin)
writes:

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

We've seen a lot of these messages, too.  I think it's an INGRES bug. 
I'm not aware of any problems that it might cause.

--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: mikes@Ingres.COM (Mike Schilling)
Subject: Re: ABF Image building on Ultrix 4.2 - Ingres 6.4/02
Date: 8 Nov 92 20:06:46 GMT

From article <01GQTMAJKBWYDCRZ1N@MATH.AMS.ORG>, by tfd@laurel.mit.edu:
> 
> 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
This error is coming from your C compiler, not from any INGRES facility.  The
compiler is evidently unable to optimize the ".c" files created by the
4GL compiler. The file $II_SYSTEM/ingres/files/utcom.def contains template
definitions for performing compiles.  If you look at the section headed
by "c" you will see the command line which performs the compilation,
and it should be straightforward to modify it to set a large value
for "-0limit".  
----------------------------------------------------------------------------
mikes@ingres.com = Mike Schilling, INGRES, An ASK Company, Alameda, CA
Just machines that make big decisions,
Programmed by fellows with compassion and vision.	-- Donald Fagen, "IGY"
From: brent@spss.com (Brent Lambert)
Newsgroups: comp.databases.ingres
Subject: Re: Shared libraries and Ingres
Date: 6 Nov 92 20:17:55 GMT
Organization: SPSS, Inc. - portable code group

In article <9211051642.AA20127@valandil.YP.sun386i>, melkor!valandil!mal (Michael A Leo) writes:
> 
> Hi,
> 
>   Our product uses Embedded C to access the tables
> in our Ingres database.  
> 
>   Unfortunately, Ingres does not supply libingres.so,
> so each of our binaries is 1/2 MB minimum, no matter
> how trivial.
> 
>   Has anyone solved this problem?  Is there a way to
> make a shared library out of libingres.a?  Will Ingres
> ship a shared library?

Probably.  What platform?

If you're using AIX 3, there are several options.  I'm not sure about
SUNOS or other UNIXes, but it's very likely that any UNIX variant that
supports shared libraries can support a shared version of the Ingres
library.  The only hitch would be if Ingres is doing "something funny"
in their library code.  And the only way to find out (Ingres probably
won't tell you directly) is to try it.

DISCLAIMER:  I haven't done this myself on any platform - I just began
             using Ingres - so don't make any promises.  I don't.

-- 
The above statements are not the opinions or policies of SPSS Inc.
The above statements may not be the opinions of Brent Lambert.
The first disclaimer is a policy of SPSS Inc.
Subsequent disclaimers are probably the opinion of Brent Lambert.
From: brendle@ise.fhg.de (Axel Brendle)
Newsgroups: comp.databases.ingres
Subject: Test please ignore
Summary: test
Keywords: test
Date: 5 Nov 92 17:05:23 GMT
Organization: FhG-ISE - Institute for Solar Energy Systems

----------------------------------------------------------------------------
Axel Brendle     MAIL: Fraunhofer Institute for Solar Energy Systems
                        Oltmannsstr. 22
                        D 7800 Freiburg, West Germany
                 PHONE: +49 (761) 4014 127    FAX: +49 (761) 4014 200
                 EMAIL: brendle@ise.fhg.de
----------------------------------------------------------------------------
From: ash@ulysses.mr.ams.com (Alan Harder)
Newsgroups: comp.databases.ingres
Subject: Ingres Advisor
Date: 12 Nov 92 15:07:00 GMT
Organization: American Math. Society


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!
Newsgroups: comp.databases.ingres
From: DELFT UNIV OF TECHNOLOGY/COMP CENTRE +31 15 784821 <Jan.vanSetten@RC.TUDelft.NL>
Subject: Finding all tables and table definitions
Organization: National Radio Astronomy Observatory
Date: Thu, 5 Nov 1992 11:42:58 GMT

Sunil Nariani writes on Nov 5 1992:

>Using sql monitor program, when I type 'help' it gives me
>a listing of all tables in the database and on typing
>'help tablename' I can find out the fields of the table.
>
>My question is how can I get this listing of which tables
>exist in a database and their field definitions using a C program
>with embedded sql or using Windows4gl ? 

Surely you can get those information using Standard Catalog
Interfaces (SCI). Those are SQL views to the internal System Catalogs
of Ingres ( = datadictionary). See SQL Ref. Manual Appendix D.

Example: SELECT * FROM iicolumns supplies you with a listing of
table_name, table_owner, column_name, column_datatype.

SCI's are guaranteed for new releases and so preferred above
System Catalogs.

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
>----------------------------------------------------------------------<
From: OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT (Marco Olivieri)
Newsgroups: comp.databases.ingres
Subject: 6.4/02 or 6.4/01, which version is the one available on SUN
Date: 12 Nov 92 11:25:00 GMT
Article-I.D.: ichcmns.C7F1FB044DDF202E38
Organization: National Radio Astronomy Observatory

Hello, 

I have a question for Ingres Users on SUN/UNIX.

-    What was the previous version of 6.4/02 ?
-    Was it the 6.3/02 ?
-    Otherwise has any of you the version 6.4/01 ?

The "ASK-ITALY" answered my request to switch from Ingres Version 6.3/02 to
Ingres Version 6.4  saying  that the  distribution of  6.4/02 has begun in
September and that version 6.4/01 is available not on SUN/UNIX, but only on
VAX/VMS. 
As a matter of fact, I have had the Ingres 6.4/01 since february on VAX/VMS,
and it seems bizarre that 6.4/01 is not yet available on SUN.

thank

  Marco O.
Newsgroups: comp.databases.ingres
From: rao@moose.cccs.umn.edu (Rao Akella)
Subject: Re: Finding all tables and table definitions.
Keywords: SQL, Windows4gl, tables
Reply-To: rao@moose.cccs.umn.edu
Organization: Colon Cancer Control Study, University of Minnesota, Minneapolis
Date: Wed, 11 Nov 1992 04:40:17 GMT


In article <1992Nov4.222139.9932@news.nd.edu>, nariani@zen.cc.nd.edu
(Sunil Nariani) writes:
> 
> My question is how can I get this listing of which tables
> exist in a database and their field definitions using a C program
> with embedded sql or using Windows4gl ? 

Pick up the file HOWBIGIS.SC via anonymous ftp from moose.cccs.umn.edu
[128.101.133.53] and follow the instructions contained therein.

If you do not have FTP access, please contact me somehow with some form
of
e-mail/paper-mail address, and I'll post it to you personally.

HOWBIGIS is a simple C program which uses Embedded SQL to determine the
disk space occupied (both used/allocated) and the file name of some/all
tables in an INGRES database.  Unfortunately, it runs currently only on
VMS, but it should be fairly easily portable to other platforms like
Unix (I don't have access to anything besides VMS, so I'm afraid I
can't
do it myself).  If nothing else, the code should be enough of an
example to help you understand how it works.

Here's the syntax:

Usage: howbigis [ -ah? ] [ -o file ] database [ table ... ]
Options:
  -a              display ALL tables (user AND INGRES system tables)
  -o file         save the display output into the filename "file"
  -h, -?          display this usage help information


-- Rao Akella    <rao@moose.cccs.umn.edu, rao%moose@umnacvx.bitnet>
Newsgroups: comp.databases.ingres
From: jstewart@alfred.carleton.ca (John Stewart)
Subject: Problem installing Ingres 6.4/02 under SunOS 4.1.3
Organization: Carleton University
Date: Fri, 13 Nov 1992 20:17:20 GMT

I just installed Ingres 6.4/02 on a Sparcstation 10 running SunOS 4.1.3 but
when it tries to start up it fails with the following error

---------------------- RESOURCE CHECKING COMPLETE -----------------------


Allocating 401408 bytes of shared memory...

!shmat for id 201 at address F4000000 fails
!errno = 22
!Can't map locking segment into memory at address FFFFFFFF
!Check or adjust the value of II_LG_MAP_ADDR
Could not create the system segment, does your kernel have enough
shared memory or has this program already been run?

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

Has anyone seen this problem before?  I'm not entirely surprised since
the release notes only guarantee that it works under 4.1.1 or 4.1.2.

I have also put a call into Ingres but they haven't gotten back to me yet.
-- 
John Stewart -- Computing and Communications Services, Carleton University
Internet: jstewart@ccs.carleton.ca or Mr.Canoehead@algonquin.carleton.ca  
"The average middle income family with two parents and children pays $2,945
more in Federal taxes than they would have under the tax policies in place
before the Tories first came to power in 1984."
Newsgroups: comp.databases.ingres
From: ash@ulysses.mr.ams.com (Alan Harder)
Subject: Ingres on SunOs 4.1.3
Organization: American Math. Society
Date: Thu, 5 Nov 1992 20:20:26 GMT


Although Ingres has not officially sanctioned running 6.4/0* on SunOs
4.1.3, we would like to do it anyhow, because 4.1.3 supposedly offers
many bug fixes and a performance boost for 690MP machines.  Since
4.1.3 is supposedly only a maintenance release, we don't expect to run
into any problems.  Is anyone out there running Ingres on 4.1.3?
Newsgroups: comp.databases.ingres
From: RASCH@C-H.BWH.HARVARD.EDU
Subject: Ingres VISION product
Organization: National Radio Astronomy Observatory
Date: Tue, 10 Nov 1992 16:29:10 GMT

I may be doing a project soon, using the VISION tool to develop a simple 
application.  While I have used it successfully before (without a manual!), I 
now may be asked to train/support new users of the product.

I would like to hear reactions from people who have used VISION.  Did you like 
it, hate it, under what circumstances did you use it?  Some specific questions:

1.  Any opinions on the quality of code that VISION generates?
2.  How complex an application will VISION's code templates handle?
3.  Has anyone had experience with the product being used by end-users, ie by 
    (sophisticated) non-programmers?
4.  Has anyone used VISION as a 'documentation tool' for complex applications, 
    ie, write user-defined 4GL or ESQl procedures for all your application 
    frames, but use VISION for the flow chart and documentation fields?
5.  Any peculiar quirks, clever tricks, or any other comments?

I found VISION very easy and quick to use for the simple application I 
developed before.  I particularly liked the way it could be used to document an 
application.

So what do you think?

Please reply to list or to me:  rasch@c-h.bwh.harvard.edu

Joan

Newsgroups: comp.databases.ingres