HDTenEightyP/NetNews huggingface dataset:
From: andres@dia.edu.ar ("Andres Marianovsky")
Newsgroups: comp.databases.informix
Subject: Last releases
Date: 21 Aug 92 10:38:06 GMT
Reply-To: andres@dia.edu.ar ("Andres Marianovsky")
X-Informix-List-ID: <list.1386>

Hello,

Which are the last releases of ISQL and I4GL for
Xenix 286? And for Xenix 386?

Thanks,

-- 
                                                    Andres Marianovsky
                                                     andres@dia.edu.ar
From: biocca@bevsun.bev.lbl.gov (Alan K Biocca)
Newsgroups: comp.databases.informix
Subject: lookup joins in perform
Date: 12 Aug 92 18:56:47 GMT
Organization: Lawrence Berkeley Laboratory, California
NNTP-Posting-Host: 131.243.192.16

I have tables that join on multiple columns, and would like to do lookups
in perform to display info from the other table when entering data.  Perform
doesn't appear able to handle more than one column joins.

In my tables, uniqueness requires the multiple column joins -- joining on
any single column is insufficient.

Is there a solution to this?  Are tables joining on multiple columns that
difficult to use from perform?  Is there a better way to approach this design?

Thanks in advance,

Alan K Biocca
AKBiocca@lbl.gov
From: bochner@das.harvard.edu (Harry Bochner)
Newsgroups: comp.databases.informix
Subject: Re: conditional select sum() based on field question
Keywords: select sum
Date: 13 Aug 92 18:06:45 GMT
Article-I.D.: das.1992Aug13.180645.6534
Organization: Aiken Computation Lab, Harvard University

In article <297@praeda.UUCP.UUCP>, pete@praeda.UUCP.UUCP (Pete Frehner) writes:
|>    select sum(amount) into total_credits
|>        from orders where order_type = "CREDIT"
|>    select sum(amount) into total_normal_orders 
|>        from orders where order_type = "REG"
|>    let net_amount = total_normal_orders - total_credits 
|> Is there a way that this could be done in one select statment??

Paul Roberts has already posted a good solution for this particular case, where
we want the difference of the two totals. I'd just like to contribute an idea for
a more general solution, usable if you really need the two separate figures:

select order_type, sum(amount) from orders
group by order_type
into temp totals

select amount into total_credits from totals
where order_type = "CREDIT"

select amount into total_normal_orders from totals
where order_type = "REG"

This way the large order table only has to be scanned once. Selecting the
individual totals should be fast, as long as the number of order_types is small.

-- 
Harry Bochner
bochner@das.harvard.edu
From: david@cssnet.UUCP (J. David Schronce)
Newsgroups: comp.databases.informix
Subject: Books on Informix
Date: 14 Aug 92 02:51:12 GMT
Organization: Computer Support Services

Many thanks to those who responded to my query on upgrading from 
Version 1.10 to 4.0.  At least now I know what questions to ask before 
I fall headlong into the "land of the lost"...
  
I started learning Informix about 2 years ago with nothing more than 
the distribution manuals and 1/2 million lines of spaghetti code that 
had been mangled previously by 4  programmers.  I've pretty 
much exhausted the info I can glean from the manuals (they COULD have 
better examples), but I know that FAR more can be accomplished.
I've already done things that my predecessors said were impossible.
  
Are there any GOOD books available on Informix?
Some that I can live with, chew on, and learn from?  My company can't 
afford to send me to training classes, so I fill my library very 
carefully.
  
Your recommendations (and warnings) are appreciated...

Please post here or reply to dschronc@lee.cerf.fred.org - Incoming 
mail is currently bouncing at this site.

---dave---
+-----------------------------------------------------------------+
|J. David Schronce     "Death Before Decaf!!"    david@cssnet.UUCP|
|Computer Support Services                            919/775-2145|
|-----------------------------------------------------------------|
|          "The opinions and the company are both mine..."        |
+-----------------------------------------------------------------+
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: porting a database to ano
Date: 19 Aug 92 23:43:08 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1383>

Quoting David Kosenko...

> (as dbimport and dbexport ship only with OnLine).  The second solution

Hmmm... now thats interesting, all my SE's came with dbexport/dbimport.  My
platforms include Motorola Delta Series, IBM RS/6000, and SCO Unix.

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
Newsgroups: comp.databases.informix
From: neil@salmon.demon.co.uk ("Neil S. Briscoe")
Subject: Informix Support Problem
Date: Fri, 21 Aug 1992 14:00:40 +0000

In article <1992Aug21.054836.3498@u.washington.edu>
From: golbone@milton.u.washington.edu (Sima Hashemifar) writes:
[...]
>But you would post to the net to clear your/company name? Why did you not
>email your response?

