HDTenEightyP/NetNews huggingface dataset:
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: Start values for serial co
Date: 5 Jan 93 19:55:59 GMT
Organization: The Island of Unwanted Toys

In article <memo.835850@cix.compulink.co.uk> shemminga@cix.compulink.co.uk writes:
>In <725749037snz@prickle.demon.co.uk.demon.co.uk> Malcolm Apps says:
>> Thanks for the advice guys - I'll give up trying and encourage people
>> to document the system properly.
>
>Now, THAT would be novel 8-)

Do you have a specific complaint about the documentation here?  Or are you 
just shooting your mouth off?  

Sorry, but this bugs me, coming from the same person who misread the 
installation instructions and complained about the install procedure...

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

  "Don't try to out-weird me, pal; I get stranger things than you
   free with my breakfast cereal."               -- Z. Beeblebrox
From: rridley@sin-pss.DHL.COM (Richard Ridley)
Newsgroups: comp.databases.informix
Subject: RE : Splitting Disk Sections
Date: 10 Jan 1993 21:58: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.1766>


%UNIPLEX
%TO            informix-list@rmy.emory.edu
%FROM          rridley
%SYSTEM        DHLNET
%SUBJECT       RE : Splitting Disk Sections
%VERIFY        y
%DATE          11/01/93 10:25
%REFERENCE     10834


RE : Spliiting up large disk sections :

We have had the same frustrations on our 827's using the C2474S
disks. We were informed that HP would not support it if we tried,
although I believe they did do it for AT&T.

HP UX 9.0's Logical Volume Manager allows you much more flexibility
as far as chopping up disks go - we decided to wait for that
rather than hassle away in our own.

Cheers,

Richard Ridley
%UEND
Newsgroups: comp.databases.informix
From: jean@aim1.aztec.co.za (Jean Ramsay)
Subject: CONSTRUCT/END CONSTRUCT within INPUT statement
Date: Thu, 7 Jan 1993 10:26:51 GMT
Organization: Aztec Information Management
Keywords: CONSTRUCT

According to the TOOLREL_4.1 document for i4GL an END CONSTRUCT statement
is now required when using CONSTRUCT within an INPUT statement when using 
version 4.1 of i4gl. (See lines 377,392)

A program containing this code, which works using release i4gl 4.0,
fails to execute the INPUT BY NAME ...  WITHOUT DEFAULTS correctly (it 
appears to ignore the WITHOUT DEFAULTS, blanking out all fields) when run 
without the END CONSTRUCT statement on i4gl 4.1. However it gives a generic
syntax error at compile time when the END CONSTRUCT is added.  

Has anybody had this problem with i4gl 4.1? I am aware of the supposed
restriction disallowing a CONSTRUCT within an INPUT statement, but the
program did not require the CONSTRUCT to be within another function
under version 4.0. Any help would be appreciated. 
-- 
Jean Ramsay             jean%aim1.aztec.co.za@ucthpx.uct.ac.za
Aztec Information Management, Cape Town, South Africa
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: Start values for serial co
Reply-To: shemminga@cix.compulink.co.uk
Date: Thu, 7 Jan 1993 07:35:00 +0000


TITLE: Re: Start values for serial co

In <1993Jan5.195559.21802@informix.com> Colonel Panic rants:

>>> Thanks for the advice guys - I'll give up trying and encourage people
>>> to document the system properly.
>>
>>Now, THAT would be novel 8-)
> 
> Do you have a specific complaint about the documentation here?  Or are you 
> just shooting your mouth off?  
> 
> Sorry, but this bugs me, coming from the same person who misread the 
> installation instructions and complained about the install procedure...

I think one of us has the wrong end of the stick. *I* believe Malcolm
was refering to the people who created the database. Remember he was
trying to re-created an exsisting database including having the right
starting values of the serial columns. And if those values were
properly documented...



| 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: Dagmar Murray <DMURRAY@PURCCVM.BITNET>
Subject: 4GL 5.0 for AIX
Organization: Purdue University
Date: Tue, 12 Jan 1993 15:45:12 GMT

