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

ObjectConnect over TCP/IP

Two and a half years after my post Transferring objects with ObjectConnect and Enterprise Extender, I finally got around to…

1 hour ago

SQL: SELECT with “superpowers”

With a little trick even a simple SELECT statement can execute any system command! Let's see how to do that...

5 months ago

NetServer for everyone – part 5

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago

NetServer for everyone – part 4

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago

NetServer for everyone – part 3

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago

NetServer for everyone – part 2

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago