HDTenEightyP/NetNews huggingface dataset:
From: sjs@netcom.com (Stephen Schow)
Subject: Re: READ ME---READ ME -- - READ ME -- READ ME
Date: Fri, 21 Aug 92 21:48:12 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 

I still don't see what the problem is with just replying to News.  Its such
a time saver for everyone concerned.
-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs@netcom.com | pick the pear with the big paw paw......
               | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: george@unixg.ubc.ca (George chow)
Subject: How to cancel a SQL*Form entry...
Followup-To: comp.databases.oracle
Originator: george@unixg.ubc.ca
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Wed, 12 Aug 1992 21:44:29 GMT

Howdy,
I have a question about changing the behaviour of SQL*Forms 3.0. Currently,
it is possible to cancel an [Enter Query]. However, it is not possible to
cancel a data entry without exiting the form. I.e., the only way to cancel
is to press [Exit]. Is there any way to change this? I've gone through the
packaged procedure list and I can't find anything I can use there. Any
pointers/explanation would be appreciated. Thanks.

George


Newsgroups: comp.databases.oracle
From: ronk@beta.lanl.gov (Ronald John Krantz)
Subject: Problem Using SQR on HP LaserJet
Organization: Los Alamos National Laboratory
Date: Thu, 13 Aug 1992 17:44:46 GMT

We have successfully used SQR (2.27) with Oracle (6.0.31) on VMS (5.5)
for many months.  A problem has come up that the very helpful folks
at SQL Solutions (Sybase) have not been able to correct.  I would 
appreciate a clue from one of you experienced SQR/Oracle/VMS users.

A report named RCODE is run that uses the new support for HP LaserJet
printers including the capability to draw boxes, use fonts, . . .
When the report is run with input parameters specifying one or two
months worth of data, everything works fine.  When the report is run
with input parameters specifying a year's worth of data, the report
completes okay, but trying to print the output to the LaserJet II or 
LJ III results in:

 %PSM-E-READERR, error reading $7$DIA2:[directory]RCODE.LIS;1
 -RMS-W-RTB, 60922 byte record too large for user's buffer

Has anyone experienced this and found a solution?

*******************************************************************************
Ron Krantz                                                        
MS B295                                         Internet: ronk@lanl.gov 
Los Alamos National Laboratory                  Voice:    (505) 665-5231  
Los Alamos, NM  87545
*******************************************************************************
-- 
*******************************************************************************
Ron Krantz                                                        
MS B295                                         Internet: ronk@lanl.gov 
Los Alamos National Laboratory                  Voice:    (505) 665-5231
From: deflenniken@beckman.com
Newsgroups: comp.databases.oracle
Subject: Re: SQR bought by Sybase; Future direction of SQR?
Date: 12 Aug 92 18:53:07 GMT
Organization: Beckman Instruments, Inc.

In article <qZaePB1w164w@cellar.org>, kml@cellar.org (Lazlo Hoover Toth) writes:
> deflenniken@beckman.com writes:
> 
>> In article <1992Aug5.232734.9943@oracle.us.oracle.com>, dbmoore@us.oracle.com
>> > In article <kpalm.712606717@athena> kpalm@athena.qualcomm.com (Kent Palm) w
>> >>Now that Sybase owns SQR (Structured Query Report Writer) originally develo
>> >>by SQ Software, the question is what kind of support is Sybase going to
>> >>provide for the SQR Oracle interface?  Oracle v. 7 support?  Timeframe?
>> >>
> 
> I would like to pass on my experience with SQR and the Oracle V7 Developers
> Release.  After going through the trauma of installing V7, SQR linked withi
> no troubles whatsoever.  The only problem I have encountered with it thus
> far is when running the EXPORT.SQR program, since the datatypes it looks 
> for are hardcoded.  This is any easy fix for anybody.  I'd like to point
> out that SQL*TextRetrieval 2.0 Beta has not yet linked correctly to V7
> at my site.  And having suffered through two years of a beast called
> SQL*ReportWriter...but I digress.  SQR works just dandy with V7.
> 
> Cheers.
> Kevin.
> 
> This message may not be rebroadcast without the express written consent of 
> the Baltimore Orioles and Major League Baseball.  Send $2 for transcripts to
>   kml%cellar@tredysvr.tredydev.unisys.com  - My other account is a Mercedes.

It is good news indeed to here of your success with SQR and V7. I too have 
suffered with SQL*Reportwriter and SQR was the medicine the cured the illness.

I've installed V7 on VMS but haven't yet tried to link in SQR ... now
I guess I will.

Regards,
Darrell
From: asymes@nl.oracle.com (Andy Symes)
Newsgroups: comp.databases.oracle
Subject: Re: READ ME---READ ME -- - READ ME -- READ ME
Date: 21 Aug 92 12:36:16 GMT
Organization: Oracle Europe

In article <5y#nh5j.sjs@netcom.com>, sjs@netcom.com (Stephen Schow) writes:
|> I would like to suggest to everyone that is reading this group that they
|> try to forward their responses to questions back to the group instead of
|> just replying to the individual users.
|> 
|> Whenever I ask a specific question, I always get 4-5 responses, which are
|> very helpful to me, but not to anyone else who is reading the list and may
|> also have interest in the topic.
|> 
|> I know there are many times when I see someone ask a question and I wish
|> I could see the responses he got.
|> 
|> What do ya think?
|> -- 
|> ------------------------------------------------------------------
|> Steve Schow    | But you don't have to use the claw, if you
|> sjs@netcom.com | pick the pear with the big paw paw......
|>                | Have I given you a clue......?
|>                |                       - Baloo the Bear
|> ------------------------------------------------------------------

Basically, I agree, but remember that not all sites are actually able to post
news.

Andy Symes.

Disc-laimer, etc
Newsgroups: comp.databases.oracle
From: doc@magna.com (Matthew J. D'Errico)
Subject: Re: READ ME---READ ME -- - READ ME -- READ ME
Organization: Magna Software Corporation
Date: Fri, 21 Aug 1992 15:22:12 GMT

In article <1992Aug20.220354.866@pmafire.inel.gov> cdm@pmafire.inel.gov (Dale Cook) writes:
>In article <5y#nh5j.sjs@netcom.com> sjs@netcom.com (Stephen Schow) writes:
>>I would like to suggest to everyone that is reading this group that they
>>try to forward their responses to questions back to the group instead of
>>just replying to the individual users.
>>[...]
>
>I think that it is proper to reply by email.  I also think that it is
>the duty of the person asking the question to summarize all such replies
>and post a summary.  It's something that should be done and isn't done
>enough, IMHO.

So that's why you posted your response ?

Really, though, that's not intended as a flame, just as fuel for *my* $0.02.

I think it's the judgement of the User who's responding to the post.
In many cases, when it's a techical question, email responses are more
appropriate simply because in 99% of the cases, they will arrive first
and can open a channel of communication in case more info is needed.  Also,
most people read email several times a day and news maybe once or twice.

If the question is philosphical (you know what I mean !), then certainly
posting a follow-up article is more appropriate than email...

Naturally, there are large grey areas involved between these two that
are simply the judgement of the two users involved.

Oh, and I *strongly* agree with your "summary" comment.  The price of
free help should definitely be to post a summary.  I look at it as
simply professional courtest, but some people need more motivation.

Regards --

-- Doc
Newsgroups: comp.databases.oracle
From: a2824ag@sunmanager.LRZ-Muenchen.DE (Riaan de Jager)
Subject: Key Triggers in Forms3.0 - redefinition
Organization: Leibniz-Rechenzentrum, Muenchen (Germany)
Date: Sun, 16 Aug 1992 13:50:47 GMT

Hi

I've just switched over from v2.3 to v3.0 forms.

I want to redefine keys - to move between blocks, disable keys etc.

However, if I redefine eg. the KEY-Delrec trigger to do nothing i.e.

NULL;

this takes no effect.

Do I need to set something somewhere? What am I doing wrong?

Thanks!
-- 
 ---------------------------------------------------------------------------
|  Riaan de Jager           a2824ag@sunmanager.lrz-muenchen.de              | 
|  Leibniz Rechenzentrum    jager@informatik.tu-muenchen.de    |         /  | 
|  Barer Strasse 21 8000    Tel +49 89 2105 7402                \    *  /   | 
|  Muenchen 2                                                    \     /    |
|  Germany                                                        ;___/     |
 ---------------------------------------------------------------------------
Organization: University of Maine System
Date: Thursday, 13 Aug 1992 15:53:22 EDT
From: Ginny Gibson <GIBSON@MAINE.MAINE.EDU>
Newsgroups: comp.databases.oracle
Subject: Oracle Documentation

Does anyone know of a good general reference manual for Oracle?
Both "Using Oracle" by Que, and "Understanding Oracle" by Sybex
are out of print.

Please reply via e-mail.
Thanks,
Ginny Gibson       GIBSON@MAINE.MAINE.EDU
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Re: Vanishing data in Dynamic tables v$... ?
Date: 21 Aug 92 08:16:12 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

In article <BtAJKF.Axo@nntp-sc.Intel.COM>, kortikar@mipos2.intel.com () writes:
> I am trying to find out type of locks held by users on various tables.
> I can do this by querying tables such as v$access,v$process etc. but if any
> user hold locks on table for quite long period then that data is removed from
> dynamic performnce tables such as v$access. If he touches the tables again
> then data will appear again.!
> 
> How can I get static data from dynamic tables!


I can't believe that ...

v$access doesn't give you any reference wich locks held by users. I think
this dynamic table only holds information about the tables used by last
access. If you want to get information about the locks you must query the
v$lock table for each pid.

You can decode the ID1 column joining it with the OBJECT_ID of the 
ALL_OBJECT (for special tables like OBJ$ use v$access) table 
(only for ID2 = 0). So you can get the table name, type and mode of the locks.

modes..............

 WHEN '1' THEN COPY 'ROW EXCLUSIVE MODE' INTO :locks.modetxt;
 WHEN '2' THEN COPY 'ROW SHARE MODE' INTO :locks.modetxt;
 WHEN '3' THEN COPY 'ROW EXCLUSIVE MODE' INTO :locks.modetxt;
 WHEN '4' THEN COPY 'SHARE MODE' INTO :locks.modetxt;
 WHEN '5' THEN COPY 'SHARE/ROW EXCLUSIVE MODE' INTO :locks.modetxt;
 WHEN '6' THEN COPY 'EXCLUSIVE MODE' INTO :locks.modetxt;


================================================================================
                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Klaus-Michael Hatzinger            mail: hatzinger_m@bmwf1f.bmwf.gv.at   |
 Bangkasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Re: How do I trap arrow keys?
Date: 20 Aug 92 10:38:56 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

In article <d2!n3r+.sjs@netcom.com>, sjs@netcom.com (Stephen Schow) writes:
> Anyone know how I can trap arrow keys..especially the right/left keys.
> I believe I can use the KEY-UP and KEY-DOWN triggers to trap the up and
> down arrow keys....but I can't figure a way to trap the left/right keys.
> I also need a way to trap the return key.  
> 
> I am trying to design a dialog
> box form that works just like a normal dialog box just like those you see
> in the forms designer, or the other built in dialogs that Oracle often
> throws up.
> 
> i.e...The arrow keys move the cursor and return selects the choice.
> 
> Any Help?
> -- 

If you are using Forms V3 you can redefine your key-mapping with 
Oracle*Terminal. I tried it with the "left" key. I remapped it so 
i could trap it with the KEY-MENU - trigger.

You can trap the "return" key with the KEY-NXTFLD trigger.

================================================================================
                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Klaus-Michael Hatzinger            mail: hatzinger_m@bmwf1f.bmwf.gv.at   |
 Bangkasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================
From: dweissman@amarna.gsfc.nasa.gov (WiseGuy)
Newsgroups: comp.databases
Subject: Alpha4
Date: 17 Aug 92 12:48:00 GMT
Organization: NASA Goddard Space Flight Center, Greenbelt, Md. USA
News-Software: VAX/VMS VNEWS 1.4-b1

Has anyone heard of a PC package called ALPHA4?  Is it a database package
or just a spreadsheet package?
================================================================================
Dave Weissman - WAN/LAN Networking

   Allied-Signal Aerospace        Internet#1 - dweissman@amarna.gsfc.nasa.gov
   BFEC - Dept. 976               Internet#2 - sysdhw@bfec2.gsfc.nasa.gov
   One Bendix Road                SPRINTnet's X.400 -
   Columbia, Maryland 21045-1897  (C:USA,A:TELEMAIL,P:GSFC,FN:DAVID,SN:WEISSMAN)
Newsgroups: comp.databases
From: jnf@gagme (Joel N. Fischoff)
Subject: FOXPRO 2 - HELP - REDIRECTING "?" OUTPUT TO FILE
Organization: GAGME - Public Access UNIX of Chicago, Illinois, USA, Earth
X-Newsreader: Tin 1.1 PL4
Date: Fri, 14 Aug 1992 19:04:27 GMT


Dan Sullivan writes:
>I need to redirect the output from the question mark command (eg. ? recno(),
>? "I NEED HELP!!!!") to a text file.  The command SET DEVICE TO FILE 
><FILE NAME> only redirects output produced by the @...SAY command.
>Other commands such as DISPLAY have their own parameters to redirect 
>output to a file.  Nobody seems to know how to redirect the output of "?"
>to a text file.  Any ideas would be greatly appreciated.

	Actually, this is fairly easy to do and has been as far
	back as I can remember.  Try something like this:

		SET ALTERNATE TO <filespec>
		SET ALTERNATE ON
		? "I NEED HELP!!!!"
		SET ALTERNATE OFF
		SET ALTERNATE TO

	The two "SET ALTERNATE TO" commands open and close the
	output file respectively, while the SET ALTERNATE ON/OFF
	restricts which data actually gets written to the file.
	All output from a ? gets written to the ALTERNATE file if
	ALTERNATE is set to ON.  Note that this command is the
	exact opposite of SET DEVICE, as @.... commands will not
	be written to the file.


				Hope this helps,

					Joel N. Fischoff
					jnf@gagme.chi.il.us
					Systems Programmer/Analyst
					Center For Clinical Research
From: albert@HPLWK.HPL.HP.COM (Joseph Albert)
Newsgroups: comp.databases
Subject: Re: Hot Standby DBMS's
Date: 17 Aug 92 21:03:36 GMT


Jonathan Edwards writes:

>In the transaction-processing world, there is the concept of a 'hot standby'
>system, which is a geographically separated system containing a copy of the
>database, and capable of coming online very quickly. The replicated data must
>be close to current, and guaranteeing complete synchronization is required
>by some applications. A further feature is the ability to 'catchup'
>incrementally to missed changes after an outage, without a complete database
>copy. Our database (homebrew non-relational) does this.
>Are there any other databases that can do this?

A more reliable fault-tolerance would be obtained from redundancy at a
level which is lowered than the level of abstraction of the database.
Disks can be made redundant by having 2 or 3 physical disks, with
drivers that make them look like a single device. if one disk fails,
the driver can automatically look at the 2nd disk. with 3 disks acting
as a single logical disk, failure can be detected at the disk page level--
a read can look at the 3 pages, and if 2 of them are the same, return
that value, or with 2 disks, a chekcsum can be stored with each page,
to determine the valid page from among hte two if a single one fails.

CPU/OS/DBMS failure can be handled by redundant CPUs. for example, a
VAXCluster can be configured so that, say, 2 CPUs share a pool of
disks as if each disk was `their own'. a dbms can be run on each CPU.
the first thing each dbms will try to do at initialization is request
a lock on the database. the dbms granted the lock will run, the other
will be blocked, waiting on the lock. when a copy of a dbms runs, the
first thing it does is execute the recovery code, scanning the log for
any incomplete work. 

if the first CPU/OS/DBMS fails, the lock on the database is released,
and the 2nd dbms copy will then run. the 2nd dbms will begin, executing
the recovery code, which will examine the log left by the first dbms
and recover from that log, accessing the same database copy. (again, 
there are no redundant databases, but a single database implemented
on a pool of logical disks (where each logical disk may be implemented
as 2 or more redundant physical disks).

thus, any uncommited transactions on the first CPU that crashed will
be aborted, but any transactions whose commit records made it to the
log before the first cpu crashed will be recovered by the 2nd copy of
the dbms. this scheme can tolerate a single failure to any logical
disk page, a single cpu failure, a single system software failure.
the only glitch at a failure is that uncommited active transactions
are aborted.

the scheme described at hte beginning of this article, where there is 
a redundant logical database, with some form of update between
the real and standby databases to keep the standby one current is
less fault-tolerant than what was just described. effectively, the
two databases become one large distributed dbms, with its own newly
introduced points of failure.

Joseph Albert
albert@hplabs.hp.com
From: socwk@lure.latrobe.edu.au
Newsgroups: comp.databases
Subject: Text base
Date: 16 Aug 92 14:54:34 GMT
Organization: VAX Cluster, Computer Centre, La Trobe University

I wonder if anyone can help me? 

I'm looking for a text based data base management system to use on a PC 
that will allow me to enter or translate text in a file of unlimited size. 
I've looked at a few DBs but none quite fit the bill.  I've heard that Reflex
might be an option but I need something that has structured fields with
unlimited text entry.

					Thanking you in advance
							Walter
From: bengsig@dk.oracle.com (Bjorn Engsig)
Newsgroups: comp.databases
Subject: Re: ORACLE newsgroup?
Date: 20 Aug 92 11:10:08 GMT
Reply-To: bengsig@dk.oracle.com (Bjorn Engsig)
Organization: Oracle Denmark

Article <1992Aug20.042112.12662@morrow.stanford.edu> by XB.K14@forsythe.stanford.edu (Pechler) says:
|Could anyone tell me whether or where I can find a newsgroup or
|mailing list for ORACLE users specifically?
comp.databases.oracle is there.  And to those who asked about comp.databases.
sybase, yes it has been started and is alive.  Check your newsfeed if you
don't get these.
-- 
Bjorn Engsig,		Internet: bengsig@oracle.com
ORACLE Corporation.	BANG-net: uunet!oracle!bengsig
			Private : bjorn@login.dkuug.dk.
Newsgroups: comp.databases
From: viking@iastate.edu (Dan Sorenson)
Subject: Re: Foxpro 2.0 ??
Organization: Iowa State University, Ames IA
Date: Thu, 20 Aug 1992 22:06:22 GMT

rahul@chaos.cs.brandeis.edu (Rahul Chawla) writes:

>2). Any comments on the LAN version of Foxpro.


	It's pretty robust, but some of the defaults I'm not happy with.
When working from the menus, the default is exclusive usage of any
file you open, so no concurrent reads.  There are commands for locking
of files and multiple records in that file, so you can get concurrent
reads and writes.  Transaction tracking is allowed, but it's not easy
to set up and it has to be incorporated both in your FoxPro code and
on your Novell server.

	I'm happy with it.  The manual is pretty clear on what is and
is not allowed, and how best to write your code for multiple users.
I can't compare it to Dbase IV because I've never used it, but I'd
be happy to send you some source that shows how to write a simple
multi-user application.

<Dan Sorenson, DoD #1066 |"There'll be angels on Ariels in leather>
<z1dan@exnet.iastate.edu | and chrome, Ridin' down from heaven    >
<viking@iastate.edu      | just to carry me home." -- R. Thompson >
< ISU thinks I need more education, which they provide for a fee. >
From: fscll@acad3.alaska.edu (Christopher Lee Lott -- One foot in the grave and the other slipping)
Newsgroups: comp.databases
Subject: FoxPro 2.o and Win 3.1 ??
Date: 14 Aug 92 05:12:29 GMT
Organization: University of Alaska Fairbanks

I am sure this is probably an FAQ, but I am 
trying to get FoxPro 2.0 to work with Windows 3.1

I used the install applications option in the setup and chose 
the FoxPro Extended version, but when I try to run it the screen 
goes black like it should right before it runs a dos app, but then it 
bumps me back into windows.... 

does anyone know how I can get this working? I hate having to exit windows 
all the time to get into My FoxPro database!

Thanks for your time and patience...
chris
poet and pauper
Newsgroups: comp.databases,comp.os.mach
From: spec01@solomon.technet.sg (Quak Wan Ling)
Subject: What is real-time database???
Organization: National University of Singapore
Date: Thu, 13 Aug 1992 05:56:06 GMT

Please mail me directly. Thanks.
Xref: sparky comp.databases:6102 comp.databases.theory:360
From: adc@tardis.msu.edu (Alan D. Cabrera)
Subject: Re: Senior Staff Member Position Available
Reply-To: adc@tardis.msu.edu
Organization: Michigan State University
Date: Thu, 13 Aug 92 17:35:44 GMT

Excuse me?  Articles of this nature do NOT belong in this group.



---
Alan Cabrera				internet:  adc@tardis.cl.msu.edu
Computer Laboratory			phone:     (517) 353-3027
Michigan State University		fax:       (517) 353-9847
514 Computer Center			bitnet:    CABRERA@MSU
East Lansing, MI 48824
From: johnb@fexco.ie (John Bowler)
Newsgroups: comp.databases
Subject: Test post
Distribution: world
Date: Sat, 15 Aug 92 21:06:00 GMT
Organization: Foreign Exchange Company Ltd.

Test post.

Posting to comp.databases
From: rahul@chaos.cs.brandeis.edu (Rahul Chawla)
Newsgroups: comp.databases
Subject: Foxpro 2.0 ??
Date: 19 Aug 92 22:13:16 GMT
Organization: Brandeis University

Greetings :


After struggling with Dbase IV I am finally inclinded to choose
another package. I am interested in puchasing Foxpro 2.0 as I have
heard a lot about. I would appreciate any comments on the following :

1). Can FoxPro create stand alone executionable files, if so, is the
compiler included with the regular version ?? ( I am interested in the
LAN version.)

2). Any comments on the LAN version of Foxpro.

Thanks for your time.

I will summarize if requested !!

-- Rahul Chawla

-- 
--
Rahul Chawla			Internet : rahul@chaos.cs.brandeis.edu
Computer Science Dept.			   chawla@binah.cc.brandeis.edu
Brandeis University.			   rahul@cmns-sun.think.com
Newsgroups: comp.databases