HDTenEightyP/NetNews huggingface dataset:
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases.ingres
Subject: Re: Insert in ESQL/C
Date: 12 Nov 92 13:05:50 GMT
Organization: Not Organized

In article <1992Nov11.132503.8082@mlb.semi.harris.com> cbh@opus.mlb.semi.harris.com (Cherie Slasor) writes:

Do you have a commit statement???  If not, then the transaction never 
happens.

bob

>I was wondering if anyone could help me with a problem I'm having with
>ESQL using C.  I've used ESQL for a long time but had never tried doing
>an insert with it.  That's what I'm trying to do now and it isn't 
>inserting the data into the database.  The syntax I'm using is:
>
>EXEC SQL INSERT INTO table_name (
>			field_1,
>			field_2,
>			field_3
>		   )
>		   values (
>			:variable_1,
>			:variable_2,
>			:variable_3
>		   );
>
>I can't find anything in the manuals that gives the exact syntax for an
>insert in ESQL so I'm assuming it's the same as for SQL.  When I run the
>debugger I find that it's definitely connecting to the database, because
>it retrieves the correct data in all the right places.  The variables
>are all being defined correctly.  The program runs very happily and never
>crashes or gives an error message or anything.  The SQLCA error codes
>seem to say that everything worked:
>
>(dbx) p sqlca
>sqlca = {
>        sqlcaid = "SQLCA   "
>        sqlcabc = 136
>        sqlcode = 0
>        sqlerrm = {
>                sqlerrml = 0
>                sqlerrmc = "                                                                      "
>        }
>        sqlerrp = ""
>        sqlerrd = (0, 0, 1, 0, 0, 0)
>        sqlwarn = {
>                sqlwarn0 = ' '
>                sqlwarn1 = ' '
>                sqlwarn2 = ' '
>                sqlwarn3 = ' '
>                sqlwarn4 = ' '
>                sqlwarn5 = ' '
>                sqlwarn6 = ' '
>                sqlwarn7 = ' '
>        }
>        sqlext  = ""
>}
>
>But the data is not being added to the database.  Any ideas?
>
>Cherie Slasor
>			
>-- 
>====================================================================
>Cherie Slasor			     |	Harris Semiconductor
>Phone:    (407) 724-7607	     |	P.O. Box 883, MS #62B-022
>          cbh@mlb.semi.harris.com    |  Melbourne, FL   32902-0883

--
RW Salnick, Spokane,WA  |  Home: salnick@dejavu.spk.wa.us
  Amiga 1000, WB 1.3    |  Work: mfgsys!salnick@kaiser.spk.wa.us
      WA9BVE            |
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Sole server access (Q)
Organization: 
Date: Thu, 12 Nov 1992 20:26:00 GMT

In article <199211120718.AA25099@mulgulgum.asis.unimelb.EDU.AU>, Gavin Trigg
<gavin@asis.unimelb.EDU.AU> writes:
>>
>> I am running an ABF application under Ingres v6.3.
>> As part of that application I want to extra the audit trails using
>> auditdb. When I attempt to do so via a system call from within ABF
>> I get a DB BUSY - Being Access by a Sole Server
>> error message. This only occurs when auditdb is called while ABF
>> is also accessing the same database.
>>
>> Any suggestions on how to get auditdb to do its job from within ABF?
>>
>> Chris Keen				AARNet: C.D.Keen@cs.utas.edu.au
>> Dept of Computer Science		Phone:  002-202906    (Australian)
>> University of Tasmania			        +61-02-202906 (international)
>> GPO Box 252C, Hobart, Tasmania  7001    Fax:    +61-02-202913
>
> Auditdb does not do its work through the server.  Moreover, it can't operate
> on a database that is currently in use by a server configured as a Sole_server.
> Therefore, unless the Sole_Server option is removed from the server, auditdb
> cannot be run against databases currently in use in that server.  This applies
> if there is *ANY* use of the database through the server NOT JUST ABF.
> Presuming that application will eventually be run from a built image rather
> than through ABF you'll need to reconsider your configuration.  That is, it
> doesn't matter whether the database is being accessed through ABF or the
> built image or some other method!
>
> Gavin Trigg	Internet: gavin@asis.unimelb.EDU.AU
> 		Telephone: +61 3 344 6003 	Fax +61 3 347 4803
> Data Base Administrator, Information Technology Services (ASIS),
> The University of Melbourne, Parkville, Australia.  3052.

