DSXchange

Hi, I need to clean email address based on soundex/phonetics approach. For example: 1. xyz@gmaill.com will be changed to xyz@gmail.com 2. xyz@gmaiill.com will be changed to xyz@gmail.com 3. xyz@yohoo.com will be changed to xyz@yahoo.com 4. xyz@ucla.ddu will be changed to xyz@ucla.edu If I can make u...

Can you please let me know how to do it?
Do I need to use Standardization stage and VEMAIL rule? If yes, pls let me know how can it be achieved. If not pls tell me the way to do it.

Hi, Our requirement is to correct misspelled email addresses. For example "xyz@gmaiil.com" should be changed to "xyz@gmail.com" "xyz@yohoo.com" should be changed to "xyz@yahoo.com" Can it be done through QualityStage? If yes, pls let me know or tell me other a...

Hi, We need to remove keywords like Jr, Sr, II, III etc from a field. For example: "Richard Headley SR" should be changed to "Richard Headley" "Richard SR Headley" should be changed to "Richard Headley" "Sr Richard Headley" should be changed to "...

Hi,

I want to know is there any DB2 function to convert LATIN1 format to UTF8 format?

Hi,
Is there any other way to convert LATIN1 format to UTF8?
Actually in datastage NLS is not enabled.
Please let me know any other solution.

Thanks,
Nasimul

Hi,
Our requirement is to ocnvert data from LATIN1 to UTF8 format? How can it be implemented throgh DataSage?
Please let me know if we have any other way to approach this problem?

Thanks,
Nasimul

Thanks Ray.
System variable @LOGNAME is not accepting.
Pls help.

I typed system variable @LOGNAME, but it is not accepting.

How to get User Name who runs the job?

How to retrieve user name who triggers the the datastage job?

I mean I need to trigger a job from a web page? lets say,server ip/hostname:=a, job name:=x, project:=y
How to run this job? Please suggest.

Thanks for reply.
Yes, i thought of it. To use dsjob, i need to telnet to the server and then invoke this command like "dsjob -run -jobstatus <params> <jobname> <project>". How can i do all these stuffs in a go?
Regards,
Nasim

Hi,
I need to trigger DataStage job through Web. Job parameters will be passed to job from the web page once the web request is submitted?
Can anyone provide some input on it?

Thanks & Regards,
Nasim

Sometimes one job is generating SIGSEGV error and sometimes it runs successfully. I couldn't get the problem why sometime it's running and sometimes it's aborting due to SIGSEGV.
Please share your knowledge, how to deal with this job?