HDTenEightyP/NetNews huggingface dataset:
From: richard@asis.unimelb.EDU.AU (Richard Begg)
Newsgroups: comp.databases.ingres
Subject: Re: ESQL Bug
Date: 20 Aug 92 01:57:39 GMT

kmchylla@vms.macc.wisc.edu writes:

|We have Ingres 6.4 installed on two machines, the first being a
|VAX 6610 (our production machine) and the second being a VAX
|4000 VLC (our development machine) both running VMS 5.5.  Ingres
|is installed separately on each machine.

|I wrote an embedded SQL program using C that seems to go into an
|infinite loop when I have too many records to process, and
|I can't figure out why.  The program simply sets up a
|cursor to read each record, take a character field (storing
|a gregorian date) and convert it to a date.  It updates another 
|field in the same record (a date field), and fetches the next record.   

|This seems easy enough, but if my table gets too large it seems
|to get "stuck" on a record and processes that same record until I 
|stop the process.  The strange thing is, depending on the Ingres 
|installation (production vs development) the program will run longer 
|before looping.  (The production machine can handle larger tables 
|than the development.)  

Let me see if I've got this right...

You have a cursor on which selects rows from a table, performs
some calculation then updates the row.

Have you declared the cursor for update?
How large is this table?
How far does it get before it loops?

A bit more info might help to track this down.  

Just a suggestion:  This sort of operation is *VERY* inefficient in a
relational database (we found out the hard way!).  If it is at all possible
to perform this operation in raw SQL operations rather than
using a cursor loop, then I would go for it, especially if the data set is
large.

Cheers,

--
Richard Begg (richard@asis.unimelb.edu.au)
Admin Systems and Info Services - University of Melbourne.
Newsgroups: comp.databases.ingres
From: CS_PAUL@GSBVAX.UCHICAGO.EDU (Paul Ford 312/702-0335)
Subject: RE: String Substitution
Organization: National Radio Astronomy Observatory
Date: Wed, 12 Aug 1992 17:20:07 GMT

Michael McGarrigle writes:

>We wish to replace all occurences of a "-" with a space in
>the employee_name field in a table.

It's ugly, but you can use the string functions left, right, locate, and
length to do it.

    update employee
    set
    employee_name =
       left( employee_name, locate(employee_name,'-')-1)
     + ' '
     + right( employee_name, length(employee_name)-locate(employee_name,'-'))
    where
    employee_name like '%-%'

This only takes care of the first '-'.  The update has to be repeated
until it affects 0 rows.

Try a select first to convince yourself that it works:

    select fixed_name =
       left( employee_name, locate(employee_name,'-')-1)
     + ' '
     + right( employee_name, length(employee_name)-locate(employee_name,'-'))
    from employee
    where
    employee_name like '%-%'

Paul Ford
--------------------------------------------------------------------------
GSB Computing Services                  312.702.0335
University of Chicago                   cs_paul@gsbvax.uchicago.edu
1101 E. 58th Street
Chicago IL 60637
--------------------------------------------------------------------------
From: ron@sigyn.cs.athabascau.ca (Ron Haukenfrers)
Newsgroups: comp.databases.ingres
Subject: Dynamic FRS
Keywords: Ingres, FRS
Date: 13 Aug 92 18:35:07 GMT


Does anyone know of a way to dynamically create a field in an ingres form?
I would like to create a field at runtime because it's datatype, length
and attributes are all derived at runtime.  I guess I can use the old
hack of creating a big text field and doing the manual type conversions,
but that doesn't solve the problem of data length and attributes.


Thanks.
--
Ron Haukenfrers		VE6RWH				     *********
ron@sigyn.cs.athabascau.ca				    **********
							   .      ****
Athabasca University 	Educational Computing Services	  ..      ****
P.O. Box 10 000						 ....     ****
Athabasca, AB CANADA	(403)675-6332			..........****
Newsgroups: comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Form-/menu-based PC frontends to DBs
Organization: U.S Dept. of Transportation
Distribution: comp
Date: Wed, 19 Aug 1992 13:55:27 GMT

