HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.databases.oracle
From: smuench@oracle.com (Steven P. Muench)
Subject: Re: Customization of SQL*Forms.
Organization: Oracle Corp., Belmont CA
	<1992Aug28.020200.6019@sun44.synercom.hounix.org>
Date: Thu, 3 Sep 1992 08:24:09 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.

+------------+
| STOP PRESS |    YOUR INP FILES ARE NOT GOING AWAY IN FORMS4!!
+------------+    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

   We will offer a human readable (say, "human revisable") version
   of the form definition just like we did in Forms 2.0, 2.3, and
   3.0. We will provide forwards/backwards conversion between the
   ASCII form definition and the portable, compressed, binary form
   definition which Forms4 will generate/read by default.

   We will provide an upgrade utility to read Forms 2.0, 2.3, or 3.0
   form definitions ("INP files") and write out upgraded form
   definitions in the new format. This will, in fact, *be* the
   required conversion step to upgrade an existing application to
   Forms4.

   The ASCII version of the form definition may likely have a
   different format than the Forms 3.0 INP file, but the information
   contained within will be virtually identical. The ASCII version can 
   be used in your existing change/version-control systems, can be used
   to easily identify differences between versions using standard 
   operating system utilities, can be used to perform global 
   search/replace, and (albeit still officially unsupported) to make 
   modifications.

   We do not make changes in format of this type without good
   reason, you can be sure. This modification allows Forms4 to
   leverage work done within the Oracle Tools and Multimedia
   Products Group to support a common document reading and writing
   mechanism for all of the new Oracle Tools, known internally as
   the "Resource Object Store" (or ROS for short).

   We know very well how designers work with form definitions from
   within their favorite editor, and while there will be no method
   from within the Forms4 Designer to make global text substitutions
   on an *ENTIRE* form definition at once -- changing PART_ID to
   PART_NUMBER in every SELECT statement for example -- we have made
   a conscious effort to allow the Forms4 designer to escape to
   his/her favorite system editor wherever multi-line text input is
   expected in the Designer interface.

   The editing of INP files will continue to be unsupported because
   in general, a lot of damage can be done to your form definition
   by careless editing. Anyone who edits INP files *now* can
   understand this official position. But we will leave the option
   open for the knowledgeable, careful, advanced developer to
   manipulate the ASCII version of the form definition in whatever
   manner he/she sees fit.

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  Steve Muench              Email: smuench@oracle.com
  SQL*Forms Development
  Product Manager
Newsgroups: comp.databases.oracle
From: dewey@centerline.com (Devan F. Dewey)
Subject: Re: keypad & sql*forms
Followup-To: comp.databases.oracle
Organization: CenterLine Software, Inc.
Date: Thu, 3 Sep 1992 14:35:18 GMT

In article <1992Sep3.133806.971@src.honeywell.com>, kdady@src.honeywell.com
(Ken Dady) wrote:
> 
> Is there a way to re-define the numeric keypad on a
> VT100, Sun keyboard, Mac (running telnet) to be used
> as a 'normal' keypad with SQL*forms? i.e. 
> 
> In case it matters I'm using oracle 6.0.30 on a Sun 4 
> and accessing it via a Mac SE with an extended keyboard
> using BYU telnet 2.4.6 w/MacTCP.
> 

I haven't done this but the theory is:

