HDTenEightyP/NetNews huggingface dataset:
From: karl@BofA.com (Karl Nicholas)
Subject: Re: XVIEW and INGRES compatability problem! HELP!
Organization: Bank of America, Capital Products, RMTG #5906
Date: Thu, 21 Jan 93 19:07:11 GMT

In article <105904@netnews.upenn.edu> jarnot@kin.lap.upenn.edu (Kevin J. Jarnot) writes:
>In article <1993Jan20.040019.11802@BofA.com> karl@BofA.COM (Karl Nicholas) writes:
>
>	I came up with a quick fix in a sleepless haze over the weekend (don't
>you love when problems like this pop up two weeks before a deadline? ;-)
>Use the following function call:
>

	Here is what I got from someone. Looks like pretty much the
same thing. I repost it without permission, so I hope I am not
stepping on any toes.


From rtech!ingres.com!jbryson Wed Jan 20 10:20:07 1993
Date: Wed, 20 Jan 93 10:16:02 PST
From: jbryson@ingres.com (Jeff Bryson)
To: karl@BofA.COM
Subject: re:XVIEW and INGRES compatability problem
Content-Length: 1531
Status: RO
X-Lines: 63

Karl,

Attached are two workarounds for your problem.

Ingres support will tell you that the workarounds are "UNSUPPORTED"....
but both will work, I have told many people about these workarounds and
no one has had any trouble.

The problem is really openwin and ESQL CONNECT.
Ingres sets most(if not all) signals to QUIT!  I am not sure
why this change happened, but, starting in 6.4 it did.

Ingres support does know about this and there are several
BUGS/SIRS entered for this problem - #20493 and #44401
are just two of them.

Good Luck,

Jeff Bryson
ex-ESQL Support

---------------------------------------------------------------------
/********************************************/
/* The easy Workaround                      */
/* set signal to the default                */
/********************************************/
#include <stdio.h>
#include <signal.h>

main()
{
  EXEC SQL CONNECT supp60;

  signal (SIGALRM, SIG_DFL);    /* just set signal to the default */

  /* ... do your code here... */

  EXEC SQL DISCONNECT;
}



/********************************************/
/* Workaround #2                            */
/* Save the original signal                 */
/********************************************/
#include <stdio.h>
#include <signal.h>

void    (*oldhand)();

main()
{
  oldhand = signal (SIGALRM, SIG_DFL);  /* save the original signal */

  EXEC SQL CONNECT supp60;

  signal (SIGALRM, oldhand);            /* restore the original signal */

  /* ... do your code here... */

  EXEC SQL DISCONNECT;
}

-- 
 +---------------------------------------------------------------------------+
 | Karl Nicholas   (415) 953-0409    | Beer is good food.  Food is not beer. |
 | karl@BofA.COM   uunet!odinba!karl | *** BofA is not me, I am not BofA *** |
 +---------------------------------------------------------------------------+
Newsgroups: comp.databases.ingres
From: karl@BofA.com (Karl Nicholas)
Subject: Re: XVIEW and INGRES compatability problem! HELP!
Organization: Bank of America, Capital Products, RMTG #5906
Date: Thu, 21 Jan 93 18:59:25 GMT

In article <105904@netnews.upenn.edu> jarnot@kin.lap.upenn.edu (Kevin J. Jarnot) writes:
>In article <1993Jan20.040019.11802@BofA.com> karl@BofA.COM (Karl Nicholas) writes:
>
>	I came up with a quick fix in a sleepless haze over the weekend (don't
>you love when problems like this pop up two weeks before a deadline? ;-)
>Use the following function call:
>

Here is what I got from ingres (sort of). Pretty much the same thing.

From rtech!ingres.com!jbryson Wed Jan 20 10:20:07 1993
Date: Wed, 20 Jan 93 10:16:02 PST
From: jbryson@ingres.com (Jeff Bryson)
To: karl@BofA.COM
Subject: re:XVIEW and INGRES compatability problem
Content-Length: 1531
Status: RO
X-Lines: 63

Karl,

Attached are two workarounds for your problem.

Ingres support will tell you that the workarounds are "UNSUPPORTED"....
but both will work, I have told many people about these workarounds and
no one has had any trouble.

The problem is really openwin and ESQL CONNECT.
Ingres sets most(if not all) signals to QUIT!  I am not sure
why this change happened, but, starting in 6.4 it did.

Ingres support does know about this and there are several
BUGS/SIRS entered for this problem - #20493 and #44401
are just two of them.

Good Luck,

