HDTenEightyP/NetNews huggingface dataset:
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: SQL 2.10.03 problem:  cannot UPDATE table
Date: 15 Dec 92 03:27:44 GMT
Organization: Enterprise Technology Center, Informix Software, Inc.

In article <Dec.10.18.05.40.1992.25678@net.bio.net> charleen@net.bio.net (Charleen Bunjiovianna) writes:
|A user wants to delete a row from a table.  The query:
|
|delete from ft
|where entry_name = "P90589";
|
|dies with:
|
|  263: Could not lock row for UPDATE.
|
|There is no possibility the table or row is being used by anyone
|else.  A number of other rows have been deleted from the same table
|without incident.  We've tried emptying the lock file.  No luck.
|
|Just for kicks, I created a new table, ft_new (using ft's dbschema output)
|and got this when I tried to fill it:
|
|insert into ft_new
|select * from ft;
|
|  534: Could not insert new row into the table, table is locked.
|
|  107: C-ISAM error:  record is locked.
|
|(BTW, the manual says to "see C-ISAM error", but there's no explanation
| of C-ISAM error messages.  Do we need to buy a C-ISAM manual?)
|
|I can select * from ft with no problem.
|
|Now it gets fun.  I run bcheck by doing a CHECK TABLE: (bcheck -n)
|
|BCHECK  C-ISAM B-tree Checker version 1.07
|Copyright (C) 1981-1988 Informix Software, Inc.
|Software Serial Number RDS#R537699

MAJOR red flag.  1.07 is terribly old -- I'd guess that you have some old
product based on an old version of C-ISAM (e.g. MF COBOL, among others)
that has you running the wrong bcheck for 2.10.03 databases.  That
bcheck could be corrupting your indexes.  Try that first.  Otherwise,
specify your platform details in your next post.

|Charleen

--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

"What does not kill me, makes me stronger."     - Nietzsche
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: INF4.1 -1 ERROR ?? problem
Date: 23 Dec 92 16:14:21 GMT
Organization: Informix Software, Inc.

Rigby writes:
>
>HELP !!!
>We have just started getting a new error which is described nowhere
>in the INFORMIX literature (whats new): -1. This happens when we
>install our package on UNIX . In one of our package-installation-scripts
>we start tbinit and straight afterwards try a drop database in a 4GL 
>program. This gives us an error -1.
>
>Any ideas ?? Is it something to do with tbinit not being quite 
>finished ?

Any error code less that 100 are Unix errors that are propagated back to
the user.  The reason they are undocumented in Informix literature is that
they are not necessarily the same across different platforms, so we would
have to have the definitions for each platform we support, which could
wind up being a lot of dead trees ;-0.

Generally, a -1 error means "Not owner." Is the 4gl program executable by
the id running the install (presumably root)? Do the permissions on the
database allow this user to access it (actually, this user would need
dba permission to drop the database)?

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
From: pp@q8.dk (Poul Pedersen)
Newsgroups: comp.databases.informix
Subject: Re.:Nice kill of tbtape -c
Date: 31 Dec 1992 05:53:05 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: pp@q8.dk (Poul Pedersen)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1747>

        Nice kill of tbtape -c
        ----------------------
        Thanks for all the answers. I think it is working now.
        This is my result:
                I will execute tbtape -c with a trap on signal 2.
                The output will be piped to a program, which will
                print label an unmount the tape device. This program
                will trap sinal 1 and 2.

                With this it will not be possible to stop the tbtape
                command (break) from the terminal.
                If the terminal is turned off tbtape -c will
                continue and stop (signal 1).
                The program tbtape will pipe to, will run and
                finish nicely. It is not stopped by signal 1.

        Thanks:
        -----------------------------------------------------------------
        Databaseadministrator Poul Pedersen
        Kuwait Petroleum (Denmark) A/S
        Hummeltoftevej 49                         Mail:   pp@q8.dk
        2830  Virum                               Voice:  +45 45 98 45 94
        Denmark                                   Fax:    +45 42 85 14 18
        -----------------------------------------------------------------
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: Display array highlist
Date: 28 Dec 92 21:14:33 GMT
Organization: Informix Software, Inc.

shemminga@cix.compulink.co.uk (Stuart Hemming) writes:

>In-Reply-To: <1992Dec21.175031.11266@informix.com> cortesi@informix.com (David Cortesi)

>I think a better way would be to arrange to have the report generated
>to a file with the programmer responsible for line and page length.
>Then Informix need only provide a file viewer in a window. The logic
>for this could (should?) be very simple.

>If this idea where implemented along with the dynamic report
>definitions (variables for output target, line and page length) then
>reports could be set up in apps to print on 60 line paper pages, in full
>screen and windowed views.

>How does that grab you?

The latter (ability to use variables in the OUTPUT section) is
generally accepted as a Good Idea, I think.  As to the file viewer
window, why do you want Informix to reinvent the browser
that exists on every platform already (and probably do it wrong :)
when you could just, for example, RUN "less /tmp/report.01"

Or under a GUI,
	RUN "/usr/openwin/bin/textedit /tmp/report.01" WITHOUT WAITING
You could even pass -Geometry arguments...  that should impress the troops...
From: rblack@netcon.smc.edu (Russ Black)
Subject: DB4 - .MDX & PopUp Menus
Organization: Santa Monica College, Santa Monica, CA
Distribution: usa
Date: Tue, 22 Dec 1992 18:40:47 GMT

   I have been using DB4 v1.5 for a while.  I like it and it hasn't given me
any trouble.  But, until recently, I haven't started using all of the new stuff
that DB4 offers.  Two of the neat features I just got into have been the .MDX &
PopUp Menus.

   According to the books, .MDX are call production index that do what the .NDX
files do but in a different way.  Under the old DB3, I had to write a few .NDX
files along with the .DBF to keep the indexs updated.  Using .MDX all I need is
one index and everthing else gets updated.  I appears that it also runs faster.
I have a 286 12 Mhz system at seems to work quite well and fast.

   As for the PopUp menus, up to a point, I did what all the books said and all
of the print outs showed.  But, nothing worked.  So, I just ran the applicationsgenterator and it wrote out a program that worked.  From their, I just modified
it to my needs and it works.

   Now, for what its worth, this information for those who have DB4 but still 
like to work with DB3 codes.  Or, am I the only one.  Just because v1.0 was a
piece of *@!&, v1.1 & v1.5 have solved this problem, and it is a nice program
to work with.

   From what I hear, a Windows version is going to be shiped to programmers.
A Windows 2.0 version for the rest of use is being worked on.

Well so much for my mental thoughts.


Russ Black
rblack@netcon.smc.edu



Newsgroups: comp.databases
From: g9utxu@fnma.COM (Tanin Uthayanaka)
Subject: Re: Pls help: algorithm wanted (xbase, pref foxpro)
Reply-To: g9utxu@fnma.COM
Organization: Fannie Mae
Date: Thu, 31 Dec 1992 15:44:49 GMT

I don't know how you converted the Clipper program to be Foxpro compatible but even 
with the bugs the program should have generated results using the following:

RATE.DBF        Record  RATE    START_DATE      END_DATE        STATUS
                1       15000   07/01/91        06/30/92        Covered
                2       20000   07/01/92        06/30/93        Covered

dStart = 01/01/92
dEnd   = 12/31/93

RESULTS: 01/01/92 - 06/30/92 Uncovered
         07/01/92 - 06/30/93 Covered
         07/01/93 - 12/31/93 Uncovered


So just for fun I fixed the program to generate the following:

RESULTS: 01/01/92 - 06/30/92 Covered
         07/01/92 - 06/30/93 Covered
         07/01/93 - 12/31/93 Uncovered

**NOTE: The program did not assume that between 01/01/92 and 06/30/93 the statuses are 
        both "Covered" because one record could have been "Provisional"

The program is listed below

CLEAR
dStart:=dEnd:=CTOD("  /  /  ")
@ 3,5 SAY "Starting Date: " GET dStart PICTURE "99/99/99"
@ 4,5 SAY "  Ending Date: " GET dEnd PICTURE "99/99/99"
READ

@ 10,10 SAY "Subcontract Period: "+DTOC(dStart)+" - "+DTOC(dEnd)
@ 11,0  SAY ""
USE RATE
INDEX ON START_DATE TO START
SET SOFTSEEK ON
SEEK dStart
IF ! EOF()
   SKIP -1
   IF RATE->END_DATE >= dStart
      @ ROW()+1,15 SAY DTOC(dStart)+" - "+DTOC(RATE->END_DATE)
      @ ROW(),  40 SAY RATE->STATUS
   ENDIF
   SKIP +1
   DO WHILE RATE->START_DATE >= dStart
      IF RATE->END_DATE <= dEnd
         @ ROW()+1,15 SAY DTOC(RATE->START_DATE)+" - "+DTOC(RATE->END_DATE)
         @ ROW(),  40 SAY RATE->STATUS
      ELSE
         @ ROW()+1,15 SAY DTOC(RATE->END_DATE+1)+" - "+DTOC(dEnd)
         @ ROW(),  40 SAY "Uncovered"
         EXIT
      ENDIF
      SKIP +1
      IF EOF()
         SKIP -1
         @ ROW()+1,15 SAY DTOC(RATE->END_DATE+1)+" - "+DTOC(dEnd)
         @ ROW(),  40 SAY "Uncovered"
         EXIT
      ENDIF
   ENDDO
ELSE
   SKIP -1
   IF RATE->END_DATE >= dStart
      @ ROW()+1,15 SAY DTOC(dStart)+" - "+DTOC(RATE->END_DATE)
      @ ROW(),  40 SAY RATE->STATUS
      @ ROW()+1,15 SAY DTOC(RATE->END_DATE+1)+" - "+DTOC(dEnd)
      @ ROW(),  40 SAY "Uncovered"
   ELSE
      @ ROW()+1,15 SAY DTOC(dStart)+" - "+DTOC(dEnd)
      @ ROW(),  40 SAY "Uncovered"
   ENDIF
ENDIF
SET SOFTSEEK OFF
SET INDEX TO
USE




Newsgroups: comp.databases
From: tleylan@pegasus.com (Tom Leylan)
Subject: Re: Info hiding v/s data abstraction
Organization: Pegasus,  Honolulu
Date: Sun, 27 Dec 92 07:51:06 GMT

John_Carson@mindlink.bc.ca (John Carson) writes:
>> Yashesh Bhatia writes:

>> Could someone let me know if there are dufferences between these two terms
>> and if so what are the pro's and cons of using one for the other in the
>> world of databeses and s/w eng.
>
>Data abstraction and hiding data.
>
>1) Data abstraction is removing the database #1 and placing into database #2
>and based on a certain condition. Then manipulating it to your needs.
>
>2) Hiding data is like setting a filter so you only see what you want based
>on the filter condition.

