IBM Support

Enhanced REPLACE() scalar built-in function



The REPLACE() scalar function has been enhanced.


You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > Enhanced REPLACE() scalar built-in function
The third argument of the REPLACE function, which specifies the new replacement string, is now optional.
See the SQL Reference for details: REPLACE scalar function

Enhanced with IBM i 7.3 SF99703 Level 3 and IBM i 7.2 SF99702 Level 14
  • Changed the 3rd parameter to be optional

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
13 January 2020