Categories: 01 - Programming (EN)

Webinar Dev – 07/28/2020 "IBM i services … at your service "- Marco Riva – ONLiNE DAYS 2020

Webinar available ON-Demand:

Update of 12 August 2020: The webinar, held on 6 August 2020, is available On-Demand directly from the ONLiNE DAYS 2020 Virtual Expo: enter the Virtual Expo (register if you have not yet done so) and join the desks in the webinar room of Webinar-On-Demand.

Speaker:

Marco Riva – Developer – Expert – IBM i Mentor – Blogger Faq400

Abstract:

  • SQL not just for reading tables:
  • monitor the system with SQL
  • integrate IBM i services into your applications

Date: Tuesday 28 July 5.00 pm

Let’s start the cycle of technical Webinars for IBM i Developers talking about IBM i Services SQL: a collection of services to be called via SQL as normal functions (UDF), tables (UDTF) or procedures (Stored Procedures) that allow you to query and interact with the IBM i system in a simple way, directly from SQL Script or from SQL Embedded, inside ILE RPG, ILE Cobol or from all Open Source languages that now run very well on IBM i.

What can we do with IBM i Services SQL?

  • Work on active Data Queues / Data Areas / Environment Variables / Joblogs / jobs
  • Work on network services and settings and security
  • IFS / Libraries
  • Java
  • Journal
  • PTF / Storage / Health
  • Spool

With IBM i Service SQL we can do many things … without reinventing hot water … therefore it is important to stay up to date with the IBM i operating system versions.

In this session our Blogger Marco Riva takes us to the discovery of these services … with concrete examples of use …

We are waiting for you

Webinar available ON-Demand:

Update of 12 August 2020: The webinar, held on 6 August 2020, is available On-Demand directly from the ONLiNE DAYS 2020 Virtual Expo: enter the Virtual Expo (register if you have not yet done so) and join the desks in the webinar room of Webinar-On-Demand.

Related Posts
DB2 for i SQL – String Manipulation – POSSTR-LOCATE-LOCATE_IN_STRING (EN)

Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful Read more

DB2 for i – FAQ & Howtos (EN)

DB2 Database and SQL ... maybe the most important things on IBM i platform: here's a collection of FAQs, tips Read more

IBM i 7.4 Announcement (En)

Comes directly with the Easter egg this IBM announcement for the news of the IBM i 7.4 version, iNext version Read more

Generated Always Columns (EN)

Introduction "Generated Always Column": are columns, table fields, filled by DB2 engine: something like columns with a default value but Read more

--- Roberto De Pedrini Faq400.com

Recent Posts

Managing Locked Display Files on IBM i: An Effective Solution

We are pleased to receive and share this "tip & trick" from Patrick Rizzi, which introduces a technique that allows…

2 months ago

Monitoring QSYSOPR Messages: SQL to Retrieve Messages and Replies

I take inspiration from a response by Michael Mayer on the Midrange.com mailing lists to someone who asked how to…

2 months ago

Why ERP is the Key to Success for Modern Businesses

Businesses are increasingly seeking tools to enhance efficiency, collaboration, and resource management. Enterprise Resource Planning (ERP) systems provide a comprehensive…

4 months ago

ACS Access Client Solution 1.1.9.5

Early April saw the release of the "Spring Version" of ACS Access Client Solution, version 1.1.9.5 Interesting new features especially…

8 months ago

Tim Rowe and Scott Forstie for CEC 2024 – Milan

If the packed agenda of sessions at Common Europe Congress 2024, June 3-6 Milan, wasn't enough for you, here's another…

8 months ago

Code for IBM i 2.10.0 – Debug IBM i App with Visual Studio Code

Debugging functions with Visual Studio Code have been available for some time but this new version 2.10.0 simplifies the handling…

8 months ago