Logical functions in Datastage

Reading Time: < 1 minute
BitAnd(352,400) If mylink.mynumber1 contains the number 352 and mylink.mynumber2 contains the number 400, then the following two functions are equivalent, and return the value 256
BitCompress(“0101100000”)If mylink.mynumber1 contains the string “0101100000”, then the following two functions are equivalent, and return the number 352
BitExpand(352)If mylink.mynumber1 contains the number 352, then the following two functions are equivalent, and return the string “0101100000”.
BitOr(352,400)If mylink.mynumber1 contains the number 352 and mylink.mynumber2 contains the number 400, then the following two functions are equivalent, and return the value 496
BitXOr(352,400)
If mylink.mynumber1 contains the number 352 and mylink.mynumber2 contains the number 400, then the following two functions are equivalent, and return the value 240
Not(5-5)If mylink.myexpression contains the expression 5–5, then the following two functions are equivalent, and return the value 1
SetBit(356,”2,4,8″,1)If mylink.origfield contains the number 352, mylink.bitlist contains the list “2,4,8”, and mylink.bitstate contains the value 1, then the following two functions are equivalent, and return the value 494

Leave a Reply