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