I am a former Oracle DBA and I am very comfortable with PL/SQL. I wonder whether there would be any improvement if I used the DB2 native
language?
The two seem to be very similar, but I wonder what would I achieve by learning another programming language? I was unable to find anything definitive on the Interner.
I am a former Oracle DBA and I am very comfortable with PL/SQL. I wonder whether there would be any improvement if I used the DB2 native language?
The two seem to be very similar, but I wonder what would I achieve by learning another programming language? I was unable to find anything definitive on the Interner.
On 22-03-17 19:53, Mladen Gogala wrote:
I am a former Oracle DBA and I am very comfortable with PL/SQL. IOracle, or DB2, are no programming languages.
wonder whether there would be any improvement if I used the DB2 native
language?
The two seem to be very similar, but I wonder what would I achieve by
learning another programming language? I was unable to find anything
definitive on the Interner.
quoot from: https://en.wikipedia.org/wiki/PL/SQL PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is
available in Oracle Database (since version 6 - stored pl/sql procedures/functions/packages/triggers since version 7),
TimesTen in-memory database (since version 11.2.1),
*and IBM DB2 (since version 9.7).*
On Sat, 25 Mar 2017 20:20:48 +0100, luuk@invalid.lan wrote:
On 22-03-17 19:53, Mladen Gogala wrote:
I am a former Oracle DBA and I am very comfortable with PL/SQL. IOracle, or DB2, are no programming languages.
wonder whether there would be any improvement if I used the DB2 native
language?
The two seem to be very similar, but I wonder what would I achieve by
learning another programming language? I was unable to find anything
definitive on the Interner.
quoot from: https://en.wikipedia.org/wiki/PL/SQL PL/SQL (Procedural
Language/Structured Query Language) is Oracle Corporation's procedural
extension for SQL and the Oracle relational database. PL/SQL is
available in Oracle Database (since version 6 - stored pl/sql
procedures/functions/packages/triggers since version 7),
TimesTen in-memory database (since version 11.2.1),
*and IBM DB2 (since version 9.7).*
Your reply is nitpicking about the notion of a programming language, but
it doesn't respond to my question: is there a performance price to pay
for programming functions, triggers and procedures in PL/SQL instead of
the native DB2 "procedural extensions". And yes, I know that DB2 supports Oracle dialect. I have even written how to activate that compatibility in
my post. That is not the question. The question is whether I'm paying a
price for using the compatibility or not.
On Sat, 25 Mar 2017 20:20:48 +0100, luuk@invalid.lan wrote:
On 22-03-17 19:53, Mladen Gogala wrote:
I am a former Oracle DBA and I am very comfortable with PL/SQL. IOracle, or DB2, are no programming languages.
wonder whether there would be any improvement if I used the DB2 native
language?
The two seem to be very similar, but I wonder what would I achieve by
learning another programming language? I was unable to find anything
definitive on the Interner.
quoot from: https://en.wikipedia.org/wiki/PL/SQL PL/SQL (Procedural
Language/Structured Query Language) is Oracle Corporation's procedural
extension for SQL and the Oracle relational database. PL/SQL is
available in Oracle Database (since version 6 - stored pl/sql
procedures/functions/packages/triggers since version 7),
TimesTen in-memory database (since version 11.2.1),
*and IBM DB2 (since version 9.7).*
Your reply is nitpicking about the notion of a programming language, but
it doesn't respond to my question: is there a performance price to pay
for programming functions, triggers and procedures in PL/SQL instead of
the native DB2 "procedural extensions". And yes, I know that DB2 supports Oracle dialect. I have even written how to activate that compatibility in
my post. That is not the question. The question is whether I'm paying a
price for using the compatibility or not.
On 26-03-17 03:35, Mladen Gogala wrote:
On Sat, 25 Mar 2017 20:20:48 +0100, luuk@invalid.lan wrote:
On 22-03-17 19:53, Mladen Gogala wrote:
I am a former Oracle DBA and I am very comfortable with PL/SQL. IOracle, or DB2, are no programming languages.
wonder whether there would be any improvement if I used the DB2 native >>> language?
The two seem to be very similar, but I wonder what would I achieve by
learning another programming language? I was unable to find anything
definitive on the Interner.
quoot from: https://en.wikipedia.org/wiki/PL/SQL PL/SQL (Procedural
Language/Structured Query Language) is Oracle Corporation's procedural
extension for SQL and the Oracle relational database. PL/SQL is
available in Oracle Database (since version 6 - stored pl/sql
procedures/functions/packages/triggers since version 7),
TimesTen in-memory database (since version 11.2.1),
*and IBM DB2 (since version 9.7).*
Your reply is nitpicking about the notion of a programming language, but
it doesn't respond to my question: is there a performance price to pay
for programming functions, triggers and procedures in PL/SQL instead of
the native DB2 "procedural extensions". And yes, I know that DB2 supports Oracle dialect. I have even written how to activate that compatibility in my post. That is not the question. The question is whether I'm paying a price for using the compatibility or not.
There's always `a` price someone has to pay for compatibility.
But in this case, because IBM/DB2 doens not have a product whuch is
comming close to Oracle/PLSQL (to my knowledge), this price should be minimal.
Always keep in mind that someting might work on DB2, and will not work
on Oracle, or the other way around ...
If you are lucky, and compatibility is GOOD, you will never hit that point.
I do not have enough exprience to claim that you will see (or not) any incompatabilities ...
I am a former Oracle DBA and I am very comfortable with PL/SQL. I wonder whether there would be any improvement if I used the DB2 native language? The two seem to be very similar, but I wonder what would I achieve by learning another programming language? I was unable to find anything definitive on the Interner.
--
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com
Yes, I agree.
Performance makes no big difference between PL/SQL and SQL/PL.
On the other hand the issues we found from 2009 to 2012 must have been corrected by now, at least most of them.
I should test it some day if find the time.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 300 |
Nodes: | 16 (2 / 14) |
Uptime: | 69:33:26 |
Calls: | 6,712 |
Files: | 12,244 |
Messages: | 5,356,703 |