I have a fixed length file which i get on a monthly basis to load into a database.
It has many fields and an end field called "End_Col".
This End_Col field is defined as 20 characters, but may be 20 or less than 20 in length.
Can we dynamically adjust its length and load into the table? Or, can we ignore this field altogether?