RSS Feed: IIUG Forum: Classics

Classics is a forum to discuss all aspects of Informix classic tools including Standard Engine (SE), Online 5, 4GL, D4GL, ESQL, ISQL and others.

Re: ISQL error when other language ttha en_us
Posted by: jleffler.iiug@gmail.com (Jonathan Leffler) - Wed, 01 Sep 2010 02:07:24 EDT
On Fri, Aug 20, 2010 at 03:02, WOLFGANG PFUELLER <w.pfueller@saskia.de>wrote:

> in isql i have created a new formular and compiled successful.
> when i execute the form isql says "unbekannte Fehlermeldung Nr.: 3120"
> It works perfect with CLIENT_LOCALE=en_us.8859-1
>
> my Params:
> OS SuSE Linux 10
> ISQL 7.50UC3
> ILS 3.50MC4
> LANG=de_DE.UTF-8
> DBLANG=$INFORMIXDIR/msg/de_de/0333
> SERVER_LOCALE=de_de.8859-1
> DB_LOCALE=de_de.8859-1
> CLIENT_LOCALE=de_de.8859-1
>

Sorry for the long delay responding - I hope you've got it resolved long
ago.

Two counter-questions:

1. Is the runtime environment you show the one you compiled with?
2. Does it work any differently (even a different error number) with
LANG=de_de.8859-1?

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.

--0022152d5fb541ac52048f2c8201




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3764]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

ISQL error when other language ttha en_us
Posted by: w.pfueller@saskia.de (WOLFGANG PFUELLER) - Fri, 20 Aug 2010 06:02:05 EDT
in isql i have created a new formular and compiled successful.
when i execute the form isql says "unbekannte Fehlermeldung Nr.: 3120"
It works perfect with CLIENT_LOCALE=en_us.8859-1

my Params:
OS SuSE Linux 10
ISQL 7.50UC3
ILS 3.50MC4
LANG=de_DE.UTF-8
DBLANG=$INFORMIXDIR/msg/de_de/0333
SERVER_LOCALE=de_de.8859-1
DB_LOCALE=de_de.8859-1
CLIENT_LOCALE=de_de.8859-1




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3763]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: informix 10
Posted by: art.kagel@gmail.com (Art Kagel) - Wed, 18 Aug 2010 20:54:43 EDT
Could it be that the missing function was a C function? For R4gl yoi will
have to link a runner with that C function.

Art

On Aug 18, 2010 11:02 AM, "LYNETTE OLIVIER" <logizmax84@gmail.com> wrote:
> good day,
>
> help is highly appreciated.
>
> we upgraded our server to informix 10(unfortunetly our erp only works with

> version 10)
>
> on our old system we used to use i4gl but now it changed to r4gl.
>
> when i run a report on the new server that worked on the old system
without
> any errors: i receive the following errors
>
> FORMS statement error number -1338.
> The function "get_origin" has not been defined in any module in
> the program.
> FORMS statement error number -1338.
> The function "get_sgc_origin" has not been defined in any module in
> the program.
>
>
>



>
>

--0016e6434aeef509f3048e224e15




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3762]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: informix 10
Posted by: domusonline@gmail.com (Fernando Nunes) - Wed, 18 Aug 2010 13:08:11 EDT
On Wed, Aug 18, 2010 at 4:02 PM, LYNETTE OLIVIER <logizmax84@gmail.com>wrote:

> good day,
>
> help is highly appreciated.
>
> we upgraded our server to informix 10(unfortunetly our erp only works with
> version 10)
>
> on our old system we used to use i4gl but now it changed to r4gl.
>
> when i run a report on the new server that worked on the old system without
> any errors: i receive the following errors
>
> FORMS statement error number -1338.
> The function "get_origin" has not been defined in any module in
> the program.
> FORMS statement error number -1338.
> The function "get_sgc_origin" has not been defined in any module in
> the program.
>
>
>
>

>
>
>

Regarding the undefined functions, you should "grep" for them in the
original sources (4GL, EC and C you may have) and check that the modules
where they are defined are part of you current compilation process.

Regarding version 10, you probably already know it will be out of support in
a few weeks (end of September). You should check the next Chat with the Labs
(August 26) for other support options (in case you're not already aware).

And you should make some pressure on your ERP vendor... Assuming they have a
set of tests to certify a certain version it shouldn't be too hard to run
them against 11.50. And if any problem is identified I'm sure IBM can
help... Moving to IDS 10 means essentially the same amount of work as moving
to IDS 11.50. And 11.50 has a future... And a lot more features... I
honestly believe IBM does everything possible to maintain backward
compatibility. And I usually do upgrades to the latest versions without
issues... All this means moving to 10 or 11.10 is a waste of time and
resources, and means customers will stay in versions with much more
limitations than the current ones.

Regards.

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--00163630ff417da781048e1c044e




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3761]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: informix 10
Posted by: noel@gfm.co.uk (Noel Murphy) - Wed, 18 Aug 2010 11:35:58 EDT
It looks like you haven't included all the functions when you recomplied
to r4gl. Check that you haven't missed out a module.

