HDTenEightyP/NetNews huggingface dataset:
From: yslas@riverauswest.com ( Rob Yslas)
Subject: char database types blanks and nulls
Keywords: null,esql/c
Organization: U S WEST Advanced Technologies
Date: Mon, 12 Oct 1992 22:50:29 GMT

Using Standard Engine

This sometimes returns a blank field for the value of column1

$string column1[20];

$declare test_curs cursor for
select distinct column1
into $column1
from test_table
where column1 is not null;
$open test_curs;
$fetch test_curs;

I know that the informix char data type will blank fill to the end of a field.
If I am using the sting data type for the variable name the trailing blanks are
removed from the value placed into the array.  If the field is blank doesn't the
database treat this as a null value?  If not what situation will cause the 
database to think there is a value in that field.  Does it fill with a different
value for blank then when a user enters a blank character?  If it thinks a
blank field is null why would it return with this cursor?  Shouldn't the 
where disallow the inclusion of this blank field with the other cursor values.

Thanks in advance for any help,
Rob

-- 
yslas@advtech.uswest.com
Thanks
From: widener!uunet!uunet!microc!eric@emory.mathcs.emory.edu
Newsgroups: comp.databases.informix
Subject: Help on SmartWare  (!?)
Date: 15 Oct 92 22:48:06 GMT
Reply-To: widener!uunet!uunet!microc!eric@emory.mathcs.emory.edu
X-Informix-List-ID: <list.1516>

Please, somebody help me!

I have a customer that is using SmartWare II 1.0 and needs to format
a report using some 400 char fields.  The option that Smart shows
are left, rigth or centered, but the customer wants to just
justify it; i.e. the same left and right margins (like a word
procesor).

Is there a way to do this on the new version (2.0)?

Is there a work-around?

This is running stand-alone in a PC planning to build a Netware LAN.

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

Newsgroups: comp.databases.informix
From: jr@speedy.uucp (Juergen Roberg)
Subject: Re: sqlca.sqlcode error -522
Organization: SNS - Berlin
Date: Thu, 8 Oct 1992 13:34:34 GMT

yslas@riverauswest.com ( Rob Yslas) writes:

>Does anyone know what this error code description is it's not in my ESQL/C 
>Informix manual.

-522	Table (table-name) not selected in query.

The table shown appears at some point in this query, but it does not 
appear in the FROM clause. Review the uses of this name: if it is 
spelled as you intended, then add it to the FROM clause.


You should use the tools finderr (Informix 4.1).
To get the message above just type: finderr 522


Juergen Roberg, Siemens Nixdorf Software Engineering GmbH
Gustav-Meyer-Allee 1, D-1000 Berlin 65

EMail   USA : roberg.bln@sni-usa.com
       !USA : roberg.bln@sni.de

Phone: (+49) 030 4607-3135
Newsgroups: comp.databases.informix
From: clercqm@nijmeg.ingr.com (Marien de Clercq)
Subject: Error -4518: Cannot allocate any more space
Keywords: -4518
Organization: Intergraph Nijmegen
Distribution: comp
Date: Thu, 8 Oct 1992 16:17:59 GMT

Can someone please help me with error -4518:

	"The 4GL program cannot allocate any more space for temporary 
	string storage."

I sometimes get this error in reports.

The problem is that the program just aborts without saying in which module 
or on which line. 
The debugger also is not of much help: it showed the place where the program 
dumped, but after simplifying the code at that place it still kept aborting.

I just don't know where to look, the more because the "corrective action"
the manual proposes is not at all that clear: "this error can occur if the 
nested functions in a CALL statement return strings whose total length exceeds
512 characters".
But I don't have any function with strings or parameters that long. What do
they exactly mean with "nested functions" and "total length" ??

And I don't get this error if I do not select too much data for the report !


Who can give me a clue about where to look for a solution ???



-- 
Marien de Clercq                            ___ "She was bored with the man,
Intergraph European Mfg. bv.      /|/|    //     because no matter what happened
Nijmegen - The Netherlands       /   | __//      he was always happy as a ...
E-mail: clercqm@nijmeg.ingr.com /    |/_/ \___   clown"    -  Laurie Anderson
Newsgroups: comp.databases.informix,comp.lang.c++,comp.databases
From: cmlow@iti.gov.sg (Low Chee Meng (KSL))
Subject: Question: Can I embed SQL in C++
Keywords: informix, embedded SQL, C++, GCC
Organization: Information Technology Institute, National Computer Board, S'pore
Date: Wed, 7 Oct 1992 16:04:45 GMT

