DSXchange

Still no.

Using that approach you don't have multiple copybooks, which was the question you originally asked.

Have you or any of your colleagues attempted any tuning of buffer sizes?
The message suggests that a buffer allocated for export (translation from internal into human-readable format) is too small, specifically smaller than the buffer needed as a result of analyzing/parsing a database query.

Your understanding is correct. On the other hand, Hash partitioning may consume resources to repartition the data. Overall, Hash partitioning is to be preferred in an MPP environment, because of the larger volume of data to be moved to the different nodes over the network. Entire is the "lazy" appro...

wht is NOT the architecture of DataStage.

Indeed, I have no idea what wht is.

Possibilities include the trading code of Westside Energy Corporation, Warwick Horse Trials, World Harvest Television, William Herschel Telescope, Web Hosting Toolkit, Wildlife Habitat Trust, and more.

Grammatical Note We advocate a professional standard of writing here on DSXchange, not least to save those for whom English is not the first language from having to decode weird constructions and abbreviations. In particular, don't use "plz"; the word is "please". Don't use "expln"; the word is "ex...

To use the orchadmin command, APT_CONFIG_FILE should be set to point to a configuration file that is, or is compatible with, that used when the Data Set was created. You may require certain other environment variables, such as APT_ORCHHOME, to be set depending on from where you are executing the orc...

No.

Not final delimiter - this appears between the data and the record delimiter.

Now read my previous post again.

Use Record Delimiter String property, set to "DOS-style", rather than Record Delimiter property.

You are being alerted to the fact that not every int64 will fit in a 10 character string. The biggest int64 is 9223372036854775807, which has 19 characters (20 if you allow one for the sign). Your output field needs to be a string of at least 20 characters to avoid this warning (alert message) from ...

Not in a Server job.

Terry Pratchett, Pyramids wrote:The trouble with Ibid is that he thinks he's a bloody authority on everything.

True, but they never supported earlier versions either, and lots of folks use Citrix to allow their outsourced folks access to DataStage.

Alas, no. The Test bed you get in Designer* does not have the fully-featured "wrapper" that a job sequence (= job control routine) has. * For those on versions earlier than 8.0, read Manager here. In version 8 all Manager functionality has been subsumed into Designer and there is no more Manager cli...

The short answer is to have DataStage (or some other utility such as sed) pre-process the file so that each pair of lines becomes one. If you have WAVES you could use that. Otherwise MNS is all that is offered "out of the box" for multi-national address processing. Of course, you could write your ow...