DSXchange

I believe there is more than one way to configure IIDR (CDC) with Oracle.

Did you search the Knowledge Center? Here is a link.

http://www-01.ibm.com/support/knowledge ... lcome.html

The preceding integer is the repeating factor.

X stands for any characters.
A stands for any alphabetic characters.
N stands for any numeric characters.

You can read a lot more about the pattern matching operator, MATCH and MATCHES, in the IBM InfoSphere DataStage BASIC Reference Guide.

Try Ray's suggestion to read each record as a single varchar column. You would also benefit from using the loop feature inside the Transformer stage. The product documentation has good examples.

Too many glossary authors could be problematic, like wikipedia. The authorized user licensing helped to encourage a limited number of authors. The change to unlimited will make things more interesting.

11.3 was made available for download June 27, 2014. Like other major releases, it contains a lengthy fix list. I found over 18 security and rollup patches for 9.1.2 that were included in the base install of 11.3, so that alone saves a lot of install time!!

I like your sample query! :lol: That was also my guess also, based on the different drill downs tested. I had searched on DSXchange and on the Support Portal and come up empty, prior to posting this question. Given that quotes are commonly contained in name data, I was curious if anyone else had run...

Has anyone run into the generic drill down error when the data contains a single quote? This is coming from IA 8.7.0.0 (no fix packs) on AIX via ODBC data source (SQL Server), Format tab, General Format A'AAAA, such as a name. The names display fine in the Distinct Values pane. Click Drill Down give...

Many posts are great. A few posts here and there deserve negative points. The ratings per post is more meaningful than points.

Or, put the data into a temp table then use the SQL to calculate the rolling total column via a DataStage job, to make life easier.

Thanks for sharing the solution.

According to this technote, the 8.1 release notes say that the dssearch command is not supported / not fully supported because certain options have known issues. JR35342: DSSEARCH COMMAND IS NOT NAVIGATING SUB-CATEGORIES CORRECTLY Now we know why the command is undocumented on versions 8.5, 8.7, 9.1...

Puzzled out from the column header of a running total of the last 7 days... Words would have been helpful. I agree that stage variables can be used if data is sorted, etc.

This is a great question, however I am afraid the root cause was an incorrect understanding of how DataStage works. It looks like DataStage is actually giving the correct results. The inner if then else statement is operating on an integer of 0 so the result will be an integer. You may surround that...

I feel better now

That certainly is an interesting requirement. I am not a big fan of XML. It carries a huge amount of overhead, so it is incredibly inefficient. Using it causes heavier loads on processors and networks. Many people do not realize the labor costs involved with all the extra effort in dealing with it a...