general nullif in external tables
696632Jan 6 2010 — edited Jan 7 2010I have an application that works with a lot of external tables based on supplied text files.
In the text files (on which I have no influence), if the field is empty, they use a weird utf8 character which I cannot determine, but the chr value of the field is 0 (Chr(0))
I know you can add nullif statements in the external tables, but that would mean adjusting all of the 100+ install files for all fields which is a helluva job.
Is there a general statement I can add to the create table statement that will replace the value chr(0) with Null for all fields in that table?