Skip to main content

Uniface 9: Get database name from path

  • November 19, 2018
  • 3 replies
  • 0 views
Jan Cees Boogaard

Get database name from path

Author: jason_zuvela@yahoo.com (jasonzuvela)

hi hi

Is there any way to retrieve the database name from a path entry in the ASN file?

So far I have only found $user and $password, but they don't help me at all. The only options I can see now are either setting a logical or saving it somewhere in the database. Though, this is quite redundant, after the database connection has already been setup.

Thanks

3 replies

Jan Cees Boogaard

Get database name from path

Author: jason_zuvela@yahoo.com (jasonzuvela)

hi hi

Is there any way to retrieve the database name from a path entry in the ASN file?

So far I have only found $user and $password, but they don't help me at all. The only options I can see now are either setting a logical or saving it somewhere in the database. Though, this is quite redundant, after the database connection has already been setup.

Thanks

Hi Jason,

as you may know, there are a lot of redirections possible in an ASN file.

More if you use UROUTER and other remote dataaccesses.

So I recommend to have a common table like "DB_PROPERTIES"
in each of your databases allowing the storage of key-value pairs.
 

sql "select .... from DB_PROPERTIES","$mydbpath"
get infos from each of your databases denoted by $mydbpath.

This way, the information is stored within the database no matter how often you redirect paths in the ASN.

I used this during a testing phase of a new application
to distinguish between test-data and production database.

Success, Uli


Author: ulrich-merkel (ulrichmerkel@web.de)
Jan Cees Boogaard

Get database name from path

Author: jason_zuvela@yahoo.com (jasonzuvela)

hi hi

Is there any way to retrieve the database name from a path entry in the ASN file?

So far I have only found $user and $password, but they don't help me at all. The only options I can see now are either setting a logical or saving it somewhere in the database. Though, this is quite redundant, after the database connection has already been setup.

Thanks

Not sure if this is helpful ...

Oracle database, assuming correct permissions on systables ...

sql "select NAME from sys.v_$DATABASE", "DEF"

will give you the database name. Other databases might have similar functions

 


Author: Rick Scally (rickscally@aol.com)
Jan Cees Boogaard

Get database name from path

Author: jason_zuvela@yahoo.com (jasonzuvela)

hi hi

Is there any way to retrieve the database name from a path entry in the ASN file?

So far I have only found $user and $password, but they don't help me at all. The only options I can see now are either setting a logical or saving it somewhere in the database. Though, this is quite redundant, after the database connection has already been setup.

Thanks

Hi Rick

Are you sure about "v_$DATABASE", should it not be "V$DATABASE" ?

For MSS, the sql statement is "SELECT DB_NAME()"

Ingo

 


Author: istiller (i2stiller@gmx.de)

Recent badge winners

Explore all badges
Terms & ConditionsAccessibility statement