HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.databases.oracle
From: kmallory@oracle.com (Kevin Mallory)
Subject: Re: I heard a Rumor about Oracle 7 and Forms
Followup-To: comp.databases.oracle
Organization: Oracle Corp., Belmont CA
	<13NOV199213095729@erich.triumf.ca> <49670@shamash.cdc.com>
Date: Thu, 19 Nov 1992 17:20:08 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <49670@shamash.cdc.com> jeff@svl.cdc.com (Jeff Needham) writes:


   grant@erich.triumf.ca (Peter A. Grant) writes:

   >In article <1992Nov13.184731.21707@cs.rochester.edu>, zhang@cs.rochester.edu (Zhang Ju) writes...
   >> 
   >>I heard a rumor which goes that the delay of ORACLE 7 is because of its
   >>incompatibility with Forms 3. So Oracle 7 is actually waiting for Forms 4.
   >>...

  > heard ORACLE7 supports SQL*Forms 2.3 and 3.0.  It's being released before
  > Forms2.3 and 3.0 have PL/SQL V1 compilers running inside them, the kernel uses
  > PL/SQL V2.  You can't single-task link Forms 3.0.16 to V7 kernels, otherwise
  > no problem.

  > But who uses single-task anyway ;-)


	NOT!

	You *CAN* link single task forms 3.0.15 or greater with oracle
7 and it will work.  There is no conflict between PLSQL V1 and PLSQL
V2 in this environment (at least on VMS).    What platform are you
concerned about?


--
---------------
Kevin Mallory	Oracle Corporation - Redwood Shores, California
SQL*Forms Development
I don't speak for Oracle, nor they for me.
Remember: If you can find someplace you laik better 'n' Tuna... **MOVE**!
From: ALANB@OWGVM0.VNET.IBM.COM (Alan Beal)
Date: Mon, 16 Nov 92 16:27:44 EST
Newsgroups: comp.databases.oracle
Subject: Ada, OCI, double with Encina
Organization: Federal Systems Company (IBM)

Can someone help me with the following two questions:

1) Is there an Ada version of OCI or is it supported only in C?
Does the Pro*Ada precompiler produce Ada code or C code?

2) When we try to update (insert/update) a table column that is
defined as NUMBER(11,2) using a double (using Pro*C), we get
a 'mdiv zero' error when our application uses Encina.  Without
Encina, it works fine, and using a VARCHAR host variable works in either
case.  Does anyone know why (does Encina use a different math library)?

Alan Beal         alanb@owgvm0.vnet.ibm.com
                  (607)751-2026
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: PD Pro*C SQL unload - wanted
Date: 18 Nov 92 22:07:30 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au
Summary: SQL UNLOAD - creates SQL*Loader files - where is it ?
Keywords: software required

Some time ago I came across reference to Pro*C source that created
an sqlunload utility : made control files, etc, from a select
statement.

Can someone email it to me or tell me where it lives ?
dtb@otto.bf.rmit.oz.au

-- 
David T. Bath
email: 	dtb@otto.bf.rmit.oz.au
Work: 	Global Technology Corporation, Carlton, Vic, OZ  (03) 3477511
#include <disclaimer.h>
Newsgroups: comp.databases.oracle,comp.databases.sybase
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Table Design Hint needed
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Thu, 19 Nov 1992 17:28:34 GMT


Without duplication of data, the many-to-many relationship is best
expressed as an intersection table:

create table DIRECTORS (
  pk_director number not null primary key,
  dir_name char(40) not null
) ;
create table BUSINESSES (
  pk_business number not null primary key,
  bus_name char(40) not null
) ;
create table BUS_DIR_XREF (
  fk_business number not null references BUSINESSES,
  fk_director number not null references DIRECTORS,
) ;
create unique index pk_bus_dir_xref (fk_business,fk_director);
create unique index pk_bus_dir_xref (fk_director,fk_business);

It may serve your purposes to define a view pre-joining these tables:

