extract function in transformer stage string functions

[RAJEEV KATTA]

Can anyone help me out how does an extract function in server transformer stage work.I have tried with different options being passed for example Extract("dsxchange",1,2,2),it runs the job properly but returns null value.

[ray.wurlod]

The Extract() function works with dynamic arrays to extract an element therefrom. Your function (Extract("dsxchange",1,2,2)) attempts to get the second sub-value from the second value of the multi-valued first field of a dynamic array but your first argument is not a dynamic array, merely a scalar string. In such cases, the Extract() function will always return "". Indeed, all string functions in DataStage BASIC return "" if reference is made to a non-existent position.

Please specify in English what you want to accomplish, and we will be able to advise more accurately the function that you should be using.

[RAJEEV KATTA]

Thanks a lot Ray but i think first i need to brush up myself with what is an dynamic array.

[ray.wurlod]

I doubt it. I think you need a different function, such as Substrings(). But that's just a guess, since you will not reveal what you want to accomplish.