HDTenEightyP/NetNews huggingface dataset:
From: mfox@bjudev.UUCP (Mike Fox)
Subject: Heading toward 4GL++
Organization: Bob Jones University
Distribution: na
Date: Wed, 2 Sep 92 17:46:18 GMT

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

However thinking and developing this way may not be what Informix is planning.
If you have more on this then I thank you for sending it.

uunet!bjudev!mfox
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Report Writer Tools IQ and FOURGEN
Date: 26 Aug 92 00:28:08 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1401>

Quoting Ruchi Patel...
> 
>                                   We are also interested in getting the
> FORM PAINTER and 4GL code generator that is also offered by FOURGEN.
> 
I'm sorry, I can't help it... I have this urge !!!

Try db4glgen-3.7 the code generated is vastly superior to the code generated
by Fourgen and it's free (end plug).

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: walt@mathcs.emory.edu (Walt Hultgren {rmy})
Newsgroups: comp.databases.informix
Subject: Re: List Server
Date: 28 Aug 92 13:46:56 GMT
Organization: Emory University

In article <memo.598476@cix.compulink.co.uk> shemminga@cix.compulink.co.uk
writes:
>
>Is there a listserver for informix products [...]

To my knowledge, there is no site where you can get actual Informix products
in the same way that you can get Apple products from ftp.apple.com. The
following listing may be of some interest, though.

If you come across any site not on this list, please let me know.

Thanks,

Walt.

------------------------------------------------------------------------------

Informix Archive Sites

Last Changed:  June 9, 1992


The following is a list of sites known to contain Informix-related archives
or files.  Included with each is a brief description of the archive contents
and how to obtain more information.


das13.snide.com

    Utilities for ISQL, ESQL/C and I4GL developed by Dave Snyder, who also
    maintains the archive.  Accessible by mail server and anonymous UUCP.
    Send mail to "archive-server@das13.snide.com" with the word "help" (w/o
    the quotes) as the Subject:.  Leave the rest of your mail blank.


mathcs.emory.edu   (IP 128.140.2.1)

    Utilities, documentation and past messages from the Informix mailing list
    and the Usenet newsgroup comp.databases.informix.  Also mirrors many of
    the files on das13.  Accessible by anonymous FTP.  Get the files "README"
    and "ls-lR" in the directory /pub/informix.


mcsun.eu.net   (IP 192.16.202.1)

    Past articles from comp.databases.informix and gatewayed informix-list
    messages kept in /newsarchive/comp/databases/informix.  The file INDEX
    in that directory contains a list of Subject lines.  Accessible by
    anonymous FTP.


InformixLink

    An on-line electronic information service offered by Informix Software,
    Inc., for a subscription fee.  Contains bug lists, workarounds, technical
    tips, product and marketing information.  Interactive dial-up access only.
    Call +1 800 331 1763 (USA) or your local Informix Software representative.


For a more detailed listing, get the file "/pub/informix/doc/archives" from
mathcs.emory.edu.  Please send any corrections or addition to this information
to walt@mathcs.emory.edu.

-- 
Walt Hultgren             Internet: walt@mathcs.emory.edu   (IP 128.140.2.1)
Emory University              UUCP: {...,gatech,rutgers,uunet}!emory!walt
954 Gatewood Road, NE       BITNET: walt@EMORY
Atlanta, GA  30329  USA      Voice: +1 404 727 0648
Newsgroups: comp.databases.informix
From: andy@cmptrc.lonestar.org (Andy Hart)
Subject: Re: interrupting reports
Date: Wed, 2 Sep 1992 03:40:39 GMT
Distribution: USA
Organization: CompuTrac Inc., Richardson TX
Keywords: informix report interrupt int_flag

  Er... I realize now that you must defer quit in the main routine and 
  cannot switch it back on.   :^<            

  Thanks to all who responded to my request for HP termcaps.  I'm still
  looking for one that supports Informix line drawing char set well.

  ...And report generator suggestions.

  And what's the deal with flat file I/O?  I presume you must use the 
  standard C library routines?  Suggestions for managing 4GL code size?
  Strategies for managing code structure for large-scale programs? 
  I-4GL seems to encourage global variables, which I hate.  

  Keep in mind that I've only been using the product (and Unix, for that
  matter) for a few weeks, but there sure are some frustrating quirks to  
  the language.  (Since I have just expressed a personal opinion, I issue
  "standard" disclaimer: my opinion only.  I do like Informix.)

  Thanks...
		Andy

