Re: Unloading a DECIMAL with no period

#1

On Fri, 2007-10-26 at 07:17 -0700, Omar Muñoz wrote:

Quote:

Hi.
I have to deliver an unload-like file from a query
with many DECIMAL data, but they require that numbers
be rounded and be shown with no period. But when I use
unload the final file shows "250.0" instead of "250",
which is what they want.
I didn't find anything about this issue in the SQL
Reference (It just mentions that DECIMAL uses format
#.# and INT uses #, but I'm afraid of getting overflow
error if I convert query results in integer) or in que
GLS Reference. I wonder if somebody can help me on
this.

It would help if you mentioned the version of engine and/or operating
system and/or client language you're using, since that defines the set
of tools available to solve your problem. Conceivable solutions include:

* If your engine is sufficiently new, you could try to cast the decimal
column(s) to int8.
* Let the file be created by unload as it is now, and post-process the
fil with awk, sed, or perl to remove the decimals.
* Don't use unload at all and instead write a simple program in ESQL/C,
Python, Perl, Ruby, PHP, or whatever, to create the file in the format
you need.

HTH,

--
Carsten Haese
http://informixdb.sourceforge.net

#2

Omar Muñoz wrote:

Quote:

Hi.
I have to deliver an unload-like file from a query
with many DECIMAL data, but they require that numbers
be rounded and be shown with no period. But when I use
unload the final file shows "250.0" instead of "250",
which is what they want.
I didn't find anything about this issue in the SQL
Reference (It just mentions that DECIMAL uses format
#.# and INT uses #, but I'm afraid of getting overflow
error if I convert query results in integer) or in que
GLS Reference. I wonder if somebody can help me on
this.

thanks in advance
Omar Muñoz.

P. By the way, I'm working with Informix 9.4 FC7.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

unload to temp_file.unl
select trunc(20.01)||"" from systables where tabid = 1;

It stinks, but for a one time job it will work on any version...
Regards.

--
Fernando Nunes
Portugal

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Unloading a DECIMAL with no period

comp.databases.informix comp.databases.informix

Re: Unloading a DECIMAL with no period - 10-26-2007 , 10:39 AM

Re: Unloading a DECIMAL with no period - 10-26-2007 , 06:41 PM