Hi,

I would like to know if anybody has any experience/success writing
embedded SQL statements inside a C++ program.

We have an Informix database and a ESQL pre-processor meant
for C. According to the local agent from Informix, the SQL
pre-processor works only on C files, not C++ files. 
We intend to use GCC as our C++ compiler, but we do not know
how to make the pre-processor work with GCC.

Is there any way to work around the abovementioned problem? 

Please reply by e-mail if possible. 

Thanks

Chee Meng


-- 
---------------------------------------------------------------------
Chee-Meng Low (cmlow@iti.gov.sg) (fax: 65-777-3043)
Knowledge Systems Lab, Information Technology Institute, Singapore
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
From: johnl@obelix.informix.com (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  ESQLC/unload/load sources
Date: 11 Oct 92 18:23:08 GMT
Reply-To: johnl@obelix.informix.com (Jonathan Leffler)
X-Informix-List-ID: <list.1513>

>From: uunet!shakti.ncst.ernet.in!aimsuser (aimsuser citibank overseas)
>Subject: ESQLC/unload/load sources
>Date: 9 Oct 92 06:42:33 GMT
>X-Informix-List-Id: <news.1948>
>
>We had received unload.ec along with ESQL/C. I was
>trying to change this program for our needs. But the
>original unload.ec has some bug, It skips some
>fields arbitarily. This behaviour is repeatable.

Not so much a bug as a feature:-)

The code is known to be incomplete -- it does not handle more than a few
types.

Yes, but it's part of a complete alternative to dbaccess/isql.
The code is correspondingly huge -- how much are you really interested in?
And how many other people are interested in the code.  If I get enough
interest, I'll post it (in several bits).

>Does any one have working versions of unload.ec/load.ec.
>
>Deenar Toraskar
>(CITICORP SOFTWARE)
>(aimsuser@shakti.ncst.ernet.in)

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: svb@svb.guug.de (Sebastian v. Bomhard)
Newsgroups: comp.databases.informix
Subject: Backspace/Delete
Date: 8 Oct 92 00:04:35 GMT
Reply-To: svb@guug.de
Organization: Brodersen + Bomhard EDV-Unternehmensberatung

Short question: I noticed that  Informix  doesn't  use  the  stty
erase  settings  but  insists  on ^H.  I don't have ^H, because I
mapped it onto ^? (I use an xterm). The  workaround  is  to  type
CYTRL+H, but I find it clumsy.  Any ideas?

System:      SS1+, SunOS  4.1.1
Front  end:  INFORMIX-SQL  Version 4.10.UC2

Thank you in advance,

  -svb.

--
Sebastian v. Bomhard                               <svb@svb.guug.de>
Brodersen + Bomhard EDV-Unternehmensberatung       <postmaster@svb.guug.de>
St.-Anna-Str. 13, D-W-8000 Muenchen 22 (Lehel),     +49-89-298934
>>>>>>>>>>>     A neat desk is a sign of a sick mind.      <<<<<<<<<<<<<
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: dbexport.
Date: 9 Oct 92 14:53:44 GMT
Distribution: comp
Organization: Informix Software, Inc.

In article <1992Oct7.2231.1781@execnet> "clay irving" 
	<clay.irving@execnet.com> writes:
>
>When you load the database from the dbimport hasn't the extent information 
>been lost?...

Yes, as well as lock modes and dbspace locations of the tables.  If you have
only one dbspace, and use default lock modes and extent sizes, this would
not be a problem.  Otherwise, you would have to modify the sql file
produced by dbexport.  As of the 6.0 release, this will be remedied.

Again, dbexport/dbexport was *originally* intended to migrate an SE database
to Turbo (thus the omission of these parameters).

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
The heart and the mind on a parallel course, never the two shall meet.
						-E. Saliers
From: lei@mtcdev.COM (Charles Lei)
Newsgroups: comp.databases.informix
Subject: Re: Error -4518: Cannot allocate any more space
Date: 16 Oct 92 18:43:09 GMT
Reply-To: lei@mtcdev.COM (Charles Lei)
X-Informix-List-ID: <list.1523>

