topic File extraction MSGF (message) AS400 in Talend Studio

File extraction MSGF (message) AS400

Anonymous — Thu, 07 Jun 2012 21:25:31 GMT

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

Re: File extraction MSGF (message) AS400

Anonymous — Fri, 08 Jun 2012 06:28:42 GMT

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

Re: File extraction MSGF (message) AS400

Anonymous — Mon, 11 Jun 2012 10:13:14 GMT

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 ?

Re: File extraction MSGF (message) AS400

Anonymous — Fri, 08 Feb 2013 08:58:38 GMT

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..