Does anyone know about the availability of Informix 4GL version 5.0
for AIX?
From: corinne@dssmktg.uucp (Corinne Gregory)
Subject: Re: Report Generators
Organization: Data Systems Support
Date: Fri, 08 Jan 93 15:34:33 GMT

>
>I've seen impressive demos of IQ.  It looks like a good product.

We actually use IQ here both for internal use, and we resell it to 
accompany our Sales/Marketing Management product (SIRS).  We've found
it easy to use, and our users seem to be pleased with it, also.  The
newest version has a nifty cross-tab feature that several of our users
had asked about previously.


>Other products I have heard about, but not seen in action, include:
>
>
>Natural Language Inc.
>2910 Seventh Street
>Berkeley, CA 94710
>(510) 841-3500   (800) NLI-5858

We evaluated this product, but by-and-large, the cost seemed to be
substantially higher for about the same features as IQ.  Although, the
user interface is even nicer than IQ's.

- Corinne


----------------------------------------------------------------------------
Corinne Gregory                                         Data Systems Support 
Manager, Software Development                               Orange, CA
         & Customer Support                               Ph: 714.771.0454 
internet:  corinne@dssmktg.uucp                          Fax: 714.771.3028
bangpath:  uunet.uu.net!dssmktg!corinne

The lab called...your brain is ready.
----------------------------------------------------------------------------
Newsgroups: comp.databases.informix
From: holder@gourde.med.ge.com (Kacy Holder)
Subject: SQL Error 403
Organization: Computer People Unlimited, Milwaukee, WI
Distribution: na
Date: 8 Jan 93 09:10:20


We are using Informix OnLine and Star 5.0 on HP 730's with HPUX 9.0
and are running into an odd problem with remote database access.
Some of the ESQL select statements will return Error Number -403
which says:

-403  The size of the received row disagrees with the expected size.

This is an internal error that shows a problem in the communication 
between the database server and the library functions that call it.
Make sure that your probram is at the same software level as the
database server in use.

The software level *is* exactly the same and most selects work
just fine.  Any idea on where I should start to look?

Kacy

---
--
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."
Newsgroups: comp.databases.informix
From: BP1@vm.urz.uni-heidelberg.de
Subject: where can i get the c-isam routines?
Organization: University of Heidelberg, Germany
Date: Thu, 07 Jan 93 16:47:14 CET

hello
Where can i get the c-isam routines public domain?
thanks so lot
     ernst
From: alan@effluvia.den.mmc.com (Alan Popiel - 303/977-9998)
Newsgroups: comp.databases.informix
Subject: Turbo 'too many users' error
Date: 8 Jan 1993 16:13:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: alan@effluvia.den.mmc.com (Alan Popiel - 303/977-9998)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1763>

Dick Seebach (seeb@cbnewsm.cb.att.com) writes:

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.
____________________________________________

Eric Pederson (eric@nit.pactel.com) writes:

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 did not appear to be answering Dick's inquiry, but the two problems 
certainly seem to be related to me.  Does anyone else have information on 
this type of problem.

Regards,
Alan
+------------------------------+---------------------------------------+
| R. Alan Popiel               | Internet: alan@den.mmc.com            |
| Martin Marietta, LSC         | ( Please note: My opinions do not   ) |
| P.O. Box 179, M/S 5422       | ( represent official Martin policy. ) |
| Denver, Colorado 80201-0179  | Voice: 303-977-9998                   |
+------------------------------+---------------------------------------+

Newsgroups: comp.databases.informix
From: pgf@hara.fct.unl.pt (Pedro Geraldes Freire)
Subject: "Invalid message received from database engine"...
Keywords: proble, error, invalid message
Reply-To: pgf@hara.fct.unl.pt (Pedro Geraldes Freire)
Organization: Universidade Nova de Lisboa, PORTUGAL
Date: Wed, 6 Jan 1993 10:03:34 GMT

