HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.databases.informix
From: neil@salmon.demon.co.uk ("Neil S. Briscoe")
Subject: Support (was Informix I-Net problem)
Date: Fri, 21 Aug 1992 13:17:54 +0000

In article <memo.585538@cix.compulink.co.uk>
shemminga@cix.compulink.co.uk (Stuart Hemming) writes:

>I've found that dealers aren't as helpful as they might be. This
>generally comes from lack of product knowledge on their part.
>
>The problem seems to be that users aren't supposed to take to
>Informix (or distributors) directly, at least not in the UK. Once the
>problem gets progressed up the line that far thinks start to happen.
>Unfortunately this can introduce a delay of up to a couple of weeks
>8-(.

In my opinion (as one who provides application support to our
customers) generally, when I need support myself, my experience ties
in with Stuart's.  Before you get anywhere, there's a question of
"have you got a support number" or at worst "have you had a support
answer from us before?" (this from Informix(UK)).  All this in a
country where we are basically setting ourselves up as a service
providing nation (we've precious little manufacturing left).

Compare this with the American attitude where an article I posted a
couple of days ago generated a response from Jonathon Leffler (I've
lost your email address Jon although I did reply).  No "Have you a
support contract?"  No "How many of our products have you bought?"  He
simply pointed me in the right direction.  (And guess what Jon, on
second and subsequent use of the same variable in a module, this beast
defines it as extern...., but not on the other machines.)

So. Don't let me read anyone criticising Informix Inc.'s support.  Why
should Jonathon (or anybody from informix.com) bother to respond to
stuff posted here.  They're not paid for it.  (Are you?)  On the other
hand, if you want to criticise support that (doesn't) happen on this
side of the duck pond - well, go right ahead.

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
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: Fri, 14 Aug 1992 08:34:32 +0000


[Lots deleted]

> If it's relevent, post it. I would.

Ooops! That was meant to go e-mail. No flames please!
--
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: afataar@casper.cs.uct.ac.za (Aneekah Fataar)
Subject: map SDM model to relational model
Keywords: informix, SQL
Organization: Computer Science Department, University of Cape Town
Distribution: a
Date: Tue, 18 Aug 1992 10:13:07 GMT


 Hi there..

As part of an Honours project I have to convert (map) input from a
semantic database model to a relational model.  The SDM model serves
as the user interface.

I am using Informix with SQL.

Any references or code or ideas will be appreciated  ASAP.

Thanx.

Aneekah Fataar
Honours 1992
UCT
Newsgroups: comp.databases.informix
From: ptm@xact.demon.co.uk (Paul Thomas Mahoney)
Subject: Online 4.10 Dbexport/Dbimport
Organization: X-Act Solutions Limited
Date: Thu, 20 Aug 1992 13:18:00 GMT

I need to move databases about. Unfortunately dbexport does not
record table extent/next extent sizes or the lock mode when it
creates the sql necessary to recreate the exported database.

Has anyone got tools which do it right? When I asked Informix they
said no.
-- 
Paul Mahoney, X-Act Solutions Limited
smail: 20 Shipley Lane, Cooden, Bexhill-on-Sea, East Sussex, TN39 3SR
email: ptm@xact.demon.co.uk ... pmahoney@cix.compulink.co.uk
phone: +44 424 3 6368
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: Mon, 17 Aug 1992 11:19:05 +0000




In article <1992Aug14.223601.8529@informix.com> billd@informix.com
(William Daul) writes:
> PROBLEM:
> =================================================================

[stuff deleted]
> 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).

OK, I'm gonna try this today. Just a point tho'; here is a typical
set of output from netstat -m from first the server:

                 alloc   inuse     total     max    fail
streams:            96      64       253      66       0
queues:            512     368      1786     380       0
mblocks:          2170     223    471846     244       0
dblocks:          1736     223    385916     244       0

and the client:

                alloc    inuse     total     max    fail
streams:           96       57       446      62       0
queues:           512      326      2526     352       0
mblocks:         2170      181    301537     234       0
dblocks:         1736      181    260248     230       0

Both of there sample were take *before I re-tuned the kernel. Don't
these figure suggest that NQUEUE isn't set wrong?
--------------------------------------------------------------
| 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                 | Tel :  (+44) 778 426444       |
| Bourne                     | Fax :  (+44) 778 421862       |
| Lincs PE10 9QL                                             |
| United Kingdom                                             |


Stuart
|8-)
From: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  Redeclaration of local variables (?)
Date: 21 Aug 92 09:53:10 GMT
Reply-To: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
X-Informix-List-ID: <list.1385>

>From: uunet!salmon.demon.co.uk!neil ("Neil S. Briscoe")
>Subject: Redeclaration of local variables (?)
>Date: 19 Aug 92 15:13:41 GMT
>X-Informix-List-Id: <news.1681>
>
>Platform: Sun 3/100, SunOS4.1
>INFORMIX-4GL Version 4.00.UD3 with an INFORMIX-SQL Version 4.00.UD4
>Standard Engine.
>
>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...

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...

>When I checked the source module, prepare_sel_ is a *local* variable
>defined in three separate functions.

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.

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?

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

>Neil S. Briscoe				Telephone: +44 252 376737
>System Administrator			Fax:       +44 252 376644
>                                        Email: neil@salmon.demon.co.uk
>                                               nbriscoe@cix.compulink.co.uk

Yours sincerely,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: chris@visionware.co.uk (Chris Davies)
Newsgroups: comp.databases.informix
Subject: Re: Unknown error 32766 occurs?
Date: 12 Aug 92 16:20:02 GMT
Organization: VisionWare Ltd., Leeds, UK
X-Newsreader: Tin 1.1 PL4


Mike Pechner wrote:
> I have tbeen getting the error "32766" unknown error

A.Heskett@bnr.co.uk (Tony Heskett) replied:
: [...]
: rsh doesn't set up all the environment: bay is our local server, for ex.
: 
: MacStuff 28 > rsh bay env | wc -l
:        5
: MacStuff 29 > env | wc -l
:       37

You could "solve" this if you use a C shell on the remote host (bay),
because rsh will then execute the .cshrc as it logs in.  Thus you place
the setenv INFORMIXDIR /usr/informix (or similar) in your .cshrc (as
well as the more correct .login).  Remember not to put anything that
reads, writes, or modifies a tty in the .cshrc without checking it
really a tty first, though!

Because this is somewhat Unix-centric rather than database oriented
email me (rather than post?) if you want a clarification of this.

Chris
--
            VISIONWARE LTD, 57 Cardigan Lane, LEEDS LS4 2LE, England
  Tel +44 532 788858 x238.  Fax +44 532 304676.  Email chris@visionware.co.uk
---------- "VisionWare:   The home of DOS/SQL/UNIX/X/VMS integration" ---------
From: paulb@p4.cs.man.ac.uk (Paul Bean)
Newsgroups: comp.databases.informix
Subject: paging up and down
Date: 18 Aug 92 14:48:59 GMT

I want to be able to page up and down in an input array using more
than one key.  e.g. F3 and control-p.  The behavior on the defined key
is exactly what I want, however I do not seem to be able to find the
internal function which does this so that I can us the on key facility
within the input array.  I am aware of the scroll function, but this
does not appear to reset the cursor as obtained by arr_cur().  I
cannot seem to find a function to set the position within the array so
scroll seems to be a insufficient for what I need.  Also Options
allows only one key to be assigned to key down etc. so I can't simply
redefine it there.  There is probably somthing really obvious that I
have missed sorry if this is the case.

Thanks in advance 

Paul B
From: A.Heskett@bnr.co.uk (Tony Heskett)
Newsgroups: comp.databases.informix
Subject: Re: conditional select sum() based on field question
Date: 13 Aug 92 19:48:08 GMT
Reply-To: A.Heskett@bnr.co.uk (Tony Heskett)
X-Informix-List-ID: <list.1377>


Pete Frehner writes:

> [ ... add or subtract according to record type, only scan table once ... ]

>    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 

Call me stupid (go on, I'm waiting  :-)  but why don't you just
do this ?    Is a cursor *much* slower ?

      declare a_curs cursor for
         select amount, order_type
            from orders
            where order_type = "CREDIT"
               or order_type = "REG"
    
      fetch a_curs into amt, ord
    
      while status = 0
     
         if ord = "CREDIT"
            net_amount = net_amount + amt
         else
            net_amount = net_amount - amt
    
         fetch a_curs into amt, ord
    
      end while
    
      close a_curs

Incidentally, does anyone else miss not having += -= and friends ?
COBOL-fingers, here we come ...

> 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           

Cheers - Tony.
_________________________________________________________________________
Tony Heskett                 th@bnr.co.uk       Phone: (+44) 279 402637
BNR, London Road, Harlow, Essex  CM17 9NA       Fax:   (+44) 279 451434
Newsgroups: comp.databases.informix
From: ktran@bogart.uucp (Kim Tran)
Subject: How to clear a field in a multiple table form?
Organization: ism:c:m/xo
Date: Tue, 11 Aug 1992 12:20:48 GMT

  
   Hi everybody,
  
  Last Tuesday, August 4, 1992, I sent a message to ask for help.  So far I 
  have not got any feedback yet.  Let me repeat my problem.  Thanks
  for any suggestions or hints.
  
  I have a form with 2 tables:
       - payment
       - partner
  
                       Payment Screen
   
  Payment_EIN     [f000]
  Partner TIN     [f001]      Partner Type [p1]
  
  Tables
     payment
     partner
  
  Attributes
     f000 = payment_table.EIN;
     f001 = partner_table.tin = payment_table.tin, queryclear;
     p1   = partner_table.type, queryclear;
  
 When I query and hit escape, all the values appear in the appropriate
 fields.  But when I hit query again, the partner type field is not cleared
 although I use "queryclear" in the attribute section.  I tried:  before
 edit, before add, before query and after edit, after add, after query but
 it didn't work.
  
 Anyone knows a way to get the partner type field cleared?  One more time
 thanks for any suggestions or hints.
  
     Kim Tran
From: billd@informix.com (William Daul)
Newsgroups: comp.databases.informix
Subject: PRESS RELEASE:  INFORMIX SOFTWARE EXPANDS OPERATIONS IN MEXICO
Date: 13 Aug 92 23:01:07 GMT
Organization: Informix Software, Inc.
Originator: billd@cheetah

INFORMIX SOFTWARE EXPANDS OPERATIONS IN MEXICO

Company To Support Four Authorized Distributors

MENLO PARK, Calif. (August 12, 1992)   Continuing its expanding sales and
support in the Mexican marketplace, Informix Software Inc. (NASDAQ:INFX) has
announced the recent opening of its newest office in Mexico City, Mexico. The
new office will enhance InformixUs sales and technical services to its customers
in Mexico and to its four authorized distributors:  MPS Mayorista S.A.; Triple I
Sistemas del Informacion, S.A.; Genesistemas, S.A.; and Multisistemas S.A.

"With the upsurge of Informix business in Mexico and Latin America, it is
essential we provide better support to our customers and distributors," said
Phil White, CEO and president of Informix. "By providing a direct local
presence, we will ensure continued success to our end-user customer base. This
will ultimately help us deliver the right products and customer services to the
Latin American marketplace." 

Currently Informix is providing leading information management solutions to a
variety of industries in Mexico and to such customers as Comision Federal de
Electricidad (CFE), Ferrocarriles Nacionalies de Mexico, Instituto de Seguridad
y Servicios Socales de los Trobajadores del Estado (ISSSTE), Nacional Monte de
Piedad, Petroleos Mexicanos (PEMEX), Seguridad Nacional, Technologico de
Monterrey and Telefonos de Mexico (TELMEX).

In addition to the office in Mexico, an office in Brazil is also planned to open
in late 1992.

About Informix
Informix Software, Inc. is a leading supplier of information management software
providing solutions from the database through the desktop.

Informix products include powerful distributed database management systems,
robust application development tools, and graphical- and character-based
productivity software for delivering information to every significant desktop
platform.

Headquartered in Menlo Park, Calif., Informix also has European headquarters in
London, and Asia/Pacific headquarters in Singapore.
###
-- 

-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
 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: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: porting a database to ano
Reply-To: shemminga@cix.compulink.co.uk
Date: Mon, 17 Aug 1992 08:47:00 +0000


In article <199216.2231.1476@execnet> clay.irving@execnet.com
(clay irving) writes:
> ->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?
--------------------------------------------------------------
| 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                 | Tel :  (+44) 778 426444       |
| Bourne                     | Fax :  (+44) 778 421862       |
| Lincs PE10 9QL                                             |
| United Kingdom                                             |


Stuart
|8-)
From: "clay irving" <clay.irving@execnet.com>
Newsgroups: comp.databases.informix
Subject: can not sort rows
Date: 21 Aug 92 18:40:27 EST
Reply-To: "clay irving" <clay.irving@execnet.com>
Distribution: comp
Organization: Executive Networks Information

We've written a I-4GL program to process an order table contain 17,000 
rows. The table is being joined to several other tables.  There is a good 
amount of substring manipulation and temporary tables.  We receive a 
message "Can not sort rows" -- "System error -5".  An Informix SE 
indicated that temporary tables are being built in rootdbs, regardless of 
the dbspace the working database is in.  I added a 100MB chunk to rootdbs 
and a 150MB chunk to the working dbspace, but I still get the same error 
message. I hate to keep throwing disk space at the problem until it 
<hopefully> goes away -- Does anyone have an idea what's going on and a 
possible solution?
====================================================================
Clay Irving                     garpac!clay@uu3.psi.com (temporary)
Project Mgr                     clay.irving@execnet.com (personal)
Garpac Corp                     75170.107@compuserve.com (CIS)
====================================================================



---
  WinQwk 2.0 a#480  As easy as 3.1415926535897932384626433832795028841.
--
Executive Network Information System  (914) 667-4567
International ILink Host
From: Steven.J.Richardson@um.cc.umich.edu
Newsgroups: comp.databases.informix
Subject: Raw Partition V/S File for Database -- Opinions Please.
Date: 18 Aug 92 02:28:07 GMT
Reply-To: Steven.J.Richardson@um.cc.umich.edu
X-Informix-List-ID: <list.1381>

Raj:
 
  Upon the advice offered by either the Informix manuals or the Informix
Sys. Admin. course, our adminstrator set up our Informix systems on RS/6000s
to use raw disk.  I believe that the UNIX filesystem overhead was supposed 
to get in the way, but don't take my word for it.
 
  Steven J. Richardson/Merit Network, Inc.
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: porting a database to ano
Date: 20 Aug 92 04:57:27 GMT
Organization: Enterprise Technology Center, Informix Software, Inc.

In article <1992Aug19.152425.24080@informix.com> davek@informix.com (David Kosenko) writes:
>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).  

