HDTenEightyP/NetNews huggingface dataset:
From: johnl@obelix.informix.com (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  Help with structs and .ec
Date: 12 Nov 1992 11:38:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: johnl@obelix.informix.com (Jonathan Leffler)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1593>


I've not seen any response to this question, so I'm sending my response,
which consists of a number of other questions, as well as one or two
pertinent (I hope) observations.

>From: uunet!turq.b8.ingr.com!randy (Randy Paries)
>Subject: Help with structs and .ec
>Date: Thu, 5 Nov 92 12:26:57 CST
>X-Informix-List-Id: <list.1574>

>	I am having problems fetching into a structure when using a prepare.

>	$struct open{
>		int  var1;
>		int  var2;
>		char var3;
>	};
>	$struct open open_rec;

>	main()
>	{
>		$declare X cursor for
>			select * from table where table.var1 = 2;
>		$open;

** Open what?

>		$fetch X into $open_rec;
>	}

>	This above example works ok.

As in compiles OK? Or runs OK?

I don't think it should even compile, because the open statement clearly
suffers from a syntax error (no cursor name).  I could easily believe that
the compiler would not then analyse the fetch statement.  Also, you should be
very careful about using keywords as identifiers.  OPEN is a keyword.  Using 
a structure type called "open" might confuse the ESQL/C preprocessor.

>   The following example fails on the compile with the following error:
>	line 13: RECORD objects 'open_rec' are not allowed in this list

>	$struct open{
>		int  var1;
>		int  var2;
>		char var3;
>	};
>	$struct open open_rec;

>	main()
>	{
>		char qvar[200];

>		strcpy(qvar,"select * from table where table.var1 = 2");

>		$prepare Y from $qvar;
>		$declare X cursor for Y;
>		$open;

** Open what?

>		$fetch X into $open_rec;
>	}


>	if I replace $fetch X into $open_rec; with
>		     $fetch X into $open_rec.var1,$open_rec.var2,$open_rec.var2
>	it works ok.

As in compiles? Or runs?

>	The problem is the tables that I need to fetch in real life have
>	LOTS of columns.

So you have five choices (at least):

(0) Fix the syntax errors in the open statements:-)

(1) Redesign your tables so they have fewer columns.

(2) Produce a program which lists all the columns in a table so that
    you can generate the elements of the record automatically.

(3) Use I4GL and the RECORD LIKE facility.

(4) Write your own preprocessor to provide you with the equivalent of
    the I4GL record.* facility.

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: hwc2243@ritvax.isc.rit.edu
Newsgroups: comp.databases.informix
Subject: tracking execution
Date: 11 Nov 92 02:50:39 GMT
Reply-To: hwc2243@ritvax.isc.rit.edu
Organization: Rochester Institute of Technology

A company I have been working is having a problem with deadlocks.  We 
handled this by checking the status variable after executing any critical
transactions.  If there is a deadlock status returned we call a routine
to handle this, which does a rollback.  This works fine except we would
like to know what statement caused it and where in the code it is.

So basically what we would like to know is if there any globals variables
or something to return the same information you get when there is an 
actual error, ie. the module and line number.

I know we could hardcode them into all the calls but there alot of them
and they would also have to be changed whenever we change code.

We are currently running OnLine 4.0, I4GL 4.0 on Intergraph equipment.

Our current call looks like the following :

     SOME CRITICAL DATABASE TRANSACTION
     IF status < 0 THEN
         CALL handle_warning(status)
     END IF

handle_warning then insert the status into a table and send E-mail to the
programming group that a deadlock happened and restarts the program for the 
user.

Any help on how to determine where the program is executing would be 
appreciated.

						Bill Connors
Xref: sparky comp.databases.informix:2341 comp.databases:7689
From: aaron@satco.UUCP (Aaron Pelton)
Newsgroups: comp.databases.informix,comp.databases
Subject: Informix 4GL vs Progress
Summary: info desired on informix vs 4gl decisions
Keywords: informix 4gl progress database
Date: 7 Nov 92 05:46:10 GMT
Reply-To: pelton@uvm-gen.emba.uvm.edu
Followup-To: pelton@uvm-gen.emba.uvm.edu
Organization: University of Vermont, EMBA Computer Facility


    I'm a member of a team assigned the task of choosing between informix
