HDTenEightyP/NetNews huggingface dataset:
From: igrdb@sunc9.informatik.tu-chemnitz.de (Ingo Gringer)
Newsgroups: comp.databases.informix
Subject: Help: Table exists but isn't eraseable!
Date: 22 Dec 1992 09:48:46 +0100
Organization: University of Technology Chemnitz, FRG
NNTP-Posting-Host: sunc9.informatik.tu-chemnitz.de

Hello World,

I'm asking a very simple but opaque Thing:

I have played with create table and create temp table .. and now I've got
the problem:

If I want to create a table called manipluation, the isql answers with:
310: Table (igrdb.manipulation) already exists in the database. 

If I try to get Table Info from the isql menu, there is no such a table: 
Not in the proposings and if I type this name into the input field, isql says:
839: Table not found.839: Table not found.

What can I do to solve this? Is this problem related to any temporary table -
where were they stored? (sqlturbo 4.00)

Thanks in advance for any hints

Ingo



ps: Merry Christmas!


                        *
                "      *O**
                      ****O	"
              "      O  ******		"
                    ******* O
                      O ********            
          "       *********O*****   "       
               "O**********"
            "     ***O**||****O**		"
                        ||
              ~ ~ ~ ~ ~ ~~ ~~ ~~ ~ ~ ~
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: INF4.1 -1 ERROR ?? problem
Date: 28 Dec 92 18:34:25 GMT
Organization: Informix Software, Inc.

>>>We have just started getting a new error which is described nowhere
>>>in the INFORMIX literature (whats new): -1. This happens when we
>>>install our package on UNIX . In one of our package-installation-scripts
>>>we start tbinit and straight afterwards try a drop database in a 4GL
>>>program. This gives us an error -1.

>Surely this should be user informix?

Why?  First of all, when you install Informix products, you do so as root,
not informix (informix would not allow setting up the permissions needed
on some of the files, which require root ownership with suid).  Second of
all, as the original poster  stated, they are using a package-installation-
script, which I doubt would be run as informix, more likely root or
install.

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: randall@informix.com (Randall Rhea)
Newsgroups: comp.databases.informix
Subject: Re: "WordWrap" and temporary s
Date: 18 Dec 92 03:22:37 GMT
Organization: Informix Software, Inc.

shemminga@cix.compulink.co.uk (Stuart Hemming) writes:

>In <randall.723872563@seashore> Randall Rhea writes:

>[Stuff deleted]

>> One of the things I like about Informix-4GL is that it does NOT
>> have all them "bells and whistles."  [...]

>I sorry but this is completely the wrong attitude! The highlight bar
>in display array is an obvious requirement. The fact that so many
>people have had to hack together a fix is enough to show that.
>Dynamic arrays are also a known requirement. To simply say you can
>simulate it by doing such-and-such is completely wrong. I mean why
>bother with INPUT ARRAY? With juditious use of INPUT, DISPLAY and


You are taking my comments out of context.  I am not saying that 4GL
is perfect and cannot be improved.  There have been many good suggestions
in this newsgroup on how the language can be improved, including the
ones you made.  But Informix-4GL is a programming language.  I was
simply reacting to an article that demanded that it be something
else.  (e.g. a forms generator like SQL*Forms)   I like having a tool
that is a true programming language.  It provides the flexibility
essential for complex business applications which, IMHO, SQL*Forms does
not.

-- 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Randall Rhea                                        Informix Software, Inc. 
Project Manager, MIS Sales/Marketing Systems    uunet!pyramid!infmx!randall
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: Tripping Server
Date: 18 Dec 92 02:55:06 GMT
Organization: You tell me, then we'll both know.

In article <1gho6eINNikv@emory.mathcs.emory.edu> rridley@sin-pss.DHL.COM (Richard Ridley) writes:
>%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.
>
>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

Is the cmf database on the same server as your primary database?
Is it intact and OK?

Are you mixing 4.0 and 4.1 engine processes or server processes in
the same environment?

>Richard Ridley

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

  Smith and Wesson: the Ultimate Point-and-Click User Interface.
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: Error 208 - Memory Allocation
Date: 28 Dec 92 19:32:18 GMT
Distribution: na
Organization: International Brotherhood of Geeks, Local 619