Perhaps you're thinking of Tbimport and Tbexport, Dave?  
dbimport and dbexport do indeed ship with SE...


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

 "These tests will have no effect on your grades.  They will merely
  determine your future social status and financial success, if any."
            - Matt Groening
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Shell Archive
Date: 13 Aug 92 02:18:03 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1374>

Quoting Doimic01@saad-emh1.ARMY.MIL...
> 
> Several of you have used something called "shell archive" (shar)
> to send code through e-mail.  We currently have a requirement to
> send sql command files, 4gl code, and per screens through e-mail.
> Is shar a share-ware routine, or did you purchase it commercially,
> or was it included with your version of Unix?  We really don't want
> to create our own shell archive if it already exists.  Tanks!
> 
There are several shell archivers available via anon-ftp/anon-uucp.  I
prefer shar-3.49 because it has the ability to compress and uuencode
rather than me doing it.

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: conditional select sum() based on field question
Date: 13 Aug 92 20:18:48 GMT
Reply-To: cortesi@informix.com
Organization: Informix Software, Inc.

> In article <297@praeda.UUCP.UUCP> pete@praeda.UUCP.UUCP (Pete Frehner) asked:
> >
> >I have a question regarding selecting a sum from a table of amounts and
> >depending upon the type of record, either adding or subtracting the amount
> >from the sum...I could do this in two select statements...  
> >   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?

In article <1992Aug13.003128.8803@informix.com> proberts@informix.com
(Paul Roberts) supplied a very clever answer:
> 
> create a temp table called "fudge" and put exactly
> two rows into it, like so:
>      char(6)       smallint 
>     order_type     f_factor
>     ----------     --------
>       REG             1
>       CREDIT         -1
> 
> and then do this select:
> 
> select sum(orders.amount * fudge.f_factor)
>   from orders, fudge
>  where fudge.order_type = orders.order_type
> 

This is exceedingly clever, but what strikes me is how it
generalizes to the application of any kind of "weight" against
any set of categorized "samples."

In this case the "samples" were money; there were just two 
"categories," and the "weights" were +/- 1 -- but that is
not inherent.  This is a general technique that can apply
arbitrary weights based on an arbitrary number of categories.

For one other commercial example, let the weights be a
series of numbers between 0 and 1 representing state
sales tax percentages, and let the categories be names of
states. Now you can sum the sales tax due on a column of
retail prices with one select.  Or, multiply by 1+weight
to sum the prices including tax. 

Or let the amounts be shipping weights; let the categories
be delivery zones; let the weights be shipping charge
per-pound multipliers.

And of course the "samples" and "weights" could actually be
samples and weights in a statistical sense.