Field in data file exceeds maximum length)
Posted: Thu Aug 28, 2008 7:56 pm
I am trying to load an oracle table through datastage Enterprise. It uses SQL loader to load this table from a pipe generated control file. I have a field which is rejecting that record which is description, currently it is varchar2 (1000), the characters are no way near hitting 1000 characters, but this is not the problem for any other column, i only get (Field in data file exceeds maximum length) for some of the records. I know there is a limitation(255chars) on varchar fields if there is no length defined in the control file. Solution is to modify the length to 1000 in the control file. Is there any setting in adminstrator that actually tells the control file to use the schema from the DS job. Can we modify this field lenght in the control file some how?
can anyone help in any way please!!!!
can anyone help in any way please!!!!