DSXchange

Then how to handle this ???

HI,

is there any function in PX Transformer to replace a character, one character replaces to three characters in a string , like 'A' Should replace 'XYZ'.
Convert function is not working in this case .

I used Wait for activity stage to check existence of file, its working fine.


Thanks for respond.

How to check the Existence of file in sequence jobs,'

if file exist then sequencer should run other wise ends successfully

Hi ,
Am working on ds 7.5.2 Server jobs
is there any function to find out the difference between dates it results completed years in 7.5.2 Server jobs

Am not supposed to call this script through job control tab.

Hi,

i have an requirement to create a datastage job to call sql script with in job but this is an external SQL script it should not be imbeeded in job control tab of ds job.

Any suggestions how to call this script in ds job.

Hi , am working on the version of Ds 7.5 server jobs, we have a three servers to mintain our ds jobs(more than 2500), same copy of jobs were maintained in three servers. my client side people found out some huge diference in ds jobs available on three servers. so they just want to know what is the d...

Thanks for your reply,

am aware of datastage having two UV tables like
DS_JOBS and DS_OBJECTES but am not sure what information contains both tables.if posssible can you just guide me any info on this

Hi ,

could you please any one clarify me where i need to find out UV Tables information( means table information)

Hi all, i have an requirement like to bulid a one script for validating fileds in all tablesby with below syntax.. ----<FILELD_NAME> INSERT INTO VALIDATION SELECT CASE WHEN (select count(*) from <TABLE_NAME> where <FILELD_NAME>is not null and <FILELD_NAME>>' ') > 0 THEN 'PASS' ELSE 'FAIL' END"R...

Hi all, i just plan to implement a surrogate key in my SCD jobs, i have three approches like 1)Database sequencer 2)Using lookup Stage by getting the max Suurogate key for a particular table 3)Call a parallel routine. Can any clarify me which approach is Better to implement ,Datbase we used is Sqlse...

No, thats wrong

Hi,

can you just tel me if any one aware of the mean of datastage is down

actually my requirement is delete some data in hashed file, so i used uv stage to doing that . i can get the hashed data through the select statement but not sure where to wwrite delete query, even if i use userdefined sequel to delete records its not working