Page 1 of 1

Problem facing while Import Old Version 6.1 Jobs

Posted: Tue Sep 14, 2004 6:53 am
by thirupri
Gurus,
We have DataStage 6.0 and DataStage 7.1 in different server. I want one job to be moved to the new version 7.1. So I exported the job from the old version 6.1 and while importing to 7.1. I am getting NLS Code page error. If any one did it already can you advice me.

Thanks with Regards,

Posted: Tue Sep 14, 2004 6:58 am
by chulett
You might want to post the error in its entirety, that may help. I would guess that either one server has NLS installed and the other doesn't or they are not setup with the same code page.

Posted: Tue Sep 14, 2004 7:23 am
by thirupri
Thanks C.Hulett. Here error message appears as follows:

"File L:\Jihad\DSExportcustquery.dsx can only be imported when the client code page is 1252 - it is currently 1256


File L:\Jihad\DSExportcustquery.dsx does not appear to be a valid DataStage export file or is from an incompatible release.

A valid DataStage export file is expected to be in Windows format (i.e. using CRLF line terminators).


Thanks with Regards,

Posted: Tue Sep 14, 2004 7:46 am
by tonystark622
I'm reasonably sure that you can edit the DSX file and change the code page to 1252 then try to import it.

You should try to sync up the code pages, though, unless they're different for a reason.

Tony

Posted: Tue Sep 14, 2004 7:56 am
by thirupri
Thanks Tonystark. I edited the DSX File and changed the code page from 1252 to 1256 and imported it. It's working fine.

Thanks to all.

Regards,