HDTenEightyP/NetNews huggingface dataset:
From: holowczk@rwja.umdnj.edu (Richard Holowczak)
Newsgroups: comp.databases.oracle
Subject: Re: Display hint/help message per re/entry of a field in SQL*Forms
Date: 23 Jan 93 14:02:29 GMT
Organization: Robert Wood Johnson Medical School, Piscataway NJ

hyu@eng.umd.edu (Henry K. Yu) writes:

>When the operator tab into a field in SQL*Forms, s/he has to press [Help]
>for the hint message to appear on the message line.

>Can a message be displayed automatically?  On-new-field-instance works if
>the field is new but not when the fields are re-cycled.

>Thanks in advance,
>hyu


   In Forms 2.3, you can designate a field with "Automatic Help" where 
   the Help message from the Validation section displays alaong the bottom 
    of the screen when you enter the field.

R.H.
Newsgroups: comp.databases.oracle
From: kmajkut@netcom.com (Keith Majkut)
Subject: Re: Windows and Oracle access.
Organization: Netcom Online Communications Services (408-241-9760 login: guest)
Date: Fri, 22 Jan 1993 05:28:24 GMT

In article <y5ZqXB2w165w@netlink.cts.com> tumidity@netlink.cts.com (Joel Garry) writes:
>skanga@us.oracle.com (Shiraz Kanga) writes:
>
>> In article <1856@rwja.umdnj.edu> holowczk@rwja.umdnj.edu (Richard Holowczak) 
>> >patrick@casbs.Stanford.EDU (Patrick Goebel) writes:
>> >
>> >>A related question:
>> >
>> >
>> >>Question:  when using these access products (in conjunction with
>> >>SQL*Net I take it) do the Forms that have been developed on the Sun
>> >>(under UNIX) have to be rewritten for use under the Mac and PC
>> >>environments?  Or do they port over in some simple fashion?
>
>I just saw a demo of Reportwriter 2.0.  It was really cool.  I think they 
>said it should be out by May.  The neat thing is, you can use the 
>executables on any machine.  Apparantly they use some sort of virtual 
>machine.  I can't imagine that it would be the most efficient on all 
>machines, but that's portability for you.  It's like a combination of 
>.inp and .frm files.  
>
>--                    
>INTERNET:  tumidity@netlink.cts.com (Joel Garry)
>UUCP:   ...!ryptyde!netlink!tumidity
>NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115

I'm not sure if you meant to say 'executable' above. I can say for sure that
none of the Oracle executables is designed in that fashion. What you meant to
say was that the files produced by SRW are portable across platforms. You
can simply transfer a file between UNIX/PC/MAC and it will load/run without
any modification. Also, you could save it to the RDBMS and retrieve it from
another version of SRW on another platform(I have done both of these myself
so I know it works).
SRW will have 3 file formats(.rdf-binary format w/source, .rex-ascii format
w/source and .rep-binary format w/runtime only).


-- 
+----------------------------------------------------------+------------------+
| Keith Majkut                                             |kmajkut@netcom.com|
| I speak for myself, since nobody else has volunteered... |kmajkut@oracle.com|
+----------------------------------------------------------+------------------+
Newsgroups: comp.databases.oracle
From: sanju@churchill.ColumbiaSC.NCR.COM (Sanjeev.Agrawal)
Subject: Re: FAQ: Does passwd length vary on different platforms?
Organization: NCR COLUMBIA SC
Date: Thu, 21 Jan 93 20:24:27 GMT

In article <1993Jan19.173354.6009@clarify.com>, frank@clarify.com (Frank H. Lai) writes:
|> 	It may be a FAQ.  Sorry if I ask a trivial question.
|> Since I took over a Oracle project recently, people were asking about 
|> the length of the passwd of a Oracle account.  I tried it out on Sparc and
|> it was 30 characters.  However, I can not say it is 30 characters of all
|> the platforms that Oracle supports.  Does anyone know about this?
|> Where usually do people find the limitation of Oracle's product?
|> 
|> Please forgive a beginner's ignorance!!
|> 
|> Frank
|> frank@clarify.com
|> 408-428-4028
|> 
As far as my understanding goes this is 30 chars  and is independent of
platforms as it is stored in Oracle data dictionary. And for that matter 
except database names all Oracle objects can be upto 30 chars.

