HDTenEightyP/NetNews huggingface dataset:
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: Triggers in Informix?
Date: 13 Nov 92 10:19:43 GMT
Organization: Enterprise Technology Center, Informix Software, Inc.

In article <1992Nov10.063200.2163@netcom.com> tssmith@netcom.com (Tim Smith) writes:
>Are the 5.01 triggers "after statement" triggers, or do you support
>the SQL3 standards for all trigger types (I think there are 12 of
>them)?
>
>If not in 5.01, when?
>
>Thanks.
>
>--Tim (tssmith@netcom.com)

Does it bother anybody else that this poster is an Oracle employee hiding
behind a public-access account?


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

  Smith and Wesson: the Ultimate Point-and-Click User Interface.
From: Root@letterkenn-emh1.army.mil
Newsgroups: comp.databases.informix
Subject: c-isam programmer's manual
Date: 12 Nov 92 05:33:03 GMT
Article-I.D.: emory.1dttffINN4ad
Reply-To: Root@letterkenn-emh1.army.mil
Distribution: world
Organization: Mailing List Gateway
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1591>

Dave@informix.com writes to see the C-ISAM Programmer's Manual for info
on log format. I keep seeing this answer to many things. Dave, not all of
us bought a C-ISAM product, we just bought SE. The  manual you refer to does
not come with SE (perhaps it should, if it contains appropriate info??).
What is available to use with just SE manuals?
Ann Barnes, Letterkenny Army Depot, anbarnes@letterkenn-emh1.army.mil
Newsgroups: comp.databases.informix
From: thaddeus@hpcvusd.cv.hp.com (Thaddeus Konar)
Subject: Escape Characters in 4GL
Organization: Hewlett-Packard Company, Corvallis, Oregon USA
Date: Fri, 13 Nov 1992 18:37:06 GMT

Is there a way to send escape characters (non-ascii) from 4GL
application to terminal? I would like to turn on and off some
soft keys on hp terminal.
For example if I could display "[ESC]&jB" then application 
would menu appear.
However 4GL compiler complains on non-ascci display or message.

Thaddeus Konar                       thaddeus@cv.hp.com
Hewlett-Packard                      (503) 750-3461
UTD/CV  Corvallis, OR   97330
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: SE vs OnLine results question
Keywords: benchmark online standard engine
Date: 5 Nov 92 17:06:48 GMT
Organization: Informix Software, Inc.

John White writes:
>
>   I'm the guy that said I was going to be comparing OL vs SE. I've got 
>some preliminary results back from the first test suite and it has raised 
>some questions.
>
>   I created a test script that would create, load, and index 4 tables. 
>This would test insert and index performance. The insert performance was 
>consistently worse in Online (12-75% depending on the bytes/row - the larger, 
>the worse). The wierd things is that as I added indexes, the gains that 
>OnLine brought diminished. It went like this:
>
>    Table	# Indexes	Pct Faster
>    1		4		+265
>    2		8		+82
>    3		8		+44
>    4		2		-22
>
>   I declared rootdbs to be 20M and the testdbs to be 171M. They share a 
>191M drive. The tables take up 71M. All of the indexes are unique.
>
>   My question to the OnLine heads: Is there an obvious fundamental 
>flaw in my setup that is causing the indexing performance to degrade?
>I need to know ASAP as it might invalidate all further tests.
>
>   - john (john%elsouth@concert.net)

It is not clear at all what measurement your numbers represent.  Pct Faster
than what?  Are you saying that the whole create/load/index was faster?
Please explain your table (above) more clearly.


