Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I skip a column when COPYing to an ODBC table ?

April 26, 2017column ODBC skip Table

0

Posted

Can I skip a column when COPYing to an ODBC table ?

1 Answer

0

Posted

Columns may be now be skipped when copying a record to an ODBC table. Normally when copying any record to a target table Warehouse writes every column to the target table. Fields not explicitly set by the script are internally initialized by Warehouse and the value set by Warehouse is written to the table. This method of writing causes the SQL target to bypass any default column values, since values are always set by Warehouse. The COPY statement has been enhanced to allow columns be skipped, thus causing the SQL default value to be used.