RE: How do I add the member name to an SQL request for multi membered PF?

I always use QTEMP for aliases. I normally do not want them hanging around.



Sent from my Galaxy Tab® A


-------- Original message --------
From: Sam_L <lennon_s_j@xxxxxxxxxxx>
Date: 10/21/16 12:11 PM (GMT-08:00)
To: midrange-l@xxxxxxxxxxxx
Subject: Re: How do I add the member name to an SQL request for multi membered PF?

Couple of thoughts/questions:

1) An ALIAS sticks around, Right?
CREATE ALIAs UPPENWORK/D001_A FOR UPPENWORK/D001STMTM1(DAC0008)
So you probably also would want do DROP ALIAs UPPENWORK/D001_A

2) What about using QTEMP so the alias goes away at end of job?
CREATE ALIAs QTEMP/D001_A FOR UPPENWORK/D001STMTM1(DAC0008)

Sam

On 10/21/2016 10:36 AM, Steinmetz, Paul wrote:

The OVRDBF FILE(D001STMTM1) TOFILE(UPPENWORK/D001STMTM1) MBR(DAC0008) worked.
I will try the Alias next.

Paul

--
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.

Please contact support@xxxxxxxxxxxx for any subscription related questions.