HDTenEightyP/NetNews huggingface dataset:
From: andy@cmptrc.lonestar.org (Andy Hart)
Subject: interrupting reports
Date: Tue, 1 Sep 1992 17:52:35 GMT
Distribution: USA
Organization: CompuTrac Inc., Richardson TX
Keywords: informix report interrupt int_flag


    Can someone help with this, pls?

    How does one interrupt an I-4GL report?  For instance, why doesn't
    this work?

    ...
    FOREACH cursor INTO variable
      IF int_flag THEN 
	EXIT FOREACH
      ELSE
	OUTPUT TO REPORT blahblah
      END IF
    END FOREACH
    FINISH REPORT
    ...

    Actually, I've tried placing the test for the interrupt in various 
    locations and have tried putting a FINISH REPORT statement in the 
    TRUE clause of the IF, etc.

    The only way I have now of interrupting a report is to wack it on the
    head with a QUIT signal.  Do I need to defer the QUIT interrupt and 
    trap for that, then turn it back on when I'm done.  (Actually, I just
    thought of this as I typed this message, so I'll go try that now...)

    Thanks!
                  Andy

-- 
+--------------------------------------------------------------------+
|   Andrew Hart                   |  CompuTrac, Inc.                 |
|   (214) 234-4241                |  222 Municipal Drive             |
|   andy@cmptrc.lonestar.org      |  Richardson, TX  75080           |
+--------------------------------------------------------------------+
Newsgroups: comp.databases.informix
From: andy@cmptrc.lonestar.org (Andy Hart)
Subject: Re: Report Writer Tools IQ and FOURGEN
Date: Fri, 28 Aug 1992 16:14:43 GMT
Distribution: USA
Organization: CompuTrac Inc., Richardson TX

 So, how does one obtain db4glgen-3.7?  I used the FOURGEN product for 
 a couple of weeks and was not too satisfied with it.

 Also... Any recommendations for report generators?  I'm looking for 
 something that we can integrate well with the applications we're developing.
 By "integrate well" I mean that our apps finds stuff and puts it into 
 temp tables.  I'd like something that we can use to let users (or us) 
 predefine reports, let them select from a list of predefined reports and 
 then generate the selected report from the rows selected into our temp table.

 ALSO.. (while I'm at it!) What's the recommended method of supporting 
 "slave" terminal printers?  My first inclination is to write some sort of 
 little filter program that will open the external port on the HP terminal 
 and then accept input piped to it from our 4gl app and output to the 
 attached terminal printer.  Any support for specific printer types would
 be localized in the filter program?  

 Does someone have a better way?  Way better, does someone already have
 something redistributable that does this?

 thx.
       andy

-- 
+--------------------------------------------------------------------+
|   Andrew Hart                   |  CompuTrac, Inc.                 |
|   (214) 234-4241                |  222 Municipal Drive             |
|   andy@cmptrc.lonestar.org      |  Richardson, TX  75080           |
+--------------------------------------------------------------------+
From: mm@ssf.pt (Manuel Monteiro)
Newsgroups: comp.databases.informix
Subject: doretalloc()
Date: 3 Sep 92 19:48:03 GMT
Reply-To: mm@ssf.pt (Manuel Monteiro)
X-Informix-List-ID: <list.1427>

Hi there netters,

Can anyone out there, pleeeeeease, tell me the exact (formal)
behaviour of the 'doretalloc()' function of the 'lib4gl' library?

Is this function supported by informix?

PS: sorry if this is a RTFM question!
Thx.

MM

-------------------------------------------------------------------------------
| Manuel Figueiredo Monteiro                                                  |
| S.S.F. - Servicos de Software Financeiro, Lda     VOICE: +351 (1) 727-0303  |
| Estrada da Luz, No 104 - Loja A                   FAX:   +351 (1) 727-0335  |
| 1600 Lisboa                                       E-MAIL: mm@ssf.pt         |
| PORTUGAL                                                                    |
-------------------------------------------------------------------------------
From: john@mks.com (John Postma)
Subject: Southwestern Ontario Informix Users?
Keywords: Contacts
Organization: Mortice Kern Systems Inc., Waterloo, Ontario, CANADA
Date: Wed, 26 Aug 1992 15:20:46 GMT

Hi,
I am a database administrator for a software firm in Southwestern Ont.,
Canada, and I would like to meet or talk to other informix users in the
area to discuss ideas regarding how they are implementing info systems, 
what third party software packages they might be using or recommend, etc. 
Is there a database user's group or Informix user's group in the area?
(I live in Kitchener/Waterloo).  In any event I'd be interested in meeting
or talking with someone in the area to compare notes on our respective 
systems and share ideas and experiences that might mutually benefit us
in bettering our info systems.

-- John Postma
-- 
    /||  // // ,'/""\'   John Postma	         john@mks.com  (519)884-2251
   / ||/// //\' `\\\     Database Administrator,   Mortice Kern Systems Inc.
  /  |/ /_//  \\___/     35 King St. N., Waterloo, Ont., Can. N2J 2W9
o/   "Things are only impossible until they're not!" -- Capt Jean Luc Picard
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: Heading toward 4GL++
Date: 3 Sep 92 19:41:21 GMT
Reply-To: cortesi@informix.com
Organization: Informix Software, Inc.

In article <1992Sep2.174618.3753@bjudev.UUCP> mfox@bjudev.UUCP (Mike Fox)  
writes:
> I would like to structure the code in development so that the transition to
> Informix 4GL++ is as smooth as possible.  Does anyone have an idea what 
> Informix is planning to do in this area?

Quite a bit was said about future directions for 4GL at the Informix
User Conference in July. Working within the bounds of what was said
there, it would be fair to say that 4GL is going to be enhanced into
a very sound, very conventional, object-oriented programming language.

For example, if you know Pascal and can follow how Apple migrated that
language smoothly into Object Pascal, you have the concept (not
to say the feature sets are the same; they are not).

But you can pick up any of the 100's of books about OO design
and OO programming and start reading, because sound design for *any*
OO language will also be sound design practice for 4GL.

It is said that you can "do" OOP in any language, even
assembler.  So in fact you can start designing 4GL apps
using OOD techniques right now. There is a definite
"object-oriented frame of mind" that you need to acquire
in order to exploit this technology, but you don't have to
wait for 4GL to begin getting into that frame of mind.

> For example we could at the present time conceive of an "object" as 
>  
>           a module of code  ----|
>           a table  -------------|--   together, an object
>           a form   -------------|
> 
> I know this isn't strictly an object since any table cannot be bound to a
> certain piece of code. Nevertheless it does begin to imitate an object in
> that it has an entity (table) and its behavior (code). The so-called objects
> would be reusable among programs. 

You have the general notions, or at least the buzzwords, so you have
begun reading the right books.  You might want to think less in terms
of "modules" of code and more in terms of functions. A "behavior"
is a function; a "module" is a convenient grouping of source lines but
is not a good design unit.

I can say from experience that the more practice you get in applying
the techniques of "abstraction" and "encapsulation," the better.
From: "clay irving" <clay.irving@execnet.com>
Newsgroups: comp.databases.informix
Subject: informix support
Date: 31 Aug 92 20:46:45 EST
Reply-To: "clay irving" <clay.irving@execnet.com>
Distribution: comp
Organization: Executive Networks Information

I've been reading a juvenile thread (I have my asbestos suit on 
waiting for the flames!) about Informix Support. I pay for Informix 
Support and I use it very infrequently. But the times I have needed 
support from Informix, I have always been pleased with the knowledge of 
the Tech Support staff and the results of my call!