In general, you will probably find that SE outperforms OnLine in low user
count tests (1 user is the extreme).  This is because OnLine is designed
to handle high user, high throughput operations.  Testing it with one user
is incurring a lot of overhead for that one user.  As your user count
increases, that overhead is amortized over more users and it becomes
more efficient.  Try testiong 20 users inserting into those tables, and
you should find that OnLine outperforms SE by a large factor.

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: johnl@obelix.informix.com (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  Need insight on error
Date: 2 Nov 92 00:23:06 GMT
Article-I.D.: emory.1d2viaINNe0p
Reply-To: johnl@obelix.informix.com (Jonathan Leffler)
Distribution: world
Organization: Emory University, Dept of Math and CS
X-Informix-List-ID: <list.1565>

Dear Todd,

UUNET bounced this mail with host david.wheaton.edu unknown -- hence the
posting to informix-list.

>From: uunet!david.wheaton.edu!bernha (Todd A Bernhardt)
>Subject: Need insight on error
>Date: 30 Oct 92 23:21:06 GMT
>X-Informix-List-Id: <news.2039>
>
>Hi, this error popped up for seemingly no reason this week.  The 4gl source
>had not been recompiled in nearly one month and the reason for its
>recompiling was a change to a globals file.  My knowledge of C does not
>lead me to an intuitive understanding of this error and any insight anyone
>can give me is already greatly appriciated!!!

>/usr/informix/bin/c4gl -a -L/usr/sturecs/lib -c ticket_list.4gl
>(ccom): ticket_list.c, line 1183: ccom: Internal: initialization alignment error
>      	{100, sizeof(ticket_arr[b_chk("ticket_list.4gl",119,(x)-1,50)].lot_code)},
>      --------------------------------------------------------------------------^
>*** Error code 1

>Stop.

Uggggh.  Without the source code for the I4GL, it'll be difficult to get very
far with this, but I think the following statements can be made:

* You have an array called ticket_arr which is defined as
  ticket_arr ARAY[50] OF RECORD LIKE ticket_list{?}.*
* You have a fetch statement (possibly an implicit one in a FOREACH loop),
  which reads: INTO ticket_arr[x].lot_code
* This occurs at line 119 in file ticket_list.4gl.
* You are compiling with the -a flag now (deduced from the presence of the
  call to b_chk, and then observed on your command line, so not too many
  marks for billiance just there).

I would hazard a guess that when you previously compiled this code, you were
not using the -a option.  The error is in your C compiler: it is baulking on
what is legitimate (but very complex) C syntax.  Try recompiling without the
-a flag.

Yours deductively,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
Newsgroups: comp.databases.informix
Subject: R4GL Menu Colors.
Date: 13 Nov 1992 12:13:05 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1603>


Hello!
 
I have a simple question which probably has a simple answer, NO
IT CAN'T BE DONE.
 
Question:  How can we alter, modify, change, or select different
colors for the R4GL menu bar we create?
 
I can change to overall foreground, background colors with
DBCOLOR=BLUE,YELLOW.
 
I can change the perform screen fields with COLOR=4 for each
fioeld.
 
I can change the ERROR, MESSAGE, and COMMENT lines with
ATTRIBUTE(GREEN, REVERSE).
 
But I have not found a way or a reference to changing the menu
bar lines I create in my R4GL programs.
 
Can we do this?
 
System specs.: 386 PC with MSDOS 5.0, Informix R4GL v. 1.10 for
DOS.
 



					Michael S. Gordon
					Foreman, Gyroscope Section
					Avionics Division 

 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 *                                                                           *
 *  Michael Gordon                           Sacramento Army Depot           *
 *  Foreman, Gyroscope Section               Directorate For Maintenance     *
 *  E-Mail: maint72@saad-emh1.army.mil       Attn: SDSSA-MAV-320             *
 *  DSN:    839-2367                         Michael S. Gordon               *
 *  Comm.:  (916) 388-2367                   Sacramento, CA 96813-5036       *
 *                                                                           *
 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
From: jbaker@bluegrass-emh1.army.mil ("John Baker, Blue Grass Army Depot")
Newsgroups: comp.databases.informix
Subject: Editing in PERFORM
Date: 12 Nov 1992 13:28:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: jbaker@bluegrass-emh1.army.mil ("John Baker, Blue Grass Army Depot")
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1595>

Ron Choi at the University of Wisconsin, Madison asks about PERFORM:

> for updating, it would be nice if the user-interface supplies some sort of
> editing capability.  only way one can update in perform is to type over the
> old entry.

Ron,
    The editing features of PERFORM are well documented.  Look in the User
Guide.  When inside a field, Ctrl-a toggles between insert and overwrite
modes.  Ctrl-l moves the cursor to the right and Ctrl-h moves it to the left.
     There is also the Ctrl-p feature which will fill each field with the 
values of the last record entered and tab the cursor to the next field.  Some
of our users find the Ctrl-p to be quite handy.

---
John
--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--
John Baker,  Directorate of Infor Mgt.  Blue Grass Army Depot, Lexington, KY
jbaker@bluegrass-emh1.army.mil    Phone: (606) 293-3644, 293-3743  DSN: 745-
--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: out-of-control /tmp files
Date: 10 Nov 92 16:11:15 GMT
Organization: Informix Software, Inc.

Mark L Trotter writes:
>Hi netheads,
>  I'm now using the latest and greatest version of Informix, 4GL 4.1 and
>OnLine 5.0, and the sort package has me miffed.  When I perform a select
>that contains a UNIQUE or ORDER BY, this thing cranks up a temporary file
>in my /tmp directory of my file system.  The problem is I have only a
>little bit of file space left, but my raw Informix drive has over 200mb
>sitting empty!  How can I convince it to use the raw device? And why
>are we converting back to using the OS, and it's overhead, to manipulate
>data instead of the OnLine engine using the raw device?
>BTW, I'm on an HP9000/832 and HPUX 8.0

   You cannot "convince" the server to use raw space (dbspace space, actually)
   for sorts.  The "new" sort package was designed to perform parallel
   sorting on SMP machines.  This requires having different drives available
   for i/o when psorting is used.  It was decided that the best approach to
   this was to use Unix files for the sorting process (generally only used
   for larger sorts).


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: trotter.1@osu.edu  (Mark Trotter)
Subject: re: out-of-control /tmp files
Originator: mtrotter@bottom.magnus.acs.ohio-state.edu
Organization: The Ohio State University
Date: Tue, 10 Nov 1992 19:44:03 GMT

Mark L Trotter writes:
>  I'm now using the latest and greatest version of Informix, 4GL 4.1 and
>OnLine 5.0, and the sort package has me miffed.  When I perform a select
>that contains a UNIQUE or ORDER BY, this thing cranks up a temporary file
>in my /tmp directory of my file system.  The problem is I have only a
>little bit of file space left, but my raw Informix drive has over 200mb
>sitting empty!  How can I convince it to use the raw device? And why
>are we converting back to using the OS, and it's overhead, to manipulate
>data instead of the OnLine engine using the raw device?
>BTW, I'm on an HP9000/832 and HPUX 8.0

David Kosenko writes (from Informix):
 > You cannot "convince" the server to use raw space (dbspace space, actually)
 > for sorts.  The "new" sort package was designed to perform parallel
 > sorting on SMP machines.  This requires having different drives available
 > for i/o when psorting is used.  It was decided that the best approach to
 > this was to use Unix files for the sorting process (generally only used
 > for larger sorts).

And I reply:
I don't have a SMP machine.  I will take a stab at guessing that most of the
machines running Informix are not SMP machines.  Using the file system for
data storage seems to be a step backwards on my machine, especially for
"larger sorts".  I don't have the room, and don't want the overhead.  How
can I get sorting back in the dbspace where it belongs?

!------------------------------------------------------------------------!
!        Mark Trotter @ The Ohio State University Graduate School        !
!     voice 614/292-6031  FAX 614/292-3656  BITNET trotter.1@osu.edu     !
!------------------------------------------------------------------------!
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Informix 4GL arrays
Date: 10 Nov 1992 13:58:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: dave.snyder@snide.com (Dave Snyder)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1581>

Quoting Aaron Pelton...
} 
}    Given that I have a set of data that may be anywhere from 0 to n records
} that I want to place in a scrolling region on the screen, can it be done
} without a LOT of code to accomplish this?
} 
Take a look at the "browse" function that is generated by db4glgen.  It
allows a user to scroll through as many rows as they can query.  The limit
on queried rows is based on RAM, ie. 4 bytes/row.

}    Can anyone recommend a direction to look for clues? Is it possible to
} fool informix into using a malloc'd array?
} 
The code generated by db4glgen does fool informix into using malloc'd arrays.

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: gaukur@rhi.hi.is (Kristjan Gaukur Kristjansson)
Newsgroups: comp.databases.informix
Subject: Re: defer interrupt.
Date: 9 Nov 92 13:22:18 GMT

