Search found 18 matches
- Thu Jan 21, 2010 9:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Run SQL Server Stored Procedure
- Replies: 6
- Views: 3022
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...
- Tue Jan 19, 2010 4:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Run SQL Server Stored Procedure
- Replies: 6
- Views: 3022
- Tue Jan 19, 2010 10:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Run SQL Server Stored Procedure
- Replies: 6
- Views: 3022
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...
- Tue Jan 19, 2010 10:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Run SQL Server Stored Procedure
- Replies: 6
- Views: 3022
Run SQL Server Stored Procedure
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...
- Tue Jan 19, 2010 10:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence Job Doesn't Abort
- Replies: 8
- Views: 4647
- Thu Jan 14, 2010 3:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence Job Doesn't Abort
- Replies: 8
- Views: 4647
- Thu Jan 14, 2010 3:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence Job Doesn't Abort
- Replies: 8
- Views: 4647
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...
- Thu Jan 14, 2010 1:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence Job Doesn't Abort
- Replies: 8
- Views: 4647
Sequence Job Doesn't Abort
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 ...
- Wed Jan 13, 2010 4:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute SQL Server Stored Procedure to Drop Index
- Replies: 6
- Views: 3774
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....
- Wed Jan 13, 2010 4:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute SQL Server Stored Procedure to Drop Index
- Replies: 6
- Views: 3774
- Wed Jan 13, 2010 3:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute SQL Server Stored Procedure to Drop Index
- Replies: 6
- Views: 3774
Execute SQL Server Stored Procedure to Drop Index
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...
- Tue Jan 12, 2010 6:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trigger In Execute Command Stage Fails
- Replies: 5
- Views: 3286
- Tue Jan 12, 2010 6:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trigger In Execute Command Stage Fails
- Replies: 5
- Views: 3286
- Tue Jan 12, 2010 5:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trigger In Execute Command Stage Fails
- Replies: 5
- Views: 3286
Trigger In Execute Command Stage Fails
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...
- Wed Oct 07, 2009 3:03 pm
- Forum: IBM QualityStage
- Topic: CASS Stage Error
- Replies: 2
- Views: 3168
Found Solution on IBM Web Site
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...