To Use Modify Stage

[ds_raman]

Hi all.

Can anyone help me in giving the syntax for converting a char datatype "which has numeric values" to integer or small int type's using Modify Stage.

[Teej]

You won't even need the modify stage, just use a copy stage, and let DataStage automatically convert it by automatically appending its own modify stage when you change the data type.

I know it's cheating, but there you go.

[subrat]

Please find the below code and change it as ur need .

<NEW_VAR>:string[6] = string_trim[NULL,end,begin]<OLD_VAR>

You won't even need the modify stage, just use a copy stage, and let DataStage automatically convert it by automatically appending its own modify stage when you change the data type.

I know it's cheating, but there you go.

[ray.wurlod]

The data type between the ":" and the "=" in a Specification is that of the output field, not that of the input field. Therefore, if the output field needs to be integer, then int32 (etc.) must be the data type. There is no implicit convertion from string to integer, so you must provide a function such as (from memory) int32_from_string.

Code: Select all

OutCol:nullable int32 = int32_from_string(InCol)

[ds_raman]

Thank you very much Ray, Hope you had good time in Bangalore,

[ray.wurlod]

If you can't find an int32_from_string() function - I did mention that it was from memory - use decimal_from_string() and specify a scale of 0.