John... Quick send a follow up message consisting of nothing more than a
grin symbol before somebody thinks you meant this <g>

Possibly you're describing "data extraction" and "database filtering" but
that isn't (in my reading) what the question was about.

Data abstraction and data hiding isn't even about "databases" particularly
but rather "data" in the sense of "what's under the hood".  Both are
fundamental principles of OOPs programming and I switch between the two
terms at will.

You want to be able to write something similar to :

 nVar = MyBox:width

and not be concerned whether "width" is a function which determines the
width of the box or simply an attribute of a box which is returned.

tom
From: steve.silverwood@filebank.cts.com (Steve Silverwood) 
Newsgroups: comp.databases
Subject: Clipper 5.01 DBF recovery
Date: 21 Dec 92 06:24:00 GMT
Distribution: world
Organization: The File Bank BBS - Fallbrook, CA  619-728-4318
Reply-To: steve.silverwood@filebank.cts.com (Steve Silverwood) 

 >From: wld@consum.moldova.su (Yakhnenko Vladimir L.)
 >Newsgroups: comp.databases
 >Subject: Clipper 5.01 DBF recovery problem
 >Message-ID: <ABaAOBh0x3@consum.moldova.su>
 >Date: 15 Dec 92 07:00:52 GMT
 >Reply-To: wld@consum.moldova.su
 >
 >
 >      Hi, there!
 >  Using Clipper applications corruption of database files sometimes appears.
 >Some variables of error object are: CanRetry=.F., CanDefault=.F.,
 >CanSubstitute=.F. .  My application perfoms copiing of backup file instead
 >corrupted and tryes to open again this area. Error of recovery in
 >DBUSEAREA(0) appears, i.e. restarting of application is necessary.
 >      Can anybody give more information about this trouble.
 >      Regards.
 >   ???????????????????????????????????????????????????????????
 >   ?     Vladimir Yakhnenko     ? VOICE: SU (0422) 24-41-32  ?
 >   ?   wld@consum.moldova.su    ?  FAX:  SU (0422) 24-41-32  ?
 >   ???????????????????????????????????????????????????????????
 >

