DSXchange

How do you define a "record" in your XML? One solution would be to count the number of instances of record end-tags that pass by.

I doubt that that's the case. For example, were the NodeAgents formerly started as root and are not started as a non-root user? Have ulimit values been changed? Are you using the same user to execute?

What is the data type of this column? Is it genuinely VarChar? In that case - and if you find that Arnd's advice about automatic "conversion" does not work - you can take it apart (using Field() functions), perform conversions to decimal (for the mantissa) and integer for the exponent, and...

Ah. I forgot you now wear your underpants on the outside!

Are you putting other components (e.g. Data Sets (resource disk)) in other folders? If not, the two folders you mentioned ought to suffice. Except...
You will need to be able to restore the Windows Registry to get things fully back to operational status.

If you do not have NLS enabled, the internal character set is ASCII. If you do have NLS enabled, the internal character set is UV-UTF8. Neither of these is negotiable. What you can do, if you have NLS enabled, is to map between any other encoding used externally to DataStage into or out of the inter...

There's a set of sample questions on the IBM certification website.

IBM also run a certification preparation class on the Sunday of the IOD conference (last week of October).

Much like that one indeed. Probably the duplicate post thereof. Maybe the OP was deleting it as I was executing posting.php.

Today I got the following error when posting one response. Could not query forum moderator information DEBUG MODE SQL Error : 1064 You have an error in your SQL syntax near 'AND g.group_single_user = 1 AND ug.group_id = aa.group_id ' at line 5 SELECT aa.forum_id, u.user_id, u.username FROM phpbb2_au...

arvind_ds wrote:We use to run 30 to 40 datastage jobs each day on this server and this issue never occurred before.

What has changed?

Parallel job (as posted) or server job (as marked)?

The space must occur for Decimal data type - it is the sign of the number.

The only way to get rid of the space is to convert to a string data type of some kind, most probably VarChar of sufficient size.

need to add dynamically additional columns may be added in future. Col1 Col1A Col1B Col1C Col1D Col1E You chose not to mention that when posing the original question. There is a delightfully elegant solution using a server job or a BASIC Transformer stage, where you treat all of the numeric fields ...

When you created the shared container in the job, did you make a copy of the shared container, or did you create a reference to the shared container?

The easiest way is to use node pools. And details on how to do that are to be found in the manuals, specifically the chapter on configuration files. (I can't give an exact reference because I am unsure of the exact version which you are running - the manuals' organization changes between versions.)