HDTenEightyP/NetNews huggingface dataset:
From: kurt@sdd.hp.com (Kurt Andersen)
Newsgroups: comp.databases.informix
Subject: ESQL/C & $set explain on problem
Followup-To: comp.databases.informix
Date: 10 Sep 1992 08:29:02 -0700
Organization: Hewlett Packard, San Diego Division
Distribution: comp.databases.informix
NNTP-Posting-Host: hpsdde.sdd.hp.com
Summary: no output file from set explain
Keywords: ESQL C select explain

While I wait for Informix tech support to call me back, I thought that I
would see if anyone on the net could help with this problem.

In an ESQL/C program (ESQL version 4.10.UD2) running on an HP 9000/380,
I am trying to do a '$set explain on' to watch the execution of the select
statements following throughout the program.  No errors come back, but I 
don't get a 'sqexplain.out' file anywhere that I can find either.

Any suggestions?  BTW, the program is talking to a standard engine (version
5.00.UC2) on another machine through I-NET.

Thanks,
  Kurt
-- 
                          kurt@hpsdid.sdd.hp.com
                  619/592-4373 (voice); 619/592-8191 (FAX)
             16399 W. Bernardo Dr. MS 61U65/San Diego, CA 92127
-----Standard disclaimer stuff applies for all of the standard reasons-----
From: atl0@isg.com (Anna T. Luong)
Newsgroups: comp.databases.informix
Subject: Out of Temporary String
Date: 11 Sep 92 16:23:13 GMT
Reply-To: atl0@isg.com (Anna T. Luong)
X-Informix-List-ID: <list.1438>


Hi netters \-),
 
 	We have a program that runs on a client's machine many times a day.
 It's an input screen that logs incomming customer replies.
 And usually after the user enters 50 records, the program bombs out 
 with the -4518 error which is the "the 4GL program cannot allocate 
 any more space for temporary string storage. 
 
 	My question is how can we identify what things are being stacked on
 the temporary string.  What are the things I need to watch for besides:
 1.  returning char values from a function.
 2.  the using, spaces, and ascii functions.
 3.  some forms of the case statement
 4.  the upshift and downshift functions.

 	Or can I somehow clear the temporary string before the program is
 run every time.

  	I know this question might have been posted to the Net a while ago,
 but I appreciate any help you can offer so I can get this problem solved
 once and for all (and get some sleep).
 
 	Thanks in advance.
 
                                    Anna



Newsgroups: comp.databases.informix
From: lpc@dickens.com (Luis P Caamano)
Subject: Re: Informix position available
Date: Mon, 14 Sep 1992 17:34:34 GMT
Distribution: usa
Organization: Dickens Data Systems, Inc.
Keywords: Informix

In article <nparkar.716236578@seamis1> nparkar@seamis1.gsfc.nasa.gov (Nuruddin Parkar) writes:
>Informix position is available.  The qualified candidate must have 
>
>          Bachelor's or Master's degree in Computer or any physical science,
>	  5 years of experience with Informix and Wingz, and
>	  Knowledge of SCO unix.
>  

Uoha!! Wingz is not 5 years old yet, how can anybody have 5 years
of experience in Wingz ... :-)

-- 
---------------------------------------------------------------------------
Luis P. Caamano                    |         lpc@dickens.com
Dickens Data Systems, Inc.         |         uunet!dickens.com!lpc
Atlanta, GA                        |         (404) 475-8860
---------------------------------------------------------------------------
If I think I know it all, I'll stop learning. -myself
The more I learn, the more I know I know nothing. -somebody else
From: johnl@obelix.informix.com (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  ESQL/C & $set explain on problem
Date: 14 Sep 92 14:13:08 GMT
Reply-To: johnl@obelix.informix.com (Jonathan Leffler)
X-Informix-List-ID: <list.1446>

}From: uunet!sdd.hp.com!kurt (Kurt Andersen)
}Subject: ESQL/C & $set explain on problem
}Date: 10 Sep 92 01:29:02 GMT
}X-Informix-List-Id: <news.1790>
}
}In an ESQL/C program (ESQL version 4.10.UD2) running on an HP 9000/380,
}I am trying to do a '$set explain on' to watch the execution of the select
}statements following throughout the program.  No errors come back, but I
}don't get a 'sqexplain.out' file anywhere that I can find either.
}Any suggestions?  BTW, the program is talking to a standard engine (version
}5.00.UC2) on another machine through I-NET.

