DSXchange

Thanks Chulett,

This mkdbfile comment has many parameters, how to know these parameters information.

Could you please help me to get this.

Thanks

Hi, I have a requirement in my project to create a hash file in a specified directory with the given name, I tried to create hash file through CREATE.FILE FILENAME command from TCL and it is creating the file at project directory only. When I was trying to prefix the directory name with the file nam...

Yes reject link is having sqlcode column, but no limitations for warnings/rows in job as well as reject links.

I changed the array size as 1 and now it is throwing the below error

Target_Oracle_Entp,0: Open failed for insert:
insert is: <<insert SQL statement >>
sqlcode is: -2290
esql complaint: ORA-02290: check constraint (Target table constraint) violated

Thanks

Hi,

The job is running fine with sequence execution mode (Basic transformer execution mode option is Sequence).

Can anyone please explain it in detail.

Thanks,

Hi, My job design is Oracle ----> Basic_Transformer ----> Orcale Extracting data from oracle passing through Basic_Transformer and loaded into Oracle table. But this is failed because of the following error node_node1: Player 1 terminated unexpectedly. main_program: Unexpected exit status 1 Unexpect...

Hi,

Is there any command to get the list of currently running jobs (including instances) from a particular project.

Thanks,

Thanks Len, Its working fine.

But now my source is also having other than Chinese and English characters (like Swedish), is there any options to support all these languages.

Thanks,

Hi Ray/Lengreenwwood, We tried as Ray had suggested and the code worked out successfully. We set the NLS setting as MS-936-CS . But even after setting the NLS map according to the code given by LenGreenWood,we are still not able to view the chinese characters as such by clicking on "view data&q...

Hi, We tried as Ray had suggested and the code worked out successfully. We set the NLS setting as MS-936-CS . But even after setting the NLS map according to the code given by LenGreenWood,we are still not able to view the chinese characters as such by clicking on "view data" option in our...

Hi, The error that we got is as below: Unable to opn "NLS.CLIENT.MAPS" file. Our UVACCOUNT path is set to c:\Datastage\engine.In this folder we have an VOC file which has NLS.CLIENT.MAPS defined in it . But the dssh through which we executed is available in c:\Datastage\engine\bin(not the ...

Hi Ray... I checked the UV.ACCOUNTS table in the command box of the DS Administrator.The UVACCOUNT is set to the path "c:\#directory path#\engine" whereas the dssh.exe application is available in "c:\#directory path#\engine\bin" path. I am doubting that this might be the reason f...

We have changed our system settings to incorporate chinese characters. By this I meant I have enabled/checked the option "Install East Asian Languages" in the Date, Time, Language, and Regional Options dialog box inside control panel. Please let us know if any other settings have to be ch...

Hi LenGreenwood, We are also having the same requirement of handling chinese characters.We have changed our system settings to incorporate chinese characters.We are able to get the chinese characters as it is in the output file.But we are not able to see them when we choose view data option in datas...

Thanks Ray and chulett,

I didn't give any limits during run time for both warning and row tabs, also no values like abort after this much rows has been processed in job level.

Thanks, Ragu