HDTenEightyP/NetNews huggingface dataset:
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Newsgroups: comp.databases.informix
Subject: Re: Display array highlist
Date: 27 Dec 92 17:49:00 GMT
Reply-To: shemminga@cix.compulink.co.uk


TITLE: Re: Display array highlist

In <1992Dec21.175031.11266@informix.com> David Cortesi


[Stuff deleted]

> How would you want this window defined?  Just a bare window, or would
> you require a form in it?  (Your mention of DISPLAY ARRAY suggests a
> form.)  So what is the relationship between the number of lines per
> "page" and the dimensions of the screen array?
> 
> One big problem you are overlooking is that some reports are
> asynchronous -- all the rows you OUTPUT just go in a temp table and
> nothing actually comes out until FINISH REPORT is executed.
> 
> Which means that the window you would name in [START] REPORT TO would
> have to still exist at FINISH REPORT time. There is no way that 4GL can
> ensure that.  Not a show-stopper, but it would mean a possibly obscure
> error message on FINISH REPORT (window not available).
> 
> In fact this would be a general problem; the program could always CLOSE
> WINDOW foo in between any two OUTPUT TO REPORT lines, and in fact the
> program could CLOSE the window and then reOPEN the window with
> different dimensions -- or DISPLAY a different FORM -- between two
> outputs!  So basically the report-display logic would have to track
> what could be a very dynamic, moving target for line width and page
> length.
> 
> That isn't a problem for your specific application I'm sure, but it
> illustrates the kind of problems that would have to be dealt with for a
> general implementation.

I think a better way would be to arrange to have the report generated
to a file with the programmer responsible for line and page length.
Then Informix need only provide a file viewer in a window. The logic
for this could (should?) be very simple.

If this idea where implemented along with the dynamic report
definitions (variables for output target, line and page length) then
reports could be set up in apps to print on 60 line paper pages, in full
screen and windowed views.

How does that grab you?

| 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: widener!uunet!uunet!microc!eric@emory.mathcs.emory.edu
Newsgroups: comp.databases.informix
Subject: mail problem
Date: 2 Jan 1993 11:48:03 -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.1749>

>From: uunet!xact.demon.co.uk!ptm (Paul Thomas Mahoney)
>I DO NOT WORK FOR INFORMIX! I'm just a VAR...
>My software runs on 468 "Class C" machines which can support > 25 people.
>Informix are now to have "# of user" prices breaks on Class C machines.
>As a result the price hike for me is not 10%... IT'S OVER 100%!!!!
>I am not very happy about this...

Why?  You're gonna get more money selling a C17+ user license!
Aren't you a VAR?

>Paul Mahoney, X-Act Solutions Limited

I DO NOT WORK FOR INFORMIX! I'm just a Distributor...
+--------------------+--------------------------------------+ ***********    *
| Eric C. Leschhorn  | *MICROCOMPUTOS*    Fax:(809)688-6044 |********    ** ***
| Marketing Director | Dominican Republic Tel:(809)530-8506 |*******    ** ****
| uunet!microc!eric  | Puerto Rico, USA   Tel:(809)250-8789 |******    ** *****
+--------------------+--------------------------------------+*****    ** ******
|  I N F O R M I X   L A T I N   A M E R I C A N   T E A M  |****    ** *******
+-----------------------------------------------------------+ **    **********
From: bob@worms-emh2.army.mil (Bob Kane)
Newsgroups: comp.databases.informix
Subject: Re:  Fixes to Informix-4gl
Date: 21 Dec 1992 11:58:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: bob@worms-emh2.army.mil (Bob Kane)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1729>

}
}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?
}
Dave, Carl

I have written a set of routines that do allow automatic jump to the 'N' 
records.  I would be glad to post, but they are rather lengthy.  I have
used a combination of routines from DB4GLGEN and my own code.  It will also
open the array at a particular point based on a query.  Note, it does not 
use DISPLAY ARRAY at all.  It uses a set of routines based on the fgl_getkey
stuff from DB4GLGEN.  Let me know if anyone is interested and I will mail it
to you, or to some host.

-----------------------------------------------------------------------------
Bob Kane                   Internet: bob@worms-emh2.army.mil (IP 134.235.9.2)
TechDyn Systems               Voice: (049) 6241-487306   (WORMS, GERMANY)
CMR 421, BOX 706                Fax: (049) 6241-49560
APO AE 09056                    CIS: 71054,2661
Newsgroups: comp.databases.informix
From: jslater@telesciences.com (John M Slater)
Subject: Freeing SQLDA Memory
Organization: TeleSciences CO Systems, Inc.
Distribution: USA.
Date: Mon, 28 Dec 1992 03:08:47 GMT

