HDTenEightyP/NetNews huggingface dataset:
From: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
Newsgroups: comp.databases.informix
Subject: Ace Report Writer, Return Response.
Date: 27 Aug 92 18:58:03 GMT
Reply-To: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
X-Informix-List-ID: <list.1406>



TO:  Alan Denney, Enterprise Technology Center, Informix Software, Inc.

Thank you for the quick and accurate response to the Ace Report Writer 
problem of "PROGRAM" key word.

Contrary to published statements directed against Informix Support, If those
individuals who have technical problems with the software performing the tasks
they require would only give people like yourself a chance to help, they 
might have greater success with thier end product.  After all, in the end, the
product we supply to our customer, the guy who signs our paycheck, is what
really counts.  That is if we still need a payckeck.

So, now I'm back to writting reports which cannot be piped to another DOS
program command, but formated for WordPerfect where we can make minor
changes to the document.  Too bad we cannot fully automate the system like
I have done with our Unix system.  But, some automation is better than none.

Again, thank you for your reply.




					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: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: question on load vs. count(*) counts
Date: 1 Sep 92 16:57:12 GMT
Reply-To: cortesi@informix.com
Organization: Informix Software, Inc.

In article <9427@emory.mathcs.emory.edu> Root@letterkenn-emh1.army.mil writes:
> 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.
> 
> 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.

Pretty clearly, LOAD is counting input rows but using an insert cursor
and PUT to do the inserts.  PUT blocks rows (probably blocks of 16 in
your case!) before sending them to the engine where an error such as
-391 would be detected.  The count of rows could be adjusted based on
the value PUT would return in the SQL Communications area, but it
would appear this isn't being done. That would be my guess as an amateur
esql/c programmer, anyway... This might be the same as bug #4465:

Bug Number    [    4465]... Scheduled Fix Ver  [  ][4.00.UC1A3]
..  Closed [10/12/89]...
Short Desc  [LOAD DOES NOT SET THE SQLERRD[2] SET TO # OF ROWS PROCESSED      ]
                           Long Bug Description
      [Because of the fact that sqlload was not setting the sqlerrd[2]  ]
      [flag that indicates the number of rows that were inserted, 4gl   ]
      [programs has no way of finding out if the rows were processed    ]
      [correctly.                                                       ]
From: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
Newsgroups: comp.databases.informix
Subject: Cannot Drop Database
Date: 3 Sep 92 18:58:04 GMT
Reply-To: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
X-Informix-List-ID: <list.1426>




I have a question into Tech Support, but havent gotten to an engineer,
so I thought i'd pose my question to the net as well.  

We have a system running Online 4.0 on a As400 386.  I've also had this
problem on a Pyramid 9845 running Online 4.0, and a Pyramid MIS S server
running 4.1.

The problem:
   I am trying to drop a database, and cannot.  The problem is actually
   with one table, named prop_alt.

Heres what I have tried:

   1)  In ISQL, Drop Database (query language or thru the menu)
       responds with:
              "215 Cannot Open File For Table()"
               "Memory Allocation Error"

   2)  In ISQL, Drop Table (query language) responds with:
              "211 Cannot Read System Catalog (sysindexes)"

   3)  In ISQL, rename table, responds with:
              "215 Cannot Open File For Table()"
       (I know the bad table name is prop_alt)

   4)  I was going to drop the big tables in the database, so
       in preparation for dumping nrows from systables, I:

       In ISQL, update statistics responds with:
              "215 Cannot Open File For Table()"

   5)  Just trying to get nrows (without update statistics) I got:
       "tblspace not found"

       In tbmonitor I can see the database in the rootdbs.

   6)  I gracefully took Informix down to quiescent, and looked in the
       Informix log for errors (there were none), then Offline, and
       back up to Online, and tried the above sequence again.  The
       same problems occurred. 

       In the past, taking Informix Offline, and back up again has
       cleared these types of problems.  Not this time.  I was not 
       yet out of tricks.

   7)  I took Informix down to quiescent in an attempt to run tbcheck's
       in fix-it mode.  

       tbcheck -cI dbname barfed with:
        "Memory Allocation Error, 
         Bad Column List for Sysindexes Found"

       tbcheck -cc dbname barfed with:
        "Memory Allocation Error, 
         Bad Column List for Sysindexes Found"

       tbcheck -cd dbname barfed with:
        "Memory Allocation Error, 
         Bad Column List for Sysindexes Found"

   Now, i'm running out of tricks.  I suspect i'm going to have to unload
   the other databases in the partition, initialize, and load the databases
   back on.  Is there anything else I can do?  Does anyone know what causes
   this?  Nothing looks askew in the error log.

   Anyone else ever seen this and know a better solution?

