HDTenEightyP/NetNews huggingface dataset:
From: mikes@Ingres.COM (Mike Schilling)
Newsgroups: comp.databases.ingres
Subject: Re: problem with "DESC" as column name in Windows4GL
Date: 10 Jan 93 18:02:01 GMT
Distribution: comp

From article <1993Jan8.174834.26387@pony.Ingres.COM>, by mikes@Ingres.COM (Mike Schilling):
> Solution:
> 1. call the field something other than desc (you control the field name).
> 2. Write the select as:
> 
> 	select :my_field = 'desc' from a;
> 
> Mike	
Please disregard this: it will, of course, select the constant string
'desc' instead of the value of the column named 'desc'.

It is possible in Windows4GL 2.0 to say:

	string = 'SELECT desc FROM a';
	EXECUTE IMMEDIATE 'string' INTO :my_field;

This isn't particularly inefficient, but it does lost the ability
to use repeat queries.
----------------------------------------------------------------------------
mikes@ingres.com = Mike Schilling, INGRES, An ASK Group Company, Alameda, CA
Just machines that make big decisions,
Programmed by fellows with compassion and vision.	-- Donald Fagen, "IGY"
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Help Facility with embedded SQL 
Keywords: help, Embedded SQL 
Organization: Palmer & Associates, Inc., Norcross, GA
Date: Fri, 8 Jan 1993 14:34:11 GMT

In article <C0Ht3n.As7@usenet.ucs.indiana.edu> levanon@browneyes.ucs.indiana.edu (Jacob Levanon) writes:
>
>--
>Greetings:
>	I am looking for a public domain software that provides a help
>facility (something equivalent to the help facility in the monitor or
>isql) implemented using embedded SQL (preferably Dynamic SQL).
>
>Thanks.
>
> /====================================================================\
>|| Jacob Levanon                   /\            Network Applications ||
>|| University Computing Services   ||             levanon@indiana.edu ||
>|| Indiana University              ||                  (812) 855-2598 ||
>|| 750 N. State Road 46-Bypass     ||  ...reserved for                ||
>|| Bloomington, IN  47405          \/                   future use... ||
> \====================================================================/
>

Have you tried the two help facilities that INGRES provides for Embedded SQL?
One of them is basically the same as you get in isql.  One is called HELPFILE
and is executed by the EXEC SQL HELPFILE subject filename command.  The other
is HELP_FRS and is executed by the EXEC FRS HELP_FRS(SUBJECT=subject,
FILE=filename) command.  Either of these provide nice help interfaces (we
use them exclusively in our application development).

-- 

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."
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: How to display 132-character lines?
Date: 11 Jan 93 14:15:39 GMT
Organization: Not Organized

In article <1993Jan8.175836.22348@zia.aoc.nrao.edu> maintadm@zia.aoc.nrao.edu (Maintenance Admin.) writes:
>We have a 4GL application which tries to read an ASCII file containing
>132-char records using "call system ('less ' + filename);".  For some
>reason INGRES wants to display only 80-char lines and folds the
>output.  Even when I set the screen width to 132 chars INGRES seems to
>intercept the command and displays only 80 chars.
>How do I tell INGRES to use 132-char lines?

use a different termcap 

bob
--
RW Salnick, Spokane,WA  |  Home: salnick@dejavu.spk.wa.us
  Amiga 1000, WB 1.3    |  Work: mfgsys!salnick@kaiser.spk.wa.us
      WA9BVE            |
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Ingres, dates and II_TIMEZONE
Date: 8 Jan 93 03:33:52 GMT
Organization: Not Organized

People:  

beware of a documentation bug... actually more of a documentation 
inadequacy.

The following discussion pertains to VMS installations...

