Loading…
Welcome to Common Europe Congress 2019 in Berlin!

Log in to bookmark your favorites and sync them to your phone or calendar.

Workshop [clear filter]
Sunday, June 16
 

10:00 CEST

Effectively Administering IBM i Security and Keeping Your Configuration in Compliance
During this workshop, Carol Woodbury will provide an in-depth look at administrating IBM i Security, including a checklist of the areas that need to be managed/administered. Carol will also describe the options available for monitoring your security configuration including examples of specific commands and/or SQL statements available. Finally, Carol will discuss popular compliance requirements and methods for maintaining compliance.

Speakers
avatar for Carol Woodbury

Carol Woodbury

President and CTO, DXR Security


Sunday June 16, 2019 10:00 - 13:00 CEST
Aquamarin

10:00 CEST

Generating and Consuming JSON Data
JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose and can be faster parsed than XML. In this way JSON becomes more and more important especially when data is exchanged by RESTful web services. The use of XML declines in favor of JSON. With Release 7.3 TR 3 a bunch of scalar and aggregate functions were integrated into SQL, for generating JSON objects, arrays and for combining JSON components into complete documents. The JSON_TABLE tables function for consuming JSON data was already introduced with Release 7.3 TR 1. With the JSON_TABLE table function JSON documents can be parsed, converted into a relational representation and data picked specifically out. Additional scalar functions allow SQL to directly access JSON documents located within the IFS (Integrated File System) or in source physical file members. Last but not least IBM provides SQL http-functions for getting access to web services. In composition with the JSON_TABLE function the JSON answers returned by web services can be consumed within a SELECT-Statement.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect


Sunday June 16, 2019 10:00 - 13:00 CEST
Rubin

10:00 CEST

Hands-on IBM i + Node-RED = succeed faster in programming
IBM i is a private cloud on its own, and when used with open source technology in conjunction with Db2 for i, you can perform great things quickly and bring innovation for your business. Node-RED, which is built on Node.js, is a browser-based flow editor that makes it easy to wire together devices, APIs, and online services by simply dragging and dropping nodes on a palette. You then connect, or wire, the nodes to create flows that can be then deployed to the lightweight Node.js runtime with a single click. Make your idea a reality by prototyping like a master using Node-RED, and Node.js in conjunction with IBM i! Get hands-on experience and learn how to use Watson services, make a chatbot, connect to your RPG programs, use NoSQL databases using node-RED. And you don ™t even need any programming experience!

Speakers
avatar for Koen Decorte

Koen Decorte

CEO, CD Invest


Sunday June 16, 2019 10:00 - 13:00 CEST
Jade

10:00 CEST

Managing your IBM i with SQL - Made Easy!
On Db2 for i, SQL can be used for more than traditional database access. With the invention of IBM i Services, there are many options for accessing and managing your IBM i. This workshop will explore the many already existing examples shipped within IBM i Access Client Solutions. We will learn how to modify and enhance these to take your system management capabilities to the next level. Additionally, we will cover many examples that Scott has created to help IBM i clients accomplish specific modern system management. Come with your laptop loaded with the LATEST level for ACS. This will get you rolling on the road to managing your environment. Download ACS at http://ibm.biz/IBMi_ACS You don't need to be an SQL expert to use SQL to achieve proactive and automated management of your IBM i.

Speakers
avatar for Dave Owen

Dave Owen

Advisory Software Engineer, IBM
David Owen is an Advisory Software Engineer at IBM. Joining IBM in 1991, he has worked in the guts of the operating system in Journal and Database. He is also the technical consult for Guardium on i and has assisted several customers with installation and proof of concept activities... Read More →


Sunday June 16, 2019 10:00 - 13:00 CEST
Turmalin

14:00 CEST

iDoctor for IBM i Deep Dive
iDoctor is the best tool for doing deep dive performance investigations on IBMi. iDoctor gives you a good graphical understanding about your performance data. This can be when you are looking at Collection Services data and Job Watcher data, but also PEX (Performance Explore) data. Wait accounting will be reviewed, so you understand how IBM i can make it possible to collect performance data used for deep diving into partition and your applications. You will see practical examples of iDoctor analyzing Collection Service data, Job Watcher data and PEX data, so you can get very deep information about bottlenecks and issues in jobs/threads that can help you solve performance problems. Before the conference, you are welcome to contact the speaker at morten.buur.rasmussen@dk.ibm.com to request your own data to be analyzed during the session. Before the conference, you will be guided through the collection of data, so that is ready for the conference. Almost all types of performance problems can be analyzed via iDoctor.

Speakers
avatar for Morten Buur Rasmussen

Morten Buur Rasmussen

Power Performance Specialist, IBM Lab Services Europe
Morten Buur Rasmussen is a performance Specialist at IBM Lab Services Europe.Morten has 32 years of experience in the computing field. He started working with the S/38 and AS/400 in 1988 as programmer.Before joining the Lab Services, he worked for IBM Denmark and several European... Read More →


Sunday June 16, 2019 14:00 - 17:00 CEST
Aquamarin

14:00 CEST

Make your move to free form RPG
Are you still holding on to fixed format RPG ? Or do you use free format RPG already, but not completely free ?
Then it’s time to upgrade your programming skills !

In this workshop we will walk through the RPG Free Format syntax, while keeping the old syntax in mind. We will look at practical examples, highlight new features and theory will be alternated with hands-on experience.

Speakers
avatar for Jürgen Desmidt

Jürgen Desmidt

Software Developer, CD Invest
Jürgen Desmidt is software developer and trainer at CD Invest, a Belgian company specialized in modernizing IBM i applications.He started his career in 2000 as RPG developer and gained a lot of experience while working on projects in Belgium, Netherlands and France.LinkedIn - h... Read More →


Sunday June 16, 2019 14:00 - 17:00 CEST
Turmalin

14:00 CEST

RDi for advanced users - in GERMAN
Learn the latest features and extensions of the newest RDi version.

Speakers
avatar for Andreas Bott

Andreas Bott

Anwendungsentwickler, PKS Software GmbH
Andreas Bott is RPG and Cobol developer at PKS Software, an innovative software house in Germany. Andreas is also trainer for programmers starting to learn RPG or Cobol, trainer for Rational Developer for i for experienced programers and trainer for modern programming techniques in... Read More →


Sunday June 16, 2019 14:00 - 17:00 CEST
Jade