HDTenEightyP/NetNews huggingface dataset:
From: chibuike@info.umd.edu (Chibuike O. Nwaeze)
Newsgroups: comp.databases
Subject: NEED HELP WITH DBASE4
Date: 23 Jul 92 21:18:18 GMT
Organization: University of Maryland, College Park


 I need help creating a relational database.  I have 3 databases 
 subtype.dbf type.dbf and riotdata.dbf.  riotdata contains the fields 
subtype and type, which form the text field typename and subtypename.
what I need to do is relate these databses in such a way that the 
riotdata->type influences the field riotdata->subtype.  type.dbf and 
subtype.dbf contain the text data for riotdata->type and riotdata->
subtype.  

Here is part of my program so far

############################################################

use subtype in 2 order ixcode

select 1 		* which is the riotdata database
scan
	select 2
	ixcode = str(code) + str (subcode) * this does not work.
	seek ixcode
	replace riotdata->subtypenam with name 
	select 1
endscan

#####################################################

type.dbf
********

has the following fields

field 1: code   	field 2: name


subtype.dbf 
***********

has the following fields

field 1: code ( which is the same with type) 

field 2: subcode 

field 3: name 

riotdata.dbf
************

has 58 fields including 

field 1: code ( which is the same with type & subtype) 

field 2: subcode  (which is the same with subtype)


if any one understands this and can be of help to me please send me e-mail
at chibuike@info.umd.edu.



-C. Nwaeze
From: darrell@eeocdt.UUCP (Darrell Tschakert)
Newsgroups: comp.databases
Subject: Need info on AS3AP database benchmark.
Keywords: AS3AP benchmark
Date: 22 Jul 92 18:55:18 GMT
Organization: Equal Employment Opportunity Comm., Washington D.C.

Hi,
We are a small U.S. Gov agency running Unix on NCR Towers in about 200 
field offices accross the country. 
One of our data base developer staff came to me with the following questions.
They are as follows:

===========================================================================

I am looking for information on the AS3AP database benchmark as described 
in "The Benchmark Handbook for Database and Transaction Processing Systems"
edited by Jim Gray.  The information that I am interested in is:

Availability of a test dataset.
Availability of a test database generator.
Any experiences in running this benchmark.

===========================================================================
Can anyone help up?

If you would be so kind as to email replies to me at
		uunet!eeocdt!darrell
we would all be very appreciative.
Thanks in advance.

			Darrell


>> Darrell Tschakert			   >> Phone: 		   >>
>> Equal Employment Opportunity Commission >>    (202) 663-4436	   >>
>> 1801 L Street N.W.			   >> Email to		   >>
>> Washington D.C. 20507		   >> uunet!eeocdt!darrell >>
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Newsgroups: comp.databases
Subject: Re: clipper 5.01 and DOS 5.0
Date: 30 Jul 92 00:35:22 GMT
Organization: Genasys II, Sydney, Australia

In article <Bs3p0r.EL4@news.larc.nasa.gov> jka@windshear.larc.nasa.gov (J. Keith Alston) writes:
>Hi,
>   I have an application that I have compiled with clipper 5.01 under DR DOS
>6.0.  It compiles and runs fine under DR DOS 6.0 with the CLIPPER=F50 environment
>variable set. when I attempt to run this same program on another machine, running
>DOS 5.0 with the CLIPPER=F50 env variable set I get DOS error number 4, which
>is, I believe, a " not enough file handles" error. I have FILES=55 and
>buffers=30 on both machines. Also I've tried increasing the f50 and the FILES
>to higher numbers, without luck. Does anyone out there have even the slightest
>clue as to what might be the problem?
> 

Please try to increase a difference between SET CLIPPER and FILES variables.
Try to make it more than 5. (For instance, FILES = 60; SET CLIPPER=F50);
FILES should be more than CLIPPER. CLIPPER veriable should be more than
files your program open, because Clipper needs a couple of files for its 
own needs. This is just a quick answer, so if you fail please e-mail me 
directly your config, autoexec and mem /c > file results and we try 
to think about.