Ingres makes use of a logical called II_TIMEZONE to establish GMT from 
system time (since VMS doesn't understand GMT).  This logical needs to be 
set to the number of hours the system location is west of GMT.  this much 
is clear in the documentation.  The documentation also states that 
II_TIMEZONE should change when daylight savings time begins/ends.  Now 
here is the inadequacy:  If II_TIMEZONE is simply changed by an 
interactive command such as:

$ define/sys/exec ii_timezone 8

Ingres will return THE WRONG TIME.  When the timezone is changed, the 
Ingres installation MUST be restarted.  In other words, the correct 
method for changing the timezone should be:

1.  edit iistartup1.com and change the line where II_TIMEZONE is set.
2.  Shutdown Ingres
3.  Start Ingres


(don't ask how I discovered this at this time of year...)

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,comp.databases
From: jhenders@sei.cmu.edu (Jordan Henderson)
Subject: ASK INGRES WINDOWS 4GL - 2.x, USING IT on SUN
Keywords: ASK INGRES WINDOWS 4GL SUN
Organization: The Software Engineering Institute
Date: Wed, 6 Jan 1993 17:01:22 EST


I am interested in hearing from anyone using the Ask Ingres Windows 2.x
product. Specifically:

	1) What release of Windows 4GL, 2.x ?

	2) What release of Ingres, 6.3 or 6.4 ?

	3) What platform are you using?
	   Database server machine, Sun 4/690 etc?
	   What OS version on server ?
	   Client machine ?
	   What OS version on client ?
	   X Windows X11R4, X11R5 ?
	   Motif, other ?

	4) What was involved when moving pre-existing code from 1.x to 2.x?
	   Were any changes at the source level required?
	   Did code that was working regress?

	5) Have you released any applications to your users?

	6) Have you had any problems with bugs during development?

Please reply directly to me.
If there is sufficent interest, I will post a summary.

Thank you
Jordan Henderson
#include	<std-disclaimer.h>
Newsgroups: comp.databases.ingres
From: jwd@rivm.nl (Jan Diesel)
Subject: Re: Transaction Log File
Organization: R.I.V.M.
X-Newsreader: Tin 1.1 PL5
Date: Fri, 8 Jan 1993 08:46:57 GMT

David Kaplan (djk@sei.cmu.edu) wrote:
: 
: I'm having some intermittent problems with the Trasaction Log File.  Or,
: rather, it's having trouble with me?  In either case, the following error
: occurs when running a rather long set of queries:
: 
: **** ERROR: E_US1262 Your transaction has been aborted due to the transaction
:     log file having reached one of the limits set by the system administrator.
:     These limits are log_full, force_abort, and 90 percent of force_abort
:     when using the fast_commit option to start DBMS servers.
:    (Thu Jan  7 12:21:39 1993)
: 
: What's this all about.  I mentioned intermittent because some days I get the
: error, and other days I don't?!  There are commits after each query (all
: creation and insertion commands), and the queries are broken up just about as
: far as we can get them.

The transaction logfile is used not only by inserts, updates and deletes but
by selects as well. The obvious solution to your problem seems increasing the
size of the transaction logfile or decreasing the size of your transactions.
The latter can be done by setting autocommit on (thereby causing each statement
to be treated as a singleton transaction). If this won't help and you don't
want to increase the transaction logfile you'll have to split up your statements.

: 
: Could this error be an indicator that something else is wrong?  The fact that
: it is intermittant EVEN when the data being used has not change is what really
: has me puzzled.
: 
: Any clues appreciated ;-)
: 
: Thanks,
: 
: -Dave.
: 
: 
: ---------------------------------------------------------------------------
: David J. Kaplan                                             djk@sei.cmu.edu
: Software Engineering Institute                         dk3g+@andrew.cmu.edu
: Carnegie Mellon University                                   (412) 268-7736

Regards,
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Jan Diesel                                       |          jwd@rivm.nl
Informatics Service Centre                       |  tel. ++31 30 742067
P.O.Box 1, 3720 BA  BILTHOVEN, the Netherlands   |  fax. ++31 30 282316
RIVM - National Institute of Public Health and Environmental Protection
Newsgroups: comp.databases.ingres
From: Tom Blythe <TJB@MATH.AMS.ORG>
Subject: Re:  UNSUBSCRIBE
Organization: National Radio Astronomy Observatory
Date: Mon, 4 Jan 1993 13:31:18 GMT

