
AUTOCOMMIT Variable Overrides COPY Command NO COMMIT Option!
According to the documentation, the NO COMMIT option of the COPY command “Prevents the COPY statement from committing its transaction automatically when it finishes copying data.” However, that’s not the case if the AUTOCOMMIT variable is set to ‘on’… Example: I have a table named JULES that I will load 3 records into using the […]
Read more
Recent Comments