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
USING FILL1 (CHAR(01))
,PRD_CD (CHAR(05)) --> column in discussion
INSERT INTO JERPD1CV.CNTCT_NB
,:PRD_CD --> col in Discussion
It is a direct insert in the load step.
The column defn for the PRD_CD is SMALLINT NOT NULL COMPRESS 0 .