Sande, you are not directly subscribed to info-ingres@math.ams.org.
You may be subscribed thru a local distribution list.
I notice that info-ingres-readers@carleton.edu is subscribed.
You may want to have them remove you from their list.
Newsgroups: comp.databases.ingres
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Subject: Re: problem with "DESC" as column name in Windows4GL
Organization: Columbia University
Distribution: comp
Date: Fri, 8 Jan 1993 20:43:16 GMT

We found we were able to go into quel and define a view that renamed the
SQL-only keywords and then reference that view from sql.  So, for example,
we had a table named 'user.'  In quel we did

	define view userview(user.all)

and then could use it fine from SQL with the exception that the "secret"
tid column is no longer there.
/a
Newsgroups: comp.databases.ingres
From: buntrock@mayo.edu (Jim Buntrock)
Subject: SQL where claus limitations
Organization: Mayo Foundation, Rochester, Minnesota
Date: Wed, 6 Jan 93 22:06:15 GMT

I have been writing a retrieval application that generates a dynamic 
where clause for a select statement.  Depending on complexity of the query
this where-clause can get quite lengthy.  I know this query
may be written differently, however, I am working with a dynamic 
query generator, which may produce thousands of different where-clauses.  The
following where-clauses are just a few examples:

  1> select *
  2> from sirsworld s
  3> where
  4>        (s.proc = '14.24' and s.diag = '100')
  5>    or  (s.proc = '14.25' and s.diag = '200')
  6>    or  (s.proc = '14.26' and s.diag = '300')
  7>    or  (s.proc = '14.30' and s.diag = '400')
  8>    or  (s.proc = '14.31' and s.diag = '500')
  9>    or  (s.proc = '14.32' and s.diag = '600')
 10>    or  (s.proc = '14.33' and s.diag = '700')
 11>  order by 1, 2
E_OP0302 too many boolean
    factors defined in query - query too complex
    (Wed Jan  6 10:38:40 1993)
 
End of Request - Terminated by Errors
-----------------------------------------------------------------
If I add two more conjunctions I get the following error:
 
  1> select *
  2> from sirsworld s
  3> where
  4>        (s.proc = '14.24' and s.diag = '100')
  5>    or  (s.proc = '14.25' and s.diag = '200')
  6>    or (s.proc = '14.26' and s.diag = '300' )
  7>    or (s.proc = '14.27' and s.diag = '301' )
  8>    or (s.proc = '14.28' and s.diag = '302' )
  9>    or  (s.proc = '14.30' and s.diag = '400')
 10>    or  (s.proc = '14.31' and s.diag = '500')
 11>    or  (s.proc = '14.32' and s.diag = '600')
 12>    or  (s.proc = '14.33' and s.diag = '700')
 13>  order by 1, 2
E_OP0002 optimizer ran out of
    memory before generating execution plan
    (Wed Jan  6 10:41:01 1993)
 
End of Request - Terminated by Errors
------------------------------------------------------------------- 
I have tried increasing the memory of the QEP and still run into the
OUT of memory error.  My concern is with the error of - E_OP0302 too 
many boolean factors defined in query - query too complex -
Does anyone know the limit of the number of boolean factors?  Can this 
be changed?  Is this a finite limitation of Ingres?  Is the limit based
on conjunctions or disjunctions?  Any suggestions?

///////////////////////////////
James Buntrock
Analyst/Programmer
Medical Information Resources
Mayo Clinic
200 First Street SW
Rochester, MN 55905
email - buntrock@mayo.edu
///////////////////////////////

Keywords: 

Newsgroups: comp.databases
From: marcs@slc.com (Marc San Soucie)
Subject: Re: request for info on OODBs
Organization: Servio Corp, Beaverton Oregon, US
Distribution: na
Date: Fri, 8 Jan 1993 01:19:41 GMT

Lisa Bahler (bahler@thumper.bellcore.com) writes:

> I recently saw a request for information on object-oriented databases
> posted to this group, but there was no follow-up.  I'd like to prompt
> some discussion in this area.