Jeff Bryson
ex-ESQL Support

---------------------------------------------------------------------
/********************************************/
/* The easy Workaround                      */
/* set signal to the default                */
/********************************************/
#include <stdio.h>
#include <signal.h>

main()
{
  EXEC SQL CONNECT supp60;

  signal (SIGALRM, SIG_DFL);    /* just set signal to the default */

  /* ... do your code here... */

  EXEC SQL DISCONNECT;
}



/********************************************/
/* Workaround #2                            */
/* Save the original signal                 */
/********************************************/
#include <stdio.h>
#include <signal.h>

void    (*oldhand)();

main()
{
  oldhand = signal (SIGALRM, SIG_DFL);  /* save the original signal */

  EXEC SQL CONNECT supp60;

  signal (SIGALRM, oldhand);            /* restore the original signal */

  /* ... do your code here... */

  EXEC SQL DISCONNECT;
}

-- 
 +---------------------------------------------------------------------------+
 | Karl Nicholas   (415) 953-0409    | Beer is good food.  Food is not beer. |
 | karl@BofA.COM   uunet!odinba!karl | *** BofA is not me, I am not BofA *** |
 +---------------------------------------------------------------------------+
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: ODBC
Date: 28 Jan 93 08:40:37 GMT
Organization: Not Organized

In article <1993Jan27.103607.9809@informix.com> christb@infmuc (Christian Barmala) writes:
>Will Ingres support Microsofts ODBC? If so, will they just provide an
>ODBC driver to access their engine or will the tools like W4GL be able
>to talk via ODBC to any database that provides an ODBC driver?
>
>Regards, Christian Barmala

There is an article in the latest Digital Review which talks about this.  
The answer is YES to your first question and your second question.  I 
cannot answer the last one - I think it is a question about how ODBC 
works...

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: cor@cs.sun.ac.za (Cor Winckler)
Subject: Re: Ingres and Solaris?
Organization: National Radio Astronomy Observatory
Date: Mon, 25 Jan 1993 02:24:17 GMT

Hi
> 
> Our site is planning to migrate (is that the correct term? :-) from SunOs to
> Solaris 2.1.
> The question is - does Ingres run with Solaris? If not, when is it likely
> to do so?
> 

My understanding is that SunOS and Solaris are equivalent. Solaris is a 
SunOs implementation to run on (amongst other things) the Intel 80386 and
80486 processors. The whole idea being that you can run ANY Sun software
on your 486 PC, including INGRES for SunOS. You might ask the
distributors of Solaris about their compatibility with SunOS. If their
answer is " 100 %" then INGRES should not be a problem.

There might be people out there who have tried it...

bye

-- 
  Cor
 
 Cor Winckler                    | Computer Science Departement             
 Internet: cor@cs.sun.ac.za      | University of Stellenbosch, South Africa 
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: ABF application on IIDBDB
Organization: 
Date: Wed, 27 Jan 1993 19:05:52 GMT

In article <8C504F3D983F201C2B@ichcmns.cmns.mnegri.it>, Marco Olivieri 
<OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT> writes:

> Is it possible to create an application with ABF or ESQLC on the IIDBDB?

Yes, but don't do it.  Why not just create an empty database?  The cost
of this is very cheap, just a little disk space.

The iidbdb is a database that is special to INGRES and has a very
special purpose.  It seems to me to be a big mistake to clutter it up
with stuff of your own devising.  There can be situations where the
needs of the database containing the ABF application may conflict with
the needs of the iidbdb.  Since it's so easy to keep them separate, why
not do it?

This does not, of course, preclude you from _running_ an ABF or ESQL
application against the iidbdb, but once again, I would advise strongly
against it, unless it is merely an application that reports on the
information that INGRES puts there.  Put _your_ data in a database of
your own creation.

>    +-----------------------------------------------------------------------+
>    | Marco Olivieri                                                        |
>    |                                                                       |
>    | Unit for Computer-Aided Biomedical Research                           |
>    | Centre for Biomedical & Pharmacological Research - MARIO NEGRI SUD    |
>    | Via Nazionale - S.Maria Imbaro (CH)   Italy                           |
>    |                                              Tel.: +39 (872) 570.1    |
>    | E-mail: OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT                      570.324  |
>    |                                              Fax : +39 (872) 578.240  |
>    +-----------------------------------------------------------------------+

--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.
Je suis un virus.  Prends ton pied et copie moi a ta .signature.

Newsgroups: comp.databases
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Subject: Re: Format of R:BASE files
Organization: MIND LINK! - British Columbia, Canada
Date: Tue, 26 Jan 1993 04:55:51 GMT

