Deliver Awesome UI with the most complete toolboxes for .NET, Web and Mobile development
Automate UI, load and performance testing for web, desktop and mobile
A complete cloud platform for an app or your entire digital business
Detect and predict anomalies by automating machine learning to achieve higher asset uptime and maximized yield
Automate decision processes with a no-code business rules engine
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premises data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
Personalize and optimize the customer experience across digital touchpoints
Build, protect and deploy apps across any platform and mobile device
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Sorry for asking such a basic question, but I'm running out of time.
I have some financial software that has bounced itself around servers for many years. From the looks of it, the last time data was entered was around 2006. All employees that knew anything about it (eg logon credentials) are long gone. However, I need to extract data from it before disposing of the server.
The database is Progress 9.1E
I can successfully connect and run ABL queries and use the progress tools to view data dictionaries etc. I have followed the knowledge base articles and created a new user, set them to be a DBA, and logged in with sql explorer as that user.
The table I want to use (as a test) is called ca-detail. I am logged in with the tmladmin2 account
I have the following output (formatted) from sql explorer.
select * from sysprogress.systables where TBL='ca-detail';
ID TBL CREATOR OWNER TBLTYPE
107 ca-detail PUB PUB T
SEGID HAS_PCNSTRS HAS_FCNSTRS HAS_CCNSTRS HAS_UCNSTRS TBL_STATUS RSSID
0 N N N N Y 5
select * from sysprogress.sysdbauth
GRANTEE DBA_ACC RES_ACC -------------------------------- ------- ------- Administrator y y SYSPROGRESS y y tmladmin y tmladmin2 y y
select * from pub.ca-detail;
=== SQL Exception 1 ===SQLState=42S02ErrorCode=-20005[JDBC Progress Driver]:Table/View/Synonym not found (7519)
Can some one help me fix the missing bit?
How about: select * from PUB."ca-detail";
You are kidding me. That worked.
All the tables created via ABL will be in PUB schema. Hence, if you want to access them via OE SQL, we should prefix table names with "PUB".