> I have recently started looking at various OODBs.  Primarily, I am
> interested in ObjectStore, Objectivity, and Versant.  Would people
> share their good or bad experiences with these products and others?
> Especially useful would be comments from people who are familiar
> with more than one OODB.

What are you interested in doing with the OODB?

    Marc San Soucie
    Servio Corporation
    Beaverton, Oregon
    marcs@slc.com
Newsgroups: comp.databases
From: D.M.Todd@massey.ac.nz (D.M. Todd)
Subject: Re: Revelation: PUSH.SESSION/POP.SESSION
Keywords: revelation
Organization: Massey University, Palmerston North, New Zealand
X-Reader: NETNEWS/PC Version 2c
Date: Wed, 6 Jan 93 20:07:09 GMT

Thanks for the help with push.session/pop.session.  What is the
"system subroutines manual"?  Is that part of the developers package?
I've just skimmed all the documentation we received here with Arev
3.0, and I don't see any mention of it.

David
Newsgroups: comp.databases
From: mfraase@mr.net (Michael Fraase)
Subject: Re: catalog publishing software wanted
Reply-To: mfraase@mr.net (Michael Fraase)
Organization: Arts & Farces
Date: Sat, 9 Jan 1993 16:04:06 GMT

In article <9d#3pkf@rpi.edu>, fitzgb@mml0.meche.rpi.edu (Brian Fitzgerald) 
writes:
> 
> Catalog publishing software wanted.
> 
> I'm looking for a program that can access a business database (say
> Paradox), extract the stock number, price, and description, and produce
> a publication quality merchandise catalog (justified, multicolumn, with
> white boxes for pix desirable.)
> 
> If there is a _convenient_ way to do this by linking a word processor
> to a database, I'm interested -- something a bit more sophisticated
> than exporting/inporting ascii.  Stories about your own experiences,
> good or bad, are welcome.
> 
> Information about add-ons to database programs, or complete business
> packages, free or commercial, would be welcome.
> 
> Pointers to magazines or recent articles cover this subject would be
> appreciated.
> 
> Thanks loads,
> 
> Brian

FrameMaker and 4th Dimension can do what you want on the Macintosh side, but 
I don't think Frame supports PC databases on their Windows product. I don't 
know if they have plans to or not. You can contact Frame directly at 
comments@frame.com.

--
Michael Fraase, proprietor     |  Voice/Fax: 612/698-0741
Arts & Farces                  |  Internet: mfraase@farces.com
2285 Stewart Avenue            |------------------------------------------
Suite 1315                     |  Nothing to tell, let the words be yours,
St. Paul, MN 55116             |  I am done with mine. (Weir/Barlow)
Newsgroups: comp.databases
From: verbus@netcom.com (Verbus M. Counts)
Subject: Re: Sybase for SysVR4 (Dell)
Keywords: Sybase, SVR4
Organization: Netcom Online Communications Services (408-241-9760 login: guest)
Date: Thu, 7 Jan 1993 14:56:57 GMT


Yes, We are using Sybase SQL Server 4.8 on AT&T UNIX SVR4.0 V4.0T
on the TMAC contract for the US government.

Works OK!


Regards,
Verbus M Counts,  AT&T/NCR Support,   verbus@attmail.com
Newsgroups: comp.databases
From: durai@ortta.umn.edu (Durai Venkatasubramanian)
Subject: Foxpro foundation read
Keywords: event driven programming, foundation read, error
Organization: U of Mn
Date: Thu, 7 Jan 1993 17:32:02 GMT

I am using foundation read, for an application.

When there is a system error, the system completely ignores the foundation 
read or read level based exits/action, and crashes.  Even if managed to pass 
control back to a read level, the system crashes.

Is there a graceful way to handle errors using foundation read ?  How do I 
restore the settings of valid data, and just suppress the error condition, 
to loop back to foundation read to use the valid data?
From: bq035@cleveland.Freenet.Edu (Brian Jepson)
Newsgroups: comp.databases
Subject: Re: Foxpro 2.0 Index Searches
Date: 9 Jan 1993 18:46:05 GMT
Organization: Case Western Reserve University, Cleveland, OH (USA)
Reply-To: bq035@cleveland.Freenet.Edu (Brian Jepson)
NNTP-Posting-Host: hela.ins.cwru.edu