Here are my 0.02.
Michael
-- 
Michael Haldey  |  Genasys II Pty Ltd
                |  13th Level, 33 Berry St, North Sydney, NSW, Australia
                |  Phone:    +61-2-954-2878 (-9930 FAX)
                |  Internet: michaelh@g2syd.genasys.com.au
From: magarell@dimacs.rutgers.edu (Christopher Magarelli)
Newsgroups: comp.databases
Subject: Paradox "Multi Pack"
Date: 22 Jul 92 21:12:11 GMT
Organization: Rutgers Univ., New Brunswick, N.J.


     Is there anybody out there who knows anything about the Paradox
"Multi Pack"?  I have heard some references to it, but am not sure
what,exactly, it is and the university purchasing department is not
much help.  
     I'm pretty sure that it's not the same thing as the "Lan Pack",
which is ok.  Is it something like one set of manuals and 5 rights to
copy or what?
     I'd appreciate any information you might have.

          Chris Magarelli
Xref: sparky comp.databases:5734 comp.unix.aix:8035
From: bill@chaos.cs.umn.edu (Hari Seldon)
Newsgroups: comp.databases,comp.unix.aix
Subject: Re: ORACLE and IBM RS/6000 AIX version 3.2
Date: 21 Jul 92 21:55:31 GMT
Organization: University of Minnesota

In <19920716.044520.933@almaden.ibm.com> ALANB@OWGVM0.VNET.IBM.COM (Alan Beal) writes:

>In <22372@oasys.dt.navy.mil> Steve Carr writes:
>>7.  My questions to the universe are as follows.
>>    a.  Has anybody else found that AIX version 3.2 is
>>incompatible with ORACLE version 6.0.31.0.1 for AIX, as well as
>>ORACLE SQLFORMS & TOOLS version 3.0.16.32 for AIX?

>I have Oracle 6.0.31.0.1 running on AIX 3.2 and haven't had any problems.
and i have oracle 6.0.34.2.1 running on AIX 3.2 and haven't had any
problems .... yet :-)
also sqlplus 3.0.8.1.5, and currently sqlforms 2.3.31.1.5 although this
will change rsn.

>>    c.  Has a separate ORACLE newsgroup been established on the
>>internet?  Several months ago, a successful vote was tallied in
>>"comp.databases" for formation of an ORACLE newsgroup, but I
>>never saw formal announcement that it had commenced.

>comp.databases.oracle
yep.

>>    d.  When is ORACLE version 7.0 for IBM RS/6000 AIX due to be
>>shipped?

>I don't think it has been announced since 7.0 is in beta test, but
>it is likely to be shipped by the end of the year.
seems like a likely time.

>Alan Beal         alanb@owgvm0.vnet.ibm.com
bill pociengel
--
bill@chaos.cs.umn.edu
Newsgroups: comp.databases.informix
From: makke@bietel.uia.ac.be (Marc Gemis)
Subject: errno -522
Organization: U.I.A.
X-Newsreader: Tin 1.1 PL3
Date: Wed, 29 Jul 1992 14:17:04 GMT


--



--------------------------------------------------------------------------
Marc Gemis                                   Tel: + 32 (3) 820.24.18
University of Antwerp (UIA)                  Fax: + 32 (3) 820.22.44
Dept. Math. and Comp. Science                Telex 33.646
Universiteitsplein 1                         Email: gemis@bietel.uia.ac.be
B-2610 Wilrijk - Antwerpen
BELGIUM
                A dog is for life... not just for Christmas
--------------------------------------------------------------------------
From: carsmax!carshp.!ken@uunet.UU.NET (Ken Evilsizor)
Newsgroups: comp.databases.informix
Subject: Re: Way to get list of databases ?
Date: 30 Jul 92 13:53:13 GMT
Reply-To: carsmax!carshp.!ken@uunet.UU.NET (Ken Evilsizor)
X-Informix-List-ID: <list.1347>

