Problem in reading a seqfile in px
Posted: Thu Dec 22, 2005 4:22 pm
Hi,
Iam new to this datastage . Iam having jobs in server and some jobs are running slowly. I want to develop those jobs in px. When Iam trying to read a data from sequential stage in px iam getting an error which says
Error Executing View data command
## E TOIX 15:53:21 (003) <seq_file 18> unable to initialize the importer.
In server job in seqfile stage
Line termination is given as unix style (LF) and in format tab i gave it as
Fixed with columns, first line is column name, missing columns action (pad with sql null) and Suppress row truncation warning. Its working fine but in parallel I have a problem.
In parallel in properties I gave
Read method = specific file(s) in options I gave first line is column name =TRUE and remaining options I kept as default
In format tab : I gave Record delimiter = unix newline, record length = fixed and in Field defaults I gave Delimiter = whitespace and all are defaults
Please help me in getting out of this problem
Regards,
Somaraju
Iam new to this datastage . Iam having jobs in server and some jobs are running slowly. I want to develop those jobs in px. When Iam trying to read a data from sequential stage in px iam getting an error which says
Error Executing View data command
## E TOIX 15:53:21 (003) <seq_file 18> unable to initialize the importer.
In server job in seqfile stage
Line termination is given as unix style (LF) and in format tab i gave it as
Fixed with columns, first line is column name, missing columns action (pad with sql null) and Suppress row truncation warning. Its working fine but in parallel I have a problem.
In parallel in properties I gave
Read method = specific file(s) in options I gave first line is column name =TRUE and remaining options I kept as default
In format tab : I gave Record delimiter = unix newline, record length = fixed and in Field defaults I gave Delimiter = whitespace and all are defaults
Please help me in getting out of this problem
Regards,
Somaraju