Does anyone have suggestions for forms- or menu-based PC client
software that can be used to query Ingres DBs running on a server
using Ingres/Net?  

Possibilities are IQ, which won't come out with an Ingres compatible
version for another month, and maybe SQL Assist.  Does anyone have
any experience with these or similar?

Seth Grimes, dcatlas!sethg@uunet.uu.net
From: LAMCOLIN@HKGVM8.VNET.IBM.COM
Date: Fri, 14 Aug 92 14:22:57 HKT
Newsgroups: comp.databases
Subject: Very large Decision Support database with Sybase ?!

Hi USENET reader,

A project is looking for solution to support a DSS (end user oriented,
  ad hoc type) with 60Gb of data from various data sources. The largest
  table will have 33Gb of data.

Does any one of USENET readers/shops experience such large data volume with
  Sybase?

Is there any physical limitation on the table size or database size with
  Sybase?

Usually, Sybase says they are good in OLTP environment, but how about DSS
  environment? Any reference or experience?

Moreover, whether all data should be placed on a single server or a network of
  servers? Does Sybase has transparent access of data that partitioned over
  several machines?

Thanks in advance for any advice and comment.

Colin Lam, IBM Hong Kong, LAMCOLIN @ HKGVM8.VNET.IBM.COM
Newsgroups: comp.databases
From: sdo@cbnewsl.cb.att.com (scott.orshan)
Subject: Re: Hot Standby DBMS's
Organization: UNIX System Laboratories
Date: Thu, 20 Aug 1992 19:25:38 GMT

In article <1992Aug19.052516.24063@anasaz> briand@anasaz (Brian Douglass) writes:
>
>Another approach to this through the use of Transaction Managers (Tuxedo,
>Encina, Top-End under Unix).  These products, and their grandpappy, CICS,
>have the ability to distribute transactions among processors or machines be
>they 10 feet apart or 100 miles.  

	...

>People from all three of these companies are listening and I'm sure they'd
>be happy to post their addresses, phone numbers and contacts if people are
>interested.

>Brian Douglass		briand@anasazi.com 	602-870-3330 X657

Well, you caught me listening again.  Before I give the contact information
for the TUXEDO System, let me plug a couple of upcoming features that have
direct applicability to the problem at hand.

(Note - the TUXEDO components are all named /<something>, e.g., /T, /WS)

The new feature called /Q provides store-and-forward messages, where the
message storage and deletion is done within an XA-compliant distributed
transaction.  The message storage facility is a special purpose
XA-compliant database.

This allows for the reliable enqueueing of service requests to be
processed either immediately, or at a later time if the service
is unavailable due to some failure.

Another new feature allows separately administered TUXEDO networks
to call each others services and allows transactions to span these
networks.

This means that a bank's application, which knows how to debit your
bank account, and a stock brokerage application, which knows how to
buy shares of stock, can be linked in a distributed transaction
such that the stock purchase and the debit occur together.  Without
this capability, the stock brokerage has to generate a batch EFT
transaction to the bank that may bounce, but the stock has already
been purchased.

It also allows for a single network to be broken up into smaller,
more easily administered pieces, and still function as part of a
larger application.

These facilities allow for a hot standby system or network to exist
far away, with all service requests done both locally, and also queued
for processing at the backup site. (I'm talking about high level
application requests: DEBIT, RESERVE-ROOM, etc., not physical database
operations.)

One thing that the other proposed schemes do not address is that of
software bugs.  Whether using locally redundant hardware, or geographically
separated backup systems, the physical updates to the databases are
still done by one piece of software.

By architecting the backup system so that it uses a different DBMS,
or even a different implementation of the application, it is more
likely that one system will be able to continue processing if the other
is stopped by a bug.

For more information on the TUXEDO System, please contact:

	UNIX System Laboratories
	190 River Road
	Summit, NJ  07901  USA
	+1-800-828-UNIX
	+1-908-522-6000

	London office: +44-81-567-7711
	Tokyo Office:  +81-3-5484-8605