In article <1992Dec26.210807.5884@Thalatta.COM> bossert@thalatta.com (John Bossert) writes:
>Environment:
>
>4GL - 4.10.UD1
>OnLine - 5.00.UC3
>
>Sparcstation IPX, SunOS 4.1.3
>
>When I try to run an application (that ran fine under 2.10.03 :-( )
>I get:
>
>#208 - Memory allocation failed during query processing.
>
>Anybody got a suggestion?
>
>In-Real-Life: John Bossert, Thalatta Corporation, (+1 206.455.9838)

My guess would be that your SHMBASE is set too low -- the default used for
5.0 Sun Sparc ports was a poor choice.  Try changing your SHMBASE to
0x10000000L and restarting OnLine.

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

"People burn more calories while sleeping than while bowling"  
                                               - Rush Limbaugh, 12/17/92

~
From: rridley@sin-pss.DHL.COM (Richard Ridley)
Newsgroups: comp.databases.informix
Subject: Tripping Server II
Date: 23 Dec 1992 07:43:05 -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.1735>


%UNIPLEX
%TO            informix-list@rmy.emory.edu
%FROM          rridley
%SYSTEM        DHLNET
%SUBJECT       Tripping Server II
%VERIFY        y
%DATE          23/12/92 20:10
%REFERENCE     9933

Hi there informixer's :

A while back I sent a mail asking if anyone had experienced problems
with Online 4.1 sending out error :

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

We can now duplicate this with the following piece of code :

<========================================================>

DATABASE tst
DEFINE   query2            char(1500)

main

        CALL first_function()
        CALL second_function()
        CALL first_function()
        CALL second_function()

end main

FUNCTION first_function()

        WHENEVER error continue
        DROP table 1st_temp_tab
        WHENEVER error stop

        PREPARE query2 from "SELECT rowid from any_table where
                             rowid = 1 into temp 1st_temp_tab"
        EXECUTE query2

END function

FUNCTION second_function()

        WHENEVER error continue
        DROP table 2nd_temp_tab
        WHENEVER error stop

        SELECT unique col1,col2
                FROM db2:table1
                WHERE col1 = 8000089
                and col2 = 35 into temp 2nd_temp_tab

END FUNCTION

<========================================================>

The program fails with the above error during the second instance of
'second_function', at the select statement.

We have noticed that, if we place 'FREE query2' (after removing the
DEFINE query2 statement ) after the 'EXECUTE query2' in the first
function, the program runs fine.

Has anyone experienced this problem with Online 4.1 before ?

Cheers,

Richard Ridley
%UEND
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: FORM FEED IN REPORTS
Date: 18 Dec 92 03:17:08 GMT
Organization: You tell me, then we'll both know.

In article <1gnr51INNa7d@emory.mathcs.emory.edu> yaron@ortarg.edu.ar (Yaron Zarfati) writes:
>Hi, I need help on the behavior of the SKIP TO TOP OF FORM statement in 
>reports.
>When this statement is reached, informix fills the report with empty lines
>until it reaches the number specified in the PAGE LENGTH statement.
>This slows down the printing, so what I would like to know is if does somebody
>knows how to make informix to use the formfeed character ???
>                                      --------

If you have 4.1, you can use 
   TOP OF PAGE "^L"
in the Output section of your report.  

See Page S-48 of the 4GL 4.1 Supplement.

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

"But you know what?  There's another point that I'd like to make: 
 it's very possible that Adolf Hitler kept a very nice check book.  
 You know?  I mean, and that's fine."    -- Barbara Boxer, 10/24/92
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Error 208 - Memory Allocation
Date: 28 Dec 92 18:28:47 GMT
Distribution: na
Organization: Informix Software, Inc.

John Bossert writes:
>Environment:
>
>4GL - 4.10.UD1
>OnLine - 5.00.UC3
>
>Sparcstation IPX, SunOS 4.1.3
>
>When I try to run an application (that ran fine under 2.10.03 :-( )
>I get:
>
>#208 - Memory allocation failed during query processing.
>

This error is caused by an error code being returned from Unix when a 
malloc() is issued.  Check to make sure that your kernel does not limit
the amount of memory allocatable by a process (that is, non-shared-memory
memory). In your 4gl code, you could FREE any cursors or prepared statements
that you no longer need.

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: alex@lucas.MREC.AR (Alejandra Perez Weiss)
Newsgroups: comp.databases.informix
Subject: Using multiple GLOBALS files
Date: 29 Dec 1992 10:23:05 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: alex@lucas.MREC.AR (Alejandra Perez Weiss)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1742>

hello,

Does anybody know how can I do something like these:

in a.4gl -> GLOBALS "glo1.4gl", "glo2.4gl"

or

in glo.4gl -> GLOBALS
				"glo1.4gl"
				DEFINE a, b, c ....
			  END GLOBALS

Any hints ?

ale.
---

By the way, I'm re-sending a question nobody answered:  

On last July, Steve Price wrote a report on the Informix User Conference
and he mentioned two new informix products announced for "late 1992 or
early 1993". 
They are Hypertools (programming tools for hyperscript, with embedded SQL)
and STORM (report and forms design facility for non-programmers)

Does anybody know anything about them ?

He also talked about a toolset for developers called EISToolKit from
MicroStrategy, Inc. 
Is there anybody using it ? Does anybody know how to contact this company ?

Thanks in advance,

ale.

-- 
Maria Alejandra Perez Weiss              alex@lucas.mrec.ar
PNUD - Min. Rel. Exteriores              alex%lucas.mrec.ar@uunet.uu.net
Buenos Aires - Argentina                 ...!uunet!atina!lucas!alex
Newsgroups: comp.databases.informix
From: M21520@mwvm.mitre.org
Subject: Re: MacTCP problem with Informix DataLink
Organization: The MITRE Corporation, McLean VA 22102
Date: Tue, 29 Dec 1992 17:28:22 GMT

I am reposting this here, because I incorrectly specified the address of this
group on my first attempt:
 
>Hello MacTCP experts!
>
>We have been using Wingz DataLink to communicate with an Informix database
>on a UNIX host.  This set-up requires MacTCP.  We have maintained a relatively
>stable connection for over a year now, and have been able to solve any
>problems - until now.
>
>When anyone uses DataLink to open a connection w/ a database on the UNIX host,
>the following error message appears: "Your MacTCP software had problems
>sending data because the TCP connection went down. (ERR# -27015)".
>
>(BTW,does anyone have a listing of MacTCP error codes? )
>
>Whenever I experience *any* problems with DataLink, the first thing I do is to
>check the connection with NCSA Telnet.  I have no problems connecting with the
>UNIX host with Telnet (MacTCP version).  This suggests a problem between
>DataLink and MacTCP.  I know that DataLink has been configured properly; we
>have not experienced *this* problem before. The problem occurred suddenly and
>affects all of our DataLink users (so it is highly unlikely that we all did
>something stupid to our DataLink configurations :-)); this seems to suggest
>some single point of failure... maybe the UNIX host?... maybe the network
>itself?  These are the only things I can think of that are common to all the
>users.
>
>I am out of my league, so I am seeking the wisdom of the Internet community
>of Mac communication gurus.  Thanks in advance for any help!
>
>Please respond via e-mail to: m21520@mwvm.mitre.org
>
Brian O'Sullivan            m21520@mwvm.mitre.org
MITRE Corp. NASA HQ site
Washington, DC
             ** my opinions are not MITRE's **
Newsgroups: comp.databases.informix
From: dave@bradley.bradley.edu (David Vessell)
Subject: Re: Improvements to I4GL
Organization: Bradley University
Date: Mon, 21 Dec 92 16:43:06 GMT

To all these suggestions, I want to add one more.

I would like to see AUTOWRAP capability restored to the CONSTRUCT
statement.  Originally it was allowable, but Informix considered it a bug
and 'fixed' it, which absolutely killed us here, because in our
applications here we do a lot of querying on fixed-length fields, one value
at a time.  The users never use ranges of data or anything else like that.
Because of this fix, every field now must be followed with a carriage
return in order to move to the next field.  I don't see why this should be
an either-or thing.  It should be definable in the screen form.  If you
need the query window at the bottom for larger-than-field search criteria,
specify it in the screen form.  But having AUTOWRAP capability restored
would be a godsend to us.

-- 
*davE*   Making the world safe for intelligent dance music.  dave@bradley.edu.
########## David L. Vessell -- Bradley University Computing Services #########
Your shame is neverending. Just one psychological drama after another.-Erasure
Newsgroups: comp.databases.informix
From: malcolm@prickle.demon.co.uk.demon.co.uk (Malcolm Apps)
Subject: Re: Start values for serial columns 
Distribution: world
Organization: The 4GL Factory Ltd
Reply-To: malcolm@prickle.demon.co.uk
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.19)
Date: Wed, 30 Dec 1992 20:57:17 +0000

Thanks for the advice guys - I'll give up trying and encourage people
to document the system properly.
-- 
+-----------------------------------------------------------------------------+
   We'd be fools not to ride this strange torpedo all the way out to the end.

   Malcolm Apps, The 4GL Factory Ltd, Bristol, England
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: Fixes to Informix-4gl
Reply-To: shemminga@cix.compulink.co.uk
Date: Mon, 21 Dec 1992 09:05:00 +0000


TITLE: Re: Fixes to Informix-4gl

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

[Stuff deleted]

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

I think this one should be looked at more in the principle of the
thing rather than in the execution of the given example. Could it not
be arranged so that the displayed list was indexed on some column and
have the "page ahead" funtion work on that column?

| 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: randall@informix.com (Randall Rhea)
Newsgroups: comp.databases.informix
Subject: Re: "WordWrap" and temporary s
Date: 19 Dec 92 00:28:49 GMT
Organization: Informix Software, Inc.

aburt@mnemosyne.cs.du.edu (Andrew Burt) writes:

>In <memo.808385@cix.compulink.co.uk> shemminga@cix.compulink.co.uk (Stuart Hemming) writes:
>>In-Reply-To: <randall.723872563@seashore> randall@informix.com (Randall Rhea)
>>TITLE: Re: "WordWrap" and temporary string storage
>>In <randall.723872563@seashore> Randall Rhea writes:

>>> One of the things I like about Informix-4GL is that it does NOT
>>> have all them "bells and whistles."  

>Has informix forgotten what "Fourth Generation Language" means???
>Personally I think Informix has the wrong attitude toward customers.


My comments were taken out of context.  I did not say that
Informix-4GL was perfect and could not be improved.  I reacted to
an article that proposed making 4GL more like forms generators
such as SQL*Forms.   That would mean changing 4GL from a programming
language into something else.  I do not believe that SQL*Forms has sufficient
flexibility to be used for development of complex business applications.
I say this because I've tried it.  I like 4GL because it's worked
for the things I've used it for, including order entry and financial
systems.  I have tried other 4GL tools and have not had the success
that I have had with Informix-4GL.  4GL is not perfect, but it's
better than the other things I've tried.  

I do not wish to see Informix-4GL go down the same road as SQL*Forms.
SQL*Forms was a reasonably useful forms generator in its 2.3 version.
Oracle then "listened to their customers" and added feature after
feature until it became an unmanageable monolith.  The result,
SQL*Forms 3.0, was slower, buggier, much more difficult to learn,
and less useful despite the additional features.   

Is 4GL perfect?  No.   Can it be improved?  Yes.  Should Informix listen
to its customers?  Yes.   Do like 4GL, despite its weaknesses?  Yes.
Would I like to see it radically re-designed?  In my opinion, no.
You may have a different opinion, and that is fine.  

-- 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Randall Rhea                                        Informix Software, Inc. 
Project Manager, MIS Sales/Marketing Systems    uunet!pyramid!infmx!randall
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: INF4.1 -1 ERROR ?? problem
Date: 30 Dec 92 16:25:46 GMT
Organization: Informix Software, Inc.

shemminga@cix.compulink.co.uk writes:
> >>Surely this should be user informix?
> > 
> > Why?  First of all, when you install Informix products, you do so as root,
> > not informix (informix would not allow setting up the permissions needed
> > on some of the files, which require root ownership with suid).  Second of
> > all, as the original poster  stated, they are using a package-installation-
> > script, which I doubt would be run as informix, more likely root or
> > install.
> 
> I'll shut up 'cos I'm at home and can't check, but I'd've been
> willing to bet real money that my installation instructions said,
> "Create a user/group informix, log in as user informix, install
> software..."

How much money do you care to sacrifice ;-)?  If you check page 7 of the
Installation guide for 4.1 (page number may be different for other releases,
though the procedure is the same), under step 1., you will see "Log in as
root."   It is true that you are directed to create an account for user
informix (which, generally, must be done by root), but at no point do the
instructions tell you to log in as informix for the installation.  As in
my message that you have responded to, I will point out that user informix
would not allow the assignment of ownerships and permissions necessary for
several of the products, which require root ownership with suid.

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: sglines@world.std.com (steve glines)
Subject: Re: mail problem
Organization: The World Public Access UNIX, Brookline, MA
Date: Sun, 3 Jan 1993 01:02:48 GMT