Some at Informix choose to, some don't.  In either case I don't see it
as trying to make the company look good.  It may be that they care
what customers feel about the company *and* themselves.  They're
trying to do you a favour.

>You may think that working at home is a sign of support, I think of it as a
>sign that either the engineer is overworked meaning that Informix is
>cutting corners in support by having too few hands, or the engineer is lazy
>at work and has to take the spill home. I have a strong feeling the reason
>is not the latter.

Most of my customers are also good business colleagues.  I've spent
social occasions with these people.  (I'm lucky we're small enough to
allow this.)  In any event, working from home after a day at the
Silicon Face is nobody's idea of fun.  I've been 'phoned at work
before and asked if I would be available at the weekend due to this
being the only time the customer could perform a particular job.  In
most cases I've agreed.  I don't get paid extra, the customer doesn't
get charged.  With an attitude like yours, however, you'd get past me
just once.  After that, boy would you be paying through the nose.
More likely, I'd just be busy that weekend, and all the following
ones.

You guessed.  You've agitated me.

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
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: The use of comp.databases.
Reply-To: shemminga@cix.compulink.co.uk
Date: Thu, 13 Aug 1992 07:33:17 +0000


> I know the focus of this group is "technical", but is it
> appropriate to post press releases here.  To save generating
> a lot of discussion here...send replies directly to me or I 
> will go with the leaning of the first 5 out of 9 replies.

If it's relevent, post it. I would.
--
These opinions are mine -- let's face it who'd want them

Send me mail -- No reasons, just send it.

stuart@cix.compulink.co.uk            Tel +44 778 426444
[Stuart Hemming]


Stuart
|8-)
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: porting a database to ano
Date: 19 Aug 92 15:24:25 GMT
Organization: Informix Software, Inc.

>> ->What is the best way to move a DATABASE from one machine to
>> ->another?

>> This is probably a RTFM question, but I've asked the same question 
>> before... I use DBEXPORT to export the db schema and the data.  DBEXPORT 
>> and go to disk or tape.  On the other system, use DBIMPORT to create and 
>> load the database.

>Well, if that database isn't *too* big and you've a TPC/IP
>connection why not just RCP it?

This discussion brings up a pretty good point.  Informix has 2 different
database servers, INFORMIX-SE and INFORMIX-OnLine.  The middle text above
pretty much assumes the person asking the original question was using OnLine
(as dbimport and dbexport ship only with OnLine).  The second solution
assumes SE (as you cannot rcp OnLine data, at least not directly {of course,
someone will respond that they do it all the time ;-)}).

I think what can be derived from this discussion is: when asking questions
about Informix, it is a good idea to indicate which of our two servers you
are using, as the answer may well be different for the two.

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
The heart and the mind on a parallel course, never the two shall meet.
						-E. Saliers
From: stb@isbank.is (Steintor Bjarnason)
Newsgroups: comp.databases.informix
Subject: Catching SIGHUP signals in Informix-4GL programs
Keywords: SIGHUP
Date: 20 Aug 92 15:13:53 GMT
Organization: Islandsbanki, Reykjavik Iceland

I was reading through the Informix-4gl supplement manual which came
with Informix-4GL v4.1 and I found the following clause (page S-205):

  ... You cannot control the processing that occurs when the SIGHUP or
  SIGPIPE interrupt is detected, even though the program catches these
  values.

If I understand this clause correctly then there is no way for me
to do my own cleanup when I receive SIGHUP ???? 

If this is correct then I consider this a MAJOR bug because I need to
be able to detect when users log out (My users are connected through
an X.25 pad which sends SIGHUPs when the connection is cleared).

If this is true, then is there some way around this "feature" ?

Steinthor
-- 
Steinthor Bjarnason    | ICEUUG chairman         | This space available for 
Islandsbanki h.f.      | Internet: stb@isbank.is | rent.....
Kringlan 7             |      Tel: +354-1-608000 |
155 Reykjavik, Iceland |      Fax: +354-1-678711 |
From: golbone@milton.u.washington.edu (Sima Hashemifar)
Newsgroups: comp.databases.informix
Subject: Re:  Informix I-Net problem
Date: 19 Aug 92 09:05:40 GMT
Article-I.D.: u.1992Aug19.090540.17209
Organization: University of Washington, Seattle

Newsgroups: comp.databases.informix
Subject: Re: informix upward compatibility (fwd)
Summary:  Informix support stinks!
Expires: 
Followup-To: 
Distribution: usa
Organization: University of Washington, Seattle
Keywords: 

In article <1992Aug15.014149.14940@informix.com> aland@informix.com (Colonel Panic) writes:
>
>Do you have any idea how the support matrix explodes if you try to support 
>the last several revs of the O/S (and I'm not talking about *different 
>versions* of the O/S, e.g. SVR4, I'm talking just maint upgrades, e.g. 3.2 to
>3.2.1 to 3.2.2 to 3.2.3 to 3.2.4)?
>

