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 (tick) 
8.2.x (tick) 
8.1.x (tick) 
8.0.x (tick) 
Applicable RDBMS

 

RDBMS
Yes/No
Oracle Server (tick) 
Microsoft SQL Server (tick) 
CSS2 (tick) 


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