SQL Tips for DB2 LUW

with Tags: local

Featured Blog Entries

All posts

DB2 10: Using locally defined types and procedures

Visits (20986)

Introduction Recently I discussed the motivation behind using anonymous blocks. The reasoning was centered around the need to execute complex scripts on the server without being able or willing to define a routine in the database's catalog. Inside of an anonymous block you can then define all the logic flow you need. You can also declare local variables to hold temporary data. DB2 10 expands beyond that by allowing you to declare local types and local procedures. Local types When ARRAY types were introduced in DB2 9.5 we discussed whether there... [More]

Tags: local sql type procedure pl anonymous declared nested functionsubprogram routine blocks

DB2 10: Making the move from Oracle even easier

Comments (2) Visits (10962)

The DB2 for LUW team has been busily driving down the cost of enabling Oracle applications since that effort started with DB2 9.7. Every DB2 9.7 fixpack up to DB2 9.7.5 has contained features to incrementally increase the level of compatibility allowing users to break free of Oracle. Now, finally it's time to unleash DB2 10 with yet another set of goodies. Here are some: Local Types This feature allows PL/SQL and SQL PL blocks to locally declare types for consumption in variables within the BEGIN .. END block. Previously when such type... [More]

Tags: compatible local application pl/sql what's type new oracle procedure subprogram db2 10 db2_compatibility_vector performance

Blogs

SQL Tips for DB2 LUW

About this blog

Links

Tags

Recent tweets

DB2 10: Using locally defined types and procedures

DB2 10: Making the move from Oracle even easier