-- 
+--------------------------------------------------------------------+
|   Andrew Hart                   |  CompuTrac, Inc.                 |
|   (214) 234-4241                |  222 Municipal Drive             |
|   andy@cmptrc.lonestar.org      |  Richardson, TX  75080           |
+--------------------------------------------------------------------+
From: andy@cmptrc.lonestar.org (Andy Hart)
Subject: HP Terminals & Informix
Date: Tue, 25 Aug 1992 15:55:59 GMT
Distribution: WORLD
Organization: CompuTrac Inc., Richardson TX
Keywords:  HP TERMCAP 70092 70094 2392A Informix 4GL


HELP!  I've already posted a similar message to comp.terminals, so I'll be
brief here:

I'm developing an application using I4GL on an HP9000/837.  We have 70092,
70094, 2392A terminals, as well as PCs running ADVLINK or REFLECTIONS.

Informix only supports termcap on HP, HP only supports terminfo.  The hp 
termcap entry we have is poor.  I've set up the gs,ge,and gb attributes per
the informix manual.  The problems I have are:

1)  Line drawing mode not working properly.  When a window is opened and 
    closed, any text underneath the window border are left "trashed" in 
    alternate character set.

2)  When displaying standout mode (reverse video) inside a bordered window, 
    "holes" get punched into the right side of my window border on any line
    that contains standout text.

3)  I would like to remap the accept key from the default to (hopefully) the 
    block enter key on the keypad.

I'm under a tight deadline and ANY ANY HELP at ALL will be GREATLY appreciated!
Please respond via email.

Thanks.

-- andy                    (andy@cmptrc.lonestar.org)
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: dbexport permissions
Date: 27 Aug 92 05:40:20 GMT
Distribution: ba
Organization: Enterprise Technology Center, Informix Software, Inc.

In article <1992Aug25.235323.1930@adaclabs.com> mikep@adaclabs.com (Mike Pechner) writes:
>I am having a problems with  dbexport.
>...
> the dbexport program is owned by root, and has not suid bits set.
> Why os the <db>.exp directory being created as being owned by nobody.
>-- 
>mikep@adaclabs.com (Michael Pechner)  | Pizza Probably The Worlds Most

If dbexport is owned by root, somebody has messed with it.  It should only
be owned by informix.

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

  Smith and Wesson: the Ultimate Point-and-Click User Interface.
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: doretalloc()
Date: 4 Sep 92 15:43:39 GMT
Reply-To: cortesi@informix.com
Organization: Informix Software, Inc.

In article <9466@emory.mathcs.emory.edu> mm@ssf.pt (Manuel Monteiro) writes:
> 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!

Well, it is, in a way. The answer to your second question is,
"does the name of the function appear in the index of the 4GL manual?"

If not, the function is not supported. Barring a documentation error
of course ...:-\  That is the case with this function.  So even
if you find out what it does, it isn't safe to use it. Why? Because
Informix feels free to change that interface at any time without
warning -- leaving your program up the creek.

What is it you want to accomplish?

Dave Cortesi
	cortesi@informix.com
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: RE: buggy ROWID
Date: 1 Sep 92 03:13:12 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1415>

Martin Hitz writes: 
 
} We are running Informix SE 2.10.03K with SCO Unix.
} 
} P.S.: Another inconvenience: ISQL core-dumps whenever it asks to select
}       a table interactively, obviously because there are more of them
}       than could fit on one screen. Is there a work-around?

I've found that this is a bug with the SQL product in pre 4.00 versions.
If the list of tables spans more than TWO screens, strange things start
to happen.  When we went to 4.00, the problem disappeared.

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: 2pereira_f@spcvxb.spc.edu
Newsgroups: comp.databases.informix
Subject: SuperNOVA Dbase Package (NEW)
Date: 1 Sep 92 14:26:58 GMT
Organization: St. Peter's College, US

Has any one e ver heard of SuperNOVADatabase Package?
It's a Object oriented Dbase Package Developed in Holland 

If anyone has let me know what you think of it...

