DSXchange

Thanks ray for the reply

Hi Chulett . I am just trying to automate a process which cleans the job logs periodically . Was trying to do it from a script

Hi
I am having trouble running a script whioch has command clear.file RT_LOG from Execute stage .
The output i get in the log is

: line 33: clear.file: command not found
128

You could set the Lookup condition to CONTINUE . Then for the matched Lookups the Lookup key value( MD_id ) becomes 0 nad non matched lookups <> 0 . Then with a transformer filer the Nonlooks and set the MD_id =-911 .Funnel both the Lookups and nonlooks with a funnel stage

Hi Chulett .
Any specific reasons for this ? I suppose it has got nothing to do with performance.I generally build my sql manually and supply it to the stage . Is this a wrong practice ??

hi raju ,
APT_STRING_PADCHAR. I usually set its value to 0*20 (space).and trim space if necessary ,thus keeping my string clean

Thanks Vamshi

vamsi.4a6 wrote:You can also try below command on unix prompt


dsjob -linkinfo <project> <job> <stage> <link>

Hi chulett we are still on 8.5 . I am using the dsjob utility to capture information and parse it .

Thanks for the info vcmburney.Thats interesting . But we are still on 8.5 .

Thanks a lot Prasson . thats helps me

Hi Chulett,
I have to insert the no of rows each DS job Inserts/update/Deletes to the target tables to another table which keeps track of all the DS job info
Thanks

Thanks for the quick response Prasson . Did u mean routine or just a custom transform ? It would be great if you can help me out with that routine,
Thanks

this function will get rid of zeroes .
DecimalToString(Input_string,"suppress_zero")

Hello all, I had trouble calculating no of rows processed on a link in a parallel job . i searched the forum and could not find any solution.I see that that there is a DSGetLinkInfo() function in server job . Is there any function for parallel jobs ?? Thanks in advance for your response Regards Prem

I did encounter this problem a couple of times even though there were permissions .I dont know what causes the problem but changing the update policy to Use Existing(Discard schema & records) got rid of this error .