DSXchange

If I were you, I will write what I need to a file (using a shell script maybe) and cat it in subject in "Notification Activity" `cat mystatusFile.txt` Try it it works for me... Kommven- So when you use "cat" in shell script, it will return a concatenated value of the contents of...

Or you can have a small basic routine, calling the DSExecute() function. You can run your dos command there. Have a routine activity stage call that routine. Connect the routine activity stage to a sequencer. That should work. I have been using Routine Activity Sequence and using the ExecDos to cal...

Not without a routine somewhere in there, to build and send the email. The Notification Activity can not take an expression as the message body (though attachments are supported in version 7.5, so yo ... Just saw your email whilst I was posting. That's what I thought too, think I will have to explo...

Just to add on, I have thought of saving the rows into a sequential file and use the Space character as a delimiter so that the contents in the sequential file will be: France (File1) UK (File2) Can I use any of the stages to transfer all the contents of the sequential file (including the new line c...

Klaus Schaefer wrote:Better use command activity in job sequencer for this.

Klaus

I think you mean the Execute Command Sequence, I have tried it but for some reason, it does not accept job parameters that makes up DOS command and will not run properly unless I hardcode the DOS command in it.

Hi, I need to create a job where I make up an email body based on data from 2 different SQL extractions (but from the same source) I receive. Examples of each piece of data I am extracting: Data1 Module | Message | Source ------------------------------------- France | Success | File1 UK | Success | ...

Hi, I am trying to have a Command Stage by itself without any links so that I can activate this DOS command, which I want to be a job by itself. If I am correct this is not possible, are there ways that I can have links to or from the Command Stage to stages that do nothing? Please feel free to corr...

Hihi,

I just realised this is possible when I tried tinkering around with another sequence I created.

Not a great question I must admit so thanks for bothering to answer my question!

In almost all cases where you can specify a parameter you can use the concatenation operator to put together constants and variables. You haven't specified exactly where and how you are doing this, so I can only answer that "yes, probably it will work". 1) I am doing a job sequence and in...

The DataStage server concatenation operator is the colon ":" character, not the plus "+" sign. ... Hi hi, thanks for the reply. I am aware of using the colon character ":" however does this mean that if I use this I am able to use the colon character in the Sequence Ar...

Hi, I have a email routine which I am activating in a Job Sequence using Routine Activity. Because the routine requires me to input the email message as an argument, I would like to concat certain parameter values and a standard string. For example (FILENAME and DATE are job parameters): "The f...

I have a similar situation where I need to delete then later insert. I did it by using two links (the ordering is done in transformer), the first will contain only one value which I use as a parameter for the condition to delete and the 2nd to do the insert the rows. If the first link doing the dele...

1) I have managed to save the returned value, using the Command Stage, to a flat file but what I really need is to throw this value up as a job output. 2) I have been playing with the ExecCommand activity, and though I managed to run my vbscript, and even succeeded in reading my return value (which ...

Oops, I mean Command Stage. I am too used to the word Command Prompt.

Am I able to retrieve the value that VBScript returns when I activate it in the Command Stage?

Hi, I wrote a VBScript to manage some files. I need my VBScript to return a value for my Command Prompt stage to capture it if no files can exist. Later in a Sequence, I will extract the value from the job to decide whether to run the subsequent jobs. I am not that familiar with how Datastage handle...