Name: Mastering Advanced SQL Data Types in ILE RPG: From LOBs to XML
Start: 2026-06-17T09:10:00+0200
End: 2026-06-17T10:10:00+0200

WELCOME TO COMMON EUROPE CONGRESS 2025

Common Europe, in collaboration with Common Sweden, is delighted to be holding its annual flagship event, Common Europe Congress, in the friendly city of Gothenburg offering extensive education, networking and relaxation opportunities.

You will be able to validate your attendance (Check-In to sessions) using your personal schedule.

Mastering Advanced SQL Data Types in ILE RPG: From LOBs to XML

Wednesday June 17, 2026 09:10 - 10:10 CEST

05 -RHÔNE 3A

Modern IBM i applications increasingly demand sophisticated data handling capabilities beyond traditional character and numeric fields. This technical deep-dive session explores the powerful arsenal of SQL data types available to ILE RPG developers, demonstrating how to leverage CLOBs, BLOBs, and XML structures for real-world business solutions.Through hands-on code examples, attendees will discover practical implementations of Character Large Objects (CLOB) for managing extensive text data, Double-Byte CLOBs (DBCLOB) for multilingual applications, and Binary Large Objects (BLOB) for document and media storage directly within Db2 for i.The session goes beyond basic usage to address performance considerations through LOB Locators, enabling efficient manipulation of large objects without loading entire contents into memory. We'll explore File Reference Variables for seamless integration between IFS files and database LOB columns, demonstrating bidirectional data flow patterns that modernize legacy document management approaches.Special attention will be given to XML_CLOB_FILE handling, showcasing how ILE RPG can natively process XML data structures stored in CLOB fields—a critical capability for web services integration and data interchange scenarios.Each data type will be illustrated with production-ready RPG code snippets, common pitfalls to avoid, and performance optimization techniques. Attendees will leave with immediately applicable knowledge to modernize their IBM i applications, eliminate external file dependencies, and implement robust, database-centric data management strategies that leverage the full power of Db2 for i.

Speakers

Antonio Salcedo

IBM i Consultor, Instructor & Programmer, Common Iberia

I'm a fan of programming in general and ILE RPG in particular. I love movies, going to the theater, reading and listening to (hard) rock music.

Wednesday June 17, 2026 09:10 - 10:10 CEST
05 -RHÔNE 3A

IBM i application development 2

Tickets

Success you have shared X tickets.

COMMON EUROPE CONGRESS 2025

Antonio Salcedo

Attendees (24)

Get help with the event

Success you have shared X tickets.

COMMON EUROPE CONGRESS 2025

Antonio Salcedo

Attendees (24)

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

Get help with the event