I would suggest that the engine which writes the explain file is on the other
machine.  Exactly where the file is written on the other machine is anyone's
guess -- I'd try root (/) first, then $INFORMIXDIR, and then
find / -name sqexplain.out -print
There is an outside chance that no file is written at all in this environment.

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: List Server
Reply-To: shemminga@cix.compulink.co.uk
Date: Mon, 7 Sep 1992 09:18:16 +0000


Thanks for the info. (Sorry for the delay in replying, I've been on
my hols)
--------------------------------------------------------------
| Who cares whos opinions these are?!                        |
| Send me mail and I'll love you forever (Maybe)             |
|------------------------------------------------------------|     
| Stuart Hemming             | shemminga@cix.compulink.co.uk |
| Tudor Labels Ltd           |                               |
| Roman Bank Bourne          | Tel :  (+44) 778 426444       |
| Lincs PE10 9LQ. UK.        | Fax :  (+44) 778 421862       |
--------------------------------------------------------------


Stuart
|8-)
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: Where's my Reverse field
Date: 9 Sep 92 20:43:46 GMT
Reply-To: cortesi@informix.com
Organization: Informix Software, Inc.

In article <1992Sep8.213142.2049@candle.uucp> root@candle.uucp (Bruce Momjian)  
writes:
> I have a field on a form I have specified as REVERSE, but it just comes
> up blank.  I know Informix knows about the reverse video on my terminal
> because my menus come up reverse.  In fact, I have some Informix
> executable from another person and its fields are reverse.  Does anyone
> know why this is happening?  Below is my form description file.
> database formonly
> screen
> {
> 			Summary of Client/Matter Activity
> 			
> 		As-of Period [a]
> 				
> }
> end
> attributes
> a = formonly.begdt TYPE CHAR, REVERSE;
> end
> instructions
> delimiters "<>";
  ^^^^^^^^^^^^^^^ this is your problem!!!
> end

I ran your form on the handiest thing, a Sparc, and as you say,
the field was not reversed but plain.

Then I noticed in the manual where it says, (page 4-51)
"on terminals that do not support reverse video, fields
having the REVERSE attribute are enclosed in angle brackets (<>)"

So I thought, hmmm, wonder if 4GL is trying to use angle
brackets, and it doesn't show because he has set angle brackets
manually?   So I changed the form to read: delimiters "{}" and
lo & behold! The field came up in nice reverse video!  

I can't figure out if this should be called a bug or a
documentation error! It is screwy enough for a bug, yet the
screwiness has a certain air of logic to it, somehow...
anybody know more?
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Error 581 ???
Date: 15 Sep 92 00:08:03 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1448>

Quoting Patrik Johansson...
} 
} 
} I've recently installed INFORMIX dbaccess Ver: 5.0.
} 
} When I tried to create a stored procedure I got the message:
} 
}   581: Error loading message file.
} 
I usually get this error if my INFORMIXDIR variable is not set.  If you
loaded Informix anywhere other than /usr/informix, this is definately the
problem.

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
Newsgroups: comp.databases.informix
Subject: Database Drop PROBLEM SOLVED!
From: naomi@anasaz (Naomi Walker)
Date: 9 Sep 92 14:49:56 GMT
Organization: Anasazi, Inc. Phoenix, AZ, USA



Our mailer is having problems, so i'll just post this, since many people
seem to have to same problem.  

naomi





Thanks to some golden advice from Bob Baskett (thank you), I have fixed
the problem with the bad database and table I could not drop.

This is not for the weak of heart, expecially when working on a production
system, and I do not encourage this mucking about if you are not desperate
(disclaimer).

Here is what I did, following Bob's directions:

1. create a table with the exact schema as the one giving you trouble.
   (for this example - use new_tab)

   NOTE: I could not do a schema on the bad database.  I created the
         schema from a similar test database.

2. get the partnum for new_tab and the old_tab (one causing problems)
   from the systables.
3. update systables - switching the partnums for the two tables.
4. delete from systables,syscolumns,sysindexs for tabid = tabid of
   new_tab
5. drop old_tab.

   This should have worked, but I got the error:
   "311 - Cannot Open System Catalogs (syscolumns)"

