One Star

File extraction MSGF (message) AS400

Hello,
Have you any idea how to extract data from a message file (MSGF) (AS400/db2) to a text file for example?

Thank you in advance
3 REPLIES
One Star

Re: File extraction MSGF (message) AS400

Hi
Bump. Does anyone know this solution?
Regards,
Pedro
One Star

Re: File extraction MSGF (message) AS400

Hi
No answer...
Is that the only solution is firstly to call an AS400 program which transfers the data from this file message to a DB2 file and then transfer the file with db2 Talend ?
Four Stars

Re: File extraction MSGF (message) AS400

hi surfary,
I'm probably too late but here is my workaround for this kind of need : to create a db2 function (or procedure) embedding a call to a CLLE or RPGLE program. For instance I created some sql functions to call some sys cmd via qcmdexec api or to submit some jobs (SBMJOB) or also to get sys datas or functionnal datas as an object last modification date..