I had a problem about ten days ago. It wasn't a serious problem -- just 
something I couldn't figure out... I called Tech Support and received the 
answer to my question within five minutes. It turned out to be the correct 
answer!

So... I really don't understand all this crap about Informix support. My 
marketing rep is ALWAYS there when I need him, my contact in Lenexa is 
ALWAYS there when I need him and Tech Support is ALWAYS there when I need 
them. Not to mention all the Informix employees that frequent the net and 
ALWAYS donate suggestions and tips!

Now, I'll step down from my soapbox.

==================================================
Clay Irving                garpac!clay@uu2.psi.com
Project Manager            clay.irving@execnet.com
Garpac Corporation        75170.107@compuserve.com
+1.212.760.0079 (voice)       +1.212.564.2635 (fax)
 --------------------------------------------------
254 West 35th Street, New York, New York 10001-2566
===================================================



---
  WinQwk 2.0 a#480  We now return to our regularly scheduled flame-throwing.
--
Executive Network Information System  (914) 667-4567
International ILink Host
From: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  can not sort rows
Date: 25 Aug 92 23:23:07 GMT
Article-I.D.: emory.9396
Reply-To: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
X-Informix-List-ID: <list.1399>


Clay,

You don't say which version of I4GL you are using.  Actually, its more relevant
to ask which version of which engine are you using on which machine?