emulate a vt220 (you'll need NCSA Telnet 2.5)
get and extended keyboard for the SE
use the keypad for the keypad and the function key across the top for
F-keys.

You'll tear your hair out trying to redefine everything to work as a vt100.

                             
               Devan F. Dewey | Senior Systems Analyst
          CenterLine Software | dewey@centerline.com
            10 Fawcett Street | "Leme esplain - no dere is
          Cambridge, MA 02138 | too much. Leme sum up."
                                       -Inigo Montoya
Newsgroups: comp.databases.oracle
From: sjs@netcom.com (Stephen Schow)
Newsgroups: comp.databases.oracle
Subject: Re: Customization of SQL*Forms.
Date: 28 Aug 92 18:43:14 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

I agree with Jeff,  INP files must not be eliminated.  Who knows who we
can talk to at this point to help Oracle swing in the right direction
with their decision about INP files?
-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs@netcom.com | pick the pear with the big paw paw......
               | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: wwm@ef2007.efhd.ford.com (William Meahan)
Subject: SQL*plus -- limiting maximum number of returned rows?
Organization: EFHD Ford Motor Company
Date: Mon, 31 Aug 1992 12:02:24 GMT

In SQL*Plus (not embedded SQL!) is there any way of limiting the number
of rows returned by a query?

I am working on a report that is supposed to find the "top 5" items in 
a catagory.  The query returns 0 or more rows based on the selection
criteria, sorted in the appropriate order.  Some queries return a dozen
or more rows, but I'm only interested in the first 5.

If I were using embedded SQL in a C program (or a perl script using 
oraperl) the solution would be trivial.  For internal reasons, however,
I'm stuck with using SQL*Plus.

Any ideas?


--
Bill Meahan
-- 
Bill Meahan			|EFHD Information Systems Staff
Technical Consultant		|Ford Motor Company
wwm@ef2007.efhd.ford.com      	| +1 313 487 6122
...!fmsrl7!ef2007!wwm           |I'm not paid to speak for Ford!
Newsgroups: comp.databases.oracle
From: ffeng@cs.tamu.edu (Fang Feng)
Subject: Oracle Books
Organization: Computer Science Department, Texas A&M University
Date: Tue, 1 Sep 1992 15:38:05 GMT

Hi, there:
    Are there books on how to use Oracle SQL*Forms, SQL*Menu, SQL*ReportWriter,
etc? It is not easy to read the manuals and do something, especially when you
use Open Window or Motif, since those manuals are written not for these kind of
environment. Can anybody mail me a list of the books?
    Thanx.

FF.
--
================================================
Department of Computer Science
Texas A&M University
internet_address: ffeng@cs.tamu.edu
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: Re: Problem on field of DEFAULT WHERE/ORDER BY on Form 3.0
Date: 28 Aug 92 08:54:50 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

In article <105@timer1.UUCP>, john@timer1.UUCP (john) writes:
> Hi, world:
> 
> In our company, we implemented a "Task Manager" with SqlForm30 to 
> keep track of our projects. When user run the form, we want him/her
> see only the tasks he/she is allowed to see. So, we put some conditions
> in DEFAULT WHERE/ORDER BY field of form30. Here is the piece from INP 
> file:
> 
>       ORDERING = <<<
>       where requestor in  (select access_name from DS_manager.user_access30
>             where user_name = lower(USER))
>          or request_for in (select dept_code from
>             DS_manager.dept_access30 where user_name = lower(USER))
>          or assigned = lower(USER)
>       ORDER BY Date_completed desc,DATE_REQUIRED, PRIORITY, date_entered
>       >>>
> 
> When I added in 4th OR condition in it then generate and execute it, it
> had segment fault and core is dumped (on unix environment) but if I trimmed
> that part, it goes fine. We guessed that the buffer mighted be too small 
> to hold the whold conditions.
> 
> Does any one know any limit on the buffer size of DEFAULT WHERE/ORDER BY
> field of block definition screen on Form 3.0. Or, it might be the limit
> of the number of "OR" conditions 
> 
> Any info will be apprecaited.
> 
> John Chan (Rightime Econometrics, Inc)

  A few time ago, i had also a problem on a UNIX system. But the core was dumped
  because I had different types of datatypes. I had a field (CHAR) with
  numbers in it like '19920828' and a procedure with variables:
  
  Screen field CHAR
               ^^^^
  
  POST-CHANGE on field
  check_date(field);
  
  
  and the procedure
  
  PROCEDURE CHECK_DATE (datum IN NUMBER) IS .....
                                 ^^^^^^
  
  The form runs everytime out of control and a core was dumped. But the form
  crashed not only in this field, it crashed anywhere. So I changed the 
  type of the field to Integer (INT). Since that time it works.
  
  
                                                              Mike
  
  ================================================================================
                                                                            ^
   Federal Ministry of Science and Research                               B | M
  <-------------------------------------------------------------------------+---->
   Computer Center                                                        W | F
                                                                            |
   Klaus-Michael Hatzinger            mail: hatzinger_m@bmwf1f.bmwf.gv.at   |
   Bankgasse 1/209                   phone: 0043-222-53120/5188             |
   1014 Vienna, Austria                fax: 0043-222-53120/5155             V
  ================================================================================
Newsgroups: comp.databases.oracle
From: dbenson@us.oracle.com (Daniel Benson)
Subject: Re: Freeing disk space
Organization: Oracle Corporation, Redwood Shores CA
Date: Wed, 26 Aug 1992 17:38:44 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 <BtK57E.HFE@monitor.com> howard@monitor.com (Howard Brenner) writes:
>When you issues a drop or delete command in oracle (then a commit) does  
>oracle free up the disk space to be reused by someone else or does it just  
>move on to the next block it thinks has been usused?  If it doen't "free"  
>the disk is there a way i can tell oracle that I'm really done with it and  
>let it reuse the space.  I seem to notice that when I create some very  
>large tablespaces after a lot of drops, creates and deletes i run out of  
>tablespace!
>
>thanks!

Howard,

Tablespaces are created for the life of the database.  The only way to free up
the space is to drop the tablespace.  There were several problems with block
cleanup that have been fixed in 6.0.34.  One issue is that the kernel doesn't
always do block cleanup when you do an update or delete because of performance
considerations.  The way to force block cleanup is to do a full table scan. 
Something that most applications try to avoid.  Other ideas: check out
percent used vs. percent free in your create commands.  Export, drop, re-create
and import to recover orphan block space and reduce fragmentation.   The DBA 
Guide explains how space is allocated and reused for database objects.  -d
D
D
Guide explains how space is allowcated and used for database objects. -d
C
C

C
and import objects to recover 
C
and import objects to recover space and reduce fragmentation
From: coghawks@mentor.cc.purdue.edu (john)
Newsgroups: comp.databases.oracle
Subject: Oracle Precompilers and Nulls
Keywords: Precompiler Null
Date: 3 Sep 92 23:19:42 GMT
Distribution: usa
Organization: Purdue University

I recently happened into a problem using Pro-C with embedded SQL with
Nulls and comparison differences between = and IS (NOT) NULL.
It was when I had built a cursor which selected into a host variable,
which was then used as part of a selection criteria on the next
SQL statement. What occured was that when using the where clause
for ex. WHERE EMPD.DESCRIPT = :host_emp, if either value was null
then this never would return true or if they both were null
it still wouldn't be true.  So either I had to have 2 versions and check
explicitly if and when things were NULL before I use them in a WHERE 
clause,  or set them to a default value.  Which in oracle is syntactily
supported, but not implemented when declaring a table.  Another problem
with setting things to a default value is then building indexes etc..
those values are all grouped.  I am new at this and am looking forward
to any replies.

Thank you
John Hawkins.

======================================================
I disclaim !! I disclaim!!                          
Newsgroups: comp.databases.oracle
From: Neil Greene <deepthought!neil@ms.uky.edu>
Subject: SQL&ReportWriter Question
Reply-To: Neil Greene <deepthought!neil@ms.uky.edu>
Organization: ARCI, Inc.
Date: Wed, 2 Sep 1992 18:38:16 GMT

I have a question using SQL*ReportWriter.

I have a report I want to add page numbers (index pages) to using a start value  
supplied by the user.  How?

Neil Greene
ARCI, Inc.
President, Kentucky NeXT User Group, Inc.
Phone: 606.254.4060
Fax: 606.254.4864 
Email: deepthought!neil@ms.uky.edu [NeXTmail]
Soon to be: neil@kynug.org, neil@benchmark.com
-- 
Neil Greene 
Director, Computer Information Systems ARCI, Inc.
President, Kentucky NeXT User Group, Inc.
Email: deepthought!neil@ms.uky.edu [NeXTmail]
From: M.W.Stern@massey.ac.nz (M.W. Stern)
Subject: Re: ORAPERL
Organization: Massey University, Palmerston North, New Zealand
X-Reader: NETNEWS/PC Version 2c
Date: Wed, 26 Aug 92 21:22:12 GMT

Can anyone answer the following questions for me.

1) Is ORAPERL public domain, shareware,...?