I need to continually reuse the SQLDA structure in a daemon application.

How does one properly release memory associated with the SQLDA structure
after being allocated with the DESCRIBE statement.

It would seem that at least two mallocs may have been done, 1 for the SQLVAR
structure(s) (assuming they point to offsets into the same memory block),
and one for the SQLDA structure.

Would this scenario be appropriate:

$FREE prepare_stmt;
free(sqlda->sqlvar);
free(sqlda);

I'm using ESQL/C 5.0UC1 On an HP9000/857 (HP-UX 8.02).

Thanks In Advance.
-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
                                 John M. Slater	
EMail:		jslater@telesciences.com
Phone:		+1 609 866 1000 x231
Newsgroups: comp.databases.informix
From: aburt@mnemosyne.cs.du.edu (Andrew Burt)
Subject: Re: mail problem
Organization: University of Denver, Dept. of Math & Comp. Sci.
Date: Sat, 2 Jan 93 17:43:46 GMT

In <1i4h03INN9ga@emory.mathcs.emory.edu> widener!uunet!uunet!microc!eric@emory.mathcs.emory.edu writes:

>>From: uunet!xact.demon.co.uk!ptm (Paul Thomas Mahoney)
>>I DO NOT WORK FOR INFORMIX! I'm just a VAR...
>>My software runs on 468 "Class C" machines which can support > 25 people.
>>Informix are now to have "# of user" prices breaks on Class C machines.
>>As a result the price hike for me is not 10%... IT'S OVER 100%!!!!
>>I am not very happy about this...

>Why?  You're gonna get more money selling a C17+ user license!
>Aren't you a VAR?
>I DO NOT WORK FOR INFORMIX! I'm just a Distributor...

I suspect his complaint is that he has to raise his price.  I.e., he
is *forced* to raise his price.  You as distributor may not care, but
you ought to know the difference between you and a V*ADDED*R -- one
of my clients is a VAR, and while they do make money off selling informix
if the sell a copy of their prodouct, it is just that much harder to
sell their product because they are *forced* to raise the overall price.

But, if y'all have been reading my prior posts, you know where I stand
on Informix's pricing:  It's way the hell out there for what you get
compared to most software.
-- 

Andrew Burt 		   					  aburt@du.edu

"But if he was dying he wouldn't bother to carve "Aaaaargh", he'd just say it."
Newsgroups: comp.databases.informix
From: bobb@netcom.com (Bob Beaulieu)
Subject: WANTED: INFORMIX for MS-DOS
Keywords: ISQL, ESQL/C
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Wed, 23 Dec 1992 22:32:28 GMT


Anyone want to sell me their current DOS version of INFORMIX?

Please reply to:

bobb@netcom.com

Thanks,

Bob Beaulieu
-- 
 =============================================================
 Bob Beaulieu                                 bobb@netcom.com  
 San Jose, CA                                 (408) 978-0818  
 =============================================================
Newsgroups: comp.databases.informix
From: kenm@PROBLEM_WITH_INEWS_GATEWAY_FILE (Ken Miles)
Subject: Re: parameters as host variables
Date: Wed, 30 Dec 1992 23:21:57 GMT
Organization: Hewlett-Packard VCD
X-Newsreader: Tin 1.1 PL5

Mark_Sherman@transarc.com wrote:
> I think I must be missing something obvious, but I can not seem to let
> procedure parameters be used as host variables in esql programs, e.g.,
> 
>     void foo(a,b)
>         EXEC SQL BEGIN DECLARE SECTION;
>         long int a;
>         long int b;
>         EXEC SQL END DECLARE SECTION;
>     {
>         EXEC SQL
>             UPDATE mytable
>             SET mycolumn = :a
>             WHERE myindex = :b;
>     }
>
  [ . . . ]
 
> Am I missing something obvious? Thanks.
> 	-Mark (mss@transarc.com)

Try the "parameter" keyword Mark:

    void foo(a,b)
         EXEC SQL BEGIN DECLARE SECTION;
         parameter long int a;
	 .
	 etc.

The 5.0 ESQL/C Programmer's Manual (P 1-16) has more information.

-Ken Miles
Hewlett-Packard
Vancouver Division
kenm@vcd.hp.com
From: ptm@xact.demon.co.uk (Paul Thomas Mahoney)
Newsgroups: comp.databases.informix
Subject: Re: mail problem
Date: 3 Jan 93 11:05:31 GMT
Organization: X-Act Solutions Limited
X-Newsreader: Tin 1.1 PL3

My original post was driven by shock.

There I had been, at an Informix User conference, listening to Malcolm
Padina (UK Managing Director) telling us that they had increased sales,
a VERY healthy bank balance, and even better products in the pipeline...

