HDTenEightyP/NetNews huggingface dataset:
From: lamboo@ce.philips.nl (Vic Lamboo)
Subject: Sybase problem
Organization: Philips Consumer Electronics, Eindhoven
Date: Thu, 30 Jul 1992 12:32:40 GMT

Hello,

Basically, we have a european system with a Sybase server and
                   an american system with a Sybase server.
These two DB need to contain the same data.

Updating them both at the same time is not allowable because the no updates
can be done if one system is down or if the connection is down.

So I have to write a 'Store and Forward' procedure.  Sybase will make a
'replication server' which can handle this but this will only be
in production by the end of december which is too late for us.

I don't feel like reinventing the weel, so how can I solve problems like this:
- connection is down
- In both DB an object X is created
- connection is up again
- I try to forward object X to the other DB but there is is rejected because
  it already exists.
What are the possibilities then?
Any references to articles or other literature will be greatly appreciated.
Algorithms also.

Thanx in advance,

Marc Van Daele
Lernout and Hauspie Speech Products
vdaele@ieper.lhs.be
From: sms@cocamrd.mel.cocam.oz.au (Steve Szalla)
Newsgroups: comp.databases
Subject: SQL processor for ISAM databases
Summary: Looking for PD or commerically available SQL processor
Keywords: SQL,ISAM
Date: 23 Jul 92 23:45:43 GMT
Organization: Co-Cam Computer Group, Oz

Does anyone know if there is a PD or commercially available SQL
processor for ISAM databases? What I am looking for is either source
code that we can convert to access our proprietry ISAM databases, or
something that uses a standard ISAM interface such as X/Open.
-- 
 /~~` /~~\   /~~` /|  /|  /|   Steve Szalla    sms@cocamrd.mel.cocam.oz.au
|    |    |-|    /-| / | / |   Co-Cam Computer Group   Tel: +61 3 286 3456
 \__, \__/   \_ /  |/  |/  |   Melbourne, Australia    Fax: +61 3 417 7857
From: atieu@skat.usc.edu (Anthony Tieu)
Newsgroups: comp.databases
Subject: Foxpro 2.0 memo file deleted
Date: 29 Jul 1992 18:04:09 -0700
Organization: University of Southern California, Los Angeles, CA
Distribution: world
NNTP-Posting-Host: skat.usc.edu

How can I recover a dbf file after the memo file is deleted. The
dbf file will not open?

-thanks
Anthony


-- 
University of Southern California
e-mail : atieu@skat.usc.edu	fax (213) 747-2973
From: magarell@dimacs.rutgers.edu (Christopher Magarelli)
Newsgroups: comp.databases
Subject: Upgrading Paradox
Date: 22 Jul 92 21:44:34 GMT
Organization: Rutgers Univ., New Brunswick, N.J.


     Could somebody tell me what, if any, conversion of files is
necessary when upgrading from Paradox 3.01a to 3.5?     I'd appreciate
any help.

          Chris Magarelli
Xref: sparky comp.databases:5790 comp.databases.informix:1612 comp.databases.ingres:1002 comp.databases.oracle:1139 comp.databases.theory:289
Newsgroups: comp.databases,comp.databases.informix,comp.databases.ingres,comp.databases.oracle,comp.databases.theory
Subject: Re: RPT/DCL com file
From: hopper@ucunix.san.uc.edu (FreeBird)
Date: Sat, 25 Jul 92 19:43:15 GMT
Distribution: usa
Organization: University of Cincinnati

   when creating a table how do you specify the primary key?

  please respond to ks534405@ucbeh.san.uc.edu ASAP, please.


-- 
*********************************************************************
*  David Ian Hopper  * hopper@ucunix.san.uc.edu * o/~ FreeBird! o/~ *
* Found on Quartz BBS, FantasyMUSE, MicroMUSE, and Quartz Paradise  *
*********************************************************************
Newsgroups: comp.databases
From: amah@nyx.cs.du.edu (Anthony Mah)
Subject: Alpha Four
Organization: Nyx, Public Access Unix @ U. of Denver Math/CS dept.
Date: Thu, 23 Jul 92 08:31:27 GMT