Funny, I tried this on our Sun and couldn't get the behavior that you
both docuument.  I didn't do exactly what you did, but I expected the
same results, given the principles.  We use INGRES 6.4/01 and SunOS
4.1.2, and the dbms server uses fast commit and sole server.

In essence, I followed these steps:

		% createdb my_db
		% ckpdb -l +j my_db	# Initialize journaling.
		% sql my_db
		create table t ( id i4 not null ) with journaling \go
		insert into t values ( 17 ) \go
		commit \go
		\quit
		% ckpdb -l my_db	# Make sure journaling is enabled
					# for the table.
		% sql my_db
		commit ; set autocommit off \go
		insert into t values ( 17 ) \go
		# An active transaction is now in progress.

From another login:

		% auditdb my_db

In general, auditdb did _not_ show recently committed transactions (and
shouldn't until the ACP kicks in--at a consistency point?), but
existence of a session with an active transaction in progress did _not_
prevent it from showing me older ones.

This is mysterious.  Maybe things were different in version 6.3...

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.
From: cathys@Ingres.COM (Cathy Savino)
Newsgroups: comp.databases.ingres
Subject: Re: Finding all tables and table definitions.
Keywords: SQL, Windows4gl, tables
Date: 5 Nov 92 21:18:23 GMT
Article-I.D.: pony.1992Nov5.211823.20922
Reply-To: cathys@ingres.com (Cathy Savino)
Organization: Ingres, an ASK company

In article <1992Nov4.222139.9932@news.nd.edu>, nariani@zen.cc.nd.edu (Sunil Nariani) writes:
|> Using sql monitor program, when I type 'help' it gives me
|> a listing of all tables in the database and on typing
|> 'help tablename' I can find out the fields of the table.
|> 
|> 
|> My question is how can I get this listing of which tables
|> exist in a database and their field definitions using a C program
|> with embedded sql or using Windows4gl ? 
|> 

Do a query against the system catalogs. They are documented in an appendix of the SQL 
Reference Manual.


--
Cathy Savino 
   ___     _____   __  __       Ingres, An ASK Company
  / _ \   / ____\  | |/ /       1080 Marina Village Parkway
 / /_\ \  \____ \  | |\ \       Alameda, Ca 94501
/_/   \_\ \_____/  |_| \_\      (510) 748-3524
                                cathys@ingres.com
Newsgroups: comp.databases.ingres
From: san@cs.brown.edu (Sergio Antonio Nakai)
Subject: ESQL to EQUEL filter
Organization: Brown Computer Science Dept.
Date: Mon, 9 Nov 1992 22:46:38 GMT

	We are looking for a filter that translates ESQL code to EQUEL.  Does such a
filter exist?  Any help will be greatly appreciated.
From: leilas@ems.cdc.com (Leila Schneberger)
Newsgroups: comp.databases
Subject: Setting all fields to same value - Paradox
Date: 5 Nov 92 01:14:49 GMT
X-Newsreader: Tin 1.1 PL5

For each record in a table, I want to set all ocurrences of a field
to some value (YearlyDues = "NotPaid"). How do I do this in Paradox?

Please e-mail replies.
Thanks!

--

 Leila Schneberger                 leilas@ems.cdc.com
From: rhaven@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Re: Paradox Help again!
Summary: Paradox calculated fields on forms
Date: 5 Nov 92 07:33:30 GMT
Article-I.D.: cruzio.4598
Reply-To: rhaven@cruzio.santa-cruz.ca.us

In article <s897336.720843298@minyos.xx.rmit.OZ.AU>, s897336@minyos.xx.rmit.oz.au (Lip Meng Soh) writes:
> Hi netter,
> I was wondering if Paradox can perform "calculation" on the data-entry field?
> That is if the user fills in the fields ( ie. qty and price per unit), can the
> field- amount (ie. qty * price per unit) be auto-generated ?
> 
> ***********
> Lip Meng, SOH 
> Email: s897336@rubicon.bf.rmit.oz.au
> ***********


Yes, Paradox forms can automatically generate calculated fields based on
other fields (or other, outside information as well).  The new 4.0
programming techniques make is easier to do selecting recalculations
as well (like total value in a field for all the detail records for this
master record).  This requires PAL programming, but most PAL programming
is taking the normal Paradox behavior and changing selected bits of it
to do exactly what you want.  You end up programming the exceptions
and leaving the rest to Paradox.

One note: these calculated fields on forms are display-only.  If you want
to have a real data entry field set to a default value based on other
field values, you would use the PAL programming method.

Cheers
From: amonge@cs.ucsd.edu (Alvaro Monge)
Newsgroups: comp.databases
Subject: Re: What is X/Open Distributed Transaction Processing
Date: 11 Nov 92 21:26:35 GMT
Organization: CSE Dept., U.C. San Diego


What is X/Open Distributed Transaction Processing?

It may be of some use to us here.
We are working on a distributed database project.
For our project we would like to have a centralized database
and have users at multiple sites make queries against this
database.

Later in the project we would like to have the database
distributed throughout the network and again have users
at multiple sites make queries.

Can this or any other tool help us in the project?

Al
amonge@cs.ucsd.edu
Newsgroups: comp.databases
From: tim@tim.src.utah.edu (Tim Ma)
Subject: Re: Paradox 4.0 speed (?)
Organization: University of Utah
Date: Fri, 6 Nov 1992 23:55:15 GMT


>>An inquiry to all users of Paradox 4.0 out there.  We recently upgraded to 
>>4.0 after reading articles and ads that highly touted the improved speed of
>>Paradox 4.0 (claims that it was much faster that FoxPro 2.0).   I am 
>>impressed with some of 4.0's new features, but SPEED is does not seem to be
>>one of them.  I have a simple script written in 3.5 that randomizes the order
>>of records in a file.  All it does it import that file as a single TEXT 
>>field, tacks on a random number in anothe field, sorts on the random number, 
>>and then outputs the randomized file.  To my surprise, it runs almost 50% 
>>slower in 4.0 thanit did in 3.5 (14 minutes vs. 10 minutes).  I'm running a
>>386SX with 4M of RAM.  Any ideas or comments?
>
>Wait now...  When you say you're doing a sort on the data, does this mean
>that you're performing a sort in PAL, or that you're incrementally updating
>the index?  If you're incrementally updating the index, do you really need
>to?  You could more than likely improve your performance by updating the index
>only when you're done with all your insertions.
>

I am doing a PAL "sort" command on this field.  I guess I could index the 
field then after I assign all the random numbers, update the index, 
but I wasn't doing that in 3.5 and it would seem surprising that 4.0 needed 
this little tweak to make it run faster (or even just as fast).

Thanks for the comments,

Tim Ma


Newsgroups: comp.databases
From: ashley@athena.cs.uga.edu (Greg Ashley)
Subject: Efficiency enhancement of Large DBMS?
Organization: University of Georgia, Athens
Distribution: usa
Date: Fri, 6 Nov 1992 14:42:19 GMT

We have been given the opportunity of revamping an existing data management
system that is written in FoxPro 2.0  It was designed to function with
relatively small databases (6,000 records), but it needs to now be able to
work with about 50,000 records and maybe more in the future.

The current system runs really slow with these numbers of records.  It is
run on a small Novell network (version 2.2(5)) that has a 386 server and
mostly 286 workstations.  New hardware is a viable option, but we will need
to make substantive changes to the database system to facilitate other
improvements besides increased speed.  However, our main task is to
greatly enhance system performance while allowing for future flexibility.  We
have been asked to leave as much of the code as possible in Foxpro.

The system is comprised of about 75 modules, 15 procedures, and 25
databases.  Most of the modules are relatively short (<200 lines of code). 
We have considered the following options: 1) leaving the bulk of the code in
FoxPro and writing especially slow sections in Pascal or C++, 2) rewriting
the entire system in C++ or pascal, and/or 3) new hardware (i.e. 486's).  We
would greatly appreciate any suggestions that would help us decide the best
option.  We would consider any options (but we have a time constraint of
about 3 months to finish this project and we only have about 30 hours/week
to devote to this).  Thank you in advance!

Greg Ashley

Please reply to gashley@agecon.conner.uga.edu or ashley@athena.cs.uga.edu


Newsgroups: comp.databases
From: xkmd@uxa.ecn.bgu.edu (Kim Butler)
Subject: Gopher database software
Organization: Educational Computing Network
Date: Wed, 11 Nov 1992 15:16:56 GMT

Is anyone familiar with gopher databases?  I'm looking for gopher
database software that can be installed and run under VM/CMS and
VM/ESA.  Any information as to where I can perhaps ftp gopher
database software and documentation would be greatly appreciated.
 
Thanks,
 
Kim Butler
xkmd@uxa.ecn.bgu.edu

Newsgroups: comp.databases,comp.databases.theory
From: ae2@cunixa.cc.columbia.edu (Amiran Eliashvili)
Subject: Correlated Queries
Reply-To: ae2@cunixa.cc.columbia.edu (Amiran Eliashvili)
Organization: Columbia University
Date: Thu, 5 Nov 1992 04:58:48 GMT


Hi all

I am new to RDBMS and I would like to understand the difference
between correlated queries and nested ones. When do I want to use
correlated queries? Hwat is it good for and can I do without it?

Please reply to ae2@cunixa.cc.columbia.edu
thanks
/amiran

Newsgroups: micro.dbms,comp.databases
From: dgm@ecsvax.uncecs.edu (Debby Morley)
Subject: dbase III+ vs. dbase IV
Followup-To: micro.dbms
Keywords: dbase
Organization: UNC Educational Computing Service
Date: Tue, 10 Nov 1992 13:41:48 GMT


I am curious as to why so many people have held onto and prefer dbase III+ to
the newer dbase IV.  Can someone please summarize the differences in these
two (DOS) products for me?

Newsgroups: comp.databases
From: M22367@mwvm.mitre.org
Subject: Re: Composing list of DBMSs w/features
Organization: The MITRE Corporation, McLean VA 22102
Date: Thu, 5 Nov 1992 18:31:50 GMT

The August 1, 1992 issue of Datamation has a 'Buyers Guide' of over 140 dbmses.
It does not attempt to rate the products, but it does list the features and
platforms supported.
 
It should answer all your questions.
 
- Mike Waters
From: ba844@cleveland.Freenet.Edu (Don Atkinson)
Newsgroups: comp.databases
Subject: ANYONE HAVE ANY EXPERIENCE WITH PROGRESS?
Date: 6 Nov 1992 14:49:59 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: slc10.ins.cwru.edu


Would appreciate comments from anyone who has experience or 
exposure with Progress.

-- 
Commander, these people are not emitting any life signs! - Data
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Newsgroups: comp.databases
Subject: Re: What would make a decent FP2.0 Workstation
Date: 10 Nov 92 20:57:08 GMT
Article-I.D.: nntpd2.1992Nov10.210316.23917
Organization: Colorado Software Solutions, Inc.


In article <BxFL5F.G94@acsu.buffalo.edu>, v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes...
>Hi all,
>	Any thoughts on what sort of hardware req's would be
>	necessary to run some fox app's via a Novell Lan
>	at a reasonably good speed.  The Current setup uses
>	Ethernet and twisted pair wiring.  Im looking more for
>	CPU, RAM, and Harddisk req's. 

The price/performance curve right now favors 386/33's.  I wouldn't go
with anything less than that.  That CPU will perform very nicely.
I'd use at least 4MB RAM so you can run Foxpro in Extended mode.  Go
to 8MB RAM if you have a lot of databases, or large ones.  But 4MB
is pretty good.  We still don't usually use local hard drives, because
most of our networks aren't close to bandwidth saturation.  Also, I
find it harder to manage a bunch of local hard drives than a bunch
of network directories (one per user).  For example, if you need to
delete .TMP files, clear out scratch databases, etc.  Also, if you
use a local drive for user-specific setup info, then when that user
uses a different machine, their setup doesn't come with them like it
does if you use network directories for that.

Having said all that, the conventional wisdom still points to a local
hard drive.  If you do, go with an 80MB IDE (40's cost barely less than
80's, even if you can still find 40's!).  I can't imagine using more
than 10 or 20MB of it for temporary files.

Randy
Newsgroups: comp.databases,comp.databases.sybase
From: mark@drd.com (Resident.Alien)
Subject: RFI: HOLOS and Holistics ...
Followup-To: poster
Reply-To: mark.lawrence@drd.com
Organization: DRD Corporation
Date: Fri, 6 Nov 1992 17:48:38 GMT

Has anybody heard of a VAX based, SQL compatible
system called HOLOS by a company called Holistics?
Supposably used to build EIS's.  I've never heard
of it.  I may be faced with trying to interface to
it from a UNIX-based Sybase application.  Yow.
-- 
mark.lawrence@drd.com                                     (918)743-3013
DRD Corp., 5506 South Lewis Ave., Tulsa, OK 74105         (918)745-9037 fax
From: ifenton@crc.ac.uk (I. Fenton)
Newsgroups: comp.databases
Subject: Re: Clipper 5.01 left over locks
Date: 8 Nov 92 17:03:25 GMT
Organization: MRC Human Genome Resource Centre

In article <paulb.721055967@cs.man.ac.uk> paulb@cs.man.ac.uk (Paul Bean) writes:
>I have a program which is to run on both a network and single user.  I
>use the locks.prg supplied with clipper to do the appropriate locking
>for me.  I have one version so I do the locking even if it is on a
>single user dos machine.  I was running it single user yesterday (Dos
>5.01 by the way) when it keeled over with not enough memory.  I
>removed a couple of drivers so that there was enough memory for it to
>run and went in again, however when the program came to open the dbfs
>that were exclusively locked when it went down it could not
>open them(in shared mode).  I presumed that the lock information was
>held in the dbfs so I deleted these and went to a backup.  However
>when I tried to run the program it still wouldn't let me open the
>previously locked files.  I tried moving everything to a new
>directory,still no joy.  I have tried ringing Computer Associates who
>could not suggest anything.  Does anyone know where the lock
>information is held ? and how I can get rid of it.  This is becoming a
>real pain.
>
>Thanks in advance Paul 

no, no, no !  teh locking information is held in the program code.  when
you leave the program and go back to dos all locking info is forgotten, 
until you re-run the exe.  are you absolutely 100% sure that it had got
past those locks the first time ?  i would bet vasts sums of money that
locking info is not remembered anywhere.  anyway, if there are incorrect
locks then it is a fault of the logic of the code.  sorry.  i write
network apps in clipper, btw, but not with 'locks.prg' as supplied, so
i dunno if that is making matters better or worse.  if it works on your
local net, copy the .exe file onto your home machine and try again.

btw, what is dos5.01 ?!  i thought dos was stuck at v5.0 ?!

good luck ...

=============================================================================
IAIN FENTON                             | All errors of spelling, grammar &
Institute of Medical Genetics           | fact are due to a missing <Del> key
University of Wales College of Medicine |====================================
Heath Park                              | "No man should marry until he has
Cardiff  CF4 4XN                        |  studied anatomy and dissected at
U.K.                                    |  least one woman" - de Balzac
=============================================================================
Voice = +44 - 222 - 744049   | In 1912, Jack Johnson, the first black world
Fax   = +44 - 222 - 747603   | heavyweight boxing champion, was refused
Email = fenton@uk.ac.cardiff | permission to board the Titanic because of
   (or) wmgif@uk.ac.cardiff  | his colour.
   (or) ifenton@uk.ac.crc    |
=============================================================================
Newsgroups: comp.databases
From: nkolluru@cs.umr.edu (THE DEADLY DEVIL)
Subject: PARADOX on the UNIX env??
Date: Fri, 6 Nov 1992 06:01:36 GMT
Organization: University of Missouri - Rolla
Originator: nkolluru@mcs213k.cs.umr.edu

Hello,

	I want to know whether PARADOX is available on the UNIX envir-
onment. I would appreciate it if someone could give me the address to
contact PARADOX.


Thank you.

Nookaiah V. Kolluru
.
From: colflgg@hubcap.clemson.edu (john f passafiume)
Newsgroups: comp.databases
Subject: Small Business Accounting
Keywords: accounting general ledger
Date: 12 Nov 92 21:19:06 GMT
Article-I.D.: hubcap.1992Nov12.211906.16421
Distribution: usa
Organization: Clemson University

I have a friend who has a small manufacturing business who is in need of some
help with accounting, especially accounts receivable, invoicing, accounts
payable, i.e., the usual stuff, as well as general ledger. I am not an
accountant, so I may not be using correct terminology. He currently has
an in-house system which he inherited when he purchased the business. The
system is written in dBASE III+, and provides all of the above, less the
general ledger, which is listed in the brief documentation, but is not
installed. He is currently at the mercy of developers of the system, and
every time he needs a simple fix, such as, listing of all orders by a certain
customer for a certain period of time, the developers will charge a
bundle for the code, and take their good time doing it. I have a limited
knowledge of dBASEIII, and could possibly fix the problem, but have had
trouble figuring out how the data files are organized and accessed by
the programs. Their are over 300 programs and about 200 files. The
company just recently starter using edi with one of their large customers
and had to pay another big bundle to the developers to get the code written
to support the loading of the edi input into the database (the input is
orders from the big customer). My friend wants to disengage from the 
developer and has asked my advice on how to go about doing this. He also
wonders if converting to dBASEIV will improve the time response of the
system which is now 5-10 minutes for some queries. Their current machine
is a 386 running at 25Mhz and he wonders if a 486 who provide significant
improvement. I feel that he ought to go to a commercial package, rather
that code a new systems in dBASEIV as the programming cost for this could
be quite high.
Does anyone know of any commercial packages that could do the job, which must
include general ledger, as well as edi capability.
From: mike@r-node.gts.org (Mike Stramba)
Newsgroups: comp.databases
Subject: Arev .. what have I been missing?
Date: 11 Nov 92 06:56:21 GMT
Organization: R-node Public Access UNIX Information System (416-249-5366)

Hello all Arev users.

I have version 1.1, haven't been using it that much, but want to start again.

I understand that 3.0 is the latest version?

I called Revelation today to find out about upgrading and to receive some
info on what version 3.0 has in it.

For any of you that have used 1.1 or anything less than 3.0 and are now using
3.0, I'd be interested in hearing what features have impressed you the most in
the new release.

Actually, I'd be interested in knowing what features have changed since 1.1,
in whatever newer versions anybody is using !
 
I'm particularly interested in what if any additions have been made in the
handling of dynamic arrays.

Mike

-- 
=====================================================================
Mike Stramba		Email: mike@r-node.gts.org
Toronto,Canada
=====================================================================