Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2012-06-07 05:25 PM

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
Labels (2)
Labels
355 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2012-06-08 02:28 AM
Author

Hi
Bump. Does anyone know this solution?
Regards,
Pedro
355 Views
0 Likes
Anonymous
Not applicable
‎2012-06-11 06:13 AM
Author

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 ?
355 Views
0 Likes
Anonymous
Not applicable
‎2013-02-08 03:58 AM
Author

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..
355 Views
0 Likes