https://communities.sas.com/t5/SAS-Data-Management/Disable-Warning-for-not-mapped-columns-in-Db2-bulk-loader-in-SAS/m-p/359566#M10807 <P>Why don't you want/can't you map all columns?</P> <P>If this because that you some sort of automatic constraint, I&nbsp;think that the IGNORE_RED_ONLY_COLUMNS option.might help.</P> Thu, 18 May 2017 08:14:01 GMT LinusH 2017-05-18T08:14:01Z https://communities.sas.com/t5/SAS-Data-Management/Disable-Warning-for-not-mapped-columns-in-Db2-bulk-loader-in-SAS/m-p/359559#M10806 <P>Hi Experts,</P><P>&nbsp;</P><P>I need some help reagrding Db2 bulk loader warning.</P><P>I am using Source to target load by Db2 bulk loader.</P><P>Source have 5 columns and Target have 5 columns , but I want to map only 4 columns from sorucen to target.</P><P>1 columns is not needed.</P><P>&nbsp;</P><P>So when I am using Db2 bulk loader, I am getting warning, like .</P><P>&nbsp;</P><P>XXXX column was not found on data file.</P><P>&nbsp;</P><P>please help me how to disable this warning.</P> Thu, 18 May 2017 07:53:48 GMT https://communities.sas.com/t5/SAS-Data-Management/Disable-Warning-for-not-mapped-columns-in-Db2-bulk-loader-in-SAS/m-p/359559#M10806 Riteshdell 2017-05-18T07:53:48Z https://communities.sas.com/t5/SAS-Data-Management/Disable-Warning-for-not-mapped-columns-in-Db2-bulk-loader-in-SAS/m-p/359566#M10807 <P>Why don't you want/can't you map all columns?</P> <P>If this because that you some sort of automatic constraint, I&nbsp;think that the IGNORE_RED_ONLY_COLUMNS option.might help.</P> Thu, 18 May 2017 08:14:01 GMT https://communities.sas.com/t5/SAS-Data-Management/Disable-Warning-for-not-mapped-columns-in-Db2-bulk-loader-in-SAS/m-p/359566#M10807 LinusH 2017-05-18T08:14:01Z