IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SET PATH in View DDL


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Akil

New User


Joined: 24 Oct 2023
Posts: 22
Location: India

PostPosted: Wed Oct 25, 2023 11:25 pm
Reply with quote

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
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1999
Location: USA

PostPosted: Wed Oct 25, 2023 11:43 pm
Reply with quote

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
View user's profile Send private message
Akil

New User


Joined: 24 Oct 2023
Posts: 22
Location: India

PostPosted: Wed Oct 25, 2023 11:49 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts Issues with VIEW DATASET Command CLIST & REXX 2
No new posts Difference when accessing dataset in ... JCL & VSAM 7
No new posts How to filter PDS member using LMINIT... CLIST & REXX 4
No new posts View GDG data which is copied from a ... JCL & VSAM 2
Search our Forums:

Back to Top