6.  I unloaded the rows from syscolumns from the similar database, same table.

7.  I changed the tabid's to match the table in the bad database.

8.  Again I tried to delete the table, but this time got:
   "311 - Cannot Open System Catalogs (sysindexes)"
   
    So I followed the procedure I used in step 6 and 7 and dumped the 
    sysindexes rows, and loaded them in the bad database.

9.  At this point, I was able to drop the table, and then the database.

Oh, boy!  I had fun, and am dangerous now that I am more confident 
changing system catalogs (ONLY if I have to, of course).

Thanks again, Bob, for your help (and Simon David).  I did not look 
forward to unloading all the databases in the partition.

Naomi

-- 
  Naomi Walker  (aka N7FSA)     naomi%anasaz.UUCP@asuvax.eas.asu.edu

  Enthusiasm is caught,         In tennis, 
  not taught.                   love means nothing.


-- 
  Naomi Walker  (aka N7FSA)
  Anasazi Inc.  Phoenix, Arizona 602-395-1731

  {uunet!pyramid},{sun!sunburn!gtx!},{asuvax} !anasaz!qip!naomi
From: phart@magnus.acs.ohio-state.edu (Patrick S Hart)
Subject: Informix, what do I do now ???
Organization: The Ohio State University
Date: Wed, 9 Sep 1992 19:22:05 GMT

     I have just started to learn and use Informix 4GL Rapid Development system
on the PC.  I am looking for simple tools that would provide support of common 
PC functions such as graphics, colors, math functions, etc.  I would like 
something like C libraries or 4GL source so that I would not have to build my 
own C interface between Informix and functions available from within MicroSoft 
C and go through the process of building a customized runner.

     Are there lists of FTP sites with sample/utility/common code available?
     Or a list/price list of utilities or libraries from 3rd party vendors
     FOR PCs?  (I have seen the Insync catalog, already)

     For example, I would like to do time/date manipulation which seams like a
common function (which the current version will do, but I don't have yet)

                                                      Thanks in advance
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Where's my Reverse field
Date: 9 Sep 92 12:13:09 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1433>

Quoting Bruce Momjian...
} 
} I have a field on a form I have specified as REVERSE, but it just comes
} up blank.  I know Informix knows about the reverse video on my terminal
} because my menus come up reverse.  In fact, I have some Informix
} executable from another person and its fields are reverse.  Does anyone
} know why this is happening?  Below is my form description file.
} 
} ------------------------------------------------------------------------
} 
} database formonly
} screen
} {
} 			Summary of Client/Matter Activity
} 			
} 			
} 		As-of Period [a]
} 				
} }
} end
} attributes
} a = formonly.begdt TYPE CHAR, REVERSE;
} end
} instructions
} delimiters "<>";
} end
} 				
To be totally honest, I never used any attributes in my form specification
file.  I always put my attributes in the 4GL code or used the "syscolatt"
table.  Can you put attributes in the form specification file?

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
Newsgroups: comp.databases.informix
From: porterg@nextnet.csus.edu (greg porter)
Subject: 4gl form field attributes
Organization: California State University Sacramento
Date: Tue, 15 Sep 1992 21:16:31 GMT


  Hi, I am a new 4gl programmer and am having a bit of an annoying problem.
On a 4gl form my attributes like reverse, or underline etc. don't seem to be
taking effect until a cursor actually passes trought the field.  In ISQL the
attributes take place as soon as the form is displayed.  Is there a way in
which the attributes can be foreced to take effect upon the display of the   
form?  

  Any suggestions would be appreciated

Thanks for the help.

Greg
-- 
 Greg Porter                                    |     gporter@csus.edu
 California State University, Sacramento        |     ucdavis!csusac!porterg
 University Telecommunications Services (UTS)   |     
        -- All opinions are my own and not of my employer --
Newsgroups: comp.databases.informix
From: reetz@news.colorado.edu (Mike Reetz)
Subject: Strings in SPL (Stored Procedure Language)...
Summary: anyway to concatenate strings...
Organization: University of Colorado, Boulder
Date: Mon, 14 Sep 1992 19:15:20 GMT