and progress. Is there anyone else out there who has already made the 
decision that might have encounted problems with either package that we
should know about?

    We have an eval copy of the informix 4gl product but found out about
their forms package after the we'd received it and we're running out of time.
Can anyone make any comments about how well it works? How about Progresses
FastTrack?

    We've been using Informix SQL and C for most of our work to date but
would like to reduce code maintenance and so forth.

    Replies to pelton@uvm-gen.emba.uvm.edu and if anyone would like to know
the results, fire off a note and I'll let you know what I know. you know?

    thanks and appreciation * alot
-- 
Aaron Pelton		    | If it sounds like an opinion, it's probably mine.
aaron@satco.UUCP            | Only R. Crusoe could have it all done by Friday
{decvax,uunet}!virgin!satco!aaron
From: johnl@obelix.informix.com (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re: Triggers in Informix?
Date: 5 Nov 1992 15:13:13 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: johnl@obelix.informix.com (Jonathan Leffler)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1575>

}From: uunet!microc!eric
}Subject: Re: Triggers in Informix?
}Date: Wed Nov  4 15:58:06 1992
}X-Informix-List-Id: <list.1570>

}>From: uunet!informix.com!dsimon (Don Simon)
}>Subject: Re: Triggers in Informix?
}>Date: 2 Nov 92 20:24:21 GMT

}>The I-Forms product provides a triggers implementation that can be used with
}>all current products that support I-Forms.

}>Current release plans I believe (take this with a grain of salt, please) call
}>for a trigger implementation in a future Informix release (6.0, 7.0, ???).

}I understand that there's going to be a 5.01 version of the engines with
}triggers.  Isn't it?

Yes.  Available RSN:-)

Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: dsimon@informix.com (Don Simon)
Newsgroups: comp.databases.informix
Subject: Re: Backing up OE db files
Date: 9 Nov 92 16:46:26 GMT
Article-I.D.: informix.1992Nov9.164626.18675
Reply-To: dsimon@informix.com
Followup-To: comp.databases.informix
Organization: Informix Software

In article 3566@infonode.ingr.com, jjolly@jjolly.b24b.ingr.com (Jack G. Jolly) writes:
>Is it necessary to back up the physical files associated with an
>ONLINE db "outside of the environment"?
>
>Consider "raw partitions" as well.
>
>I always thought that backup of physical files was a necessity to
>prevent against disk failure - that you would restore your old
>files and apply the contents of saved transaction log files against
>them to bring them up to date (at least that is how you're supposed
>to do it with Oracle).
>
>Does the "Archive" utility in tbmonitor eliminate the need to make copies
>of the physical files??
>
>JJ
>-------------
>
>  ^^^^^^^^^          Jack Jolly  @  jjolly@jjolly.b24b.ingr.com
> (| 0   - |)
>  |   *   |             Intergraph Corporation, Huntsville AL
>  \_______/                AEC Project Management Support


The entire purpose of the archive system is so that you don't have to make backing
up your on-line data part of your regular backups.  The on-line archiving system
stores all database information needed to restore the database in the event of failure.
You still need to backup your regular UNIX system, so that the INFORMIXDIR files
(programs and configuration info) are saved.  If you are using cooked files, and
are properly archiving your on-line system (both data and logs), you can exclude
the cooked files from your unix archive.

Hope this clears things up some,

don simon
"I didn't do it.
 Nobody some me do it.
 You can't prove a thing."
From: david@cssnet.UUCP (J. David Schronce)
Newsgroups: comp.databases.informix
Subject: upgrade help
Date: 3 Nov 92 16:19:24 GMT
Organization: Computer Support Services

I'm preparing to upgrade from Informix version 1.10 to 5.0 and have some 
lingering questions that I can't seem to answer, so once again I bow 
before the collected knowledge of the net and pray for enlightenment.

We are migrating all our database work to either an Altos 10000 or 15000.
I will have 30 -40 Informix users on this system.  MOST of them will be 
inserting/updating data into the various tables.

We are a manufacturing/sales organization so the data is inventory 
levels, customer data, order_header, order_detail, shipping info, etc.. 
all interacting.

In such an environment, do you think that th on-line engine is a 
necessity, or is the SE engine equivelent to the task?
At this level of use, on the proscribed hardware, would the on-line 
engine offer perceptibly faster access to data?
I suppose the REAL question is - Is online WORTH the $5000 difference as 
compared to SE? - and why?

