Search found 218 matches
- Tue May 15, 2007 8:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conditional job abort
- Replies: 5
- Views: 3554
We Can achieve your requirement by writing the Basic Routine and call that in After Subroutine box. First thing is make the constraint as per your requirement in a new link called dummy link ( Condition is data='False') in that link just create a column called Dummy and direct to Copy stage and leav...
- Fri May 11, 2007 12:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 EE stage - Extract - SQL IN Clause
- Replies: 4
- Views: 1842
- Thu May 10, 2007 11:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 EE stage - Extract - SQL IN Clause
- Replies: 4
- Views: 1842
Hi Ray, Thanks for your reply. I am passing the parameter #FACPARAM# and passing the values as '100A','101B','101C' and inside that SQL I am passing the parameter without Quotations like FAC in (#FACPARAM#). In this Case job is aborting. If I pass the values in the parameter like 101A,101B,101C and ...
- Thu May 10, 2007 10:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 EE stage - Extract - SQL IN Clause
- Replies: 4
- Views: 1842
DB2 EE stage - Extract - SQL IN Clause
Hi All, My Requirement is like these : In my SQL I have to use IN condition for checking the few strings. I have to pass these strings in a parameter as per my requirement. I am using the DB2 EE stage for my extract from DB2. But, my job is aborting as it is not able to perform IN function with the ...
- Thu Dec 28, 2006 9:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Strange thing about Lookup Stage
- Replies: 1
- Views: 1712
Strange thing about Lookup Stage
Hi Dsxians, Today I have encountered one strange thing in DS Parallel Lookup. Its related to Condition Box on Constraint Tab. I have one reference link for my Lookup stage and Whenever I tried to insert some condition on my Reference link by using the Inputcolumns from Driving link, I didn't get tha...
- Wed Dec 13, 2006 11:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to capture reject records in ETL process?
- Replies: 15
- Views: 10322
Hi Swathi, There are so many stages in Parallel to support reject process. Lookup ----- Lookup fails (capture the driving link) Merge-------- join fails (Capture the refrence/updated records) Tranformer -------- caputure the records which are not satifying the requirements (Like null handling) Seque...
- Wed Dec 13, 2006 11:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Number of rows in a data set
- Replies: 23
- Views: 6962
- Wed Dec 13, 2006 11:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to increase the Sequence number in PX from Oracle
- Replies: 14
- Views: 9145
- Wed Dec 13, 2006 11:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compilation error of Transformer stage
- Replies: 11
- Views: 8347
- Mon Dec 11, 2006 9:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to use DSLogFatal in Parallel job
- Replies: 4
- Views: 2362
- Mon Dec 11, 2006 7:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to use DSLogFatal in Parallel job
- Replies: 4
- Views: 2362
How to use DSLogFatal in Parallel job
Hi All, I have a requirement to abort my job based on a constraint in Transformer. My constraint is If cloumnA is null then abort the job and insert a statement like 'Job is aborted CloumnA is null'. I came to know that it is possible with subroutine called Call DSLogFatal (Message,CallingProgName) ...
- Sun Dec 10, 2006 5:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: compilation error - transformer stage
- Replies: 18
- Views: 6937
- Sat Dec 09, 2006 3:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to abort job based on constraint
- Replies: 20
- Views: 11426
- Fri Dec 08, 2006 6:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to abort job based on constraint
- Replies: 20
- Views: 11426
Create another output link from the Transformer. Its constraint is the logical inverse of the constraint you have been using. On this link set Abort After Rows to 1. The link can connect to a Copy ... Hi Ray, Its a good idea to capture the rows to another link and abort the job. Here my doubt is if...
- Fri Dec 08, 2006 3:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: section leader died
- Replies: 3
- Views: 3318