View Single Post

   
  #3 (permalink)  
Old 02-26-2008, 02:43 PM
Bill
 
Posts: n/a
Default Re: MVS/DB2 From an application program, How to get the DSN SYSTEMNAME?

How about

SELECT CURRENT SERVER

Bill



Jay Mills wrote:

> Is there a more elegant / direct method of find out the DSN SYSTEM NAME
> in an application program on the mainframe?
>
> SELECT SUBSTR(PDSNAME,1,4)
> FROM SYSIBM.SYSDBRM
> WHERE NAME= 'DSNTIAD'


Reply With Quote