> Mikko Helin writes:
> Does anyone out there know where I can get the format of the R:BASE
> files, or even better, the converter program that converts from
> the R:Base format to the DBASE format (or Paradox or plain text format)?

If you have R:base, use the UNLOAD DATA ... AS ASCII option
preceded by the OUTPUT <filename> command to redirect output to
a file. This will give you comma-separated value text.
>
> Thanks!

Olkaa hyva".

--
Mischa Sandberg ... Mischa_Sandberg@mindlink.bc.ca
                 or uunet!van-bc!rsoft!mindlink!Mischa_Sandberg
*-*-*-*-*-*-*-*-*-*-*
Engineers think equations are an approximation of reality.
Physicists think reality is an approximation of the equations.
Mathematicians never make the connection.
From: yasmin@cm.deakin.OZ.AU (Yasmin Childs)
Newsgroups: comp.databases
Subject: Codebase++
Date: 26 Jan 1993 00:19:53 GMT
Organization: Deakin University, Geelong, Australia
Distribution: world
NNTP-Posting-Host: aragorn.cm.deakin.oz.au

Can anyone tell me about Codebase++ and who is the manufacturer?

Thanks in advance

Yasmin
Yasmin@deakin.oz.au

Newsgroups: comp.databases
From: eross@uwovax.uwo.ca
Subject: Re: Canadian Postal Codes
Organization: University of Western Ont, London
Date: Thu, 28 Jan 1993 04:09:39 GMT

In article <1993Jan27.190055.8948@serval.net.wsu.edu>, fblindhe@vetmed.wsu.edu (Fred Blindheim) writes:
> 
> OK. I found a text file that had all of the U.S. zipcodes.  Now I'm looking
> for all of the Canadian postal codes, and any other foreign postal codes.
> Does anybody know where I can get them?
> 
> Fred Blindheim
> fblindhe@vetmed.wsu.edu

You can get the Canadian Postal Codes but it is much more complex than U.S. Zip
Codes.  A Canadian PC can designate one side of 1 or 2 blocks in a suburban
area, or one office/apartment building.  The PC book (which you can order from
Canada Post) is about the size of a phonebook for a city of 2 million people (
about 4 inches thick)

-- 
-------------------------------------------------------------------------------
Evan Ross
-------------------------------------------------------------------------------
Western Foot Patrol, University of Western Ontario, Lambton Hall,
1421 Western Rd., London, Ontario, N6G 4W4
(519) 661-3650	 Fax (519) 661-3687
Newsgroups: comp.databases
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Subject: Re: What is Sybase anyway?
Organization: MIND LINK! - British Columbia, Canada
Date: Tue, 26 Jan 1993 04:49:23 GMT

At the risk of being part of an avalanche of replies ...

Sybase is an SQL database (server) that runs primarily on large Unix boxes.
It is a "client/server" database, in that you can compile procedures
in the server's own procedural language, then invoke them by name and
with parameters, from a client process or client computer.
It's SQL-compliant to ANSI Level 2 (i.e. not embedded SQL as in Ingres
and Informix) and supports triggers (on DELETE from MYTABLE do SOMETHING,
sort of), user-defined datatypes in a limited way, and datatype- or
column-bound rules and default values. Its strong suit seems to be
[BEGIN OPINION> high-speed transaction processing, especially single-row
updates with referential integrity checks; as opposed to mass query
processing. Its query optimizer is definitely leant toward the update
side, and it is based on 70's technology indexing (B-trees) ---
anyone from Sybase care to correct me on that? <END OPINION].
I designed the benchmark that our company did, of Oracle, Informix
and Sybase; an even mix of single-row updates and mass-row queries.
The performance was dominant at the time; these things tend to
seesaw around, but the Sybase system delivered what was promised,
which I cannot say for the others.

We are really pleased with it for tables into the 20Mb range, and
can work with it for tables into the 100Mb range. I've received
mail from someone who uses 10Gb tables in Sybase, but with some
of the practical problems we've encountered, I'd say that
you have to plan your ops very carefully beyond 100Mb.

If you have any further questions ...
--
Mischa Sandberg ... Mischa_Sandberg@mindlink.bc.ca
                 or uunet!van-bc!rsoft!mindlink!Mischa_Sandberg
