DSXchange

Dear Denzil

Thanks for your help.

I did not understand the step 2.3 and please explain me when to use Sequetial Stage & Hashed file stage.

best regards
Ramesh

Hi All, I have the following SQL query to be done using DataStage... SELECT distinct(Cd_corretor), Cd_administradora, Cd_filial,Dv_tipo_pessoa,Nm_endereco, Nm_bairro, Nm_municipio, Nm_uf, Nm_cep,Nm_fone,Nm_fax, Nm_corretor, Nm_email, Nm_endereco1,Nm_endereco2,a.Cd_uf,a.Cd_orgao_produtor,a.Dt_admissa...

I changed the SQL Type to VARCHAR in the Input link of the transformer stage, it worked.

Thanks
Ramesh

Hi Duke & Ray Thanks for your inputs. As you recommend I have left the data type of source & target fields to their defaults. The source field stores the values N or S of Data type NCHAR but when I check the target field (VARCHAR) in an Enterprise manager, I see a strange 'square' character....

Dear All, I'm novice to DataStage... I have problem converting data type, please help. I have a source field having SQL Type as NCHAR where as target field having SQL Type as VARCHAR, how can I do this in Transfaormer stage... doesn't look like existing built-in data type conversion will help. best ...