Hope it helps !

Sanjeev 
Newsgroups: comp.databases.oracle
From: scheidjs@mickey.informatik.uni-stuttgart.de (Johannes Scheidler)
Subject: Locking under SQL*Forms 3.0
Keywords: Lock
Organization: Informatik, Uni Stuttgart, Germany
Date: Thu, 28 Jan 1993 09:58:43 GMT

With default locking in SQL*Forms 3.0 (if you make an query with FOR_UPDATE 
and NOWAIT option), the record is locked, when you change its value, as late 
as possible. When the record is already locked, you get the message :
Attempt to preserve record for update or delete. Press CONTROL-C to cancel...

The reaction of the CTRL-C is very slow (it can take up to minutes). Is it 
possible to avoid this message and then giving the user a message without
waiting for the CTRL-C ? In my own programs I can make a Lock with NOWAIT 
option and then I get an error, if the lock is used by another process, but a
simple Select in Forms does never make any locks, even if I made an explicit
lock statement.

The other way is never to lock anything and always get the message :
Record updated by another user, plese requery.

Is there any use of the ON-LOCK-Trigger?
Is it possible to make an explicit lock (e.g. row exclusive) at the time of 
the query ?
How can I lock other tables which contains references on the current visible
data and must be updated/deleted with the current record ?

We need an easy way (for many Forms) to implement multi-user-features without
any visible messages for the user (or simply no waiting for CTRL-C).
If you have solved this problems please mail me your solution to :

hannes%tuatara@Germany.EU.net

Thanks
From: holowczk@rwja.umdnj.edu (Richard Holowczak)
Newsgroups: comp.databases.oracle
Subject: Re: Database files
Date: 26 Jan 93 21:04:45 GMT
Organization: Robert Wood Johnson Medical School, Piscataway NJ

jbaker@moby.micro.umn.edu (Jeffrey J Baker) writes:

>The company I work for has been thinking about moving their Oracle development
>system from a RISC platform to one running OS/2.  I know that there will be no
>problem reloading the existing forms, but what I am wondering about is whether
>or not the existing database files (dbs*.dbf) can be copied directly over to
>the new system.  Has anyone had experience with this procedure?  Are there other
>problems with doing this that I am not taking into consideration?
>Any suggestions would be much appreciated.

>Jeff
>jbaker@cs.umn.edu


         I doubt the file systems are compatible. What you would want to do
         is to EXPORT the data from the RISC box and then IMPORT the
         data on the OS/2 box.  It's fairly simple and you can keep 
         views and access rights together as well.

Rich H.
Rutgers U.
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: How Do you Do this in Forms 3.0?	
Date: 22 Jan 93 06:29:31 EDT
Distribution: na
Organization: Hayes Microcomputer Products, Norcross, GA

In article <1993Jan21.152213.14740@stortek.com>, v045100@otis1.stortek.com (Jennifer Farnham) writes:
> Setup: One block, multiple records.
>        User may query on all fields or one,
>          or combination of.
> 
> 
> Problem: How do I let the user know before or
>          after, how many records there query will produce?  I know the user could
> have pressed "count query hits", but I want to
> do this for the user. I can not user COUNT_QUERY
> procedure as it is a packaged procedure (restricted),
> and it won't work in a pre-query or post-query.
> I can't hard code the query, cause the user makes
> it different each time.
> 
> ANY IDEAS?
> 
> Jenny
> v045100@otis1.stortek.com
> Boulder, Colorado
> 

The easiest way is to utilize two calls to the data base.  On the first,
retrieve just a count of the records and then, on the second, execute the
actual query.  Assume a local variable XCOUNT.  The first read would be

	SELECT COUNT(*)
	INTO   xcount
        FROM   the_table
        WHERE  the_condition(s);