Hi, everyone!
Sorry if this is an FAQ, but...
My employer recently received a postcard offering to sell him the Alpha Four
database program and Lotus Magellan (sp?) for approx. 100 dollars.
He is a bit sceptical about this offer since Alpha Four retails for about
500 dollars.  I was wondering if anyone has any experience with Alpha Four.
What is it like?  Is it worth the price?  What do you think of it?

Any comments are appreciated.  Thanx in advance...
From: gonzalod@amex-trs.com (Gonzalo Diethelm)
Newsgroups: comp.databases
Subject: DBMS libraries for MS-Windows
Date: 31 Jul 92 01:34:07 GMT



Distribution: world

Hello everyone,

I'm looking for information on database libraries with the following
requirements:

1. Must be callable from C++ and C.
2. Must support the relational model; this implies that it must provide
   some relatively automatic tools to enforce relational integrity
   (like triggers).
3. Must support multiple users.
4. Must support transaction management.
5. Must support a data dictionary OR provide the tools necessary to
   create it.
6. Must run under MS-DOS/Windows.
7. Public domain or shareware preferred (8^), commercial products are
   OK as long as they don't move into the four-digit price tag...

I would really like to find a package with all these characteristics and
with a price that is not tied to the number of users that will be using the
database manager. In other words, something like CodeBase which, to
my knowledge, complies to 1, 3, 5 and 6 and is priced about $300.
My guess is that anything based on the Client-Server model will be
priced according to the number of clients, though. Any comments on
why I should or should not choose to use a Client-Server based
DBMS?

Any takers? If there is a FAQ or a better place to post this, I would
appreciate any pointers. I prefer e-mail answers; if I get enough
response (say more that 5 messages), I'll post a summary. Thanks in
advance and best regards.

gonzalod@amexphx.amex-trs.com
Gonzalo A. Diethelm                 (602)375-8410  home
16220 N 7th St Ap 1314              (602)492-3536  office
Phoenix, AZ 85022                   (602)492-4248  FAX
Newsgroups: comp.databases
From: jka@windshear.larc.nasa.gov (J. Keith Alston)
Subject: DBASE 3+ .ndx to Clipper 5.01 .ntx
Organization: NASA Langley Research Center, Hampton, VA  USA
Date: Thu, 30 Jul 1992 16:32:03 GMT

 Hi,
   I'm looking for a program that will convert dbase 3+(.ndx) index files to
Clipper 5.01 .ntx index files. Any help with this would be greatly appreciated.
Thank You.
-- 
************************      Don't just do it!     ***********************
Lockheed Eng. and Sci. Co./Nasa Larc|J. Keith Alston jka@windshear.larc.nasa.gov
Newsgroups: comp.databases
From: steven@dev.state.COM.AU (Steven Sweeting)
Subject: Sybase db-library 4.6 `feature'
Summary: dbrpcparam data not used until dbrpcsend, potential corruption
Keywords: sybase db-library dbrpcparam
Organization: Group Treasury, State Bank of NSW
Date: 24 Jul 92 07:06:15 GMT

This is currently undocumented, so to save someone else debugging...

The dbrpcparam() call in Sybase Open Client library version 4.6 (on
SPARC) operates differently to the previous version 4.0. dbrpcparam
accepts a parameter `value', which is a pointer to the value you want
to send as a parameter. In 4.6, this pointer is not dereferenced until
dbrpcsend() is called. You must thus guarantee that the data does not
change. (or rather that the data is valid at the time of dbrpcsend()).

Other than that things check out ok, the new registered stored procedures
for asynchronous callbacks look pretty powerful.
--
-----------------8<-------------------8<-------------------8<----------------
Steven Sweeting, Treasury Systems,                    steven@dev.state.com.au
State Bank of New South Wales, Grosvenor Place             ph. +61 2 259-4144
L40 225 George St, Sydney, NSW 2000, Australia            fax. +61 2 251-8009
Xref: sparky comp.databases:5760 comp.databases.informix:1592 comp.databases.ingres:982 comp.databases.oracle:1111 comp.databases.theory:287
From: salnick@dejavu.spk.wa.us (There is no substitute for displacement...)
Newsgroups: comp.databases,comp.databases.informix,comp.databases.ingres,comp.databases.oracle,comp.databases.theory
Subject: Re: RPT/DCL com file
Date: 23 Jul 92 05:49:57 GMT
Distribution: usa
Organization: Not Organized

