DSXchange

Yes you could use Ereplace as well,

Ereplace(ColumnName,Char(13),"")

Thanks & Regards
Mahesh

Hi, Thanks again for your thoughts, The problem is the special characters are in the string and this is not a Individual alphabet and I doubt whether I could take a risk of converting sensitive information. But I just found from Ascential Support that some company's have rasied a E Case ticket for t...

Hi, Thanks for your thoughts, These are a few alphabets which I have given as an example they are lot many. The NLS Setting we have been currently using is ISO Standard and in some case we have been using PC852 but this will help us to resolve for 80% of the data but the rest 20% are also sensitive ...

Hi All, I have been a special case / issue with respect to the Source Data, I am currently working on the Baltic's Countries and I have found a strange issue which is as follows: Č Ū 1. Could anybody please tell me what kind of NL Setting is suitable to get the data in a Proper way. 2. Could anybody...

Hi All, Thanks for all your valuable suggestions, we have resolved this issue. Just to share what we did, We had asked the UNIX Admin person to change the Kernal parameters as per Ascential support request and they have done the necessay changes and then we stopped and restarted the DS Services and ...

Can you check who owns the directory mentioned in your /.dshome file. Also check the permissions of its sub-directories. I believe there is some kind of permission issue(s) in your setup that is preventing datastage from starting. What happens when you issue the command 'netstat -na | grep 31538' ?...

Hi Sainath, ************** You need to start/stop DataStage as dsadm rather than root. Did you load dsenv before starting the DataStage Engine? ************ As stated, I have loaded the dsenv variables before starting the DS server. If I goto dsadm and do a DS Start then asks for a passoword so I lo...

Hi All, Thank you for your valuable sugeestions, I have done the necessary checks and they have installed the DS Server as root and there were a few permission issues which I checked and corrected. the dsenv file is in the "dsadm" owner and group. Now after checking and correcting as state...

Hi All, The regarding a new issue which i seen for the first time. The problem is somebody has installed DS Server on the HP-UX box and I installed DS Client and tried to connect to the Server for the first time, it gives me the following error: Failed to connect to host: <server_name>, project: UV ...

Hi All,

Thanks you for your comments.

With Regards
Mahesh

Hi All, Could anyone please explain what exactly the following message means ----------------------------------------------- *** No output from command *** The following parameters in the call to DSSendMail were not mentioned in the file 'dssendmail_template.txt': server ----------------------------...

Hi All,

Thanks you for your valuable suggestions, As we were not able to do an export , We have done the necessary clean up now and imported the previous back up taken and seems to be fine.

Thanks & Regards
Mahesh

Hi All, I have checked the Permissions, the Owners and the Group there is not change at all. I have also checked for the disk space on the box there was enough space. there are couple of projects which use DS on the same Box. Thanks again for all your valuable suggestions. Thanks & Regards Mahesh

Hi All,

There was no change to the group done or to any users, as Kim said nothing has been done. The Projects were working fine all off sudden we started facing this issue.

Thanks & Regards
Mahesh

Hi Sainath,

Nops, The Project was not moved as such, and The project was created by granting permissions for a specific set of users who are going to use work on the Project.


Thanks & Regards
M