DSXchange

i moved my file s from as/400 to unix by using ascript

Hi, 1.my file in as/400 is moved into unix box, 2.we could see the records from unix box into datastage and read in this manner 3.,we checked in source file but in place of null values ^ is present. 32001 CMP^O0010301^O^O0153 after CMP it is null and should keep 9 characters but it is redaing the ne...

my question is like when i created a job sequencer for 5 flat files which i am using with job activithy stages how can i get record count should get the record count .iam asked to create a control job for this purpse.
Thanks
sunitha

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. 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 csv->transformer->hash file movi...

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

HI,

i should create control job to get the record count of the of the target file,my source is flat files ,how should i create this.what are the fields i should configure.how to use it in job sequencer to load 5 flat files.

Thanks
sunitha

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

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

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

HI Chulett,

I was struggling with the ultra edit ,but finally I got the answer for ultra edit ,to check for the path manually we go for ultra edit we are directly passing job parameters in the job to fetch th file from AS/400.
Thanks
sunitha

The main aim is to move all the files and move them as folder ,this folder will have all the files i require

Actually the files coming are moved to c:\documents and settings from AS/400 ,now our aim is to move the files throgh ultra edit into DS

HI, My source is AS/400 WHERE DATA IS AVAILABLE IN FORM flat files ,is they any way to import the files into datastage ,i am using ultra edit for unix console ,so if i am using a hash file as the source ,how could i import as/400 files into datstage. i was told to use chmod 777 convert dos to unix f...

Hi,

I don't have special books to follow ,these r my client's reqiremnt when using large volume of data

Hi, I want to keep track of the rejected records at the source which is called quality reports and error reports which are generted by using transformation ,the rejected records at the transformation .So Can all the reject records be maintained in these two report files ,if yes how could it be done....