Pad leading zeroes to a smallint field

Marley777 · Post by **Marley777** » Mon Oct 25, 2010 11:02 am

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.

vivekgadwal · Post by **vivekgadwal** » Mon Oct 25, 2010 11:23 am

See if this helps:

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

n.parameswara.reddy@accen · Mon Oct 25, 2010 11:29 am

use str function for pad chars leading or trailing

Marley777 · Post by **Marley777** » Mon Oct 25, 2010 11:51 am

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

n.parameswara.reddy@accen · Mon Oct 25, 2010 11:58 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Oct 25, 2010 12:59 pm

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.

mhester · Post by **mhester** » Mon Oct 25, 2010 1:45 pm

If nothing else this thread is good for a laugh

Marley777 · Post by **Marley777** » Wed Oct 27, 2010 2:01 pm

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

mhester · Post by **mhester** » Wed Oct 27, 2010 2:05 pm

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.

Marley777 · Post by **Marley777** » Wed Oct 27, 2010 2:10 pm

Changed to resolved. Thanks.