HDTenEightyP/NetNews huggingface dataset:
From: rridley@sin-pss.DHL.COM (Richard Ridley)
Newsgroups: comp.databases.informix
Subject: Tripping Server
Date: 14 Dec 1992 05:38:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: rridley@sin-pss.DHL.COM (Richard Ridley)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1696>


%UNIPLEX
%TO            informix-list@rmy.emory.edu
%FROM          rridley
%SYSTEM        DHLNET
%SUBJECT       Tripping Server
%VERIFY        y
%DATE          14/12/92 18:03
%REFERENCE     9241


We are experiencing problems with an application developed using
I4GL 4.0, and running on Online version 4.10.UE4 back-end.

The error message returned from either prepared select statements or
normally coded select statements are as follows :

SQL statement error number -211
Cannot read system catalog (systables).
System error number -101.
ISAM error: file is not open.

We have run tbchecks on the databases involved each time the error
appears, but no faults are reported. The problem itself cannot be
purposely duplicated - the engine seems to occasionally trip and send
out the error (it does this about 3 times a day).

The line that is supposedly causing the error is the prepare line
below:

let line3 = "select acc_no,company_name from cmf:accteadd where 1=1
and acct_addr_cat_cd = 'B'"
prepare line1 from line3
declare c4 scroll cursor for line1

Any ideas/help would be much appreciated - this problem does not seem
to occur when people are running 4.0 Online engine, but we are trying
to encourage upgrading to 4.1 Online, so it is important that we
track this one down.

Thanks in advance,

Richard Ridley
%UEND
Newsgroups: comp.databases.informix,comp.databases.sybase
From: tranth@egr.msu.edu (Thanh Tran)
Subject: database comparsion: Informix vs. Sybase; any info out there?
Organization: Michigan State University, College of Engineering
Date: Mon, 14 Dec 92 15:10:59 GMT

The subject line said it all:  Is there anything in the FAQ of those news
group, or are there any white papers on the subject achived somewhere on the
net.

