We imported a table definition of a table through ODBC. When we changed the column width for one table and tried to import it again with the same name(i.e replaced the table definition), the length of the column did not change.It shows the same definition as it had earlier. We tried many times, but there is no change.Any thoughts about what the reason could be and how to rectify it.
I tried to re-import the definition, but it still shows up the same old column length. If i manually change it , still i am not able to insert the data in that particular column as it still refers to the old one.
I tried to re-import the definition, but it still shows up the same old column length. If i manually change it , still i am not able to insert the data in that particular column as it still refers to the old one.
This turned out to be an issue with the table that was created. We found out that We had not changed the field value in the table, and no issues with datastage.