create view BUSINESS_DIRECTORS as
  select pk_business business, pk_director director, 
	bus_name, dir_name
  from BUSINESSES, DIRECTORS, BUS_DIR_XREF
  where fk_business=pk_business
	and fk_director=pk_director
  ;


Now you can do selects like this:

  select business, bus_name
  from BUSINESS_DIRECTORS
  where bus_name='INTERNATIONAL BUSINESS MACHINES'
  ;

Enjoy.
-Andy

PS - this was typed with verification against SQL.  There might be
some C-isms that creeped in .


ummalik@ccu.umanitoba.ca (Ijaz Rashid Malik) writes:
>Hello,
>I have to design two tables and I need some help to minimize the duplication
>etc.
>One table is "businesses" and key fields is business ID.
>Other is "directors" and key is dir. ID.
>A business can have more than one directors and a director can control more
>than one business.
>Both table have to be linked so that all directors for a given business or
>all businesses under given director could be listed.
>My thinking either calls for mulitple Dir. ID. columns in business table
>(dir1. ID, dir2. ID...) but its not practicle as # of directors varies. OR
>same director could be listed in directors table under different ID's and 
>there is a column (field) called Business ID which points to the business
>controlled by this person but problem with this is that same record is listed
>multiple times ==> redundancy!!!
>Could someone please help me out here with some hints...
>Thanks very much!
>Malik
>ummalik@ccu.umanitoba.ca
-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy@vistachrome.com, andy@genie.geis.com.
  Join GEnie, call 800-638-9636/301-251-6415.  Join Unix, CASE, and Desktop 
  Oracle RDBMS Database discussions, send mail to ora-request@vistachrome.com
From: btreuman@ems.cdc.com (Bob Treumann)
Newsgroups: comp.databases.oracle
Subject: EUROTUNNEL,CIT,Kvaerner Engineering Ltd
Date: 23 Nov 92 16:03:23 GMT
Reply-To: btreuman@ems.cdc.com
Organization: Empros Systems International, a division of CDC

If anyone using Oracle at Eurotunnel,
CIT and/or Kvaerner Engineering Ltd  reads this newsgroup, please 
respond to me to discuss CASE and MCS-II.


Mail address   Bob Treumann
               1290 Osage St North
               St Paul Mn    55117

Thanks.
From: idixon@infocom.UUCP (Ian Dixon)
Newsgroups: comp.databases.oracle
Subject: Re: Dell Unix - rmfree map overflow
Date: 21 Nov 92 23:51:17 GMT
Distribution: world, local
Organization: INFOCOM Public Unix Server, +44 [0] 734 340055

Hi there
The place that I'm currently working at has a Dell machine running SCO Unix. 
They did this because Dell Unix would not run Oracle v6. More recently, 
they've tried to get the two working together. Perhaps because they are both 
in the same town, Oracle and Dell talked to each other and ended up saying 
that the two would work together. The most recent Oracle UK Technical 
Bulletin says that Oracle is now certified to work with Dell Unix.
I know this doesnt solve your problem but maybe you could use the fact that 
the two companies have been talking in the UK to get the answer you need out 
of one of them!

Regards
Ian
PS We are still using SCO Unix
-- 
_________________________________________________________________
  EMAIL =---> idixon@infocom.co.uk (Ian Dixon)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Newsgroups: comp.databases.oracle
From: charlie@clarify.clarify.com (Charlie Hsu)
Subject: Senior Database Application Engineer Wanted
Organization: Clarify Inc., San Jose
Distribution: ba
Date: Fri, 13 Nov 1992 20:00:12 GMT


Exciting position as senior database engineer in
rapidly growing 45 person software vendor startup
located in the San Jose/Santa Clara area.

Be a major contributor to the architecture of a set of
client/server applications running in multiple hardware,
software environments.  Join a winning team.

Responsibilities include:
   Design and development of an object-oriented data
     integration architecture
   Implementation of Oracle 6.0 and 7.0 data servers
   Application data modeling

Position Requirements:
   Minimum BS in Computer Science or equivalent
   3 or more years in software development
   2 or more years with Oracle database application 
     development
   Software vendor experience

