DSXchange

any body know the reason?


Thanks

when i had used that sed '1d' in source sequential filter also its working fine. but if i use same in target sequential its removing two records first and second as well as if i place sed '2d' its removing 2nd and third record . @ray i had tried by changing of firstlinecolums true as well as false a...

Hi @Ray i had set firstline colum names as false

pradeep9081--- iam running on 4node configfile but the stages are executing sequentially

Thanks

i had executed sed '1d' command in external filter stage it removed first line in the file same command i had used in sequential file filter it had redmoved first two records.if i use sed '2d' in sequential filter it is removing 2nd and 3rd
can you please suggest me why its giving like that


Thanks

I Tried same once with following approach , My gola was to get the count of rows during tht particular run and get this count value in one of the column . So i did as follow , 1.From Transformer defined a variable COUNTER with values as '1' 2.Aggregate grouping on this COUNTER and using Count funct...

<removed your complete reposting of my last response and your idea>

WON'T IT WORK???

Try this logic Right(Field(col1,'.',1),1)=0 or 1 or 2 Then (Left((Field(col1,'.',1),Length((Field(col1,'.',1))-1):0) Else If Right(Field(col1,'.',1),1)=3 or 4 or 5 or 6 or 7 Then (Left((Field(col1,'.',1),Length((Field(col1,'.',1))-1):5) Else If Right(Field(col1,'.',1),1)=8 Then (Left((Field(col1,'.'...

Thanks ArndW & chulett due to server problem i'm not able to connect to datastage in my vpc i will try it after some time and let you know the result

Thanks

Hi Thanks ArndW for quick reply i had written command in that filter is grep-w detail but it throwing error command not found and job got aborted

can i run unix commands in sequential file filter iam working in windows

environment


Thanks

Thank You So Much ArndW

ray.wurlod wrote:Specify Unicode, write to a text file, view using a hex display utility (for example UltraEdit). ...

What is hex display utility


Thanks

resource disk "/is/isdata/partn/03" {}
resource disk "/is/isdata/partn/03" {pools "sort"}


in the above both paths are same but one is empty and another one is

alocated for sort whats the use of giving of both paths


Thanks,

Thanks for quick reply pandeesh

but iam in windows environment

how can we call parameters from a file?

Thanks