topic Re: Copy files to AS400 in Talend Studio

Copy files to AS400

ars — Thu, 10 May 2018 08:32:57 GMT

Hi all,

I need to copy files from a windows folder to AS400 library.

Obviously the tFileCopy component will not work !!!

I'm wondering if there is way to do that using FTP or something else.

Regards,

Arsenios

Re: Copy files to AS400

Anonymous — Mon, 14 May 2018 09:21:59 GMT

Hello,

Please have a look at this job design:tfilelist-->tfileinputXXX-->tAS400Output.

You can Iterates your folder in a given directory based on a filemask pattern by using tfilelist component and load your files into AS400 database.

Let us know if it is OK with you.

Best regards

Sabrina

Re: Copy files to AS400

manodwhb — Mon, 14 May 2018 09:24:21 GMT

@ars,you can try to put the file using tFTPput from local to remote server.

Re: Copy files to AS400

ars — Mon, 14 May 2018 11:04:25 GMT

Hi manodwhb,

I'm using tFTPPut component in order to upload a file e.g.EDI_ARS from local folder to a AS400 - e.g. LIBA/EDI/EDI_ARS (library name/physical file/member?)

Something in my declarations is wrong because no file is being uploaded.

Can you please see my attachment and advice what is wrong ?

Thank you,

Arsenios

put400.png

Re: Copy files to AS400

ars — Mon, 14 May 2018 11:07:44 GMT

Hi xdshi,

I'm not so familiar with tAS400 component.

I see there is a table declaration but I can't understand how it works!

Can you please give me a sample?

Regards,

Arsenios

Re: Copy files to AS400

manodwhb — Mon, 14 May 2018 11:08:49 GMT

@ars,Filemask Can you use as "*EDI_ARS*" ?

Re: Copy files to AS400

ars — Mon, 14 May 2018 11:37:18 GMT

@manodwhb

I changed Filemask from "EDI_ARS" to "*EDI_ARS*" but it's not working.

Arsenios

Re: Copy files to AS400

manodwhb — Mon, 14 May 2018 11:40:03 GMT

@ars,you schould specify the all path of remote directory.did you specified?

you just specified LIBA,

Re: Copy files to AS400

ars — Mon, 14 May 2018 11:43:50 GMT

@manodwhb

I have tried various remote directory setups

e.g.

LIBA/EDI ("/" character is not allowed)

LIBA.EDI returne error

It seems that remote directory only accepts library name LIBA.

Re: Copy files to AS400

manodwhb — Mon, 14 May 2018 11:46:32 GMT

@ars,you should use in the below way for directory.

For EIndow C drive means

C:/LIBA/EDI

for Unix

/LIBA/EDI

Re: Copy files to AS400

ars — Mon, 14 May 2018 11:52:24 GMT

@manodwhb

Sorry, maybe I was confused you.

Remote directory is on AS400.

If you type "/LIBA/EDI" or "/LIBA" on Remote directory setting it returns [550-Specified directory does not exist]

Only "LIBA" seems to be valid !!!

Re: Copy files to AS400

manodwhb — Mon, 14 May 2018 11:58:57 GMT

@ars,if LIBA is valid then should work.

Re: Copy files to AS400

ars — Mon, 14 May 2018 12:03:44 GMT

@manodwhb

I don't know why it doesn't work.

I have also problem with downloading.

I have the same file (EDI_90050) a library named GCH and I see that Talend recognizes it as GCH/%EDISND.EDI_90050.

But if I put %EDISND.EDI_90050 on filemask it returns error because of '%' character.

If I put EDISND.EDI_90050 file is not downloading.

Any suggestion for this please ?

Thank you for your time.

Re: Copy files to AS400

manodwhb — Mon, 14 May 2018 12:21:31 GMT

@ars,there should not be problem with %,as i have tested like below,since not IBM AS400 server.

Re: Copy files to AS400

ars — Mon, 14 May 2018 16:26:11 GMT

@manodwhb

This is a tFileInputDelimeted componenet which seems no have issue regarding the '%' character.

The problem in our case is tGet component. This is where I need to declare the file !!!

get.png