HDTenEightyP/NetNews huggingface dataset:
From: riskit@x400gate.bnr.ca (Reg Foulkes)
Subject: Re: Updating within a scrolling cursor
Followup-To: comp.databases.informix
Organization: Bell-Northern Research
Date: Mon, 11 Jan 1993 14:14:52 GMT

In article <1ik9fsINNhbe@emory.mathcs.emory.edu>, dave.snyder@snide.com
(Dave Snyder) wrote:
> 
> Quoting Reg Foulkes...
> } 
> } I would like to access the temporary file created by the a scrolling 
> } cursor. Anyone know how to do this (i.e. what is the mystery table name)? 
> }  
> }  Here is what I would like to do
> } 
> }   Declare scrolling cursor sel_stmt 
> }   Open sel_stmt
> }   RUN "insert into mystery_table VAULES (....) | isql database - -"
> }                    ^^^^^^^^^^^^^
> }   FETCH next sel_stmt
> } 
> Won't happen.  First of all, I don't think you can access a cursor's tmp
> table.  Second, even if you were using a real tmp table, when you execute
> the RUN command to do the INSERT, a new database process is started.  The
> tmp table from your first database process is not available to any other
> database processes.

 Sorry but you are mistaken. Currently, I can create my own tmp table and 
it works fine. I just wanted to bypass that step and go directly to the 
temp table created by the open and do an insert before a fetch. This 
saves me from creating the temp table. That I use for the fetch.
Unfortunately,
informix hides its' system temp tables so I am unable to use them. Why?

riskit@bnr.ca
phone (613) 763-4131
Ottawa, Ontario Canada.
From: widener!uunet!ge!dedes!dedes@emory.mathcs.emory.edu (Apostolos Dedes)
Newsgroups: comp.databases.informix
Subject: Informix & Tuxedo
Date: 7 Jan 1993 18:48:07 -0500
Organization: GE Information Services
Distribution: world
Reply-To: widener!uunet!ge!dedes!dedes@emory.mathcs.emory.edu (Apostolos Dedes)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1761>

Help!
I need to get the 2-phase commit to work using Informix as the Database
Manager & Tuxedo as the Transaction manager. If someone on the net has
already done this I would appreciate a phone call or a personal message
for a couple of questions that I have.

Thanx,
-Toly uunet!ge!dedes
(301)340-4959

#############################################################################
#     In-Real-Life : Apostolos Dedes        | GEnie  : APOSTOLOS            #
#     Zodiac-Sign  : Leo                    | uunet  : uunet!ge!dedes       #
#     Organization : GEIS                   | Work   : (301)340-4959        #
#                    401 N. Washington Str. | Home   : (301)990-6572        #
#                    Rockville, MD 20850    | Fax    : (301)340-5340        #
#############################################################################
From: tstar!verbus@psds.attmail.com
Newsgroups: comp.databases.informix
Subject: isql query VS ace report writer query
Date: 5 Jan 1993 18:28:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: tstar!verbus@psds.attmail.com
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1751>

Hi,

We have a query that produces different results when run
by "isql" than when run under the ace report writer.
The output is as expected in isql but incomplete, a subset of
the expected output, when run under the report writer.

Are there any known exceptions, do's and don'ts, when using the
report writer?  Our query does have an order by clause, but
we are not using a integer or a column name with a table prefix,
page 5-36, Informix SQL Reference Manual, Version 4.00.

We have Informix-SQL 4.00.UE2 under AT&T UNIX SVR4.0 2.1 on
a i386/33 platform.

Thanks in Advance!



 
Regards,
Verbus M. Counts,  AT&T/NCR   Customer Support     (703) 691-6134 VOICE
                                                   (703) 691-5659 FAX  
email: verbus@attmail.com   OR   ...att!attmail!verbus
From: eric@nit.pactel.com (Eric Pederson)
Newsgroups: comp.databases.informix
Subject: sqlturbo processes don't die
Keywords: sqlturbo online i-star
Date: 8 Jan 93 17:46:07 GMT
Organization: Pac*Tel Corporation

