how i transfer my as/400 files into unix box

sunitha_cts · Post by **sunitha_cts** » Thu Jun 25, 2009 4:54 am

Hi Chulett,

how could i transfer by as/400 files into my unix box,ultra edit from where i am going to import into datastageserver edition.

Thanks
sunitha

chulett · Post by **chulett** » Thu Jun 25, 2009 5:17 am

Why ask just me rather than everyone?

Talk to your AS/400 and UNIX administrators, see what approved ways you have to transfer files between those boxes.

sunitha_cts · Post by **sunitha_cts** » Thu Jun 25, 2009 10:37 pm

Hi all,

Can anyone give me any idea to move my files from AS/400 to unix box because for a single file i can move using ajob ftp stge->hash file, we don't want to hit as/400 box for every file we want to use .i should pull all the as/400 libraries into unix box ,so from this unix box i will import files using ds to develop my jobs .i got stuck up at the source level itself,and my work is not in progress.
Thanks
sunitha

pxraja · Post by **pxraja** » Thu Jun 25, 2009 11:43 pm

sunitha_cts wrote:Hi all,

Can anyone give me any idea to move my files from AS/400 to unix box because for a single file i can move using ajob ftp stge->hash file, we don't want to hit as/400 box for every file we want to use .i should pull all the as/400 libraries into unix box ,so from this unix box i will import files using ds to develop my jobs .i got stuck up at the source level itself,and my work is not in progress.
Thanks
sunitha

there are two ways :
one is to download files from the library using iseries and save it as csv file,upload to unix and then go ahead with datastage jobs

second, directly connect to database by configuring odbc.ini file for db2 WIRE PROTOCOL

pxraja · Post by **pxraja** » Thu Jun 25, 2009 11:44 pm

sunitha_cts wrote:Hi all,

Can anyone give me any idea to move my files from AS/400 to unix box because for a single file i can move using ajob ftp stge->hash file, we don't want to hit as/400 box for every file we want to use .i should pull all the as/400 libraries into unix box ,so from this unix box i will import files using ds to develop my jobs .i got stuck up at the source level itself,and my work is not in progress.
Thanks
sunitha

there are two ways :
one is to download files from the library using iseries and save it as csv file,upload to unix and then go ahead with datastage jobs

second, directly connect to database by configuring odbc.ini file for db2 WIRE PROTOCOL

pxraja · Post by **pxraja** » Thu Jun 25, 2009 11:46 pm

Applicable only if you are DB2 WIRE PROTOCOL or you have ISERIES to access the database.

sunitha_cts · Post by **sunitha_cts** » Fri Jun 26, 2009 2:31 am

i don't want to hit as/400 libraries once i pull all the as/400 files into unix box

chulett · Post by **chulett** » Fri Jun 26, 2009 6:44 am

Talk to your AS/400 and UNIX administrators, see what approved ways you have to transfer files between those boxes.

sunitha_cts · Post by **sunitha_cts** » Tue Jun 30, 2009 11:08 pm

Hi,

I should use a script to pull all the libraries to the unix box.

as/400,>etl->unix ,by using a etl job ,all the libraries reside in the unix box.
the etl job is like 2) seq->hash file this job is as given below

i should move 5 flat files in unix box having different metadata by using the same job 2)how could it be done,
job is hash file->transformer->hasf file moving all the flat files shuld be done using single job ,how could it be done.what the configuartion i should i should set up.
Thanks
sunitha

ray.wurlod · Post by **ray.wurlod** » Tue Jun 30, 2009 11:54 pm

Please delete your duplicate thread that you just started with exactly this same post.