Scott Orshan
USL
908-522-5063
sdo@usl.com
Newsgroups: comp.databases
From: tedboone@freezer.cns.udel.edu (Edward F. Boone)
Subject: Easy-to-use DB for Unix?
Reply-To: tedboone@freezer.cns.udel.edu
Organization: University of Delaware
Date: Thu, 20 Aug 1992 19:08:54 GMT

I am looking for a database for Unix.  Preferably NOT a power user
Database, but rather a database more directed towards end users?
Any input would be appreciated.  Please e-mail me...
tedboone@brahms.udel.edu
 



Newsgroups: comp.databases
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re: nested SQL select
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Date: Wed, 12 Aug 1992 17:08:00 GMT

In article <l8h5i5INNhvg@jethro.Corp.Sun.COM>, jdr@starflight.Corp.Sun.COM
writes... 
>In article 3761@keele.keele.ac.uk, csa09@seq1.keele.ac.uk (Paul Singleton)
writes:
>>Is there a general algorithm for translating relational algebra expressions
>>into SQL?  Or a preprocessor from sensible SQL to real-world SQL?  Or have
>>I (and my colleagues) missed something obvious?
> 
>You've missed our thread on "SQL Shortcomings", in which we have shown why
>SQL is brain-damaged and needs to be stamped out.

Not to start any flame wars, but is anything else but SQL being worked on as a
standard for intercommunication between different vendors databases?  We're
going to be using SQL because we have that requirement.  I haven't heard of any
non-vendor-specific developments of relational languages other than SQL, but
would be interested to hear if there are.

Bill Thompson
Newsgroups: comp.databases
From: khioe@mona.jpl.nasa.gov (Kent Hioe)
Subject: Re: How to trim down dBASE IV database file ?
Keywords: dbase IV file
Organization: jpl
Date: Thu, 20 Aug 1992 17:01:34 GMT

In article <1992Aug20.034649.16721@cam.compserv.utas.edu.au> rhidding@esk.compserv.utas.edu.au (Robert Andrew Hidding) writes:
>Try using the DBase command "PACK". Deleting a record only results in the
>record being marked as deleted, but it isn't physically deleted until
>"PACK"ed.

I have tried that but the file size still remains the same.

This is what I did:

before record deletion :
slhist.dbf      2546900 byte.
# of records: 10500 records

--------------------------------
delete 10000 records
pack

--------------------------------
After deletion:
slhist.dbf      2546900 byte. <<<  how come the size is the same as before ?
# of records: 500 records.


My original question was how to gain back the memory disk space ?


Thank you for your help.


--
Kent
khioe@juno.jp.nasa.gov

Newsgroups: comp.databases
From: br326@cleveland.Freenet.Edu (Raphael Pungin)
Subject: FOXTRIS - Tetris clone for FoxPro!
Reply-To: br326@cleveland.Freenet.Edu (Raphael Pungin)
Organization: Case Western Reserve University, Cleveland, OH (USA)
Date: Fri, 14 Aug 92 13:35:14 GMT


Hi Everybody!
  Tired of Fox's puzzle to take breaks from database programming?
Well, now you can enjoy a Tetris clone for FoxPro - FOXTRIS!
Written entirely in FoxPro language, it runs just as regular .APP.
 
  You may get FOXTRIS.ZIP at WUARCHIVE.WUSTL.EDU in /pub/MSDOS_UPLOADS.
 
ENJOY!
 
Raphael Pungin - the author
iby247@uriacc.uri.edu
pungin@cs.uri.edu
br326@cleveland.freenet.edu
From: millia@athena.cs.uga.edu (David W. Millians)
Newsgroups: comp.databases
Subject: Re: Foxpro2 Book
Date: 13 Aug 92 06:03:44 GMT
Organization: University of Georgia, Athens

>In article <BsMu6K.2xJ@acsu.buffalo.edu>, v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes...
>>		I've been working hard these last few weeks to learn
>>	the new way of developing apps under Foxpro 2.0.  (It seems
>>	wierd to me).  Im having some difficulty catching on, can some-one
>>	recommend a book that could provide me with a more thorough tutorial
>>	than the one provided in the system docs.  (Its too lacking for 
>>	thick-heads like me :) )
>>	 Ami

Well, having bought them all, I think the best one is the PC Magazine
-- 
normally, mild-mannered David W. (Stimpy) Millians, millia@athena.cs.uga.edu 
but now, "Yes, dear"-Man. Able to fix sinks, move boxes and write thank you
Newsgroups: comp.databases
From: kalagher@mwunix.mitre.org (Dick Kalagher)
Subject: Distributed vs. Centralized Database
Organization: The MITRE Corporation
Date: Wed, 12 Aug 1992 19:07:13 GMT


Organization: The MITRE Corporation

I have a question related to response time of a centralized vs. a 
distributed database.  Suppose I have a database made up of one record 
type that is fairly simple, consisting of 20 or so data elements.  Suppose 
there are X records, where X is a large number, lets say 10*6.  Suppose
I am concerned about the response time.  If I had all records stored in 
one database on a single computer, would the response time be better than having the database distributed among 10-20 computers on a wide area network.  Assume that network traffic is not a problem and that I am using a modern relational database such as Oracle 
7.  I may also have thousands of users accessing the database.

Any help, either theoretical or operational would be appreciated.

Dick Kalagher


Newsgroups: comp.databases
From: monte@fwi.uva.nl (Michiel Monte (I83))
Subject: Teradata
Summary: Who has hands on experience with the Teradata database machine
Keywords: Teradata database machine
Organization: FWI, University of Amsterdam
Date: Fri, 14 Aug 1992 11:29:00 GMT

I would like to have contact with anyone who has experience with
the Teradata DBC/1012 database computer. Our problem is that in
the Netherlands not one machine has been sold. I hope you
out there won't let me down!
Thanks.
Michel Monte
University of Amsterdam
monte@gene.uva.nl

Newsgroups: comp.databases
From: jms@wzlr.uucp (Jack Stephens)
Subject: what is Decision Support ??
Organization: Amalgamated Widgets
Date: Mon, 17 Aug 92 04:18:11 GMT

Well, the question is actually not quite *that* broad, perhaps a more
appropriate version would be "What is decision support to you ?" or
"How is/will decision support be used in your organization ?"

In particular, I am interested in:

-- data volumes, sources and refresh/stability metrics 

-- typical DS machine configurations (size, isolation, workload)

-- query mix and composition (aggregations, joins, bulk retreivals)

-- perceived DBMS stress points in DS (utilities, SQL, tuning)

-- anticipated growth or modification over the next 6, 12, 18 months

-- usage patterns of DS utilities or their output (who, why, how, how often)


Thank you for any and all input. I will post a summary if there is
any interest.

jms
-- 
===========================================================================
Jack Stephens          Summer in California and the TR6 is running...
jms@wzlr                           who has time to dream up a cute quote ?

Newsgroups: comp.databases
From: eric@desktalk.com (Eric Lieber)
Subject: Help with Sybase Gateways to Oracle and Informix
Reply-To: eric@desktalk.com
Organization: Desktalk Systems Inc.
Date: Thu, 13 Aug 1992 16:41:24 GMT

I have Open Client 2.0, and SQL Server 4.8 running on a Sun ,( SunOS 4.1.1/4.1.2).

I would like to use the Gateways to access an Oracle database and an Informix database
in a C program.

The  gateways curently supplied by Sybase ( SQL Solutions) does not
function properly with this configuration. (it is compatible with Open Server 1.0)

The  "rpctest" RPC does not function for either Gateway, but the
"oraexec" and the "ifxexec" RPC do function.

Is there anyone out there who has experience with these Gateways who can give me
advice, pointers, etc..

Thanx

Eric Lieber
DeskTalk Systems	STD Disclaimer
Torrance, CA
eric@desktalk.com
(310) 323 5998 ext 124



