×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
midrange.com
