| I believe your best source of information would be in the VAX SQL
manual where we compare Rdb to DB2. Since Oracle is closely aligned
with DB2, this would serve as a quick starting point. For a more
detailed study, you need Oracle manuals.
I have a SQL*Plus manual which I could send your way if you would
copy it and send it back since I use it about every week. Be aware
that SQL*Plus is similar to our interactive VAX SQL except that
SQL*plus contains a ton of proprietary extensions. Any conversion
effort would have to include SQL*plus command files (like DCL .COM
files). SQL*plus is used widely for simple ad hoc queries and quick
and dirty dba work.
For 3gl programs, I have a Pro*C user guide for loan as well. It
probably is not appropriate to assume that a customer's 3gl code
would have only SQL statements. There are bound to be those customers
who have written their code using the HLI (high language interface).
When using the HLI method, your 3gl program would include numerous
calls to Oracle routines. Think of HLI like writing a program using
DSRI calls.... pretty wild stuff. If you run across an ISV who
has a lot of experience with Oracle, I would expect you to encounter
HLI more frequently than with a customer with just a couple of years
experience.
Oracle 3gl programs which do use SQL statements should map nicely.
For SQL*forms, I assume you are aware of Trifox on the west coast.
-- gerry duncan
|