thanks,
Naomi
      
-- 
  Naomi Walker  (aka N7FSA)     naomi%anasaz.UUCP@asuvax.eas.asu.edu

  Enthusiasm is caught,         In tennis, 
  not taught.                   love means nothing.
From: jan@bohra.cpg.oz.au (Jian Cai)
Newsgroups: comp.databases.informix
Subject: C-ISAM: deleting record also removes lock
Date: 26 Aug 92 23:20:00 GMT
Organization: Computer Power Software

Can anyone confirm (or reject) this statement:

C-ISAM, while in a transaction, removes the lock (if any) on a record
upon deletion of the record.

If this is true, and if the file is not locked, another transaction
can insert a record with the same key, and both are successful:
   transaction 1                    transaction 2
  delete record1
                                     insert record1
   commit                            commit
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: Why does this not work on one machine?
Date: 31 Aug 92 19:00:29 GMT
Reply-To: cortesi@informix.com
Organization: Informix Software, Inc.

In article <9208281432.AA00270@salmon.demon.co.uk> neil@salmon.demon.co.uk
("Neil S. Briscoe") complains that the following code doesn't
work on some machines:
> 	ON KEY (CONTROL-O)
> 	DISPLAY FORM sptq_frm_
> 	CALL short_query("Y", "N")
> 	CALL make_pat_name()
> 	CALL disp_patient()
> 	DISPLAY FORM add_appt_frm_
> 	DISPLAY diary_.* TO sc_find.*
> 	CALL disp_instruct()
> 	EXIT INPUT

To me the idea of displaying form "b" from within
an INPUT statement that is using form "a"; and then
repainting form "a"; is so bizarre it would never have
occurred to me -- nor, I would guess, to the developers...

Why f'r'evvins sake don't you open a subordinate window?
The code comes out shorter by a bit.

> 	ON KEY (CONTROL-O)
> -- 	DISPLAY FORM sptq_frm_
	OPEN WINDOW sptq AT 1,1 USING FORM "sptq"
> 	CALL short_query("Y", "N")
> 	CALL make_pat_name()
> 	CALL disp_patient()
> -- 	DISPLAY FORM add_appt_frm_
> -- 	DISPLAY diary_.* TO sc_find.*
	CLOSE WINDOW sptq
> 	CALL disp_instruct()
> 	EXIT INPUT

But then maybe I don't understand the whole point (as for
example I don't see why the EXIT INPUT is there...)
Newsgroups: comp.databases.informix
From: forney@esd.dl.nec.com (Elizabeth (Liz) J. Forney)
Subject: ESQL/C Application-Interface Library Documentation
Organization: NEC America, Engineering & Support
Date: Wed, 26 Aug 1992 21:23:43 GMT

A while back the function prototypes for the OnLine Engine interface
library was posted to the net.  Is there documentation available for the
engine interface routines?  Any help locating documentation for these
routines (such as _iqinsput, iqpopen, etc.) will be greatly appreciated.

Liz Forney
Software Engineer
NEC America, Inc.
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: SQL Ace Report Writer.
Date: 27 Aug 92 05:37:43 GMT
Organization: Enterprise Technology Center, Informix Software, Inc.

In article <9399@emory.mathcs.emory.edu> maint72@saad-emh1.ARMY.MIL (Michael Gordon) writes:
>>>THE PROGRAM KEY WORD DOSE NOT WORK AT ALL, NOT IN ANY CONFIGURATION I CAN
>>>COME UP WITH.
>>(Me:)
>>I've *never* heard of a PROGRAM keyword.  I just re-checked the doc (2.10.06)
>>and it says that "filename" or PRINTER are the only options. Is this Informix
>>documentation that you are looking at, or some third-party doc?
>>--
>>Alan Denney      aland@informix.com     
> 
>Alan,
> 
>This PROGRAM key word is directly out of the Informix SQL v.
>2.10.06 for MS-DOS, page 5-29.  To quote the line beneth the
>heading "PRINTER"; 'program    is the name of a system
>command'.
> 
>Dose this not read as if 'program' means a DOS System Command?

