![DB2 and SQL. Agenda: –Why use SQL? –Rewrite OPNQRYF Example –DB2 Built In Functions –Miscellaneous SQL Examples. –Visual Explan Example. - ppt download DB2 and SQL. Agenda: –Why use SQL? –Rewrite OPNQRYF Example –DB2 Built In Functions –Miscellaneous SQL Examples. –Visual Explan Example. - ppt download](https://images.slideplayer.com/18/6103755/slides/slide_31.jpg)
DB2 and SQL. Agenda: –Why use SQL? –Rewrite OPNQRYF Example –DB2 Built In Functions –Miscellaneous SQL Examples. –Visual Explan Example. - ppt download
![IBM i, AS400 Tutorial -Usage of OPTIONS(*TRIM) with CONST and VALUE - Parameter passing in ILE RPG - YouTube IBM i, AS400 Tutorial -Usage of OPTIONS(*TRIM) with CONST and VALUE - Parameter passing in ILE RPG - YouTube](https://i.ytimg.com/vi/q8NIjrRoa6Q/maxresdefault.jpg)
IBM i, AS400 Tutorial -Usage of OPTIONS(*TRIM) with CONST and VALUE - Parameter passing in ILE RPG - YouTube
![Example RPG Email Validation Program - SQLRPGLE ILE » Nick Litten [IBM I AS400 ISeries] Software Developer Example RPG Email Validation Program - SQLRPGLE ILE » Nick Litten [IBM I AS400 ISeries] Software Developer](https://www.nicklitten.com/wp-content/uploads/as400-regex-to-validate-bad-email.png)
Example RPG Email Validation Program - SQLRPGLE ILE » Nick Litten [IBM I AS400 ISeries] Software Developer
![IBM i, AS400 Tutorial, iSeries, System i -Trim function in CL|%TRIM,%TRIML,%TRIMR with optional parm - YouTube IBM i, AS400 Tutorial, iSeries, System i -Trim function in CL|%TRIM,%TRIML,%TRIMR with optional parm - YouTube](https://i.ytimg.com/vi/jymx0cVWmj4/maxresdefault.jpg)
IBM i, AS400 Tutorial, iSeries, System i -Trim function in CL|%TRIM,%TRIML,%TRIMR with optional parm - YouTube
![Using string functions: SUBSTR(), TRIM(), UPPER(), LOWER() — A Gentle Introduction to SQL 0.0.1 documentation Using string functions: SUBSTR(), TRIM(), UPPER(), LOWER() — A Gentle Introduction to SQL 0.0.1 documentation](https://a-gentle-introduction-to-sql.readthedocs.io/en/latest/_images/select_substr.png)