SQL Queries - CAST Knowledge Base - Queries on objects - How to get the source path of an object

Purpose of Query

The query returns the source path of a given object

Applicable CAST Version

Release	Yes/No
8.3.x	✅
8.2.x	✅
8.1.x	✅
8.0.x	✅

Applicable RDBMS

RDBMS	Yes/No
Oracle Server	✅
Microsoft SQL Server	✅
CSS2	✅

Query for CSS

SELECT refp.path
FROM   objfulnam ful
       JOIN objfilref obj
         ON ful.idobj = obj.idobj
       JOIN refpath refp
         ON refp.idfilref = obj.idfilref
WHERE  ful.fullname = <'Full name'>

Query result example

“C:\CASTMS\Deploy\TESTAPP\oracle\VASTCreateTable.3.src”

Query result interpretation

The query returns the source path of the object

Query for Oracle

SELECT refp.path
FROM   objfulnam ful
       JOIN objfilref obj
         ON ful.idobj = obj.idobj
       JOIN refpath refp
         ON refp.idfilref = obj.idfilref
WHERE  ful.fullname = <'Full name'>

Query result example

“C:\CASTMS\Deploy\TESTAPP\oracle\VASTCreateTable.3.src”

Query result interpretation

The query returns the source path of the object

Query for SQL server

SELECT refp.path
FROM   objfulnam ful
       JOIN objfilref obj
         ON ful.idobj = obj.idobj
       JOIN refpath refp
         ON refp.idfilref = obj.idfilref
WHERE  ful.fullname = <'Full name'>

Query result example

“C:\CASTMS\Deploy\TESTAPP\oracle\VASTCreateTable.3.src”

Query result interpretation

The query returns the source path of the object

Notes/comments

Related Pages