Marien,

We ran into this same string sotrage problem last year and we 
received through the net C routines that got us around the problem.
The C routines allowed you to save,clear, and restore the string 
space stack within a function, thus completely eliminating  the -4518
error.

Let me know if you'd like a copy, it may help you out.


Charles Lei
Mediatech, Inc.

E-Mail: lei@mediatech.com
Voice: (312) 828-1146
UUCP: ..!{uunet,4gen}!mtcdev!lei
From: billd@informix.com (William Daul)
Newsgroups: comp.databases.informix
Subject: Re: sqlca.sqlcode error -522
Date: 8 Oct 92 06:06:09 GMT
Organization: Informix Software, Inc.

In <1992Oct7.202905.1988@advtech.uswest.com> yslas@riverauswest.com ( Rob Yslas) writes:

>Does anyone know what this error code description is it's not in my ESQL/C 
>Informix manual.


                   TechInfo # 97

Long Description: 
Error 522 is generated when you reference a table in the where
clause that is not used in the select statement.

  select * from customer where tab.customer = value



                   TechInfo # 2049

Long Description: 
-522

Table (table-name) not selected in query.

The table shown appears at some point in this query, but it does not 
appear in the FROM clause. Review the uses of this name: if it is spelled 
as you intended, then add it to the FROM clause.
-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
 William Daul             Advanced Support      INFORMIX SOFTWARE INC.
 4100 Bohannon Dr.        (415) 926-6488 - wk
 Menlo Park, CA. 94025    uunet!infmx!billd  or  billd@informix.com
From: baskett@hermes1.sps.mot.com (Bob Baskett)
Newsgroups: comp.databases.informix
Subject: Re:  Error -4518: Cannot allocate any more space
Date: 9 Oct 92 05:18:08 GMT
Reply-To: baskett@hermes1.sps.mot.com (Bob Baskett)
X-Informix-List-ID: <list.1510>

Marien,

this error can occur when your using the 'print xxx using "####"' construct.
other string space eaters are using functions in if-then conditions.  by
this, i mean the following:

if (upshift(somevar) = 'Y') then statement end if

this can be replaced with:

define someothervar char(#)
let someothervar = upshift(somevar)
if (someothervar = 'Y') then statement end if

this takes more code, but uses less temp string space.

hope this helps.

-----------------------------------------------------------------------------
Bob Baskett
Motorola, Inc.
Newsgroups: comp.databases.informix
From: clercqm@nijmeg.ingr.com (Marien de Clercq)
Subject: Re: Error -4518: Cannot allocate any more space
Organization: Intergraph Nijmegen
Date: Fri, 16 Oct 1992 10:37:52 GMT


Thanks you all who reacted to my request for help on error -4518 (cannot 
allocate any more space for temporary string storage).

I really tried all the solutions and work-arounds you suggested. Some of them
worked a little bit: the program dumped somewhat further on. So I guess the
problem is caused by a combination of possible "string-eating" situations.

But after two days of trying to get the thing running I have give up :(

After all, the problems only occurs when the data of more than one employee 
were selected (it's a report in a time-registration program). So I simply 
will restrict the selection to the data of one employee at a time, untill 
Informix has fixed this temporary string space problem.


-- 
Marien de Clercq                             ___ 
Intergraph European Mfg. bv.       /|/|    //     "The balance is always a lie"
Nijmegen - The Netherlands        /   | __//    
E-mail: clercqm@nijmeg.ingr.com  /    |/_/ \___             - David Halberstam
From: mfaurot@bogart.uucp (Michael Faurot)
Newsgroups: comp.databases.informix
Subject: Default dbspace?
Date: 8 Oct 92 16:52:11 GMT
Organization: ism:c:m/xo

This has probably already been discussed to death, so please reply by
e-mail.

Is there a way with OnLine v4.0 or v4.1 to make the default dbspace
something other than the root dbspace?

Thanks.

-- 

+--------------------+-------------------------------------------------------+
|   Michael Faurot   | Domain: mfaurot@bogart.UUCP		             |
|   ------- ------   | UUCP:   ...uunet!media!ka3ovk!irscscm!bogart!mfaurot  |
+--------------------+-------------------------------------------------------+
From: nll@cbnewsb.cb.att.com (neal.l.leitner)
Newsgroups: comp.databases.informix
Subject: Re: Informix 4.1 vs later versions
Date: 8 Oct 92 14:32:55 GMT
Organization: AT&T

From article <1992Oct8.121056.19648@cs.umb.edu>, by tchow@ra.cs.umb.edu (Tony Yee Chow):
> I have sent a message before and it got corrupted.  So I am posting it again.
> 
> Our company is going to install an Informix system and I would like to know
> which version of Informix is better (programming bugs, stability, and helpful
> hints).  I have heard that 4.1 is the most stable version so far.  Is that
> true?
> Thanks in advance.
> Tony Chow.

I had to chuckle a little when you used the word "stable".  I am using 
Informix 4.10 UC4 for AT&T Unix version 4.0.  The 4gl in earlier releases
of 4.10 was pretty buggy, with core dumps when executing 4gl programs.  It
was fixed and attributed to a memory management problem.  The current
release is 4.10 UC4, which seems ok except for one bug that was uncovered the
other day.  The bug is if your TERMCAP variable points to the informix termcap
and your terminal is not listed, it will dump a core.  Otherwise I have not
noticed anything else yet with 4.10 UC4.

Neal Leitner
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Licencing Query I4GL RDS & ESQL/C
Date: 16 Oct 92 02:48:08 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1520>

Quoting Mark Kellaway...
} 
} I have a question about the Informix products and licencing.
} 
} We have a product that is written in I4GL V4.00.
} 
} In the current development phase we can see the need for a .ec function, 
} do we need to purchase ESQL/C, since we could just use c4gl to compile it,
} or does this infringe the Licencing.
} 
I don't know if it infringes on the licencing... I do know that it is
documented on page 1-35 of the Informix-4GL Reference manual.  Only a fool
would document something that would infringe on licences.

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Error -4518: Cannot allocate any more space
Date: 9 Oct 92 12:48:06 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1511>