You then need to add a user prompt message and reply.  If the user indicates
the desire to actually retrieve the data then execute the query.

 ----------------------------------------------------------------------------
 |      Frank Greene                  |          //////  //////             |
 |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
 |      Telephone [615] 458-6032      |          ////    ////  //////       |
 |      Compuserve 74200,427          |         ////    ////    ////        |
 |      324 Ootsima Way               |        ////    ////    ////         |
 |      Loudon, TN 37774              |       //////  //////  //////        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------

Newsgroups: comp.databases.oracle
From: smj@jbecpor.demon.co.uk (Martin Jarvis)
Subject: TWO_TASK
Organization: John Brown E&C Ltd
X-Newsreader: Tin 1.1 PL4
Apparently-To: mail2news@news.demon.co.uk
Date: Fri, 22 Jan 1993 16:16:57 +0000

Have a look for some info on the environment variable TWO_TASK.
Newsgroups: comp.databases.oracle
From: v045100@otis1.stortek.com (Jennifer Farnham)
Subject: Advanced SQL*FORMS question. 
Keywords: solaris, oracle7,oracle6
Reply-To: v045100@otis1.UUCP (Jennifer Farnham)
Organization: Storage Technology Corp.
Distribution: na
Date: Thu, 21 Jan 1993 15:26:32 GMT

After implementing the Dynamic Sorting Routine
as explained in the Advanced SQL*FORMS book
by Oracle, I wanted to know if anyone out there
in comp.databases.oracle has used this with
the combination of a user entering a query
by placing a colon in any of the fields and
writing there own WHERE clause in the pop-up
block.

My problem is that the ORDER by clause gets
written before their where clause.  Sql *forms
gives me an error obviously. Does anyone have
a work around?

Jenny
v045100@otis1.stortek.com
Boulder, Colorado



Newsgroups: comp.databases.oracle
From: smj@jbecpor.demon.co.uk (Martin Jarvis)
Subject: Commit and ANSI SQL
Organization: John Brown E&C Ltd
X-Newsreader: TIN [version 1.1 PL8]
Apparently-To: mail2news@news.demon.co.uk
Date: Thu, 28 Jan 1993 09:51:52 +0000

I've just had a discussion with some colleagues about the use of Commit in 
Oracle. In particular that a commit will save _all_ outstanding changes. My
boss seems to think that other databases allow concurrent transactions, thereby
allowing individual changes to be saved separately.

What does the ANSI standard for SQL say about this ?

________________________________________________________________________________
 Martin Jarvis                 | Internet - smj@jbecpor.demon.co.uk
 John Brown E & C Ltd          |    X.400 - Martin Jarvis /JBEC-Portsmouth, IT
 Portsmouth, England           |    
Newsgroups: comp.databases.oracle
From: v045100@otis1.stortek.com (Jennifer Farnham)
Subject: How Do you Do this in Forms 3.0?	
Keywords: solaris, oracle7,oracle6
Reply-To: v045100@otis1.UUCP (Jennifer Farnham)
Organization: Storage Technology Corp.
Distribution: na
Date: Thu, 21 Jan 1993 15:22:13 GMT


Setup: One block, multiple records.
       User may query on all fields or one,
         or combination of.


Problem: How do I let the user know before or
         after, how many records there query will produce?  I know the user could
have pressed "count query hits", but I want to
do this for the user. I can not user COUNT_QUERY
procedure as it is a packaged procedure (restricted),
and it won't work in a pre-query or post-query.
I can't hard code the query, cause the user makes
it different each time.

ANY IDEAS?

Jenny
v045100@otis1.stortek.com
Boulder, Colorado
From: doering@matisse.informatik.uni-stuttgart.de (Sven Doering)
Newsgroups: comp.databases.oracle
Subject: Locking under Forms 3.0
Date: 26 Jan 1993 10:10:58 GMT
Organization: IPVR, University of Stuttgart, Germany
Distribution: world
NNTP-Posting-Host: rusmv1.rus.uni-stuttgart.de