I'm getting this error (SQL -408, ISAM 0) on a program while printing a
large report (some 50 pages). Sometimes it happens after printing 20
pages, 30 pages, 40 pages of the same report and the error message has
pointed, in different occasions, to several lines on different source
files. The only thing there is in common to the various places where the
error has occurred is that it is always a SELECT COUNT(*) statement on
some table (different tables, no joins) with a WHERE clause that
consists of 2 to 6 equality comparisons ANDed together.

By the way, this program has been developed in MS-DOS and is actually
running under MS-DOS...

Can anybody help me on this one?

Pedro.

Pedro Geraldes Freire             | BITNET/Internet: pgf@fct.unl.pt
Projecto CIMTOFI		  |            UUCP: pgf@unl.uucp
UNINOVA - GRI - FCT/UNL           | Fax:   (+351) (1) 295 56 41/44 61
2825 Monte Caparica, PORTUGAL     | Phone: (+351) (1) 295 44 64 ext.1560
From: alan@effluvia.den.mmc.com (Alan Popiel - 303/977-9998)
Newsgroups: comp.databases.informix
Subject: Re:  hidden password entry
Date: 12 Jan 1993 18:53:07 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: alan@effluvia.den.mmc.com (Alan Popiel - 303/977-9998)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1776>

willem@sparc-1.law.columbia.edu (Willem Scholten) writes:
->
->Two questions:
->
->One is any one keeping the archive of this news group and so where is it located ?
->
->Secondly: I remember someone posted a routine a while ago which lets you do
->hidden password entry.  Con somone repost it or sent me the sample ??
->
->Thanks.
->-Willem.

I have no info on the first question.  (Other than I am keeping those items 
that interest me.)

For the second:  I did not see the original posting, but I accomplished 
hidden entry on a DOS system by simply specifying COLOR=BLUE for the password 
field within my login form, so that the color used matched the background 
color specified by DBCOLOR, in my case BLUE.  I have not tried this technique 
under UNIX, but do not see why it shouldn't work.

If someone wants a copy of this rather straight-forward code, mail me direct 
and I will send the code in reply.

Regards,
Alan
+------------------------------+---------------------------------------+
| R. Alan Popiel               | Internet: alan@den.mmc.com            |
| Martin Marietta, LSC         | ( Please note: My opinions do not   ) |
| P.O. Box 179, M/S 5422       | ( represent official Martin policy. ) |
| Denver, Colorado 80201-0179  | Voice: 303-977-9998                   |
+------------------------------+---------------------------------------+
Newsgroups: comp.databases.informix
From: nbriscoe@cix.compulink.co.uk (Neil Briscoe)
Subject: Colour Termcap under Interactive
Reply-To: nbriscoe@cix.compulink.co.uk
Date: Tue, 12 Jan 1993 14:58:00 +0000

The docs for terminfo(4) seem to show that there are colour code
equivalents in termcap to those provided in terminfo.  I ran infocmp
-C -r to generate a termcap file from the terminfo compiled file and
it generated a very long termcap file (indeed, it said it was too
long).

Without a lot of mucking about, has anyone got a working colour
termcap for the AT386 terminal?  I need it for Informix work.
Regards
Neil
From: ecg00@hplvec.LVLD.HP.COM (Ed Gulczynski)
Date: Wed, 6 Jan 1993 21:43:48 GMT
Subject: 4GL date routine, HOW?
Organization: Hewlett-Packard Co., Loveland, CO
Newsgroups: comp.databases.informix

In 4gl I'm trying to calc. the number of days between 2 dates 
Here's what I've done.  This doesn't work at all????
I'd appreciate it if you could send me some working code that would 
yield p_diff as a valid integer value.


.
.
GLOBALS
    p_diff      INTEGER
END GLOBALS
.
.

LET p_diff  = TODAY - 60 UNITS DAY
    DISPLAY "diff=",
            p_diff
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: where can i get the c-isam routines?
Date: 9 Jan 93 04:01:43 GMT
Organization: The Island of Unwanted Toys