In a previous article, thomasd@tps.COM (Thomas W. Day) says:

[stuff deleted]

>4) Is there a reasonable way to perform math functions on 4-digit time 
>data?  The data is derived by the TIME() function but is stored 
>in a character field as 99:99 (hour:minute) character data.  What I want to 
>do is subtract two fields stored this way in each record and obtain the 
>average time between each of these fields.  Obviously, 15:01-14.58 should 
>equal something other than 00:43.  Is there a convert-text-to-time (CTOT?) 
>function?
>
This might be something like what you want. Calling syntax is:
?military("10:00AM")
You will have to decide how to put the AM/PM indicator on there. It won't be
too hard.

*-
*- takes a string variable of the form ##:##XX ie, 4:45pm, 5:30am
*- and returns a string in military time (but in decimal), ie, 1675, 0550
*-
FUNCTION military
PARAMETER t12

	t24 = ALLTRIM(STR(VAL(LEFT(t12,2)) + ;
			 IIF(RIGHT(t12,2) = "AM", 0, 12))) + ;
			 PADL(ALLTRIM(STR((VAL(SUBSTR(t12,4,2)) / 60) * 100)), 2, "0")

	IF LEFT(t24,2) = "12"
		t24 = STUFF(t24,1,2,"24")
	ELSE
		IF LEFT(t24,2) = "24"
			t24 = STUFF(t24,1,2,"12")
		ENDIF
	ENDIF

RETURN VAL(t24)

