DSXchange

Hi Abhilash,

If no other option works, try releasing the job from manager.

Go to DS Manager.select the job,click on Tools -> release job

this would create a replica of the job.

we had it worked out when we faced the same problem.

just try out !!

Hi ArndW, I intented as column1 and column2.However both the columns have same name.I should have written the code a bit more clear.Below is the code.The left hand side convert is related to the source data conversion and the right hand side convert is related to the lookup data conversion. If(UpCas...

I have a requirement such that If I have two strings(one from source and one from lookup). I have to compare them for equality and case insensitivity.If both the strings are not equal in every aspect,then the string from the source should be loaded to target. The code which I used before was If upca...

Thank You Very Much for your help. I tried to use convert as you told and it worked fine. However,now I have a requirement such that If I have two strings(one from source and one from lookup). I have to compare them for equality and case insensitivity.If both the strings are not equal in every aspec...

We are using server jobs on DS 7.5.1.

My requirement is to get only the characters from the string.

Please let me know how to find out unprinted characters in a string.

I tried to use TrimB,TrimL but in vain.I used other options like L,T,B,F,E,D.However 4 values continue to show.

Hi, I have a requirement which needs the following output. If have a string as " XXX YYY ZZZ" ,the output should be XXXYYYZZZ.The output should not have any spaces,tabs,nulls.IT should return only all the characters what it contains. I tried the option of trim("XXX YYY ZZZ","...

yes.we have access to DS_LICENSE.

Hi, We are facing problem when trying to connect to the projects in all the DS components(Designer,director,manager,administrator). While trying to open the projects from these windows,the error window shown is "Cannot open file DS_LICENSE" Apart from the above error ,one of the projects i...

Hi Kumar, As I am currently working on Datastage 7.5 server jobs,I thought of having some certification related to this area as well as DW concepts. However as the server jobs certification is not yet released,I would go for either TDWI Certification for DW or IBM's DS Certification. Thank You Much ...

Thank You Very Much all of you ..

I got a lot of information and I will give a try for these exams

yes I searched that search engine before.I agree that it provide us a wealth of information. However I could not find any certification information related to Server Jobs.(Probably not released!!) Hence I was a bit curious to know if any certification for server jobs is available and any updates reg...

Hi

Please help me in getting the information related to certifications for datawarehousing as well as datastage.

Thanks Much.

If you want the patch file,contact the IBM Support at WDISupport@us.ibm.com.

DSGetLogSummary function may help!

You can create a procedure which contains the SQL related to dropping and re creating the indexes.

From the datastage job,you can call the procedure.