topic Re: AS/400 Custom component, studio 7.1 in Talend Studio

AS/400 Custom component, studio 7.1

Anonymous — Fri, 02 Jan 2026 14:45:42 GMT

HI,

Few questions -

I've built a custom connector which connect to as400, make a program call with a unique key as an input, and return the suitable entity:

1. How can I log each transaction in my IBM db2 (query itself, data which has passed, date-time)? I know the terminal command ,DSPJRN JRN, but how i can use it in talent to connect to the journal?

2. How can I map the specific returned entity (It is complex structure entity) from the as/400 ? I use a function with the @Producer annotation to return it but I really don't know where it return to or how can I catch it in talent studio and use it in my jobs flow.

Re: AS/400 Custom component, studio 7.1

Anonymous — Wed, 30 Jan 2019 09:13:48 GMT

Hello,

Are you using Java Jet approach or talend component Kit to build your custom connector?

Best regards

Sabrina

Re: AS/400 Custom component, studio 7.1

Anonymous — Wed, 30 Jan 2019 13:35:18 GMT

HI @xdshi ,
I'm using talend component Kit

Re: AS/400 Custom component, studio 7.1

Anonymous — Sun, 03 Feb 2019 07:46:31 GMT

@xdshiIs there any idea?

Re: AS/400 Custom component, studio 7.1

igorbeslic — Fri, 05 Apr 2019 05:41:12 GMT

Hi @dani31090 beside AS400 JDBC Driver operations, other complex operations against AS400 programmatically can be done with IBM Toolbox for Java. However it will require you to write some custom Talend code to provide it with access credentials.

IBM Toolbox https://www.ibm.com/support/knowledgecenter/en/SSPSQF_9.1.0/com.ibm.etools.iseries.toolbox.doc/page1.htm allows you to execute any terminal command and retrieve results in your code.

Question 2: Every structure from outside system is specific and as I see how Talend works you just apply patterns from documentation or code related to salesforce components (helped me a lot) https://github.com/Talend/connectors-se/tree/master/salesforce/src/main/java/org/talend/components/salesforce

Btw. AS400 data record format almost matches Talend's Record methodology. I guess you could also use IBM Toolbox to analyze it, or if available via DB2 use table metadata to recreate structure (see salesforce components).

Hope this will help you to make a step