However a price increase was announced, it would be in the region of 10%
to 15%. This was only annoying since it was an increase higher than inflation
and we are in recession...

Then my distributor sends me the new price list. No matter how hard I try I
cannot make 113% look like 15%! Now this, I agree is not across the board.
The low end machines that are having far higher price increases with respect
to high end machines. When I last asked the percentage of users running on
486 PC's the answer given was about 20%...

It seems certain that I'm not the ony VAR in a state of shock.
-- 
Paul Mahoney, X-Act Solutions Limited
smail: 20 Shipley Lane, Cooden, Bexhill-on-Sea, East Sussex, TN39 3SR
email: ptm@xact.demon.co.uk ... pmahoney@cix.compulink.co.uk
phone: +44 424 3 6368
From: dom@oasis.icl.co.uk (dominic alston)
Newsgroups: comp.databases.informix
Subject: Re: Improvements to I4GL
Date: 22 Dec 92 14:15:14 GMT
X-Newsreader: Tin 1.1 PL3

obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler) writes:
>
>Dear Paul,
>
>The following items are on my wishlist for I4GL, over and above the INPUT
>ARRAY stuff which has already been supplied by other people.
> . . ..
 
	How about making it object oriented.

--
Dominic Alston                                 "Where am I ?.. In the village."
International Computers Ltd.               
Lovelace Road.                              dom@oasis.icl.co.uk ||
Bracknell RG12 4SN                          ..!uunet!mcvax!ukc!iclbra!dom ||
Berks, England.                             da16@unix.brighton.ac.uk

Tel: +44 344 424842 x2324
Fax: +44 344 487832

Disclaimer: class MyDisclaimer : public StdDisclaimer {
				public: MyDisclaimer():StdDisclaimer() { }
			}
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Nice kill of tbtape -c ?
Date: 30 Dec 92 16:34:16 GMT
Organization: Informix Software, Inc.

Poul Pedersen writes:
>
>        How is it possible to stop 'tbtape -c' if it is running
>        in the background. (Terminal turned off and SIGHUP trapped.)
>
>        The tbtape command must be stopped in a nice way.
>        Is it possible to use 'kill -xx' ?

Since tbtape is coded to catch an interrupt and terminate cleanly,
sending a kill -INT (-2) should do the job quite nicely.

Note that any log currently in the process of being backed up will
complete before tbtape actually terminates.

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: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: Display array highlist
Date: 21 Dec 92 17:50:31 GMT
Organization: Informix Software, Inc.

In article <1992Dec15.145006.8036@mnemosyne.cs.du.edu> aburt@mnemosyne.cs.du.edu (Andrew Burt) writes:
> [his homespun solution is a lot more work than...] something like
>
>	OPEN WINDOW foo AT 5,5 WITH 10 ROWS, 60 COLUMNS
>	...
>	REPORT TO WINDOW foo
>
>"report to window" should automatically allow scrolling, like display array.

How would you want this window defined?  Just a bare window, or would
you require a form in it?  (Your mention of DISPLAY ARRAY suggests a
form.)  So what is the relationship between the number of lines per
"page" and the dimensions of the screen array?

One big problem you are overlooking is that some reports are
asynchronous -- all the rows you OUTPUT just go in a temp table and
nothing actually comes out until FINISH REPORT is executed.

Which means that the window you would name in [START] REPORT TO would
have to still exist at FINISH REPORT time. There is no way that 4GL can
ensure that.  Not a show-stopper, but it would mean a possibly obscure
error message on FINISH REPORT (window not available).

In fact this would be a general problem; the program could always CLOSE
WINDOW foo in between any two OUTPUT TO REPORT lines, and in fact the
program could CLOSE the window and then reOPEN the window with
different dimensions -- or DISPLAY a different FORM -- between two
outputs!  So basically the report-display logic would have to track
what could be a very dynamic, moving target for line width and page
length.

That isn't a problem for your specific application I'm sure, but it
illustrates the kind of problems that would have to be dealt with for a
general implementation.

Dave Cortesi
	cortesi@informix.com
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Fixes to Informix-4gl
Date: 23 Dec 1992 11:48: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.1731>

Quoting Stuart Hemming...
} 
} In-Reply-To: <1gor7vINN4u9@emory.mathcs.emory.edu> dave.snyder@snide.com (Dave Snyder)
} 
} 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?
} 
Probably not.  The page ahead function works because the data is sorted
somehow.  If you were to use another column that was sorted for the page
ahead to index, you would then have to say, "What was the code for Russian?"
Needless to say, the end-user doesn't need anymore codes to memorize; the
patient speeks Russian, I want to select Russian!

