DSXchange

Thanks a lot for the reply, but i just want to have the combination of the 1 and zero for the length of 15 and every combination must be unique.for example 100000000000000 000000000000001 000000000000011 000000000001111 and so on. We have to use 1 and 0 only and the length is 15 so 2 power 15=32768 ...

I have to generate a file with two columns (ID and COMB). ID must contain a sequence number so Integer data type.(I took care of that). COMB column must have the data like this. ( it can be numeric or string) 111111111111111 111111111111110 111111111111100 and so on. The size is 15 and it must have ...

I built a script which ckecks the status for all datastage jobs in a project and clears the log if the status of the job is successful. I used the "CLEAR.FILE RT_LOG" $project_name $job_name which is throwing an error as "Unable to clear file RT_LOG." I heard that CLEAR.FILE comm...

I want to clear the datastage job log using a unix script

I am sorry, for changing the requirement, but the second time posted is my exact requirement. Can you help me in that regard? I am new to unix and even dont know how to write a script.. So, it will be helpful for me a lot if you send that script to me....

I want the script for the second part. that is for this condition "If it is a successful job then the log must be fully cleared, If it is an aborted job, then the log must clear for just one day."

Need a customized unix script to purge the log in data stage. The only condition is,if it is a successful job then the log must clear for just one day, If it is an aborted job, then the log must be fully cleared.

ok....Can you tell me the after-job subroutine for the above function which i specified earlier........

Hi I am working on Datastage V8.1 parallel Jobs. Can anybody please provide me a parallel routine for reconcilitation purpose. The functioality which i need in the routine is It must compare the count of input records from the source link and count of output records to the target link. If both are e...

I have a server routine which is using in a job sequence, I want to capture the return value from the routine and save it in a textfile. ReconLinkCount(jobname,stagename,linkname) #include DSINCLUDE JOBCONTROL.H Ans = 0 ThisJob = jobname ThisStage = stagename ThisLink = linkname JobHandle = DSAttach...

Where and how can i call this routine kirtikumar?

Can anybody share a subroutine which returns the count from the source stage link and to a target stage link and to a reject stage link. It is very urgent.

1.I AM GETTING 3 COLUMNS FROM SOURCE (xx) P_TYPE S_TYPE POLICY_NUMBER. 2.I have 3 cols coming from reference(yy) p_type s_type product_code 3.I need to do this xx.p_type=yy.p_type and xx.s_type=yy.s_type and populate the product_code. 4.If the product_code is null then i need to look up on another (...

Hi Folks I want to generate a surrogatekey directly in a table i mean neither using a flatfile nor using a database sequence.How is it possible and which properties i have to fill with what? say my colnume for surrogatekey is ID_NUMBER Number(25,0) PK and table name is TABLENAME. The efforts will be...

"DsJobStartTimestamp[1,7]" means current timestamp?