Skip navigation
Contact Us
753 Views 1 Reply Latest reply: Feb 22, 2013 2:33 PM by Dan Smith RSS
Vid K Newbie 1 posts since
Feb 21, 2013
Currently Being Moderated

Feb 21, 2013 8:11 AM

Convert low value coming from mainframe to spaces

Gurus, I need help in converting a low value to spaces. Basically one of the column may contain low value and want to know how to validate low value data for conversion

  • Dan Smith InfaEmp 185 posts since
    Jun 2, 2009
    Currently Being Moderated
    Feb 22, 2013 2:33 PM (in response to Vid K)
    Convert low value coming from mainframe to spaces

    PowerCenter doesn't understand binary format data, so you would need to convert it in PWX, before it gets to PowerCenter.

     

    You could do that by using a row-level exit.  Please note that doing that will degrade performance, because PWX would have to call an external program for each row that it processes from the source.

     

    You might also be able to find some way to do this with a function - I haven't tried it, so I'm not certain.

More Like This

  • Retrieving data ...

Bookmarked By (0)