Re: Unload
From: "Martyn Shiner" <martyn.shiner@bff-nonwovens.com>
>
>Sorry to appear dim - what is the Informix syntax to cast float field to
>char to get this to work.
You don't have to do anything at all. It does it whether you want to or not.
:0)
>Scott Black <sblack@elsouth.com> wrote in message
>news:8ji4v4$6cl$1@news.xmission.com...
> >
> > Actually Informix will do the casting for you automatically (I don't
> > think you'll have any problems with money to char). But as Jonathon
> > stated, this may or may not suit your needs. Give it a try like you
> > have below (without the 'cast' part), and see it the resulting output
> > file looks like you want it to.
> >
> > Good luck.
> >
> > -----Original Message-----
> > From: Martyn Shiner [mailto:martyn.shiner@bff-nonwovens.com]
> > Sent: Friday, June 30, 2000 7:53 AM
> > Posted To: informix
> > Conversation: Unload
> > Subject: Re: Unload
> >
> > Scott,
> >
> > thanks for the reply - pity about the non-char fields. Why can't I cast
> > them
> > (sorry I'm new to informix!!)?
> >
> > like
> >
> > unload to "items.unl"> > select "imast_item", "imast_descext", "imast_cost"
> > from systables
> > where tabid = 1
> > union all
> > select imast_item, imast_descext, cast(imast_cost AS char)
> > from imast> >
> > Regards
> > Martyn
> >
>
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com