-----Original Message-----
From: classics-bounces@iiug.org [mailto:classics-bounces@iiug.org] On
Behalf Of LYNETTE OLIVIER
Sent: 18 August 2010 16:02
To: classics@iiug.org
Subject: informix 10 [3758]

good day,

help is highly appreciated.

we upgraded our server to informix 10(unfortunetly our erp only works
with version 10)

on our old system we used to use i4gl but now it changed to r4gl.

when i run a report on the new server that worked on the old system
without any errors: i receive the following errors

FORMS statement error number -1338.
The function "get_origin" has not been defined in any module in the
program.
FORMS statement error number -1338.
The function "get_sgc_origin" has not been defined in any module in the
program.

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System before entering the GFM Network. If you have any
queries please contact Systems Administration or IT.
________________________________________________________________________

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3760]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: informix 10
Posted by: smiley73@googlemail.com (Keith Simmons) - Wed, 18 Aug 2010 11:16:27 EDT
On 18 August 2010 16:02, LYNETTE OLIVIER <logizmax84@gmail.com> wrote:
> good day,
>
> help is highly appreciated.
>
> we upgraded our server to informix 10(unfortunetly our erp only works with
> version 10)
>
> on our old system we used to use i4gl but now it changed to r4gl.
>
> when i run a report on the new server that worked on the old system without
> any errors: i receive the following errors
>
> FORMS statement error number -1338.
> The function "get_origin" has not been defined in any module in
> the program.
> FORMS statement error number -1338.
> The function "get_sgc_origin" has not been defined in any module in
> the program.
>
>
>

>
>
>

Lynette

Firstly, why have you changed from i4gl to r4gl, i4gl will work with IDS10
just as well as r4gl !
However, there two functions, are they 4gl functions or C functions. If they
are 4gl functions then you are missing a module from your planned compile
list, check that all required source modules are associated with the program.
If they are C (or other non-4gl) functions then you will need a customised
pcode runner in order to allow access to the function. Look at the 4GL
Manual for further details on how to do this.

Keith




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3759]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

informix 10
Posted by: logizmax84@gmail.com (LYNETTE OLIVIER) - Wed, 18 Aug 2010 11:02:01 EDT
good day,

help is highly appreciated.

we upgraded our server to informix 10(unfortunetly our erp only works with
version 10)

on our old system we used to use i4gl but now it changed to r4gl.

when i run a report on the new server that worked on the old system without
any errors: i receive the following errors

FORMS statement error number -1338.
The function "get_origin" has not been defined in any module in
the program.
FORMS statement error number -1338.
The function "get_sgc_origin" has not been defined in any module in
the program.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3758]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Printing Graphics (logo) in Informix
Posted by: amarini@fazenda.ms.gov.br (Alexandre Marini) - Wed, 11 Aug 2010 09:09:36 EDT
Hello.
Just a tip: you could also look for any printer specific resource.

Here we implemented several reports using macros, that enabled us to do
an external layout for a page, for
example, or even "2 pages per paper" features, including images on it.

But that will depend specifically on your printer model features, ok?

Hope it helps.
Best regards.

Em 11/08/2010 09:04, Yves Vallet escreveu:
> Le 11/08/2010 12:09, FELIX MWANGO MUTALE a écrit :
>> Dear All,
>>
>> I need your valuable advice.
>>
>> We have Informix SE version 7.26 UC6R1
>> Informix 4gl Developer version 7.32 UC4
>> Informix 4gl Run time version 7.32 UC4
>> Informix 4gl Compiler RT version 7.32 UC3
>> Informix SQL Development version 7.32 UC4
>> Informix SQL Run time version 7.32 UC4
>>
>> I just wonder if it will be possible to include graphics, like a logo in a
>> print report. If so, how ?
>>
>> Thanks.
>>
>> Felix Mwango Mutale
>>
>>
>>
>

>>
>>
>>
>>

--

Alexandre Marini

Tecnologia da Informação - DBA

msn: alexandre_marini@hotmail.com

SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix

Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>

IBM Informix Dynamic Server Certified Professional V10 / V11




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3757]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Printing Graphics (logo) in Informix
Posted by: yvallet@ilta.fr (Yves Vallet) - Wed, 11 Aug 2010 09:04:23 EDT
Le 11/08/2010 12:09, FELIX MWANGO MUTALE a écrit :
> Dear All,
>
> I need your valuable advice.
>
> We have Informix SE version 7.26 UC6R1
> Informix 4gl Developer version 7.32 UC4
> Informix 4gl Run time version 7.32 UC4
> Informix 4gl Compiler RT version 7.32 UC3
> Informix SQL Development version 7.32 UC4
> Informix SQL Run time version 7.32 UC4
>
> I just wonder if it will be possible to include graphics, like a logo in a
> print report. If so, how ?
>
> Thanks.
>
> Felix Mwango Mutale
>
>
>

