There are 2 reasons why the separator between Schema and Object can be
either . or / in SQL naming:
1. If you want to call a qualified UDF in an SELECT-Statement like this
SELECT YOURSCHEMA/YOURUDF the slash is interpreted as DIVIDE. So it was not
possible to call a qualified UDF with SYS* Naming
2. If you want to run the same SQL Script with System and SQL Naming you
always had to replace the Slash by a period (and the inverse)
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of John R.
Smith, Jr.
Sent: Mittwoch, 29. November 2017 00:15
To: 'RPG programming on the IBM i (AS/400 and iSeries)'
<rpg400-l@xxxxxxxxxxxx>
Subject: RE: SQL with connections to multiple databases
When I look at the documentation, it shows both will work for *SYS but only
shows the period for *SQL. Is the documentation wrong for *SQL?
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck
Calabro
Sent: Tuesday, November 28, 2017 6:03 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
<rpg400-l@xxxxxxxxxxxx>
Subject: Re: SQL with connections to multiple databases
On 28 November 2017 at 17:16, John R. Smith, Jr.
<smith5646midrange@xxxxxxxxx> wrote:
I thought about the *SYS vs *SQL but wouldn't an update library1/file1
fail?
Wouldn't it have to be update library1.file1 (period instead of slash
separating)? When I hardcoded the library, I used library1/file1 and
it worked.
The database manager has allowed either a slash or a dot as the separator
for several releases now.
SQL vs SYS isn't about the separator so much as it is about *LIBL vs USERID.
--buck
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-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 is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-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
midrange.com