In article <16B4FEC12.BP1@vm.urz.uni-heidelberg.de> BP1@vm.urz.uni-heidelberg.de writes:
>hello
>Where can i get the c-isam routines public domain?
>thanks so lot      ernst

You can't -- C-ISAM is a commercial product, not public domain.

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

  Smith and Wesson: the Ultimate Point-and-Click User Interface.
From: unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah)
Newsgroups: comp.databases.informix
Subject: Re: UPDATE problem on UNIQUEly INDEXed table on DOS
Date: 6 Jan 1993 18:23:06 -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.1753>

Use the following:

begin work

update fartigos                       /* Shift things beyond N */
set c_int_art = c_int_art + N + 1
where c_int_g = ....
  .. and c_int_art >= K

insert into fartigos values (....., K)    /* Place your stuff */

update fartigos                   /* Bring back records into domain */
set c_int_art = c_int_art - N
where c_int_g = ...
and c_int_art >= K+N

commit work

========================================================================
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: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: Updating within a scrolling cursor
Date: 11 Jan 93 20:02:53 GMT
Organization: Informix Software, Inc.

>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

>Quoting Dave Snyder...
>
>Won't happen.  First of all, I don't think you can access a cursor's tmp
>table...

well, he COULD if he knew its name, but you're right because the
name formation rule isn't documented. So even if you figure out
what the name is for any case, you can't rely on it.

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

Very true. But the basic question -- can I open a cursor and then
use INSERT to stick more rows in the selection set? -- is interesting.
Answer: you probably could if you knew the table name, but you don't,
and won't.

For Reg Foulkes: why do you want to do this?  Perhaps if you explain
what you are trying to accomplish, somebody would have another
suggestion.
From: gaukur@rhi.hi.is (Kristjan Gaukur Kristjansson)
Newsgroups: comp.databases.informix
Subject: Archive; levels on different tape devices...
Summary: Is restore impossible if level2 is made on an diff. tape dev. than lev0
Date: 12 Jan 93 17:57:22 GMT

The tape device I use for archiving I-OL broke down and I'm not sure when it
will be fixed, (a DAT dev. on a HP), so if I want to take daily backups
I have to back up on a different machine and tape dev.  But reading the manual
suggests to me that you can not restore OL from different devices, is that
correct?  Should I rather take the engine off-line and unix-backup the
cooked files?
				Gaukur.
Newsgroups: comp.databases.informix
From: lsystemsb@cix.compulink.co.uk (Langdon Systems)
Subject: Problems Linking With DOS 4GL
Reply-To: lsystemsb@cix.compulink.co.uk
Date: Tue, 12 Jan 1993 08:32:00 +0000



  I wonder if anyone can help with the following problem. 
  We are currently in the middle of porting our applications 
  to Informix 4GL 1.10.06c for DOS. Surprisingly until 
  yesterday things have been going ok, then a problem occured 
  with the Microsoft C linker we are using. Our application 
  contains a large number of screens which, since they are 
  all inter-linked are all part of the same EXE. Unfortunately 
  the linker has run out of relocation entries (>32k) and falls 
  over with a fatal error, its just not up to the job. There is 
  an option /EXEPACK which will increase the number of entries 
  to 512k, but this does not work with the Dos Extender that 
  Informix use.

 Can anyone suggest an alternative linker which would resolve 
 this problem. We need a workaround very quickly as our project 
 deadlines are rapidy approaching! Any help appreciated.

Thanks In Advance

David Heydon.

Newsgroups: comp.databases.informix
From: clw@hprnd.rose.hp.com (Carl Wuebker)
Subject: Recovery
Summary: How long does db recovery take?
Date: Fri, 8 Jan 1993 21:42:24 GMT
Organization: HP Roseville Networks
X-Newsreader: TIN [version 1.1.8 PL6]
Keywords: corruption,recovery

     I'm running Informix-Online 5.00.UC3 with Informix 4-4GL 4.10.UE2 on 
