Char to Decimal conversion.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dashpriya
Participant
Posts: 28
Joined: Thu Mar 09, 2006 12:57 am
Location: mumbai
Contact:

Char to Decimal conversion.

Post by dashpriya »

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
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

No simple way, but you could write a procedure/function in DB2 and use that. See this link for an example.
dashpriya
Participant
Posts: 28
Joined: Thu Mar 09, 2006 12:57 am
Location: mumbai
Contact:

Char to Decimal conversion.

Post by dashpriya »

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