I believe you are referring to three part name support. It's not the system name, it's whatever the relational database directory entry is called, so it's rdbdire.schema.table.
Here is a developerworks article from 2013
https://tinyurl.com/y6vby824
Coy Krill
Core Processing Administrator/Analyst
Washington Trust Bank
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of a4g atl
Sent: 2017 July 10 12:41
To: midrange-l@xxxxxxxxxxxx
Subject: Help with reading SQL tables from multiple systems
Importance: Low
IBM added the ability to include the system (connect) name to the database name but I do not remember how to format the statement. Google is not my friend today.
I think it is [system_name].[schema_name].table_name example:
Select * from system_1.library_a.table_A;
Which releases did this apply to?
TIA
Darryl Freinkel
--
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.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
---------------------------------------------------------------------
This electronic mail message and any attachments may contain confidential or privileged information and is intended for use solely by the above-referenced recipient. Any review, copying, printing, disclosure, distribution, or other use by any other person or entity is strictly prohibited under applicable law. If you are not the named recipient, or believe you have received this message in error, please immediately notify the sender by replying to this message and delete the copy you received
---------------------------------------------------------------------
midrange.com
