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?
UV Table
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Please post the entire error message, which will show you the query and the column about which it was complaining.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.