DSXchange

Thanks Craig. As I understood, you think that the problem has to do with the parameters values; but the weird of this situation is that they have the same values in both executions (please, see previous post). I can insert the code written in the 'Job Control' tab but I'm afraid this will bring more...

sorry to bother you. I apologize.

Craig, thanks for your answer. Yes, I verified the "job starting" log message in both runs. Here they are: Manually execution : Starting Job Prueba_SP_Value. (aka: JobB) DBName = dstdesa UserName = datastage PassWord = ******** PgmName = xxx Dictionary = CUSTOMERS SrcSystem = SAP-ONE TgtSy...

Thank you for your answer. I clarified that both jobs were servers jobs since in a previous reply they asked whether JobA was a "Sequence job". I call JobB by using the following commands: hJob1 = DSAttachJob("JobB", DSJ.ERRFATAL) * Setting parameters of job ErrCode = DSSetParam(...

The parameters sent to JobB are the same in both executions.

Regards
Diego

Good morning, fellows:

I forgot to tell: both Jobs (JobA and JobB) are server Jobs.

Thanks!

Diego

Hi fellows: In order to close this subject, I want to tell you I used a sort of "Plan B" to solve my problem. What I did was to create a routine that receives the parameters I needed and then invoke to dsjob command; then I put this routine in a Transformer Stage. It's working fine. I've g...

Hi fellows: I'm regret having written "without success": what I tried to say is "the job I wanted to execute using UtilityRunJob didn't run or it didn't be called" On the other hand, I'll show you what I did: |Oracle | | Transformer | | Command | |Stage |-----> | Stage |----> | S...

Hi Fellows: Following your advice, I use a Transform Stage to compose the string with the command to execute. But, unfortunately, the Command Stage failed because it can't support variables as a valid command (in fact, the message of error says " '[variable]' is not recognized as an internal or...

I'm using a server job.

It seems like Command Stage takes everything as one single command and doesn't distinguish between text and variables...

sure. I would like to attach a print screen or a document with the image embedded but I don't know how.

Is it posible?

Thanks!

Thank You for the explanation.

It Works fine now!

Regards
Diego

Dear Nagaraj: Suppose you need to create a xml document like this: <MyXML> <MyColumns> <col1>123</col1> <col2>abc</abc> </MyColumns> </MyXML> You must use xpath statements to indicate to corresponding stage (e.g: XMLOutput or XMLWriter) how this columns are arranged, so in this example you should se...

Sure. First of all, the problem is my inexperience with this stage but, punctually, has to do with I didn't to know that I should provide a xpath statement into description field of every column of input file in order to tell the stage how to place data of such a column into XML document. I apologiz...