DSXchange

Below is the design to do your logic. Seqfile-------->Transformer------->output In the transformer you declare stage variable as below StgVar---If Mod(@INROWNUM,2)=1 Then InputColumn Else StgVar: '|' : InputColumn In the constraint give the condition as -- Mod(@INROWNUM,2)=0 In the derivation for ou...

I have 5 sequencer jobs are executing sequentially one executing another.In that after executing the first and second job i don't want to run the third job(this job runs only once in life time.i.e only first execution) and run the fourh and fifth sequencer jobs. Forex: A--->B--->C--->D--->E I want t...

Hi
can any one please help me how to calculate the number of months between two dates.

Thanks

Hi,
how to convert the decimal value to Hexadecimal values in job

Hi , I want to convert from today's day to julian day as DDD format. I have tried the function juliandayfromDate , but it is giving the 7 digit number. I'm little bit confused whether i can extract the day (DDD which should 3 digit integer) from julian day. Please provide me suggestions on the same....

please let me know if there are any differences between datastage server edition 7.5.2 and 8.1 with respect to the stages added or removed, plug in available etc..

Hi All,

Is there any possibility that to send datastage director log details to database.If so how can i send the log details to database.currently iam using 8.1px and SQLserver is my database.

Hi, http://www.dsxchange.com/viewtopic.php?t=121714&highlight=mq+stage For me also same scenario that extracting data from the table by using Oracle Stage and trasforming to XML output stage and generate the XML SOAP message through MQ stage. Here my question is in MQseriesPX stage page there is...