Sybase seems to have more support from third-party (middle-ware) vendor and is
doing very well these day.  However, Informix is also coming out with trigger
in the Online 5.1 version.  As far as serious imaging application go, seems
like Informix are still the database choice because of their blob
implementation. For example, Informix allow a predefined page size increment
((8,16,32K) where Sybase only increment on a 2K page size.

Any information will be greatly appreciated.

Is informix a better choice for a image database and Sybase better for your
typical OLTP. (Wall Street type).

If you prefer to eamil me directly, I will summarize result and post.
Once again, thanks in advance!!!

Maybe in these day, the SAG, ODBC ... will really make these database talk
to one another and we don't have to choose between them and have them all
for whatever they are good for......
Newsgroups: comp.databases.informix
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: WingZ
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Tue, 15 Dec 1992 15:08:00 GMT

I've been looking for a database package for a Unix system, and am considering
Informix-SE among others.  Originally I wasn't considering WingZ as a front end
because I was told that it was somewhat limited as to what kind of queries it
could process.  For us, the main point of using a relational database is to
process complex SELECT statements--the description of WingZ as a "spreadsheet"
doesn't make it sound relevant to us.

On the other hand, I think we'd be better off with a completely X-windows based
GUI interface, rather than a character-based interface.  Hence, could anyone
comment on the ease-of-use of WingZ, and its flexibility in regard to SQL
queries, compared to Informix-4GL?

Thank you in advance,

Bill Thompson
From: jparker@hpbs2776.boi.hp.com (Jack Parker)
Newsgroups: comp.databases.informix
Subject: Invisible entry
Date: 18 Dec 1992 12:48:13 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: jparker@hpbs2776.boi.hp.com (Jack Parker)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1724>

> I couldn't think of a better way to phase this. I have a form that
> is basically an opening screen that asks for Employee Id and password.
> 
> In 4gl 4.0 how do I make it so the user DOESN'T see what they type as the enter
> their password. I like to be able to do it in the form. 
> 
> I try setting color attribute = invisible. I think I am may be confused as
> to what that attribute does. What does invisible mean? It is available
> attribute for display and prompt.
> 
> 				Thanks,
> 					Ceci

in the form:

f001=passwd, invisible;

OR in 4gl:

INPUT passwd FROM screen.passwd ATTRIBUTE(INVISIBLE) or (BLACK)

But all of this is pointless if the terminal in question does not have
a supporting termcap entry that defines invisible.  This would be the entry
for 'mk' in termcap or 'invis' in terminfo.  If you're code still doesn't
work, check those.  You can check terminfo from the command line by doing:

a=`tput invis`
echo $a"this is a test"
you should get a blank line.  (to see if that works do the same thing)
			      (with smso (a=`tput smso`) this should give)
			      (a highlighted (maybe reversed) string, all)
			      (depends on your terminfo)

To check what you are currently using as a terminfo $TERM do:

untic	(prints definition for your current $TERM)

To use terminfo instead of termcap (warning terminfo doesn't do color),
set INFORMIXTERM=terminfo. (default is termcap).

Write bAck with questIons, i'm sure I've conFused me.

lotsa luck,
	j.
_____________________________________________________________________________
Jack Parker - Contractor               | 
Hewlett Packard, BSMC Boise, Idaho, USA|     I've forgotten more than
jparker@hpbs2651.boi.hp.com            |           I ever knew
(208) 323-5388 (W)  (208) 384-1623 (H) |
_____________________________________________________________________________
Newsgroups: comp.databases.informix
From: holder@gourde.med.ge.com (Kacy Holder)
Subject: Re: Informix termcap
Organization: Computer People Unlimited, Milwaukee, WI
Date: 17 Dec 92 10:16:20



In article <1go378INNh9f@emory.mathcs.emory.edu> jparker@hpbs2776.boi.hp.com (Jack Parker) writes:
   Anybody got a good termcap/terminfo entry for an hp tube?  (Yeah, I know, look 
   where I'm working!).  Specifically I'm wondering if there is a solution to the
   magic-cookie-glitch for this thing.

   Also, has anybody ever got Informix to use attributes like DIM, UNDERLINE, or
   BLINK in a DISPLAY on an hp tube?  REVERSE is ok, but no others.


Me, too!  I can't find a way to get hpterms or xterms to run
isql, tbmonitor, vi, and man consistently in the same window.

Thanks!

--
Katharine C. Holder
Computer People Unlimited, Inc.
email: holderk@positron.med.ge.com

"These opinions are my own and not necessarily those of the client for whom 
 I am working or Computer People Unlimited, Inc."
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Newsgroups: comp.databases.informix
Subject: Re: Display array highlist
Date: 14 Dec 92 15:54:00 GMT
Reply-To: shemminga@cix.compulink.co.uk


TITLE: Re: Display array highlist

In <1992Dec10.181239.29704@mnemosyne.cs.du.edu> Andrew Burt asks:

[Stuff deleted]

> But, seriously, here's one that I haven't researched enough to know
> that it can't be done:
> 
> Is there any way to display a report to a window, and scroll through
> it (up/down)?

In your report include:

OUTPUT
        REPORT TO PIPE "less"  -- Assumes you have less. Pick it up at
                               -- FTP site near you NOW!

The only problem with list is that you will always get the output on
the screen.

An alternative is to set DBPRINT to the name of a file viewer and
have your report set up to REPORT TO PRINTER.

| I'm not bad, I'm just drawn that way -- Jessica Rabbit     |
|------------------------------------------------------------|     
| 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-)
From: cjaeger@bogart.uucp (Cecilia Jaeger)
Newsgroups: comp.databases.informix
Subject: Entering "invisible" data in a form
Date: 16 Dec 92 21:11:56 GMT
Organization: ism:c:m/xo

I couldn't think of a better way to phase this. I have a form that
is basically an opening screen that asks for Employee Id and password.

In 4gl 4.0 how do I make it so the user DOESN'T see what they type as the enter
their password. I like to be able to do it in the form. 

I try setting color attribute = invisible. I think I am may be confused as
to what that attribute does. What does invisible mean? It is available
attribute for display and prompt.

				Thanks,
					Ceci
-- 
+----------------+--------------------------------------------------------+
|  Ceci Jaeger   |   Domain: cjaeger@bogart.UUCP		          |
|  ---- ------   |   UUCP:  ...uunet!media!irscscm!bogart!cjaeger         |
+----------------+--------------------------------------------------------+
| Washington, DC |  "Some dance to remember, some dance to forget."       |
|                |   "Hotel California" --- Eagles                        |
+----------------+--------------------------------------------------------+
From: KOSARZYCKI@opal.oinov.poz.edu.pl
Newsgroups: comp.databases.informix
Subject: INFORMIX how many records ?
Date: 14 Dec 1992 16:03:55 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: KOSARZYCKI@opal.oinov.poz.edu.pl
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1700>

 Hi,
 I have a simple, maybe a FAQ question.
 How many records INFORMIX can handle - (a real value!) ?
 Where are a big databases which are maintened by INFORMIX programs -
 some e-mail addresses please.
   Krzysztof (Chris) Kosarzycki
 p.s.
   E-mail address of persons who writes a big bases
   in INFORMIX language are welcome
 p.s''
    Please send me responses directly to me becouse
    I'm not registered on the list


 Technical University of Poznan,
 Faculty of Electrical Engineering,
 Department of Control, Robotics and Computer Science
 Computer Science Laboratories
 ul.  pl. Sklodowskiej-Curie 5
 60-965 Poznan
 POLAND
 phone: +48 61 333615
 fax:   +48 61 330217

     Krzysztof (Chris) Kosarzycki
     e-mail : krzys@oippuxv.poz.edu.pl (Internet)
              KKOS@PLPUAM11.Bitnet
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Newsgroups: comp.databases.informix
Subject: Re: Suggesting changes to 4gl
Date: 14 Dec 92 15:54:00 GMT
Reply-To: shemminga@cix.compulink.co.uk


TITLE: Re: Suggesting changes to 4gl


In <1g8o6oINNq8c@emory.mathcs.emory.edu> Dave Snyder writes:

>Quoting David Stockel...
>}
>} >The top of my list is the input array statement.  It is just
>} >good enough to get you in trouble.  For example, it's a drag
>} >only being able to display all the elements of a program array
>} >to a screen array.
>}
>} How about a Highlite Row option in DISPLAY ARRAY/INPUT ARRAY?
>}
>} How about a simple way to control INSERT/DELETE in an INPUT ARRAY?
>}
>} How about a GOTO ROW command for the INPUT ARRAY?
>}
>} How about an INPUT/DISPLAY CURSOR comand?
>}
>} How about an USING parameter on the FOREACH command?
>}