The default locking in SQL*Forms 3.0 (if you make an query with FOR_UPDATE 
option), the record is locked, when you change its value. When the record is
already locked, you get the message :
Attempt to preserve record for update or delete. Press CONTROL-C to cancel...

Is it possible to avoid this message and then giving the user a message without
waiting for the CTRL-C. In my own programs I can make a Lock with NOWAIT option
and then I get an error, if the lock is used by another process, but a simple Select in Forms does never make any locks, even if I made an explicit lock 
statement.

The other way is never to lock anything and always get the message :
Record updated by another user, plese requery.

Is there any use of the ON-LOCK-Trigger?
Is it possible to make an explicit lock (e.g. row exclusive) at the time of 
the query ?
How can I lock other tables which contains references on the current visible
data and must be updated/deleted with the current record ?

If you have solved this problems please mail me your solution to :

hannes%tuatara@Germany.EU.net

Thanks
Newsgroups: comp.databases.oracle
Subject: Re: Windows and Oracle access.
From: tumidity@netlink.cts.com (Joel Garry)
Date: Thu, 21 Jan 93 14:25:21 PST
Organization: NetLink Online Communications, San Diego CA

skanga@us.oracle.com (Shiraz Kanga) writes:

> In article <1856@rwja.umdnj.edu> holowczk@rwja.umdnj.edu (Richard Holowczak) 
> >patrick@casbs.Stanford.EDU (Patrick Goebel) writes:
> >
> >>A related question:
> >
> >
> >>Question:  when using these access products (in conjunction with
> >>SQL*Net I take it) do the Forms that have been developed on the Sun
> >>(under UNIX) have to be rewritten for use under the Mac and PC
> >>environments?  Or do they port over in some simple fashion?

I just saw a demo of Reportwriter 2.0.  It was really cool.  I think they 
said it should be out by May.  The neat thing is, you can use the 
executables on any machine.  Apparantly they use some sort of virtual 
machine.  I can't imagine that it would be the most efficient on all 
machines, but that's portability for you.  It's like a combination of 
.inp and .frm files.  

--                    
INTERNET:  tumidity@netlink.cts.com (Joel Garry)
UUCP:   ...!ryptyde!netlink!tumidity
NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115
Newsgroups: comp.databases.oracle
From: kmajkut@netcom.com (Keith Majkut)
Subject: Re: State of tools for Oracle7
Organization: Netcom Online Communications Services (408-241-9760 login: guest)
Date: Fri, 22 Jan 1993 05:02:38 GMT

In article <SBCHANIN.93Jan21101553@raisin-nut.ai.mit.edu> sbchanin@ai.mit.edu writes:
>To run oracle 7 on hp or sun, will I need new versions of Pro*C, OCI,
>or ReportWriter?  I would think that Pro*C 1.4 and ReportWriter would
>be capable of connecting to either an Oracle 6 or an Oracle 7
>database, but I'm not sure.
>
>Thanks for any info,
>Steve
>--
>===============================================================================
>DOMAIN: sbchanin@ai.mit.edu                                       Steven Chanin

The tools will work fine against either V6 or V7. Since they were developed
primarily for V6 you can not make use of the new V7 features and/or datatypes(
I know that's true for SRW 1.1, but I think FORMS 3.0 has some stored procedure
support). You'll have to wait for the next generation of tools for full V7
support(SRW 2.0, FORMS 4.0, etc).



-- 
+----------------------------------------------------------+------------------+
| Keith Majkut                                             |kmajkut@netcom.com|
| I speak for myself, since nobody else has volunteered... |kmajkut@oracle.com|
+----------------------------------------------------------+------------------+
From: eaton@pacersoft.com (Mark W. Eaton)
Newsgroups: comp.databases.oracle
Subject: Re: Pro*C and gnu C on SUN
Date: 25 Jan 93 19:02:26 GMT
Followup-To: comp.databases.oracle
Organization: Pacer Software, Inc.