It does not seem that informix offers any support. I have
an experience where their i4GL product would hang up my machine when we
use passwords and we try to delete a password.
This is under DOS version 3.1. I found the bug the second day
after acquiring the damn package. The first thing the supposed engineer told
me was that the packeage has not been registered for support, this was
after telling him that the package was one day old, One day old
for christ sake!
Then he said the bug has been fixed. I said I was not dreaming this up, my
machine hangs!!!! He said he would test it out. One week later, he called me to
confirm that his machine at home hangs, (at home mind you), he would have
to test it again in the office. Three days later: Yes the machine at the office
also hangs. He gave me a bug report number or something like that. He would
have to have another engineer verify this bug.
All this happened in May, I am still awaiting a letter or a phone call
from Informix. Meanwhile, my client yanks a few dollars out of my quote --
thank God they did not pull the project-- The strength of my
proposal was the password protection which I can not now deliver.
What about BLOBS? Only in our online engine, said the support engineer, but
the sales engineer said, Yeah, we support them.

Meanwhile, the campaign has started:
Please do not buy infromix products, their tech support stinks.
The support policy will kill your business!!

BTW: The support engineer said I could return the product if I did not
like what I was getting. Talk about support!?
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re:  Informix I-Net problem
Reply-To: shemminga@cix.compulink.co.uk
Date: Fri, 21 Aug 1992 08:28:37 +0000



In <9351@emory.mathcs.emory.edu> zill@hermes1.sps.mot.com (Mike Zill)
writes:

> I would raise this UK support issue to the top of INFORMIX asap.  If this
> is common in the UK, the top guys at INFORMIX need to know.  
> Fix problems at the root and problems they are no more.

I'm not sure it is. Are they may (any) other users out there using
SE/SQL/RDS with I-Net who are having problems?
--------------------------------------------------------------
| These opinions are mine -- let's face it who'd want them   |
| Send me mail... Now send me some more                      |
|------------------------------------------------------------|     
| Stuart Hemming             | shemminga@cix.compulink.co.uk |
| Tudor Labels Ltd           |                               |
| Roman Bank Bourne          | Tel :  (+44) 778 426444       |
| Lincs PE10 9LQ. UK.        | Fax :  (+44) 778 421862       |
--------------------------------------------------------------


Stuart
|8-)
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: conditional select sum() based on field question
Keywords: select sum
Date: 15 Aug 92 03:03:44 GMT
Organization: The Helen Keller Bondurant High Performance Driving School for the Blind

In article <297@praeda.UUCP.UUCP> pete@praeda.UUCP.UUCP (Pete Frehner) writes:
>I could do this in two select statements and the difference would be the
>net amount, but this requires that the data be read twice (once for each
>select statment).  
>
>   select sum(amount) into total_credits
>       from orders where order_type = "CREDIT"
>
>   select sum(amount) into total_normal_orders 
>       from orders where order_type = "REG"
>   let net_amount = total_normal_orders - total_credits 
>
>Is there a way that this could be done in one select statment??  Two select
>statments is no big deal for a small database, but this database contains
>hundreds of thousands of orders.  If the data could be read only once it would
>pick up performance quite a bit.

This does the *important* work in one select:

select order_type, sum(amount) sum_amount from orders
  where order_type in ("CREDIT", "REG")
  group by order_type
  into temp tempsum

The queries to populate the variables are really quick, since they are dealing
with a two-row summarized temp table at this point:

select sum_amount into total_credits from tempsum where order_type = "CREDIT"

select sum_amount into total_normal_orders from tempsum where order_type="REG"

let net_amount = total_normal_orders - total_credits 

>Pete Frehner				 Voice (519) 673-3350
>Praeda Management Systems                Fax   (519) 667-1968
>371 Dufferin Ave.                        uucp: .....uunet!praeda!pfrehner
>London, Ontario CANADA N6B 1Z5           


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

  Smith and Wesson: the Ultimate Point-and-Click User Interface.
From: billd@informix.com (William Daul)
Newsgroups: comp.databases.informix
Subject: Re:  Informix I-Net problem
Date: 14 Aug 92 22:36:01 GMT
Organization: Informix Software, Inc.
Originator: billd@cheetah

FROM:  The Informix Closet Engineer

PROBLEM:
=================================================================
>From shemminga@cix.compulink.co.uk (Stuart Hemming)
Newsgroups: comp.databases.informix
Subject: Informix I-Net problem
Date: 12 Aug 92 16:44:00 GMT


Can anyone help me? We're running a small net of 386/486 boxes. On
the 486 machine we've got Informix SE installed along with SQL and
I-Net. On the other 2 machines we've go SQL and I-Net.

We also have a number of Informix 4GL programs running. The problem
is that when a number of sqlexec processes are started the system
reports the following error messages if someone tries to start
another one:

        -932 : Error on network connection, t_open system call failed
          28 : No space left on device

