Page 1 of 1
Where can I enable the NLS setting???
Posted: Mon Oct 22, 2007 9:01 pm
by ICE
Dear All,
May I know where can I enable the NLS setting so that I can use NVarchar data type???
Thanks,
Posted: Mon Oct 22, 2007 10:15 pm
by ray.wurlod
Look in the uvconfig file for a tunable called NLSMODE. If it is there, set it to 1 and restart DataStage. If it is not there you will need to re-install the DataStage server, this time with NLS enabled.
Posted: Mon Oct 22, 2007 11:04 pm
by vanathy
After National Language Support has been installed, to enable NLS set the NLSMODE uvconfig parameter to 1 and Please run uvregen and DBsetup to pick up uvconfig changes.
Enter NLS database administration via the menu NLS.ADMIN.
Posted: Mon Oct 22, 2007 11:57 pm
by ICE
Dear Ray,
This is the production live server:(
Do I need to uninstall in order to reinstall the server???
I am afraid to do that so.
Thanks,
ray.wurlod wrote:Look in the uvconfig file for a tunable called NLSMODE. If it is there, set it to 1 and restart DataStage. If it is not there you will need to re-install the DataStage server, this time with NLS ena ...
Posted: Tue Oct 23, 2007 12:49 am
by ArndW
No, you do not need to un-install in order to re-install DataStage. I would recommend trying this first on your development server, including taking backups and making sure that they are successful.
Posted: Tue Oct 23, 2007 1:12 am
by ray.wurlod
You will need to reinstall the production server if NLS is not installed and you want to use NLS. You would do well to read the DataStage NLS manual first since you appear to be unacquainted with it. As Arnd points out, you do not need to uninstall to re-install DataStage server at the same version.
Posted: Tue Oct 23, 2007 2:10 am
by ICE
Dear Armdw,
So, do you mean I just need to rerun the installer?
Thnaks,
ArndW wrote:No, you do not need to un-install in order to re-install DataStage. I would recommend trying this first on your development server, including taking backups and making sure that they are successful.
Posted: Tue Oct 23, 2007 2:24 am
by ArndW
re-running the installer and specifying NLS will do what you requested, but you really should follow what Ray just suggested and go through the documentation. Once you have NLS you cannot go back.
Posted: Tue Oct 23, 2007 6:36 am
by chulett
Are you
absolutely certain you need to do this?
Posted: Tue Oct 23, 2007 7:53 am
by ogmios
And wasn't NLS only included as of 6.x ... I don't recall 4.0 (as in the OP) having NLS at all.
Also having NLS won't solve all of your data problems. Since for a lot of databases you can only include one "home instance" like DB2 e.g. if you have to write to databases using different encodings you will still have a problem if the encoding is determine by the database client.
Posted: Tue Oct 23, 2007 7:55 am
by chulett
ICE - Is this in response to your other thread?
viewtopic.php?t=113918
Posted: Tue Oct 23, 2007 3:17 pm
by ray.wurlod
.
ogmios wrote:And wasn't NLS only included as of 6.x ... I don't recall 4.0 (as in the OP) having NLS at all.
The first version of DataStage to have NLS was 2.5, the next was 3.6, then every version after that (except x.0 versions) has had NLS capability.
Posted: Tue Oct 23, 2007 3:18 pm
by ray.wurlod
.
ogmios wrote:And wasn't NLS only included as of 6.x ... I don't recall 4.0 (as in the OP) having NLS at all.
The first version of DataStage to have NLS was 2.5, the next was 3.6, then every version after that (except x.0 versions) has had NLS capability.
Posted: Wed Oct 24, 2007 12:06 am
by ICE
Dear Chultt,
Yes. I would like to find out the problem whether my problem is because of NVarchar data type.
But now I realized that this is not the problem actually.
Yesterday I asked the SQL server team to change their data type to Varchar and tried to run my job but the problem is still there.
I can update only one row at a time. If there is 6 rows, the job updated for only one row and the other 5 rows were rejected with fractional truncation warning msg.
But if I select only one specific row from those 6 rows and tried to update, the job can update to the database.
Still I don't find the problem. I already check all the data type and length and used the same data type and length. But the problem is still here.
Do you think it is the SQL server problem?
I already have the update job with DB2 and I never see this problem before.
Is there anybody have any idea please???
Thanks in advance,
ICE
Posted: Wed Oct 24, 2007 7:29 am
by chulett
Pretty much what I thought, this wasn't going to solve your problem just create oodles of new ones. Please mark this thread as Resolved and add your latest explanation / questions to the original thread so we can continue the conversation over there, not here.