If you have Version 4.10 or above, the engine is probably using the Unix
file system indicated by DBTEMP to do the sorting in.  You can prove whether 
this is the case by looking for files with names which start srt in the 
relevant directories.  If so, you probably need to transfer some of the extra
250 MB of disk space from the raw partitions to the Unix file system.

Yours helpfully, maybe,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: cheryl@redriverad-emh1.army.mil (Cheryl Gross)
Newsgroups: comp.databases.informix
Subject: Informix Phone Numbers
Date: 2 Sep 92 03:03:10 GMT
Reply-To: @emory.mathcs.emory.edu


X-Office:                  
Dsn:                   
X-Informix-List-Id: <list.1422>


As of:  Nov 29  1989  which is the last date we updated these phone numbers:

            INFORMIX 

  TECH SUPPORT    1-800-274-8184
           FAX    1-415-926-6626

You must have a valid serial number and maintenance agreement to get a 
response.

These numbers may not be valid now.
From: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  TPC and Informix
Date: 28 Aug 92 11:48:03 GMT
Reply-To: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
X-Informix-List-ID: <list.1408>

>From: uunet!baloo.ee.byu.edu!kelly (J. Kelly Flanagan)
>Subject: TPC and Informix
>Date: 27 Aug 92 15:29:21 GMT
>X-Informix-List-Id: <news.1721>
>
>	How simple is Informix to install on a 486 machine running
>	UNIX?  I can run Interactive SYSV R3.2 or DELL UNIX SYSV R4.

    Very.  As root, use cpio (or possibly tar) to extract product off
    distribution media into directory where product will live --
    /usr/informix is the normal place.  Then run the install script
    (./installsql, ./installstar, or whatever) to brand the product.
    End of installation.

    If you are commissioning OnLine and want to use raw disks (a good
    idea), then you need to know how to set up a raw partition which
    is not being used by Unix.  This can be tricky to do
    retrospectively -- but it is a problem with Unix rather than
    Informix per se.

>	I keep hearing about tuning the database, is this required?
>	How difficult is this to do?

    It depends on the engine.  Standard Engine is not very tunable --
    it is simple to install and largely idiot-proof.  OnLine is
    considerably more complex and does benefit from tuning, though
    even untuned configurations work, often surprisingly well
    considering...  More important, in general, is tuning the database
    design, and the way the application uses the database.  As many
    performance problems are due to poor application design as they
    are to engine performance.

>	Will the TPC-A and TPC-B benchmarks run on Informix?  Has
>	anyone done it that could share their code with me?

    Of course they do.  I don't have shareable code, I'm afraid.  Are
    you sure you want to do TPC-A on a 486?  The difficulty with TPC-A
    is the terminal handling rather than the database handling.

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: walt@mathcs.emory.edu (Walt Hultgren {rmy})
Newsgroups: comp.databases.informix
Subject: Mailing list & gateway down 8/28-8/30
Date: 27 Aug 92 17:40:10 GMT
Organization: Emory University

The system rmy.emory.edu will be down for most of this weekend (beginning
late Friday, Aug 28) while we rearrange some equipment.  We hope to be back
up no later than Monday, Aug 31.

This system is the home of the Informix mailing list and the gateway between
the list and comp.databases.informix.  Messages sent to the list or through
the gateway, or replies routed through rmy, will be delayed but should not
be lost.

If we are down longer than we anticipate, there is a chance that messages
arriving here early in the weekend will time-out and bounce.  If this occurs,
or if anything else weird happens, wait for a couple of days for things to
smooth out before resending.

An alternate address for me, <walt@mathcs.emory.edu>, should continue to work
while rmy is down, in case you need to reach me.

Thanks,

Walt.

-- 
Walt Hultgren              Internet: walt@rmy.emory.edu       (IP 128.140.8.1)
Emory University               UUCP: {...,gatech,rutgers,uunet}!emory!rmy!walt
954 Gatewood Road, NE        BITNET: walt@EMORY
Atlanta, GA  30329  USA       Voice: +1 404 727 0648
Newsgroups: comp.databases.informix
From: judym@col.hp.com (Judy Miller)
Subject: INFORMIX CUSTOMER SUPPORT LINE?
Date: Tue, 1 Sep 1992 23:09:47 GMT
Organization: HP Colorado Springs Division

What's the phone number of the INFORMIX CUSTOMER SUPPORT LINE?

