DSXchange

Can anyone tell me how I would represent a hex constant in the where predicate of a filter stage?

var_x = 'E3'xb is the equivalent Teradata expression. And I get the feeling osh will throw up on this.

Thanks.

Convert it to decimal. E3 becomes 227.

ray.wurlod wrote:Convert it to decimal. E3 becomes 227.

You mean like with a Modify stage beforehand?

No, I mean manually when designing the job.