Demonstrated Skills:
   Strong C Programming 
   Database modeling knowledge
   Oracle Call Interfaces (OCIs) for C language experience 
   Large software development experience

Personal Characteristics:
   Team-player
   Conscientious
   Flexible
   Ethical & Loyal
   Self-starter
   Dedicated

Reply by email to:
   charlie@clarify.com








Newsgroups: comp.databases.oracle
From: omikko@cs.joensuu.fi (Olli Mikkonen)
Subject: Re: Long insert statement in PCC ireclen exceeded.
Organization: University of Joensuu
Date: Mon, 23 Nov 1992 08:26:04 GMT

kortikar@mipos2.intel.com (Aniruddha Kortikar) writes:

>I have a long insert statement in PRO*C insert into table ( ....) values (...)
>ireclen is exceeded.
ireclen is the maximum length of source line.  The PCC option does not work.
ireclen is always 80 characters.  If you have longer source lines,
there will occur some kind of a input buffer overflow in PCC, and
the results are quite unpredictable (core dump or erraneous code produced).

>I tried 
>char stmt[1000];
>sprintf(stmt,"insert into ... values (:v1,:v2);");
>exec sql execute s using :val1,:val2 ....
1. Remove the semicolon from the end of the SQL-statement.
2. There is a bug in Oracle.  If you declare a host variable
   as an array of char, Oracle can't always detect the end of the
   string.  To get around the bug there are several alternatives:
a) Add some spaces to the end of the string.
b) Use VARCHAR as a type the host variable.
c) Try something like this:
char stmt[1000];
EXEC SQL BEGIN DECLARE SECTION;
char *sqlstatement;
EXEC SQL END DECLARE SECTION;
...
sprintf(stmt,"insert into ... values (:v1,:v2);");
sqlstatement = stmt;
EXEC SQL PREPARE S FROM :sqlstatement;
exec sql execute s using :val1,:val2 ....

>but even then the exec sql execute s using is about 300 chars long.

>is there any way out other than using :a1,:a2 as variable names.

>Aniruddha Kortikar (kortikar@mipos2.intel.com)
>-------------------------------------------------------------------------------
>E-mail 	: kortikar@mipos2.intel.com | A billion here, a billion there ...
>Phone(W): 408 765 5515              | pretty soon it adds upto real money.
>-------------------------------------------------------------------------------

The information above is based on my personal experiences with Oracle
versions 6.0.3[1-4] and discussions with Oracle (Finland) tech support.
People at Oracle may disagree.

Olli Mikkonen
-- 
Olli Mikkonen		: Any opinions above are purely my personal ones.
Internet: 		: Especially they do not reflect my employers
omikko@cs.joensuu.fi	: official opinions.
Newsgroups: comp.databases,comp.databases.theory
From: marti@nugget.inf.ethz.ch (Robert Marti)
Subject: Re: Simple SQL Join question
Organization: Dept. Informatik, Swiss Federal Institute of Technology (ETH), Zurich, CH
Date: Mon, 16 Nov 1992 09:19:30 GMT

In article <1992Nov13.152835.1@ilp.mit.edu>, gold@ilp.mit.edu writes:
|> 	I have a basic SQL question regarding joins. [...]  A typical 
|> query would ask for:
|>         "List employee names and ids and each employee's
|>          department(s), publication(s), project(s),
|>          expertise keyword(s)
|> Some employees have 10+ expertise keywords, 2-3 departments, 1-30 
|> projects, 1-500 publications.
|> 
|> The SELECT statement that I am using is listed below.  [...]
|> Is there a simplier, or less resource-consuming way of using SQL to 
|> answer the user's question (in quotes above) rather than using the 
|> SELECT statement below.  Thank you for any assistance!
|> 
|> SELECT  [...]
|>   FROM  employee, employee_dept, dept, employee_project, project,
|>         employee_publication, publication, employee_expertise, expertise
|>   WHERE [ ... lots of join conditions deleted ...]