2) Can ORAPERL be compiled on, or is available for, MSDOS given that
   PRO*C is available?

Many thanks in advance.

==============================================================================
Mark Stern              | "There are holes in the sky,
Analyst/Programmer      |  where the rain gets in,
Massey University       |  but they're ever so small,
NEW ZEALAND             |  that's why rain is thin"
Internet:               |  ...
M.W.Stern@massey.ac.nz  |     Spike Milligan
==============================================================================
From: hans@pyrtor.UUCP (Hans Jespersen)
Newsgroups: comp.databases.oracle
Subject: Re: Parallel architectures and Oracle
Keywords: yes
Date: 26 Aug 92 21:23:46 GMT
Reply-To: hans@pyrtor.UUCP (Hans Jespersen)
Organization: Pyramid Technology Canada, Toronto, Ontario

In article <=2ann3q.tcox@netcom.com> tcox@netcom.com (Thomas Cox) writes:
>In article <nirad.713977503@newdelphi> nirad@newdelphi.ceu.uq.oz.au (Nirad Sharma) writes:
>>Has Oracle v.6/7 been ported to any parallel architectures ?  
>
>Yes:  VAXcluster, HA/6000, Sequent (new box not yet out), nCube, KSR-1, NCR,
>and a few others.
 ^^^^^^^^^^^^^^^^