Judy
From: mtrotter@magnus.acs.ohio-state.edu (Mark L Trotter)
Newsgroups: comp.databases.informix
Subject: HELP! Trying to UPDATE temp table HELP!
Summary: A nasty compile bug with updating temp tables
Keywords: update, 4gl
Date: 4 Sep 92 18:42:19 GMT
Article-I.D.: magnus.1992Sep4.184219.11503
Organization: The Ohio State University


Hi fellow netters!
   I am trying to create a temporary table, insert some elements from
another table, then go thru the temporary table using a cursor and 
do some updating of other elements.  All works except:
   1. I can't DEFINE a memory record LIKE the temporary table because
      it doesn't exist at compile time so I assume I must define the
      entire memory record via listing all of the elements, but if I do
      that then: 
   2. I can't UPDATE the temporary table using 
       UPDATE temptablename SET temptablename.* = memrecord.*
      because I get a compile error saying that memrecord was not
      defined using the RECORD LIKE phrase.

Is this a know bug and is there any workarounds?
By the way, I'm on 4GL version 4.0, OnLine engine and HPUX 7.0.
Thanks for any help!!!!
!------------------------------------------------------------------------!
! "In these uncertain times, one must think of others' viewpoints, and   !
! always remember that a crowded elevator smells different to a midget." !
!        Mark Trotter @ The Ohio State University Graduate School        !
!     voice 614/292-6031  FAX 614/292-3656  BITNET trotter.1@osu.edu     !
!------------------------------------------------------------------------!
Newsgroups: comp.databases.informix
From: W10075@maccvm.corp.mot.com (Stephen Weet)
Subject: Re: 4GL, Make & SCCS
Organization: Motorola
Date: 4 Sep 1992 09:40:17 CDT
From: sford@oregon.wvus.org (Scott Ford)
Newsgroups: comp.databases.informix
Subject: Physical and Logical Recovery (fwd)
Date: 26 Aug 92 23:18:05 GMT
Article-I.D.: emory.9403
Reply-To: sford@oregon.wvus.org (Scott Ford)
X-Informix-List-ID: <list.1404>

According to Naomi Walker:
> 
> The Informix log shows that OnLine was initialized, Physical recovery
> started, and completed, restoring 648 pages.   For six hours after
> that, dots flew across the screen, over and over and over again.
> It appeared to be reading, maybe something again and again.  Logical
> Recovery never completed.  The engineer on site finally aborted the
> logical recovery and restored via archives (owwwwww!).  
> 
> I remember when 4.0 had a problem in recovery when the logs were filled,
> and it looked the same way.  One time, Informix was able to patch 
> something it looked like there was nothing in the Logical logs, and the
> system came back up.
> 
If it's not the age old log problem, perhaps it is what we recently
encountered.  We were building (correction, attempting to build) an index
on a very large table (no transactions in db - don't even think about
that for an index build like this).  For an unrelated reason, the machine
crashed.  Upon recovery, physical recovery was done quickly and logical
(i.e. "*fast*") recovery took 20 hours.

It turns out that this is a bug fixed under 4.10.UF (or UG or UH, not
sure) regarding the way a create index rollback is handled.  The reason I
don't know the level is that we're 4.10.UD and are currently working on
installing 5.0, so I've no compunction to get the upgraded 4.1 at this
juncture -- might want to check with your Informix contact..

If it's not this nor the infamous, "sorry your logs are already full"
problem, we haven't encountered it.


Scott Ford, DBA        |  sford@wvus.org                      
World Vision USA/ISD   |  elroy.jpl.nasa.gov!wvus!sford    
919 W. Huntington Dr.  |  Voice: 818/357-1111 x3333       
Monrovia, CA  91016    |  FAX:   818/303-6212            
                                                        
          "...The bozone layer: shielding the rest of the solar
                system from the earth's harmful effects...."
Newsgroups: comp.databases.informix
From: chris@hawkesbury.uws.EDU.AU (Chris Thompson)
Subject: Mosaix
Summary: Mosiax new dev language GUI images
Keywords: language NEW
Organization: University of Western Sydney
Date: Fri, 28 Aug 1992 02:28:52 GMT




				MOSAIX

I have heard of a product which has not got much press - seems OK
It's called 'Mosaix' from

Mosaix Marketing Pty Ltd
Attn Bill Dalgliesh
L1, 170 Pacific Hwy
Greenwich NSW 2065
Australia
(61)02-9013199
(61)02-9013493 Fax


Abstract:

The Mosaix ADL, ( Application Development Language) is a high  level language
designed to enable rapid development of graphics based applications in an X-
windows environment using object oriented methodologies. Mosaix provides a
graphical user interface toolkit, links to proprietary databases, integration of
raster and vector data, multimedia support and real time event handling.

