Re: SQL: how to use short names

[Steve Richter <stephenrichter@xxxxxxxxx>]

you can rename the columns in the sql so they have the same name in both
selects:

select   c1name custname
from     custmast1
union all
select   c2name custname
from     custmast 2 ;


On Tue, Feb 19, 2013 at 5:07 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:
> How do I tell SQL to use short (10 byte) names instead of alias field
names?
> 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.
> 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.