The OVRDBF FILE(D001STMTM1) TOFILE(UPPENWORK/D001STMTM1) MBR(DAC0008) worked.
I will try the Alias next.
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Friday, October 21, 2016 11:31 AM
To: Midrange Systems Technical Discussion
Subject: Re: How do I add the member name to an SQL request for multi membered PF?
Well, IBM shareholders would like you to purchase "DB2 Multisystem" At the cost of that product, even spread out amongst all shareholders, they can tell. <sarcasm intended>
Failing that, I believe you still have to do one of two things:
One: OVRDBF. Yes, this can be put into Run SQL Scripts with the CL option.
Two: CREATE ALIAS. Look that up. You'll figure that out.
I've gotten out of the habit of using *SYS naming and have gone more to *SQL naming. Namely because I tend to prefer the dotted naming vs the slash naming. That, and when you do inter system stuff systemname.library.table makes more sense. Granted, there are library list considerations...
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 10/21/2016 11:23 AM
Subject: How do I add the member name to an SQL request for multi
membered PF?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
How do I add the member name to an SQL request for multi membered PF?
SELECT 'UPPENwork' as Lib, 'D001STMTM1' as File, GOBGT1, count(*)
as Count FROM UPpenwork/D001STMTM1 GROUP BY GOBGT1 ORDER BY GOBGT1
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx
http://www.pencor.com/
midrange.com
