Last Updated on 20 August 2020 by Roberto De Pedrini
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.
Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful Read more
DB2 Database and SQL ... maybe the most important things on IBM i platform: here's a collection of FAQs, tips Read more
Comes directly with the Easter egg this IBM announcement for the news of the IBM i 7.4 version, iNext version Read more
Introduction "Generated Always Column": are columns, table fields, filled by DB2 engine: something like columns with a default value but Read more
