DSXchange

Do the UV tables that DataStage Operates on, has any limit for space it can actually hold

We have some 3 lac records (of size 1.2 GB) that are added to the table and the table is looked up for.

In the process of writing from the transformer stage to the UV table it throws an error stating "An illegal SQL data type was supplied"
It is able to write few records and update few but rejects most . is it because it is not able to hold any more data?

can someone help me with this?

The limit is at least 2GB so it's not that.

Please post the entire error message, which will show you the query and the column about which it was complaining.