Print this page

 

If you need to pad a field with leading zeros, the following ESQL is a simple technique for WMB:

SET OutputRoot.XMLNSC.ns:field = RIGHT( ('000000000' || CAST(InputRoot.ns:fieldIn AS CHARACTER)), 10);

This is particularly when a schema specifies Integer, causing leading zeros to be dropped.