SQLServer has NChar but Datastage does not have NLS

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Thamilton
Participant
Posts: 2
Joined: Mon Apr 17, 2006 2:23 pm

SQLServer has NChar but Datastage does not have NLS

Post by Thamilton »

I need to read/write to a table with columns that are NVarchar & NChar. This is a database froma vendor. We don't have the need to implement these datatypes in our day to day business.

Is there a way to read/write to the columns without installing NLS?
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Just switch NVARCHAR to VARCHAR and NCHAR to CHAR in your job.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
Post Reply

Return to “General”