HDTenEightyP/NetNews huggingface dataset:
From: DVaz@cup.portal.com (David D Vazquez)
Newsgroups: comp.databases
Subject: Re: Validating data imported from text files.
Date: Thu, 19 Nov 92 20:58:47 PST
Organization: The Portal System (TM)
Distribution: usa

>I was just told something startling.  In an E-mail message from Myron China
><mryo@ind_maroon.gwl.com>, I was told

>   problem with flat file xfers is verifying successful completions of both
>   the dump and the import.  oracle products, for instance, always signal 
>   a 0 return code whether or not it had a problem.  so you end up spooling
>   log files and checking them for errors yourself.  we also check file
>   record layouts for validity before anything goes through.

Hmmm.  I've worked with Oracle's SQL*Loader utility.  It can write a log file
of everything (if I remember correctly) as well as a log file with only the
erroneous data in it.  If it returns 0 regaurdless of the outcome, you can
always check for the existence of the error log file by running the loader
and whatever construct you use to find the file from a script or batch file.

  -Dave.  "DVaz@cup.portal.com"
Newsgroups: comp.databases
From: schaerer@isi.ethz.ch (Thomas Schaerer)
Subject: dBase IV  MEMO-Field !!!
Organization: Swiss Federal Institute of Technology (ETH), Zurich, CH
X-Newsreader: TIN [version 1.1 PL6]
Date: Fri, 20 Nov 1992 18:41:09 GMT


Hello world,

Can somebody help me? The problem:
The right lineal-end-tabulator of the MEMO-Field (Editor) has a length
of 65 Characters per default. I read in the originalbooks of dBASE IV,
that it is possible to set this value to another number. The only way
is a set-command  in CONFIG.DB. But I didn't find out the right command.
(SET MEMOWIDTH ...  is wrong!).

Please answer to my e-mail-box. Thank you very much.

Bye Thomas		schaerer@isi.ethz.ch

Newsgroups: comp.databases
From: broy@vaxa.weeg.uiowa.edu (Barbara Roy)
Subject: Re: Query by Example
News-Software: VAX/VMS VNEWS 1.41    
Organization: University of Iowa, Iowa City, IA, USA
Date: Fri, 20 Nov 1992 21:13:00 GMT

In article <20NOV199212114547@aardvark.ucs.uoknor.edu>, ntruelove@aardvark.ucs.uoknor.edu (STEP OUT OF THE CAR PLEASE) writes...

<stuff deleted>

> 
>Multi-table queries can be performed by linking several query forms through the
>use of tilde variables.  

This must be a typo because query forms are linked by EXAMPLE ELEMENTS, not
tilde variables. Tilde variables are used to supply run-time values to a query.

Barbara Roy, University of Iowa, Weeg Computing Center, Iowa City, IA.  52242
Internet:   broy@vaxa.weeg.uiowa.edu or Barbara-Roy@uiowa.edu
Bitnet:     broyva@uiamvs.bitnet  
Disclaimer: My opinions are solely my own and may change daily.
From: tleylan@pegasus.com (Tom Leylan)
Newsgroups: comp.databases
Subject: Re: Clipper 5.01 array problem
Date: 21 Nov 92 08:12:14 GMT
Organization: Pegasus,  Honolulu

timmer@fwi.uva.nl (Ralf Timmer (I89)) writes:

>To manage this I use Straleys :

>But, if I place the above IF..GET..ENDIF in a FOR..NEXT loop, with
>the index of aExtra is the same as the loop counter it doesn't work
>anymore!?

Ralf...  I'm not a major fan of Straley and usually suggest that people
ignore his stuff so I'd rework it without his #xtranslate...

On the other hand the reason you have a problem in that fragment is that
by the time the EVAL()'s are taking place you have incremented your
counter variable beyond the length of the array.  In other words you
can't do it that way.  You were hoping that the value of the counter
got "transferred" somehow but it doesn't.

tom
Newsgroups: comp.databases
From: aahz@netcom.com (Mean Green Dancing Machine)
Subject: Re: PARADOX HELP NEEDED re: auto fill of key field.
Organization: Don't blame me, I voted for Bill 'n' Opus
Date: Sun, 15 Nov 1992 16:12:34 GMT

Call Borland's Tech Fax number, (800) 822-4269, and order a catalog of
the available information.  The one you're specifically looking for is
#662, Auto-increment.
-- 
                         --- Aahz (the *other* Dan Bernstein)
                             @netcom.com 

Hugs and backrubs -- I break Rule 6

