S
Sean John
Guest
Our company used to use Oracle system but recently decided to move to Apprise (7.5), which uses Progress OpenEdge 11.1. I checked 11.1 is kind of old but we have NO control. Apprise installs OpenEdge into 3 machines, I was told 2 are application servers and one is the RDBMS? I looked into the installation, there is no easy way to tell which machine installs database, which one is the application server , most menus like "Database Administration Console" are identical in all 3 servers. I did find 11.1 documentation and read some of them, to me , it's not easy to get started with Progress , I hope some one could enlighten me on some of the basics of progress: 1. where to find ad-hoc SQL query tools? such as "mysql" in Mysql and "sql*plus" in Oracle? 2. Database Administration Console is like Sql*server's Enterprise manager? but it doesn't allow me to create a physical database. 3. I assume ABL to progress is PL/sql to Oracle? PL/sql can run inside RDBMS and Application server Forms services ( can be different version but mostly the same). Does ABL run inside the database? why is Application server required ? To practice I downloaded OpenEdge 11.6 and installed on windows server (both RDBMS and Studio), but I can't find an easy way to play with data like other database systems ( i.e, like Oracle I'll have sql*plus and it tells me some users like scott/tiger to select sample table right away). Please enlighten me the proper way to get started with Progress and become a progress programmer ( Apprise has all API in .r files) , thank you. Sean
Continue reading...
Continue reading...