The message appears on the client terminals, the server doesn't seem
to be getting upset about it. I don't know however, whether it's the
client or the server that's generating the error message.

Can anyone tell me why this is happening, what the device in question
is and whether I can do anything about it?

I'd really appreciate *any* help!
--
These opinions are mine -- let's face it who'd want them

Send me mail -- No reasons, just send it.

stuart@cix.compulink.co.uk            Tel +44 778 426444
=================================================================


RESPONSE:
=================================================================

Stuart:

  -932 Error on network connection, t_open system call failed
   SYSTEM error number 28
   No space left on device.

   Note no errors in sqlsrvlog.

   What you should do would be to increase the number of Queues.  This
   should be a parameter like NQUEUE in the kernal on the server.

   You could check this by using crash utility and the command strstat
   (streams status).



---John
=================================================================

-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
 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
Newsgroups: comp.databases.informix
From: spw@ccd.harris.com (Steve Wallick)
Subject: Co-Op position
Organization: Harris Controls and Compositions
Distribution: usa
Date: Wed, 12 Aug 1992 19:29:43 GMT



******************************************************************************
		HARRIS PUBLISHING SYSTEMS CORPORATION
		   505 N. John Rodes Blvd, Bldg. 1 
		     Melbourne, Florida 32934-9196
******************************************************************************

SOFTWARE ENGINEERING CO-OP POSITIONS

Harris Corporation with annual sales of over $3 billion, is a producer of 
state-of-the-art information processing, communication, and microelectronic 
products for the worldwide information technology market.  Our Publishing 
Systems subsidiary, located in Melbourne FL, is a leading producer of 
Computer Graphic Systems for the newspaper industry.  The evolution of our 
exciting new family of Engineering Workstation and PC-based products for 
interactive Newspaper Layout and Electronic Photo Processing provides a 
number of cooperative education opportunities within our Engineering 
Department.

SOFTWARE ENGINEERING (BUSINESS APPLICATION) CO-OP

In this position you will work with Software Engineers to perform a variety 
of tasks associated with developing and implementing an integrated business 
information system.  You will be exposed to the latest technologies of open 
systems and business management software.  Your responsibilities will include 
database applications programming in SQL (I4GL) to adopt standard software to 
custom needs.  Working knowledge of database concepts is required.  SQL, C, 
and UNIX experience is helpful. 

This assignment will be double block in duration.

Contact Tim Kirk, e-mail tmk@ccd.harris.com or phone (407) 242-4440.
Harris is an equal opportunity employer M/F/H/V

	Experience the difference at Harris Publishing Systems.

******************************************************************************
   
******************************************************************************
Newsgroups: comp.databases.informix
From: neil@salmon.demon.co.uk ("Neil S. Briscoe")
Newsgroups: comp.databases.informix
Subject: Redeclaration of local variables (?)
Date: 21 Aug 92 12:08:05 GMT
Reply-To: neil@salmon.demon.co.uk ("Neil S. Briscoe")
X-Informix-List-ID: <list.1387>

Jonathon,

You wrote:

>>I had the message:
>>ut_merge.c Line 4351 redeclaration of prepare_sel_
>
>This is therefore probably a C compiler error message.  If it came
>from 4GL, the file referenced would be ut_merge.4gl; if it came from
>ESQL, the file referenced would be ut_merge.ec.  Also, the message
>format is more like that used by the C compiler...

Sorry.  Well of course you're right and I new the message was not from
c4gl itself by then, I merely mentioned this so that folks would know
I was working from make and not from the programmers environment.

>In fact, I would expect an error message to refer to the .ec file even
>if the compiler was compiling the C produced from the .ec file...

I would expect that.  But both this version and 4.10.... on the Sparc
always state blah.c.  Only lowly 1.10.00B states blah.ec.

>When you checked the source, did you look at the I4GL code or the generated
>C code?  I would expect your observation to be valid for both, which would
>then indicate a broken C compiler -- however, you don't get many broken
>C compilers on Unix boxes, so it needs more careful scrutiny.

I must admit that so far I've only checked the 4GL.  I fixed this
particular variable by making it global.  The reason I did this was
because it, amongst other variables, were listed in ld's list of
undefined symbols.  I've grepped for all of these variables in the 4gl
code and the objects are in the library.

>Have you tracked down the declarations of prepare_sel_ in the C code?
>Are these internal to the function or external to them?  If internal and
>the compiler is wittering, then you have a seriously defective compiler.
>If external, then we have a question of what is being done on your other
>machines where it does work.  Where are the variables declared on those
>other machines?

Thanks for the hint.  As you might guess, I don't often program in C.

>None of this is a definitive answer, but to give one would need much more
>information than should be sent over the net...

Accepted.  Again, thanks very much.

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