Back To Schedule
Thursday, October 7 • 9:15am - 10:15am
SQL and IFS - Reading/Writng IFS Files with SQL

Log in to save this to your schedule, view media, leave feedback and see who's attending!

SQL is great for accessing data located in a relational database. But in a modern world it is also necessary to consume data that is located in the IFS (Integrated File System) or provided by web services_x000D_ With each Technology Refresh IBM introduces and enhances Db2 for i Services. With Release 7.4 Technology Refresh 3 IBM provides new SQL Stored Procedures for reading data from and writing Data into the IFS._x000D_ In composition with other SQL Functions it is easy to scan through IFS files or decompose *.csv files or JSON files or XML documents located in the IFS. _x000D_

Learning Objectives:
In this session you’ll learn how to write data to the IFS and how to read IFS files, by using no other programming language than SQL. _x000D_ It will be also demonstrated how to access and decompose *.csv files located in the IFS without copying them into a physical file or SQL table. _x000D_

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →

Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 7 Online

Attendees (2)