DSXchange

If your DB2 is on Z/OS , like we had, you need to use CALL SYSPROC.DSNUTILU() , with RUNSTATS TABLESPACE option.

Its still remains as chulett says , a special case similar to SCD2, maybe you should just enable change capture stage for Updates & Inserts and run both that data[sets] as an Insert. Drop Copies ( same addresses) and Deletes ( No records in Input , but exist as reference) . MAke sure Not to comp...

IDK why its common to refer to Change Capture stage as CDC stage, because it creates quite a confusion with the CDC Transaction Stage.

more specifically use a SCD stage or Change Capture .

FYI IDK why , but our AIX doesn't like quoted arguments to Grep and getting the sam eto work in External filter was quite a pain requiring blunt trial and error till we could force it to recognize : I have a requirement to only pass values that match '9' but not any other number preceeding '9', fort...

I guess you'd be better off using an Oracle Stage like oracle connector than ODBC for such requirements. Its most likely your BLOB column has a limited support in ODBC stage that causing the error . The CPP program will usually be packaged in a shared library and you wont really have access to the s...

I did not have tim eto work through a generic algorithm though a sequencer loop processing a constantly reducing file would have worked logically speaking. The business only wants to load 3 years of data at a time , so I created a job that runs 5 iterations and writes an overflow bucket if it did no...

Pity that Server Jobs and Basic transformer are nowadays frequently considered 'illicit' workarounds in many places, despite their unique and powerful capabilities, and despite the fact that basic transformer is capable of running on multiple nodes on an SMP system.

I have a Bunch of Rows grouped by a key and multiple such bunches. The requirement For a given Grouping Key , start the first group at the lowest date and and it at the row where the date is highest value less than 365 - store in first grouping bucket next start with the row that is the First Value ...

wrapped stage only accepts pipe safe commands and hence doesn't really do row by row. Inserting a wave gen to do row by row may not work because the Wrapped stage is typically Not 'Wave-Aware'. Maybe try sequential file with multiple files option and use filter command . Is there no oracle function ...

why dont you write the result set from the stored proc to a table in a before stage proc call and then read the xmltype using XMLSERIALIZE(DOCUMENT columnname) oracle function - you could use an oracle connector stage perhaps ? ? Again i'm not sure of you need to execute this on a per row basis - bu...

I just checked my calendar to make sure its not April 1st.
PS
There is a higher chance IBM may stop future development of AIX OS and provide customers with a path for transitioning to Linux on Power Arch. .

You can write a DS Basic routine using BCI and the ODBC api to retrieve a database value from an ODBC compliant database - but you must strictly control the output returned by such a routine which calls embedded SQL. And if you want to pass arguments to the SQl within the routine - you must properly...

You can go to the Output Master tab of CFF stage ,and you will see a sub tab called constraints - it offers some level of capability of filtering data -, but I don't think any string functions can be used. You can just filter on a column or bunch of columns based on equality or inequality criteria. ...

Yeah, the post is resolved, but i usually design my jobs to minimize number of Transformer stages ( a throw back to the past i guess ) - So i would have just read from the sequential file , and used a copy stage to get only the columns after the 3rd position. Or read the whole file as a string and c...