RE: imbedded sql sytax question

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

You just make each SELECT of the UNION to have the same number of and 
compatible columns - and in a view be sure to use alias names so the 
names are the same in all segments of the union.

Don't get stuck in the SELECT * trap =>> you need to be in control of 
what columns you present - no sweat.

Or just a little sweat!!

You can use literals - numeric of alpha - as place holders.

HTH
Vern

At 07:37 PM 2/28/2007, you wrote:

> I like the union idea, but the 2 files don't have duplicate layouts and I
> need more of the fields from file1 then file2.
>
> Is there a way of creating a place holder field, something like
>
> Select clientnumber, name, address, phonenumber from File1 Where phonenumber
> = '2015551212'
> Union
> Select clientnumber, filler1, filler2, phonenumber * from File2 Where
> phoneNumber = '2015551212';
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Alan Campin
> Sent: Wednesday, February 28, 2007 8:15 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: imbedded sql sytax question
>
> Aren't we just talking a Union here?
>
> Select * from File1 Where phonenumber = '2015551212'
> Union
> Select * from File2 Where phoneNumber = '2015551212';
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.