Kbase 18363: Why Does Apptivity Auto-Qualify Tablenames With Usernames?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FIX:
Apptivity auto-qualifies tablenames with usernames when using an ORACLE database. When creating a new datasource using a SQL statement like "select * from emp", this appears in the .qry file as "select * from scott.emp", where "scott" is a user of the database.
Apptivity also qualifies tables for some databases (for example, DB2, Informix (nonANSI), Oracle) with the owner names because these databases allow multiple tables with the same names as long as they are created by different users. The creator of a table is the table's owner.
If the development and deployment databases are different, you can:
1) manually modify the query file (.qry) AFTER deployment, or
2) regenerate the queries in the IDE against the deployment database just before deployment.