In article <4355@eastman.UUCP>, mahmoud@icts01.kodak.com (Ahmed Mahmoud)
wrote:
> 
> We are planning on using gnu C with pro*c with oracle version 7 on a SUN 670
> running sunos 4.1.2. Does anybody out there have any idea why this should not
> work...has anyone out there tried this combination....has anyone used gnu	with oracle????   thanks for any info on this matter....Ahmed Mahmoud	
> 
> 
> please reply to mahmoud@kodak.com

I know Oracle 6 won't run under Solaris 2.1, but don't know about the
converse.
Does Oracle 7 require Solaris 2.0/2.1?

Mark W Eaton
Pacer Software, Inc.
eaton@pacersoft.com
Newsgroups: comp.databases.oracle
From: jstander@ml.csiro.au (Jeff Stander)
Subject: Re: Export/Import to tape?
Reply-To: jstander@ml.csiro.au
Organization: CSIRO Marine Laboratories
Date: Sun, 24 Jan 1993 22:39:32 GMT

In article 1902@spectrum.xerox.com, rdutc@sarek.xerox (Ray Dutcher) writes:
> Compressing the export through a named pipe worked great and I did the
> reverse fine without any loss of data.  I also did this with success on
> data files (ie. a physical backup).  Thanks for the info.  Just to
> check I called Oracle Support to see if they were familiar with this
> technique and they said that they know of customers who do this but
> they know that some customers have experienced a loss of data when
> using the UNIX compress/uncompress command and that Oracle will not
> support this technique. I also used compress in the past on exports to
> transfer a database to another machine over my network and also had
> zero problems.> 

> Before I put this technique into a production system I would like to
> know if anyone has experienced the "data loss" that Oracle Support
> mentioned? and if so please state your Oracle version and OS when
> replying.

> FYI, here's the technique I'm referring to:
> (1) Compressing export to disk
>	mknod ora_export.dmp p
>	nohup compress < ora_export.dmp > ora_export.dmp.Z &
>	exp / ...... file=ora_export.dmp
>	
>	This lets you compress on the fly without using any disk (well,
>	you will use 4 disk blocks or the size of a pipe).

I have used this technique for years and have not experienced any
data losses with UNIX compress.

---
___________________________________________________________________________

Jeff.Stander@ml.csiro.au        _--_|\        Database Analyst
CISRO Division Of Fisheries    /      \       Pelagic Fisheries Resources
GPO Box 1538, Hobart           \_.--._/       Tasmania 7001, Australia
Aus Tel: 002-206-206                 v        Intl Tel: +61-02-206-206
Aus Fax: 002-240-530                          Intl Fax: +61-02-240-530
___________________________________________________________________________

Xref: sparky comp.databases.oracle:2974 comp.databases.sybase:759
From: ekrell@fundch.fundch.cl (Eduardo Krell)
Newsgroups: comp.databases.oracle,comp.databases.sybase
Subject: Gateway to Datacom DB on IBM mainframes
Date: 28 Jan 1993 12:41:17 -0300
Organization: Fundacion Chile
Distribution: world
NNTP-Posting-Host: fundch.fundch.cl

Hi,
  I am looking for any information on products from either Sybase or
Oracle or some third party vendor to integrate their RDBMS (Sybase or
Oracle) running on Unix platforms with an IBM mainframe (9021-500)
running:

MVS/XA 2.2
CICS 1.70
VTAM 3.3
DATACOM 8.0

  I need to be able to read and write from the Datacom DB on the
mainframe (as well as from VSAM files) as transparently as possible.
Ideally, these will look just like another Sybase/Oracle DB.

  I know a little bit about Open Server for CICS and Open Gateway
for DB2 from Sybase and SQL*Connect from Oracle. However, I need
a gateway for Datacom, not DB2. If there are no such products available
on the market, I would like to get an idea of what's involved in
writing such a thing...

  Please respond directly to me and I will summarize.
-- 
Eduardo Krell
Fundacion Chile			ekrell@fundch.fundch.cl
Newsgroups: comp.databases.oracle
From: aaj@cmutual.com.au (Tony Jambu)
Subject: CASE*Designer and MIT's X11 on SPARC
Keywords: CASE OpenWindows MIT X11 SPARC SUN
Organization: Colonial Mutual Group
Date: Tue, 26 Jan 1993 05:32:11 GMT