Tony Heskett writes:
} Jeff White writes:
} 
} }   Does someone know of a way (easy or not, but needs to be executeable
} } from command line, not interactive) to return a list of all the available
} } databases?  
} 
} Well, someone does.   From Ken Evilsizor a little while ago:
} ...
} I get the feeling that this *hasn't* been posted, but that you'd get
} a fair way by playing with sqgetdbs().   Otherwise, mail him & grovel ;-)

I didn't ever post it since there was a copyright message at the top of the
page I had.  The information was posted in X-Informix-List-Id: <list.1287>
by Steven J. Richardson.  Here it is:

}   Recently, I referred to a function which tells one the names of the
} databases of which an Informix engine knows; that function is "sqgetdbs()"
} and its use is illustrated below.
} 
} #define MAXDBNAMES 64
} #define AREA_SIZE 128
} 
} main()
} {
}        int ndb, sqlcode, i;
}        char *fnames[MAXDBNAMES], area[AREA_SIZE];
} 
}        if (sqlcode = sqgetdbs(&ndb, fnames, MAXDBNAMES, area, AREA_SIZE))
}                printf("sqgetdbs() returned %d\n", sqlcode);
}        else
}        {
}                printf("%d databases\n", ndb);
}                for (i = 0; i < ndb; i++)
}                        printf("%s\n", fnames[i]);
}        }
}        exit(sqlcode);
} }
} 
} 
} Steven J. Richardson/Merit Network, Inc.

---------------------------------------------------------------------------
Ken Evilsizor 			Email: uunet!uceng!cinnet!carsinfo!ken
CARS Information Systems
4000 Executive Park Dr.		Disclaimer: All opinions expressed are
Cincinnati, OH 45241		    definitely my own.
Newsgroups: comp.databases.informix
From: carsmax!carsmax!bryan@uceng.uc.edu (Bryan Klopfenstein)
Newsgroups: comp.databases.informix
Subject: Re: Fractured Indicies
Date: 22 Jul 92 21:13:12 GMT
Article-I.D.: emory.9220
Reply-To: carsmax!carsmax!bryan@uceng.uc.edu (Bryan Klopfenstein)
X-Informix-List-ID: <list.1334>

Naomi Walker says:
> How can I tell how fractured an index has become?  I've been experimenting
> with tbcheck -pk, and tbcheck -pT, but cant convince myself of anything.

I am not sure what you mean by a "fractured" index. As I understand it,
the indexes are kept in order dynamically as rows are added or deleted.
However, the records will not be necessarily in a physical order which
follows the index. I'm proceeding under the assumption that you want the
physical order of the rows of a table to match an index on that table.

> If I tbunload/tbload an entire database, will indicies be rebuilt,
> and therefore, unfractured?  

I suspect that tbload will build the database back with the same order
to the rows as when they were tbunloaded, however, if a table has been
interleaved with other tables, that table may load back in into a 
contiguous space on the disk as long as there is a big enough contiguous
space available. This will not guarantee that the physical order will
match the index.

You can "alter index index-name to cluster". This WILL reorganize the data
so the physical order will follow this index. However, at the first update,
add, delete, this order will begin to be "fractured" again. Also, this
command may take quite a while on a large table, and will have to be run
on each index individually (only one index per table, or you will undo
what you did on the previous index on that table). See the Alter Index
command in the manual for further details about use and space requirements.
-- 
Bryan Klopfenstein			try: bryan@cinnet.com
CARS Information Systems, Inc.		or: ..uunet!uceng!cinnet!carsinfo!bryan
Cincinnati, OH				better: usr10300@tso.uc.edu
		Standard Disclaimers Apply
From: hpd@cbnewsk.cb.att.com (harold.p.debban)
Newsgroups: comp.databases.informix
Subject: Creating a MS-Windows DLL using esql/c for DOS
Keywords: Windows, DLL, esql/c
Date: 22 Jul 92 19:40:38 GMT
Distribution: na
Organization: AT&T

Note: this is my first posting to netnews.

I am attempting to use Informix esql/c for DOS, release 4.1 to write a
Microsoft Windows Dynamic Link Library to link Windows applications such as
WingZ, Microsoft Excel, or Visual Basic to my database using Informix-net.

