DSXchange

Hi, is there a way to pad leading zeroes to a smallint field within a prallel job? Target is also smallint. Can have values 01 or 1. We always want a leading zeroes so need to make sure the field is always padded, so the 1 become 01. Thanks for your help.

See if this helps:

viewtopic.php?t=136356&highlight=leading+zeroes

use str function for pad chars leading or trailing

my target and source is an integer. How can I pad leading zeroes when my source and target datatypes are integer?

Marley777 wrote:my target and source is an integer. How can I pad leading zeroes when my source and target datatypes are integer?

use transformer, Stage variable , convert into char or var-char , then pad it, then again covert into intiger

Integers are stored in binary form. You can not expect leading zeroes to be preserved. Only the value is stored. To display with leading zeroes you must use a string data type.

If nothing else this thread is good for a laugh

Changed output to character. This works for us. Thanks everyone.

I might suggest that whomever set the resolution status of this thread to "WORKAROUND" change it to "RESOLVED" since workaraound implies that there is a problem with small int and integers in that they cannot be zero padded.

Converting it to a character and padding that STRING with zero's is the only solution and is not a workaround.

Changed to resolved. Thanks.