AnsweredAssumed Answered

Import into database drops leading zeros

Question asked by Lowell on Aug 9, 2016
Latest reply on Aug 10, 2016 by Lowell

Hi All,

I have a GEL import script that drops the leading zeros in the data.  Is there a way to retain those leading zeros?

 

Would I need to wrap the items in some function?

The field is "varchar" in the database.

0405 becomes 405

 

 

      <core:forEach begin="1" items="${input.rows}" trim="false" var="row">
        <core:catch var="ex2">

          <sql:update>
             INSERT INTO trg_lawson_data_stage
            (LOAD_DATE,COSTCNTR,COST_CODE_ID)

             VALUES (?)
            <sql:param value="${row[4]}"/>
          </sql:update>

 

Thanks!

Outcomes