Yeah, I do. You are welcome
------------------------------
Matheus Porsch
Systems Administration - Kyndryl
Brazil
------------------------------
Original Message:
Sent: Tue January 13, 2026 12:29 AM
From: Shashank Dewangan
Subject: Db2 zos ETL tool
Thanks Matheus for your response.
I think you are referring to zOS Db2 loading the data by using the cross-loader function.
Original Message:
Sent: 1/12/2026 9:22:00 AM
From: Matheus Porsch
Subject: RE: Db2 zos ETL tool
I believe you want an 'into DB2' solution, the closer is use SELECT / LOAD and INCURSOR.
You define an SQL cursor (EXEC SQL). The cursor executes a SELECT that: Reads the source table, applies all necessary transformations, returns the final format expected by the destination table.
The LOAD utility consumes this cursor with the INCURSOR option The transformed data is loaded directly into the destination table
------------------------------
Matheus Porsch
Systems Administration - Kyndryl
Brazil
Original Message:
Sent: Mon January 12, 2026 08:34 AM
From: Shashank Dewangan
Subject: Db2 zos ETL tool
Hi
Does IBM offer a specific tool or utility that facilitates an end-to-end ETL process entirely within the Db2 for z/OS environment? specifically, I am looking for a solution that can efficiently unload data, apply custom transformations based on user requirements, and load the result into a separate Db2 for z/OS database.
Regards,
Shashank
-------------------------------------------