Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html

Exhibitor Hall Map Here 
Back To Schedule
Monday, May 20 • 11:30am - 12:30pm
179: SQL and IFS - Reading/Writng IFS Files with SQL

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
EVALUATION
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

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.

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.

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.
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.
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
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 →

Monday May 20, 2024 11:30am - 12:30pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Advanced
  • Audience Developers and users who are experienced in SQL Queries and want to know how to write data into the IFS or have to consume IFS data, or simply want to enhance their SQL know-how.

Attendees (36)