As David Masterson points out in his posting, you have practically
no other choice than to issue separate queries (typically 3-way joins
joining employee, employee_something, and something) and to "join"
their results "manually", by writing a C-ESQL program, or by using
some sort of 4GL (whatever that means) which supports the stuff you
want.

Also, be aware that your SELECT-statement above will not return
_any_ information on employees who have no corresponding information
in _one_ of the tables joined with employee.  In this case, you'd
have to use outer joins, a feature which was not in the 89 SQL
standard.  (However, as far as I know, outer joins are supported
by many systems.  Also, for what it's worth, I think outer joins
made it into the 92 SQL standard.)

Your example is IMHO one of the biggest weaknesses of relational
systems (or 1NF, if you will) as opposed to, for example, object-
oriented systems.

-- 
Robert Marti                    |  Phone:    +41 1 254 72 60
Informationssysteme             |  FAX:      +41 1 262 39 73
ETH-Zentrum                     |  E-Mail:   marti@inf.ethz.ch
CH-8092 Zurich, Switzerland     |
Newsgroups: comp.databases
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Subject: Re: help needed on sybase stored procedure
Organization: MIND LINK! - British Columbia, Canada
Date: Thu, 19 Nov 1992 04:22:37 GMT

> In article <1992Nov14.000317.58320@ssf-corp.dhl.com>,
> julies@ssf-corp.dhl.com (Julie Stephens) writes:
> |> I'm attempting to create a generic Sybase stored procedure which will
> |> accept up to 254 input parameters.  Within the stored procedure
> |> I would like to determine how many parameters were passed to the
> |> stored procedure & process them.
>
> |> Here is an example of what I'm trying to do.  The problem here is
> |> clear (see WHILE clause).  The program will evaluate the temporary
> |> variable @argName--not the input parameter @arg1.
> |>
> |>      CREATE PROC processArguments
> |>              @arg1   varchar(255),
> |>              @arg2   varchar(255),
> |>              @arg3   varchar(255),
> |>              ...
> |>              @arg254 varchar(255)
> |>      AS
>
> Anyone reported this to Sybase as a feature enhancement request?
>
> Mark
>


254 arguments !? No, I'm sorry, I guess you *are* being serious.

While there is a time and place for everything, might I suggest that
if using as many as 254 arguments might occur some time, then a list
of arguments is not the place for them. More likely, you might want
to create something like:

        create table #arg(num int, val varchar(255) null)
        create procedure ProcessArgs as
        declare @nargs int
        select  @args = count from #arg
        ... operations on #arg en masse where possible and
                en loope where not ...
        go
        drop table #arg   /* ... to be born again */

        create table #arg(num int, val varchar(255) null)
        insert #arg(1, "This is the first argument")
        ...
        insert #arg(254, "This need not be the last argument!")
        exec ProcessArgs
        drop table #arg

Small tables are a pretty efficient way of dealing with lists of values
in Sybase, and allow you the efficiency of vector operations instead of
tedious loops, within your procedure ...
        (e.g. "update #args set val=rtrim(val) where num between 3 and 10")

Then again, perhaps I'm off base, and that the actual purpose is to
see how much Transact can be used without having to resort to any SQL :-).

--
Mischa Sandberg ... Mischa_Sandberg@mindlink.bc.ca
                 or uunet!van-bc!rsoft!mindlink!Mischa_Sandberg
*-*-*-*-*-*-*-*-*-*-*
Engineers think equations are an approximation of reality.
Physicists think reality is an approximation of the equations.
Mathematicians never make the connection.
Newsgroups: comp.databases
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re: How About COMP.DATABASES.PARADOX ?
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Date: Mon, 23 Nov 1992 15:57:00 GMT

In article <1992Nov20.055959.11241@pegasus.com>, tleylan@pegasus.com (Tom Leylan) writes...
>mikef@som.yale.edu (Michael Fanara) writes:
> 
>> I think that a seperate group for Paradox would be an excellent idea.  I've
>>spent days, that's right days, trying to get through to Borland Tech Support.
> 
>>Access to the USENET is a very easy task for me and would prove to be an
>>invaluable service to me.
> 
>Mike... dividing up comp.databases comes up every so often (there was talk
>of a separate "xBase" newsgroup some time back) and I oppose them in
>general because the traffic on comp.databases doesn't warrant it.

