I have the following

export to a.txt of del modified by coldel| messages a.msg
select *
from b_table
where b_table.nbr =any
(select c_nbr from c_table);

This statement works fine.

What I would like to do is prepend a literal to each export record.

I can achieve this by doing the following on the first select:

select 'x', nbr, .........

But is there a way to do this without naming all the fields on the select statement?

I think you want something like:

export to a.txt of del modified by coldel| messages a.msg
select 'x', b.*
from b_table as b
where b.nbr =any
(select c_nbr from c_table);


Andy

Thanks Andy, your suggestion worked just fine.