I have started with a simple function which executes the $database
statement and returns sqlca.sqlcode. When I call the DLL from Visual Basic
without running remsql, I get error -854, which is as expected. When I run
remsql, load Windows, and call the DLL, I get a general protection fault in
ldllsqlw.dll.

I don't know if I am not allocating memory correctly, using the wrong compiler
command line, or what. Technical support has not been able to help so far.

Does anyone out there have any secrets to share? The Programmers Manual hints
that what I want to do is possible, but offers no clues on how to make it work.

Note: I have compiled and run the wdemo1.ec demo program included with esql/c
without any problem, but I need the flexibilty of a DLL so that I can
use a variety of Windows front ends.

My environment is 
Compiler:  Microsoft C 6.0
Operating environment: MS-DOS 5.0, MS Windows 3.1 in enhanced mode, QEMM v6.0
Network:   AT&T StarGroup


Compiler Command used
esql -wd demo.ec libentry.obj demo.def -o demo.dll

Source Code (demo.ec)

#include <windows.h>
$include sqlwproto.h;
$include sqlca;

/* Prototypes */
long FAR PASCAL start_db();


int FAR PASCAL LibMain(hModule, wDataSeg, cbHeapSize, lpszCmdLine)
HANDLE	hModule;
WORD    wDataSeg;
WORD    cbHeapSize;
LPSTR   lpszCmdLine;
{
    return 1;
}

/*****************************
   FUNCTION: long start_db()

   PURPOSE:  Open database.

   Returns:  sqlerror code.
******************************/

long FAR PASCAL start_db()

{
    /* Open database   */

   $ database stores2;

   return(sqlca.sqlcode);
}

VOID FAR PASCAL WEP (bSystemExit)
int  bSystemExit;
{
    return;
}

****************
Definition file (demo.def)
****************
LIBRARY   demo

EXETYPE   WINDOWS

CODE	  PRELOAD MOVABLE DISCARDABLE
DATA	  PRELOAD SINGLE

HEAPSIZE  10240

EXPORTS
    WEP			@1 RESIDENTNAME
    start_db		@2
From: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
Newsgroups: comp.databases.informix
Subject: Fractured Indicies
Date: 22 Jul 92 07:29:13 GMT
Reply-To: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
X-Informix-List-ID: <list.1332>


How can I tell how fractured an index has become?  I've been experimenting
with tbcheck -pk, and tbcheck -pT, but cant convince myself of anything.

If I tbunload/tbload an entire database, will indicies be rebuilt,
and therefore, unfractured?  

-- 
  Naomi Walker  (aka N7FSA)     naomi%anasaz.UUCP@asuvax.eas.asu.edu

  Enthusiasm is caught,         What if, there were no hypothetical
  not taught.                   situations.......
Newsgroups: comp.databases.informix
From: cauhape@twg.com (Jeff Cauhape x7147)
Subject: RE: A solution to SQL reformatting problem
Organization: The Wollongong Group, Palo Alto, CA
Date: Wed, 22 Jul 1992 16:38:57 GMT


Oops.

I thought stty was generic enough that this might be a general 
UNIX solution.  Sorry.

I'm running a terminal emulating package on a PC which is connected
over ethernet to a Sun 4/470 running Sun OS 4.1.1. Uname -a responds 
with:

    SunOS ra 4.1.1 4 sun4 

Sorry for the inconvience.  :|

Jeff Cauhape / cauhape@twg.com / The Wollongong Group, Inc.

#include <std_disclaimer.h>
From: billd@informix.com (William Daul)
Newsgroups: comp.databases.informix
Subject: 800 Support Lines Not Available - what to do
Date: 21 Jul 92 20:49:14 GMT
Organization: Informix Software, Inc.
Originator: billd@cheetah


PROBLEM:  800 Support Lines Not Available - what to do

US and Canadian Informix Users:

Over the past few weeks, we have been experiencing some problems with our 800# 
telephone service and we need your help.

Occasionally, you may get a busy signal when attempting to reach us at the 
toll-free Technical Support number, (800) 274-8184.                      

We are working on tracing and identifying this problem, but in the meantime, if 
you need to reach us:

