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.
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.
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 ?
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?
I have tried various remote directory setups
LIBA/EDI ("/" character is not allowed)
LIBA.EDI returne error
It seems that remote directory only accepts library name LIBA.
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 !!!
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.
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 !!!
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.