The traffic doesn't warrant it!?  My god, this newsgroup is humongous.  If I
didn't have to monitor it, I wouldn't because it takes so long to get through
it!  Maybe there are newsgroups out there that are bigger, but this is still
awfully big.  So big that it's a pain.

I think separating out certain traffic as a function of software, when that
software can be easily identified as separable (like Paradox), is a good idea.
However, I don't think organizing it by platform, as was suggested earlier,
makes good sense.

Bill Thompson
Newsgroups: comp.databases
From: mikes@vivanet.com (Michael Shea)
Subject: Re: Foxpro for UNIX?
Organization: VIVATRON Corporation 
Date: Thu, 19 Nov 1992 12:32:06 GMT

In article <1992Nov15.021053.6862@DIALix.oz.au> dent@DIALix.oz.au (Andrew Dent) writes:
>The Windows and DOS versions are now in beta test.
>
>I have a letter from Microsoft Australia that states that SCO are doing the
>UNIX version (this is a reversal from the falling-out between Fox and SCO a
>year or so ago).

 I went to a microsoft seminar and they confirmed this.  Told me that
 we could expect the product in early 1993.  Whatever that means in
 Microsoft speak.....

>
>Andy Dent (A.D. Software - Mac & VAX programming)
>-94 Bermuda Dve, BALLAJURA  Western Australia  6066
>Phone/Fax: 09 249 2719 (local)  +619 249 2719 (International)
>       Internet: dent@DIALix.oz.au    Compuserve: 100033,3241
>

Michael Shea          VIVATRON Corporation
mikes@vivanet.com

Newsgroups: comp.databases,comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: SQL Query and a QUEL query
Organization: U.S Dept. of Transportation
Date: Mon, 23 Nov 1992 13:45:05 GMT

thomasl@mtl.mit.edu (Thomas J Lohman) writes:

>I want to select all entries of a table like so based on some
>qualifications:

>select ta1.name from table1 ta1, table2 ta2 where ((ta1.id = ta2.id
>and ta2.string = "testing" and ta2.sequence = 1) and (ta1.id = ta2.id and
>ta2.string = "testing2" and ta2.sequence = 2))

Well, first of all, the ta1.id=ta2.id is given twice and second of all,
more importantly, you'll get a null return because you have
"ta2.sequence=1 and ta2.sequence=2" and same for ta2.sequence in your 
where clause.  Maybe you meant "or" in the middle of the where and not
"and".  Assuming you did, you could render this in QUEL (if memory
serves me correctly) as

range of ta1 is table1
range of ta2 is table2
retrieve (ta1.name) where [same clause, corrected, as above]

Oh, I notice your SQL select should have ' instead of ".

Seth Grimes, dcatlas!sethg@uunet.uu.net
Newsgroups: comp.databases
From: DVaz@cup.portal.com (David D Vazquez)
Newsgroups: comp.databases
Subject: Re: MANY-TO-MANY mess in Paradox!!!
Date: Sat, 21 Nov 92 13:58:09 PST
Organization: The Portal System (TM)

>
>Is it just me or does every one is unhappy withg Paradox's way of handling
>many-to-many links. I always end up with extra tables and lots of redundant
>information. In a typical scenerio (sp?), a product can be supllied by
>many vendors and a vendor can suplly many products. When it comes to 
>displaying either side of this info, paradox suggests extra tables and their
>use in the "form" display/generation. It, however, doesnot suggest an
>answer to following problem....
>
>say, from an input screen I am entering info about new products or new
>suppliers. If its products, it can have a variable number of vendors and
>if it is a vendor, there could be a variable # of products for it. How can
>I design an input screen/form that has linked tables on it and handeles
>multiple entries for a given field. I mean I can use Products as master
>form and use vendors as linked embeded form. Now when ever I enter a new
>product, I am not sure how many vendors for this product there will be.
>Could be 0,1, or 10000!!! How can I design an input screen and then table
>which would handle this situation????
>

