SEO

#1 (**permalink**) 02-26-2008, 02:42 PM

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'

#2 (**permalink**) 02-26-2008, 02:43 PM

In article <5597693c.0309050910.37a97866@posting.google.com >,
Jay Mills <millsjay@aol.com> 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'

This will give you the first 4 characters of the Dataset name of the PDS
which contained the DBRM that was used to do the bind for the program.

Not sure what use that will be?

Ahah - are you after the DB2 Subsystem name to which you are connected?

If so, your method might work, but only if the naming convention was that
the first 4 chars of the DBRM library happened to start in the subsystem
name. There must be a better way, but I cannot think of it at the moment!

Martin

--
Martin Avison

#3 (**permalink**) 02-26-2008, 02:43 PM

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'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

MVS/DB2 From an application program, How to get the DSN SYSTEM NAME?