bye.
Felix
From: mm@ssf.pt (Manuel Monteiro)
Newsgroups: comp.databases.informix
Subject: memory allocation under AIX 3.2
Date: 2 Sep 92 03:58:04 GMT
Reply-To: mm@ssf.pt (Manuel Monteiro)
X-Informix-List-ID: <list.1423>

Hi Informix AIX gurus,

I had the following problem when upgrading from AIX 3.1 to AIX 3.2.

In a esql/c program, when you pushquote((char *)str, strlen(str)),
what is really pushed into the stack is the pointer to the string, not
the contents of the string (I didn't know that 'call by reference' was
supported :-).

With AIX 3.2 when you 'free' a block, previously allocated using
'malloc', its contents are destroyed. With AIX 3.1 its contents were
left undisturbed.

I have several ec functions similar to

f(fgl_pcnt)
     int fgl_pcnt;
{
  ...;
  char *x = malloc(...);        /* x size is not known in compile time */
  
  ...;                          /* calculates x value */
  
  /* RETURN x */
  pushquote(x, strlen(x));
  doretalloc(1);
  free( x );                    /* must free x space before returning */
  return(1);
}

To be called from 4GL programs

    CALL f() RETURNING str

The problem is that the pointer pushed into the stack now points to a
'destroyed' block, no longer containing the values I want.

Does anyone out there knows how to solve this problem (without
rewriting all those functions :-(?
Is there a port to AIX 3.2 that really copies the strings to the stack?

BTW: I'm running INFORMIX-4GL Version 4.10.UD2 on a IBM RISC 6000/530

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: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  memory allocation under AIX 3.2
Date: 4 Sep 92 15:28:04 GMT
Reply-To: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
X-Informix-List-ID: <list.1430>

}Date: Wed, 2 Sep 92 22:38:00 GMT
}Message-Id: <9209022238.AA05733@obelix.informix.com>
}Subject: Re:  memory allocation under AIX 3.2
}X-Informix-List-Id: <list.1424>
}
}}Date: Tue, 1 Sep 92 18:35:28 +0100
}}From: Manuel Monteiro <uunet!ssf.pt!mm>
}}Subject: memory allocation under AIX 3.2
}}X-Informix-List-Id: <list.1423>
}}
}}I had the following problem when upgrading from AIX 3.1 to AIX 3.2.
}}
}}In a esql/c program, when you pushquote((char *)str, strlen(str)),
}}what is really pushed into the stack is the pointer to the string, not
}}the contents of the string (I didn't know that 'call by reference' was
}}supported :-).

Time to grovel apologetically.  I was working too late at night to
spot that the function which should be called is retquote, not
pushquote.  If you use the correct function, you get the correct
results.  Your code, Manuel, is simply wrong and should use retquote.
My answer was wrong in not pointing this out.

My thanks to Dave Cortesi for pointing out the error of my ways.

Yours apologetically,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: ddntswa@baisg.BELL-ATL.COM (Raj Muralidharan)
Newsgroups: comp.databases.informix
Subject: Need Informix guru's
Date: 1 Sep 92 00:18:08 GMT
Reply-To: ddntswa@baisg.BELL-ATL.COM (Raj Muralidharan)
X-Informix-List-ID: <list.1414>


  
  
  Hi all!!
  
  	There is a need for upto 4 people for a long term (at least 1 year)
  	assignment in North Carolina.  If you are interested or know some
  	one who might be interested, please contact me email or voice 
  	ASAP.  We need factory trained INFORMIX killers.  X Windows, MOTIF
  	a plus.
  
  Raj Muralidharan
  
  -- 
  
  
 =**= - =*= - =*= - =*= - =*= - =*= - =*= - =*= - =*= - =*= - =*= - =*= - =**=
 Voice    : (301) 989-5042		Fax  : (301) 989-5040
 Internet : ddntswa@baisg.bell-atl.com	UUCP : bell-atl.com!baisg!ddntswa
 =**= - =*= - =*= - =*= - =*= - =*= - =*= - =*= - =*= - =*= - =*= - =*= - =**=