This should help out with your problem. Just be aware that 10:45 am = 1075.
I don't have a routine to change it back, although that should be easy. 
Good luck!
-- 
*  __                _____                        Brian Jepson
* /__)  __ . __ __     /  __   _   /  _   __      iqm229@uriacc.uri.edu
*/___) /  / (_// / (__/  (_/  /_) _) (_) / /      bq035@freenet.cwru.edu
*                         `- /
From: al439@cleveland.Freenet.Edu (David Churnega)
Newsgroups: comp.databases
Subject: File conversion QBasic to Comma Del.
Date: 11 Jan 1993 20:07:08 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: slc10.ins.cwru.edu


I need some help with file conversion of a ASCII text file, such
as a listing of files on a local BBS, to a comma delimited file
using QBasic.  

Have written some code using sting parsing with the LET command but
am running into problems with unexpected characters being read in.
Has anyone written a QBasic program to do this?

Eventually want to import data in Paradox 4.0 and perform queries at
that point.

Please help and I will include the QBasic code I have written thus
far in my next communication.

Thank you
From: durai@ortta.umn.edu (Durai Venkatasubramanian)
Newsgroups: comp.databases
Subject: Help wanted: usenet groups
Date: 5 Jan 93 16:29:49 GMT
Organization: U of Mn

I apologize for posting a message that may not be appropriate for this group.

I would like to have a list of all newsgroups.  Can someone help me with a 
text file of all the newsgroups ? Please mail to durai@ortta.umn.edu

I do not have enough memory in my pc, and as a result, everytime I try to 
subscribe from the list, my computer crashes after counting upto 4000 
newsgroups.   I would like to include the groups in my startup file, so that 
I do not have to worry about selecting from the five thousand odd groups.

Where can I find a list of all the newsgroups, in a downloadable form ?

Thanks a ton.
From: lapworth@mizar.usc.edu (Bill Lapworth)
Newsgroups: comp.databases
Subject: UDF problem in FoxBase+
Date: 8 Jan 1993 13:21:32 -0800
Organization: University of Southern California, Los Angeles, CA
NNTP-Posting-Host: mizar.usc.edu


* I'm playing with FoxBase+ without a manual (it's coming, but not too
* soon!) and I can't get a UDF to work in the valid clause.
*
* If I run the following code, I get a 'file not found' error message
* upon exiting the get

height = 100.0
@ 0,0 clear
@ 3,1  say "Height in CM: " get HEIGHT valid isok(HEIGHT)
read
cancel

function isok
    parameter value
return iif( value > 150, .F., .T. )

* I tried moving the UDF isok to it's own .prg file and added the following
* line at line 1: set procedure to c:\spiro\isok
* This time I got the error message 'No parameter statement found'

* Anybody got any clues?


Newsgroups: comp.databases
From: "tom frazer" <tom.frazer@canrem.com>
Subject: move xbase compats to own
Reply-To: "tom frazer" <tom.frazer@canrem.com>
Organization: Canada Remote Systems
Distribution: comp
Date: 6 Jan 93 00:30:09 EST

DB> 	fox, clipper, dbase, etc .... all those "xbase" compatibles
DB> 	using "dbase" files deserve their own newsgroup.
DB> 
DB> 	maybe paradox stuff should have theirs as well.
DB> 
DB> 	comp.databases should be a general discussion area, with
DB> 	most of the product specific stuff living in their own
DB> 	newsgroups, as comp.databases.(oracle|ingre|sybase) do.
DB> 
DB> Who wants to do this ?

    I'm game.
---
 . MegaMail 2.10 : Now you're reading with REAL POWER! MEGAR210.ZIP
--
Canada Remote Systems  - Toronto, Ontario
World's Largest PCBOARD System - 416-629-7000/629-7044
Newsgroups: comp.databases
From: rickt@rmtc.paramax.com (Rick Thompson [RMTC/ISP])
Subject: ObjectVision
Organization: Paramax Systems
Date: Mon, 11 Jan 1993 20:25:32 GMT


Hello,

  I was curious if anyone out there has used ObjectVision and if so
what do you thing about it?  I've tried Microsoft Access and I'm not
impressed.  I understand that ObjectVision has a run-time as well.
What kind of "baggage" needs to be included in distributing a program?


Thanks for any information,

Rick Thompson   rickt@rmtc.paramax.com
Xref: sparky comp.databases:9040 comp.databases.oracle:2782 comp.databases.theory:679
From: ggarcia@mipos2.intel.com (Gilbert Garcia)
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.theory
Subject: QUESTION: Modeling problem using ERWIN/SQL
Date: 13 Jan 93 01:34:01 GMT
Organization: Intel Corporation, Santa Clara, CA USA

Hello ERWIN/SQL users, 

I'm wondering if anyone would know if ERWIN/SQL supports this modeling
problem:

Suppose I have a table called CARD.  One of the attributes in CARD is
a field called CARD_TYPE.  Another table exists called CARD_DEVICE which
given a CARD_TYPE, there exists a corresponding DEVICE_TYPE.  So far this
is what I have:

CARD                   CARD_DEVICE
--------               -----------
card_id                card_type
card_type              device_type

Now suppose I want to create subtypes of CARD and use DEVICE_TYPE
as the discriminator.  Does ERWIN/SQL allow me to do so??  If so, how?!?

Any feedback will be greatly appreciated.

Thanks, in advance,

Gilbert H. Garcia
From: lkress@reed.edu (Lucien Kress)
Newsgroups: comp.databases
Subject: Paradox Runtime - Info please
Date: 8 Jan 93 09:10:27 GMT
Article-I.D.: reed.1993Jan8.091027.768
Organization: Reed College, Portland, OR

Can anyone tell me about Paradox Runtime?  Specifically, how much
does it cost?  Does it compile the Paradox application?  Do data
tables used in a Runtime application have the same format as those
used with Paradox itself?  Are there any hardware limitations for
running a Runtime application?  Can any Paradox application be
used as a Runtime application?  Is a Runtime application faster or
slower than the same application in Paradox?  Other than the obvious
advantage of the user not needing to own Paradox, are there any
other advantages (or disadvantages) in a Runtime application?

Any answers to these questions, or other pertinent information,
would be much appreciated.  Please respond by email to lkress@reed.edu.
I will summarize upon request.  Thank you.

Lucien Kress
Xref: sparky comp.databases:8994 comp.periphs.printers:3865