| Below is the latest content available from this feed: 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]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * | | | Subscribe to this feed | | You can subscribe to this RSS feed in a number of ways, including the following: Drag the orange RSS button into your News Reader Drag the URL of the RSS feed into your News Reader Cut and paste the URL of the RSS feed into your News Reader>v | |