HDTenEightyP/NetNews huggingface dataset:
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: query on date
Organization: 
Date: Sat, 29 Aug 1992 08:21:00 GMT

In article <IebhlJS00io7AIuUlc@andrew.cmu.edu>, jj23+@andrew.cmu.edu 
(John Hawfeng Jeng) writes:
> I would like to make some query base on date using BETWEEN.  Can anyone
> verify the following query for me since I could not find anything
> similar in the reference manual?
> 
> 	select *
> 	from transaction
> 	where date_time_of_transaction between :start_date and :end_date
> 	and account_number = :in_account_number;

It works like a charm.  Even though INGRES stores dates internally in a
binary format, and even though you may specify them in host variables
with values like "today", "now", or "12/31/1971", INGRES is smart enough
to convert the host values into internal format before it does the
comparison.  The same is true of "money", which the only other
Ingres-supplied abstract data type (ADT).  

If you have an isam or btree secondary index on the date, then INGRES
uses it to good advantage.

Use some caution if your column includes times as well as dates, but the
comparison values are dates only.  If the condition is:

	where date_time_of_transaction between '1/1/1970' and '1/1/1971'

then I don't think you'll get any row for "1/1/1971" if there is _any_
time value on it.  It's worthwhile building a test case to convince
yourself of how it works.

--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: eric@brolga.cc.uq.oz.au (Eric Halil)
Subject: Re: E_CLFE07 and E_SC022F and E_LQ002E
Organization: Prentice Centre, University of Queensland
Date: Fri, 4 Sep 1992 07:51:22 GMT

alan@curta.cc.columbia.edu (Alan Crosswell) writes:

>I keep seeing this errors under 6.3 and 6.4.  Anybody know that they
>really mean if anything? 
>      ::[4026            , 00846860]: Thu Sep  3 04:02:17 1992  
>E_CLFE07_BS_READ_
>ERR     Read from peer process failed; it may have exited.
>      ::[4026            , 00846860]: Thu Sep  3 04:02:17 1992  
>E_SC022F_BAD_GCA_
>READ    SCF was unable to read a GCF block.

From the release notes for 6.4/02/00
------------------------------------
KNOWN PROBLEMS IN THE 6.4/02/00 RELEASE
       The bugs  listed  below  are  known  problems  in  the  6.4/02/00
       release.

         o Bug 42284

           Sometimes normal exits from INGRES  frontends  (i.e.  tm/sql)
           and user applications will cause spurious errors to be logged
           to the dbms error log file (errlog.log).  The errors are:

                 E_CLFE_07_BS_READ_ERR  Read from peer process failed;
                       it may have exited.
                 E_SC022F_BAD_GCA_READ  SCF was unable to read a GCF block.


Hope that helps,
Eric.
--
Eric Halil                           |Internet/CSnet:         eric@cc.uq.oz.au
Prentice Centre                      |Bitnet:    eric%cc.uq.oz.au@uunet.uu.net
University of Queensland    4072     |UUCP:        uunet!munnari!cc.uq.oz!eric
AUSTRALIA --   Phone: +61 7 365 3610 |JANET:        eric%cc.uq.oz.au@uk.ac.ukc
Newsgroups: comp.databases.ingres
From: cdkeen@probitas.cs.utas.edu.au (Chris Keen)
Subject: Problem with Report-Writer 6.3 (Q)
Organization: University of Tasmania, Australia.
Date: Tue, 1 Sep 1992 06:24:37 GMT

Using Report-Writer in Ingres v6.3, I cannot print out negative
numbers using the standard .pr command. All numbers appear without
signs, regardless of whether they are positive or negative.

Any suggestions (apart from upgrading to a later version, which is
out of my control)?

thanks,

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: ageorge@ra.nrl.navy.mil
Newsgroups: comp.databases.ingres
Subject: INGRES date data type
Date: 2 Sep 92 21:47:00 GMT
Reply-To: ageorge
Organization: Naval Research Laboratory, Washington DC
News-Software: VAX/VMS VNEWS 1.3-4


	Hello everyone,

	I use INGRES Version 6.3/02p (sgi.us5/01) on
a Silicon Graphics Personal Iris 4D/35 workstation running IRIX V3.3.2.

	Is there any way to use the INGRES date data type to represent
times that have a fractional second component; eg, 2-sep-1992 17:27:00.5?

	I know of two workarounds(decompose the time into its component parts,
use date data type along with an integer to represent the fractional second),
but these are unattractive options.

	Plus, I vaguely recall reading something about extending INGRES with
user-defined data types(like date w/ a fractional second). I'm not absolutely
clear on this so could someone clarify this for me?

	I'll summarize the responses I collect.

	Thank you in advance,

	Arthur George, NRL
	ageorge@BDCI143.nrl.navy.mil
Newsgroups: comp.databases.ingres
From: xli@hfglobe.intel.com (Xiaoqing Li)
Subject: Access two INGRES databases from one application
Organization: Development Tools Operation, Intel Corp., Hillsboro, OR
Date: Thu, 27 Aug 92 17:15:09 GMT

    Does anyone know if an application can connect to two or more INGRES 
    databases and keep them open at the same time (that is, the application
    needs to retrieve data from more than one INGRES databases and it only
    does one "connect" statement per database while the application is running,
    for the performance reason)?  If so, could you specify how?  Thanks!

    Xiaoqing Li
i

Newsgroups: comp.databases.ingres
From: effah@scs.carleton.ca (samuel effah)
Subject: Help: On-fly View Creation
Reply-To: effah@scs.carleton.ca
Organization: School of Computer Science, Carleton University, Ottawa, Canada
Date: Thu, 27 Aug 1992 21:02:12 GMT

Is there a way to create views/tables with part of the name concantenated with 
a value retrieve from the database?

For example if during the excution of a program, variable name.surname = 'Daniels'
is there a way to define a view/table (in application) with 'Diniels' being part?
As in:
		create view temp_Daniels
		   :
		   :

Pls mail me a copy if you post replies.

Thanks in advance.

Newsgroups: comp.databases.ingres
From: hkau@jyu.fi (Harri J Kaukovuo)
Subject: HP-UX 8.xx Ingres images + coredumps
Organization: University of Jyvaskyla, Finland
Date: Tue, 1 Sep 1992 06:35:24 GMT


...

What is the problem when our images don't work correctly in HP-UX 8.xx?
The problem occurs both in 6.3/6.4 and only in HP-UX (the same sources
exist in VAX/VMS and the application works as it should).

The application exists and makes a coredump (only when running an image,
this _doesn't_ happen when running thru ABF). We have tried to track
the reason without success. The coredump occurs everywhere, sometimes
the application comes down when loading the frame sometimes this
happens in the middle of program (without any logical reason!!!!).

First of course we thought that this is a question about having
bugs in our programs, but there were any (that could cause this). 
We have been debugging our images and suspect problems 
with Vifred forms/memory managing.

The time is running out, man ...

HELP!!!! Somebody?!

Harri Kaukovuo			hkau@tukki.jyu.fi

Ps. We have checked the variables, our sources (*.osq), forms, etc.
-> no idea what's going on. 

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


Newsgroups: comp.databases.ingres
From: Gavin Trigg <gavin@asis.unimelb.EDU.AU>
Subject: Re: Database Procedure
Organization: National Radio Astronomy Observatory
Date: Thu, 3 Sep 1992 21:42:28 GMT

> 
> 
> We hit a certain limit while trying to incorporate some pretty hugh
> database procedures to Ingres 6.4. Just wondering what those limits are
> and how to reset them. In addition, what are the effects to the whole
> server in general?
> 
> Thanks for any advice
> 
> chou@csd.hku.hk
> 
Please be specific about the limits that you have exceeded.  We have some large
procedures that exceed some of the default server limits.  I just increased
the limits until they worked :-)

Following is the rundbms.opt file from one of our Solbourne installations
running dual Ingres servers -

-active_sessions 110
-connected_sessions 110
-cursors_per_session 64
-database_count 36
-fast_commit
-names
-opf.active 10
-opf.memory 40000000
-psf.memory 22000000
-qsf.pool_size 16000000
-quantum 1000
-session_accounting
-shared_cache
-stack_size 65536
-write_behind 4

Is it one of these limits that you have exceeded?

I wouldn't expect it to be a locking and logging system problem but for
whatever it's worth here is the setup as well -

Current logging parameters...

Maximum number of open databases in logging system: 36
Maximum number of transactions in logging system: 2000
Transfer block size for the log file: 8
Number of log buffers in shared memory: 10
Log-full-limit as a percentage of the log file: 95
Force-abort-limit as a percentage of the log file: 80
Percentage of the log file to be used for each consistency point: 2
Number of consistency points taken before invoking archiver: 1

