I am trying to get the information of a job in aftersub routine.
the parameters are passed during runtime.
Now i want to find out the type of the parameter and then do some coding on the value i get.
This is the code that i have used
v_jobHandle = DSJ.ME
v_paramtype = DSGetParamInfo(v_jobHandle, v_paramName, DSJ.PARAMTYPE)
now
v_paramvalue = '123456'here what i want to to do is if the paramtype is integer then paramvalue
how can i check with datastage code
else
v_paramtype = DSGetParamInfo(v_jobHandle, v_paramName, DSJ.PARAMVALUE)