DSXchange

Hi I am having a problem with null handling. My code in tranformer derivation is- If In_Tfm_EmpId_Customer.TRAN_TYPE='EMPSALE' AND In_Tfm_EmpId_Customer.CUSTOMER<>' ' Then NullToValue(In_Tfm_EmpId_Customer.ASSOC_ID,' ') Else NullToValue(In_Tfm_EmpId_Customer.EMP_ID,' ') But still I am getting null v...

Hi I have an integer field of length 11. Now I need to attach Zeros before it, in the empty spaces. e.g if input column is 124125,then I must get 00000124125 What I have done is - IntegerToDecimal(input column) in stage variable.....then Str('0',11-input column):input column in derivation. But I am ...

hi,

I have a varchar field of lenght 11 and I need to find the characters from 6th to 9th position, in transformer stage.Plz help.

Regards
Arnab.

Hi,

how do the derivations in transformer operate..... top down in their grid??Or what is the sequence of operation of the derivations in transformer??

Regards
Arnie

Hi,

I just want to know the sequence in which the transformer components operate i.e Stage variable,constraints and derivation.Which one operates 1st.....

Regards
Arnie

got it...its working....Vinod and Joshy thanks very much......

Regards
Arnie.

Hi

I need to pad zeros on the left side of a varchar field. e.g:
I have a field called ID with length 6. Now if it is populated with 12,the it should come as 000012 and if 123 is populated then it should come as 000123. Please let me know if it is possible and how to implement........

Regards
Arnie.

got it....thank you very much ........

Hi, My source table has a varchar field. And it propagates either alphabatic or numeric value in it (like 'ABG' and '123'). Now in the transformer stage I have to check whether it is alphabatic or numeric ...i.e 'asd' or '412'...... Is it possible in datastage.....Kindly let me know... regards Arnie.

Hello

I want to call a stored prosedure from DB2 table , using datastage.
How is this possible?
Is there any stage for that?
Thanks
Arnie

Hi
I am new to Data stage.

I want to generate surrogate key in the transformer .I have done it by putting a column gen. before the tarnsfrmer. But I want it done using only a transformer.

Regards
Arnie