as per select question in another thread : you have to be more specific, as we can not guess what you want to do..
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
I would like to replace 3 insert with just one ...
insert into table_out select 'VOI' as cpc_code , fields from t1
insert into table_out select 'SMS' as cpc_code , fields from t1
insert into table_out select 'EMA' as cpc_code , fields from t1
do something like
insert into table_out
select a(i) , t1.name , t1.address
from t1 , table (values 'EMA', 'SOC', 'VOI', 'SMS', 'POS') a(i)
then in my output table ( table_out ) I would have
EMA Jon street1
SOC Jon street1
VOI Jon street1
SMS Jon street1
POS Jon street1