HDTenEightyP/NetNews huggingface dataset:
From: wong@sybase.com (J. Wong)
Newsgroups: comp.databases,comp.databases.ingres
Subject: Re: Ingres questions
Date: 18 Nov 92 06:16:41 GMT
Distribution: usa
Organization: Sybase, Inc.

In article <1992Nov11.180040.7771@dcatlas.dot.gov> sethg@dcatlas.dot.gov (Seth Grimes) writes:
>I don't know of any workaround other than vertically partitioning your tables.
>On the other hand, Ingres 6.5 to be released in the spring will support BLOBs
>and presumably remove the 2000-byte limit (based on Ingres's current page
>size of 2048 bytes) on general fields.

Wrong!  INGRES 6.5 will support BLOBs as columns, but will not remove the 2000
byte limit on tuple size.
From: djs@sys.uea.ac.uk (Dan Smith)
Newsgroups: comp.databases
Subject: Re: ER diagrammer
Date: 16 Nov 92 22:01:05 GMT
Organization: School of Info. Systems, UEA Norwich, UK

In article <1992Nov9.230408.2063@sierras.com>, dhubb@sierras.com (David B. Hubbell) writes:
> 
> Can anybody recommend a good package for creating Entity Relationship
> diagrams.  I need something that runs on a SparcStation or a PC.
> -- 
We've recently got a product called Modellator which might do what you want.
It runs on almost any PC and will produce DDL code for dBase, DataEase 
and various flavours of SQL; we use it with Ingres 6.4 and have not yet
found many bugs. I don't know how it would cope with a really large ER model,
as we use it principally for teaching.
Otherwise most of the CASE tools around do some sort of ER modelling.

Modellator: Stubbraten, 1352 Kolsas, Norway.
Distributed in UK by DataEase User Group, Hi-Tech House, Blackfriars St.,
Norwich NR3 1SF, UK
Newsgroups: comp.databases
From: jatg5423@uxa.cso.uiuc.edu (John A. Ternent)
Subject: R:Base 3.1 : Variables outside a region?
Organization: University of Illinois at Urbana
Date: Sun, 15 Nov 1992 22:44:33 GMT

Hi, all.

I am writing an application in R:Base 3.1 (PC) and have run into an
annoying problem. I have a form in which I need to have a tier for
the user to enter some information. However, I would like to have some
variables (the user's name, the date, number of hours worked) which
are either passed in or looked up on the top half of the screen. 
Unfortunately, it seems that for R:Base, either all the fields to 
be duplicated must be in the region, or the variables must belong
to another table. So I created a dummy table to hold the variables, 
but then R:Base said that they had to have a column in common. So
I set up a common column, but now a null row gets inserted every 
time I press <Enter> to get rid of the pesky "No editable data in 
this table" message. So, I tried to set the table so that you couldn't
enter information, and R:Base choked when I tried to ENTER USING that 
form (can't be used for ENTER). There has to be an easier way of doing
this! If anyone has any suggestions on 1) entering variables outside
a region, 2) preventing R:Base from entering null rows, or 3) Avoiding
the "No editable data" problem, I would _really_ appreciate a note. 
Please e-mail me directly and, if anyone is interested, I can post 
a summary to the group.

Thanks in advance,

John Ternent
jatg5423@uxa.cso.uiuc.edu
Newsgroups: comp.databases
From: timmer@fwi.uva.nl (Ralf Timmer (I89))
Subject: Clipper 5.01 array problem
Organization: FWI, University of Amsterdam
Date: Tue, 17 Nov 1992 10:22:00 GMT

Hi,

I've got a Clipper 5.01 question about passing array elements by
reference.
To manage this I use Straleys :

  #xtranslate @@<exp> => {|x| IF( x = NIL, <exp>, <exp> := x) }

I use this as follows:

  IF aExtra[1,1] != ""
     @ nRegel++,47 GET aExtra[1,2] VALID Control(@@aExtra[1,2], nX)
  ENDIF

where Control is like:

  Function Control(Item,X)
     ...
     LOCAL nTemp,....

     IF VALTYPE(Item) = "B"
        nTemp := EVAL(Item)
     ELSE
	nTemp := Item)
     ENDIF
     ....
     ...
     ..
   RETURN .T.

This works.

