DB2 for i 7.2 TR3 and 7.1 TR11 Features
May 17, 2016 Michael Sansoterra
I was writing up some exciting stuff on the new IBM i 7.3 features when I realized I never finished reporting about other recent DB2 features! Below are highlights of some newer features offered starting in DB2 for i 7.2 TR3 and 7.1 TR11.
Assign A System Name To A Global Variable
Recall that when you create a global variable, behind the scenes SQL Server implements the variable’s logic and value retrieval logic as a service program. The following variable definition with a long name (>10 characters):
CREATE OR REPLACE VARIABLE DEV.AVENGERS_TOWER VARCHAR(32) DEFAULT (SELECT ADDRESS FROM DEV.HERO WHERE