DSXchange

Ray,

Thank you very much, It solved my problem.
You are the man!

Hi, I am looking to get a column F2 having cumulative totals from column F1 Also I need it to reset for each year. I am guessing stage Variables is the way to, but no clue as to how to go about it. Can someone help me out with. Please let me know if my requirement is not clear. Thanks in advance. Ex...

Hello all, Is there a way to replace "IN" statement without using "OR" multiple times while creating a derivation for a stage variable? Eq: If I have to use a Job parameter "JobP" which has a value of ('AAA',BBB','CCC','DDD') which I use in my source query, I would like...

Thanks for confirming chulett.
If possible can you please give me a code snippet of the same.

Hi, Is it possible to run a multi instance job using UtilityRunJob after a job? If yes, how do we call it? Do we need to incorporate it into an After job subroutine? or write a Transform Function? p.s. I know that I can call it as a Job Activity, but I want to run it as an after job. Any help apprec...

Can you please tell me how do you select from a hashed file from unix?

ArndW, I had a question.
How do you make the file fifo?

Kumar, sorry for the late reponse.
Yeah I guess you are right, that may be my only option. Thanks

I have a simple job to read from a sequential file and load into Oracle table. One of the column in the file in timestamp in the format. 2008-04-01 02:05:48.147 I would like to maintain the same format in the target table If I need to load it into an Oracle table - 1. What datatype should the target...

Bulls eye!
Problem solved. Thanks Ken

Hi all, Can any body guide me in the below scenario Table A has the below data Item1 Item2 Item3 Item_type Item_Qty ---- ----- ----- --------- -------- A B C x 1 A B C y 2 A B C z 5 D E F y 2 D E F x 6 D E F u 8 D E F m 9 I want to transpose the Item_Type and Quantity in the below manner Item1 Item2...

Thanks Craig and ArndW for pointing in the correct direction.

Hi all, I have a requirement where in I need to convert some values in a tables below. From------------------------->To =================================== 111,22,3245,44 ------------> ##111,###22,#3245,###44 32,434-----------------------> ###32,##434 1232,3432,54,54334-------> #1232,#3432,###54,543...

There is a option in the Tools menu of the DS Manager where in you can compile multiple jobs at the same time.
It does not select the jobs inside the sequence automatically, you need to select them manually.

By the way, it is sequence and not sequencer

Kool! Works like a charm!
I have both ways now.
You guys rock