DSXchange

Search for "enabled" within security.xml. It was the first occurrence of "enabled" in the Windows security.xml file; I can not guarantee that this will be the case for AIX, so check that the line looks something like what I described.

The problem here seems not to be that the design elements are going into production but that the underlying class (from which user variables activity is instantiated) appears not to exist in the production project. I agree with you on the software development life cycle, but millions don't.

DataStage was never intended to be a reporting tool.

Use a reporting tool - maybe a BI tool, maybe a spreadsheet tool - for this.

You will need to enable export of read-only components for what Craig suggests to be successful.

There is a class available specifically about programming in the DataStage BASIC language.

Are these environment variables set? DataStage needs to be able to find the resource file/table it needs to decode the message to which the indicated token pertains.

Please help us to help, by supplying more information, not least of which are the data types of these two fields and whether they form a key. The fact that these are meaningfully named suggest that you need another column which will act as the surrogate key. What is its data type (usually integer of...

What do you mean by "handle"? What data type is the input field? What data type is the output field?

You may need to use Grid view. I can't check at the moment.

Seems to me that the User Variables activity has not been imported successfully (and maybe not exported successfully). Try this query in production: SELECT OBJNAME FMT '32L', OLETYPE FMT '20L' FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = 'LoadPIRMExtract_000_Control...

They are separately licensed, you can buy one, the other or both. All Information Server components' licensing information is in the one XML file.

QualityStage is a really great tool for this style of unduplication. When you say that you have duplicates, is it possible for there to be three or more records with the same key, or only two? If only two you can sort by key and use stage variables in Transformer to compare current row with previous.

Without knowing why that recommendation was made, it's impossible to comment. Can you please ask the IBM consultant why that recommendation was made? For example do you have many developers, do you use the same machine for development and testing?

Are you permitting zero-valued decimals? There's an environment variable that you can set to do that - I can't recall the name of it at present.

I suspect it's more to do with the fact that environment variables such as DB2INSTANCE can only have one value at a time.