On our Online/I-star systems the sqlturbo processes don't seem to quit,
even when a "close database" has been run from the client.  The only way
to get rid of these processes is via kill.  How can we get these things
to go away?

-- 
Eric Pederson                                       Pac*Tel Corporation
eric@nit.pactel.com                                        510-210-8890
From: unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah)
Newsgroups: comp.databases.informix
Subject: Re: "Invalid message received from database engine"...
Date: 7 Jan 93 14:48:06 GMT
Reply-To: unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah)
Organization: Mailing List Gateway
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1756>

This message stemps from the broken pipe between sqlturbo & the engine.
This message means that there is nothing wrong with your query ... but
you should see the environment. (eg pipes, kernel parameters, env space etc).
We have experienced this problem multiple times and each time it was 
faulty device driver or a bug in a new driver we are in the process of coding
which has nothing to do with Informix.

========================================================================
Bharat Shah                                        Voice: (508)-663-7570
Unifi Communications Corp.                           Fax: (508)-663-7543
4 Federal St, Billerica, Mass 01821, USA          uunet!bharat@unifi.com
========================================================================
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Differences between SE and On-Line?
Keywords: Informix SE On-Line
Date: 6 Jan 93 16:24:23 GMT
Organization: Informix Software, Inc.

In article <C0EwAs.2x1@panix.com> coop@panix.com (Robert Cooper) writes:
>I know that On-Line is the big brother (sister?) to SE in that it
>has more record locking features, choice of raw or native file system,
>etc. Thats all fancy OLTP stuff. What about other features like BLOBS,
>stored procedures, triggers? How far behind does SE lag after On-Line
>gets new features?

OnLine and SE are released simultaneously (they are considered part of the
Servers and Connectivity group of products, which includes network, i.e.
I-Net and I-Star, and embedded language products), so there is no "lag".
There are features that have been and will be added to OnLine that are
not part of SE, but these will never be part of SE (BLOBs, for example).
In general, any SQL level feature will be in both servers, though there
are exceptions.

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
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: Display array highlist
Reply-To: shemminga@cix.compulink.co.uk
Date: Tue, 12 Jan 1993 17:01:00 +0000


Does anyone from Informix want to pick this up as I don't think we've
finished with it.


| I work with some bloody strange people, and so do they!    |
|------------------------------------------------------------|     
| 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             |
From: rperkins@emh_1.submepp.navy.mil (RPERKINS)
Newsgroups: comp.databases.informix
Subject: FOURGEN Tools
Date: 12 Jan 1993 09:28:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: rperkins@emh_1.submepp.navy.mil (RPERKINS)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1774>

I would like to communicate with anyone having experience with FOURGEN 
development tools. I am interested in development problems, software bugs, 
development designs to avoid, software shortcomings, general impressions or 
other tidbits anyone would care to share.
---------------------------------------------------------------------------
    Bob Perkins
    Internet: rperkins@emh_1.submepp.navy.mil
    (IP 192.111.116.26)
    Voice: (603) 427-2161
    Fax:    (603) 427-5002
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Find Next row - Performance questions
Date: 9 Jan 1993 19:03: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.1765>

Quoting John LeBrun...
} 
} 	The largest performance problem occurs when executing a
} logical next/prev record request.  (To explain: a logical next record,
} given a key of N columns and a value, find the next record in key
} order) I currently have an implementation that is flexible enough to
} return the correct request for any table or key.  I am looking for
} comments and suggestions on ways to improve performance.
} 
  [ lots of statements and examples ommited to conserve band-width ]

I don't know why there is a problem.  If you create an index on say...
(lname, fname, custno) and then declare the following cursor:

  DECLARE cust_curs SCROLL CURSOR FOR
    SELECT * FROM customers ORDER BY lname, fname, custno

it will do exactly what you need it to do when you open it and start
fetching.

