SQL names :vs: SYSTEM names
Posted on 2008-10-22
According to DOCs for AS400 iSeries SQL R5V3 - when creating an object (like a Proc, Table, View, etc) ...
If SQL names are used, procedures are created with the system authority of
*EXCLUDE on *PUBLIC. If system names are used, procedures are created
with the authority to *PUBLIC as determined by the create authority
(CRTAUT) parameter of the schema.
Here is a CREATE PROC sample which "apparently" uses "SQL NAMES" ... I know this because ... it's created with *EXCLUDE on *PUBLIC
-- Generate SQL
-- Version: V5R3M0 040528
-- Generated on: 10/22/08 11:30:50
-- Relational Database: STEEL
-- Standards Option: DB2 UDB iSeries
SET PATH "QSYS","QSYS2","CISFGV" ;
CREATE PROCEDURE MYSCHEMA.MYPROC ( )
DYNAMIC RESULT SETS 1
MODIFIES SQL DATA
CALLED ON NULL INPUT
P1 : BEGIN
DECLARE C1 CURSOR FOR SELECT * FROM MYSCHEMA.MYTABLE
OPEN C1 ;
END P1 ;
So can somone give an example where SYSTEM NAMES are used?