DSXchange

This information should already be stored in relational form in the XMETA database. But it's painful to get out of there. You can get some of the information you require using DataStage API calls,and the remainder from various tables whose names begin with DS_ in the project itself. Search DSXchange...

Welcome aboard.

The error is "ADMA5014E: The installation of application common_metadata_ai.ear failed."

Was WebSphere Application Server running when you attempted to install the fix pack?

In which case all of the above advice is apposite.

Welcome aboard.

There are some ports that have to be open for inbound traffic in addition to those open for outbound. The error message(s) suggest which ports. Or you can refer to the Planning, Installation and Configuration Guide

I'd suggest that you prepare specifically for version 9. The same bank of questions is not used between versions of the tests, and you would need to identify and eliminate from your mind the new features in version 10.

One could use a Column Import stage with sufficient target columns.

There's no convenient way to use looping to populate an arbitrary number of target columns unless, again, you have at least sufficient target columns.

Seems to me you'll need something more like a Regular Expression to detect the presence of four contiguous occurances of the same letter in your data. This is do-able in DataStage if you have the Data Rules stage, which implies version 8.7FP1 or later and an Information Analyzer licence. One of the...

Above Expression gives the position as 2 . Depends what's in InLink.TheColumn - which you did not indicate before making this assertion. Let me be clear with the requirement. If the column from the file has data NSAAAAI then the record is rejected since there is 4 consecutive A's in it. I did not r...

Welcome aboard. Do you have knowledge of the "alphabet" at job run time? If so you can make it a job parameter and use an Index() function to search for four contiguous occurrences of that value. Index(InLink.TheColumn, "#jpLetter##jpLetter##jpLetter##jpLetter#", 1) will be zero ...

It's not clear how the output is to be generated. Please express the rules in words (this is called a specification, and is a skill you need to develop in any case).

I would not be using DataStage to perform what is an obviously simple SQL query.

Looks like a task for a Column Import stage.

Your decimal precision must be at least 8. Its scale should be 0.

Someone or something has knocked out the conductor node - hence the status of Crashed. Did someone issue a kill -9 command? With no conductor with which to communicate, the section leaders will take some time to react to that situation. In the interim the player processes - those doing the actual wo...

Use an explicit Sort stage. Partition data by the sort key. The Sort stage allows you to allocate more memory than the default to the sorting operation, which means it takes longer before the sort has to spill to scratchdisk. You can control the default with an environment variable called APT_TSORT_...