a HP 9000 s750 computer.  A process with some 4000 locks had hung trying to
update the database.  I killed the process (which was a very bad move).  
Going into tbmonitor, I tried to set the DB online again.  Results: Since
about 8 this morning (6 hours) the tbmonitor has said:

      Recovering, please wait ...

       please wait ........

with the dots on the second line growing until about the 50th column, then
disappearing and starting over.

     We didn't have *that* much data in the database, but the database's disk
is fairly large (1.3GB).  I can't seem to find anything to tell me how to 
put this recovery to sleep (we've got a power shutdown tomorrow), whether
recovery time is proportional to raw disk space or amount of data, or how
long a recovery is supposed to take.  Any info would be appreciated...

Thanks,
    Carl Wuebker * HP Roseville * clw@hprnd.rose.hp.com * (916) 785-4296
From: ramesh@informix.com (Nagar Ramesh)
Newsgroups: comp.databases.informix
Subject: Re: Informix ON-LINE archiving
Keywords: Automatic or manual only
Date: 11 Jan 93 05:35:51 GMT
Organization: Informix Software, Inc.

In article <Jan.10.22.30.35.1993.27002@remus.rutgers.edu> lad@remus.rutgers.edu (Kamlesh) writes:
>
>	On Informix ON-LINE, is it posssible to automatically archive 
>databases.  Currently, you have to manually run tb-monitor and create
>an archive.  Is there any way to write a macro or a cron to
>automatically backup the database at a certain time?
>
>
>Can anyone suggest any utilities to provide automatic archiving?
>
>Thanks,
>
>
>Kamlesh
>lad@remus.rutgers.edu

hi kamlesh,

i'll leave the cron stuff up to you but the command line argument
to create an archive is tbtape -s which you can incorporate in 
a cron job.  however, you will be prompted for the level of
the archive and additional tapes to be mounted, if necessary.

hope this helps,

regards,

ramesh.
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: 4GL date routine, HOW?
Date: 7 Jan 1993 15:18:04 -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.1760>

Quoting Ed Gulczynski...
} 
} In 4gl I'm trying to calc. the number of days between 2 dates 
} Here's what I've done.  This doesn't work at all????
} I'd appreciate it if you could send me some working code that would 
} yield p_diff as a valid integer value.
} 
}  .
}  .
} GLOBALS
}     p_diff      INTEGER
} END GLOBALS
}  .
}  .
} 
} LET p_diff  = TODAY - 60 UNITS DAY
}     DISPLAY "diff=",
}             p_diff         
} 
You are making things harder than they need to be... to calculate say,
the number of days since an invoice was cut, do this:

GLOBALS
    DEFINE  p_diff INTEGER
    DEFINE  invoice_date DATE
END GLOBALS

LET p_diff = TODAY - invoice_date

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: eric@nit.pactel.com (Eric Pederson)
Newsgroups: comp.databases.informix
Subject: sqlturbo processes don't die
Date: 8 Jan 93 17:33:12 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
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: An insider's view
Reply-To: shemminga@cix.compulink.co.uk
Date: Thu, 7 Jan 1993 07:35:00 +0000


TITLE: Re: An insider's view

In <1993Jan5.195133.21463@informix.com> Colonel Panic writes:

> Just a few unofficial thoughts from another insider:
> 
> 1) just because somebody has an informix.com email address doesn't necessarily
>    mean a person is an *employee*.  The author could well be a consultant or a
>    contractor.

The Insider IS.

> 2) I know a fair percentage of the development staff, and I honestly can't
>    this of *anyone* in Product Development who shares this attitude.  And
>    a fair percentage of people in Support and Consulting would actually be
>    as critical (or *more* critical) of response-time-to-feature-requests 
>    than many of the posters in this group.

Tha may well be the case, but I'm afraid I can't say where The
Insider works.

> 3) If we even *attempted* to continue to "sell 4GL as it is" for an extended
>    period of time...  we'd soon get to a point where we wouldn't be selling
>    much AT ALL...

Ain't THAT the truth

> 4) I would dispute the assessment that 4.1 4GL's screen handling is "state of
>    the art".  I expect that most people in this group would, too.

And most people have!


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