Kbase P9967: How to retrieve connection information and more for a connected a Database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to know the connection parameters of a connected a Database?
GOAL:
How to retrieve -H -S -N used for a connected a Database?
GOAL:
How to retrieve the connection phrase of a connected a Database?
GOAL:
How to know the logical name of a connected a Database?
GOAL:
How to know the physical name of a connected a Database?
GOAL:
How to know the database type of a connected a Database?
GOAL:
How to know the version of a connected a Database?
GOAL:
How to know the database restrictions of a connected a Database?
GOAL:
How to know the schema holder database of a connected a Database?
GOAL:
How to know the collation used for a connected a Database?
GOAL:
How to know the codepage used for a connected a Database?
FIX:
DEFINE VARIABLE i AS INTEGER NO-UNDO.
DO i = 1 TO NUM-DBS:
MESSAGE LDBNAME(i) SKIP PDBNAME(i)
SKIP DBPARAM(i) /* the all connection phrase -S -H -N ...*/
SKIP DBTYPE(i) SKIP DBVERSION(i) SKIP DBRESTRICTION(i)
SKIP SDBNAME(i) SKIP DBCOLLATION(i) SKIP DBCODEPAGE(i)
VIEW-AS ALERT-BOX INFO BUTTONS OK.
END.