RE: Unload

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

Scott Sorry to appear dim - what is the Informix syntax to cast float field to char to get this to work. Regards Martyn 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 >