Uppercase in one line

[worksofliam]

I've just seen this blog post and I do only have a two issues with it:

• For code that's written in 2016, it's still in fixed format.
• It's so much code just to do an upper case that supports multiple CCSIDs.

In this small blog, I'm going to show you how to do 'uppercase' in one line of code - using Embedded SQL.

Dcl-S CharField Char(100);

CharField = 'hello db2 summit!';

EXEC SQL SET :CharField = UPPER(:CharField);

..and that's it.

[JDubbTX]

Should probably mention this too: https://www.ibm.com/support/pages/rpg-cafe-new-built-ins-lower-upper-and-split