Rejected Data as Table

Sam37

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?