1)  Try 800-274-8184.  If it does not work, call in on (415) 926-6794.
             
2)  Tell your Customer Services Rep that you have had a problem on the 800# and 
describe what happened.


Thank you!
Informix Customer Services






































-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
 William Daul             Advanced Support      INFORMIX SOFTWARE INC.
 4100 Bohannon Dr.        (415) 926-6488 - wk
 Menlo Park, CA. 94025    uunet!infmx!billd  or  billd@informix.com
From: walt@mathcs.emory.edu (Walt Hultgren {rmy})
Newsgroups: comp.databases.informix
Subject: Files from IWUC92 talk
Date: 28 Jul 92 14:30:35 GMT
Organization: Emory University

Several people at IWUC92 asked for copies of files related to the talk I
gave on a method of running Informix applications setuid.  This technique
allows a user to have multiple sets of permissions for the same login name
in the same database.

I have placed a shar of the files in /pub/informix/pub/appstart.shar in
the ftp archive on mathcs.emory.edu (IP 128.140.2.1) in case anyone else
is interested in looking at them.  I can e-mail you a copy if you don't
have access to ftp.

If you have files containing code, text, PostScript, etc., from IWUC92
that you'd like to place in the archive, drop me a note.

Thanks,

Walt.

-- 
Walt Hultgren             Internet: walt@mathcs.emory.edu   (IP 128.140.2.1)
Emory University              UUCP: {...,gatech,rutgers,uunet}!emory!walt
954 Gatewood Road, NE       BITNET: walt@EMORY
Atlanta, GA  30329  USA      Voice: +1 404 727 0648
From: snorri@strengur.is (Snorri Bergmann)
Newsgroups: comp.databases.informix
Subject: ESQL/C and error msgs
Date: 22 Jul 92 09:43:13 GMT
Reply-To: snorri@strengur.is (Snorri Bergmann)
X-Informix-List-ID: <list.1333>

Hi y'all!

Is there function in esql/c to get the SQL error message if you have the
sql error code? (Similar to ERR_GET function in 4gl).
Thanks in advance,
--
Snorri Bergmann                    | Internet: snorri@strengur.is
Strengur Consulting Engineers      | Bang:     ...!uunet!strengur.is!snorri
Storhofdi 15                       | Phone:    +354 1 685130
112 Reykjavik Iceland              | Telefax:  +354 1 680628
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: Online 5.0
Date: 25 Jul 92 01:31:48 GMT
Organization: Enterprise Technology Center, Informix Software, Inc.

In article <9221@emory.mathcs.emory.edu> baskett@hermes1.sps.mot.com (Bob Baskett) writes:
>
>I am interested in any bugs/problems anyone is having with OnLine version
>5.0.  We are running 5.00.UC2 on a sun 690MP and have come across a few
>quirks;
>
>1. select a.rowid, b.rowid
>   from   table1 a, table2 b
>   where  a.col1 = b.col1
>
>   this returns some interesting values - namely, if you dont have an
>   index on the join columns for both tables it returns the max rowids
>   from both tables for each line.  add an index to table1, you will
>   get the correct rowids for table1 and the max rowid from table2.

Sounds like known bug 13029, 5.0 regression, fixed in 5.00.UE1 / 5.01.

>2. tbcheck -pe appears to be limited to 14 chunks. we currently have
>   21 chunks.

No record of this ever being reported.

>There are more. Let me know if you come across any.
>Bob Baskett
>Motorola, Inc.
>baskett@hermes1.sps.mot.com


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

"They've taken Bill Clinton back into the 'smoke-filled room', and this
 time they're making him inhale!"
      -- LNWDL 1992 Democratic Convention correspondent Larry 'Bud' Melman
Newsgroups: comp.databases.informix
From: aastrand@nyx.cs.du.edu (andrew astrand)
Subject: informix/unix/486 question
Organization: Nyx, Public Access Unix @ U. of Denver Math/CS dept.
Date: Fri, 31 Jul 92 18:51:55 GMT










hello, The company I work are just moving into 4Gl's and for several
reasons we have decided to plump for Informix. Now the first project
that we are to work on is a system for around 20 Users, running
on a 50Mhz 486, SCO System 4 Unix box. We shall be running Informix
Online. Given that of these users maybe 4 or 5 will be doing a 
moderately high volume of data entry, and maybe one or two others will
be doing moderately complex queries
How fast can we expect the machine to run?
we of course need to size the system before we give our final
recommendations to the company we are writing for. And unfortunately
the Informix people are VERY cagey about suggesting any performance
type figures.

Is our suggested system sensible (running with a big fast hard disk)
any opinions will be greatly appreciated. Please Email them to me
as I have trouble keeping up with all the net traffic.

Andy
From: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  dbschema and documenting tables/columns
Date: 24 Jul 92 09:29:12 GMT
Reply-To: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
X-Informix-List-ID: <list.1337>

>From: uunet!col.hp.com!judym (Judy Miller)
>Subject: dbschema and documenting tables/columns
>Date: 23 Jul 92 16:49:57 GMT
>X-Informix-List-Id: <news.1574>
>
>I need suggestions for documenting an Informix database I support.  It
>has been modified greatly since it was first created.  I used the dbschema
>utility to create a fresh schema.  The problem is the original sql files
>contained lots of valuable documentation.
>
>Is Informix self-documenting (meaning you can add descriptions somewhere
>in the database), or can someone suggest a method where I can make it
>self-documenting?  (or I'll invent my own...)
>
>I'd like the descriptive info to be part of the database, not a separate
>file that must be maintained.

DB2 has a comments column in its equivalent of Systables and Syscolumns,
which can be used to store the extra information -- Informix does not.
This means that if you are going to keep the comments in the database, you
will either have to play with the system catalogue (and you'll be all on
your own when everything falls into a heap around your feet -- it would NOT
be supported), or you provide your own data dictionary tables, or you buy a
third party data dictionary system (there must be some out there, but I
don't have anything in mind).

If you decide to write your own data dictionary, bear in mind that tables
can be altered, and that Systables.Tabid usually changes when you alter a
table.  This makes it unsuitable for use as the primary key of your data
dictionary table description table.  You will probably end up defining your
own equivalent of Tabid, with table name as an alternative key, and the
actual tabid as a foreign key.  Similarly, columns can be moved around in
the table, so the Colno attribute is not necessarily as useful as it could
be.  And both table names and column names can be altered.  The point I'm
making is that the system catalogue can change without your data dictionary
being aware of the change, and if your dictionary is too closely tied in to
the key structures in the system catalogue, you will get erroneous
information out of your data dictionary after the database is changed.

Which version of Informix are you using?  If you are using Version 5.00,
you can declare PRIMARY KEYs, FOREIGN KEYs and CHECK constraints.  These
are often part of the information which would exist as comments, but they
can be documented in the database explicitly, which is a step in the right
direction.  It does not allow you to document the purpose of a table or
column, though, so you still need some data dictionary support.

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: bob@worms-emh2.army.mil (Bob Kane)
Newsgroups: comp.databases.informix
Subject: Re:  SCROLL statement help
Date: 24 Jul 92 09:58:08 GMT
Reply-To: bob@worms-emh2.army.mil (Bob Kane)
X-Informix-List-ID: <list.1339>

Ian,

You cannot use SCROLL with DISPLAY ARRAY, because it does not change the
array pointer that DISPLAY ARRAY is using.  As soon as you hit another key,
like an arrow key, the screen will go back to the original position that
DISPLAY ARRAY was using.  I have a set of routines that will do what you
are trying to do, that use Dave Snider's fgl_getkey stuff.  I do not use
DISPLAY ARRAY, so you have complete control over the array positioning.
I have such things as a GOTO record function, and a FIND bad record 
function.  Let me know if you want a copy.

-----------------------------------------------------------------------------
Bob Kane                   Internet: bob@worms-emh2.army.mil (IP 134.235.9.2)
TechDyn Systems               Voice: (049) 6241-75936   (WORMS, GERMANY)
CMR 421, BOX 706                Fax: (049) 6241-74530
APO AE 09056                    CIS: 71054,2661