>Did you read pages S-29 - S-32 (in the English version, anyway) of the 
>4GL 4.1 Supplement document? If so, what was unclear?

Yes I've read them, but maybe theres something wrong with my configuration.
In my test exemplar I'm interrupting a foreach loop thats fetching rows
and getting some of them into a report.

I started with 'whenever error call error_func' and when I hit ctrl-c the
program goes to that function (usually with status = -213) and then goes to
the int_flag check.

I also tried it without the 'whenever' statement and then the prog. breaks
right away with errors -229 and -103 (illegal key descriptor).

So is it maybe something wrong with my termcap?

Also one comment on the int_flag testing; if youre interrupting open, fetch,
close statements (with something in between) do you have to test the int_flag
after every statement (because you never know in loops where the ctrl-c will
hit)?  That seems like a whole lotta work for just wanting to be able to
stop long queries.

(config. I-Online 4.1, IBM/RS-6000 AIX 3.1)

				With thanks in advance

					Gaukur

Disclaimer: Our god is what is left when every god has been counted and said:
	    No, not him, not him.	--Halldor Laxness.
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: out-of-control /tmp files
Date: 11 Nov 92 15:45:50 GMT
Organization: Informix Software, Inc.

Mark Trotter writes:
>David Kosenko writes (from Informix):
> > You cannot "convince" the server to use raw space (dbspace space, actually)
> > for sorts.  The "new" sort package was designed to perform parallel
> > sorting on SMP machines.  This requires having different drives available
> > for i/o when psorting is used.  It was decided that the best approach to
> > this was to use Unix files for the sorting process (generally only used
> > for larger sorts).
>
>And I reply:
>I don't have a SMP machine.  I will take a stab at guessing that most of the
>machines running Informix are not SMP machines.  Using the file system for
>data storage seems to be a step backwards on my machine, especially for
>"larger sorts".  I don't have the room, and don't want the overhead.  How
>can I get sorting back in the dbspace where it belongs?

Well, "where it belongs" is rather subjective, but if I wasn't clear enough 
in my previous response: sorting will NOT use dbspace space, it will always
use Unix file space.  You cannot "get sorting back in the dbspace."  The new
sort package was designed to be able to take advantage of SMP machines, but
works and is also used for single processor machines.

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
Newsgroups: comp.databases.informix
From: rchoi@thylacine.cs.wisc.edu (Ron Choi)
Newsgroups: comp.databases.informix
Subject: Re: Informix logs read-only queries? can't handle 'not-exists'?
Date: 12 Nov 92 21:06:41 GMT
Organization: University of Wisconsin, Madison -- Computer Sciences Dept.

In article <1992Nov12.161943.21876@informix.com> davek@informix.com (David Kosenko) writes:
>Ron Choi writes:
>>i ran the following query overnight:
>>
>>select count(*)
>>from relA
>>where (relA.x10A = 0 or relA.x10A = 5) and not exists (
>>	select relB.evenAcct
>>	from relB
>>	where (relB.x100B = 0 or relB.x100B = 49) and
>>	relB.evenAcct = relA.acct
>>	);
>>
>>and got hundreds of "Logical Log Files are Full -- Backup is Needed".
>>the worst thing is that this corrupted the database.  
>
>The reason log entries are being generated is that the sub-query is 
>generating a temporary table, and the creation of this temp table is being
>logged.
>These tables do not hang around, but
>the log entries will fill up the logs.
>The log records are still being written because OnLine logs all DDL 
>statements (whether logging is on or not) and the creation of even an
>implicit temp table is, at the rsam level, a DDL action.
>
>I agree wholeheartedly that a query should not corrupt the database.  What
>exactly become corrupted and how?

after i ran the query above the system could not restart (or recover).  that
is, i tried to restart it using tbmonitor/mode/startup, but it spent over
5 hours printing out "recovering. please wait...." message.  i had to restore
the database from the tape.  i don't know what exactly got corrupted.  i 
suggest you have your q.a. guys run the above query and figure it out.
do you know just what exactly happens when logical log space runs out while
a query is running?

