Filter status 65,280

[via]

Hi all,

I am tyring to use the unix replace comamnd 'sed -e 's/"""/"/g', in the filter of a sequential stage in parellel job. I get this error message
"Filter status 65,280" -- the job gets aborted, but If click the view data button in the sequential stage( the stage where I read the data from the file), I get a Data stage error, and still could see the data, the way I wanted.

Any help regarding this would be greately appreciated.

Thanks in advance
Radha

[ArndW]

if you limit the number of rows in the input do you get the same error?

[via]

Thanks ArndW
I ran With just 4 rows. Its throwing the previously mentioned error for the last record only.
My job is :SEQ_FILE ---> trans ---> SEQ_FILE
INPUT FILE: I am reading this file as a single column as varchar
"""1234"""|"""2"""|"""1"""
"""1235"""|"""2"""|"""1"""
"""1235"""|"""2"""|"""1"""
"""1236"""|"""2"""|"""1"""

FILTER COMMAND USED--> sed -e 's/"""/"/g'
ERROR MESSAGE GOT:
Filter status 65,280;
filter process failed: 255;
import error at record 4.

THE OUTPUT FILE I GOT:
"1234"|"2"|"1"
"1235"|"2"|"1"
"1235"|"2"|"1"
"1236"|"2"|"1"

The command is working correctly but with these warning messages and the job is failing(but producing required output).
Any ideas??
Thanks

[ray.wurlod]

Does the last line in the file have a line terminator? (Can you position to the empty "line #5" in an editor such as NotePad?)

[via]

Thanks Ray there are only 4 rows in the input file(there are only 4 lines in textpad).
for the input sequential file stage and out put sequential file: using
record level-final delimiter= end & record delimiter string = DOS format
Field defaults-delimiter = none & quote = none.

I tried changing record level and field level defaults in the sequential file stage, but the same thing is repeating....

Thanks..