If you are an IBM i / AS400 developer and use ODBC, you’ve possibly had a need to connect to the IBM i using ODBC with SSL. Well this last week I tried using SSL for the first time on Linux, Windows and MacOS. Each of them had their unique connectivity challenges. Check out the following links for info on how to possibly resolve your SSL issues: How to set up IBM i Access ODBC Driver for MacOS to use an SSL CertificateHow to set up IBM i Access ODBC Driver for Windows to use an SSL CertificateHow to set up IBM i Access ODBC Driver for Linux to use an SSL Certificate Read More
API QtmsCreateSendEmail (Create and Send MIME E-mail) RPG IV Sample
API QtmsCreateSendEmail (Create and Send MIME E-mail). This API became available with OS release V7R1. It caters for both creating the MIME note and sending it through SMTP.
https://www.ibm.com/docs/en/i/7.5?topic=ssw_ibm_i_75/apis/qtmscreatesendemail.html
This article is presenting a simple use case of sending an email to one user.
The sample is written in RPG IV language and assumes the prerequisites which are documented in the API have all been implemented.
The sample is not written to include extensive error handling capability. Read More
Program Status Data Structure (PSDS), %editc BIF (Built-In Function), and %subst BIF in RPG free. Aldo SUCCI
Program Status Data Structure (PSDS) : The psds named Pgm is utilized to store system-related information like the current user and program time.
User: A character field of length 10, located at position 358 in the program status data structure (PSDS). Read More
SQL: SELECT with “superpowers” Massimo Duca
With a little trick even a simple SELECT statement can execute any system command! Let’s see how to do that…
L’articolo SQL: SELECT with “superpowers” proviene da BlogFaq400. Read More
Planning Your Exit from IBM DB2 Web Query
IBM’s decision to drop DB2 Web Query caught customers by surprise. But as IBM said in their announcement letter, there are alternative solutions. We invite you to learn about ours: NGS-IQ. Read More
