There is a mainframe MLOAD job , the source file has spaces for a 'prd_cd' value . when i query the table i am not seeing spaces for prd_cd they are all '0'. There is no default value set , or any kind of manipulation in the load . Can you please help me understand how are these spaces loaded as '0' into the table
The Mload is coded
It is a direct insert in the load step.
The column defn for the PRD_CD is SMALLINT NOT NULL COMPRESS 0 .