Real-life experiences, suggestions, alternative, condolences solicited:

Please reply here or to:  dschronc@lee.cerf.fred.org and I'll summarize.

THANK YOU !


---dave---
+-----------------------------------------------------------------+
|J. David Schronce     "Death Before Decaf!!"    david@cssnet.UUCP|
|Computer Support Services                            919/775-2145|
|-----------------------------------------------------------------|
|          "The opinions and the company are both mine..."        |
+-----------------------------------------------------------------+
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: upgrade help
Reply-To: shemminga@cix.compulink.co.uk
Date: Thu, 5 Nov 1992 16:15:00 +0000


In <2i9NTB1w164w@cssnet.UUCP> J. David Schronce asks:

> I'm preparing to upgrade from Informix version 1.10 to 5.0 and have some
> lingering questions that I can't seem to answer, so once again I bow 
> before the collected knowledge of the net and pray for enlightenment.
> 
> We are migrating all our database work to either an Altos 10000 or 15000.
> I will have 30 -40 Informix users on this system.  MOST of them will be 
> inserting/updating data into the various tables.
> 
> We are a manufacturing/sales organization so the data is inventory 
> levels, customer data, order_header, order_detail, shipping info, etc.. 
> all interacting.
> 
> In such an environment, do you think that th on-line engine is a 
> necessity, or is the SE engine equivelent to the task?
> At this level of use, on the proscribed hardware, would the on-line 
> engine offer perceptibly faster access to data?
> I suppose the REAL question is - Is online WORTH the $5000 difference as 
> compared to SE? - and why?

I can't answer all of you questions but we're a manufacturing company
with sales and purchasing departments all
inserting/updating/selecting a variety of tables. We use SE with
I-Net. The DB is on a 486 tuned for quick disk access and the apps
run on 2 386 boxes (with a third on the way RSN). We have about 20
users and for the most part everything runs well and fast enough.
Hving said that it could run fasted, but then if we all had a cray on
the desk we'd still say it could run faster wouldn't we?

--------------------------------------------------------------
| Who cares whos opinions these are?!                        |
| Send me mail and I'll love you forever (Maybe)             |
|------------------------------------------------------------|     
| Stuart Hemming       | shemminga@cix.compulink.co.uk       |
| Tudor Labels Ltd     | uunet!cix.compulink.co.uk!shemminga |
| Roman Bank Bourne    | Tel :  (+44) 778 426444             |
| Lincs PE10 9LQ. UK.  | Fax :  (+44) 778 421862             |
--------------------------------------------------------------


Stuart
|8-)
Newsgroups: comp.databases.informix
From: dinguyen@wam.umd.edu (Dzi Nguyen)
Subject: Re:  Erratic error 408 from ESQL/C
Organization: University of Maryland, College Park
Date: Sat, 7 Nov 1992 00:47:34 GMT

