Kbase 22090: Using SQL-92 to Determine if conv89 Was Used
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/06/2002 |
|
SUMMARY:
When troubleshooting issues with a Progress 9.x database, it is helpful to know if the database is originally a 9.x database or a converted Progress 8.x database. This is particularly useful information to have when just starting to use SQL-92.
EXPLANATION:
In some cases, a user may not know if their existing Progress 9.x database was converted via proutil conv89. One quick way to tell is to use the following command via the SQLExplorer:
select * from sysprogress.sysdbauth
A database or database structure created with Progress 9.x will return two users, "sysprogress" and the database creator. A database which was converted using the proutil conv89 command will only show "sysprogress".
References To Written Documentation:
Progress Knowledge Base Solution, 20143 "Basic Guide to Defining Progress SQL-92 Database Security"