DSXchange

Take a look at MetaDex from Compact Solutions which has the ability to "translate" metadata from other tools into IIS format.

I believe that MetaDex can be supplied by your regular IIS reseller.

Full outer join in Join stage, filter using IsNotNull() function.

How many records? Why is 4400 rows/second unacceptable? The CFF stage potentially has to do a lot of work. Increasing the number of nodes (given that the underlying server has sufficient capacity) would be one approach. Limiting other activity on the server while this job is running would be another.

I prefer to teach people to fish rather than to give them a fish, the benefit of the latter being ephemeral.

I have had issues in the past trying to bring back too much at once, which were eventually resolved by replacing the 32-bit JVM that comes with IIS with a 64-bit JVM (provided by IBM Support). The clue was "out of memory" errors that kept occurring.

Probably my favourite example of a gerund.

Column Import stage to split the delimited field into columns then a Pivot stage.

Hashed files can be created in the project or in any other directory. If they are created in a project, that project's vocabulary (stored in the project's VOC file) includes an entry that records the name and location of the hashed file and its dictionary. Hashed files that are created elsewhere can...

The three bridges for Cognos 8.4 can also handle Cognos 10.

Thanks for that. The same technique works when importing reports and packages from Cognos though I seem to remember it expects semi-colons as the delimiter.

A pedant.

Does not re-running the -user command with the appropriate group list overwrite what's currently there?

x is a placeholder for the table name(s) returned by the IN clause. You need to study DB2 SQL a little more, it would seem.

"More than 42,700 users" is even more precise.

bhasds wrote:Hi Cherukuri,

If you have the pattern no2,2012 is common for each delimited substring then you can use-

Code: Select all

Convert("no2,2012","",IPfield )

That won't work for "nafta" because every "n" is converted to "".