Kbase P170255: Is there a utility to find what Datasources refer to a particular database?
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  7/21/2010 |
|
Status: Unverified
GOAL:
Is there a utility to find what Datasources refer to a particular database?
GOAL:
How to list details of all DXRE Datasources?
FACT(s) (Environment):
All Supported Operating Systems
Windows
DataXtend RE
FIX:
There is no specific tool to make inquiries of all datasources on a system to see which ones refer to a specific database.
The tool pddsn has serveral functions which can help with this task.
pddsn /MATCH <dbname>
pddsn /M <dbname>
Can look for string matches of a database name. It stops at the first reference it finds even if it is not an exact match. It stops at the first datasource even if there are other datasources that exist on the system.
A better option to use is:
pddsn /DETAILEDLIST all
pddsl /DET all
This will output a text list of all datasources on a system with details information for all.
The database=<dbname> reference is listed in this detailed listing.