Is there any way to concatentate strings in SPL?  Can't find 
a way to do it (or I'm just stoooopid).  Anyone have a
good idea?

I tried:

LET long_string = shortstr1, shortstr2;

this gives an error -661 (Number of variables does not match number 
of values returned.)

I tried:

LET long_string = shortstr1 + shortstr2;

this is just a plain error.

Any other help would be greatly accepted.

--
-------------------------------------------------------------------------------
Mike Reetz                          boulder.colorado.edu!morse!reetz
ConferTech International            (800) 525-8244 or (303) 235-5378 (voice
2801 Youngfield, Golden, CO 80401   (303) 237-5151 (switchboard)        mail)
-- 
-------------------------------------------------------------------------------
Mike Reetz                          boulder.colorado.edu!morse!reetz
ConferTech International            (800) 525-8244 or (303) 235-5378 (voice
2801 Youngfield, Golden, CO 80401   (303) 237-5151 (switchboard)        mail)
Newsgroups: comp.databases
From: durai@ORTTA (Appadurai V.)
Subject: Re: Restoring Menu Popups in Foxpro 2.0
Keywords: Foxpro Popup menu restoring
Organization: U of Mn
Date: Fri, 11 Sep 1992 13:18:05 GMT

reply to <638@ddou.dla.mil> nhb1038@ddou.dla.mil (ramona lower) on 
Foxpro2 menu popup:

I have faced similar problems.  

Would you like to try "_curobj" to save and restore menu settings.  
Something like "m.oldobj" to save old menu choice/setting and restoring that 
back to _curobj.

I thought of this a while ago, but never bothered to experiment.  <i have
plenty of spare time, you see.. i go boating and fishing instead..>

I would be happy to know what happened, or if you came across a solution.
From: graeme@hart.actrix.gen.nz (Graeme Hart)
Newsgroups: comp.databases
Subject: Re: another lovely test
Date: 5 Sep 92 19:12:12 GMT
Distribution: Actrix

boag@world.std.com (Scott A Boag @ The World Public Access UNIX, Brookline, MA) once wrote....
>I am testing, testing, testing!
>
>
>-- 
>**********************************************************
>*  Scott Boag
>*  DMR Group, Inc.
>**********************************************************



You lucky person....
From: rfrx@vax5.cit.cornell.edu
Newsgroups: comp.databases
Subject: Accessing Databases from Fortran and C
Date: 8 Sep 92 15:36:36 EDT
Distribution: comp
Organization: Cornell University

Does anyone have a list of databases with preprocessors which allow one to
imbed querry languages such as SQL into FORTRAN or C?  Many databases
with such features are very expensive, so I'm wondering if there are any
cheaper ones.

Tony Yan
RFRX@Vax5.cit.cornell.edu
SIDEV group at Cornell University

Newsgroups: comp.databases,comp.databases.ingres,comp.databases.oracle,comp.databases.informix,comp.databases.sybase
From: irwin@binky.Binky.COM (Irwin Schafer)
Subject: ANSI Semantics with NULL and NOT IN
Reply-To: irwin@binky.Binky.COM (Irwin Schafer)
Organization: Binky, Inc.
Date: Wed, 16 Sep 92 02:40:53 GMT

Given table "r1":

        a1      a2      a3
        1       A       null
        2       B       1
        3       C       1

On Ingres, this query returns the value "A"
        select a2 from r1 where a1 in
                (select distinct a3 from r1);

However, this query returns no rows
        select a2 from r1 where a1 not in
                (select distinct a3 from r1);

Where one may expect two rows ("B" and "C")

The Ingres explanation is that "this is ANSI semantics when NULL is
involved in the subselect,  NOT IN is equivalent to !=ALL which
means the values must satisfy "!=" for all values in the subselect,
since, for example, 3 != NULL is FALSE given ANSI semantics, the qualification
is FALSE for all rows so zero rows are returned."

Is this true?  What do Sybase, Oracle, Informix do?

Thanks,
Irwin	 irwin@Binky.COM
Newsgroups: comp.databases
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re: C-tree and db-VISTA, any experiances ?
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Sun, 13 Sep 1992 18:39:00 GMT

In article <1992Sep12.155601.3823@compu.com>, fr@compu.com (Fred Rump from home) writes...
>walz@elde1.epfl.ch writes:
> 
> 
>>I plan to write an interactive database application generator and I'm
>>looking for a database engine I can use for this. I've had a look on
>>Faircom's C-tree and Raima's db-VISTA. Has anybody had good or bad
>>experiance with one of those products of with some other similar products
>>(C-written database engines in source form) ?
> 
>Sure would be nice to have something like that for Raima. I see it as 
>extremely difficult to do though, mainly because of the rather fixed nature of
>network style databases. You just don't willy-nilly rearrange them. These 
>suckers need to be designed up front and rather carefully.

That brings up an interesting question.  I've lately been looking into a number
of SQL databases.  As I understand it, Raima claims that for their database,
the user can either choose to use or not to use the network capabilities, and
that even if you do, the view to the user is always relational.

How important is the network structure to Raima Data Manager?  They claim it
speeds up queries--is it slower than other databases if you don't use it?  Does
the database look any different to the user than if it were maintained with a
purely relational engine?

Bill Thompson
Newsgroups: comp.databases
From: nelson@paradyne.com (Bill Nelson)
Subject: Clipper Questions from a Constipated Programmer
Organization: AT&T Paradyne, Largo, Florida
Date: Tue, 15 Sep 1992 13:38:41 GMT


I have a couple of questions about clipper in which I am entrusting to the wit and wisdom
of the net.  Please be gentle, I am but an amateur at this.

Question #1
-----------
Lines of text that I display on row 0 of the screen (using the @/say command) seem to be 
overwritten by blanks at about column 60.  Since this is the place that clipper displays
such things as "INS" (when the insert key is on) or the date, I can only assume that it 
is this which is overwriting my text (or is this an unwritable portion of the screen?).

Is there any way that I can disable this and allow a full line of output to go to row 0
or do I simply need to begin writing text at row 1?

Question #2
-----------
I have written a program where there are several times in which I am accessing the same
variables (or at least the same variable names).  This seems to use up quite a bit of 
memory.  Is there some way I can declare variable names in one common place and simple
call them into being when I set them to some value?  Note: I do not want these variables
to be global to all the routines in the program since I do not want to carry over "old" 
values entered in from some previous routine. 

Question #3
-----------
I have created a database which contains several numeric values (prices) and is accessed
by a stock number.  My program is such that when the user wants access these prices, he
enters in the stock number and the prices are displayed.  Just lately these prices have 
started being displayed incorrectly.  It seems as if the values for *some* of the items 
(not all of them) are being rounded to 2 digits.  What could be causing this?  I am using
the "TRANSFORM" function to ensure the size of the output (i.e.  transform(price,"9999.99"))
could it be somehow rounding *some* of the prices or should I look elsewhere?

Question #4
-----------
I am trying to make my program as fast and space efficient as possible (who isn't).  One of
my programs is running on an XT and is slow as molasis (as my son would say - No Duh!).  I 
have tried making the code reusable and as sleek as possible, but is still runs pretty slow.

What kind of considerations should I take into account in my programming?  Could someone
provide a sort of checklist in which could be accessed to ensure certain steps are taken 
to obtain optimum code?

--
*****************************************************************************
Bill Nelson   *    AT&T Paradyne        * Internet: nelson@pdn.paradyne.com * 
              *    Largo, FL            *************************************
              *    (813) 530-8696       *   Opinions are mine, not AT&T's   *
Newsgroups: comp.databases
From: jmh@coyote.datalog.com (John Hughes)
Subject: FORCE xbase compiler status
Keywords: dbase force compile
Organization: Random, at best.
Date: Sat, 5 Sep 92 09:12:52 GMT

Does anyone know the current status of the "FORCE" xbase compiler system
for MS-DOS platforms? The last version I'm aware of was 2.1D1, and that
was when Sophco was still the owner. It has since changed hands and, as
far as I can tell, dropped off the face of the earth. It was, to the best
of my knowledge, the only xbase compiler which produced "real" executable
code (eg. no imbedded runtime engine).

Thanks.


-- 
|     John M. Hughes      | "...unfolding in consciousness at the            |
| datalog.com!moondog!jmh | deliberate speed of pondering."  - Daniel Dennet |
| jmh%coyote@noao.edu     |--------------------------------------------------|
| jmh%moondog@datalog.com |   P.O.Box 43305      Tucson     AZ       85733   |
Newsgroups: comp.databases