Which version of Talend are you using?  There have been a lot of work on AS400 related issues between V2.1.4 and V2.2.1.  I currently have had no problems with AS400 connections, except for tCreateTable component.  The tCreateTable issue should be corrected in the next release.  I would only use V2.2.1 for AS400 connections.

You didn't mention if the problem was with Metadata or a specific component.  If you are having problems with the tAS400Output component, you might want to change the 'use commitment control' check box.  If your file isn't set to use commitment control on the AS400 (journaled files) the box should not be checked.  If they are under commitment control, check that box.  I think the defaults were changed in Talend V2.2.1 to not use commitment control by default.

Hope that helps, and if it doesn't, leave a bit more detail about what component you are using and when the error occurs.

Jerry Leeper

1) Are you using a Perl or Java Project.  The Java project have AS400 specific connectors, tAS400Input and tAS400Output. And the Metadata create connection wizard will create AS400 specific connections. 

I don't think Perl projects are really set up to handle AS400.  If you are able to get to an AS400 in a Perl project, I think you end up going through the JDBC:ODBC bridge; something that APITA as far as I'm concerned.  Java Projects will give you direct connections through the JT400 JDBC driver which probably is what's working fine for you with other products.

I didn't need any special setup.  I would guess that all the applications you have made AS400 jdbc connections use the JT400 driver, just like Java project do in Talend.

If you really, really want to work in a Perl project, I'd start by creating an OBDC connection to the AS400.   Once you get that working, then I'd try setting up a generic OBDC connection in Metadata.  I wouldn't recommend it though...

jerry leeper

Last edited by jleeper (2007-11-16 00:51:37)

Hello

I have been recently able to connect succesfully to a few AS400 with Talend.
Talend was fully able to work conect and execute request to AS400.

May you post your full error message ?

Regards,
Michaël.

hi,
is there a place where i can look for a more detailled log, in talend or on my as400

it's ok like this
i just connect a tinputas400 and toutputdelimited, run it ..............

and it's work.

the probleme is just at the connection test ?
i am not able to open the tinputas400's sql builder.
i am not able to define a data connection.

thanks for help

it's a V5R3 version
is there a way to bypass the problem or am i obliged to migrate to V5R4 ?

Last edited by chris doudet (2007-11-29 09:38:50)

hi,
it's me again.
i'm now on V5R4, and i still have the same problem

RESOLVED

The problem is a bad SQL package on QGPL.

if you got the same error ask for your ibm support.