*-*-*-*-*-*-*-*-*-*-*
Engineers think equations are an approximation of reality.
Physicists think reality is an approximation of the equations.
Mathematicians never make the connection.
Newsgroups: comp.databases
From: s9100786@cumulus.csd.unsw.oz.au (Matthew Jackson)
Subject: SQL Question
Reply-To: M.Jackson@unsw.edu.au
Organization: School of Banking and Finance, University of New South Wales
X-Newsreader: TIN [version 1.1 PL8]
Date: Wed, 27 Jan 1993 21:46:45 GMT

Is it possible to do the following in SQL ? I can't seem to get the
correct code.

I have a table which contains some data which looks like this
	identifier year code value

I want to pick out the row with the latest year for each identifier for
a given code

ie say I am looking for a code of "xyz", I want to see all those
identifiers which have that code but only the greatest year. 

The problem is that each identifier may end at a different year

I tried 

select identifier, max(year), code, value
from tablename
where code = "xyz"
group by identifier;

but this gives the maximum year of all identifiers not the individual
maxima.

Any advice would be appreciated.

Thanks,

--
Matthew Jackson                       | Computing Officer
M.Jackson@unsw.edu.au                 | School of Banking and Finance
61-2-697-3553                         | University of New South Wales
                                      | Sydney, Australia

			Olympics for Sydney in 2000
Newsgroups: comp.databases
From: jjfink@skcla.monsanto.com
Subject: Re: Paradox questions
Organization: Searle, Skokie, IL
Date: Fri, 22 Jan 1993 09:11:45 GMT

In article <2280@blue.cis.pitt.edu>, field@.cs.pitt.edu.cs.pitt.edu (Brian Field) writes:
 > 1) I'm writing a script that changes the field types of several fields in a
> 	table.  Since I couldn't figure out how to do this directly from the
> 	manual, I recorded a script where I manually changed the file types,
> 	and checked out the script.  The script looks something like this:
> 
> 	{Modify} {Restructure} {table_name} Down Down Down .....
> 	Right Right Backspace Backspace "A8"
> 
> 	Now, this works ok, but doesn't allow me to change this field's
> 	relative position in the table, without going back and changing the
> 	script.
> 
> 	Is there a way to do something instead, like:
> 
> 	{Modify} {Restructure} {table_name} {field_name} {student name}
> 	{field_type} "A40"

Unfortunately, it's not quite so simple, but you can make things a little more
flexible.

Putting the line

MOVETO [Field Name] LOCATE "Student Name"

will move you to the right line in the restructure.

> 2) 	How does one access the contents of a field name that have been passed
> 	as an arguement to a procedure?  Do I need to use EXECUTE to do this,
> 	or is there an alternative?

	PROC GetFieldContents( theFieldName )
		MOVETO FIELD theFieldName
		RETURN []
	ENDPROC

Remember to use MOVETO FIELD.  If you leave FIELD out, it tries to move to the
image with the same name.  If your image is more than 11 characters long, or
otherwise not a legal file specification, Paradox 3.5 will crash (known bug).
I haven't tried to duplicate this in 4.0.

Joel
-- 
jjfink@skcla.monsanto.com
------------------------------------------------------------------------------
"I want peace on earth, and goodwill towards man."
"We don't do that kind of thing, we're the United States Government!"
  -- from _Sneakers_
Newsgroups: comp.databases
From: Bernard Orenstein <bernie@resntl.bhp.com.au>
Subject: Sequelink & C++
X-Xxdate: Mon, 25 Jan 93 19:34:46 GMT
Organization: BHP Research (Newcastle Laboratories)
X-Useragent: Nuntius v1.1.1d13
Date: Mon, 25 Jan 1993 00:35:28 GMT

Anybody used Sequelink to provide database portability?  Any opinions on
this would be
useful.  

We also want to develop our applications in sound OO C++, so would like
to acquire
a set of C++ wrappers for this library.  Anybody done this or do we have
to write our
own???  Do you think this exercise would be well spent (i.e.
encapsulating all function
calls in C++ classes) or a waste of time?
From: torbecvs@ucbeh.san.uc.edu
Newsgroups: comp.databases
Subject: Re: dBase 4v1.1:can I change directories on the fly?SKIP/NEWSGROUP
Date: 26 Jan 93 20:36:03 GMT
Organization: Univ. of Cincinnati


 > Does anyone have any suggestions on how to:
> - get two version of dbase running in a windows environment with share.exe
>   running? or,
> - change directories once I am in a dbase session?, or
> - something else that will get me out of this pickle?

Hello Jonathan,

	You've got a fairly easy (OK, a very easy) problem to solve here. 