Are you new to Informix-4GL?  If so, Informix's book 4GL By Example is
a great book to learn from.  You also might want to pick up a copy of
"db4glgen" my public domain 4GL screen code generator.  Good luck with
your project!

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: root@rebell.rmt.sub.org (Gottfried Hamm)
Newsgroups: comp.databases.informix
Subject: Re: Differences between SE and On-Line?
Keywords: Informix SE On-Line
Date: 8 Jan 93 00:33:32 GMT
Organization: rebell * +49 6249 8842 * D-6524 Guntersblum

In <C0EwAs.2x1@panix.com> coop@panix.com (Robert Cooper) writes:
>A second question, if I may. How is informix in the PC world? I'm
>thinking of SE on a RS/6000 server and/or a Novell server. Any
>experiences I should know about?

There exists a version of INFORMIX running standalone on a PC. The
other possibility is to connect PCs via an ethernet and TCP/IP with
a UNIX-Host. On the host will run Online and Star as Net-software,
on the PC you have to run INFORMIX PC Net which will connect to the
host. This works with version 4.x.

Gottfried



-- 
+---------------------+----------------------------------+--------------+
| Gottfried Hamm      |  Email: root@rebell.rmt.sub.org  |     I'm      |
| Wormser Str. 36     |  Phone: +49 6249 8997            |   awaiting   |
| D-6524 Guntersblum  |  Fax  : +49 6249 8842            | your mail... |
+---------------------+----------------------------------+--------------+
From: barrym@informix.com (Barry Mednick)
Newsgroups: comp.databases.informix
Subject: Re: Turbo 'too many users' error
Summary: old bug
Keywords: informix,turbo,keys
Date: 8 Jan 93 22:20:15 GMT
Distribution: usa
Organization: Informix Software, Inc.

In article <1993Jan7.203618.21467@cbnewsm.cb.att.com> seeb@cbnewsm.cb.att.com (Dick Seebach) writes:
>
>We are running Turbo 2.10.03 on a 3B2. Several users can access
I assume you mean version 1.10.03K
>the database simultaneously. After being up for several days,
>only one user will be allowed to access the database at a time;
>other attempts to open the database will fail with sqlcode -529,
>cisam code -129 (too many users).
>
>However, tbstat -u shows only a few users accessing the database,
>much fewer than the 100 defined in tbconfig.
>
>The problem is cleared by stopping and restarting turbo.

Sounds like bug 6295, fixed three years ago in version 4.00.UC1.
I would recommend upgrading.
-------
Newsgroups: comp.databases.informix
From: ciacovel@telesciences.com (Chris D Iacovelli)
Subject: Report Generators
Organization: TeleSciences CO Systems, Inc.
Date: Tue, 5 Jan 1993 17:39:06 GMT

Informix Netters,

 I am looking for info on report generators for informix. Please post or
email me name and address for any vendors.

Thanks
Chris
Christopher D. Iacovelli
Member, Technical Staff
TeleSciences CO Systems
ciacovel@telesciences.com
From: unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah)
Newsgroups: comp.databases.informix
Subject: OnLine.USERS.parameter
Date: 6 Jan 1993 14:13:05 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1752>

Hi,

We have been using SCO-OnLine since last three years and I have yet to figure 
out the **TRUE** meaning of the USERS shared memory parameter.

USERS imply maximum number of users

Page 2-28 of Informix OnLine Administrator's Guide,
Database Server Version 4.00 states:

   " ..... Daemon and tape utilities count as users.
    Minimum number of users is given by the equation 4 + p + m

    where p is the number-of-page-cleaners
          m is 1 if you use disk mirroring and
          m is 0 if you are not using mirroring"

My question goes if:

p = 1 and m = 1 and
I want five "people-users" (one each for isql, esql/c, forms, Wingz, Ace) 
to use the engine what should be my setting for USERS ?

If your answer is  5 + daemon + (p=1) + (m=1) = 8 ... You are wrong !!

On calling Informix Tech Support I was told that for five people user the
setting should be (5 * 4) + p + m = 22 !!

My license being for 16-users I was not sure if this was OK, so I called
again to confirm USERS setting of 22 and queried some other Support
engineer. He not only refused to confirm the setting but seemed upset at 
the previous engineer for giving me the **REAL** formula !!