Xref: sparky comp.databases:6148 de.comp.databases:76
From: mi@starlab.UUCP (Michael Hoennig)
Newsgroups: comp.databases,de.comp.databases
Subject: C interface to AS/400 SQL wanted
Keywords: C;SQL;AS/400;interface;Client-Server
Date: 17 Aug 92 08:03:07 GMT
Followup-To: poster
Organization: Star Division GmbH, D-W-2000 Hamburg, Germany

Hi NetWorld,

I'm looking for a C interface running with MS-Windows to connect through
a Novell network (Netware 3.11) to an AS/400 SQL server.

Has someone any experiance in this topic?

Please reply by mail (followup to poster), my site don't gets this
newsgroups. I will post a summary.

Thanks

-- 
Michael Hoennig                                  FAX:   +49 40 23 646 550
StarDivision GmbH                                Phone: +49 40 23 646 500
Sachsenfeld 4                                    uucp: ...!unido!starlab!mi
D-W-2000 Hamburg 1                               domain: mi@starlab.uucp
Newsgroups: comp.databases
From: viking@iastate.edu (Dan Sorenson)
Subject: Re: Text base
Organization: Iowa State University, Ames IA
Date: Tue, 18 Aug 1992 22:39:38 GMT

rmc@davidge.com (Robert Cianchette) writes:

>In article <1992Aug17.005434.1@lure.latrobe.edu.au> socwk@lure.latrobe.edu.au writes:
>>I wonder if anyone can help me? 
>>
>>I'm looking for a text based data base management system to use on a PC 
>>that will allow me to enter or translate text in a file of unlimited size. 
>>I've looked at a few DBs but none quite fit the bill.  I've heard that Reflex
>>might be an option but I need something that has structured fields with
>>unlimited text entry.

>Check out askSam. It has an editor and can import ASCII files.  It also
>allows for a variety of database record structures, including free-text and
>structured.  It can handle any size file.

	The original question didn't go into specifics, but he might also
wish to check out FoxPro.  The memo fields can handle text or binary data,
and can be of unlimited size.  The built-in or an external editor can be
used to edit them, and there are even spellcheckers and similar 3rd party
programs available for manipulation and retrieval of memo contents.

	I suspect Dbase IV has similar capabilities, but I'm not sure of
how these two products compare on this level.

<Dan Sorenson, DoD #1066 |"There'll be angels on Ariels in leather>
<z1dan@exnet.iastate.edu | and chrome, Ridin' down from heaven    >
<viking@iastate.edu      | just to carry me home." -- R. Thompson >
< ISU thinks I need more education, which they provide for a fee. >
Newsgroups: comp.databases
From: prastogi@netcom.com (PARAG RASTOGI )
Subject: GUI front-end on PC for SYBASE client ?
Date: Tue, 18 Aug 92 01:12:04 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Keywords: SYBASE, GUI


Hello there
I am interested in knowing what GUI front-end development tools are there
in the market which provide object-oriented framework. We want to develop on PCs an
application-client to talk to the SYBASE server on SunSparc server. 

Is there any class-libraries written in C++ that provide neat handling of 
object-oriented GUI front-end and also have hooks linked to talk to the
SYBASE dblib. 

I would appreciate any replies and will post a summary if sufficient interest.
is there in the group. 


Parag Rastogi
SPRINT , Inc
916-636-7379 

-- 
Oh, when I was in love with you,
	Then I was clean and brave,
And miles around the wonder grew
	How well did I behave.

And now the fancy passes by,
	And nothing will remain,
And miles around they'll say that I
	Am quite myself again.
		-- A. E. Housman
-----------------------------------------------------------------------
#include <std_disclaimers.h>
From:prastogi@netcom.com
-----------------------------------------------------------------------
Newsgroups: comp.databases
From: dlcogswe@vela.acs.oakland.edu (Dan Cogswell)
Subject: DOS DBMS with VMS SQL-server support??
Organization: Oakland University, Rochester MI.
Date: Sat, 15 Aug 1992 21:01:07 GMT

