Talend community forum / File extraction MSGF (message) AS400

surfary · 2012-06-07 22:25:31

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

pedro · 2012-06-08 07:28:42

Hi

Bump. Does anyone know this solution?

Regards,
Pedro

surfary · 2012-06-11 11:13:14

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 ?

sylpri · 2013-02-08 09:58:38

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

Announcement

Unanswered posts

#1 2012-06-07 22:25:31

File extraction MSGF (message) AS400

#2 2012-06-08 07:28:42

Re: File extraction MSGF (message) AS400

#3 2012-06-11 11:13:14

Re: File extraction MSGF (message) AS400

#4 2013-02-08 09:58:38

Re: File extraction MSGF (message) AS400

Board footer