Hi,
Is there any other way to display value of "CURRENT USER" than
using SELECT from sysibm.sysdummy1


Can we use ECHO in our scripts some how ?


Please Help

DBFinder

Try "VALUES CURRENT USER"

Andy

Well, you are right,
that is for Dynamic SQL.

I was looking for source of retrieval of SPECIAL Register values. So that I can print in simple BAT file.

Thanks Anyway.

DBFinder

A "special register" is a SQL construct, a SQL expression. Thus, you have to use SQL mechanisms to evaluate the expression and retrieve the value. So what's wrong with using the VALUES statement that Andy mentioned?

If you just need to get the user who is executing your batch file, you have to look at Windows mechanisms - not at DB2.