DSXchange

Sometimes a job loses it's design information. I am really not sure how this happens but it does. Is there a(ny) way to identify jobs that don't have design information? One way that comes to my mind is to compile the jobs and look at the error message to find such odd ones. But this is time consumi...

Thanks Eric. This is my thought. Sequence is just a native batch creation tool and it should have all features like command like batch execution & any 3rd party batch execution tool. Hope IBM introduces this option in the near future. Can anyone check 11.3 version and let me know if queue option...

When i try to run a job from designer or director, i see an option "workload management -> queue". I could see the same option when i try to run it from Operations console. I believe dsjob -queue could be used to specify from command line. Good so far.... If i create a sequence with 20 job...

I believe that most of us knew about Operator & Super Operator roles in DataStage. This is my 4th organization, especially a bank, where admin or infra team is reluctant to grant Operator or Super Operator role in production environment for genuine reasons. The reasons are that the production en...

Thanks Ray

A job that reads from a sequential file, applies some business logic, and writes the results to a db. Layout of input file change from run to run. All columns will remain the same, but the order of them will change. which feature of sequential file stage allows to accomplish this? Answer: Schema fil...

Do you have any update on this? Did IBM or DBA find the root cause?

Also, let me know if your reference could have duplicates on the combination of Key1 and Key2.

Which version of DataStage you are using? If it is >= 8.5, then you can use vertical pivot method in pivot stage. In this case, you need to assume that you will always have 4 rows coverted to 4 columns. Any concern on null fields for groups having less than 4 rows? Or Use stage variables in transfom...

The logic is : source.key1=Ref.Key1 and source.key2<> Ref.key2 SO, the result should be: key,key2,val1,val2,key2_1,val1_1,val2_1 ------------------------------------------------ 123,121,120,128,120,120,123 123,120,120,123,112,119,100 Is your expected output correct? Based on your condition, only on...

Single - fine.
With Family - Useless..

pandeesh wrote:So we nee to recursively apply for all the occurrence of a

Is this the actual requirement? What i thought is you want to select some string which has one occurrence of %a_b%.

Anyways, i don't think you can achieve this with a cake walk.

Yes kandy. Thats the way I was also thinking about . But when we have the pattern like %a_b%, I don't know how to match all the possible patterns . That is also possible. No time to give you the code. Find the location of first 'a' using Index, then add 3 to it and see whether the character in that...

Check if this is what you want..

InputString[1,1] = 'a' and InputString[3,2] = 'b%'

or

InputString[1,1] = 'a' and InputString[3,1] = 'b'

Vamsi, SAME partition brings the data of 0 partition of the previous stage to 0 partition of current stage. This is used in most of the places where you don't need to reparitition the data flow. This answers both of your questions. E.g. your job design is like dataset to transformer Assume that 0 pa...