Re: Using CONNECT to a remote system with RUNSQLSTM

On Tue, Jul 28, 2015 at 11:06 AM, <rob@xxxxxxxxx> wrote:

Which rather surprised me as how it could use *SYS naming
and create a table called rob.scrapme. Maybe, once it saw the three part
naming it said to hell with with *SYS naming? Because if I change it to
... table rob/scrapme ...
and still use *sys it works also. Did they deprecate NAMING(...) and use
some intelligence instead?

What happens here is that the System naming convention (*SYS) was expanded
to allow either the dot(.) or the slash (/) for name qualification (?).
Doesn't work the other way around, though (using / with *SQL naming)

There is a wonderfully long IBM URL for that:
https://www.ibm.com/developerworks/community/wikis/home?lang
=en#!/wiki/IBM%20i%20Technology%20Updates/page/System%20naming%20convention%20expanded%20to%20permit%20%28slash%29%20and%20%28dot%29%20qualifiers

And a really nice and short TinyURL :


*http://tinyurl.com/nl5lfrh*
Best Regards,


Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--