All of this gets my vote.

> How about giving this man a cigar... great ideas Dave!  Informix, this is
> what your customers are asking for.

Should we hold our breath? Probably not.

| I'm not bad, I'm just drawn that way -- Jessica Rabbit     |
|------------------------------------------------------------|     
| 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: briand@anasazi.com (Brian Douglass)
Subject: Re: Suggested Changes to 4gl
Organization: Anasazi Inc Phx Az USA
Date: Tue, 15 Dec 1992 18:27:41 GMT

How about IFDEFs in 4GL code.  Sure would be handy to make customized
versions of standard products in a single source tree.
From: samp@DIALix.oz.au (Sam Pascoe)
Newsgroups: comp.databases.informix
Subject: Project Management Packages using Informix  WANTED
Date: 16 Dec 1992 11:48:43 +0800
Organization: Wally World
NNTP-Posting-Host: localhost.dialix.oz.au
Summary: Know any good Proj Mgmt sware using Infrmx?
Keywords: Project Management, Informix, Unix
X-Newsreader: NN version 6.4.19 #1



We are looking for a package (commercial/shareware/freeware)
that will be able to handle our engineering Project Scheduling 
requirements.

Some requirements are that it:
-	uses Informix (at least 4.0) as the database
-	runs on UNIX (at this stage HPUX 7.0/8.0 and AIX (Risc6000 box)
-	uses the Informix tools
-	does Project Scheduling (elementary, but a MUST)
-	can produce Gantt, Pert, and CPA reports
-	is capable of levelling across resources
-	will run on 'character' based terminals
-	will support multiple users, preferably simultaneously :-)

Comments and experiences on packages that NEARLY fit the above
are also very welcome.  It will give us a guide as to what else to 
look for (or lookout for :-) in these type of packages.

Anybody have any experience with a package called Hornet 
I believe that it is British...


email to samp@DIALIX.oz.au    Many thanks, =Sam=.
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Fixes to Informix-4gl
Date: 16 Dec 1992 22:13:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: dave.snyder@snide.com (Dave Snyder)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1713>