From: warren@hector.cc.bellcore.com (saccente,warren j)
Newsgroups: comp.databases.informix
Subject: RE: buggy ROWID
Date: 31 Aug 92 21:53:06 GMT
Reply-To: warren@hector.cc.bellcore.com (saccente,warren j)
X-Informix-List-ID: <list.1413>


Martin Hitz writes: 
 
} We are running Informix SE 2.10.03K with SCO Unix.
} 
} Recently, I have been debugging an error in our application which
} I managed to boil down to the following SQL-script. Can anybody
} tell me if it's a bug or if we misunderstood the concept of ROWID?
} To my opinion, the two SELECTs at the end which differ only with 
} respect to the sequence of tables in the FROM clause
} should NOT generate different output. In fact, I consider the last output
} WRONG:
} 
} create table a (k smallint);
} create table b (k smallint);
} 
} insert into a values (1);
} insert into a values (2);
} insert into a values (3);
} 
} insert into b select * from a;
} delete from b where k = 2;
} 
} select rowid brow, k bk from b;
} 
}        brow     bk 
} 
}           1      1
}           3      3
} 
} select a.rowid arow,  b.rowid brow, a.k ak, b.k bk from b, a where a.k = b.k;
} 
}        arow        brow     ak     bk 
} 
}           1           1      1      1
}           3           3      3      3
} 
} select a.rowid arow,  b.rowid brow, a.k ak, b.k bk from a, b where a.k = b.k;
} 
}        arow        brow     ak     bk 
} 
}           1           1      1      1
}           3           2      3      3
} 
}                      ^^^
}                      !!!
}
 
Under 4.0 Online the correct result is returned no matter which table is
listed first.

} 
} P.S.: Another inconvenience: ISQL core-dumps whenever it asks to select
}       a table interactively, obviously because there are more of them
}       than could fit on one screen. Is there a work-around?
 
I'm not sure if I understand the problem - but I use ISQL all the time
without getting any core dumps.

Warren J. Saccente
Bellcore
From: adamt@ant.EBay.Sun.COM (Tom Adam)
Newsgroups: comp.databases.informix
Subject: Wingz - Hyperscript
Date: 26 Aug 1992 01:55:03 GMT
Organization: Sun Microsystems, Inc.
Distribution: world
Reply-To: adamt@ant.EBay.Sun.COM
NNTP-Posting-Host: ant.ebay.sun.com


Any Wingz users out there?
I woul appreciate any help with Hyperscript such as libraries, tips etc.
You can email me, or post to this group.

Thanks in advance,

Tom Adam
 +-----------------------------------------------------------------+
 | Tom Adam   M/S Mil 3-73		      		  Phone: 31399 or  |
 | Sun Microsystems			                          (408) 276-1399  |
 | 2550 Garcia Ave			                  Fax: (408) 946-7665  |
 | Mountain View, CA 94043-1100	                   Email: adamt@ant.EBay.Sun.COM  |
+-----------------------------------------------------------------+
From: carsmax!carsmax!bryan@uceng.uc.edu (Bryan Klopfenstein)
Newsgroups: comp.databases.informix
Subject: Re: Online Performance Degradation
Date: 1 Sep 92 22:33:08 GMT
Reply-To: carsmax!carsmax!bryan@uceng.uc.edu (Bryan Klopfenstein)
X-Informix-List-ID: <list.1418>

andrew.shaw says:
> Elapsed minutes:   1    2    3 ... 10  ... 35  ... 50
> # of transaction: 220  210  200    150     100     50
> 
> If you plot the number of transactions possible against elapsed time you get
> what looks like a log N graph, ie plotted on log paper you get a downward
> sloping straight line.  I should point out that since we are doing adds,
> the elapsed time reflects the database getting continuously larger, albeit
> at a slowing rate.

You are doing adds. It's pretty safe to assume that you have indexes on
the table you are adding to.

Informix must rebuild the indexes after each add to ensure that each index
is in order. The larger the table, the longer it takes to rebuild an index
because there are more entries that must be searched for the spot to insert
the new row.

I'm sure a more technical answer will arrive if you need it...
-- 
Bryan Klopfenstein			try: bryan@cinnet.com
CARS Information Systems, Inc.		or: ..uunet!uceng!cinnet!carsinfo!bryan
Cincinnati, OH				better: usr10300@tso.uc.edu
		Standard Disclaimers Apply