Some simple experiments showed that a value of 10 would suffice for my needs.

MY GRIPE HERE IS WITH DOCUMENTATION and WITH INFORMIX TECH SUPPORT !! 

IF ONLINE REQUIRES MAX USERS SETTING WHY NOT DOCUMENT A FORMULA TO
COMPUTE MAX ? WHY BOTHER TO GIVE A FORMULA FOR MINIMUM SETTING ?

WHY NOT BE FORTHCOMING AND SAY THAT **USERS** SETTING IS THE NUMBER OF
PROCESSES (This though could be found out by reading the tbconfig file which 
states that users = max number of concurrent processes). I guess I had better 
read all Informix provided scripts & files to to understand the product!

Comments welcome.

========================================================================
Bharat Shah                                      Voice: (508)-663-7570
Unifi Communications Corp.                         Fax: (508)-663-7543
4 Federal St, Billerica, Mass 01821                     bharat@unifi.com
========================================================================
From: ramesh@informix.com (Nagar Ramesh)
Newsgroups: comp.databases.informix
Subject: Re: Recovery
Date: 10 Jan 93 06:41:44 GMT
Organization: Informix Software, Inc.

In article <1inm5vINN3gm@emory.mathcs.emory.edu> unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah) writes:
>Welcome to the world of STUCK FAST RECOVERY ...
>I have faced this problem on more than one occassion and I have been asked to 
>wait for version 5.0 where HIGHT_WATER settings can solve this problem.
>
>Bharat.

hi bharat,

i don't know the version of the engine you have, but if you have 4.10
you can edit the tbconfig file to include the two long transaction water
marks - LTXHWM and LTXEHWM which are commonly set to 75 and 80
respectively (percentage values).  

LTXHWM is the Long Transactio High Water Mark - set to 75% which tells
       online to roll transactions back when the logs are 75% full.

LTEXHWM is the Long Transaction Exclusive High Water Mark - set to a 
        value > LTXHWM, usually 80% , which when reached, gives 
        "exclusive" access of the logical logs to the transaction
        currently being rolled back.

just a brief explanation but i hope it helps.

regards,

ramesh.





>
>========================================================================
>Bharat Shah                                        Voice: (508)-663-7570
>Unifi Communications Corp.                           Fax: (508)-663-7543
>4 Federal St, Billerica, Mass 01821, USA          uunet!bharat@unifi.com
>========================================================================
Newsgroups: comp.databases.informix
From: rridley@sin-pss.DHL.COM (Richard Ridley)
Newsgroups: comp.databases.informix
Subject: RE: UPDATE problem on UNIQUE constraint
Date: 6 Jan 1993 22:23:04 -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.1755>


%UNIPLEX
%TO            informix-list@rmy.emory.edu
%FROM          rridley
%SYSTEM        DHLNET
%SUBJECT       RE: UPDATE problem on UNIQUE constraint
%VERIFY        y
%DATE          07/01/93 10:28
%REFERENCE     10661

Pedro Freire writes :

>When the statement is executed, it proceeds by looking up the first
>row that satisfies the condition, updating it and then repeats the process
>with the next row and so on, until there are no more rows to update.
>The question is that, when updating a row that has c_int_art = P and row P+1
>exists and hasn't been updated (yet), after the update you'll have 2
>rows P+1 and that violates the UNIQUE INDEX constraint, which causes
>the statement (and the program) to be aborted with the following error message:

>"Could not update a row in the table"
>SQL -346
>ISAM -100

Which version of Online are you running ?

According to the 4.1 Online Enhancements documentation, effective
checking of unique constraints is implemented from 4.1.

This should solve your problem.

Cheers,

Richard Ridley

DHL Asia Pacific
%UEND
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: tbtape problems with OnLine & IBM RT
Date: 6 Jan 1993 21:53:10 -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.1754>

