VARCHAR converting to NVARCHAR
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Tue Nov 27, 2007 10:59 pm
VARCHAR converting to NVARCHAR
Hi,
When i am using Run Time Column propagation, all the columns having data type VARCHAR are converting to NVARCHAR. I do not want to convert the datatype.
I need to stop this in job level not in administrator level. Is it possible? Please let me know.
Thanks,
Sreeram
When i am using Run Time Column propagation, all the columns having data type VARCHAR are converting to NVARCHAR. I do not want to convert the datatype.
I need to stop this in job level not in administrator level. Is it possible? Please let me know.
Thanks,
Sreeram
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
-
- Participant
- Posts: 9
- Joined: Tue Nov 27, 2007 10:59 pm
-
- Participant
- Posts: 9
- Joined: Tue Nov 27, 2007 10:59 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I am guessing that you have NLS enabled, and that therefore DataStage is expecting to work with Unicode data and will take every opportunity (such as during runtime column propagation) to do so.
If you don't like it, disable RCP and specify your data types explicitly.
If you don't like it, disable RCP and specify your data types explicitly.
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: 9
- Joined: Tue Nov 27, 2007 10:59 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 9
- Joined: Tue Nov 27, 2007 10:59 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: