Uppercase in one line - Githubissues

worksofliam / blog

Blog

28 stars 5 forks source link

Uppercase in one line #8

Open worksofliam opened 5 years ago

worksofliam commented 5 years ago

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 commented 9 months ago

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