38 Messages
•
1.8K Points
COBOL Technical Lineage?
Hello everyone,
This may sound like a weird quesiton, but do you know if you can ingest technical lineage through a cobol program like you can an ETL? The scenario I’m dealing with is we still use Mainframe for several applications and I have the DB2 tables connected to Collibra. The flow is incoming files go through a cobol program to load into DB2. Has anyone dealt with this? If there just isn’t a way to deal with this programatically, what solutions have you used to stich the lineage? Not sure if this would apply, but just in case we are using EDGE. Thanks!
rudolfkunkel
18 Messages
1 year ago
Hello Lance,
one idea for custom Lineage for the COBOL program is to extract the DB2 SQL statements from your COBOL program as SQLfiles and use the SQL directory-based Lineage Harvester ingestion for DB2.
The DB2 COBOL precompiled produces a DBRM with resolved SQL statements.
Might be a good way to get the DB2 SQL statements is to use the SYSIBM Catalog tables instead trying to extract it from your COBOL programs.
Reference:
https://www.ibm.com/docs/en/db2-for-zos/11?topic=tables-sysstmt
When a DBRM is bound into a plan, all its SQL statements are placed into the SYSIBM.SYSSTMT DB2 Catalog table. When a DBRM is bound into a package, all its SQL statements are placed into the SYSIBM.SYSPACKSTMT table.*
1