Vladimir:

I presume this is with Clipper 5.something, right?  Which specific
version?  Also, under what circumstances is the problem occurring?
Are the results consistent?  All the details you can think of will be
helpful in figuring out the problem.

//Steve//

/----------------------------+---------------------------------------\
|Steve Silverwood            |  Internet: 76703.3035@compuserve.com  |
|Computer Associates         |CompuServe: 76703,3035                 |
|300 Corporate Point, 2nd Fl.|     Voice: (310)348-4448              |
|Culver City, CA  90230      |       FAX: (310)348-7701              |
+----------------------------+---------------------------------------+
|The opinions expressed here are solely my own, mainly because nobody|
|else would want them....                                            |
\--------------------------------------------------------------------/
From: steve.silverwood@filebank.cts.com (Steve Silverwood)
Newsgroups: comp.databases
Subject: <None>
Date: 29 Dec 92 12:02:00 GMT
Reply-To: steve.silverwood@filebank.cts.com (Steve Silverwood)
Organization: The File Bank BBS - Fallbrook, CA  619-728-4318


 > Newsgroups: comp.databases
 > From: ppaunio@cc.helsinki.fi
 > Subject: <None>
 > Message-ID: <1992Dec23.205824.1@cc.helsinki.fi>
 > Date: Wed, 23 Dec 1992 18:58:24 GMT
 >
 > I have recently bounced into problem of corrupted dBase IV files. They seem to
 > be quite normal but somewhere in the file fields are filled with garbage.
 > Rumour says that somewhere exists programs that are able to repare these kinds
 > of files.
 > Thanks in advance
 >
 > Pekka Paunio

