DSXchange

Thanks for Replay,

I tried in both the ways but still i am unable to view the compilation box after compiling the job.

Hi,

I am unable to view the confirmation window after compiling the Job, Is there any setting to view it?

Due to this issue i am unable to know whether the job had compiled or not.


Thanks in advance

Thanks every one

Sreeni,
Thanks, i know abbreviation of NLS but i don't know the unicode issue as Andy mentioned.

Kalyan,

In Datastage 7.5 there was no stage to connect MYSQL, is it true?

Andy,
Could you please explain me the NLS issue? I am not aware of it.

Ray, Thanks for responding to my request, I never worked MYSQL as source before could you suggest me which stage would be better to serve my purpose (Javaclient or ODBC) as i explained above. If I want to use JavaClient could you explain the advantages/disadvantages and same with ODBC. Once again th...

Kalyan,
Thanks for your response, in our organisation they are using mostly JavaClient to connect MYSQL Database, I never used that stage before so i thought of use this stage as source to connect MYSQL.
Do you have any idea about this stage??

In our current project we are extracting data from MYSQL database by using Unix Scripts then scheduled by CRONTAB. The out file is then transferred through PM4 Data Transfer to ETL server then it is loaded into TeraData Database. Unix Script: #!/bin/sh #----------------------------------------------...

Thanks a lot for response Andy and Ray. I am trying to collect all the issues related to migration as we are planing to do it in couple of weeks.

Do any one faced any issues while migrating from 8.1 to 8.5?

Right now we are using V-8.1 and planing to migrate to 8.5, can any one explain the advantages of upgrading please and are there any problems with the new Version-8.5?