Re: SQL Question

Susan Elliott (ISG) wrote:

> Howdy Folks,
>
> I have few unloads that are done reguarly, 1 of these
> unloads is used to upload the data into an access database.
> The Access database requires quotes (") around text fields,
> currently this is being done manually using find and replace through vi -
> this can be automated at the Unix level using sed, but ideally, I would like
> the Informix unload process to do this. I seem to think that there is a way
> of doing this - has anyone any ideas ?

How about coding it into your unload query?

UNLOAD TO file.unl
SELECT """" || charcol || """", intcol, datecol, """" || varcharcol || """" FROM tablename

June

--
june_t_at_hotmail.com
Grounded in Palo Alto, living on KitKat bars