Informix prices have placed their products beyond the reach of my clientel.
I no longer sell or support their products.

Steve Glines
--
From: girard@informix.com (Girard Chandler)
Newsgroups: comp.databases.informix
Subject: Re: Suggested Changes to 4gl
Date: 19 Dec 92 03:29:35 GMT
Organization: Informix Software, Inc.
Originator: girard@hyperion

In article <1992Dec16.213256.21452@nezsdc.icl.co.nz> you write:
: John Oliver writes...
: >How about dynamic use of I4GL call command, i.e be able to issue:-
: >	call func_name 
: >where func_name is a char variable storing the name of a function. 


I think we have this (sort of.)  See pages S-198 -> S-212 of the 
4.1 4GL supplement.  We provide a fgl_call(char *funcname, int
nparams) macro which turns into:

	p4gl_call("funcname", nparams)	- 4gl-rds
or simply,
	funcname(nparams)		- w/c4gl

So, using a very short C function with 4gl-rds, you can call functions 
"by name."  In C-4gl, the only method to do this would be to create a 
lookup table of strings and function pointers.


: >Under the current I4GL, this is impossible. The best you can do us use the run
: >command to run named stand alone executables, but this leaves a whole
: >lot of sleeping parent processes around when leaves of complex menu trees 
: >are reached.


Or, in 4gl-rds, you can load individual pcode files dynamically and
execute them (see the fgl_start() function, page S-207.)

: >------------------------------------------------------------------------
: > John Oliver, Ernst & Young Management Sciences, Auckland, NEW ZEALAND
: Hugh Grierson          Fujitsu/ICL New Zealand - Software Development Centre



Girard Chandler	(Informix 4GL Development)