Quoting carl.t.mosley...
} 
}   How about an improved DISPLAY ARRAY where the user can, for example,
} press the letter "N" and the array will automatically scroll to the 
} row(s) beginning with "N"? If I am using DISPLAY ARRAY for some sort of
} "browse" function or a "pick list" I would like to allow a user to quickly 
} skip around in the array to find what they are looking for.  It is not 
} a good situation when I have a screen record of 10 rows and the array 
} being displayed has 200 choices and the user has to press "page ahead"
} 20 times to get to the end of the list...
} 
Sounds great... but what happens if the data isn't sorted alphabetically?
An example that comes to mind is in a medical system that I just wrote.
There is a pop-up window of languages that people have to select from.
In our area, ENGLISH is first, SPANISH is second, FRENCH third, etc.  I
display this by using an internal sequence number assigned by the customer.
Now although there are only about a dozen or two languages and "page ahead"
would only have to be hit twice, how would this work if you had many rows?

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
Newsgroups: comp.databases.informix
From: sglines@world.std.com (steve glines)
Subject: Re: Two index query optimization problem
Organization: The World Public Access UNIX, Brookline, MA
Distribution: usa
Date: Sat, 12 Dec 1992 11:56:14 GMT

In article <1992Dec12.000653.7004@anasaz> devin@anasaz (Devin Wala) writes:
>
>
>There are two indexes on the table:
>
>   index1: unique index on A, B;
>   index2: unique index on C, D, A, B;
>
>The problem I'm having is that I can't run a query with A and B mentioned
>in the WHERE clause that will use index2.  I suspect that the optimizer
>is looking at the query and saying; hey, I got A, I got B, I've got a unique
>index1 on both A and B.  Look no further, I am set dudes and dudettes, and 
>I am outta here! (optimizers talk like that you know).
>
>This would be fine if my queries were of the form:  
>
>   WHERE C=value AND D=value A=value AND B=value; 
>   
>However, one of my queries is of the form:
>
>   WHERE C=value AND D=value A>value AND B=value; 
>
>so it doesn't _really_ have a value for A.  I do need to have both
>indexes for performance reasons.  I don't think that setting optimization
>to low is an option in this case since it effects the whole database
>back end and not just the single query.  We are running Online V 4.10.UF2, 
>SQL V 4.00.UG2 on a Pyramid MI Server.
>
If uou split your query unto two statements:
where c=value and d=value and b=value into temp Q;
select * from Q
where a>value...

It'll work fine, but take a little longer than you anticipate.

PAX
Steve Glines
From: jgabriel@academ01.mty.itesm.mx (Ing. Juan Gabriel Ruiz)
Newsgroups: comp.databases.informix
Subject: Re: Help, tbtape is trashing my rootdbs!
Keywords: Online, IBM RT
Date: 17 Dec 92 15:16:26 GMT

davek@informix.com (David Kosenko) writes:
>What you should do is run a low-level disk surface check on the devices you
>are using for your chunks.  Typically, this problem is caused by bad blocks
>present on the device.

>As per bringing your system back up after a "bad block experience": if you
>edit your tbconfig file and set MIRROR to 1, you will be able to restart
>your system even though the chunk is marked as down.

I don't understand your information, you're saying that we need a very
clean hard disk to make Informix work, and I understand with this that
Informix doesn't have a bad block rellocation schema and I think this
is elemental.
In other way, you said that if we set MIRROR=1 we'll be able to restart
the system, but at what cost, doble disk space needed??

--
Juan Gabriel Ruiz Pinto                Internet:  jgabriel@mtecv2.mty.itesm.mx
Soporte Equipos UNIX                   NeXT-mail: jgabriel@roxette.mty.itesm.mx
Depto. de Tecnologia Computacional 
I.T.E.S.M. Campus Monterrey
From: inf_bb@hermes1.sps.mot.com (informix users bb)
Newsgroups: comp.databases.informix
Subject: tmp space question
Date: 18 Dec 1992 12:38:12 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: inf_bb@hermes1.sps.mot.com (informix users bb)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1723>


we have been having problems with our disk space not being released
by the engine.  we have a sun 690 running 5.0 online. 

several times we've had the case that one of the mounted devices
would become 100% full.  we looked at all the files for size, creation
time, etc. and nothing had changed that would have eaten up 100+ MB
of disk space.  this has happened to the home directory device as
well as the /tmp device.  ls -lt and du -s both said nothing had
changed on those devices.  in all cases, users were accessing the
databases and were asked to log out.  still no change in the free
space on the device.  the next step was to shut down the online engine.
at this point, the space was freed up.  im talking about 100's of MB
and random devices.  anyone else see this? whats going on?  on the
unix side, what should i look for when this is happening?

thanks in advance,

------------------------------------------------------------------------------
                                                            |     .     .
  Bob Baskett                                               |    ...   ...
  Software Engineer, DBA                                    |   ..... .....
  Business Systems Integration Group                        |  ..   ...   ..
  Semiconductor Products Sector                             | .      .      .
  Mesa, AZ                                                  |
                                                            |  Motorola, Inc
------------------------------------------------------------------------------
Newsgroups: comp.databases.informix
From: scotto@ipars.cts.com (Scott O'Connell)
Subject: Re: Suggested Changes to 4gl
Organization: Spectrum Data Services - Carlsbad, CA
Date: Tue, 15 Dec 1992 07:33:49 GMT
X-Newsreader: TIN [version 1.1 PL6]

Hi Paul,

I've had a feature on request for a long time.  I don't know the status but
I would very much like to see the ability to fill a screen record both
horizontaly and vertically.  ie.

row 1   row 6	row 11
row 2   row 7   ..etc
row 3   row 8
row 4   row 9
row 5   row 10


Currently Informix *only* let's you fill a screen record

row 1    row 2   row 3  ...etc

-- 

Scott O'Connell - N6ZEK                UUCP: {nosc, ucsd}!crash!ipars!scotto
Spectrum Data Services                 ARPA: crash!ipars!scotto@nosc.mil
Carlsbad, CA                           INET: scotto@ipars.cts.com
Newsgroups: comp.databases.informix
From: aburt@mnemosyne.cs.du.edu (Andrew Burt)
Subject: Re: "WordWrap" and temporary string storage
Organization: University of Denver, Dept. of Math & Comp. Sci.
Date: Sat, 12 Dec 92 00:17:59 GMT

>>One of the things I like about Informix-4GL is that it does NOT
>>have all them "bells and whistles."  This is also why I and many other
>>people like C.  Why have all those huge libraries filled with crud
>>you'll never use?  ...

>Here I have to disagree with you. Are you suggesting that I do *not* get
>a 200 Kb executable every time I write a "hello world" program? If so,
>I have a news flash for you :-). Actually, it's 227190 Bytes. I just
>checked. I suspect that this executable is filled with crud the program
>will never use. Does this bother me? Not really. I should have written
>it in C.

>I was under the impression that I4GL was a speciality language designed
>for developing database applications. If so, it makes sense that the
>libraries contain enough crud to do it as efficently as possible.

Exactly.  To strengthen the argument, consider that it probably adds MORE
to the size of the end result for me to have to code all this malarkey
every time I want to use it or via a code generator.  It probably would
take much less space if in the language; and we're talking about common
requests here, not arcane things only one person will use.

If you're *really* worried about executable size, create a cfglgo option
to create a runner that only has the stuff used in a given set of 4gl
code... :-)

Consider the various code generator deals out there right now, like
Dave Snyder's... The mere existence of these demonstrates (a) a need
and (b) a deficiency in the language for not meeting that need.

(Oh, and let's not forget how much we're all paying for these products,
compared to many other software packages, etc.  Yeah, I'm the guy who
posted before saying that if something has a high price tag then I have pretty
high expectations of it and it's support.  I hope the developers are reminded
of this daily... let's all chant, "Informix's cost implies users expect the
best"...)

(Oh, and let's retire the "but it's the same for Informix's competition"
argument.  It may be the same for other Unix database vendors, but let's look
at some other large, highly complex packages.  Does WordPerfect for Suns
cost $32,000 [a 1-user development license for RDS+Online for a class F
machine] ?  Er, no, that's $495.  As I ponder it, it seems that Informix is
one of (if not *the*) most expensive non-custom software package that
comes to mind.  I'm not griping about the price per se, but what one gets
for that price.  Here's hoping 4gl++ is an order of magnitude better
language than 4gl... (though, really, 4gl should have been better than it
is!).)

(Sorry for the excessive flaming, but sometimes with informix I feel like
I've, say, hired an extremely expensive executive secretary, and s/he spends
all day goofing off, messing up work, and being surly. :-)
-- 

Andrew Burt 		   					  aburt@du.edu

"But if he was dying he wouldn't bother to carve "Aaaaargh", he'd just say it."