DSXchange

Chulett, I would generally agree with you, although it appears that with the combining of the 2 products into one interface, the lines have gotten a bit blurred. Since I'm not using any of the QS specific components, I had assumed that the content of the post would be more relevant to DS users. If I...

Sreenivasulu,

The client I'm working at has only purchased QualityStage. It appears that the Rowgenerator Stage is a Datastage specific stage. Is there another stage I can use as a dummy stage.

Mike

Sorry, I misspoke. I realize that the Stored Procedure Stage is used for Parallel Jobs, not Job Sequences. Is it possible to create a Parallel Job that would have as its only stage a Stored Procedure Stage? If so, I still need to figure out the configuration. Otherwise, is it possible to call it fro...

I'm trying to use a Stored Procedure Stage in a Job Sequence to run a SQL Server Stored Procedure to truncate tables before individual Job Sequences are processed. There are no parameters to send to the Stored Procedure. I'm having trouble configuring the Stage to work properly. It keeps failing wit...

Thanks to all who replied. I was successfully able to add a Terminator stage for all unsuccessful Jobs during a Job Sequence.

Mike

veerabusani185512,

Thanks. I was just thinking about that myself. I'll try it and let you know.

Mike

veerabusani, I'm not sure I'm following this exactly. My Sequence Job runs several individuals Jobs in parallel. There are no output links for any of them so there are no trigger conditions. When all the jobs complete in the Sequence, all succeeed except on which finishes with an abort status. The o...

Here's probably a simple one for you gurus out there. :lol: I've got a Sequence Job that runs several individual Jobs in Parallel. One of the individual Jobs aborts, but the Sequence Job still finishes with a Status of 1 (Finished-OK). This sends a false success status to the Master Sequence Job it ...

Excellent Ray! The only reason I was confused is that the Information description for the Close Command in the stage is as follows: SQL statement to be executed before insert array is processed. This statement is executed only once on the conductor node. This certainly seems counter-intuitive to me....

Thanks, Ray. Just one more slightly stupid question.

Which command (Open or Close) do I set in the Source Enterprise Stage and which command do I set in the Target Enterprise Stage? Or can I set them in the same stage?

Mike

You folks have always been great in responding with quick and accurate info. Here's what I think is a fairly simple problem but I'm have trouble figuring out the answer: I want to execute SQL Server stored procedures within a Job that will drop an index before a target table is loaded and then recre...

Thanks, Guys. Problem Solved.

Chulett,

If I read your post correctly I changed the Trigger to:

CONVERT(@FM, "",Execute_Command_17.$CommandOutput > 1)

However, this still didn't work. Am I missing anything?

Mike

I'm using an Execute Command stage in a Sequencer job to grab a single value from a text file (the file has only one value). In this case, the value in the text file is 1. I've created a DOS batch file to read the value from the file: @Echo Off set /p "var="<"C:\IBM\Data\Dev\Output\Ch...

It took a while, but I found the solution on the IBM web site: http://www-01.ibm.com/support/docview.wss?uid=swg21402870&myns=swgimgmt&mynp=OCSSVSBF&mync=R Here's the solution from IBM: Diagnosing the problem When you try to run a CASS job, you receive the following error: cass: Unrecogn...