Quoting Marien de Clercq...
} 
} Can someone please help me with error -4518:
} 
} 	"The 4GL program cannot allocate any more space for temporary 
} 	string storage."
} 
} I sometimes get this error in reports.
} 
This error can be caused by any of the following:
  1)  CASE statements without an OTHERWISE
  2)  CASE statements that look like this:
	  CASE dummy_var
	      WHEN 0
		  .....
	      WHEN 1
		  .....
	      WHEN 2
		  .....
	  END CASE
      instead of this:
	  CASE
	      WHEN dummy_var = 0
		  .....
	      WHEN dummy_var = 1
		  .....
	      WHEN dummy_var = 2
		  .....
	  END CASE
  3)  Reports with excessive string usage (ie. USING)

I probably missed a few.  Call tech. support, they faxed me something that
showed examples of what caused the error and how to work around it.  I
found that by compiling it to an executable, the problem always goes away.

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
Newsgroups: comp.databases.informix
From: forney@esd.dl.nec.com (Elizabeth (Liz) J. Forney)
Subject: Function Prototypes for ESQL/C
Organization: NEC America, Engineering & Support
Date: Thu, 8 Oct 1992 16:31:05 GMT

Back in April Jonathan Leffler from Informix posted ".h" files that
contained the function prototypes for ESQL/C.  I have recently upgraded
from 4.10 ESQL/C to 5.00 ESQL/C, and need to flush out the differences
between the prototype function declarations between the two versions.

In particular, did the prototype declaration for sqgetdbs (to obtain a list
of databases known to OnLine change.)

Jonathan - or anyone else know the answer!

Thanks,
Liz Forney,
Software Engineer
NEC America, Inc.
From: bob@worms-emh2.army.mil (Bob Kane)
Newsgroups: comp.databases.informix
Subject: Re:  Query By Example in 4GL
Date: 16 Oct 92 17:23:17 GMT
Reply-To: bob@worms-emh2.army.mil (Bob Kane)
X-Informix-List-ID: <list.1522>

Andy Watson asks:
>
>When one uses the CONSTRUCT command in 4GL it blanks the listed screen 
>fields before allowing user input. Does anyone know of a means of 
>avoiding this, or alternative ways of achieving the functionality below.
>
>a) To allow the user to edit his previously entered criteria (e.g. his 
>first search returns far less than he expected)
>
>b) Use a QBE on two fields to search Table 1. Only if that fails search
>using the same values on table 2. One way I've thought of is to replace
>the Table 1 column names in the return field of the original CONSTRUCT.
>
>Informix 4GL V1.1 by the way, but V4.0 manuals don't look any different
>
>Thanks in Advance
>
Andy,

