Hi,
I am loading data to oracle database using Oracle connector stage as my target.
The source column is varchar 20 and target oracle column is varchar2(10).
I have put a reject link from the target oracle connector stage and have checked the data truncation errors check box in the reject link. But the source records that have data greater than 10 characters are also getting loaded into the target table when actually they need to be rejected. I am using Insert mode to load the records.
Below is the job design
File->Transformer--------->OracleConnector-->RejectLinktoFile
Is any configuration missing in the oracle connector stage or is any environment variable needs to be set?
Oracle connector stage not rejecting data truncations errors
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can you try an INSERT statement with more than ten characters into this field using some other client, such as TOAD or Data Studio? If Oracle will accept (and, presumably, truncate) over-length strings, then DataStage cannot detect in the Oracle Connector that this problem has occurred.
You may be able to raise the level of error reporting in Oracle.
Otherwise, you could reject these rows in your Transformer stage.
You may be able to raise the level of error reporting in Oracle.
Otherwise, you could reject these rows in your Transformer stage.
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.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I assume DataStage is truncating the data before it sends it to Oracle and thus avoiding the error. Do you see any truncate warning messages in the DataStage job log?
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
When I increase the length of the field ()i.e varchar 15) in the Input tab of Oracle connector, then the record gets rejected from Oracle connector stage.
Yes even I think DataStage is truncating the data before sending it to Oracle but I dont see any warning messages in the log.
Is there any patch/environment variable setting to supress this truncation?
Yes even I think DataStage is truncating the data before sending it to Oracle but I dont see any warning messages in the log.
Is there any patch/environment variable setting to supress this truncation?