Welcome aboard.
What are the NLS settings for this stage/job?
Issue with nChar in Datastage 11.3
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3
- Joined: Thu Jun 11, 2015 11:26 am
-
- Participant
- Posts: 3
- Joined: Thu Jun 11, 2015 11:26 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There's obviously some kind of problem with the data in the NEW_STATUS field.
Apart from the mismatched quote, the hex representation looks OK (all of the byte representations are below 256).
What do you see for this value when you select directly from Oracle, for example using TOAD?
Apart from the mismatched quote, the hex representation looks OK (all of the byte representations are below 256).
What do you see for this value when you select directly from Oracle, for example using TOAD?
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.