>I cannot say for sure if this is considered a "bug".  

if a query makes the system fail to recover, i'd say it's a bug.

>Dave
>-- 
>Disclaimer: These opinions are not those of Informix Software, Inc.


-- 
---------------------------------------------------------------------------
ron choi 				\\  #include <disclaimer.h>
university of wisconsin, madison	\\
	"when i was your age, i walked ten miles to school, unarmed."
Newsgroups: comp.databases.informix
From: frank@algol.bsa.de (Frank Huemme)
Subject: output > 80
Organization: BSA
Distribution: comp
Date: Fri, 13 Nov 92 10:10:05 GMT
Keywords: output

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
d	x

a	x
b	x

I dosn't matter if the output is > 80 

	Thanks in advance

		Frank
-- 
Frank Huemme	frank@algol.bsa.de	email: ..!unido!algol!frank
BSA 		Bizerba Software- und Automationssysteme GmbH
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: Running SE with log files linked to /dev/null
Date: 8 Nov 92 02:39:58 GMT
Organization: Helen Keller Bondurant's Performance Driving School for the Blind

In article <1992Oct29.153901.22495@informix.com> davek@informix.com (David Kosenko) writes:
>Jack G. Jolly writes:
>[ some details deleted]
>>
>>If we first link the log file to /dev/null, then load the graphics files,
>>we don;t have to worry about the log file getting so big that it uses all
>>the disk.
>
>At this point, I have to ask why you are using a log in the first place?
>It provides no functionality, and in fact is only serving to
>slow down processing (due to writing log records out).  You have no
>capability to rollback your work.  Why not just turn logging off?

Keep in mind, Dave, that there IS NO DOCUMENTED WAY to turn off logging
in SE; perhaps this is the source of Jack's problem.

FYI: to turn off logging in an SE database, do the following as user
"informix":

   1) set environment
   2) isql - - 
       database <dbname> exclusive;
       begin work;
       delete from systables where tabid = 0;
                             should respond: "1 row(s) deleted."
       commit work;      (you can rollback instead if you changed your mind)
       close database;

The database logging is now turned "off".

>Dave


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

  Smith and Wesson: the Ultimate Point-and-Click User Interface.
From: bmacwill@letterkenn-emh2.army.mil ("B.T. MacWilliams")
Newsgroups: comp.databases.informix
Subject: Informix 408 error
Date: 5 Nov 1992 14:38:07 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: bmacwill@letterkenn-emh2.army.mil ("B.T. MacWilliams")
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1569>




  >        Every now and then a query in our application fails
  >with an error code of 408. We have'nt been able to duplicate the
  >scenario and make the error occur again. The manual's description
  >of 408 does not seem to make sense.
  >
  >        Any ideas / suggestions?
  >
  >BTW we are running Informix online 5.0 and ESQL/C on an IBM RS600
  >running AIX 3.2
  >Raj.

Raj,

        We have periodically experienced the same error.  On one ocassion,
        It  was  determined  that  any array was being exceeded.  A select
        statement was returning 23 rows when we were allowing for only 20.
        Hope this helps.


---------------------------------------------------------------------------
	Brian MacWilliams
	Ind Tech & Db Admin Br
	ADP Tech
	USAMC SIMA - CHAMBERSBURG
---------------------------------------------------------------------------
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: table creation timestamp
Date: 13 Nov 92 16:30:29 GMT
Organization: Informix Software, Inc.

Bob Baskett writes:
>
>i there a way that the creation timestamp of a table can be obtained.
>tbcheck -pt db:tab displays it, but i want to get this info non-
>interactively and without having to wait for tbcheck to finish.  also,
>does informix stores the last update, last alter timestamp anywhere.
 
You could get the creation *date* (but not time) by 

SELECT created FROM systables WHERE tabname = "<tablename>";  This
will not reflect any table alterations though.  There is nothing that
tracks the last "update" (we'd be forever modifying it!).  There is a verion
column in systables that get sincremented when an ALTER TABLE is performed,
but it is not a timestamp.

The timestamp you see in tbcheck is stored in the tblspace tblspace, and is
not available to users via any method other than tbcheck.

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