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
Char to Decimal conversion.
Moderators: chulett, rschirm, roy
No simple way, but you could write a procedure/function in DB2 and use that. See this link for an example.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Char to Decimal conversion.
Thanks a lot for pointing me to the site.
Thanks
Dash
Thanks
Dash