Pekka: Yes, such files do exist. The best by far was "dBASE File
Recovery," distributed by Ashton-Tate. After Borland acquired the
company, they killed that program and several others. Now all that's
left is Paul Heiser's program, and a similar one built into Norton
Utilities. Fortunately, the author of A-T's program now works for
Symantec/Norton, so good things are no doubt in store.

//Steve//

---
 . SM 1.06 A0070 . When at a loss for words, try silence.
From: nathans@pacifier.rain.com (Nathan Silva)
Newsgroups: comp.databases
Subject: dBASE/Clipper file format
Summary: I need the dBASE file format
Keywords: dBASE Clipper
Date: 23 Dec 92 00:13:35 GMT
Article-I.D.: pacifier.1992Dec23.001335.5962
Organization: Pacifier BBS



I *know* this must be a FAQ, but I can't find the FAQ list.

Where can I obtain a technical description of the dBASE file and
index format?  Also, I could use a description of Clipper's
.NTX index format.

Please save bandwidth and reply by E-Mail.
-- 
 -----------------------------------------------------
| Nathan Silva               |                        |
| nathans@pacifier.rain.com  | Is my 486 a "Quadium"? |
 -----------------------------------------------------
Newsgroups: comp.databases
From: sle@world.std.com (steve l edwards)
Subject: DEC VAX/VMS RMS & MS ACCESS
Keywords: DEC VAX/VMS RMS & MS ACCESS
Organization: The World Public Access UNIX, Brookline, MA
Distribution: all
Date: Mon, 21 Dec 1992 07:43:18 GMT

I need to access DEC VAX/VMS RMS files in MS Access. I already have
written code that allows my PC C programs full FAB/RAB/XAB access to the
files on the VAX. I'm assuming that I will need to write some support code
and package the whole thing up as a DLL (along the same lines as the
Paradox and Btrieve DLL's).

Anybody know where I can get the information needed to perform such a feat
of magic?
Newsgroups: comp.databases
From: gdzimmer@phoenix.Princeton.EDU (Gary David Zimmer)
Subject: Help with Microsoft ACCESS, please
Followup-To: gdzimmer@phoenix.princeton.EDU
Originator: news@nimaster
Keywords: access, Microsoft, questions
Organization: Princeton University Class of 1993
Date: Thu, 24 Dec 1992 00:25:47 GMT


Questions about Microsoft ACCESS:

  1)  Is there any way to control the starting value of a counter? Or,
      alternatively, is there a handy macro that sets the value of a
      field one greater than the field in the previous record?

  2)  Is there a way to design a form/table such that there are multiple
      check boxes for a field and that more than one of these options
      can be checked off at the same time (ie. pre-defined medical
      ailments which a person can be suffering from)?

  3)  Is there any way to allow for the entry of a time field without
      the colon and still allow for the simple calculation of elapsed
      time between two fields?

Newsgroups: comp.databases,comp.databases.sybase,comp.databases.oracle
From: flog@open.ch (Florian Gutzwiller)
Subject: 500'000 records - who does best?
Reply-To: Florian.Gutzwiller@open.ch
Organization: Swiss Federal Institute of Technology (ETH), Zurich, CH
Date: Mon, 21 Dec 1992 18:29:48 GMT

If you'd have to realize a server client based database with Suns as servers  
and NeXT as clients. Single records would be an average of 30KB in size and  
there would be a number of 20 concurrent users. 

Would you choose Sybase or Oracle ?
Who has experience with similar solutions/environments ?

Thanks

-Florian