Does anyone know the direction ORACLE is taking with CASE*Designer with
regards to the windowing system?  At the moment CASE*Designer is able to run
against MIT's X11 (XR4) .  

This posting is a result of a release documentation for patch 4 against
V6.0.36.  In section 2.2 titled CASE*Designer, it says

'Please note:  CASE*Designer is no longer supported with MIT version X11.
STarting from next patch release, CASE*Designer will not be supported with
OpenWindows 2.0/2.5 libraries.  It will only be supported with OpenWindows
3.0.'

What does this mean?  If I have an ICL DRS 6000 (SPARC), do I have to
go out and get Sun's windowing system?  Excuse me if I am not making too much
sense as I am not a window expert.  I have approach ORACLE Support and I have
not got a satifactory answer from then as they thenselve are not too sure
what it means.


Any infor is much appreciated.


Environment:
Machine         : SUN Sparc compatible
O/S             : SUN OS 4.1.2
RDBMS           : RDBMS 6.0.36
Windowing system: MIT X11
Window Manager  : MOTIF

-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Invest Mgmt Aust (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
 \_______/                   |PHONE:  +61-3-6418448       FAX:  +61-3-6076198
From: epeas@abds7.aberdeen.chevron.com (John Peach)
Newsgroups: comp.databases.oracle
Subject: Re: Q: Duplicate records
Date: 25 Jan 93 08:48:37 GMT
Reply-To: epeas@aberdeen.chevron.com
Organization: Chevron (UK) Ltd.
Disclaimer: The opinions expressed are mine; _not_ those of        
            the company I work for.

In article <1993Jan23.124513.26942@kaija.spb.su>, adn@kaija.spb.su (ADN communication group) writes:
|> Does anyone know how to remove duplicated records from existing
|> Oracle table? Records may not be duplicated in all fields.


DELETE FROM &TABLE
WHERE ROWID NOT IN
   (SELECT MAX(ROWID) FROM &TABLE
    GROUP BY &DUPLICATE_COLUMNS
   )
/

|> --
|> Nick Maximov
|> St. Petersburg, Russia

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas@aberdeen.chevron.com       Phone: +44 224 242637
From: rdutc@sarek.xerox (Ray Dutcher)
Newsgroups: comp.databases.oracle
Subject: Re: checking for full tablespaces
Date: 22 Jan 93 19:44:20 GMT
Reply-To: rdutc@sarek.xerox
Organization: Sun Microsystems, Inc.

How about


select fs.TABLESPACE_NAME, (sum(fs.bytes) / sum(df.bytes)) * 100 PctFull, 
	count(*), max(fs.BLOCKS) max_contig
from dba_free_space fs, dba_data_files df
group by fs.TABLESPACE_NAME
/
Newsgroups: comp.databases.oracle
From: umgeary0@ccu.umanitoba.ca ()
Subject: Is there a SYBASE newsgroup ?
Organization: University of Manitoba, Winnipeg, Canada
Date: Sat, 23 Jan 1993 07:18:51 GMT



I'm not sure where else to ask this questions (no flames please),
but .. Is there a SYBASE newsgroup out there similiar to this
group? If not how do I go about starting such a group?
Please e-mail.
Thanks
Peter

Newsgroups: comp.databases.oracle
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: ORACLE/SAS Interface
Organization: U.S Dept. of Transportation
Date: Mon, 25 Jan 1993 13:02:11 GMT

prs9k@brain.med.virginia.edu (Phil Scarr) writes:

>SAS/Access from the SAS Institute allows SAS users to read from and
>write to Oracle tables, create SAS datasets directly and do some
>sophisticated stuff with Oracle tables.  It's one of the big selling
>points in Oracle's favor for our site (we're comparing Oracle, Ingress
>and HP/Allbase).

SAS/Access works with Ingres too.  I've used it.

		Seth, grimes@oecd.fr
Newsgroups: comp.databases.oracle