DSXchange

hi,
In the filter stage when I use the condition

Col1='Sales #'

it gives the below error:

main_program: Data set, file set, or file "Copy_13:ToFilter.v": Non-pipe (or non-virtual data set) with .v in its name
Data set, file set, or file "Copy_of_FilterFlag:Lkup_Flag.v": Non-pipe (or non-virtual data set) with .v in its name

When I change the filter condition to Col1='Sales' with no '#' sign it works, is there a way I can go about it.

Thanks,

What happens if you escape it as in \# ?

ArndW wrote:What happens if you escape it as in \# ? ...

you will hit bulls eye , i have checked it , it solves the problem

Thanks guys !

The "#" sign is a special symbol in DataStage, a matched pair indicates a reference to a job parameter.