DSXchange

You can also reset to any particular value using an UPDATE statement. It has been posted before, but the trick here is - because the SDKSequences hashed file lacks a complete dictionary (set of metadata) - to "borrow" another hashed file's metadata via a USING clause. Let's say you want to reset the...

Yes, but it's much easier on UNIX than on Windows. Why would you want to do so? A lot of thought went into choosing 31538 as a port number that didn't seem to be in use anywhere else for anything at all.

The key to it all is this statement: System error: A file or directory in the path name does not exist. This suggests that the shared library path environment variable (LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH, depeding on your UNIX) has not been set properly (probably in dsenv). Determine, perhaps us...

It is impossible for a cleared status file to report "Running". Did you refresh the view? Did you clear the right RT_STATUSnn file? (Eek!) You could, with somewhat more finesse, identify the status field for the job plus each stage and resource in the RT_STATUSnn file and reset them individually if ...

It's actually RT_STATUSnn (not DS_, which are design-time information, and with a job number suffix). You need to find the job number from DS_JOBS then clear the data from the RT_STATUSnn hashed file. This is possible with commands. SELECT JOBNO FROM DS_JOBS WHERE NAME = 'JobName'; CLEAR.FILE RT_STA...

Routine activity invoking UtilityAbortToLog will abort the main sequence. But it will not send stop notifications to currently running jobs. In 7.0 this is not quite so easy to do. You can create your own routine that will detect what the controlled jobs are, attach, issue DSStopJob request and deta...

As far as DB2 is concerned, DataStage job is just another client application. Therefore the DataStage job needs to have access to the client software (DB2 Connect perhaps).

is much, much more efficient than

When you connect with the Administrator client do you have administrator privilege? Are there very many UNIX groups on your server's domain? It may be taking a long time to determine who belongs to the various groups. Indeed, this sometimes out with "unable to enumerate domain groups" if the domain ...

You never really stated what your issue was. Be very, very careful with Repository objects; if you cripple them your support provider won't help and you may even void your warranty.

I wonder if the interviewer knows the right answer?! Actually, that should be answers (plural). I can cite at least five different ways to create a dynamic hashed file. These include the following. Do nothing in a Hashed File stage Check Create File in a Hashed File stage and don't visit the Options...

Is there an entry for the hashed file in the VOC? If not, that form of CLEAR.FILE will not work, and generate an @ABORT.CODE of 3.

Welcome aboard. :D

The answer, alas, is NO. You need to provide some other mechanism, like specifying an environment variable to be used. The environment variable can contain the password. Encrypted environment variables are supported from version 7.5 (or is it 7.5.1?).

It's probably an extra line termination character at the end of the file.
If you can't change the file, handle it with a rejects link and/or create a message handler to demote the warning to an informational message.