But, if I place the above IF..GET..ENDIF in a FOR..NEXT loop, with
the index of aExtra is the same as the loop counter it doesn't work
anymore!?

   FOR i:= 1 TO 6
      IF aExtra[i,1] != ""
         @ nRegel++,47 GET aExtra[i,2] VALID Control(@@aExtra[i,2], nX)
      ENDIF
   NEXT

I get an array boundary error at the EVAL call, why?


-- 
Ralf Timmer                                     Department of Computer Science
Email: timmer@fwi.uva.nl                        University of Amsterdam
--
Newsgroups: comp.databases.informix
From: craig@osh3.OSHA.GOV (Craig Nordin)
Subject: Re: Help with antique Xenix/Informix on Altos Z-80
Organization: U.S. D.O.L - Occupational Safety & Health Admin.
Date: Sat, 21 Nov 1992 06:12:11 GMT

In <1ej49dINNb9c@emory.mathcs.emory.edu> jparker@hpbs2776.boi.hp.com (Jack Parker) writes:

>> 
>> > 985 runs with a 80186.  Xenix provided by Altos.
>> 
>> Post this to the net, please. The original poster will want to know.

>Already mailed to him directly.  Somebody else (was it you?) suggested
>it was an 80286.  My memory is dim on the subject, but the I do remember
>working on a 986 in late 83 early 84 when they were brand new - I seem to
>remember this being the, albeit shortlived, age of the '186.  It is
>entirely possible that Altos turned around and changed it to an 80286, but 
>Altos has a habit of upgrading a lot of things when they go to a new chip
>and coming out with a totally new box for it.

We've got 75 of these 986T models and Everyone around me (the old hands
included) say it is a 80286 platform.  The "T" may mean some sort of
chip upgrade, I don't know.  I wish I had eyeballed the insides of
one so I could say with certainty.  But I do know that I can take
an executable, compiled on the 2086 model with the compiler flag 
set specifically for an 80286 CPU, and run it fine on the 986.

I know I can't bring that same executable and run it on one
of our 586 models (8086).  


From: raguayo@hpprdeb.prd.hp.com (Radames Aguayo Soto)
Date: Mon, 16 Nov 1992 20:43:05 GMT
Subject: Re: Triggers in Informix? (fwd)
Organization: HP Puerto Rico Manufacturing Operation
Newsgroups: comp.databases.informix

>
>According to the sales preson we talked to yesterday, 5.01 became
>available on October 31, 1992.  Call now and order yours
>today! :-) :-)
>
>
>--
>Katharine C. Holder
>Computer People Unlimited, Inc.
>email: holderk@positron.med.ge.com
>

According to the sales person I talket to today, it is not released yet.

----
Radames Aguayo, Manufacturing Development Engineer
Hewlett Packard, Puerto Rico Manufacturing Operation

HP Telnet: 882-6445
Outside HP: (809) 882-6445

HPDESK: Radames AGUAYO/HP5600/00
Internet: raguayo@hpprdea.prd.hp.com
AT&T Mail: mhs!hp/pn=Radames_Aguayo/o=hp/ou=corp/ou=unix/ou=x400/dda.hpmext1=raguayo@hpprdea.prd.hp.com
Newsgroups: comp.databases.informix
From: neil@salmon.demon.co.uk ("Neil S. Briscoe")
Subject: fecat.ec assertion failure
Date: Fri, 20 Nov 1992 14:44:06 +0000

Platform:  Sun 4/330 SunOS 4.1.2 Informix/4GL compiler 4.10.UC1

The problem is that when compiling any 4gl source I get the message:

Assertion failed: fecat.ec line 1091 and the compilation, of course,
aborts.

I can't find the file fecat.ec anywhere.  Can someone tell me what
this means?

Regards
Neil

Neil S. Briscoe				Telephone: +44 252 376737
System Administrator			Fax:       +44 252 376644
                                        Email: neil@salmon.demon.co.uk
                                               nbriscoe@cix.compulink.co.uk
Bartec Medical Systems Ltd.
Impression House
Invincible Road				"!##@!** Listen who swears
Farnborough				Christopher Robin has fallen downstairs"
Hants GU14 7NP				-- The Goodies Book of Criminal Records
England
"A man is incomplete until he's married -- then he's finished!"
-- seen on a desktop calendar
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: error message numbers change (was various other topics)
Date: 16 Nov 92 20:21:13 GMT
Organization: Informix Software, Inc.

