Thank you Duke. I will try if this works.
Meanwhile I decided to write the count to a temp table from within the procedure which I then read from the routine. This solved my issue.
Search found 24 matches
- Mon May 24, 2010 2:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute procedure from server routine
- Replies: 3
- Views: 2008
- Thu May 20, 2010 9:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute procedure from server routine
- Replies: 3
- Views: 2008
Execute procedure from server routine
Hi I have a requirement to refresh a materialized view (mv) only when one table within mv has > 0 records. If count=0 another set of steps need to be done. To achieve this I decided to call an oracle procedure from a server routine and later branch accordingly. This procedure does a materialized vie...
- Mon May 11, 2009 11:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: scd using changecapture
- Replies: 0
- Views: 1062
scd using changecapture
Hi, I am using change capture stage to implement type 2 scd. Below is an example where I have multiple records for an id in source. I would like to fetch reference data from database for every source record. Is there a way to achieve this? source id col1 col2 col3 s1 a b c s1 a1 b c s1 a1 b1 c targe...
- Thu Sep 25, 2008 1:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem with dssearch command
- Replies: 8
- Views: 6831
- Mon Jun 23, 2008 9:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fail job during ExecTCL failures.
- Replies: 2
- Views: 1707
Fail job during ExecTCL failures.
Hi, We are executing SQL procedures using Before-Job subroutine - ExecTCL.(This approach was suggested by IBM as our procedures did'nt run as expected from before/after sql in Dynamic RDBMS stage. We have created VOC entry & are using Exec TCL) If Exec TCL fails, it gives an error in log but doe...
- Mon Feb 11, 2008 1:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while executing SQL proc from DS
- Replies: 3
- Views: 1887
- Mon Feb 11, 2008 1:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while executing SQL proc from DS
- Replies: 3
- Views: 1887
- Tue Dec 04, 2007 1:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: px version of Ereplace - SIGSEGV error.
- Replies: 8
- Views: 3993
- Tue Dec 04, 2007 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: px version of Ereplace - SIGSEGV error.
- Replies: 8
- Views: 3993
- Mon Dec 03, 2007 3:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: px version of Ereplace - SIGSEGV error.
- Replies: 8
- Views: 3993
- Mon Dec 03, 2007 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: px version of Ereplace - SIGSEGV error.
- Replies: 8
- Views: 3993
px version of Ereplace - SIGSEGV error.
Hi, I have created a parallel routine for Ereplace using the code by DSguru2B (http://www.dsxchange.com/viewtopic.php?t=106358&highlight=ereplace) I have compiled the code & mentioned the library path: /etl/ascential/Ascential/DataStage/PXEngine.751.1/lib/libereplace.o When I compile a job u...
- Mon Nov 19, 2007 3:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence forced restart
- Replies: 12
- Views: 4824
- Mon Nov 19, 2007 3:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence forced restart
- Replies: 12
- Views: 4824
Thanks a lot gateleys. Both ur approaches worked just like I wanted. One quick question. Can you let me know if you meant any specific stage by this - 'Sequencer (any)'; to merge my 2 flows into 1. For time being I am having 2 separate flows(no good). I couldnt find a stage which accepted more than ...
- Mon Nov 19, 2007 2:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence forced restart
- Replies: 12
- Views: 4824
- Mon Nov 19, 2007 11:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence forced restart
- Replies: 12
- Views: 4824