When the DB2 access service detects an unequal number of columns between the source and the target, a structural error can occur.
For bulk copy transfer:
If the number of source columns exceeds the number of target columns, the DB2 access service cancels the transfer.
If the number of target columns exceeds the number of source columns, processing continues if all of the extra columns of the target table accept nulls. If any one of the extra columns in the destination table does not accept nulls, the DB2 access service cancels the transfer.
For destination-template transfer:
If the number of columns returned by the sourceselectstatement exceeds the number of question marks in the destination-template transfer statement, the DB2 access service cancels the transfer.
If the number of question marks in the destination-template transfer statement exceeds the number of source columns, the keyword null replaces the extra question marks for each row of the transfer.
