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

I specify *SYS naming in order to use the library list and still use the
'.' notation for library.file, or as some might write, schema.table


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (905) 486-1162 x 239
Cell: (416) 317-3144


On 21 October 2016 at 11:31, Rob Berendt <rob@xxxxxxxxx> wrote:

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/

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


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