Oh, I get it.  If you look carefully, you'll see that <program> is
not listed in the Syntax or Notes sections.  It's only under the 
Explanation section.  It's a remnant from an early draft version 
of the manual (which starts from the UNIX version, which *does* support
"PIPE <program>".  It's a typo; cross it out.

>If "PRINTER" will sent the report output to the system
>printer, why won't other system commands work as well?

The DOS version does direct writes to PRN: if TO PRINTER is specified;
there's no program interface.

>I really don't expect a lot of positive answers from this
>message, because I know MS-DOS dose not work like Unix.  But,
>thanks for trying.
>					Michael S. Gordon
>					Foreman, Gyroscope Section
>					Avionics Division 
>

No problem.

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

"Platforms are built only for conventions to sit on, and fall into decay as
 of course when conventions adjourn." - Woodrow Wilson
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: 3 Sep 92 01:48:37 GMT
Reply-To: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
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 :-).
}
}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

I wasn't sure I believed this diagnosis, but you're quite correct -- I
cheated and looked at the source, and all the 4.1 stack routines do is copy
the pointer onto the stack.  The obvious thing to point out is that it is
only coincidence that the programs used to work at all; what if you had
tried to assign two successive values to the same allocated space, as in:

s = malloc(space);
strcpy(s, "something");
pushquote(s, strlen(s));
strcpy(s, "other string");
pushquote(s, strlen(s));
free(s);
return(2);

I fear me that you are going to have modify your code.  I will raise this
as an issue within Informix.

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: hitz@ifs.univie.ac.at (Martin Hitz)
Newsgroups: comp.databases.informix
Subject: buggy ROWID
Date: 31 Aug 92 17:18:03 GMT
Reply-To: hitz@ifs.univie.ac.at (Martin Hitz)
X-Informix-List-ID: <list.1409>

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

                     ^^^
                     !!!


Many thanks in advance, 


Martin Hitz
					
Department of Information Systems       Internet: hitz@ifs.univie.ac.at
University of Vienna                    Phone:    +43-1-40103-2795	
Liebiggasse 4/3-4                                 +43-1-436712
A-1010 Vienna (Austria, Europe)         Fax:      +43-1-430197

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?
Newsgroups: comp.databases.informix
From: ffang@newsuiowa.edu (Francis Fang)
Subject: DAL server for Informix DBs?
Date: Sun, 30 Aug 1992 16:19:44 GMT
Organization: University of Iowa, Iowa City, IA, USA
X-Newsreader: Tin 1.1 PL3

I'm currently running INFORMIX Online 4.0 on a DECsystem 5000/200. The
menu system of the application using the online engine is extremely
cumbersome and I would like to see if I can extract, update, and insert
new information directly from online on my Mcaintoshes. 

The best solution would be to have a DAL server running on the DEC with
client software (written in 4D, Hypercard, or some other
Hyperscript/Database software). 

I have spoken to informix and they seem to think that the only solution
is to run I-NET, I-STAR and use Datalink & Wingz.

Does anyone know if there is a general purpose (non-dependent on client
software) DAL server available that runs on a DECsystem running Ultrix
4.2? If not are there many folks running the configuration as suggested
above by informix?

Any info would be greatly appreciated.

Please post followups or reply to ffang@grover.printing.uiowa.edu (I
compiled the news reader I use with an incorrect reply to parameter).
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: buggy ROWID
Date: 4 Sep 92 05:01:58 GMT
Organization: Enterprise Technology Center, Informix Software, Inc.

In article <17vvm3INNc31@hpsdde.sdd.hp.com> kurt@sdd.hp.com (Kurt Andersen) writes:
>On the other hand, using 4.1 ISQL and the 5.0 SE engine on HP 9000/series 300
>I found the following behaviour:
>
>> select a.rowid arow, b.rowid brow, a.k ak, b.k bk from b, a where a.k = b.k
>> select a.rowid arow, b.rowid brow, a.k ak, b.k bk from a, b where a.k = b.k
>both generated:
>    arow   brow  ak  bk
>     3      3    1   1
>     3      3    3   3
>
>The only way to get the expected result was to use "b, outer a" in the 
>table specification.

If a and b are not indexed on k, and the problem goes away if a and b *are*
indexed on k, then this is probably bug 13029, specific to rowids in
5.00.U[CD]*.  It's fixed in 5.00.UE1 and beyond.

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

"I must have gone through 20 Porsches in the last 15 years.  Now I own 
 a Ferrari Testarossa.  My body would reject a Plymouth."
        -- Willie Brown, speaker of the California State Assembly
From: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
Newsgroups: comp.databases.informix
Subject: Physical and Logical Recovery
Date: 25 Aug 92 19:13:05 GMT
Article-I.D.: emory.9394
Reply-To: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
X-Informix-List-ID: <list.1398>



