how i transfer my as/400 files into unix box
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
how i transfer my as/400 files into unix box
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
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
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
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
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 :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
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
there are two ways :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
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
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: