DSXchange

if you want to see summary log report, you can also use
dsjobreport, which can be called either before job subroutine or after sub routine.
see help file for more details

ray.wurlod wrote:It may be that Sprint does not extend to South Africa, but most mobile phone providers have a similar service. ...

Thanks Ray
I will check that and will send SMS at ray.craig.ArndW@dsxchange.com

Hi, We are in process of calculating effort estimates of rework in our development due to target datamodel changes. Changing one field in target model has cascading impact on other jobs due to dependency.There is almost 300+ jobs. Manual process for this would be very time consuming. So We want to c...

Thanks Ray and ArndW for sharing this!


Thanks and Regards,
Rafik

Thanks ArndW and Craig for sharing valuable information.

I will test the jobs and will let know the outcomes.

Thanks and Regards,
Rafikul

Hi All, We have created one main sequence job which inturn calls another 15 inner sequence jobs. There is almost total 250 jobs in the sequence and which takes almost 24 hours to finish. My requirement is to send status (success/abort/fail) SMS message upon completion of each inner sequence jobs. Co...

Hi All, I have one general question on DS, Apologies if it seems silly question? Basically I want know 1) which file in ds server controls the process like allocation,deallocation of resources to stages/jobs etc ? 2) how the processes are managed ? 3) How resource allocation is done at OS level and ...

You can get certification information on the following link

http://www.squidoo.com/datastage

http://www-03.ibm.com/certify/certs/iisdwsdev75.shtml

I am not sure whether is it possible or not? I have input data set of customers information for different region like North,South,West,North_West etc. My requirement is to create exactly one output file for each region. I am not sure how many region would be at the time of reading input file. Based ...

Thanks a lot Ray!
Using SETFILE command,I set a VOC pointer of the file and
It's working fine

But when I use account name insted of directory path for hashed file, I don't need to set it

Thanks

Thanks Ray and Craig for your input!
I would appreciate if somebody helps me to find solution of my original post

Thanks Ray!
I need to read all 3 variable

Parameter name,prompt,value

from first line and their corresponding value from 2nd file.

Can you pleae let me know or give me hints how to acheive this?
I believe I will have write the routine, but don't know the actual syntax of reading text file.

Thanks

we are receiving international data Is there any spceail charachter set you are receiving? You need to check for your project's NLS map and collation locale setting. If you get any error due to unhandling of special character while running job, then you need to set appropriate setting for your proj...

Hi, I want to read paramter from text file and use the value of paramter in my job. Example FileName is parameter Parameter name,prompt,value domain_name,Enter value name domain, electricity I tried searching in archive, but failed to get desired result. Please let me know any reference of previous ...

Thanks Ray!
Ray,Craig: This is my requirement where I want to count no. of records reading from the source(in may case hashed file) and compare with records count loaded into target database db2.

I am reusing the hashed which was created by other job.