In article <1dbtpnINNqac@emory.mathcs.emory.edu> johnl@obelix.informix.com (Jonathan Leffler) writes:
>}From: uunet!gauss.rutgers.edu!manmetha (Rajesh Malhotra)
>}Subject: Erratic error 408 from ESQL/C
>}Date: 4 Nov 92 22:26:16 GMT
>}X-Informix-List-Id: <news.2057>
>}
>}Fellow Informix'ers,
>}
>}	Every now and then a query in our application fails
>}with an error code of 408. We have'nt been able to duplicate the
>}scenario and make the error occur again. The manual's description
>}of 408 does not seem to make sense.
>}
>}	Any ideas / suggestions?
>}
>}BTW we are running Informix online 5.0 and ESQL/C on an IBM RS600
>}running AIX 3.2
>
>The key info here is probably the RS6000.  AIX detects when it is getting
>low on swap space (or some other virtual memory resource), and it then
>arbitrarily kills a process or processes to relieve the pressure.  Sometimes
>you are lucky and it is only an sqlturbo it kills -- sometimes it kills
>tbinit instead.  And sometimes you are unlucky and it kills an sqlturbo in a
>critical section so OnLine has to abort.
>
>AIX is wonderful, really:-(
>
>Yours,
>Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>

This error occurs every time in one of my load module.  To work around this
problem, I have to move/rearrange codes around.

It is a mystery to me, and I don't think it have any thing to do with the 
machine (my application is on Pyramid 7080 series).

I am still investigating....\8-(

Zombie (dinguyen@wam.umd.edu)

-- 
**********************************************************
*     There is no victim, only volunteers.               *
**********************************************************
From: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
Newsgroups: comp.databases.informix
Subject: Federal User Group.
Date: 12 Nov 1992 14:23:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1598>


FOR: Bill Daul, Informix Software, Inc.  Advanced Support.

Bill,

I would be very interested in a Federal Government User Group.

If one should be set up let me know.

Thanks.




					Michael S. Gordon
					Foreman, Gyroscope Section
					Avionics Division 

 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 *                                                                           *
 *  Michael Gordon                           Sacramento Army Depot           *
 *  Foreman, Gyroscope Section               Directorate For Maintenance     *
 *  E-Mail: maint72@saad-emh1.army.mil       Attn: SDSSA-MAV-320             *
 *  DSN:    839-2367                         Michael S. Gordon               *
 *  Comm.:  (916) 388-2367                   Sacramento, CA 96813-5036       *
 *                                                                           *
 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
From: billd@informix.com (William Daul)
Newsgroups: comp.databases.informix
Subject: Informix Demo Truck Schedule
Date: 12 Nov 92 00:05:27 GMT
Distribution: usa
Organization: Informix Software, Inc.
Originator: billd@cheetah

Truck News Bulletin
-------------------


                   ....
           _____________\
      ~  / Informix   /-)___
     ~  /  Truck     /   /_@/
    ~   --OO-------OO---O--/


        **News Bulletin**     **News Bulletin**    **News Bulletin**

********************************************************************************               
                       Equipment/Demos on the Truck



IBM RS/6000:
-----------------
I4Gl-ID               
I4GL-RDS
ISQL
Wingz

KC HOUSE HUNTER
TEST FLIGHT
CORCORAN ART GALLERY


SUN SPARCSTATION
------------------  
Wingz 
Storm
4GL/GX

CADRE
BAHH
CORCORAN

HP-710
------------------
ISQL
I4GL-ID
OnLine
Wingz

Great Northwet Office Supply demo
Corcoran
BAHH
Test Flight
Food Mart


IBM PS/2
-------------------
ISQL, I4GL, RDS, ID, ESQL/C
SE, INET-PC

I4GL DEMO
BLOB DEMO
QUICK DEMO
SQL DEMO

ATT Star Server E
--------------------
ISQL, I4GL, ESQL/C, SE
OnLine, INET, STAR

Stores (I4GL, SQL)


MAC
------------
Wingz
Wingz Datalink

Cumulus
Expense Report
Hotdog 
JC Penney


SEQUENT
-------------
ISQL, I4GL, QUICKSTEP, ESQL/C 
SE, OnLine, INET, ISTAR

JC Penney Demo
BLOBS (ISQL)
Wall of terminals (Fourgen Case tools)

********************************************************************************
				
                            Truck Schedule



November
-----------
9 - 17          St. Louis - Eric Enzeroth

December
------------
7 - 18          Florida Area

January
-----------
18 - 22        Phoenix, AZ  - John Houtsma

  
February
-----------
15 - 26        Mexico Tour - Gilma/Steve Clarence  (??)

 
March
----------  
24 - 25        Denver, Colorado - John Houtsma 
29 - 31        Detroit, MI  - Jeannine 

April
----------
1 - 9          Detroit, MI  - Jeannine

  
May
----------
17 - 18        North Carolina - Gary Wood
20 - 21        Tennessee - Gary Wood
24 - 25        Atlanta, Georgia  - Gary Wood
27 - 28        Florida - Gary Wood

*****************************************************************************
    *************************************************************
If you have any concerns or questions, please send me a note or contact
your local sales office.    --Bill

-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
 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: jsb@jack.sns.com (Jim Best)
Subject: help on output
Organization: Systems'n'Software
Distribution: usa
Date: Thu, 12 Nov 92 03:47:18 GMT

I would like to get a small ace report that will output each individual
field to it own file.

I have a small database with 6 fields and the output commands does not
seem to have a way to put each field in its own file.

Any help would be appreciated.
___________________________________________________________________________
                                   \ /        \  /
I had a seat in the very first row +-------------+ 
I heard it all on my radio         | 0 -(....) 0 |    uunet!jack!jsb
                                   +-------------+    Jim Best             
___________________________________________________________________________


Newsgroups: comp.databases.informix
From: mtrotter@magnus.acs.ohio-state.edu (Mark L Trotter)
Subject: out-of-control /tmp files
Organization: The Ohio State University
Date: Mon, 9 Nov 1992 19:30:11 GMT

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

!------------------------------------------------------------------------!
!        Mark Trotter @ The Ohio State University Graduate School        !
!     voice 614/292-6031  FAX 614/292-3656  BITNET trotter.1@osu.edu     !
!------------------------------------------------------------------------!
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: c-isam programmer's manual
Date: 13 Nov 92 16:13:23 GMT
Organization: Informix Software, Inc.

Root@letterkenn-emh1.army.mil writes:
>Dave@informix.com writes to see the C-ISAM Programmer's Manual for info
>on log format. I keep seeing this answer to many things. Dave, not all of
>us bought a C-ISAM product, we just bought SE. The  manual you refer to does
>not come with SE (perhaps it should, if it contains appropriate info??).
>What is available to use with just SE manuals?
>Ann Barnes, Letterkenny Army Depot, anbarnes@letterkenn-emh1.army.mil

Sorry for not realizing that you wouldn't have the CISAM manual.  Anyone who
is doing "internal type" stuff with SE (pretty much anything that requires 
knowledge of the data structures used by SE) would find this manual very
helpful.  You can order it by itself (you don't have to buy CISAM).

There is no information in the SE manuals about contents/structures of
any files used by SE.

As to whether this info (and the CISAM  manual, for that matter) should come
with SE, My opinion is YES!!, but I do not make the decision to do that (in
fact, they don't even ask my opinion).  As the .sig indicates, I don't
necessarily agree with everything the company I work for does, and the
company is kind enough to reciprocate in that sentiment.

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
From: widener!uunet!uunet!microc!eric@emory.mathcs.emory.edu
Newsgroups: comp.databases.informix
Subject: Re: Triggers in Informix?
Date: 5 Nov 1992 14:43:09 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: widener!uunet!uunet!microc!eric@emory.mathcs.emory.edu
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1570>

>From: uunet!informix.com!dsimon (Don Simon)
>Message-Id: <1992Nov2.202421.24240@informix.com>
>Subject: Re: Triggers in Informix?
>Date: 2 Nov 92 20:24:21 GMT

>The I-Forms product provides a triggers implementation that can be used with >all current products that support I-Forms.

>Current release plans I believe (take this with a grain of salt, please) call >for a trigger implementation in a future Informix release (6.0, 7.0, ???).

>that is all,

>don simon

I understand that there's going to be a 5.01 version of the engines with
triggers.  Isn't it?

+--------------------+--------------------------------------+----------------+
| Eric C. Leschhorn  |    MICROCOMPUTOS   Fax:(809)688-6044 |                |
| Marketing Director | Dominican Republic Tel:(809)530-8506 +-----------+    |
| uunet!microc!eric  |  Puerto Rico, USA  Tel:(809)250-8789 +---------+ |    |
+--------------------+--------------------------------------|   +-+   | |    |
|  I N F O R M I X   L A T I N   A M E R I C A N   T E A M  |   | |   | |    |
+-----------------------------------------------------------+---+ +---+ +----+

Newsgroups: comp.databases.informix
From: Dwight.Smith@launchpad.unc.edu (Dwight Smith)
Subject: Loading PC Keyboard Buffer from 4GL
Organization: University of North Carolina Extended Bulletin Board Service
Date: Wed, 11 Nov 1992 21:54:38 GMT

We are using Informix 4GL on SCO Unix PCs.  Under the MS-DOS version of
Informix, it is possible to use a BIOS interrupt to place a carriage return
character (or any character) in the keyboard buffer.  This character is then
read and interpreted by Informix just like any other keyboard character.
Does any one know how to perform a similar feat under Informix running on
SCO?   Thanks.

--
   The opinions expressed are not necessarily those of the University of
     North Carolina at Chapel Hill, the Campus Office for Information
        Technology, or the Experimental Bulletin Board Service.
           internet:  laUNChpad.unc.edu or 152.2.22.80
Newsgroups: comp.databases