This is a little after the fact, but I have some questions about
recovery, on a Pyramid MIS S server, running Online 4.1.

I will pass on the details I have heard from the person on site.
The system in question was running along fine, when everything 
hung.  The logs were not full.  Bouncing the application programs 
did not help, so it was decided to bounce Informix.  

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.

Can someone offer a guess as to what was actually occurring, and what
we could have done to avoid going to the archive (without Informix 
patching)?


-- 
  Naomi Walker  (aka N7FSA)     naomi%anasaz.UUCP@asuvax.eas.asu.edu

  Enthusiasm is caught,         In tennis, 
  not taught.                   love means nothing.
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: List Server
Reply-To: shemminga@cix.compulink.co.uk
Date: Fri, 28 Aug 1992 11:22:37 +0000


Is there a listserver for informix products (I've seen vague hints to
suggest that there is.

If so could some kind soul point me in the right direction?
--------------------------------------------------------------
| 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           |                               |
| Roman Bank Bourne          | Tel :  (+44) 778 426444       |
| Lincs PE10 9LQ. UK.        | Fax :  (+44) 778 421862       |
--------------------------------------------------------------


Stuart
|8-)
From: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
Newsgroups: comp.databases.informix
Subject: Temp Tables
Date: 26 Aug 92 00:08:02 GMT
Reply-To: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
X-Informix-List-ID: <list.1400>


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.


-- 
  Naomi Walker  (aka N7FSA)     naomi%anasaz.UUCP@asuvax.eas.asu.edu

  Enthusiasm is caught,         In tennis, 
  not taught.                   love means nothing.
From: Steven.J.Richardson@um.cc.umich.edu
Newsgroups: comp.databases.informix
Subject: Informix vs. Oracle
Date: 27 Aug 92 15:18:04 GMT
Reply-To: Steven.J.Richardson@um.cc.umich.edu
X-Informix-List-ID: <list.1405>

Mr. Mathews:
 
  Both Informix and Oracle are represented on a group which is deciding on
RDBMS standards, the X/OPEN SQL Access Group.  Informix has taken a strong
stand on implementing these, apparently, and Oracle v. 6.0 seems to
implement more of what is considered to be "standard SQL" than Informix's
OnLine v. 4.0, so both companies should produce implementations along
the line identified by the X/OPEN Group.
 
  This having been said, I don't know how the salesman can say that
"Informix [will] soon be the new RDBMS standard on top of Oracle"--they
are moving toward a common SQL implementation...
 
  There is a VA office of X/OPEN, if you'd like more information:
 
     Suite 670, 3141 Fairview Park Dr.,
     Falls Church  VA
     Phone (703) 876-0044    Fax 876-0050
 
  I obtained some information about the SQL Access Group from John
Robertson of Hewlett-Packard, who is the chair of the group; there was
a write-up of the Group's activities in a trade magazine (earlier this
year).
 
  Steve Richardson/Merit Network, Inc.
---(Forwarded from: mathews@bones.ecs.umass.edu, Dated: Wed, 26 Aug 92 19:13:12 EDT)---
Received: from rmy.rmy.emory.edu by um.cc.umich.edu via Internet with TCP; Wed, 26 Aug 92 22:36:12 EDT
Received: by
        rmy.rmy.emory.edu (5.65/Emory_rmy.3.3.20) via MAILPROG
        id AA29766 ; Wed, 26 Aug 92 22:38:20 -0400
Return-Path: ilist@rmy.emory.edu
From: mathews@bones.ecs.umass.edu (Mathew J Mathews)
Message-Id: <1992Aug26.231313.28687@risky.ecs.umass.edu>
Subject: Informix vs. Oracle
Date: 26 Aug 92 23:13:13 GMT
Reply-To: mathews@bones.ecs.umass.edu (Mathew J Mathews)
Organization: University of Massachusetts, Amherst
To: informix-list@rmy.emory.edu
X-Informix-List-Id: <news.1715>
 
My boss was recently told by a salesman that Informix would soon be the new
RDBMS standard on top of Oracle.  Needless to say, she asked me to investigate.
I have not been able to find very much written on Informix.  Could anyone
give me their 2 cents, and/or point me to a good source of info?
 
Thanks,
 
Mathew J. Mathews
Univ. of Massachusetts at Amherst
mathews@risky.ecs.umass.edu
 
#disclude <inclaimer.h>
Newsgroups: comp.databases.informix