User-defined scalar functions (UDFs) on IBM DB2 for i SQL

User-defined scalar functions (UDFs) on IBM DB2 for i SQL

Create SQL scalar User defined function (UDFs) on IBM DB2 for i SQL 2021 explain about creating Scalar SQL udf.

Create DB2 SQL UDF - SQL Scalar UDF in AS400 - SQL UDF check ODD or EVEN number -Create SQL UDF using RUNSQLSTM will explain about SQL scalar function in Db2. how to execute SQL function from within SQL statement.
Created first SQL function ODDEVEN to check if a number is ODD or EVEN.
Create RUNSQLSTM command to create SQL function.

#ibmi #as400 #rpgle
Using SQL UDF with RPGLE - Different ways to call UDF from RPGLE in AS400 will explain how to create SQL UDF using CREATE function command and different ways to execute the UDF from RPGLE.

DB2 Overloaded UDF function in IBM i AS400 create multiple function with same name in same schema

Create DB2 SQL UDTF in IBM i AS400 - Pipelined UDTF - Creating SQL UDTF using RUNSQLSTM

Create DB2 SQL UDTF in AS400 IBM i - Non pipelined UDTF -Create SQL UDTF using RUNSQLSTM

Create DB2 SQL UDF - SQL Scalar udf function in AS400 -Check ODD EVEN-Create SQL UDF using RUNSQLSTM

Using DB2 SQL UDF with RPGLE - Different ways to call UDF from RPGLE in AS400

You can also watch other AS400 Training related playlist as follows:

My Easy Classes is the YouTube channel which aims to provide the coding videos on RPG, CL, SQLRPGLE and SQL DB2.