HDTenEightyP/NetNews huggingface dataset:
From: u9048979@cc.uow.edu.au (glen eastment)
Subject: Re: Clipper: Backup/Restore routines for BIG files...
Organization: University Of Wollongong
Date: Wed, 2 Sep 92 02:41:36 GMT

schli@cs.tu-berlin.de (Wolfram Schlickenrieder) writes:


>	Hi there...

>	I'm stuck: I wanted to write a backup & restore routine for an
>	application I wrote before, but I have got a few data bases
>	which are HUGE (2-4MB) and therefore won't fit on a single
>	disc. Has anyone out there done that before from within a
>	Clipper application (without using "run backup ..." of
>	course)? 

>	Any help is appreciated...

>	...Wolfram


If your data can be split up in some way, eg. a range in customer number,
then you can split up sections of the database onto various disks.

eg. 	disk 1 - cus no. 0000-1000
	disk 2 - cus no. 1000-2000....etc.

This is really just about the only way I can think of splitting the database
without using external commands (eg. 'run backup....').

The problem with this is that you'd want there to be a relatively even
distribution of data items - this is not always the case.

Putting it together again, should be just about as easy as taking it apart.

Hope this helps - if you think of a better solution, let me know, because
I may have the same problem oneday myself :-) .

Cheers!

<GE> a.k.a. u9048979@wampyr.cc.uow.edu.au

Newsgroups: comp.databases,comp.databases.informix,comp.databases.oracle
From: tcox@netcom.com (Thomas Cox)
Subject: Oracle non-posting (was Re: Informix vs. Oracle)
Date: Tue, 01 Sep 92 01:01:12 GMT
Organization: Netcom - Online Communication Services (408 241-9760 guest)
Followup-To: comp.databases.oracle

randall@informix.com (Randall Rhea) writes:
>mathews@bones.ecs.umass.edu (Mathew J Mathews) writes:

>>I have compiled a list of the comments mailed to me, if anyone is interested
>>I can post it.  The replies were mostly in favor of Oracle.  Actually,
>>he score is about --

>>		Oracle:		A gazillion
>>		Informix:	1

>All of the replies that were actually posted on the net were
>in favor of Informix.  Perhaps you can share your replies
>that favor Oracle.  We would certainly be interested in what
>they had to say.

(This has since been posted.)

I did notice several followups from Informix, and far fewer from Oracle.
That's not surprising.  Oracle's MIS group don't officially support
Netnews as of the last time I asked them to, a few months ago.  If
anyone can post from Oracle, they are lucky or are running their own
news box.

(Since this is now about Oracle Corp. supporting netnews, followups are
directed to comp.database.oracle.)

As for me, I pay money to Netcom to get reliable two-way netnews.

I work for Oracle.

Cheers.
	-- Tom
-- 
Tom Cox      DoD #1776   '91 CB 750 Nighthawk   tcox@netcom.netcom.com
My opinions!  Mine!  Not those of Netcom, or Oracle, or anybody else I know...
Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
From: tensmekl@infonode.ingr.com (Kermit Tensmeyer)
Subject: Re: Objects and Oracle?
Organization: Intergraph Corporation, Huntsville, AL.
Date: Sat, 29 Aug 1992 22:20:11 GMT

In article <1992Aug28.214443.24903@IRO.UMontreal.CA> jalbert@IRO.UMontreal.CA (Francois Jalbert) writes:
>Greetings all!
>
>Our company develops software to run under Windows using the toolbook package 
>in the early development phases. We do everything using objects and fairly 
>complex inheritance schemes. Our current task is to develop some software to 
>act as a front end to some relational database system. We are currently trying 
>to figure out if Oracle might do the job for us. We phoned the local Oracle 
>outfit but their answers were very vague, to say the least. I hope that by 
>asking to net, somebody out there will know more than our local Oracle folks. 
>
>Primarily, the database manager we seek should
>
>  - be a true RDBMS
>  - manage table creation and updates using SQL commands
>  - run under Windows 3.1 on top of DOS 5.0
>  - be callable from C (or C++) according to the DB2 standard of embedded SQL
>  - support referential integrity, transaction security (commit rollback),
>    multiusers, networks, to name the few I can think of at the moment.

 Now I know what I _mean_ when I say a true RDBMS manager, but what do
 you mean when you use the term? If you are asking if any commerical
 product meet more than 75% of the criteria that Codd used to define
 an RDBMS, then the answer is NO. There are no commercial True RDBMS's
 available.

 Is it possible to support multiuser client/serever on anything other
 than a dedicate machine under dos. I don't think so.

 There may well be a single user version of Oracle and or Informix
 that will run on Windows 3.1 or even NT.

 The problem is not Intel, but the operating system.  If you would upgrade
 your requirements to use a modern system you cound network several
 user interface systems around a central server and then use either
 Informix SE or Oracle. Unless your application has only a trival
 use for databases, stay the hell away from Informix standard engine.