In article <1992Jul21.195448.7486@stortek.com> v045100@otis1.stortek.com (Jennifer Farnham) writes:
>Thanks to everyone who helped out on the
>RPT/RPF question that I had.  Now I have
>one more question and it probably shouldn't
>be posted here but since there are some very
>talented people out there who know VAX DCL,
>i thought i would pose it:
>
>In a DCL Com file, how do you turn off all
>output to the screen so that the user can not
>see what's taking place within the com file.

Try this:

$ define sys$output NL0:  (or maybe its NLA0:)

--
Bob Salnick, Spokane,WA |  Home: salnick@dejavu.spk.wa.us
  Amiga 1000, WB 1.3    |  Work: mfgsys!salnick@kaiser.spk.wa.us
      WA9BVE            |
From: ajross@husc9.harvard.edu (Andrew Ross)
Newsgroups: comp.databases
Subject: PARADOX 3.5:  Multiple Links of One Table
Date: 21 Jul 92 20:43:54 GMT
Article-I.D.: husc9.ajross.711751434

O.K., I'm stumped.  I have a database form I've created using several more
or less identical fields (a list) which I want to link to another table
(To look up weights & other info for the items on the list). 

Paradox doesn't like this.  It wants to allow only one link to the table. 
I.E., I can get it to look up the weight for the Item1 field fine, but
when I try to insert another link, It balks, saying "Table already linked"
or somesuch.

