Not bounded length

craviraj · Post by **craviraj** » Mon Oct 26, 2009 8:23 am

Hi,
I am getting the following error when I try to insert a text field. In Database it is defined as 'ntext'. When I import the table definition, I get it as LongNVarChar(3741823). I am not able to insert record(s) because it shows Fatal Error: Not bounded length when I try to insert a record.

Cases when it fails:
1) Hardcode value 'Test Insert' in transformer for this field.
2) Harcode value 'Test Insert' in a parameter (JPM_TEST) and assign the parameter value in the trasnformer to this field.

The job works fine if I hardcode the value in the Database query using the insert command. Any help about this is highly appreciated. My requirement is to pass the value in a parameter so that I can use the same job multiple times.

Thanks,
Raviraj

ArndW · Post by **ArndW** » Mon Oct 26, 2009 8:33 am

What is the SQL datatype for the column and are you using a DataStage "LongVarChar" definition? Have you tried just Varchar() ?

craviraj · Post by **craviraj** » Tue Oct 27, 2009 1:43 am

The SQL Datatype is 'ntext' (when I see the definition on SQL Server). Whan I import, I get it as LongNVarchar.

I have tried to use Varchar. The job still aborts.

craviraj · Post by **craviraj** » Tue Oct 27, 2009 1:45 am

The SQL Datatype is 'ntext' (when I see the definition on SQL Server). Whan I import, I get it as LongNVarchar.

I have tried to use Varchar. The job still aborts.