Comment:
	Seems to offer a reasonable runtime price and for Uni's a reasonable
price for development. Would suit Sun environment. Language is written in 'C'
with its own syntax and lots of inheritable goodies.

Please contact  Bill Dalgliesh for further info.

Kind Regards
c.thompson@uws.edu.au
Newsgroups: comp.databases.informix
From: ppascoe@bjudev.UUCP (Phillip Pascoe)
Subject: Informix & Data General hardware performance
Organization: Bob Jones University
Distribution: na
Date: Wed, 26 Aug 92 14:33:32 GMT

Hello,
	We are evaluating several machines for use in an Informix On-Line
environment.  The environment is a University setting with a rather large
database and OLTP requirments with most of the traffic coming in over a
campus network.  The DG Avion 6240 platform is one of the ones under
consideration.  Does anyone have any experience with Informix On-Line on
this platform in an OLTP environment that they are willing to share?  Has
the machine met your performance expectations? Are you pleased with DG's
support (Hardware ___, Software ___)?  Any great features in the OS? Any
major flaws in the OS?  Thanks for your help!

Please email responses.
-- 
-----------------------------------------------------------------------------
 Phillip Pascoe              Bob Jones University              Greenville, SC 
 uunet!bjudev!ppascoe                                    Opinions are my own.
-----------------------------------------------------------------------------
From: cheryl@redriverad-emh1.army.mil (Cheryl Gross)
Newsgroups: comp.databases.informix
Subject: ESQL/C 2.1 to 4.1 conversion problem correction
Date: 2 Sep 92 01:33:15 GMT
Reply-To: cheryl@redriverad-emh1.army.mil
X-Informix-List-ID: <list.1421>

Dave,

Thanks for correcting my mistake in the description of my problem.
Was trying to hurry.  It is described in my program as you stated with 
the char in it.  Thanks for pointing out that mistake.

(I said it was working in 2.1) but when I typed the description
of my problem I didn't copy code but HAND typed which usually
gets me in trouble.

Thanks

Cheryl Gross
From: alfonso@mtecv2.mty.itesm.mx
Newsgroups: comp.databases.informix
Subject: Help needed with errors -242 and -211
Date: 25 Aug 92 20:33:01 GMT
Reply-To: alfonso@mtecv2.mty.itesm.mx
Distribution: alt


  I'm running an application under Informix On-Line 4.0 under AIX 3.1 on
an IBM-RS/6000.
  The program works fine, but sometimes, without being a special condition, I get this error:

  SQL error -211
  Cannot read system catalog (systables)
  SYSTEM error -101
  File is not open.

  Once I got a similar error, (error -211) and instead of "can not read system catalogue" was "cannot read database.table".

  Why is this happening. I read in another message about the possibility of
this being a bug. Can anybody help me? Is there something that can be do changing the configuration of my On-Line System?

  Thanks in advance.

  Alfonso

  alfonso@mtecv.mty.itesm.mx
  ITESM
Newsgroups: comp.databases.informix
From: lpc@dickens.com (Luis P Caamano)
Subject: Re: Informix I-Net problem
Date: Thu, 27 Aug 1992 17:44:05 GMT
Organization: Dickens Data Systems, Inc.

In article <memo.594498@cix.compulink.co.uk> shemminga@cix.compulink.co.uk writes:
>
>This may seem like a dumb question but I understand the entry that is
>made in /etc/services is to allow tcp/ip to make connections. Would
>having more than one entry mean that I could have more connections?
>

No. /etc/services only maps a service name to a well known port
number that is needed to make the connection.

When making a connection to a server, the client must specify the
port number to TCP so it knows to which process (server) it should
give the packets to.  Instead of coding the number in the code, the
client finds out what number to use at runtime.  You can change the 
port number as long as it is the same on the server and client machines.

This is necessary to avoid port number conflicts, e.g. Informix decides
to use port number xxxx for Inet and then you install I-Net on a
machine that has another application using the same port number. 
Obviously, it won't work.

For more info on port numbers and /etc/services consult the Unix
networking bible, R.Stevens's "Unix Network Programming."

-- 
---------------------------------------------------------------------------
Luis P. Caamano                    |         lpc@dickens.com
Dickens Data Systems, Inc.         |         uunet!dickens.com!lpc
Atlanta, GA                        |         (404) 475-8860
---------------------------------------------------------------------------
If I think I know it all, I'll stop learning. -myself
The more I learn, the more I know I know nothing. -somebody else
Newsgroups: comp.databases.informix