I've spent the vast majority of the last 3-4 weeks translating stored procedures from Oracle to DB2, Oracle to SQL Server, and back again, etc. etc. etc. and so on and so forth ;-)
I have a couple of observations:
1 - Oracle PL/SQL is a very clean and easy to read language.
2 - MS SQL Server's T/SQL is powerful and modern and easy
3 - DB2's PL/SQL is, well, my grandmother always taught me that if I didn't have anything nice to say I should just not say anything at all.
I'll post some more useful notes in the coming days. For now, I wanted to say, very clearly, that I have spent an inordinate amount of my time on the DB2 portions of this. Sort of sad. I fear IBM is neglecting this flagship product ...
Subscribe to:
Post Comments (Atom)
DBT-50000 when using DBCA.bat on Windows (Oracle 19.11)
I’ve been having some trouble getting DBCA to run in order to create databases. Thought I’d share it with you, and thus document it for la...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
I was not able to find what I considered a good, clear reference for this when I recently encountered it at a customer installation. I fou...
-
I spent a lot of time on this one, and it wasn't clear from examples precisely how the various items should be used together. The form...
No comments:
Post a Comment