>
>
>


-- 
         Kermit Tensmeyer                         | Intergraph Corporation
Life is sometimes a bowl of Cherries; Watch out for the pits;
   klt@kt8127.b23a.ingr.com                       | 
Newsgroups: comp.databases
From: pjyamamo@watdragon.uwaterloo.ca (Peter Yamamoto)
Subject: CASE tools (public/share/research...)?
Organization: University of Waterloo
Date: Thu, 3 Sep 1992 18:43:29 GMT
X-Mailer: ELM [version 2.3 PL11]

Does anybody know of any cheap (read free) CASE tools available?
Preferebaly UNIX based but MAC or PC would be ok too.
I am aware of commercial products but can't afford them.

I am not looking for anything too sophisticated.
I need to document a database design and would like some tool
which allows one to define an Entity-Relationship data model
and has tools for summarizing/drawing ER diagrams etc.

I will summarize here if I get any answers.
Thank you,
Peter
From: mikes@vivanet.UUCP (Michael Shea)
Newsgroups: comp.databases
Subject: Progress
Date: 4 Sep 92 12:59:50 GMT
Organization: VIVATRON Corporation


 have just been dubbed "Progress Programmer" by the boss.  I, however
have no Progress experience and am looking for a few good books.

Can anyone make suggestions for me?  I am using the latest and greatest
version, (PADS) which includes Fast Track, and all the goodies.

Any replies will be gratefully accepted.

Mike Shea




Michael G. Shea
VIVATRON Corporation
Rochester, NY
From: daryl@piano.adept.ih.att.com (55000-Daryl Monge(ih1439)392)
Newsgroups: comp.databases.ingres
Subject: Re: Replicating Databases
Date: 31 Aug 92 23:50:18 GMT
	<Btv3Et.JHn@usenet.ucs.indiana.edu>
Organization: 5ESS(TM)-US Release Management
In-reply-to: mdchaney@fractal.ucs.indiana.edu's message of 31 Aug 92 18:59:17 GMT

In article <Btv3Et.JHn@usenet.ucs.indiana.edu> mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney) writes:

   I couldn't imagine too many people having views depending on views, though,
   so I count this as only a borderline bug.

Not at all.  I consider this a very serious bug.  The view paradigm is what gives
abstraction to the relational system and views of views is often the only way to
get a readable set of queries when you need to contend with complexity.

This bug has been a bug for a long time also.

Daryl Monge			AT&T Bell Labs
EMAIL: daryl@adept.att.com	VOICE: 708-713-4696
PAPER: Rm 2A-448   P.O. Box 3050, Naperville, Il 60566
From: sophia@syd.dms.CSIRO.AU (Sophia Liow)
Newsgroups: comp.databases.ingres,comp.databases.sybase
Subject: information request
Keywords: ingres, sybase
Date: 31 Aug 92 00:22:18 GMT
Organization: CSIRO Division of Mathematics and Statistics, Australia

We are in the process of trying to set up some databases. 
Currently we have 3 in mind

- a database of customer information 
- a database for bug reporting of software that we develop
- a database for keeping track of user problems/requests within our
  division and our response.

I have no experience in database packages.
We have been looking at Sybase and Ingres up to date, and would like to
find out from those who have been using these packages some information
which may help us decide which would suit our needs better.

- what capabilities or features of these package made you decide on one
  rather than the other

- having used the package, are there any annoying things that we should
  take into consideration

- was it easy to use in the first instance, time required to implement a
  simple database

- how would you rate the documentation

- are you happy with their support (if you have software support)

