DSXchange

On a Windows machine I used the /? switch to get the following. On a UNIX machine try orchdbutil with -H or with no command line options at all. It's a start. D:\Ascential\DataStage\PXEngine\bin>orchdbutil /? ##I TFCN 000001 15:37:02(000) <main_program> Ascential DataStage(tm) Enterp...

Etiquette Note Pushing like that is regarded as offensive here. People post as and when they can, and don't get paid for anything. If you are seeking specialized customized support - at weekend rates, mind you, since it's Saturday in most of the world - then please revert. Otherwise wait patiently ...

Orchestrate does support the concepts of arrays and subrecords (refer to Chapter 2 of Parallel Job Developer's Guide for a brief overview). As to whether these map correctly through the Oracle Enterprise stage I can not say, as I have not tried it. I suspect that version 7.5 of DataStage only offici...

For DataStage processes, in the dsenv script. For other processes, in the .profile script in their home directories.

Why we need delimiter while calculating for Hashed files? 10+3+8+14=35 bytes per line \ For 15446662 records equates to 540633170 bytes You need the delimiter because it's in there (though it's a "field mark" in hashed files). By default hashed files are only filled to 80% of capacity, so your calc...

What triggers are on the Execute Command activity? The test command returns 1 if the test condition is not met. A pipeline such as that suggested by DSguru2B may be better, as the terminating command ( wc ) should always set its exit status to 0. You then need to test the command output (not its sta...

Why hide the logic, and make life difficult for future maintainers? Surely there can't be that many different jobs involved. Put your decision logic into a Nested Condition activity, and emplace specific Job activities for each of the jobs on the appropriate outputs (triggers) from the Nested Condit...

Some people like mysteries, but not us. Please post how you resolved this issue, the better to assist future searchers who are trying to solve the same question.

Null Field Value is only displayed if the field is nullable.

If the field is nullable, but the Null Field Value property has not been selected, it is to be found in the "available properties to add" list.

Parallel jobs cosume far more resources than server jobs; these may be starving the server jobs of resources. Have you considered this design in a job sequence? Job1 -----+ | +---> Job4 Job2 -----+---> Sequencer ---+ | (all) +---> Job5 Job3 -----+ Or even: Job1 -----+ | Job2 -----+---> Seque...

Inputs can come from any source. But do you have a join key? You may need to generate one on one or both inputs (perhaps the row number). Join stage inputs need to be compatibly key partitioned and sorted.

What's the largest size of the number in the source, and what's the maximum length of the ustring? It may be from the combination of the two that DataStage is generating the warning. For example, Decimal(10,2) will not fit in ustring[10] (character places are needed for the decimal place and optiona...

When you can not do it is when you're writing the same records, since these will be locked by the SELECT process. What you can do is to stage the records somewhere intermediate (a text file will do) so that the SELECT completes before the write process is asked to begin.

Use a stage variable to store the value from the previous row. You can search the forum for myriad examples of this technique. With that available for reliable change detection you can have another stage variable for the level, which is reset when a change is detected and on input row #1 and increme...

"Failed to load library" is most usually a run-time error indicating a deficiency in the shared library search path (environment variable LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH, depending on your operating system). This should be adjusted to include the parent directory of the library containing the...