DSXchange

Hi, Well, at this time I can only change the shell script, not the other commands inside ExeCmd. So I can't pass in a argument to the shell script to indicate whether it's in the EH as that would require change to all other DS jobs to pass in this flag. That's why i was wondering if there is an API ...

Hi That would work the way you explained. But I was thinking of not having to change existing code (ie, not adding the set variable command). Shell script is common code called by many DS jobs. Each DS job calls the same shell script both inside and outside the Exception Handler to do some reporting...

You are correct. That's what I mean: Exeception Handler stage


Thanks

Hi I have shell script that is called by ExeCmd. This ExeCmd stage can be called by either inside Exception Block or outside Exception Block. It executed fine as it really just do some logging. What i now need is NOT to do some step while inside Exception Block. Is there a way to determine (from she...

I was out last few days. I will get the admin to help with the above tips. Thanks for the replies.

Hi, After each job completes (sequence, parallel) I would like to extract the time each stage took, so to identify the resource hogs. Right now i have to manually open up the job logs and jot the time down. My question is, which is the best way to get that info automatically? Do I have to parse the ...

Hi Jay I just tried that. " -hiveconf PARAM1="A%20B%20C" " It passed in this: PARAM1=A%20B%20C PARAM2=DEFG Same for this: " -hiveconf PARAM1='A%20B%20C' " Your suggestion is similar to my backup solution: Everybody agrees to some non-space token (such as *, or %20 as u ...

Hi Ray
I tried that also. Didn't work either. This is what it passes into Hive:
Thanks

Hi I need to invoke Hive from Datastage, but I am having problem with passing in spaces in Hive parameters At the operating i can pass in parameters with space in them, like this: I have this simple Hive script. It just prints out the parameters passed in: ==> cat param1.hql !echo ==================...

I wish i know how to write such a viewer. Other than that, How would you line things up in the Log viewer? For example, the ExeCmd invokes a shell script which outputs some table on the screen. DS captures this in its log. But when you open the log, it all looks out of alignment, because the font it...

Darn :)

Would be nice since we could draw some ascii pictures in the log.

Thanks

Hi

In the Log Event Detail panel in Datastage Designer how can I select Courier as the default font?

Thanks

Hi That's what I want to do, but the existing jobs that I inherited use UserVariablesActivity to hold that time constant. I want to reference this variable in the ExeCmd script inside Exception Handler (or even in SendMail's subject line.) If system variables/macros is a better solution, I can propo...

Hi This is my understanding. Pls correct as needed: - This jobs command must be run within an ExeCmd (because it is a Unix command). - Since all bkg processes are child processes, that means we must find the pid of the parent process (1st sequence job) - Then, how do you get the pid of the parent jo...

Hi Yes, that was what I meant: I had a UserVariablersActivity where i have a variable containing the current timestamp. This timestamp kind of acts as the PrimaryKey. Has to be exact. I am able to pass this timestamp as parameter to any ExeCmds scripts, but DS will not accept this parameter inside t...