DSXchange

A vital piece of information that you completely neglected to reveal in your original post.

In UNIX execute permission allows you to use the directory name in a pathname so, yes, you need execute permission. The permissions on Datasets are OK. The permissions on Scratch are not. However, the error message in your original post was unable to write to Datasets, so permissions may or may not ...

This is probably most easily done using SQL directly in the database. Sure DataStage could be used, but so could a fairly straightforward UPDATE (using a correlated subquery containing MAX).

Do you have write permission to /DataStage/751A/Ascential/DataStage/Datasets ?
You might also check /DataStage/751A/Ascential/DataStage/Scratch

Repartitioning is totally irrelevant to data volume. Who suggested it? Repartitioning is added cost that should be avoided unless absolutely necessary, for example to achieve key or group adjacency or to match database (DB2) partitioning. Repartitioning is particularly costly on cluster or grid conf...

No problem; you simply need to record the instance=paramvalue pairs somewhere. A hashed file keyed by instance would be ideal, even SDKSequences could be used. Just remember to remove the record from the hashed file upon successful completion.

Search IBM web site. Course code is DX436 for version 7.x - it changes for version 8.x but I don't think that's out yet - they've only just issued the Essentials class for version 8. Get in touch with Gulf Business Machines in Dubai who I believe would be your closest IBM training supplier. Tel: +97...

Back to basics, can you guarantee that the XML is well-formed?

Deployment domain consists of a metadata server (hosted by a WebSphere Application Server instance), one or more DataStage servers, one DB2, Oracle or SQL Server instance containing the Repository database, IBM Information Server clients (administration console, reporting console and DataStage clien...

Unless it turns out to be like clothes sizing, and we get XXML, XXXML and so on. Then parallel may be better, like some folks needing two seats on the aircraft.

Actually the warning there is about string to string[size] - that is, unbounded string to bounded string. Not sure where that's coming from, but it's clearly not covered by the NOWARN specification. Do you have a VarChar with no precision (length) anywhere in the design?

Then simply specify that field as the join key, and make sure that you partition and sort on that field.

As a general rule you seek to minimize the amount of time you are hitting operational systems with extraction requests. Best practice, therefore, is to extract as rapidly as possible into a staging area (which can be text files) without performing too much manipulation of the data. This is not about...

Add an extra Specification containing the single word NOWARN

Use a telnet client with a known emulation, such as VT100. Once in dssh, issue the command SET.TERM.TYPE VT100 to inform the shell that that's the emulation you're using. All should be well. Try the CS command, which should clear the screen. Try DS.TOOLS to see whether a formatted menu works. Now yo...