|
View previous topic :: View next topic
|
| Author |
Message |
Akil
New User
Joined: 24 Oct 2023
Posts: 22
Location: India
|
|
|
|
Hi,
When I give DDL for a view from RC query,I see:
SET PATH ='SYSIBM','SYSFUN','SYSPROC','SYSIBMADM',
in the very first line before view statement.What does this mean?why do these populate in view definition? |
|
| Back to top |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
|
|
RTFM:
| Quote: |
SET PATH
The SET PATH statement assigns a value to the CURRENT PATH special register.
Invocation
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.
Authorization
None required. |
|
|
| Back to top |
|
|
Akil
New User
Joined: 24 Oct 2023
Posts: 22
Location: India
|
|
|
|
But I did not issue/include this set path statement anywhere when I created the view from spufi.
Why does it show these statments ,even though I have not declared /used it during view creation?
How & from where these values-"SYSIBM*" are picked up? and why does it show just "SYSIBM* keywords" something strange |
|
| Back to top |
|
|
|
|
