cancel
Showing results for 
Search instead for 
Did you mean: 

Read FILE from as400

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

Hi,

i have to read a file from AS400. Wich is the best way to do it?

by file adapter (how?) by jdbc adapter ( is the any module to convert the inbound file to XML i remember one like SwapTrasformationBeam or something like that)

Remenber any blog?

Thanks

Rodrigo

Accepted Solutions (0)

Answers (3)

Answers (3)

ravi_raman2
Active Contributor
0 Kudos

Rodrigo,

you can go for sync if thats needed..else ..get the file and go with file adapter..dont forget to cater for the quotes...in your commands..

Regards

Ravi Raman

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

hi,

how cai i get the file via FILE adapter? FTP?

its just a common scenario FTP or have something special in this case with as400??

Thanks

Rod

Edited by: Rodrigo Pertierra on Apr 23, 2008 11:58 AM

Shabarish_Nair
Active Contributor
0 Kudos

There are two methods

1. File - The AS400 system can provide files and XI processes them.

2. JDBC - Connect directly via JDBC and update data.

The advantage of JDBC is that you can have sync processing!!!

Former Member
0 Kudos

ROdrigo:

I have done few interfaces in my previous project with As400 but they were using some shared FTP folder and I used to pick/place files using File Adapter.

Following are some info I found on AS400..hope its useful for you