adding column to outfile

[Anon]

Hi:

I have poured over outfile documentation looking for a way to select certain columns from a table and output them to a text file and add my own columns during the output process.

In other words, between one column and the next I would like to add a column (in the text file) with the value 'U'. This column does not exist in the table.

HELP!!!

Thanks,

Jock

[Anon]

select aleb, 'U', bleb from ogrish ...

[Anon]

This did not work 🙁 - I added this:

column1, 'U',column2, etc...

to my select statement - output file contained: column1, column2

Jock