I rashly asserted,

>> Purely a side issue, but this is in general not true. Error
>> numbers are very stable. 
>> [...]
>> But as long as the error cause is the same, the number is the same.
>
Oliver Okrongli calls me to account:

>In I-SE 4.0 the error number for "statement not available" was -515.
>This changed to -554 in I-SE 4.1 whithout any obvious reason.  Since
>our code is designed to work with I-SE and I-OnLine whithout
>recompilation one of the first things in database initialization is:
>
>   $set isolation to dirty read;
>   if (!db_stmt_not_available())
>      db_error("set isolation to dirty read");
>
>To work with both releases the definition of db_stmt_not_available had
>to be changed:
>
>   #define db_stmt_not_available()  (db_code() == -515 || db_code() == -554)

You are right, I was wrong, it is even worse than you say, and I have
no good explanation.

Previous to 4.0 there were three messages, -513 (statement not available
with Informix-Turbo) and -515 (statement not available with non-Turbo).

Clearly both were not needed.  As of release 4.0 their texts were
made the same: here are the actual entries from the .msg file:
  .-513
  Statement not available with this database engine.
  ...
  .-515
  Statement not available with this database engine.
  ...
  .-554
  Syntax disallowed in this database engine.

The distinction between them is not clear; however -513 and -515
presumably refer to statement verbs such as CREATE AUDIT or SET
ISOLATION, while -554 refers to a single clause such as LOCK MODE
{PAGE|ROW} within a statement that both engines otherwise support.

In version 4.1, -515 was made redundant. From the 4.1 .msg file:

   #               The following message numbers are not being used
   #               and are commented out:
   ...
   #                 515 - Statement not available with this database engine.
   ...
   .-513
   Statement not available with this database engine.
   #.-515
   #Statement not available with this database engine.

In version 5.0, -513 apparently still exists and -515 has been reused
for a constraint error (-554 is unchanged).  From that .msg file:

  .-513
  Statement not available with this database server.
  ...
  .-515
  Constraint %s has already been dropped.
  ...
  .-554
  Syntax disallowed in this database server.

However, although -513 is still in the message file, the manual
(Informix Error Messages, edition with "December 1991" on the cover)
under error -513 says "this message is replaced by error -554 starting
with software level 4.1."

The only rationale I can imagine for this change is to release yet
another number for future use.  In your place I would also feel irked.
From: jparker@hpbs2776.boi.hp.com (Jack Parker)
Newsgroups: comp.databases.informix
Subject: Deletes - and compression of data files
Date: 19 Nov 1992 12:38:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: jparker@hpbs2776.boi.hp.com (Jack Parker)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1624>

In the good old days of SE, a table with a high level of activity
(i.e. deletions/inserts) became riddled with old data row slots 
which were available for re-write, and the index began to look like
swiss cheese.  To correct this periodic unload/loads or cluster
manipulation or ALTER TABLE (same as an unload/load but more user-friendly)
were needed to keep index and data table efficiency at peak.

Is this also true of Online?  Or does Online do this automagically?

						j.

_____________________________________________________________________________
Jack Parker - Contractor               | 
Hewlett Packard, BSMC Boise, Idaho, USA|     These don't look like opinions.
jparker@hpbs2651.boi.hp.com            |       Are you sure they're mine?
(208) 323-5388 (W)  (208) 384-1623 (H) |
_____________________________________________________________________________
Newsgroups: comp.databases.informix
From: jjolly@jjolly.b24a.ingr.com (Jack G. Jolly)
Subject: Backing up physical files
Organization: Intergraph Corporation, Huntsville, AL.
Date: Mon, 23 Nov 1992 19:06:56 GMT

Is it necessary to back up the physical files associated with an
ONLINE db "outside of the environment"?

Consider "raw partitions" as well.

I always thought that backup of physical files was a necessity to
prevent against disk failure - that you would restore your old
files and apply the contents of saved transaction log files against
them to bring them up to date (at least that is how you're supposed
to do it with Oracle).

Does the "Archive" utility in tbmonitor eliminate the need to make copies
of the physical files??

JJ
-------------

  ^^^^^^^^^          Jack Jolly  @  jjolly@jjolly.b24a.ingr.com
 (| 0   - |)
  |   *   |             Intergraph Corporation, Huntsville AL
  \_______/                AEC Project Management Support
From: pp@q8.dk (Poul Pedersen)
Newsgroups: comp.databases.informix
Subject: Is NET needed for ONLINE ?
Date: 17 Nov 1992 03:38:12 -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.1613>

Hey experts !

        What do you actually get, when you use NET on a client for an
        Informix server with ONLINE and ISTAR (version 5.0) ?

        Thanks from:
        -----------------------------------------------------------------
        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
        -----------------------------------------------------------------
Newsgroups: comp.databases.informix
From: akk@aplcenmp.apl.jhu.edu (Arvind Kukreja 202-219-7396)
Subject: CASE TOOLS
Organization: Johns Hopkins Continuing Professional Programs
Distribution: USA
Date: Sat, 14 Nov 1992 23:26:28 GMT

Currently I am involved in evaluating various case tools to be 
used on unix platform using informix database and 'C' programming
language. If there is anyone out there who has any information 
about dedciated case tools for this environment [plase let me know
I will really appreciate it. There are case tools such as  Cadre's
Teamwork and Saber etc.. I am also looking at some of the high end
tools such as TI's IEF etc. Please let me know if you know anyothers 
that will fit into this enviroment. The hardware platform is Sequent
S27 machine. 


Thaknk


Arvind KUkreja
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Deletes - and compression of data files
Date: 20 Nov 92 15:50:28 GMT
Organization: Informix Software, Inc.

Jack Parker writes:
>In the good old days of SE, a table with a high level of activity
>(i.e. deletions/inserts) became riddled with old data row slots 
>which were available for re-write, and the index began to look like
>swiss cheese.  To correct this periodic unload/loads or cluster
>manipulation or ALTER TABLE (same as an unload/load but more user-friendly)
>were needed to keep index and data table efficiency at peak.
>
>Is this also true of Online?  Or does Online do this automagically?

OnLine has assorted "reclamation" stuff that it does, so that you should
not wind up with a "swiss cheese" situation (reuse of freed pages, page
compression, etc.).

What OnLine will NOT do is return pages allocated to an extent (or an
empty extent, for that matter) back to the dbspace.  Once an extent has
been allocated to a able, it will always be allocated to that table
(unless, of course, you drop or alter the table).

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: manmetha@gauss.rutgers.edu (Rajesh Malhotra)
Newsgroups: comp.databases.informix
Subject: Informix Online 5.0 has memory leaks ???
Keywords: Growing memory sizes and page space foe sqlturbo procs.
Date: 16 Nov 92 21:18:15 GMT
Organization: Rutgers Univ., New Brunswick, N.J.


Fellow Informix'ers,

	We've noticed something starnge. On running our application
we find that the sqlturbo processes keep increasing in size inspite of the
fact that our application is not hitting the database atall. The application
seeps waiting for an event to occur, but the sqlturbo processes keep growing
eventually bringing the machine to a grinding halt.

	This happens with Online version 5.00. The application is
written using ESQL/C 5.0. We went back to Online version 4.10, and here the
sqlturbo processes do not seem to grow malignantly.

	Is this an Informix bug we've hit. Have any of you netters faced
this problem. We ar using an RS6000 running AIX 3.2.

	Another question I have is -- Can informix products ment for
AIC 3.1.5 be used with AIX 3.2, or is an upgrade required.

	Any and all responses will be greatly appreciated.

Raj
-- 
===============================================================================
  __  __     .
 /   __/    /                               Raj Malhotra.
/   ( /_   /                                voice : (908)613 4313. 
        __/                                 email : manmetha@gauss.rutgers.edu

===============================================================================
From: andres@dia.edu.ar ("Andres Marianovsky")
Newsgroups: comp.databases.informix
Subject: UnixWare and Informix
Date: 23 Nov 1992 18:23:07 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: andres@dia.edu.ar ("Andres Marianovsky")
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1637>

I'm coming from Comdex Fall. I saw there UnixWare, by Univel (USL + 
Novell).

What think you, people of Informix, about the UnixWare stuff?

---
                                                    Andres Marianovsky
                                                     andres@dia.edu.ar
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: output > 80
Keywords: output
Date: 14 Nov 92 01:08:54 GMT
Distribution: comp
Organization: Informix Software, Inc.

In article <92.318.11.10.05@algol.bsa.de> frank@algol.bsa.de (Frank Huemme) writes:
>Hello,
>My command is :
>isql bws script.sql > sql.out
>where "bws" is the database and "script.sql" the sql-command
>Is there a way ALWAYS to get an output such as     a   b   c   d
>                                                   x   x   x   x
>                                                   x   x   x   x
>
>and NOT
>a	x
>b	x
>c	x

Well, there WAS... a few months back I posted an awk script
that did exactly this (rawther cleverly, too ;)  UnFORtunately,
now I can't find the dang thing.

Did anybody save that?  Send a copy to Frank and one to me, too.

Dave (senility encroaches) Cortesi
  cortesi@informix.com
From: jparker@hpbs2776.boi.hp.com (Jack Parker)
Newsgroups: comp.databases.informix
Subject: Pretty printers (seen the laserjet IV?)
Date: 20 Nov 1992 13:38:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: jparker@hpbs2776.boi.hp.com (Jack Parker)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1631>

Joe Ryburn,

Thank you sir, since it got posted I might even try it.  I apologize most
profusely for my ignorance.

j.

_____________________________________________________________________________
Jack Parker - Contractor               | 
Hewlett Packard, BSMC Boise, Idaho, USA|     These don't look like opinions.
jparker@hpbs2651.boi.hp.com            |       Are you sure they're mine?
(208) 323-5388 (W)  (208) 384-1623 (H) |
_____________________________________________________________________________
Newsgroups: comp.databases.informix
From: joe@smt_6.ingr.com (Joe Ryburn)
Subject: Pretty-Printer for 4GL Programs
Reply-To: joe@smt_6.ingr.com (Joe Ryburn)
Organization: Intergraph Corporation
Date: Thu, 19 Nov 1992 15:04:59 GMT


Does anyone know of a prettyprinter for 4GL programs, or perhaps a 
vgrind definition file for Informix 4gl?  Please Post.


Joe Ryburn
Intergraph Corporation - Huntsville, Alabama
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: The twin problem (was Re: HELP - Index Locks are creating DEADLOCKS)
Date: 16 Nov 92 14:21:51 GMT
Organization: Informix Software, Inc.

Oliver Okrongli writes:
>In I-SE 4.0 the error number for "statement not available" was -515.
>This changed to -554 in I-SE 4.1 whithout any obvious reason.  Since
>our code is designed to work with I-SE and I-OnLine whithout
>recompilation one of the first things in database initialization is:
>
>   $set isolation to dirty read;
>   if (!db_stmt_not_available())
>      db_error("set isolation to dirty read");
>
>To work with both releases the definition of db_stmt_not_available had
>to be changed:
>
>   #define db_stmt_not_available()  (db_code() == -515 || db_code() == -554)

Please allow me to offer you a (perhaps) better solution.  If you
check a 4.1 or better manual, you will find that following the database
statement, the sqlca structure will contain a flag value indicating
whether an SE or OnLine engine was started (it is one of the sqlwarn
elements - it will also indicate logging/no logging and ansi/no ansi).
If you check this then, you can easily set a global flag that can be
checked for the very purpose of determining appropriate statements.

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: pao@wam.umd.edu (Nikos Strifas)
Newsgroups: comp.databases.informix
Subject: tbinit processes on 5.0
Keywords: informix,tbinit,database
Date: 17 Nov 92 16:57:04 GMT
Article-I.D.: wam.1992Nov17.165704.2904
Distribution: usa
Organization: Workstations at Maryland, University of Maryland, College Park


Informix Users,

I have a problem that our local guru is unable to answer. I just installed
Informix 5.0 on my HP-700 & INCREASED some of the kernel parameters so I
could run TUXEDO. Anyway, the problem is that when I start Informix I see
6 tbinit process running. We thought that 2 is the normal. Any suggestions?

Thanx,

Apostolos Dedes
GE Information Services
Rockville, MD 20878
(301)340-4959
dedes@geis.geis.com
From: ric@updike..sri.com (Richard Steinberger)
Newsgroups: comp.databases.informix
Subject: man pages for tbXXX ???
Date: 23 Nov 92 19:18:14 GMT


	We have recently installed Informix OnLine at our site.  Apparently
there are no man pages for the tbXXX commands.  Is this really true?
If so, has anyone written any?  Just wondering.

regards,

	ric steinberger

	ric@updike.sri.com