Hi folks,

I'd appreciate some feedback about a project I'm looking into.  We have
a VAX/VMS system running Rdb/SQL and need to write some database
applications that track engineering changes.  I'd prefer that we used a
DOS-based DBMS that could make calls to our SQL-server on the Vax,
keeping data stored on the Vax.  Some factoids:

1)  We're running Pathworks for VMS and the Vax is relatively busy as it
is.  We have mostly 386 systems on the network, so distribution of work
is preferable.

2)  We're allowed to replace Rdb/SQL with some other server.

3)  Distribution of developped code should cost us little to nothing.
It would be nearly impossible to license by user.

It seems that Paradox 4.0 will do what we need on the DOS side.  I'm
afraid it will be slow since it can't be compiled a la Clipper.  But, it
doesn't seem that Clipper can do the SQL-server stuff.  So, some
recommendations for both DOS and VMS software to help us accomplish this
would be greatly appreciated.  If someone can comment on performance
with Paradox or just the package in general, that would be marvy too.

Thanks...

-- 
Dan Cogswell

Newsgroups: comp.databases
From: jlewis@indyvax.iupui.edu
Subject: DBFNDX w/Clipper 5.01
Organization: Indiana University
Date: Thu, 20 Aug 1992 15:52:26 GMT

When using the DBFNDX driver for Clipper 5.01, I get a message to the screen
stating the buffer size for the indexs i.e. (disk io 512).

How do I get rid o

Any help would be appreciated....

Thanks..  Jeff
 
this message when the application starts (w/o having to
clear the screen).

Newsgroups: comp.databases
From: viking@iastate.edu (Dan Sorenson)
Subject: Re: Foxpro2 Book
Organization: Iowa State University, Ames IA
Date: Thu, 13 Aug 1992 20:07:35 GMT

v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes...
>		I've been working hard these last few weeks to learn
>	the new way of developing apps under Foxpro 2.0.  (It seems
>	wierd to me).  Im having some difficulty catching on, can some-one
>	recommend a book that could provide me with a more thorough tutorial
>	than the one provided in the system docs.  (Its too lacking for 
>	thick-heads like me :) )

	I have found that a great learning tool was the purchase of the
book "Exploring Foxpro" by Martin Fox, ISBN 0-9626660-3-3.  It comes
with a companion disk, and is basically a motherlode of code snippets
that are ripe for incorporating into your programs or dissecting to see
just how they work.  If you just use the menu functions, this is a great
way to see how easy it is to program in the xBase language.

<Dan Sorenson, DoD #1066 |"There'll be angels on Ariels in leather>
<z1dan@exnet.iastate.edu | and chrome, Ridin' down from heaven    >
<viking@iastate.edu      | just to carry me home." -- R. Thompson >
< ISU thinks I need more education, which they provide for a fee. >



Newsgroups: comp.databases
From: pburry@manitou.cse.dnd.ca (Paul Burry)
Subject: SYBASE: stored procedures and permissions
Organization: Canadian System Security Centre
Date: Fri, 14 Aug 92 01:27:28 GMT


I am having a problem with stored procedures and permissions.  I am using
SYBASE 4.8 under SunOS 4.1.1.

If as the dbo I define

	create proc a as return 
	go
	create proc b as exec a
	go
	grant execute on b to public
	go

then when as myself I try to use 'b', I get an error stating that I do not
have execute permission on 'a'.

Now, according to the documentation permissions are only checked when object
ownership changes.  This means that when I execute 'b', Sybase will verify
that I have EXECUTE permission on 'b'.  Since it was granted to the group
public, I am permitted to execute 'b'.  But, why does Sybase check my 
permission to execute 'a'; the dbo owns both 'a', and 'b'.  

Any help or explanation would be appreeeciated.
-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Paul Burry			
Voice: (613)-991-7325		Internet: pburry@cse.dnd.ca
Fax:   (613)-991-7323		UUCP:	  ..!{uunet,cunews}!cse.dnd.ca!pburry
Newsgroups: comp.databases