Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ars
Contributor III
Contributor III

Copy files to AS400

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

 

Labels (2)
14 Replies
Anonymous
Not applicable

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

manodwhb
Creator III
Creator III

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

ars
Contributor III
Contributor III
Author

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
ars
Contributor III
Contributor III
Author

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

 

manodwhb
Creator III
Creator III

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

ars
Contributor III
Contributor III
Author

@manodwhb

 

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


Arsenios

 

 

manodwhb
Creator III
Creator III

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

you just specified LIBA,

ars
Contributor III
Contributor III
Author

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

 

manodwhb
Creator III
Creator III

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

 

For EIndow C drive means

C:/LIBA/EDI

for Unix

/LIBA/EDI