Quoting Michael Faurot...
} 
} At this point in time I find OnLine to be utterly worthless to me.  If I
} can't back-up my data then the product is useless to me.
} 
} Is this a known bug in this release/port of OnLine?  Is there a fix or
} update for it?
} 
} 
} Here follows the text of my original post and problem:
} 
} ==============================================================================
} 
} Have the following hardware, OS, and Informix . . .
} 
} 	IBM RT 
} 	AIX 2.2.1
} 	Informix OnLine v4.00.UD4
} 
From my personal experience I can tell you what the problem is with
one word...  AIX !!!  Although they won't admit it, I'll bet there
are other people out there that agree with me.

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: seeb@cbnewsm.cb.att.com (Dick Seebach)
Subject: Turbo 'too many users' error
Organization: AT&T Bell Labs, Warren NJ
Distribution: usa
Date: Thu, 7 Jan 1993 20:36:18 GMT
Keywords: informix,turbo,keys

Does anyone have information about this problem:

We are running Turbo 2.10.03 on a 3B2. Several users can access
the database simultaneously. After being up for several days,
only one user will be allowed to access the database at a time;
other attempts to open the database will fail with sqlcode -529,
cisam code -129 (too many users).

However, tbstat -u shows only a few users accessing the database,
much fewer than the 100 defined in tbconfig.

The problem is cleared by stopping and restarting turbo.
From: widener!uunet!uunet!microc!eric@emory.mathcs.emory.edu
Newsgroups: comp.databases.informix
Subject: Informix & Tuxedo
Date: 11 Jan 1993 14:48:08 -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.1770>

>From: Apostolos Dedes <uunet!ge!dedes!dedes>
>Subject: Informix & Tuxedo
>Date: Thu, 7 Jan 93 17:36:52 EST
>Organization: GE Information Services

>Help!
>I need to get the 2-phase commit to work using Informix as the Database
>Manager & Tuxedo as the Transaction manager. If someone on the net has
>already done this I would appreciate a phone call or a personal message
>for a couple of questions that I have.
---
Have you considered Regency Support?
Good Luck!
+--------------------+------------------------------------------+
| Eric C. Leschhorn  |   *MICROCOMPUTOS*      Fax:(809)688-6044 |
| Marketing Director | Dominican Republic ==> Tel:(809)530-8506 |
| uunet!microc!eric  | Puerto Rico        ==> Tel:(809)250-8789 |
+--------------------+------------------------------------------+
From: unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah)
Newsgroups: comp.databases.informix
Subject: Re: Informix ON-LINE archiving
Date: 11 Jan 1993 10:08:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1768>

Kamlesh,
Look into tbtape utilty provided by Informix.
Use redirected input to get past the prompts.
With this you should be able to archive without using tbmonitor.

========================================================================
Bharat Shah                                        Voice: (508)-663-7570
Unifi Communications Corp.                           Fax: (508)-663-7543
4 Federal St, Billerica, Mass 01821, USA          uunet!bharat@unifi.com
========================================================================
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: 4GL 5.0 for AIX
Date: 12 Jan 93 21:00:03 GMT
Organization: Helen Keller Bondurant's Performance Driving School for the Blind

In article <93012.104512DMURRAY@PURCCVM.BITNET> DMURRAY@PURCCVM.BITNET (Dagmar Murray) writes:
>Does anyone know about the availability of Informix 4GL version 5.0
>for AIX?

Yeah: none.  No such product exists on any platform.

4GL:The Next Generation, whatever it's called   ("Deep Space 9GL"?  [-: )
and whenever it arrives, will likely have AIX on the RS6000 series as a 
first-tier platform, if that helps.

--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland
 Disclaimer: These opinions are mine alone.  If I am caught or killed,
             the secretary will disavow any knowledge of my actions.

"Fall not in love; it will stick to your face."    -- Deteriorata
From: withers@src4src.linet.org (John Withers)
Newsgroups: comp.databases.informix
Subject: Reference book advice sought
Date: 7 Jan 93 17:31:06 GMT
Organization: The Source for Source

Can anyone give me any pointers on reference materials to
supplement the Informix manuals?

John Withers