DSXchange

'Program HASH.HELP stopped'. Any reason that this is happening? Probably. Report it to your support provider. I have certainly used HASH.HELP on hashed files with more rows than 45 million, but they were small rows. I suspect that some kind of arithmetic overflow has occurred within the HASH.HELP p...

Welcome aboard. Server and parallel jobs are different products (parallel jobs formerly known as "Orchestrate" from Torrent Systems before they were acquired). Little inconsistencies are thus to be expected. If this causes you grief, raise an enhancement request to get it altered. You will be requir...

What are the permissions on the /root/.bashrc file?

One process (the "conductor") reads the generated OSH and the configuration file (referred to be the APT_CONFIG_FILE environment variable) and, from these, composes the score. The conductor process then organizes for one process (the "section leader") to be started on each processing node mentioned ...

They are not commands, they are not options, they are not utilities.

They are directories.

And they are just there. They are emplaced when you create the project. You don't need to do anything.

You're reading the sequential file in either case. So introducing a Data Set will yield no overall gain, though time-shifting the read process may have scheduling advantages in your situation.

Have you investigated the "multiple readers per node" option for reading the sequential file?

There are lots of ways to do this. What does your job design look like? The best way is not to extract rows in the first place. Another possibility is a Head or Tail or Sample stage. What precisely are your requirements?

1. DataStage does not have a directory called "px". I suspect you mean "&PH&" and "&COMO&". Search the forum to find the answer. Both are necessary, but their contents can be periodically cleared. 2. No. Except on Tru64 operating system DataStage is purely a 32-bit application. There...

Job1 selects the table name from wherever it is stored, and loads the table name into its (the job's) user status area via a routine that invokes DSSetUserStatus(), picking up the input table name from the input link. The job sequence reads Job1's user status via $UserStatus activity variable and us...

Are you passing a and b to the script from DataStage, or are they something intrinsic to the script? If the former, how are you passing them and how are you retrieving them in the script (for example are you using positional command line arguments)?

So that ZPROMID is a string by the time it gets into this expression, and appending a zero-length string to it leaves it unaffected.

Looks like the problem for the original developer was between the keyboard and the chair.

SELECT @ID FMT '60L' FROM DS_LICENSE; Each connected client obtains a licence seat; the licensing is partly managed through the DS_LICENSE table, the key to which includes the client machine's MAC address, its hostname and the process ID on the server of its agent dsapi_slave process. You can also ...

It would in a server/BASIC expression. Appending no characters to a string returns the original string.

This is also true in a parallel expression, except that concatenation to a Decimal data type is prohibited. (You have marked the job type as parallel.)

Nice try, but BASIC is not recommended for parallel jobs. Also, how well does the "solution" handle an arbitrary number of levels? Yes, it CAN be done in BASIC, but that's not the point. A strategy needs to be found whereby an abitrary number of recursive queries (against the target table, as popula...

Go away from DataStage for a short while. Get yourself a whiteboard or some paper, and sketch out exactly what has to happen; that is, what columns have to come from where, and what the layout of the final text file has to be. This will clarify your thought processes so that you can come up with an ...