--
Florian Gutzwiller		Tel: +41 61 262 05 10, Fax: +41 61 262 05 10
Open Systems AG, Basel		flog@Open.CH
Switzerland			S=gutzwiller;O=open;P=EUnet=A=EUnet;C=CH
From: chris@yen.IMSI.COM (Chris Payne)
Newsgroups: comp.databases
Subject: Re: Any FAME users?
Date: 31 Dec 92 17:00:03 GMT
Distribution: comp
Organization: Moore Capital Management
In-reply-to: sethg@dcatlas.dot.gov's message of 30 Dec 92 14:26:10 GMT
Originator: chris@yen


   Anyone out there using FAME for time-series data management?  I'd be 
   interested in hearing about experiences with FAME -- either stand-alone
   or tied to other statistical or DBMS software.

We use FAME extensively.  It works fine.  What do you want to know?

Xref: sparky comp.databases:8674 comp.databases.oracle:2630 comp.databases.sybase:561
From: ddruker@agsm.ucla.edu (Daniel Druker)
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.sybase
Subject: Re: 500'000 records - who does best?
Date: 23 Dec 92 21:21:54 GMT
Organization: Anderson Graduate School of Management, UCLA

In article <1992Dec21.182948.16832@bernina.ethz.ch> Florian.Gutzwiller@open.ch writes:
>If you'd have to realize a server client based database with Suns as servers  
>and NeXT as clients. Single records would be an average of 30KB in size and  
>there would be a number of 20 concurrent users. 
>
>Would you choose Sybase or Oracle ?
>Who has experience with similar solutions/environments ?

I'd choose Oracle, hands down, based on backup and recovery issues. 500k recs
of 30kb each means you have a pretty large database. Figure in additional
space for indexes and sorting space and you might be talking 30 Gigabytes
or more. Sybase will have serious problems backing up a database of this
size. It will probably take DAYS to perform a backup, load, or restore. 
Oracle treats large databases much better, and includes lots of parallel
stuff which really helps on multi-processors. I expect query speeds will
be similar since you're really only gated by how fast the disk spins, 
and with a database of this size you probably wont want to allow many
(or ANY) full table scans, ad hoc stuff, etc..., especially on a sun
with a limited number of procs...

Oracle has a very large database group which they can put you in touch with
to get some practical experience of users with I think up to 100 or so gigs   
of data. 

Hope this helps, 

- Dan

Daniel Druker
Anderson Graduate School of Management at UCLA
                   

----------------------------------------------------------------------------
| Dan Druker                                                               |
| agsm mail 	: ddruker                                                  |
| internet 	: ddruker@agsm.ucla.edu                                    |
| oracle*mail	: unix:ddruker@agsm.ucla.edu                               |
----------------------------------------------------------------------------

Disclaimer:  None. I'm a student now and I don't care what you think.
From: chris@visionware.co.uk (Chris Davies)
Newsgroups: comp.databases
Subject: Re: PIONEER + InterBase
Date: 22 Dec 92 11:11:04 GMT
Organization: VisionWare Ltd., Leeds, UK
X-Newsreader: Tin 1.1 PL5

Nigel Campbell (nigelc@cognos.com) wrote:
: I am looking for an Inet address for someone at PIONEER
: SOFTWARE to discuss their pending InterBase support - 
: the same could be said of other companies planning
: an InterBase interface (or have one).

We're about to release a first beta cut of our InterBase ODBC driver.
Email me if you're interested...

Chris
--
            VISIONWARE LTD, 57 Cardigan Lane, LEEDS LS4 2LE, England
  Tel +44 532 788858 x238.  Fax +44 532 304676.  Email chris@visionware.co.uk
---------- "VisionWare:   The home of DOS/SQL/UNIX/X/VMS integration" ---------
From: cc920@cleveland.Freenet.Edu (Michael A. Rife)
Newsgroups: comp.databases
Subject: Re: Zip code data base wanted
Date: 30 Dec 1992 04:32:46 GMT
Organization: Case Western Reserve University, Cleveland, OH (USA)
Reply-To: cc920@cleveland.Freenet.Edu (Michael A. Rife)
NNTP-Posting-Host: hela.ins.cwru.edu


In a previous article, john@timer1.UUCP (john) says:

>Hi, Netter :
>
>Our company is looking for a postal zip code database. We are willing
>to pay for a resonable price for it. It will be better if we can
>get updated if any change is made.
>
>Any pointer will be appreciated.
>
>John Chan
>

Contact the postal service.  There were some rumblings on the net about a year
ago about this same subject.  I thought that the postal service sells the zip
codes.  Can anyone out there confirm this or not?

Xref: sparky comp.databases:8696 comp.os.msdos.apps:5939