Current locking parameters...

Maximum number of locks per transaction: 500
Maximum number of locks in the locking system: 80179
Number of lock lists in locking system: 2000
Size of the locks hash table: 16057
Size of the resources hash table: 16057

*PLEASE SUPPLY THE SPECIFIC ERROR MESSAGE NUMBER AND TEXT TO ENABLE A PROBLEM
LIKE THIS TO BE DIAGNOSED ACCURATELY*
-- 
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: Tom Blythe <TJB@MATH.AMS.ORG>
Subject: Ingres applications and desktop devices
Organization: National Radio Astronomy Observatory
Date: Thu, 3 Sep 1992 12:40:17 GMT



At Ingres World in Tarpon Springs one of the concerns raised was the
presentation of applications to users through the ingres forms system.
Since many companies still have a large number of VTXXX terminals, we
are limited to using ABF for application development and are left out of
the features offered in Windows/4GL. Not only does this affect our
applications, it affects our application developers, as we are left with
character-based development tools on which to develop character-based
applications (this is especially noticable in vifred, which can be
clumsy compared to forms development in a windowing environment). Since
many companies' developers have workstations, Ingres' developers offered
the possible work around of moving toward having a windowing development
environment for  character-based applications. This suggestion received
quite a bit of support.

In reading the trade press, I have noticed that the Uniface 4GL  allows
the same application to be deployed on multiple desktop devices (i.e.
the same application running under X-windows and a VT200 terminal, using
different display device drivers). This scenario was not raised at
Ingres World, but I'm sure if it was it would have received a lot of
support from the user base. 

I'd be interested in hearing from someone who has used Uniface's 4GL to
learn of their experiences with this product across multiple desktop
devices. I'd also like to hear from someone at Ingres as to whether or
not this is a direction we could see Ingres take with either ABF/4GL or
Windows/4GL.

----------------------------------------------------------------------
Tom Blythe                               TJB@MATH.AMS.ORG
American Mathematical Society            (401) 455-4015
PO Box 6248, 201 Charles St.
Providence, RI 02940
----------------------------------------------------------------------
From: chou@csd.hku.hk (Chou Sui Lin)
Newsgroups: comp.databases.ingres
Subject: Database Procedure
Date: 3 Sep 92 04:04:44 GMT
Organization: National Radio Astronomy Observatory


We hit a certain limit while trying to incorporate some pretty hugh
database procedures to Ingres 6.4. Just wondering what those limits are
and how to reset them. In addition, what are the effects to the whole
server in general?

Thanks for any advice

chou@csd.hku.hk
Newsgroups: comp.databases.ingres
From: mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney)
Subject: Re: Access two INGRES databases from one application
Organization: Indiana University, Bloomington
Date: Thu, 27 Aug 1992 19:50:48 GMT

In article <1992Aug27.171509.14440@intelhf.hf.intel.com> xli@hfglobe.intel.com (Xiaoqing Li) writes:
>    Does anyone know if an application can connect to two or more INGRES 
>    databases and keep them open at the same time (that is, the application
>    needs to retrieve data from more than one INGRES databases and it only
>    does one "connect" statement per database while the application is running,
>    for the performance reason)?  If so, could you specify how?  Thanks!
>
>    Xiaoqing Li

Embedded SQL has this capability.  To use it, you include a "session
number" when you connect, which is simply an integer.  It must be
unique within the application.

For instance:

exec sql connect database1 session 1
exec sql connect database2 session 2

Then, to switch between the two within the application, you use the
"set_ingres" command:

exec sql set_ingres (session=1)

That statement will cause subsequent sql statements to be applied to
database1.  You can use this statement to switch back and forth
between the two.  Inquire_ingres can be used to determine the current
session.

For more information, check out the SQL manual.  The Ingres Features
chapter has a section on this command.  Also, look at the commands
mentioned above (connect, set_ingres, and inquire_ingres).

	Darrin
-- 

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

"It's a marvel of vegetable containment..."
Newsgroups: comp.databases.ingres
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Subject: Re: Access two INGRES databases from one application
Organization: Columbia University
Date: Thu, 27 Aug 1992 19:14:12 GMT