You can of course upgrade to 4.1, but not all of us have nice budgets lying
around.  The work-around that we use in 4.0 and earlier versions is to use
an INPUT statement instead of CONSTRUCT.   If you use the WITHOUT DEFAULTS
attribute, the INPUT will not clear the form, and you have full control
of user entry with BEFORE and AFTER field constructs.  All you have to do is
take the users entry and bulid your own WHERE clause.  The examples of what 
a normal WHERE clause built with CONSTRUCT looks like are in the book.  Since
you built the WHERE clause, you can control the FIELD names in it for problem
(B) above.

Cheers

-----------------------------------------------------------------------------
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
From: tchow@ra.cs.umb.edu (Tony Yee Chow)
Newsgroups: comp.databases.informix
Subject: Informix 4.1 vs later versions
Date: 8 Oct 92 12:10:56 GMT
Organization: University of Massachusetts at Boston, Dept of Math and CS

I have sent a message before and it got corrupted.  So I am posting it again.

Our company is going to install an Informix system and I would like to know
which version of Informix is better (programming bugs, stability, and helpful
hints).  I have heard that 4.1 is the most stable version so far.  Is that
true?
Thanks in advance.
Tony Chow.
From: ado@ibg1.ibg.sub.org (Christoph Adomeit)
Newsgroups: comp.databases.informix
Subject: Who can build a select-statement for that ?
Date: 12 Oct 92 21:14:59 GMT
Organization: ibg

Hi SQL-Freaks,
I've got a complicated problem with SQL:
I've got to tables :
	a) article :
			- artnr
			....
	b) relatedarticle
			-artnr
			-relatedartnr
			-factor
			....

The sense is: If the user writes an invoice for an article,
let's say a PC, he automatically gets another position, lets say
a serial-port and maybe another position, lets say a VGA-Card
automatically.

In this case if my tables look like:
article
------------
(artno)
PC ....
SERIALPORT
FLOPPYDRIVE

relatedarticle
------------
(artno)      (relatedartno) (factor)
PC           VGACARD        1
PC           SERIALPORT     2
PC           FLOPPYDRIVE    2
SERIALPORT   DB25CABLE      1

If i write an invoice and simply enter PC I get the following invoice :
Items  article
2      PC
2      VGACARD
4      SERIALPORT
4      DB25CABLE
4      FLOPPYDRIVE

This works perfectly. But: If some crazy secretary will define a 'PC' as
a related article for a 'FLOPPYDRIVE', I get an endless invoice because
of recursion.

So what I need is an SQL-select statement that allows to detect, wether
there is recursion in the definition of related articles.
Has anybody an idea ?

-- 
Origin: It's not a bug, it's a feature !
Newsgroups: comp.databases.informix
From: aec@cbnewsd.cb.att.com (arthur.e.cooper)
Subject: Re: Modulus Arithmatic
Organization: AT&T
Date: Mon, 12 Oct 1992 17:02:24 GMT
Keywords: cace, C functions


> In message  <9210051003.aa03784@dmrinc.com> ( Bob Hadden ) wrote:
> 
> 
> I rarely need to do modulo arithmatic, but I seem to
> remember being able to have this capability in Informix. But
> I can't seem to find a manual that shows the corect syntax
> for this operation in ACE.  
> This is strictly for SQL, and the SE engine (NO 4GL).
> Anyone out there have a simple answer?
> 
> RH.
> 
Failing to find a way to do modulo arithmetic in ACE one can
reach the same goal with a C function called by the report 
program. Write the C function. The functions to be defined
in the C program must be declared in the report spec file in 
the define section. ( Call the function where needed in the 
report. ) Compile and link using the shell script called cace. 
A customized version of sacego is created by cace. 
I have not used this feature but have seen references in the
following:
	1. INFORMIX-ESQL/C Programmer,s Manual 
	    Chapter 6. "C Functions in ACE and Perform".
	2. Data Processing in UNIX by R. S. Tare (McGraw-Hill)
	    Chapter 6.2.12 "Interfacing C Functions"


-- 


    Art Cooper    AT&T Bell Laboratories    att!ihlpk!wd9aet   708-979-3049