Many to many relationships should always be resolved.  This feat is ac-
complished by use of an intersection table.  In your example above, the
final database could look like this after the many to many is resolved:

  VENDORS
    Name         A10*
    Location     A15

  PRODUCTS
    Name         A20*
    Manufacturer A30
    MSRP         $

  INVENTORY (you'll have to shrink this down to 8 chars for DOS)
    Vendor Name  A10*
    Prod. Name   A20*
    Quantity     N

INVENTORY is the intersection table.

For the input screen, you could use VENDORS as the master, embed INVENTORY,
and use PAL to popup a form that you can enter new products on.  This method
is good because it would be a waste of space to keep track of products that 
no vendor has in its inventory.  When a vendor starts supplying a *new* product
,
you could add it to the product list, then the product will be available when
other vendors add it to their inventory.

If you decide to make PRODUCTS the master and embed INVENTORY, you'll have to 
reverse the order of INVENTORY's key.

>Thanks very much for help.
>
>Malik
>ummalik@ccu.umanitoba.ca

  You're welcome
  -Dave.  "dvaz@cup.portal.com"
Newsgroups: comp.databases
Subject: re: How about comp.databases.[...].paradox
From: lembark@sysjj.mdcbbs.com
Date: 21 Nov 92 21:05:20 GMT
Organization: EDS Unigraphics, Cypress CA
Nntp-Posting-User: lembark

wherever we put it, i'd read the thing.
sl
Organization: University of Illinois at Chicago
Date: Tuesday, 17 Nov 1992 10:00:21 CST
From: Ron Vyhmeister <U53805@uicvm.uic.edu>
Newsgroups: comp.databases
Subject: Database Design Tools

I'm looking for a current review of tools used in database design.  Where is
the most recent one?  Also, and Database Design tools available as public
domain or shareware?

I'm looking for stuff for a PC platform, WIN or DOS.

Thanks

Ron Vyhmeister
u53805@uicvm.uic.edu -- Internet
u53805@uicvm         -- Bitnet
From: weiss@cs.wm.edu (David W. Weiss)
Newsgroups: comp.databases
Subject: dBASE prompt menu question
Date: 20 Nov 92 19:34:22 GMT
Distribution: na
Organization: The College of William and Mary



Is there a way in dBASE to put up a prompt menu containing
more than one field from the input file?  The DEFINE POPUP
command only allows PROMPT FIELD <field name> without
permitting multiple fields.  

Thanks,

Dave Weiss
weiss@cs.wm.edu
Xref: sparky comp.databases:7887 comp.databases.oracle:2217 comp.databases.ingres:1909
From: jeff@svl.cdc.com (Jeff Needham)
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.ingres
Subject: Re: I heard a Rumor about Oracle 7 and Forms
Date: 16 Nov 92 19:32:58 GMT
Followup-To: comp.databases

grant@erich.triumf.ca (Peter A. Grant) writes:

>In article <1992Nov13.184731.21707@cs.rochester.edu>, zhang@cs.rochester.edu (Zhang Ju) writes...
>> 
>>I heard a rumor which goes that the delay of ORACLE 7 is because of its
>>incompatibility with Forms 3. So Oracle 7 is actually waiting for Forms 4.
>>...

>heard ORACLE7 supports SQL*Forms 2.3 and 3.0.  It's being released before

Forms2.3 and 3.0 have PL/SQL V1 compilers running inside them, the kernel uses
PL/SQL V2.  You can't single-task link Forms 3.0.16 to V7 kernels, otherwise
no problem.

But who uses single-task anyway ;-)
 

later,me


--
Buy Nerve Net or go to jail!
| Jeffrey Needham
| Yet Another Oracle Performance Group
| Control Data Systems Inc - Santa Clara, CA - jeff@hawk.svl.cdc.com