In article <1992Aug27.171509.14440@intelhf.hf.intel.com>  
xli@hfglobe.intel.com (Xiaoqing Li) writes:
>     Does anyone know if an application can connect to two or more INGRES 
>     databases and keep them open at the same time (that is, the  
application
>     needs to retrieve data from more than one INGRES databases and it  
only
>     does one "connect" statement per database while the application is  
running,
>     for the performance reason)?  If so, could you specify how?  Thanks!
> 
>     Xiaoqing Li
> i

Yes, you can do a set session and switch back and forth.  Alternatively,
you can get Ingres/Star and do joins, etc. across multiple DBs on the same
host or across the network.
From: klkarp@remus.rutgers.edu (klk)
Newsgroups: comp.databases.ingres
Subject: Report Writer Fonts?
Date: 31 Aug 92 18:19:25 GMT
Organization: Rutgers Univ., New Brunswick, N.J.


I was wondering if anyone knows if you can use different fonts on the
Report Writer.

Please email any responses to klkarp@remus.rutgers.edu or to
                   rhody@remus.rutgers.edu.

Thanks!
From: croft@csusac.csus.edu (Steve Croft)
Newsgroups: comp.databases.ingres
Subject: Re: Blobs in Ingres 6.5
Date: 1 Sep 92 17:04:14 GMT
Organization: California State University, Sacramento

>Because of the need for multiple large text fields in one table we
>have often run into the 2000 byte limit for records in Ingres tables. 
>Will the implementation of the BLOB datatype eliminate the 2000 byte
>limitation?

INGRES engineers at the INGRES World Servers discussion said that
BLOBs will be seperate from normal data pages and there will still
be a 2000 byte limit.  They also said that alot of work is being
done on allowing data to expand beyond page boundaries.  They didn't
announce when this limitation would be changed (or eliminated).

steve
Newsgroups: comp.databases.ingres
From: root@candle.uucp (Bruce Momjian)
Subject: Remote batch queue request fails in QUEL
Organization: a consultant's basement
Date: Thu, 3 Sep 1992 14:01:48 GMT
X-Newsreader: Tin 1.1 PL5

When I submit a job on a remote queue job, quel doesn't seem to
understand the system logicals.  This command fails:

	copy rteclients() from "rte_common:x.x"

with a message "file not found".  If I replace the logical rte_common
with the full path without the node name, I get the same error.  If I
include the node name, I get "Unrecognized error".  The logicals are
understood within the COM file outside the quel script.

There is something about referencing files from within a QUEL script that
was submitted via a remote queue request that is strange.  Has anyone
seen this before?  I set DECNET up as a super-user in ACCESSDB.  I am
running Ingres 6.4 under VMS 5.4.
-- 
Bruce Momjian                      |  830 Blythe Avenue
root%candle.uucp@bts.com           |  Drexel Hill, Pennsylvania 19026 
                                   |  (215) 353-9879(w)  853-3000(h)
Newsgroups: comp.databases.ingres
From: ncourdy@endor.sim.es.com (Nabil Courdy)
Subject: Ingres 6.4 for SCO Unix
Summary: Ingres 6.4 for SCO Unix
Keywords: Ingres 6.4 for SCO Unix
Organization: Evans & Sutherland Computer Corporation
Date: Thu, 27 Aug 1992 17:15:54 GMT


Does anyone know how reliable Ingres 6.4 is for SCO Unix.  We will be using
it as a Front End (Client) platform.  Our Server is a Sequent/2000 running
Ingres 6.3.

EMAIL - ncourdy@zephyr.sim.es.com
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Database Procedure
Organization: Palmer & Associates, Inc.
Date: Fri, 4 Sep 1992 12:15:02 GMT

It would be very helpful if you could tell us what limit you ran into.  Many
times it is possible to exceed a general limit which is not necessary directly
related to db procedures, but has the affect of making a procedure fail).

