DSXchange

Hi All,

My Datatstage job consist of a DB2 stage then a Transformer then again a DB2 stage.In transformer stage I am using a Isvalid function to convert the char filed to decimal field.Can anyone suggest me if the same thing can be written in DB2 query? For debugging my answer i need this.

Any suggestion is higly appreciated.

Thanks In Advance
Dash

No simple way, but you could write a procedure/function in DB2 and use that. See this link for an example.

Thanks a lot for pointing me to the site.
Thanks
Dash