News
Abstract
The REPLACE() scalar function has been enhanced.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 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"}}]
Was this topic helpful?
Document Information
Modified date:
13 January 2020
UID
ibm11163836