HDTenEightyP/NetNews huggingface dataset:
From: wrighri@jacobs.CS.ORST.EDU (Rick Wright)
Newsgroups: comp.databases.oracle
Subject: Re: Changing the WHERE/ORDER BY clause in SQL*FORMS
Date: 17 Apr 92 03:56:51 GMT
Article-I.D.: CS.1992Apr17.035651.11891
Organization: CS Dept. Oregon State University, Corvallis, Oregon.

In article <fragante.703209729@chilko.ucs.ubc.ca> fragante@unixg.ubc.ca (Gv Fragante) writes:

>My question now is, has anyone used the pound (#) operator to dynamically
>change the default WHERE/ORDER BY clause of FORMS ? There are examples given
>in the documentation "Advanced SQL*FORMS technique", but I cannot understand 
>how it works.

When SQL*FORMS executes a query it normally builds a sql query based on fields
that have data entered into them.  If it finds a field that begins with a 
pound sign (#) it will take everything that follows the pound sign as a literal
string that is placed into the sql query.  Since the "order by" clause always
follows the "where" clause any text that will modify the order by should be
placed in the last database field in the block.  That text will be appended
to the end of any other text that is generated by FORMS.  You can try this
out in an executing form by simply typing it into the field before pressing
[EXECUTE QUERY].  After you try that out you can modify the PRE-QUERY trigger
on the block you want to order.  The last field in the block should have a
query length of 240 to insure that you will have plenty of room to insert 
your order by clause.  Don't forget to consider the case where the operator
enters query criteria into the last field.  Your will need to format your
text in the PRE-QUERY trigger before inserting it into the last field.
It will be a trial and error learning experience but you can see the whole
sql statement that is generated by pressing [DISPLAY ERROR] after an error
occurs on the query.  Good luck.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
|                               |                                             |
|      Rick Wright              |    Internet: wrighri@jacobs.cs.orst.edu     |
|      Systems Developer        |                                             |
|      Teledyne Wah Chang       |    Phone:    (503) 926-4211   ext. 6294     |
|      Albany, Oregon           |                                             |
|                               |                                             |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Newsgroups: comp.databases.oracle
From: drt@brolga.cc.uq.oz.au (David Taylor)
Subject: Compiling PRO*C with ANY compiler
Summary: Can Pro*C libs be linked with ANY object code?
Organization: Prentice Centre, University of Queensland
Date: Tue, 14 Apr 1992 03:52:51 GMT

Is it possible to link the PRO*C libraries with any object modules
from any compiler? The .LIB files supplied are intended for use with
MSC, but is it possible to link them in with object code from other 
compilers?

I have experimented a bit but I get lots of Undefined symbols and
fixup overflows. Anyone in netland experimented with this?

D.T - david@cc.uq.oz.au
Newsgroups: comp.databases.oracle
From: kpalm@athena.qualcomm.com (Kent Palm)
Subject: Re: Space left in database (V6)
Organization: Qualcomm, Inc., San Diego, CA
Date: Thu, 16 Apr 1992 15:40:00 GMT

Look at the table SYS.DBA_FREE_SPACE;

Generally, to find out how much free space is available in all of your
tablespaces, you can:

SELECT TABLESPACE_NAME, SUM(BLOCKS) FROM SYS.DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME;

However, this will not give you a picture of the internal state of the
tablespace (e.g., fragmentation, chaining).  Besides the Oracle documentation,
you will find good information in the 1990 and 1991 IOUG proceedings.
From: dcox@relay.nswc.navy.mil (David Cox)
Newsgroups: comp.databases.oracle
Subject: non-vt100 keys using SQL*REPORTWRITER as vt100
Date: 10 Apr 92 17:13:15 GMT
Organization: NSWC

I am using SQL*REPORTWRITER on a CYBER 995 running the NOS/VE
operating system. I invoke SQL*REPORTWRITER with the term=vt100
option. When I hit the "key help" function key (F1, or esc O q), there is
a display of functions and their associated keys. Some of the keys displayed
are not defined for a vt100. The most important for me is the key to toggle
from insert to replace mode, which is listed as: INS. I have no idea what actual
escape sequence is supposed to handle this, since no key on an actual vt100
is labeled INS and no insert/replace mode function is described in a vt100
manual. The keys described in the "key help" screen as F1 etc. refer to the
numeric keypad (thus, as mentioned before, esc O q works as F1 to get the
KEY HELP displayed). There are also shifted and control function keys listed,
and F10 is also listed. These are also basically undefined on a vt100. So, how
do I find out what sequence to send to effect these functions?

David Cox
dcox@relay.nswc.navy.mil
From: suran@nff.ncl.omron.co.jp (Suran de SILVA)
Newsgroups: comp.databases.oracle
Subject: Oracle has multimedia?
Date: 15 Apr 92 08:16:14 GMT
Distribution: comp.databases.oracle
Organization: OMRON Corp., Kyoto, Japan

Hello,

        I was wondering if someone could help me.  Our section at Omron
Japan has started looking into multimedia databases.  Does Oracle have
any such databases already or soon to come?  If so, I would be interested
in talking to a developer at Oracle on the topic.  Would anyone be able to
refer me to an email address where I could find an appropriate person or
where I can ask further?

Thank you,
Suran de Silva

-------------------

                Omron Corporation | Suran de Silva (suran@nff.ncl.omron.co.jp)
                                        | Corporate Research & Development H.Q.
            | Shimokaiinji, Nagaokakyo-city, Kyoto, 617 Japan
                                                        | Tel (075) 951 - 5111
                                                        | Fax (075) 956 - 7403
================================================================================
Newsgroups: comp.databases.oracle
From: waider@glas.rtsg.mot.com (Ronan Waide)
Subject: Help with compiling XWindows-to-C-to-Oracle
Summary: I am having problems : -(
Keywords: oracle xwindows BSD cc SysV cc panic panic panic
Organization: Motorola Ireland Ltd., Cork, Ireland.
Date: Wed, 15 Apr 1992 16:34:51 GMT

Okay, here it is:

I am designing a cute XWindows front-end for an ORACLE database. Fine. The 
front end is okay, works, blah blah. The problem is that I need to write C
code to access the database, said code being called by the front-end. BUT:
Oracle does not seem to like not having a main() function wrapped around
its access section. This rather tends to upset things. Can anyone out there
help?

--
Ronan Waide, Motorola Ireland Ltd.

.sig? now where did I put it?
From: rick@rick.cs.man.ac.uk (Rick Dipper)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle UNKNOWN processes
Date: 6 Apr 92 11:56:24 GMT
Reply-To: rick@uk.ac.man.cs
Organization: University of Manchester, Dept. Computer Science

In article <1992Apr2.161630.5407@deepthought.uucp>, deepthought!neil@ms.uky.edu (Neil Greene) writes:
|> I am running Oracle v6 on a NeXTcube.  I am accessing the database fine from  
|> the host machine.  However, when I connect to the server through our Tymnet  
|> network, Oracle processes come up with the user UNKNOWN.
|> 
|> > UNKNOWN    5349   0.0  2.3 3.40M  832K p4 S     0:00 ora_pmon_nasris
|> > UNKNOWN    5350   0.0  2.8 3.49M 1024K p4 S     0:00 ora_dbwr_nasris
|> > UNKNOWN    5351   0.0  2.8 3.40M 1016K p4 S     0:00 ora_lgwr_nasris
|> > UNKNOWN    5352   0.0  2.3 3.40M  832K p4 S     0:00 ora_smon_nasris
|> 
|> Does anyone know what may be causing this, I am confused on the situation.   
|> Note:  this does _not_ happen all of the time either.

This is becuse ps is looking in the password file to find the name of the
user that owns the process. The process table only stores the UID of the 
process. What has happend is that the entry in the password file has gone
missing for some reason. Yoll have to investigate why & also why it comes
back again. Maybe you NIS server dies or something ??

RICK DIPPER, Unix Systems Administrator                       rick@uk.ac.man.cs
Department of Computer Science, University of Manchester           061-275-5725
.............................Meemberrr the of Fumblee Ingers Culb..............
Newsgroups: comp.databases.oracle
From: hyu@eng.umd.edu (Henry K. Yu)
Subject: Oracle for Macintosh 2.0 w/ SQL*Net 1.5
Date: Sat, 11 Apr 92 22:55:43 GMT
Organization: College of Engineering, University of Maryland, College Park
Keywords: oracle macintosh sql*net
Originator: hyu@pepsi.eng.umd.edu


I am having GREAT difficulty in attempting to setup Oracle for Mac 2.0 and
SQL*Net 1.5.  The setup I work with is a MacIIfx with 8 meg of RAM running
System 7.0.

At this point, I just want to bring up Oracle in two ways.  (1) as a local
server.  And (2) be a client to an Oracle (v6) server running on a VAX.
I sometimes jump around when I install new software.  BUT, not in this case
page by page, I have followed the "Getting Started" until 3-16.

Problem 1:
According to the "Hardware Requirement", I should be about to bring up the
Oracle kernel and start it with 5 meg.  However, I canNOT start
any of the following: System Stack, SQL*Plus, etc.  All of which complains
about not enough memory.  After Oracle's kernel is loaded the system already
jumped to 3 meg.

Problem 2:
How does one initiate a client session with Oracle's SQL*Net (TCP/IP)?
(I somehow thing that my manager didn't pass the sale rep's trick. :-) )
There is a MAC TCP already running and SQL*Net doesn't seem to give you
anything but the equivalent.  Meaning, if one does not have any communication
software, use SQL*Net.  In the "Getting Started", it mentions the hardware
requirment of being a client.  It documents nothing about it, however.

In case you are wondering, we did purchase a service contract and do have
a valid CIS number.  Yet another persisting problem is there MAC technical
services.  I have broken new personal queue time records for the only
three times I called.  Anyone who can suggest a way to get help will be
greatly appreciated.

If Oracle the corporation is monitoring this group, please email.  I
really would like to at least the setup part finish.

Sincerely,
Henry Yu
From: lvc@cbnews.cb.att.com (Larry Cipriani)
Newsgroups: comp.databases.oracle
Subject: How to avoid appending matching records ?
Keywords: inserts
Date: 16 Apr 92 01:17:59 GMT
Distribution: usa
Organization: Ideology Busters, Inc.

I have two tables A and B which share a common schema.
In that schema I have 60 fields, f1, f2, ... f60.

Basically, I want to append A - B to A, but I want the
difference to operate only on two fields f1, and f2.  From
what I can tell, 'MINUS' operates on entire records.

Or ...

If I have a unique index i_a on fields f1 and f2 of A and
then insert all of B into A the whole insert will fail if
there is one record from B that matches an indexed record
in A.  Is there a way to make sqlplus keep going and ignore
the duplicate indexes errors ?  That is, inserts on other
records should succeed but the duplicates should be thrown
away ?

Thanks,
-- 
Larry Cipriani, att!cbvox1!lvc or lvc@cbvox1.att.com
"Be wary of strong drink.  It can make you shoot
at tax collectors - and miss." -- Lazarus Long
From: deepthought!neil@ms.uky.edu (Neil Greene)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle UNKNOWN processes
Date: 7 Apr 92 13:53:47 GMT
Article-I.D.: deepthou.1992Apr7.135347.22526
Reply-To: Neil Greene <deepthought!neil@ms.uky.edu>
Organization: ARCI, Inc.

In article <4537@m1.cs.man.ac.uk> rick@rick.cs.man.ac.uk (Rick Dipper) writes:
> In article <1992Apr2.161630.5407@deepthought.uucp>,  
deepthought!neil@ms.uky.edu (Neil Greene) writes:
> |> I am running Oracle v6 on a NeXTcube.  I am accessing the database fine  
from  
> |> the host machine.  However, when I connect to the server through our  
Tymnet  
> |> network, Oracle processes come up with the user UNKNOWN.
> |> 
> |> > UNKNOWN    5349   0.0  2.3 3.40M  832K p4 S     0:00 ora_pmon_nasris
> |> > UNKNOWN    5350   0.0  2.8 3.49M 1024K p4 S     0:00 ora_dbwr_nasris
> |> > UNKNOWN    5351   0.0  2.8 3.40M 1016K p4 S     0:00 ora_lgwr_nasris
> |> > UNKNOWN    5352   0.0  2.3 3.40M  832K p4 S     0:00 ora_smon_nasris
> |> 
> |> Does anyone know what may be causing this, I am confused on the situation.   
> |> Note:  this does _not_ happen all of the time either.
> 
> This is becuse ps is looking in the password file to find the name of the
> user that owns the process. The process table only stores the UID of the 
> process. What has happend is that the entry in the password file has gone
> missing for some reason. Yoll have to investigate why & also why it comes
> back again. Maybe you NIS server dies or something ??

Well, the NeXT does not use normal unix flat files for system administration.   
Although, it is possible to use both flat file and NetInfo together.  I have  
simply exported the /etc/passwd file from Netinfo and will see if this solves  
the problem.

Thanks

-- 
Neil Greene
ARCI, Inc.
Kentucky NeXT User Group, Inc.
Phone: 606.254.4060
Newsgroups: comp.databases.oracle
From: brt@scammell.ecos.tne.oz.au (Brett Dunstan)
Subject: Import Parameters
Organization: Telecom Australia, Information Technology Development
Date: Mon, 13 Apr 1992 01:15:08 GMT

	G'Day Netters,

	This should be an easy question for most of you, and the
question may have already been asked, so if it has I am sorry.

	When an import is done there are a few undocumented arguments
that may be used in order to obtain some extra useful information. 
The only one that I know of is indexfile=< filename >, this creates a
file which consists of the number of rows in a given table, this is very 
useful for creating indexes before the import is actually performed. 

	Q : Does anyone know of any other parameters that are useful ?

	Please email me if possible:
		brt@scammell.ecos.tne.oz.au

			Thanks in Advance.

> Thanks For the Fragmentation Info, it was useful
From: mmwang@adobe.com (Michael Wang)
Newsgroups: comp.databases.oracle
Subject: Re: SQL: Translate
Date: 15 Apr 92 18:56:02 GMT
Article-I.D.: adobe.1992Apr15.185602.4194
Organization: Adobe Systems Incorporated

[ See my previous post for other solutions ]

Darn! I knew I was making things too complicated. If your mailbox number
can vary in length and you want NULLs try:

     RTRIM(mailbox,'*')

-- 
Michael Wang
mmwang@adobe.com
Newsgroups: comp.databases
From: liping@Xenon.Stanford.EDU (Liping Zhu)
Subject: Teradata system
Originator: liping@Xenon.Stanford.EDU
Organization: Computer Science Department, Stanford University.
Date: Wed, 15 Apr 1992 01:45:10 GMT

Hi, there!

We are about to build a system with the central repository on Teradata
(DBC/1012 is proposed) containing corporate financial data. Teradata will be
channel attached to an IBM 3090 or IBM ES 9000. Sun client/server systems and 
Sybase will be used to handle on-line business functions, such as customer 
service and order entry. An end-user will be using either a PC or a Sun 
workstation to access the data stored in the central repository or Sun 
servers. 

We want to learn as much as possible the industry experience for this kind
of system architecture. In our application, the typical requirements are:

   a. periodicly update the central repository from the corresponding Sybase 
      databases on Sun servers, and from the IBM 3090/ES 9000 DB2 databases. 
      
   b. financial and operational reports will be printed out at Sun workstations
      or PCs by assembly data from Sybase and Teradata databases.
      
We are particularly interested in the following issues:

   a. How sufficient and easy to use is the facility supporting communications
      between databases on DBC/1012 and DB2 databases on IBM 3090 or ES 9000?
      
   b. How well does the DBMS Gateways on Teradata support the communications
      between databases on DBC/1012 and Sybase databases on Sun workstations?
      
   c. Are there any reporting tools available on Teradata DBC/1012? 
      
   d. How sophisticated is the security control on Teradata? e.g. access
      rights for users on Sun platforms. 
   
Any information or experience regarding to the use of Teradata or to any of 
the above issues will be greatly appreciated! 

Please e-mail to lzhu@sunser.tpi.umn.edu.

Thanks a lot.
Liping
Newsgroups: comp.databases
From: tazzzzz@sparky.eecs.umich.edu (Kevin Dangoor)
Subject: Re: Foxpro 2 extended version - work with DOS 5 emm38
Organization: University of Michigan EECS Dept., Ann Arbor
Date: Sun, 5 Apr 1992 18:42:15 GMT

In article <1992Apr3.134137.10650@husc3.harvard.edu> wong1@husc4.harvard.edu (Christopher Wong) writes:
>On the extended or standard version? Standard: no problem. Extended: yes, 
>but not the way you think. Foxpro (X) uses the VCPI memory spec as provided
>by emm386, but not DPMI as provided by himem.sys (which you are undoubtedly
>using). Though you configured 2 Mb as EMS, it will be used as *extended*
>Chris

One thing I would just like to mention is that I've heard that Fox is
talking about making FoxPro (X) DPMI compliant in the not too distant
future. Which will then make it executable under Windows and OS/2 2.0
(something I would very much like... for multi-user testing if nothing else)

Kevin
internet: tazzzzz@eecs.umich.edu
From: pje@stan.xx.swin.oz.au (Peter Eden)
Newsgroups: comp.databases
Subject: Re: Can E-R express this?
Summary: ER solution
Date: 8 Apr 92 08:16:30 GMT
Organization: Computer Centre, Swinburne Inst. of Tech., Melbourne, Australia.

In article <11246@mindlink.bc.ca>, Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg) writes:
> I have an interesting relationship that I don't see how to put on an
> E-R diagram, and I'd appreciate any advice. It seems too simple and
> common for E-R methods to miss:
> 
> ORDER<ORDER#>
> ORDER_DETAIL<ORDER#, PRODUCT#>
> INVOICE<INVOICE#> ORDER#
> INVOICE_DETAIL<INVOICE#, PRODUCT#>
> 
> i.e. there is a one-to-many relationship between:
> ORDER and INVOICE
> ORDER and ORDER_DETAIL
> INVOICE and INVOICE_DETAIL
> ... with which E-R diagrams have no problem. On the other hand,
> there is the referential integrity constraint that an INVOICE_DETAIL
> must have an ORDER_DETAIL. I can expres this algebraically, but the
> client doesn't dig algebra. What am I missing?
> Oh, and I do NOT intend to make ORDER# a phony (and abnormal)
> attribute of INVOICE_DETAIL.

ORDER_DETAIL is in fact a derived relationship, so it does not
appear in the ER diagram. This is essential if redundancy is
to be avoided.

  ____________
  |  ORDER   |
  ------------
      1|
       |
      M|
   ___/|\____   M                     M  _____________
   |INVOICE |\--------------------------/|  PRODUCT  |
   ----------/                          \-------------

INVOICE_DETAIL is the weak entity arising from the many-to-many
INVOICE-PRODUCT relationship. ORDER_DETAIL is the derivable
many-to-many relationship ORDER-PRODUCT relationship which is not shown.

Peter Eden Information Systems Department Swinburne Institute AUSTRALIA.
Phone +61 3 8198402  Fax +61 3 8183656 Email  pje@stan.xx.swin.oz.au
Xref: sparky comp.databases:4054 comp.edu:709 comp.infosystems:254 sci.med:8428 alt.hypertext:387
From: chuan@milton.u.washington.edu (Chuan Lee)
Newsgroups: comp.databases,comp.edu,comp.infosystems,sci.med,alt.hypertext
Subject: Re: New Technologies for Medical Journals
Date: 8 Apr 92 07:07:58 GMT
Article-I.D.: u.1992Apr8.070758.11101
Followup-To: chuan@milton.u.washington.edu
Distribution: usa
Organization: University of Washington, Seattle

In article <961-PCNews-124beta@jacc.com> jcarroll@jacc.com writes:
>
>And probably the greatest form of encouragement will be if Medicare 
>promises faster remittance of fees if bills are submitted electronically
>instead of paper. That will be sure to move a lot of doctors into this
>area....
>

It is not necessarily true.  Think about what will you do if you
have to pay a big bill?  Won't you rather send it out just a couple
days before the due date, assuming the mail will be delivered on time?
So why would you do it differently if you are going to pay the bill
electronically?  If I were you, I would program all my bills be paid
just minutes before the due time (much less care about date).

Chuan Lee
Newsgroups: comp.databases
From: viking@iastate.edu (Dan Sorenson)
Subject: ESC trapping in FoxPro 2.0
Summary: I can't trap ESC effectively
Keywords: grrrr  aargh!
Organization: Iowa State University, Ames IA
Date: Mon, 6 Apr 1992 20:22:14 GMT

All,

     I have an interesting problem with trapping escape key
usage in FoxPro/LAN 2.0, and I'm hoping somebody knows what
may be done to fix it.

     First, I have "SET ESCAPE ON" and "ON ESCAPE RETURN TO
MASTER" set in my root program.  This program calls several
procedures, sometimes they are nested three and four deep.
In all instances, pressing the escape key will boot me back
to the root program, with one annoying exception.

     One procedure has three nested DO...WHILE loops and a
bunch of @SAY and @GET statements, with READS throughout.
I put up four @GET's and press ESC, and it will complete
the READ and go on instead of returning to the calling
program.  If I press ESC twice in quick succession, it will
return to the calling program, but if I'm not quick enough
it will read whatever values are in my GET fields and go
on to the next set of GETs and that READ.  All GETs are in
the form @row,col GET variable PICTURE 'XXXX', if that has
anything to do with it.

	In a fit of desperation, I made a new procedure
"mayday" and changed my statements to ON ESCAPE DO MAYDAY
and ON ERROR DO MAYDAY.  PROCEDURE MAYDAY consisted of a
CLEAR, a SAY, a WAIT, and then a RETURN TO MASTER.  It
had no effect on the problem.

	The only thing I can think of is that the READs are
capturing the ESC keypress, and when I press ESC twice in
quick succession it is captured before the next READ is
encountered.  This is still annoying.  Anybody have any
ideas?  I'm using FoxPro/LAN 2.0 with the 2.0 distribution
kit over a Novell 2.15c LAN on a 386/25 clone.

<Daniel R. Sorenson   Dod #1066  |If Iowa State University agreed with me >
<z1dan@exnet.iastate.edu <- work |I'd make $90K/yr.  They don't, I don't. >
<viking@iastate.edu      <- play |"I am *not* goofing off.  I am driving  >
< myself mercilessly in the pursuit of relaxation." -- T. Weeds           >
From: yse@minster.york.ac.uk
Newsgroups: comp.databases
Subject: Ingres Locking
Date: 16 Apr 92 08:51:15 GMT
Organization: Department of Computer Science, University of York, England

I recollect that "old" versions of Ingres supported only page
and table level locking. Do newer versions support row level locking?

Replies by e-mail please to: yse@minster.york.ac.uk

David Jordan
York Software Engineering
Newsgroups: comp.databases
From: hwilliam@isis.cs.du.edu (Hywel Williams)
Subject: Anyone with experience with Recital?
Keywords: recital 4gl xbase
Organization: Nyx, Public Access Unix at U. of Denver Math/CS dept.
Date: Fri, 10 Apr 92 13:33:06 GMT

My company is taking a very serious look at Recital, a 4gl which claims
to be xbase compatible.  Everything is looking good so far and everything
that we hear and see is positive.

Has anyone has a good/bad experience with this product?

Any help is GREATLY appreciated...

Please send any email to the address below of possible as email takes much 
longer to get through using the above email address!


Cheer,

--david
	Care of: cshjw@pyr.swan.ac.uk