Newsgroups: comp.databases.informix
Subject: CISAM and incomplete transaction caused by system crashes
From: russell@ccu1.aukuni.ac.nz (Russell Fulton)
Date: Wed, 2 Sep 1992 01:45:21 GMT
Organization: University of Auckland, New Zealand.

When using isbegin() and iscomit() to bracket transaction it is
not clear from the manual what happens if the system should crash
before the call to iscommit().  Is isrecover() smart enough to
recognise that there is an uncompleted transaction. Or more likely
is it the case that the transaction isn't logged until it is completed?

I assume that this *is* handled correctly but I have been burned before
by assuming that other people's programs do the sensible thing.
(Mine alway do, of course! :-).

Thanks, Russell.


-- 
Russell Fulton, Computer Center, University of Auckland, New Zealand.
<rj_fulton@aukuni.ac.nz>
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Temp Tables
Date: 27 Aug 92 16:43:47 GMT
Organization: Informix Software, Inc.

Naomi Walker writes:
>
>I thought you could control where temp tables were created (from 4.1
>Online) using DBTEMP.  We sometimes have to create them in Unix file 
>space.

DBTEMP has no effect on temporary *tables* created in OnLine; they will
always exist in the root dbspace.

Temporary *files*, created by the sort package, will be created in Unix
file space.  They will be located in: $PSORT_DBTEMP, $DBTEMP, or /tmp
(in that order of preference).

A future release of OnLine will allow you to specify the dbspace to
be used for temporary tables.

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: Root@letterkenn-emh1.army.mil
Newsgroups: comp.databases.informix
Subject: question on load vs. count(*) counts
Date: 31 Aug 92 20:48:07 GMT
Reply-To: Root@letterkenn-emh1.army.mil
X-Informix-List-ID: <list.1412>

A programmer at our site created a new table (unisys 5000, sql 4.0.UE2,
and SE engine) and then made a flat pipe-separated file with say, 50
records in it.  Using sql load command, try to load it into empty table.

When the 43rd row had a problem, of course the load halted and a count
of successful rows loaded was displayed, and the reason (error) encountered.

What we THINK we notice is:

If the error is 846 Number of values in load file not equal to # columns, the
count displayed is 42, and "select count(*) from table" also yields 42.
No problem, right? The error in my load file is on line 43, and sure enough,
there it is. Neat debugging tool.

But, when the errors was either 391 cannot insert a null into column, or
239 could not iinsert new row - duplicate value in unique index column
the count displayed is usually 48 (always a multiple of 16).  The error
occurs within 16 rows before the displayed count. "select count(*) from
table" displays a count of existing rows which is always less than the
loader said, but not more than 16 less.  In this example it said 48 rows
loaded, and the actual select count(*) says 42.  Each time we try this we
have run delete from table first.

Can anyone explain?  We also have a call into hotline.  Is this a bug in
4.0 UE2?  Or are we missing something here?  Its easy to work around in an
empty table, but not in the real world.  Thanks.  This BB is really great
for quick answers to problems; so much expertise in one place!  Thanks in
advance.

Ann Barnes
Letterkenny Army Depot
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: message mystery
Date: 31 Aug 92 19:08:04 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1411>

Quoting L. D. Stratton...

->  I've tried about everything I can think of to correct this situation 
->  but haven't found a solution yet.
-> 
->    After the 'screen record' statement, the following error appears:
-> 
-> #  Screen record array "s_plan" has component sizes which either differ
-> # from the specified dimension of teh array or differ among themselves.
-> # See error number -2029.
-> 
->   I've double and triple checked the field lengths in the database
->   as compared to what is on the screen (it shouldn't matter).  The
->   only thing I can see is that it can't handle the double line of 
->   data in the array, 8 lines above and the same 8 continued below.

Yup, that's the reason.

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: ae954@yfn.ysu.edu (Andy Johnston)
Subject: What is informix? request for summary info
Organization: Youngstown State University/Youngstown Free-Net
Date: Thu, 27 Aug 1992 18:36:37 GMT


Can someone e-mail me a brief description of informix?  I have
just been asked to find out about it and, outside of it's being a
database s/w, I know nothing about it.  Is it relational, hierarchical?
What does it support and why should(n't) I use it?  Stuff like that.