Pyramid MIServer
 
>Call your local Oracle reps.  Ask about version 6.2 and about the v7 Parallel
>Option (or whatever it's called).
         ^^^^^^^^^^^^^^^^^^^^^^^
Oracle Parallel Server

--   
       -m-------   Hans Jespersen                        hans@pyrtor.UUCP
     ---mmm-----   Pyramid Technology Canada             Tel:  (416) 490-1165 
   -----mmmmm---   2235 Sheppard Ave. East, Suite 1104   Fax:  (416) 490-9864
 -------mmmmmmm-   Willowdale, Ontario, Canada M2J 5B5
Newsgroups: comp.databases.oracle
From: lahti@paiste.fmi.fi (Mikko Lahti)
Subject: Re: how to compress database and move indexes to different tablespace
Organization: Finnish Meteorological Institute
Date: 4 Sep 92 11:37:57

In article <1992Sep2.100626.1@bbs.mdcbbs.com> suskind@bbs.mdcbbs.com writes:

> I am trying to compress my database. While I am at it I am moving stuff
> into various tablespaces to improve performance and layout. My original
> database has only ONE tablespace "system". My new database will have
> "system", "user", "temp", and "index". I can see how to easily move
> a user's tables into the "user" tablespace by only giving him resource
> in that tablespace and altering his user account so "user" is his default
> tablespace. 

As you did not mention version you are using, I suppose RDBMS v. 6.0.
You might already know this, but have you checked that none of your users
have general resource privileges (that is, have number 1 in column 
RESOURCE_PRIV in table DBA_USERS). If they have, they have resource on 
every tablespace and granting (or revoking) resources in any one tablespace
does not mean a thing and imports always goes to the original tablespace.
So do not use GRANT RESOURCE TO <user> command (I think it is quite useless),
use always GRANT RESOURCE ON <tablespace> TO <user> command.

> However, how to I move the corrisponding indexes? I have tried using the
> "show" option of IMP to generate a file, but this file is in such a poor
> format I cannot use it without EXTENSIVE editing. Does anybody have a
> utility that will take the file generated by the "show" option and make it
> usable? The format I get is ONLY 80 column records and EVERY line is
> enclosed in double quotes.

Try 

IMPORT username/password INDEXFILE=<filename>

It gives you a file <filename>.SQL with CREATE INDEX commands.
It works on RDBMS 6.0.34 (may work on earlier versions, but I cannot say
for sure), but it is not yet in the manuals, only in the readme-file.

Hope this helps, I had to learn it by try-and-error.

Mikko Lahti                            Mikko.Lahti@fmi.fi
Finnish Meteorological Institute
Helsinki, Finland
From: kml@cellar.org (John Galt)
Newsgroups: comp.databases.oracle
Subject: Re: maxdatafiles -- inquiry/update
Keywords: maxdatafiles
Date: 28 Aug 92 12:32:02 GMT
Organization: The Cellar BBS and public access system

esc@netcom.com (Steve Etchelecu) writes:

> 
> I am looking for a method to inquire on the current value for
> the MAXDATAFILES parameter which was set when a database is created.
> 
> More importantly, I am looking for a method to increase this value
> without having to recreate the database.
> 

The only way to set the MAXDATAFILES value is to do a CREATE DATABASE.
To change it, you have to export the old DB and re-create.  
The dc_files parameter in init.ora is kind of cosmetic.  It can't override
maxdatafiles.  Check the create_host_instance.sql script in the
ora_instance directory; it's created by the installation procedure.
If there's no maxdatafile spec, then you're stuck with the default,
which is 32 in VMS.  When you recreate the DB, set maxdatafiles high;
the control file size will then increase nominally.

The only other way I can think of to view maxdatafiles size would be to
do a trace dump of the control file; any oracle.com folks care to
contribute the syntax?  It's something like "alter database trace immediate
controlf level 3" ???


kml.


               Personally, I skip the posts and just read the sigs.

  kml%cellar@tredysvr.tredydev.unisys.com - My other account is a Mercedes.
From: losburn@teal.csn.org (Lynn Osburn)
Newsgroups: comp.databases.oracle
Subject: Report process so large it gets killed
Date: 1 Sep 92 15:37:21 GMT
Organization: Colorado SuperNet, Inc.

Running under AIX 3.1.x on RS/6000, 16M, 40M swap, Oracle 6.0.31.x.x;

We have run into difficulty while running a SQL*ReportWriter report.
The report has two "IN" clauses. If we provide it with more than 
about 5 values for the "IN" clauses AIX takes over and kills the process
because paging space is too low.  This usually occurs about 1 minute and
fifteen seconds into the run, and all is lost.

Does anyone know a way to limit the resources that SQL*ReportWriter can
use, or a way to tell AIX not to kill the process.  We need to run 
several of these reports at once, but due to the fact that we can not
even run one to completion we are stuck!

Aside from rewrite the report, specific examples of reconfiguring our
machine, or Oracle would be appreciated.
From: jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
Subject: SQL*Net performance - why this way?
Date: 4 Sep 92 17:36:04 GMT
Organization: University of Helsinki

Dear Netters,

I have done some performance measurements on using Oracle SQL*Forms in
client/server mode. The client was always a PC (386SX/16MHz to
486/50MHz) and was used against a remote database server.

The results were (using SQL*Forms 3.0 and 386SX 16 MHz IBM PS/2 55SX)

  Simple query (13 different SQL statement executions)

  Time  Relative  Server/Protocol
  3.5s  1.00      IBM 3090 VM/XA         APPC
  3.3s  0.94      HP9000/817 HP-UX       TCP/IP
  3.2s  0.91      IBM RS6000 340 AIX     TCP/IP
  2.6s  0.74      IBM PS/2 70 OS/2 1.3   NetBIOS
  2.6s  0.74      Tricord Novell NetWare SPX/IPX

  Complex update

  Time  Relative  Server/Protocol
  20.9s 1.00      IBM 3090 VM/XA         APPC
  17.5s 0.84      HP9000/817 HP-UX       TCP/IP
  17.2s 0.82      IBM RS6000 340 AIX     TCP/IP
  13.1s 0.63      Tricord Novell NetWare SPX/IPX

Using 486 25 MHz client (Dell 425DE) the results for the complex update were:

  Time  Relative  Server/Protocol
  14.2s 1.00      IBM 3090 VM/XA         APPC
   6.1s 0.43      IBM RS6000 340 AIX     TCP/IP
   5.5s 0.39      Tricord Novell NetWare SPX/IPX

All tests were performed without other users whenever possible. We used
4Mbps Token Ring in all tests. The time was taken when repeating the
test during the same session (the first timing during a session is about
30..50% slower than subsequent timings).

Could anybody explain WHY we got those results: Why SPX/IPX and NetBIOS
were faster than TCP/IP, particularly on the 386SX?

Are there any parameters which could be tuned to gain better
performance? We used HP ARPA 2.11 TCP/IP package on the PCs. I tried to
tune some parameters without any success.

Do the results match any other measurements?

Why 386SX is so much slower than 486 25 MHz?

By the way, the complex update takes about 2 seconds when run on the
UNIX servers without SQL*Net or using a powerful UNIX workstation as a
client.
--
Juhani Jaakola
jaakola@cc.helsinki.fi
From: ar869@cleveland.Freenet.Edu (Jon S. Christiansen)
Newsgroups: comp.databases.oracle
Subject: Writing your own functions for SQR in UFUNC.C on the VAX
Date: 27 Aug 92 22:36:37 GMT
Reply-To: ar869@cleveland.Freenet.Edu (Jon S. Christiansen)
Organization: Case Western Reserve University, Cleveland, OH (USA)


	I have been trying to write a character function through UFUNC.C on
the VAX to no avail.  I am using SQR 2.27 I believe.... my main problem is
using pointers and etc, and figuring out how to pass a character string back
to the program.  The included UFUNC.C is nice, but it doesn't have enough
examples to show exactly how to write a string function that returns a string.
Anyone who has a few examples of any functions that they have written, I would
appreciate it very much if they could send me some sample code, either through
the list, or right to me at: jsc93@uno.cc.geneseo.edu

	Thanks in advance!!!
		Jon Christiansen
		Student Programmer/Analyst
		SUNY Geneseo, New York