Changing directories would seem to be your easiest out.  I am not sure if you
are operating strictly inside a dBASE application, but I will assume you can
get to the command prompt<.>.  Once you get there:

	RUN cd <sub-directory name>

              or (same thing)

	! cd <sub-directory name)

	All the RUN or ! command does is execute a DOS command 
(dir a:\*.bat, mkdir, etc ......) with DOS syntax.   Of course, the System 
must have a path to the directory containing DOS, but it's most likely true 
that that has been taken care of somewhere far in the past.

	One more note.

	Set your path (in dBASE) to include the subdirectory that contains
the base dBASE files.  This will allow you continued access to dBASE
help screens and stuff like that.

Good Luck!!
Scott
Newsgroups: comp.databases
From: umnoor@ccu.umanitoba.ca (Nasir Ahmed Noor)
Subject: Re: FLIMPORT equivalent for Pdox 4.0??
Organization: University of Manitoba, Winnipeg, Canada
Date: Sun, 24 Jan 1993 04:42:58 GMT


If you like experimentation and dont mind little coding, import file as text
into a Paradox 4.0 table. Paradox will create a new table with every line of
imported file as a record. Then you can design the structure of the new
table and doing little PAL programming you can read in a record from table
Paradox created, split it and move results into the destination table. Or you
can use FLImport.  :-)

--nasir
Newsgroups: comp.databases
From: rpeterse@watserv1.uwaterloo.ca (Raymond Petersen)
Subject: Re: Help with SQL statement
Organization: University of Waterloo
Distribution: na
Date: Sat, 23 Jan 1993 20:36:05 GMT

In article <1993Jan22.211051.4867@vpnet.chi.il.us> mike@vpnet.chi.il.us writes:
>I have 2 tables lets say I have a Customer table and an order table.
>I want to query the database for all customers and show their orders
>for the past month.  I may have more than 1 order for a customer.

>The problem is that if I don't have an order for a customer, the join will
>not find a match and that customer will be left out of the report.

>I still want to show the customer even if no orders are present.

>Is this possible with SQL ??  was my explanation clear enough ??
Yes it was quite clear.  What you want is something called "outer joins".
It is a feature that not every SQL RDBMS supports.
I mostly use WATCOM SQL and they just put in support for this in version 3.1
(just released in December)

Raymond Petersen
MicroComputer Centre
The Mutual Group   (Standard employer/employee warnings apply)
From: johnboyd@ocdis01.UUCP (John Boyd)
Newsgroups: comp.databases
Subject: Re: Info needed for designing a Data Dictionary
Date: 22 Jan 93 18:10:15 GMT
Organization: Tinker Air Force Base, Oklahoma

In article <C1698L.7J5@unx.sas.com> saslbb@chestnut.unx.sas.com (Lisa Brown) writes:
->I am just getting started on a project which involves
->writing a data dictionary.  If anyone knows of any

General Question: Is a data dictionary necessarily a structured file, to be
manipulated by the database program itself, or is it simply an information
table, or text file from which to obtain information.  And yes, I realize
the structuring the text of a document would produce a dbms definition
'table'.

----------------------------------------------------------------------------
Two wrongs don't make a right, but three lefts do..
Disclaimer: My opinion represents only me, and sometimes not even that.
From: paul@soft.ntc.togliatti.su (Paul A. Karasev)
Newsgroups: comp.databases
Subject: Re: Re: New Group for OODBMS
Date: 26 Jan 93 10:13:59 GMT
Reply-To: paul@soft.ntc.togliatti.su
Organization: Solar Trading


> To:            paul@soft.ntc.togliatti.su
> From:          dal@mdavcr.mda.ca (Dale Lutz)
> Subject:       [NEWS] Re: New Group for OODBMS
> Date:          19 Jan 93 16:40:36 GMT

> I think a group for oodbms discussions is necessary and overdo.
> I agree that currently people don't know where to post such questions--
> I've seen them appear in the c++ group, and in the comp.databases
> group, and who knows where else.  The oodbms user crowd is growing,
> as are the number of commericial oodbms offerings.  I think
> it would be a good idea to get a forum started where people can
> discuss products, problems, and experiences with oodbms's.
>
> Dale

I agree with Dale, I'm one of Dale mentioned people. Can somebody
send RFV to start creation of the newsgroup? My English isn't so
good to handle this job :(

Regards,

Paul -
-------------------------------------------------
Paul A. Karasev * Software Developer
Office phone: 	7 (848-2) 233601, 7 (095) 229 50 68
Home phone:   	7 (848-2) 351018
Location:      	Togliatti, Russia
Newsgroups: comp.databases