For people who want to automate Linux shell script or Windows batch file to send authenticated email (not by email relay method), you’ll love this open-source, command-line smtp email client.
Let’s use the fprintf() function to dump debugging info to error log file!
However, not C implementation includes a command processor for executing other program.
After learning how to build DB2 external UDF in the previous post, now let’s see how to make the user-defined function writing debugging info to your own application log file (not the DB2 system log file).
The IBM DB2 allows one to create external user-defined function (UDF) in few of the popular programming languages. In this tutorial, however, the focus is on using C Language to build an external scalar function that convert UNIX epoch time to calendar date.
To make thing perfect, we decided to build an external scalar function in C programming language for this subject.
However, administrator and developer can create a SQL scalar function (UDF, shorts for user-defined function) to get this job done.