Get Journal Activity in "Real Time"

[MFisher]

Does anyone know of a method to get file Inserts & Updates in "Real Time" so they can be sent to a system outside the IBMi, like to a REST API ?

[Adarsh-PIA]

I worked 5 years back on this kind of requirement.. There were PFs/DDL tables from ibm i which needed data copy to MS SQL server in realtime..
what was done, as required by client is to have a separate library in ibm i with the set of file structures which required data migration and triggers were applied to the production library files which called one program. The behavior of that program was to write all generated data set along with the file name into a staging table.
another program was there which ran as NEP batch job, which read the data in staging file, segregated the data set based on columns from the mentioned table using syscolumns, and inserted/updated in the separate library files. And MS SQL job just processed that data from the separate library files into their DB.

Segregation of data was done through the sample logic that you can find in this repository in github.

https://github.com/AdarshPradhan03/DynamicTriggerData/blob/main/TSTTRGDTA.SQLRPGLE

you can also find code samples here -

https://github.com/AdarshPradhan03/dynamic-query-builder/blob/master/creating%20dynamic%20insert%20statement%20with%20values.docx

I hope you find this helpful..

[MFisher]

Thank you !!!