What is new in DB2 V10? (Part-1)

I am writing what DB2 did more in V10. Developer has to focus more on performance, and logic for any type of business scenario.

  1. IBM did some changes in Create Trigger functionality:

More flexible and function-rich CREATE TRIGGER support. The trigger-event clause can now contain more than one INSERT, UPDATE, or DELETE operation, which means that a trigger can be activated by any combination of specified events. Although you can specify one, two, or all three trigger events in a single CREATE TRIGGER statement, a trigger event cannot be specified more than once. You can also use the new trigger event predicates (INSERTING, UPDATING, and DELETING) in a triggered action to test the event that activated a trigger. A trigger event predicate is only valid in the triggered action of a compiled trigger definition. And finally, the FOR EACH STATEMENT option is now supported in the CREATE TRIGGER statement for PL/SQL triggers. You can create triggers that fire only once per statement.(Source : IBM)

2. Added new scalar functions:INSTRB – Returns starting position in bytes. TO_SINGLE_BYTE – Returns string in which multi-byte chars are converted into single byte char.


Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.