Rejected Data as Table

For creating Rejected table, we are using a copy statement such as below (v7.2.3-2)


copy reject_1(test) from stdin rejected data as table schema.reject_table;



This is used to just to get the rejected table created both in Prod and DR. However, this on-the-fly DDL seems to be different in Prod than in DR.


rejected_data column has shown up as 'varchar' in Prod but as 'long varchar' in DR. Both are created at the same time. I did not see any parameter that we can set at system level that could cause this difference. 


Any thoughts?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file