I don't know of any limit on the number or size of procedures.  I do know that
the ISQL terminal monitor has a maximum buffer size, which in effect limits the
size of a procedure that can be created through terminal monitor (though I
don't know what the maximum size is).  If you run up against this buffer size,
you can use Embedded SQL to create your procedure.

There are also caches in the server that can limit the effectiveness of
procedures.  In particular, there is a server facility called the Query Storage
Facility.  The server stores information about queries, including repeated
queries and db procedures, in this cache.  If the cache fills up or becomes so
fragmented that there is not a contiguous chunk of memory large enough to hold
a query/procedure, another query/procedure must be kicked out of the cache.  The
next time this query/procedure is referenced, INGRES has to reparse and
reoptimize (so you lose the effect of caching the query/procedure).

If your username has the set trace point permission, you can measure how much
QSF memory is being used by connecting to sql and entering the command 'set
trace point qs501'.  This output will show how much total QSF memory is
available and how much is in use.

-- 

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: guest@cg.emr.ca (guest account)
Subject: need TERMCAP entry for shelltool or cmdtool on SUNOS/4.1.2
Reply-To: guest@cg.emr.ca
Organization: Dept. of Energy, Mines & Resources, Canada
Date: Thu, 27 Aug 1992 15:03:06 GMT

The termcap entries provided by INGRES for the SUNOS/openwindows are not satisfactory.
Has anyone written a better termap for the SUN (shelltool or cmdtool windows)? If so,
could you send me a copy at mcneil@seismo.emr.ca.  Also, is there a FAQ for this group?
If so, is it archived at a FTP site anywhere?
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Ingres 6.3 on SVR4
Organization: 
Date: Sat, 29 Aug 1992 07:40:13 GMT

In article <dtb.714877859@otto>, dtb@otto.bf.rmit.oz.au (David Bath) writes:
> mclo@rtf.bt.co.uk (John McLoughlin) writes:

>>We are thinking of upgrading our SUN Sparc 2s from SUNOS 4.1.1 to Unix
>>SVR4. We are currently running Ingres Release 6.3. on them.
>>Does anybody out there know of any problems / have any hints to
>>bear in mind while doing this.

> Well -I came across a "RELIABLE RUMOR" that Ing 6.3 was not certified
> for SUNOS 4.1 (aka Solaris 1), only 6.4 is.

> I would be surprised if 6.3 is certified by SVR4 (aka Solaris 2)

It's no secret.  In the U.S., you can just call (800) 4-INGRES and ask
to talk to a salesman about product availability.  I've learned that
INGRES 6.4 will be certified for use with Solaris 2.0 (aka SunOS 5.0)
in the 4th quarter (read: late December).  I, too, would be surprised if
Ingres goes to the trouble of working on the INGRES 6.3/Solaris 2.0
combination.  Given the product improvements and bug fixes, you surely
want to upgrade to 6.4/02.

However, given the newness of Solaris 2.0, I personally would be
inclined to wait 6 months and let everyone else work out the bugs.

--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: sfc@tpghq.com (Steve Caswell)
Subject: Re: Setting up error handling routines (ABF 6.4)
Organization: Palmer & Associates, Inc.
Date: Fri, 4 Sep 1992 12:23:49 GMT


>I have a ABF application in which I what to trap all database error messages,
>e.g. "DUPLICATE ROW ON INSERT DETECTED", and so on.
>
>I had a quick look in the ABF manual and did the following:
>----
>int myhandler (errno)
>int     *errno;
>{
>int     status = 0;
>
>switch (*errno)
        >{
        >default: status = 0; /* suppresses message */
                >break;
        >}
>return (status);
>}

>With a call to IIseterr(myhandler);
>
>Unfortunately this also traps validation error messages from the forms.
>I guess I just need to be more discerning in the switch stmt.  Can anyone
>tell me the values to use to allow the forms validation messages and to stop
>the database messages?
>
>Thanks,
>Eric.
>--
>Eric Halil                           |Internet/CSnet:         eric@cc.uq.oz.au
>Prentice Centre                      |Bitnet:    eric%cc.uq.oz.au@uunet.uu.net
>University of Queensland    4072     |UUCP:        uunet!munnari!cc.uq.oz!eric
>AUSTRALIA --   Phone: +61 7 365 3610 |JANET:        eric%cc.uq.oz.au@uk.ac.ukc

I believe you can look for error numbers between 8000 and 8999.  We do the
same thing you described.  Here is the code we use for our error trap routine:

int myhandler(errno)
int *errno;
{

   /* allow forms system messages to be given to the user.  restrict
      all others */
   if ( (*errno) >= 8000 &&
        (*errno) <= 8999 )
   {
      return(*errno);
   }
   else
   {
      return(0);
   }
}

There is no guarantee that we are trapping absolutely all forms messages, but
I have searched the [ingres.files.english.messages]messages.txt file and I
believe they are all within this range.  I suppose Ingres is free to add other
forms validation error numbers, so this range could change in the future.

Of course, if you want to change the way forms validation messages are given
to the user, this would be the place to do so.

-- 

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