>
>
>
>

--
To do it with SE :

report to "filexxx.txt"
Then run a shell to transform the file to pdf with txt2pdf
(www.sanface.com/*txt2pdf*.html )
with This tool you can insert graphics (jpeg, ...) in the file

Cheap and Easy

Yves




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3756]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Printing Graphics (logo) in Informix
Posted by: art.kagel@gmail.com (Art Kagel) - Wed, 11 Aug 2010 07:06:46 EDT
Not easy with Informix 4GL. With the 3rd party 4GLs (Aubit, 4Js, and
Querix) it is rather easier as they can output to PDF and other formats that
handle graphics. From Informix 4GL you would have to handle the printer
codes to map in the graphics yourself and probably output the graphic to a
file first.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.

On Wed, Aug 11, 2010 at 6:09 AM, FELIX MWANGO MUTALE
<fmutale02@yahoo.com>wrote:

> Dear All,
>
> I need your valuable advice.
>
> We have Informix SE version 7.26 UC6R1
> Informix 4gl Developer version 7.32 UC4
> Informix 4gl Run time version 7.32 UC4
> Informix 4gl Compiler RT version 7.32 UC3
> Informix SQL Development version 7.32 UC4
> Informix SQL Run time version 7.32 UC4
>
> I just wonder if it will be possible to include graphics, like a logo in a
> print report. If so, how ?
>
> Thanks.
>
> Felix Mwango Mutale
>
>
>
>

>
>
>

--000e0cd56b367e51f7048d8a3e10




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3755]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Printing Graphics (logo) in Informix
Posted by: fmutale02@yahoo.com (FELIX MWANGO MUTALE) - Wed, 11 Aug 2010 06:09:55 EDT
Dear All,

I need your valuable advice.

We have Informix SE version 7.26 UC6R1
Informix 4gl Developer version 7.32 UC4
Informix 4gl Run time version 7.32 UC4
Informix 4gl Compiler RT version 7.32 UC3
Informix SQL Development version 7.32 UC4
Informix SQL Run time version 7.32 UC4

I just wonder if it will be possible to include graphics, like a logo in a
print report. If so, how ?

Thanks.

Felix Mwango Mutale




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3754]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: error 1005 when simply trying to execute isql
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 30 Jul 2010 14:46:38 EDT
Yes. Make sure that TERM is correctly set. It might be that TERM is not
defined or is defined to something that the termcap file or terminfo
database does not define.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.

On Fri, Jul 30, 2010 at 2:43 PM, WILL LANDSTROM
<willlandstrom@yahoo.com>wrote:

> Hey everyone....HP-UX ia64 machine I have SE 7.25 UC7 ISQL 7.50 UC4 and
> also
> CSDK 3.50 UC7 installed. Everything seems to work fine except for isql
> which
> gives an error 1005 which supposedly means the TERMCAP variable is set
> incorrectly. However on another machine isql is working WITHOUT the TERMCAP
> var set. Would you happen to know how to address this? Thanks. Will
> Landstrom
>
>
>
>

>
>
>

--00504502e23d0d4e00048c9f4505




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3753]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

error 1005 when simply trying to execute isql
Posted by: willlandstrom@yahoo.com (WILL LANDSTROM) - Fri, 30 Jul 2010 14:43:07 EDT
Hey everyone....HP-UX ia64 machine I have SE 7.25 UC7 ISQL 7.50 UC4 and also
CSDK 3.50 UC7 installed. Everything seems to work fine except for isql which
gives an error 1005 which supposedly means the TERMCAP variable is set
incorrectly. However on another machine isql is working WITHOUT the TERMCAP
var set. Would you happen to know how to address this? Thanks. Will Landstrom




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3752]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Documentation for latest 4gl Reference
Posted by: adolfo.flores@lycos.com (adolfo flores) - Tue, 27 Jul 2010 13:41:53 EDT
You can see here:

release note :
http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.relnotes.doc/relnotes_4gl.html

web service with 4gl
http://www.ibm.com/developerworks/data/library/techarticle/dm-0910i4glwebservices/

Manual reference
http://publib.boulder.ibm.com/infocenter/ifxhelp/v0/index.jsp?topic=/com.ibm.tools.doc/4gl.html

Regards

---------[ Received Mail Content ]----------

Subject : Re: Documentation for latest 4gl Reference [3749]

Date : Tue, 27 Jul 2010 09:04:03 -0400 (EDT)

From : "Obnoxio The Clown" <obnoxio@serendipita.com>

To : classics@iiug.org

K CHANDRA wrote:

> Kindly suggest if any online documentation is available from IBM.

Didn't I just do that?

--

Cheers,

Obnoxio The Clown

http://obotheclown.blogspot.com

I will now proceed to pleasure myself with this fish.

--

This message has been scanned for viruses and

dangerous content by OpenProtect(http://www.openprotect.com), and is

believed to be clean.






Adolfo D. Flores T.
\nmailto:adolfo.flores@mailcity.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3751]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Documentation for latest 4gl Reference
Posted by: chandra.kala00@gmail.com (K CHANDRA) - Tue, 27 Jul 2010 09:21:09 EDT
Yes..thank you. You beat us before our second went in. If there is nothing
downloadable from IBM for free, I was asking if there is any that we can
access when online. But your link has a downloadable manual.
Thank you.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3750]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Documentation for latest 4gl Reference
Posted by: obnoxio@serendipita.com (Obnoxio The Clown) - Tue, 27 Jul 2010 09:04:07 EDT
K CHANDRA wrote:
> Kindly suggest if any online documentation is available from IBM.

Didn't I just do that?

--
Cheers,
Obnoxio The Clown

http://obotheclown.blogspot.com
I will now proceed to pleasure myself with this fish.

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3749]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Documentation for latest 4gl Reference
Posted by: chandra.kala00@gmail.com (K CHANDRA) - Tue, 27 Jul 2010 08:58:42 EDT
Kindly suggest if any online documentation is available from IBM.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3748]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Documentation for latest 4gl Reference
Posted by: obnoxio@serendipita.com (Obnoxio The Clown) - Tue, 27 Jul 2010 08:57:35 EDT
K CHANDRA wrote:
> We have Informix-4gl Reference volumes from Informix Press for version 6.0.
> Where can we find the latest Reference volumes to use ?. Our client updated
to
> Informix 11.x recently.

http://www-01.ibm.com/support/docview.wss?uid=swg27018472

--
Cheers,
Obnoxio The Clown

http://obotheclown.blogspot.com
I will now proceed to pleasure myself with this fish.

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3747]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Documentation for latest 4gl Reference
Posted by: chandra.kala00@gmail.com (K CHANDRA) - Tue, 27 Jul 2010 08:54:52 EDT
We have Informix-4gl Reference volumes from Informix Press for version 6.0.
Where can we find the latest Reference volumes to use ?. Our client updated to
Informix 11.x recently.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3746]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Unload with smallfloats issue
Posted by: domusonline@gmail.com (Fernando Nunes) - Fri, 23 Jul 2010 12:04:39 EDT
If this is what I found it happens when the value is 0 or 0.00.
Regards.

On Fri, Jul 23, 2010 at 4:06 PM, Art Kagel <art.kagel@gmail.com> wrote:

> First, are you using the UNLOAD command in isql or the UNLOAD verb in 4GL?
> They are different implementations, so there may be a different answer
> depending. Second, if you can identify which row(s) are unloading with this
> 'value', can you create a table with a DECIMAL(20,10) column, copy the
> value
> from the original table to this test table and display the value that's
> stored in the DECIMAL column? It may be that the value is a very tiny
> fraction and can't be correctly converted to a string by whichever library
> you are using. If this fixes the problem, in that you can get a good value
> from the DECIMAL column, you can try staging the data you want to unload
> through a table with a DECIMAL column in place of the SMALLFLOAT column (or
> just ALTER the original column to DECIMAL(10) - 10 digit floating point
> (the
> same resolution as a SMALLFLOAT but more precise).
>
> Another alternative would be to UPDATE all rows with a value in this
> columns
> that's less than 0.00000001 to be zero before the unload.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or
> by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Fri, Jul 23, 2010 at 10:45 AM, Vigil, Joe <jvigil@avibank.com> wrote:
>
> > Our environment:
> > AIX 4.3.3, I-SQL version 7.20.UD2, SE version 7.24.UC1, I4GL version
> > 7.20.UD2.
> >
> > I've discovered that when I do an UNLOAD on a table that contains
> > smallfloat
> > fields, sometimes (not all the time) the smallfloat field will be
> unloaded
> > as
> > "-le" (dash lower case L and lower case E) when it should be zero. This
> > causes
> > a subsequent LOAD to fail (character to numeric conversion error).
> > Anyone else encountered this?
> > As workarounds, I can pipe it through "sed" or download something from
> the
> > iiug archives, but I'd like to know how to prevent it (if possible).
> > Thanks!
> >
> > - Joe Vigil
> >
> >
> >
> >
>
>

> >
> >
> >
>
> --0022152d83f5892264048c0f625a
>
>
>
>

>
>
>

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--00c09fa21ac3eb5d81048c1030b8




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [3745]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *