You could create a Stored Procedure that build the request form column names found in syscolumns.
Puesdo SQL code:
With tableA as (select columns from syscolumns where table = fileA),
tableB as (select columns from syscolumns where table = fileB)
select columns from tableA as A join tableB as B using(columns)
But that in a cursor and loop through it to build the SQL statement string with all field names. Prepare and execute that statement.
I posted a stored procedure a few weeks ago that would help in getting this started.
-Tom Stieger
IT Manager
California Fine Wire
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Wednesday, December 19, 2012 11:45 AM
To: 'Midrange Systems Technical Discussion'
Subject: SQL union - is there a CPYF *DROP type of directive?
I have two files that are ALMOST identical
fileA: field1, field2, field3, field99
fileB: field1, field2, field3, field4, field99
Can I create an SQL UNION without naming fields - and have SQL drop any fields from the second file that are NOT in the first file?
Or must I name fields (creates maintenance headaches down the road).
For example can I do something like:
create table fileAandfileB as
(select * from fileA
union
select * from fileB
) with data *drop missing columns
Thanks!
______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit
http://www.symanteccloud.com ______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