I can find no mention of why this is so in the manuals.  Does anyone know
a solution?  (I have the academic edition, so PAL workarounds won't work,
I'm afraid)

Thanks in advance,
Andy Ross
ajross@husc.harvard.edu
Newsgroups: comp.databases,comp.databases.theory
From: marc@sei.cmu.edu (Marc Graham)
Subject: VLDB Agenda?
Organization: The Software Engineering Institute
Date: Wed, 22 Jul 1992 14:49:22 GMT


Does anyone have an electronic copy of the VLDB Agenda
(Vancouver,23-27 Aug) they could either post here or mail to me? I
have a paper "Call for Attendance" but it doesn't have paper titles,
times, etc. Thanks.

Marc H. Graham                    Software Engineering Institute
marc@sei.cmu.edu                  Carnegie Mellon University
(412) 268 7784                    Pittsburgh, PA   15213
                   


Marc H. Graham                    Software Engineering Institute
marc@sei.cmu.edu                  Carnegie Mellon University
(412) 268 7784                    Pittsburgh, PA   15213
From: DEVRIES@NAUVAX.UCC.NAU.EDU (Ernie DeVries)
Newsgroups: comp.databases
Subject: Re: Upgrading Paradox
Date: 24 Jul 92 16:33:00 GMT

The file format of Paradox 3.x is the same for all versions.  No conversion
is necessary for moving from 3.01 to 3.5.  There were some incompatibilities
for 3.01 scripts moving to 3.5, but not for tables.
+========================================================+
|     /\                   Ernie DeVries                 |
|    /  \/\      Academic/Personal Computer Services     |
| /\/    \ \/\       DeVries@nauvax.ucc.nau.edu          |
|   Northern Arizona University   "The Mountain Campus"  |
+========================================================+
From: brianv@amiganet.chi.il.us (Brian Vargyas)
Newsgroups: comp.databases
Subject: Postgres
Date: 24 Jul 92 06:23:41 GMT
Organization: Amiga Network Information Systems

I have been looking into the postgres from Berkeley.  Does anyone know if
Version 4 support System Vr4? I have Version 3 and there is no support for
SVr4.  If not, do you know of any public domain database packages that run
under SVr4?

Please reply by E-Mail, I don't get a chance to read this group often.  Thanks!
Xref: sparky comp.databases:5788 comp.databases.oracle:1138 comp.benchmarks:1190
From: ab@dcs.ed.ac.uk (Albert Burger)
Newsgroups: comp.databases,comp.databases.oracle,comp.benchmarks
Subject: TPC-B benchmark source code for Oracle 6.2/Meiko system
Date: 25 Jul 92 16:49:57 GMT
Reply-To: ab@dcs.ed.ac.uk (Albert Burger)
Organization: Department of Computer Science, University of Edinburgh

Hello there,

As preperation for some other work I would like to run a TPC-B benchmark
in an Oracle 6.2/Meiko computing environment. Is there public domain
source code available for this? Or did anybody write their own software
and would be willing to send me a copy?

Cheers,
Albert
+----------------------------------------------------------------------------+
|   Albert Burger, University of Edinburgh, Department of Computer Science   |
|    JCMB #1410, The King's Bldgs., Mayfield Road, Edinburgh EH9 3JZ, UK     |
|  Phone: +44 (31) 650-5165, Fax: +44 (31) 667-7209, Email: ab@dcs.ed.ac.uk  |
+----------------------------------------------------------------------------+
Newsgroups: comp.databases
From: MARK.CHILENSKAS@OFFICE.WANG.COM ("Mark Chilenskas")
Subject: Re:  Transaction Roll-Forward...
Reply-To: Chilenskas@Office.wang.com
Organization: PACE Database Group
Date: 21 Jul 92 09:02:26 EST

CCA in Cambridge Massachusetts were doing research on a similar line about 10
years ago.  Basically, the contract was figuring out how one could merge
transactions after a network partition rather than blocking some or all of
the sites on the network.  Two approaches were examined, one looking at the
semantics of individual transactions and one looking at the semantics of
changed data items.  Logs were merged individually at each site, and
transactions run where discrepencies were found.

In general, you cannot simply roll forward the journal from separate sites
and expect a useful database.  The problem is that the cumulative effect of
transactions will violate integrity constraints that would have rejected
some of them had they all been run serialized at a central site.  You ship
more product than you have inventory, end up with negative bank balances,
etc.  Within each application domain there seem to be generally accepted
practices for dealing with such constraint violations, like charging the
extra $20 for the overdraft, but they are application domain specific.

I know of no general commercial application of this type of technique.
However, a New York and a London bank (sorry, i don't remember which ones)
were interested in the work and may have incorporated some of the ideas in
their automated teller systems.  Also, the WWMCCS inventory application used
the data item semantics. I think logitics  writing notes on the blackboard
so capabilities understood that some bases were currently over booked was one
type of compensating transaction used there.

For more information, i would look for papers by Hector Garcia Molina and
/ or Susan Davidson for the data oriented approach, Barbara Blaustein and /or
Dale Skeen for the transaction semantics approach, and Charles Kauffman for
retrospectives on the experiment.  They would tend to be 1982 to 1987.

R Mark Chilenskas
Chilenskas@Office.wang.com
Newsgroups: comp.databases
From: schli@cs.tu-berlin.de (Wolfram Schlickenrieder)
Subject: Clipper/MEMO Question
Organization: Technical University of Berlin, Germany
Distribution: comp
Date: Mon, 27 Jul 1992 13:24:22 GMT


	
	Hi there...

	I (yet again) have a problem with the *.DBT files (those files
	where the content of all the MEMO fields of a DB is held).
	Problem is the following:

	I have a database with two fields in each record: An index
	field for identification purposes, and a memo field with about
	10000 to 25000 Bytes in it.  I expect to have about 100 to 200
	records in it.  Now when I change the contents of a memo field
	it seems like the old contents are not removed from the DBT
	file, and thus, the DBT file gets *enormously* huge: With 20
	records in it and exactly 10000 bytes in each memo field the
	DBT file's size is now about 7MB (7,000,000 bytes)!  Is this
	supposed to be like it is, or am I doing something wrong? Or
	-- even better -- am I missing anything, something like
	"memo-file-pack ()"?!?

	Any help is greatly apprechiated...

	...Wolfram
Newsgroups: comp.databases
From: zenner@dfki.uni-sb.de (Frank Zenner)
Newsgroups: comp.databases
Subject: GUPTA SQLBase. Need contact.
Keywords: Who is using it ?
Date: 22 Jul 92 19:54:22 GMT
Organization: DFKI - German Research Center for AI


I am using the Gupta SQL-Base server under Windows in a single user version.
I use the SQL-Windows (Version 3.0) front-end.
I yet developed a large and nice standard application frame which needs only
few changes to serve the very most demands.
If you are interested in exchanging experiences, please send me a mail.

Thanks Frank.
From: Tony Lezard <tony@mantis.co.uk>
Newsgroups: comp.databases
Subject: Re: Very strange Clipper effect...
Summary: RTFM
Date: Wed, 15 Jul 92 11:15:59 BST
Distribution: world
Organization: Mantis Consultants, Cambridge. UK.

schli@cs.tu-berlin.de (Wolfram Schlickenrieder) writes:

> [why does this:]
>        cls
>        name := SPACE (10)
>        @ 10, 10 get name
>        setcolor ("w/w")    <- This is the line producing a white box
>                               in the first line of the screen 
>        ? "name = " + name
>
> [produce a blob on line 0?]

For a start, a READ statement somewhere is recommended.

Anyway, to cure your problem, put a SET SCOREBOARD OFF statement
somewhere at the top of your program. When the scoreboard is ON, well,
I'll just quote what Norton Guides says:

#  SET SCOREBOARD controls whether or not messages from READ and
#  MEMOEDIT() display on line zero.  When SCOREBOARD is ON, READ displays
#  messages for RANGE errors, invalid dates, and insert status.
#  MEMOEDIT() displays an abort query message and the insert status.

It's the Insert Status that you're seeing. Either "Ins" if in insert
mode or "   " if in overstrike mode. You were seeing three spaces in
the current colours - white on white.

--
 Tony Lezard IS tony@mantis.co.uk OR tony%mantis.co.uk@uknet.ac.uk
  OR EVEN arl10@phx.cam.ac.uk if all else fails.
   Mantis Consultants Ltd. Cambridge, UK. Try our "Jobstream" product today!
    Anyone know of a place to stay in Phoenix Arizona this September?

Newsgroups: comp.databases
From: tthieman@redbrick.com (Todd Thiemann)
Subject: Interbase
Followup-To: tthieman@redbrick.com
Summary: Want to hear from users about Interbase performance
Keywords: interbase
Organization: Red Brick Systems, Los Gatos, CA
Date: Thu, 23 Jul 1992 18:44:53 GMT



Greetings,

I'm trying to learn how Interbase (from Borland) performs in
the real world and would like to hear from any users about their
experiences with Interbase.  I am particularly interested in the following
areas:
	-large table ability
	-query performance 
	-tool support (what tools - good, bad, ugly?)
	-any general comments or experiences

I will gladly compile the responses and post them to the
net.  

Todd

-- 

-----------------------------------------------------
| Todd Thiemann               tthieman@redbrick.com |
| Red Brick Systems                                 |
-----------------------------------------------------
From: hcliff@wybbs.mi.org (Cliff Helsel)
Newsgroups: comp.databases
Subject: Re: FoxPro, printer not ready error trap
Keywords: help, trap, error, printer
Date: 24 Jul 92 12:52:46 GMT
Reply-To: hcliff@wybbs.UUCP (Cliff Helsel)
Organization: Consultants Connection, Jenison MI

I recently ran into this same exact problem on an HPII.  If you do go the
route of trying to trap for the error I hope you have better luck than I
did.  Whenever I would be put into the error routine and I would try to
retry the command all of the output went to the screen instead of the
printer.

I eventually solved the problem by writing all of my output to a file and
then calling a routine that sent the file to the printer.  By doing this I
was able to implement a dialog bar that indicated printing status and also
have greater control over how much data was going to the printer.

Make sure that you use "MODE LPT1:,,p" for infinite retry on the printer.

Good luck.

Cliff Helsel
hcliff@wybbs.mi.org
or hcliff@wybbs.UUCP

-- 
hcliff@wybbs.UUCP | I'm still thinking of something to put
WK: 616/459-5861  |           inside of this
Cliff Helsel      |             empty box
----------------------------------------------------------
From: robert@CAM.ORG (Robert Masse)
Newsgroups: comp.databases
Subject: FoxPro and Foxbase
Date: 21 Jul 92 18:32:00 GMT
Organization: Communications Accessibles Montreal, QC CANADA

Hello, I need some help:

  Can I compile my Foxbase v2.00 program and run it on a FoxPro v2.00 copy?

Ie: Compile a database program under foxbase 2.0 and give it to someone who
has Foxpro.

  Does this work?  Or would I need to buy a development kit for FoxPro 2.0?

Rob
Newsgroups: comp.databases
From: westes@netcom.com (Will Estes)
Subject: Can A FoxPro App Contain An Editor?
Date: Thu, 30 Jul 92 03:28:51 GMT
Organization: Mail Group

I'm trying to determine if an existing application written in C could be
easily re-written as a FoxPro application.

The part of the application that is in question is an editor and
form-letter generator.  Essentially, the application contains a list of
form letters.  If the user selects one of these letters, he is brought
into an editor, and he is able to edit the text of the letter as well as
insert and delete fields of the database within the letter.

Can the above be handled elegantly within a FoxPro application?  Would
it require interfacing to a C program for the editor/mail-merge
functions?

Thanks,
Will Estes         Internet: westes@netcom.com
Newsgroups: comp.databases
From: gribble@bronze.ucs.indiana.edu (steve gribble)
Subject: Re: ABF/4GL Help 
Organization: Indiana University
Date: Wed, 29 Jul 92 13:18:55 GMT

In <1992Jul28.185544.17880@emr1.emr.ca> kasvand@ccrs.emr.ca (Tony Kasvand) writes:


>   Hi, 
>        I have a small problem with the ABF/4GL (Ingres 6.4) language.

>  In the 'where' clause of a callframe statement, I would like to simulate
>the 'field' condition.

> Example - 
> 
>  look_for = 'Joe';     /*  varchar(10) */ 
>  whclause = 'fixer';   /*  varchar(15) */ 
> callframe by_fixed_second(by_fixed_second.programs =
>                        select distinct key_b = unique_bug#,
>                                type_p = product_type,
>                                prior = priority,
>                                cond = condition,
>                                name_p  =  product_name,
>                                usrnm = username,
>                                fix = fixer,
>                                d_of_bug = date_of_bug,
>                                name_sys = system_name,
>                                des =details1
>                                from bug_reports_table
>                /* ****** -->*/ where :whclause = :look_for
>                                order by prior );

>      I am assuming from this code, this is what it should look like:
>			 where 'fixer' = 'Joe'

>**->
>   What I really want is:  where fixer = 'Joe'

>                             

Yes, make the whclause varchar(25) and concatenate the fields together.
e.g  whclause = 'fixer= ' + '''' + 'Joe' + '''';
     ...
     where :whclause

i've done this many times, i must admit the quadruple quotes aren't
very intuitive or clean ... 'fixer= ' + '''Joe''';
should work, too, but i haven't tried it that way.


hope this helps,
steve
A
A
steve
Newsgroups: comp.databases
From: iverson@mobius.nas.nasa.gov (Ruth A. Iverson)
Subject:  PD SQL interpreter/pre-compiler
Keywords: SQL
Organization: Numerical Aerodynamic Simulation Facility NASA
Date: Wed, 29 Jul 92 00:16:05 GMT
Reply-To: iverson@mobius.nas.nasa.gov (Ruth A. Iverson)

I have heard that there is a public domain SQL interpreter and an
accompanying SQL pre-compiler available somewhere out there.  Supposedly this
interpreter has hooks for most database and database-like products,
including Btree.  If anyone has any information about either of
these pieces of software and/or where I can get hold of them, please send
me email or post a reply to this newsgroup.

Thanks in advance!

   -- Ruth Iverson
      iverson@nas.nasa.gov


Newsgroups: comp.databases