curl Your RPG Apps with QSHCURL Richard Schoen

​In this post we’ll take a closer look at how IBM i developers can use the QSHCURL command to easily reach out from CL or RPG and talk to internet-based services and APIs, then consume the resulting data, without a lot of extra effort. First we’ll provide a short curl intro, and then we’ll look at an example of how to use the PASE-based curl command with an RPG program. Intro to curl “Client for URL,” or curl as we know it today, has been a connectivity staple in the open systems world for over 27 years. It lets you…
The post curl Your RPG Apps with QSHCURL appeared first on Seiden Group. Read More 

How IBM Improved Application Development with the Spring 2023 TRs Alex Woodie

​IBM i developers have a few exciting new features to look forward to with the latest Technology Refreshes for IBM i 7.5 and 7.4, including a new release of RDi and new RPG and COBOL functions in the compilers.
As part of the Spring 2023 announcement for IBM i 7.5 TR2 and 7.4 TR8, IBM last week unveiled a new release of Rational Developer for i (RDi), version 9.8, that brings new functionality to the Eclipse-based integrated development environment (IDE). Read More 

Personalised SQL error logging, SELF Simon Hutchinson

​Introduced as part of IBM i 7.5 Technology Refresh 1 and IBM i 7.4 TR7, is a mechanism to capture details of SQL errors into a separate log table. I can decide which errors I want to capture in the log, by use of the SQL code. The SQL codes to capture are set at the SQL session level, rather than at the IBM i job level.
This is called the SQL Error Logging Facility, or SELF for short. It consists of several parts, the parts I am going to explain in detail are:

SQL_ERROR_LOG:  A View that is used to display the logged errors
SELFCODES:  A Global Variable that needs to contain the SQL codes I wish to log
VALIDATE_SELF:  A scalar function that validates SQL codes

Read more » Read More 

How To Eliminate Dependency On Tape For IBM i Backups LaserVault

​Using manual tape is no longer the best option for backup and recovery at most companies. Learn how you can step-up backup operations and strengthen your overall data protection through eliminating your dependency on using manual tape. During the session we cover why the switch from using tape makes strategic sense, and demonstrate the multitude of benefits gained from using a virtual tape solution instead. Read More 

Verified by MonsterInsights