I'm not knocking this routine, it's a wonderful idea and it can be used
90% of the time.  I just wanted to point out that there is that 10% :-)

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: brownlow@informix.com (Keith Brownlow)
Newsgroups: comp.databases.informix
Subject: Re: ESQL C problem with sqlerrd[2]
Date: 17 Dec 92 17:58:02 GMT
Organization: Informix Software, Inc.

ray@unlv.edu (Ray Tripamer) writes:

>The sqlca.sqlerrd[2] value DOES NOT hold the number of rows found by opening
>a cursor for a select statement (dynamic or otherwise).  The sqlerrd[2] value
>is filled in only by the update and delete statements (maybe insert too), but
>not by a select.

>The only way to get the number of rows from a select statment is to
>execute some type of "select count(*) into $cnt ..." statement with the same
>from and where clause as the original select statement.
>--


A little clarification at this point;

 sqlca.sqlerrd[2] holds the values of the last SERIAL value inserted.

sqlca.sqlerrd[3] will hold the TRUE number of updates and deletes but only
the first of an insert or select.  This is because both insert and select 
statements need cursors if they are to manipulate more than one row at a time, 
while update or deletes will affect every row in the table unless some 
criteria is specified.

Hope this clears up any misunderstanding.
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: C-ISAM to Informix rdb con
Reply-To: shemminga@cix.compulink.co.uk
Date: Wed, 30 Dec 1992 07:58:00 +0000


TITLE: C-ISAM to Informix rdb conversion utilities

In <1hqc37INNaj@emory.mathcs.emory.edu> Mark R. Friedman asks:

> What utilities/tools exist to ease moving data from (Informix) C-ISAM files
> over to a series of Informix databases? We've recently acquired a suite of 
> 'replacement' applications and would like to move the existing data over to 
> the new apps, but our software vendor claims the only way to do so is by 
> writing a suite of C programs (for which he'll charge us a mere arm and leg).
> Is there a better way? We have access to what I believe to be the full range
> of Informix products, and I _want_ to assume that there's a cleaner and
> easier approach. Many thanks for any ideas or pointers...

If they are REALLY C-ISAM files then, unless I've missed my guess,
all you need to know is the type of each data field in each data
file. You also need to know the keys for each index.

Now, in informix, create data tables of exactly the same type.
Now once you've created the tables you login as user informix (or any
other user with DBA privilage). Now create a default form for the
table SYSTABLES. Now for each table you've created in SQL, change the
dirpath field to point to your original data tables.

So, you now have you're old data in you shiny new database.

At this point I would suggest that you UNLOAD the bits of the data
you need and LOAD it into you new apps.

I hope this helps.



| 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: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: Display array highlist
Reply-To: shemminga@cix.compulink.co.uk
Date: Tue, 29 Dec 1992 21:40:00 +0000


TITLE: Re: Display array highlist

In <cortesi.725577273@helium> David Cortesi writes:

[Stuff deleted]

> The latter (ability to use variables in the OUTPUT section) is
> generally accepted as a Good Idea, I think.  As to the file viewer
> window, why do you want Informix to reinvent the browser
> that exists on every platform already (and probably do it wrong :)
> when you could just, for example, RUN "less /tmp/report.01"

OK, fine for full screen paging. The original contributer was looking
for scrolled reportd in a window. I would imagine something like:

        OPEN WINDOW win1, AT 3, 3 WITH 10 ROWS, 40 COLUMNS
        PAGE <textfile>

I don't believe that the compiler should be responsible for checking
line lengths, simply foreshortening long lines should be ok, that
would make the implementation easier anyway.


> Or under a GUI,
>         RUN "/usr/openwin/bin/textedit /tmp/report.01" WITHOUT WAITING
> You could even pass -Geometry arguments...  that should impress the troops...

Maybe, I wouldn't know.

| 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: oles@uniware.dk (Ole Skanning)
Newsgroups: comp.databases.informix
Subject: Re: Improvements to I4GL
Date: 23 Dec 92 12:53:45 GMT
Organization: UNIWARE danmark a/s

obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler) writes:

>* Screen dumps.


There is an undocumented feature in INFORMIX-4GL and INFORMIX-SQL
(it is documented in the INFORMIX-Quickstep manual though) that
makes screendumps:

Set the environment variable DBSCREENDUMP to a filename.

When pressing ctlr-p inside of a 4GL program or inside ISQL, 
the current screen will be dumped to the file.

Graphics characters and effects are not handled well, though.

regards and merry christmas
-- 
Ole Skanning
Organization: UNIWARE danmark a/s,  Bygstubben 12, DK-2950 Vedbaek, Danmark
Phone: Office: +45 42 89 49 99, Fax: +45 42 89 28 18, Home: +45 31 65 58 31
Reply-To: oles@uniware.dk