Trying to be happy is like trying to build a machine for which the only
specification is that it should run noiselessly.
Newsgroups: comp.databases,comp.os.msdos.programmer
From: jmcquade@ringer.cs.utsa.edu (Jorge R. McQuade)
Subject: Re: FoxBase to `C' Contract: How much should I ask for? Help
Organization: University of Texas at San Antonio
Date: Sat, 21 Nov 1992 19:09:18 GMT

In article <1992Nov16.232318.21234@ve3ied.UUCP> bduncan@ve3ied.UUCP (Bill Duncan) writes:

>I developed a number of tools functions which emulated the 
>FoxBase counterparts.

Could you be more specific about this?

Thanks

G. McQuade
UTSA

Xref: sparky comp.databases:7916 comp.databases.ingres:1922
From: jgk@osc.COM (Joe Keane)
Newsgroups: comp.databases,comp.databases.ingres
Subject: Re: Ingres questions followup
Summary: VMS is dumb.
Keywords: byte
Date: 16 Nov 92 20:13:09 GMT
Reply-To: Joe Keane <jgk@osc.com>
Followup-To: comp.databases
Organization: Versant Object Technology, Menlo Park, CA
Weather: sunny, high 66, low 47
Moon-Phase: waning gibbous (57% of full)

In article <BxLBKH.2w0@usenet.ucs.indiana.edu>
mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney) writes:
>Traditionally, files under VMS are limited to 65534 byte records.  That's
>because for normal variable length record files, the record length is stored
>in the two bytes before the record.

That is so dumb.  What kind of operating system is it?  It looks like a C-64.
I mean, sometimes you can get away with using less bytes if you're clever.
But having variable-length fields break when you get to 64KB is unacceptable.

--
Joe Keane, professional programmer
jgk@osc.com (uunet!amdcad!osc!jgk)
Newsgroups: comp.databases
From: cpetersn@iastate.edu (Clifton R Peterson)
Subject: Re: AREV MULTIVALUE Symbolics
Keywords: AREV MULTIVALUE SYMBOLIC
Organization: Iowa State University, Ames IA
Date: Sun, 22 Nov 1992 04:35:18 GMT

This should be as simple as using the following oconv[ersion]

"MD02" 

which displays zero decimal points but divides the number by 100 before
applying the zero decimal place rule.

Clif

-- 
 _________________________________________________________________________
/ Clifton R. Peterson    1108 Burnett		(515)232-5254	    	  \
| B.S. Chem E            Ames IA  50010                                   |
\_______________"42"_is_one_hell_of_an_answer!!___________________________/
Newsgroups: comp.databases
From: "tom frazer" <tom.frazer@canrem.com>
Subject: query by example?
Reply-To: "tom frazer" <tom.frazer@canrem.com>
Organization: Canada Remote Systems
Distribution: comp
Date: 23 Nov 92 05:19:21 EST


======\ Quoting: GARY BARTOW \======\ On: 11/21/1992 \===========

GB> I just heard the phrase "Query By Example" and was wondering if anyone
GB> knew what it was all about.  It seems to be a technique to help users f
GB> their queries more precisely.

======================================\ END QUOTE \======================

    It refers to a method of building an example, on the screen, of the
type of data you want displayed from a search.
    It does NOT work with dBASEs RUNTIME module, so unless your customer
has the full dBASE package it is useless to try it.
    IMO, it's not too difficult to learn but is not easy either. It
involves selecting the database fields you want to view from across the
top of the screen. These are then pulled down to the bottom of the screen
and show the order of the fields as they will come up on the display, then
if necessary, you must build a condition box to select the criteria of the
data to be displayed.
 In dBASE it looks kinda like this

----------------------------------------------------------------------
         :           :         :           :
database : v field_1 : field_2 : v field_3 : etc..
----------------------------------------------------------------------
                                 ^indicates field to be used in query
                                  (clicked on with a mouse or from menus)

                                                   --------------------
                                                      CONDITION BOX
                                                    field_1 = SUBSTR(test)

          --------------------------               --------------------
            field_1 : field_3 : etc
          --------------------------

    Personally I prefer to program search choices in, also I use the
Runtime package so this can't be used.
---
 . MegaMail 2.10 : A happy life has memories u don't want to repeat
--
Canada Remote Systems  - Toronto, Ontario
World's Largest PCBOARD System - 416-629-7000/629-7044
Newsgroups: comp.databases
From: bonak@herky.cs.uiowa.edu (Esmail Bonakdarian)
Subject: Normalizing 2NF -> 3NF
Date: Sun, 15 Nov 1992 16:34:13 GMT
Reply-To: bonak@herky.cs.uiowa.edu (Esmail Bonakdarian)
Organization: U of Iowa, Iowa City, IA

I have a question about normalizing a relation from 2NF to 3NF.
My understanding is that we try to remove any sort of transitive
dependencies during this step.

E.g., given a relation with three attributes, A, B, and C, where
attribute A is the PK, the following dependencies exist:

+----+-----+----+
| A* |  B  | C  |
+----+-----+----+

   A -> B
        B -> C

i.e, A determines B, and B in turn determines C.

3NF would split this up into two relations:

+----+-----+
| A* |  B  |
+----+-----+
            and

+----+----+            +----+----+
| A* | C  |    OR      | B* | C  |
+----+----+            +----+----+

Which of these two latter relations is the "correct" one according to
the theory? Or does it always depend on the given semantics of the data
being modeled? It seems to me that I've seen both.

Could somebody please clear this up form me? Also, any references to
material/articles (both on/off the net) that explain the normalization
process clearly would be much appreciated.

Thanks!

Esmail
PS: If this isn't the best place to ask this question, please tell me
    where to post this instead. Thanks
From: dalet@reseau.Berkeley.EDU (Groupe SUPAERO)
Newsgroups: comp.databases.oracle
Subject: Manipulating an ORACLE database on HP-9000 from a Macintosh
Date: 16 Nov 92 16:58:54 GMT
Reply-To: dalet@reseau.Berkeley.EDU (Groupe SUPAERO)
Distribution: world


 Hi,

 I'm a french engineer working in an engineering school.
 We have an ORACLE database v 6.0 (soon v 7.0) on HP-9000 serie 850.
 We plan to develop an application of student's management (name,
address, marks, ...)
 running on a macintosh and manipulating the HP ORACLE database.

 The students management is divided in 2 parts :

   - Updating the database with input screens from the Macintosh.

   - Querying the database to produce reports or data about student's
results with 
     the possibility of processing those data with software like
excel,word,etc ...


 Could you tell me what sorts of softwares i need to do such an
application ? (for each part)


 Thanks in advance !
Newsgroups: comp.databases.oracle
From: c-wilson@uchicago.edu (Clark H. Wilson)
Subject: High-vol admin sites
Organization: University of Chicago
Date: Mon, 16 Nov 1992 22:21:42 GMT

We're researching the feasibility and wisdom of replacing our major 
administrative systems (independent of each other & running on the 
mainframe) with an integrated set of systems based on Oracle, running 
on Unix boxes.

I've been asked to focus on the overall performance issues involved - 
specifically, to find, talk with, and even visit sites running loads 
and transaction mixes roughly like or more challenging than those we 
anticipate.  Let's say 800 to 1500 simultaneous users, doing what 
the Interbase folk are fond of calling "online complex transaction 
processing" - i.e., mixed inquiries and updates with complex 
transactions that vary widely (as opposed to high transaction volumes 
that are predominantly inquiries or that consist of nearly identical 
transactions).  As I said, I'm interested in Oracle running under Unix,
on any hardware configuration, any architecture (unified, distributed, 
whatever).

If you are at or know of such a site I'd appreciate email or a phone call 
from you.  If you send me a phone number I can then call you on our nickel.
Unless you explicitly say it's okay I won't give your name or other 
identifying info to anyone else.

Or, if your site tried to do this but the attempt crashed and burned, I'd
very much like to talk with you!

If you know of recent articles, consulting group reports available 
for purchase, etc., I would also be interested in those; but my primary 
goal is to talk directly with, and perhaps visit, actual sites.

The best email address to use is the one in the signature, below.

Clark Wilson
Manager, Administrative Information Systems Consulting
University of Chicago
312/702-8871
c-wilson@uchicago.edu
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: Will Oracle Provide USER EXITS in kernel ?
Summary: Request for rumors ?
Keywords: PL/SQL Stored procedures user_exit
Date: 19 Nov 92 13:34:33 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au


Has anybody heard (or would like) the ability to link in user-exits
into the oracle rdbms that could be called from the PL/SQL of stored
procedures ?


========================================================================
David T. Bath
email: 	dtb@otto.bf.rmit.oz.au
Work: 	Global Technology Group, Carlton, Vic, OZ  (03) 3477511
"Failure to emulate is the best revenge" - Marcus Aurelius
=======================================================================
-- 
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
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Platforms for Oracle
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Thu, 19 Nov 1992 17:21:39 GMT

David Mason <vid@zooid.guild.org> writes:
>I'm not sure where to post this. It's sort of a general 
>question, I'm looking for people's thoughts and experiences.
> 
>Currently our organization is using a proprietary NCR 
>minicomputer on which a large number of accounting-related 
>COBOL programs are running. In the next year or two we will 
>be switching over to a new system. 
> 

A colleague in Nebraska is also in this situation I believe.
He is evaluating an Oracle solution and another database,
I cannot remember which one; Progress sticks in mind.

[parts deleted showing Unix aim]
> 
>Oracle recommended four hardware vendors for us to consider: 
>the high end is Sequent and Pyramid at over $100,000, and 
>the low end is Sun and HP, both at around $60,000. 
> 

In general accounting packages generate high select rates during
data entry, and high update rates during commit and processing.
In order to maintain an acceptable performance rate for your
users you may need to go with a high-end Sun or HP system at that
$60K figure.

>What I'm wondering is if there are less expensive, less 
>proprietary (in my mind at least) systems (IE Intel '486 
>architecture that we've had more experience with) that would 
>run these accounting systems as well or better. Does anyone 
>have any experience with running Oracle, particularly their 
>accounting system, on a platform such as an EISA 
>multiprocessor SCO system, Compaq Systempro, ALR, or 
>whatever? 

We have some experience on PC Unix and SunOS (low-end ELC Sun)
with Oracle and Multi-user databases.  Both are uni-processor
models with substantial amounts of memory in use by Oracle and
its toolsets.

Taking the 486 system:
  486 Micronics 486DX-50 mhz
  48 megabytes of memory
  2.5 gb of disk storage, 2gb of it for Oracle
  24 port Equinox board with Wyse-50 terminals
  WD8003E ethernet for printing

We get adequate performance for 12 interactive users doing 
high-select slow update activities.  Slow periods include
news processing <grin> and long-running reports which could
be solved by tuning our application.

> 
>Thanks for any (polite) suggestions.
>-- 
>vid@zooid.guild.org             -->> ZOOiD Public Access Usenet 416 322-7876
-- 
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
Newsgroups: comp.databases.oracle
From: Mathew L. Spolin <mspolin@cyber.hughes.american.edu>
Subject: Re: Manipulating an ORACLE database on HP-9000 from a Macintosh
X-Xxmessage-Id: <A72D8D5377029637@cyber.hughes.american.edu>
X-Xxdate: Mon, 16 Nov 92 22:39:31 GMT
Organization: Cybervision Productions
X-Useragent: Nuntius v1.1.1d12
Date: Mon, 16 Nov 1992 22:34:41 GMT

In article <2436@cix.cict.fr> Groupe SUPAERO, dalet@reseau.Berkeley.EDU
writes:
> I'm a french engineer working in an engineering school.
> We have an ORACLE database v 6.0 (soon v 7.0) on HP-9000 serie 850.
> We plan to develop an application of student's management (name,
>address, marks, ...)
> running on a macintosh and manipulating the HP ORACLE database.
>
> The students management is divided in 2 parts :
>
>   - Updating the database with input screens from the Macintosh.
>
>   - Querying the database to produce reports or data about student's
>results with 
>     the possibility of processing those data with software like
>excel,word,etc ...
>
>
> Could you tell me what sorts of softwares i need to do such an
>application ? (for each part)

Practically any of the "card" based authoring systems would work,
including Hypercard,
SuperCard, and Oracle Card (which also works under Windows).  You pass
SQL to the
Oracle database by way of an XCMD which sends the command through SQL*NET.

Other options are the Macintosh database programs like 4th DIMENSION,
Omnis 7, and
Double Helix.  These are relational database systems that can be modified
to use
SQL, although they weren't written for the job.

Based on my experience with Oracle Corp. and the federal government, I
would recommend
using Oracle Card.

---Matt Spolin
   Washington, D.C.
Newsgroups: comp.databases.oracle
From: einhorn_d@apsicc.aps.edu (E. Drew Einhorn)
Subject: Dell Unix - rmfree map overflow
Date: Wed, 18 Nov 92 21:32:00 GMT
Organization: Albuquerque Public Schools - Career Enrichment Center
News-Software: VAX/VMS VNEWS 1.41    

Hello,

I am trying to get Oracle 6.0 up on a Dell Unix SVR4 Issue 2.2
platform.  When attempting to apply 6.0.34 Patch #2:

I am getting a large number of messages of the form:

WARNING: rmfree map overflow D01B475C. lost 1 items at -19yxxx

where y is 0, 1, or 2 and x is a decimal digit. 

By digging around using strings and grep I have determined that
these error messages are coming from the unix kernel.  I hope
that fixing it will only require adjusting a kernel config
parameter and building a new kernel.  Has anyone seen this
problem and gotten around it.

At present Oracle Tech Support considers it a "Dell problem".
Dell's front line Tech Support has referred to another Dell
group and I am waiting for someone to return my call.

Any suggestions on what it takes to get the respective Tech
Support Organizations to cooperate and solve the problem, 
instead of assigning the blame?

Newsgroups: comp.databases.oracle
From: David Mason <vid@zooid.guild.org>
Subject: Platforms for Oracle
Organization: The Zoo of Ids
Date: Wed, 18 Nov 1992 17:06:35 GMT

I'm not sure where to post this. It's sort of a general 
question, I'm looking for people's thoughts and experiences.
 
Currently our organization is using a proprietary NCR 
minicomputer on which a large number of accounting-related 
COBOL programs are running. In the next year or two we will 
be switching over to a new system. 
 
The focus of the system will be two or three different UNIX 
based servers, one used for the accounting system, one as a 
database server, and one for other uses. These systems will 
be accessed from users who are on PC workstations using 
Ethernet, tied together with Novell LANs.
 
The main problem is the accounting system. Right now two 
systems are being considered, a system from a company called 
Coda, which sounds good but it only runs on DEC's Vax/VMS, 
and an accounting system from Oracle. For various reasons we 
are leaning towards the Oracle system since it will run on 
many platforms including SVR4. 
 
Oracle recommended four hardware vendors for us to consider: 
the high end is Sequent and Pyramid at over $100,000, and 
the low end is Sun and HP, both at around $60,000. 
 
What I'm wondering is if there are less expensive, less 
proprietary (in my mind at least) systems (IE Intel '486 
architecture that we've had more experience with) that would 
run these accounting systems as well or better. Does anyone 
have any experience with running Oracle, particularly their 
accounting system, on a platform such as an EISA 
multiprocessor SCO system, Compaq Systempro, ALR, or 
whatever? I've been hearing a lot of good things about a 
system from Altos but don't know any details. We're looking 
for a hardware vendor with better pricing, more open 
architecture, and a non-mainframe sales philosophy. Also one 
that has had a lot of experience with this type of system, 
this Oracle accounting system and UNIX SVR4 in particular. 
Does anyone have any suggestions? It would have to be a dealer 
that could support us in Toronto, Canada so we'd be looking for
something local.
 
Thanks for any (polite) suggestions.
-- 
vid@zooid.guild.org             -->> ZOOiD Public Access Usenet 416 322-7876
From: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Newsgroups: comp.databases.oracle
Subject: how to insert datetime in PRO*C
Date: 18 Nov 92 00:53:56 GMT
Organization: Intel Corporation, Santa Clara, CA USA

varchar var1;
varchar var2;
varchar datetime[15];
datetime.arr contains "mm/dd/yy hh24:mi" i.e "12/30/92 15:54"
datetime.len contains 14     

char stmt[1000];
strcat(stmt,"insert into tablename (f1,f2,date_field) values (:v1,:v2,:v3)");
exec sql prepare s1 from :stmt
exec sql execute s1 using :var1,:var2,:datetime

ORA-01859 : a number was found in a date and a letter was expected.

How can I force oracle to consider this as datetime. in normal sql I would have
done 
insert into tab (f1,f2,date_field) values 
		(v1,v2,to_date('char text','mm/dd/yy hh24:mi');

exec sql execute s1 using :var1,:var2,to_date(....) does not work

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.
-------------------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: walker@superboy.jsc.nasa.gov 
Subject: MVS & DBA job in Texas
Reply-To: walker@superboy.jsc.nasa.gov
Organization: NASA Johnson Space Center
Date: Mon, 23 Nov 1992 20:37:39 GMT

GHG, Corp currently has an opening for an ORACLE DBAA with MVS
experience.  If interested contact me by email aat
walker@superboy.jsc.nasa.gov  or 713-483-9281

-- 
Doug                   

Ask not what your country can do for you, but what you can 
do for your country.  - JFK
Newsgroups: comp.databases.oracle
From: Neil Greene <deepthought!neil@ms.uky.edu>
Subject: Oralce and color monitors on unix platforms
Reply-To: Neil Greene <deepthought!neil@ms.uky.edu>
Organization: ARCI, Inc.
Date: Thu, 19 Nov 1992 14:46:18 GMT

We are getting ready to integrate several clients with Oracle running in a  
Unix environment.  I have played around with the color options for Oracle,  
but was wondering what recommendations the net may have for color  
terminals accessing oracle.  

What other options should I consider in this development?  What about  
bitmapped environments??  Anyone have pricing available?? 
-- 
Neil Greene
President, Kentucky NeXT User Group, Inc.
Email: neil@ms.uky.edu [NeXTMail]
Newsgroups: comp.databases.oracle