DSXchange

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.

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...

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...

ssunda, we are facing same issue while using dssearch command. Did you manually change the dependencies in all sequences. Is there any other way to achieve this?

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...

Hi All,
I understand that this is an entry in VOC database table of this project but I would like to know how to get this from DEV to UAT/PROD. Is there a way I can import VOC definitions or should I make similar manual entries in UAT & PROD environment.

Thanks,
Preethi.

I was working with IBM support for past 2 months and we just got a workaround for this issue. I was adviced by IBM to use before/after pre-sql only if the sql's are simple. In my case we have a very complex SQL server procedure call & had to be called only from Datstage due to few other contrain...

I get this error while running the job using this routine. Sorry for typing it wrong earlier in the post.
Also I have tried executing a sample rouine & it works fine.

I have used object file option only...

Ray, will this information help?

procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s1 s2 s3 in sy cs us sy id
0 0 0 17150280 1040208 258 886 1049 8 10 0 3 0 0 0 0 300 547 488 15 6 79

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...

Got it... :D
sequencer activity with ANY mode...

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 ...

Thanks gateleys. I will try this now. Are there any built in routines for getFileSize & clearfile.

I agree to that Chulett.
JobA & B are only pre-checks before I proceed with Job C. Based on the tgt rowcount of Job B(for which I use routine), I decide if I shud stop or proceed to Job C.