On 19 Feb 2013 14:07, Stone, Joel wrote:
Issue: I am CREATEing a table with a union and SQL errors out
because the ALIAS field names are not identical between the two
union input files. But the 10-byte names are identical.

Presumably the issue is SQL0153 "Column list required." The issue is easily resolved without naming the columns. Just use the first subselect for the CREATE TABLE AS, but using the WITH NO DATA clause. Then use the same query as what would have been the CREATE TABLE AS of the UNION query on an INSERT INTO statement.

This thread ...

Return to Archive home page | Return to MIDRANGE.COM home page