DSXchange

Did you search the forum for SIGINT? If so, what did you find? You can also learn about signals by viewing the man page for signal on your UNIX system.

You are probably noting a similarity between the fact that a hashed file and a data set can be in memory and can service lookups. While that is true, the architecture of each is radically different. For example there is no mechanism for automatically partitioning a hashed file over the processing no...

When the job starts, the stage sends the SQL (whether generated or user-defined) to the database server to be "prepared". This means that the database server prepares its execution plan based on available indexes, current load and whatever other factors might be involved. A request is then sent to t...

Somewhere (in a Sequential File table definition) you have specified that this value occurs in a fixed-width of 11 characters. I assumed - wrongly - that its data type was therefore string[11]. Nonetheless, what it's looking for is a representation of NULL that is 11 characters long, for example '##...

It's a plain text file on Windows also.

%WINNT_ROOT%\System32\drivers\etc\services

No. Existing jobs will not be affected. When you re-open them you will see NLS tabs, but the settings will be as if you had not enabled NLS. Note that installing NLS is not suffiicient - it must also be enabled by changing the NLSMODE parameter in uvconfig to 1, regenerating and restarting DataStage.

Avoid using the keyboard as much as possible. Choose the job parameter from the "add job parameter" tool. That way you must get it right.

Trust the Hashed File Calculator. A few alphabetics won't hurt the Type 2 hashing alogrithm if the keys are primarily numeric varying most on the right hand (line number) end. I must challenge your assertion that you are moving away from dynamic hashed files because of size. Any kind of hashed file,...

Your problem with a single stage was that a passive stage can not open its output(s) until all its inputs are closed. This is in the API and not negotiable.

Search this forum for "invalid magic number" - it could be a corrupted file or perhaps a file for the wrong platform.

We weren't discussing 390 either, but I had to challenge your assertion!

$UNSET specifically unsets the environment variable. So that, when time comes to check it, it is not found and the default is used. Perhaps you want to set its value to LOAD explicitly.

Orchestrate manuals are handed out (on CD) with every DS EE class, and can be downloaded from the eServices web site. Search on this forum to find the link.

Any stage can be forced to operate in sequential mode. Or you can use a server job.

You have posted in the parallel jobs forum but specified "server" as your job type. Which is it? Particularly if it's server, please advise precisely what you mean by "partition", which has a very specific meaning for parallel jobs.