DSXchange

Yes it is a parallel job , .....

I am going to pass the values as decimal and then later in the job convert to char, ....

The condition is col1 = col2


ie: if col1 <> col2 then ABORT JOB

Hi,

I am working on a job in which there is a condition, Which if not satisfied should abort the job. Can I do this ?

I have this job in a sequence, so when the job fails ....the "fatal" link should be executed.

Please help .. thnx

View data , ....

@Kumar_s

I have no idea about "Multiple reader per node" , how can i find out ?

The text file is been generated from a sql script .... The type is varchar from the source. It not a fixed width file.

but when I change the datatype to decimal .... I am able to view the data.

The "display" property is not present in the metadata, Cant figure out where I can add that

Hi , I Have a seq file seperated by the column delimiter "|" abc|123|xyz|000| When I read the file in parallel, i am missing data in 2 of the columns, like abc|3|z|000| Why does it show like that , I have the metadata for all the columns ? .... i am just missing data in 2 columns. Can anyo...

The data comes as char from the source ... anyway i will try converting to string again and see if it works ..

My job structure is Seq stage > Seq stage > Funnel > Filter > Seq Stage The job was working fine when I had transformer in the place of the filter, but When I use a filter there, the job dosent work. The director shows the job ran sucessfully in 0.2 seconds, there are no warnings. DS dosent show any...

Well the Routine Activity is working fine now . But now i want to come up with a little more flexible job . as in i want to parameterize the command so that i can run the same job in order to execute the same task for different files ie i am using routine activity stage and using ExeSH this pops up ...

Thanks DSguru,

Can I specify "And" in the clause?

like DIGIT_CODE like "04%" And l_INVENT.KIT_ID like "~00000"

and can I use <> or = in the filter stage?

Hi, One of my job uses a transformer to apply the constraint l_INVENT.DIGIT_CODE[1,2] = "04" And l_INVENT.KIT_ID <> "00000". I am trying to replace the transformer with a filter stage, How do I specify the above constraint in the filter stage? I tried DIGIT_CODE like "04...&...

Oops sorry if I got you guys confused ... datasets with VARCHAR work generally , but in my case I was using dataset with varchar but then the padding does not work, if i use char them my trim does not work. My whole point is ...I need to pad the values SPACE in my dataset or seq file but I also need...

Dataset with varchars does not work ...

The output is a dataset currently, do I need to use a sequential file there to be able to get APT_STRING_PADCHAR working ???