<snip>
Also they list this: Allow period separator for qualification of objects
in system naming. What does this new feature mean exactly?
</snip>
As stated in the reply
http://archive.midrange.com/midrange-l/201507/msg00575.html
Prior to this PTF to 7.1 (which came out in base 7.2) when you specified
*SYS vs *SQL in many SQL commands (like CRTSQLRPGI, RUNSQLSTM, etc) you
would specify
library/file
While, if you specified *SQL instead of *SYS you specified
schema.table
The big difference being the slash versus the period.
However, with the advent of 7.2 (and the fixing PTF for 7.1)
You could still say *SYS and use the period as in schema.table versus
using the slash as in library/file.
Now, the only difference between *SYS and *SQL is that when you do not
qualify a table (like schema.table or library/file) when you use *SYS it
will use the library list while *SQL will use the default schema.
Let's assume you're current on OS and PTF's.
From a 5250 session.
STRSQL
F13=Services
1. Change session attributes
Naming convention . . . . . . *SYS
SELECT * FROM QSYS2.LIBRARY_LIST_INFO
ORDINAL_POSITION SCHEMA_NAME
1 QSYS
2 QSYS2
3 QHLPSYS
4 QUSRSYS
5 QSQL
6 QGPL
7 QTEMP
CREATE TABLE HOKEYPOKEY(MYINT INT NOT NULL WITH DEFAULT)
Table HOKEYPOKEY in QGPL created but was not journaled.
DROP TABLE ROB.HOKEYPOKEY
HOKEYPOKEY in ROB type *FILE not found.
Notice that I didn't specify any schema in the create table and it put it
into QGPL?
Notice that I didn't specify any schema in the drop table and it tried to
drop it from ROB? Which isn't in the library list?
DROP TABLE QGPL/HOKEYPOKEY
Drop of HOKEYPOKEY in QGPL complete.
F13=Services
1. Change session attributes
Naming convention . . . . . . *SQL
CREATE TABLE HOKEYPOKEY(MYINT INT NOT NULL WITH DEFAULT)
Table HOKEYPOKEY in ROB created but was not journaled.
DROP TABLE HOKEYPOKEY
Drop of HOKEYPOKEY in ROB complete.
So, while 7.2 and this 7.1 ptf, allow you to pretty much interchangeably
use the slash or the period regardless of *SYS or *SQL, there are still
some differences in how *SQL or *SYS operate.
Understand?
See also
*SQL
VALUES CURRENT SCHEMA
retrieves ROB
*SYS
VALUES CURRENT SCHEMA
retrieves *LIBL
Now if I run
set schema qgpl
VALUES CURRENT SCHEMA
will retrieve QGPL instead of *LIBL
From Infocenter:
<snip>
If system names were specified, the table will be created in the schema
that is specified by the qualifier. If not qualified:
If the value of the CURRENT SCHEMA special register is *LIBL, the
table will be created in the current library (*CURLIB).
Otherwise, the table will be created in the current schema.
</snip>
Rob Berendt
midrange.com