- any other information that you think we should take into consideration
  before we  make a choice

I would appreciate any response via email please.

Thank you for your time
Sophia

(:------------------------*   *----Sophia --------------------------Liow----:)
|    +==^      ,           \ /  CSIRO, Div. of Mathematics & Statistics      |
|    !__  _ !_.!_  "  _     I   Private Bag 10, Clayton, VIC 3168, Australia |
|       !{_}!_}! ! % {_&.   I   email: sophia@mel.dms.CSIRO.AU               |
|    `=='   !              / \  Tel: +61 3 542 2267   Fax: +61 3 542 2474    |
(:------------------------*   *---------------------------------------------:)
From: jjm+@andrew.cmu.edu (James J. Murawski)
Newsgroups: comp.databases.ingres
Subject: Re: using "ping" and "pong" tables
Date: 3 Sep 92 03:51:36 GMT
Article-I.D.: andrew.kedTl8C00iUyQ1IHEA
	<1992Sep2.173422.9570@tpghq.com>
Organization: Administrative Systems, Carnegie Mellon, Pittsburgh, PA


On 02-Sep-92 in Re: using "ping" and "pong"..
user Steve Caswell@tpghq.com writes:
>user Alan Croswell@curta.cc.columbia.edu writes:
>>I have a number of large "production" tables that are being hit on
>>interactively 'round the clock primarily for reads plus a bunch of 
>>"overnight" update jobs lock these tables exclusive for extended
>>periods.  I was thinking about have two versions of the same table,
>>and ping-ponging back and forth between them by simply having all my
>>programs use a variable for the "current" table which itself would
>>be in a table somewhere.  This seems like it is probably a pretty
>>common practice and I figured I see if any of you have any pointers....
>>Thanks.
>>/a
> 
>One problem you will have if you are using Embedded/SQL is that you
can't simply
>"use a variable for the current table" in standard SQL.  You would have to 
>convert all your queries to Dynamic SQL, which may or may not be difficult
>depending on what you are doing.  Most non-select statements can be performed
>rather easily in Dynamic SQL without much work, as can singleton selects.
>Multiple row selects require more work, and setting up the code for this is
>not trivial.

However, if you use views for your selects, you won't need dynamic SQL.
Suppose you have tables "ping" and "pong".  Table "pong" is the exact
duplicate of table "ping".  Each is used on alternating days.  Suppose you
do your daily table switch at 2:00 AM.  All you need is two definitions for
the same view.  Create a view called "pingpong".  On the days that "ping" is
your target table, use the "create view pingpong as select * from ping"
definition.  On the other days, use the "create view pingpong as select *
from pong" definition.  At 2:00 AM, you'd just drop all the "pingpong"
views, re-create them, and reassign permissions, all in some script.

====================================================================
    Jim Murawski
    Sr. Data Base Analyst               (412) 268-2650  [office]
    Administrative Systems              (412) 268-6868  [fax]
    Carnegie Mellon University          jjm+@andrew.cmu.edu
    4910 Forbes Avenue                  Office: UCC 155
    Pittsburgh, PA 15213-3890
Newsgroups: comp.databases.ingres
From: KOSTER@CDHF1.GSFC.NASA.GOV
Subject: Varchar Column with Binary Data, reply
Organization: nrao
Date: Thu, 27 Aug 1992 11:21:27 GMT

Thanks to all those who responded to my question regarding the storage of
generic binary data in VARCHAR columns.

As it turned out, my coworker had been reading the ESQL Companion for C, but
had incorrectly set up a typedef for the VARCHAR structure rather than a
variable declaration.  It worked as soon as that was fixed.

Thanks again,

Bill Koster
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Access two INGRES databases from one application
Organization: 
Date: Sat, 29 Aug 1992 08:09:45 GMT

In article <Btnr4o.1zA@usenet.ucs.indiana.edu>, 
mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney) writes:
> 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?
> 
> 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.

You can also do this within an ABF application, with caution.  You can
call a 3GL procedure to connect to another database (or another session
on the same database), and access stuff in that database from other 3GL
procedures.

The only caveat is that you must always switch back to the session that
was created for the ABF application before you return from the 3GL
routine.  This implies that each such 3GL procedure must contain
something like this:

	exec sql BEGIN declare section ;
	int abf_sess ;
	exec sql END declare section ;

	exec sql INQUIRE_SQL ( :abf_sess = session ) ;

	exec sql SET_SQL ( session = :other_sess ) ;
	...
	exec sql SET_SQL ( session = :abf_sess ) ;
	return ;

If you forget to switch back to ABF's session, then ABF actually notices
and tries to reinitialize some things, which can lead to some very
bizarre bugs (I know, I've tried it), especially if you use "where
qualification" (the INGRES initialization code gets interleaved with the
"select" which is dynamically generated).  I think I remember seeing
something about this in the release notes for 6.4/01.  Also note that
the session number ABF uses does not conform to the rules for session
numbers that are stated in the SQL Reference Manual.  I think it has the
value "-1".  It's probably not supported, but it works and it seems like
something that would continue to work.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: INGRES date data type
Organization: Palmer & Associates, Inc.
Date: Fri, 4 Sep 1992 12:28:18 GMT

x
(intervening text omitted)

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

Yes, you can in fact extend INGRES with user-defined datatypes.  To do so, you
must provide INGRES with code to manage all aspects of the data, including how
the data is stored internally, how it looks to the outside world, how to compare
two values of the datatypes, how to add and subtract values, how to calculate a
hash representation of the value, etc.  It is not simple to implement even a
more standard type such as an ordered pair.  It would be very complex to attempt
to implement a date data type.  INGRES does not give you any way of extending
one of the existing data types, so it is not a matter of just taking their
existing date and adding the extra fractional second piece.

>
>I'll summarize the responses I collect.
>
>Thank you in advance,
>
>Arthur George, NRL
>ageorge@BDCI143.nrl.navy.mil

-- 

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: jaa@world.std.com (Jerry A Abramson)
Subject: Ingres ESQL/and EFRS/C contractor in Chelmsford, MA needed.
Organization: The World Public Access UNIX, Brookline, MA
Distribution: usa
Date: Tue, 1 Sep 1992 18:28:28 GMT



Voicetek is currently involved in a project that involves an Ingres
Database.  I am looking for some outside development help with the Ingres
forms (using Ingres Embedded FRS), and the Ingres transaction processing
(locking) system.  If you know of someone with strong C/UNIX skills and
Ingres database experience, I would appreciate E-mail or a phone call.

This person would need to be on-site for about a month in Chelmsford, MA.



						Thanks, in advance,



						Jerry Abramson
						Voicetek Corporation
						jaa@world.std.com
						Voice: (508) 250-7957
						Fax: (508) 250-9378

Newsgroups: comp.databases.ingres
From: CS_PAUL@GSBVAX.uchicago.edu (Paul Ford 312/702-0335)
Subject: Re: sending parameters to reports
Organization: nrao
Date: Tue, 25 Aug 1992 20:52:16 GMT

Victoria Pickard writes:
>I'm trying to pass a value in a field of a record as a report
>selection criteria.  For instance, the user might scroll through and
>select a record & then choose to generate a report on that record.
>
>But I can't seem to get a field's value to pass correctly.  The report
>function is written in C using the "system" call, which doesn't take
>parameters.

The description of your problem is a bit sketchy, I hope the following
discussion hits the mark.

If you are trying to execute the a report from an application you
probably want to execute a command something like:

        report mydb myreport (param1=99)

where param1 is the name of the numeric report writer parameter you
allude to.

You can do this in two basic ways:

    1. Start a subprocess to execute the above command. This is done
    with the C system() function or the INGERS CALL SYSTEM statement.

    2. Use the INGRES CALL REPORT statement, available in 4GL and
    embedded SQL.

The first solution will start a whole new database session.  The second
solution reuses the current session to run the report and for that
reason is preferable.

In either case the problem of passing a form field value to the report
is a matter of formatting the field value as part of a parameter string
passed to the SYSTEM or CALL REPORT command.  Some fragmentary examples
follow.

Example 1: CALL REPORT from C:

        exec frs getrow table ( :xx = column ) ;
        sprintf(param_string, "param1=%d", xx ) ;
        exec sql call report ( database = 'mydb'        ,
                               name     = 'myreport'    ,
                               param    = :param_string ) ;

Example 2: CALL REPORT from 4GL:
        call report (name='myreport', param='param1='+varchar(table.column) ) ;


Example 3: C library system() function.

        exec frs getrow table ( :xx = column ) ;
        sprintf(command_string, "report mydb myreport (param1=%d)", xx ) ;
        system(command_string) ;

Example 4: CALL SYSTEM from 4GL.

        call system 'report mydb myreport (param1=' + varchar(table.column)
                    + ')' ;


Paul Ford
--------------------------------------------------------------------------
GSB Computing Services                  312.702.0335
University of Chicago                   cs_paul@gsbvax.uchicago.edu
1101 E. 58th Street
Chicago IL 60637
--------------------------------------------------------------------------
Newsgroups: comp.databases.ingres
From: eric@desktalk.com (Eric Lieber)
Subject: Ingres - help with DateTime values
Reply-To: eric@desktalk.com
Organization: Desktalk Systems Inc.
Date: Mon, 31 Aug 1992 18:07:20 GMT

I am posting this because I do not have Ingres yet and therefore I cannot try itout myself.

I want to insert a datetime value into a table. The format I have to use is:
	"yyyy-mm-dd hh24:mi:ss"
where hh24 is the 24 clock , (13:00 = 1:00 pm)

After reading the manual, I assume that the  II_DATE_FORMAT varable must
 be to set to  'SWEDEN/FINLAND'.

 The question is will Ingres  accept the following:
 insert into test_table (date_col)
           values (	"1992-12-31 13:45:59");

Thanx for any info.

ps. isn't it amazing that none of the 4 databases (sybase, oracle, informix and ingress) have the same datetime definitions when creating a table and  same format when inserting a value!!!!!! 

Eric Lieber
DeskTalk Systems


Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: INGRES date data type
Organization: 
Date: Thu, 3 Sep 1992 22:17:23 GMT

In article <3505@ra.nrl.navy.mil>, ageorge@BDCI143.nrl.navy.mil
(Arthur George, NRL) writes:
> 	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?

Once upon I time I dumped the INGRES data files to see if I could figure
out how they store dates, and I think I decided that times are actually
stored down to the 1000th of a second.  However, INGRES gives you no way
of getting at its internal date data.  When you select a date or a time,
all you get back is a character representation.  You can get at the
parts with the date_part() function, but the smallest granularity it
returns is seconds.

The INGRES extension that you refer to is the optional Object Manager
(costs 50% of base, I think).  What this product does is allow you to
extend the dbms server.  What you have to do is write some code (in some
3GL language, maybe only C).  You then compile and link it with
Ingres-supplied libraries to create a new server program (replaces
iidbms.exe).  This new server can understand new datatypes, new
functions, and can extend existing syntactic elements (e.g., min(),
max(), +) to the new types.

In your case, you could create a brand-new datatype, but it might be
easier to create some new functions that work with the existing date
datatype.  These functions would allow you to get at the fractional
seconds for which there is actually already room in the INGRES datatype. 
I'm not sure what you would have to do for inserting, though.

While this is not impossible, it's probably not for the faint of heart
either.  It seems a somewhat daunting task for a pedestrian applications
coder like me.  8^)  Plus, we don't have the bucks or the resources to
put into writing new server code.

I keep waiting to hear about Object Manager products from third parties,
but I haven't heard anything yet.  I guess most people are just living
with INGRES's limitations.

--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: akk9180@ritvax.isc.rit.edu
Subject: INGRES/VMS
Reply-To: akk9180@ritvax.isc.rit.edu
Organization: Rochester Institute of Technology
Date: Wed, 2 Sep 1992 21:02:32 GMT

We are currently running INGRES on DECstation 5000s under ULTRIX.  We
are seriously evaluating a platform/o.s. change.  VAX/OPEN VMS.  SUN.
Long term we are planning on Alpha/OSF.  However, we are going to
need more horsepower before DEC will be ready with or we will be
comfortable with Alpha/OSF.  How about some feedback from some users
about their platforms.  We would need connectivity with our other DECstation
file servers serving Pathworks (TCP or DECNET).  Thanks!

						Alok Kapoor
						Harris Corp.
						(716)244-5830 x3663
						AKK9180@RITVAX
Newsgroups: comp.databases.ingres