DSXchange

Please do NOT advise kill until ALL other avenues have been exhausted. The correct procedure is to identify the owner of the lock, with a view to getting it released cleanly. If it is a defunct process, the administrator has an UNLOCK tool available (perhaps via the DS.TOOLS menu). A Director open i...

You could execute a lookup based upon a correlated subquery. Ugly and slow, but it would work.

As noted, it's a two step process. Step 1 involves creating a "domain user" who can use things in the deployment domain (including the Information Server and Application Servers). A domain user can be described, among other things, as a DataStage administrator or a DataStage user. Step 2 involves mo...

Looks like the FTP has generated an error but has not exited. You need to identify where this is and correct it.

Where is the slowness? - you need to verify that the slowness is in the Hashed File stage rather than in the extraction piece. Much of the slowness loading large hashed files on disk is the randomness of the operation (about which there is nothing you can do). Each new write has to move the disk hea...

As always, find out what's changed. It may not be something in DataStage - you may need to cast your net more widely. Were you running using a different login ID? Or it could be a damaged or corrupted run-time hashed file in the Repository; the error message was generated from the (internal) routine...

There is usually a line terminator at the end of the output of each operating system command. It's this that puts the cursor on the next line when output is to screen.

Craig, seshu doesn't want your help. The question explicitly asks plz to help (whoever plz may happen to be).

You could always read and parse the environment variable definitions (maybe only the ones from -listenv) from the DSParams file.

Roy?

Get to a TCL prompt and type the command HELP BCI SQLBindParameter

Not sure that works in parallel jobs, gateleys.

Licence usage over time is not monitored by the product. You would need to set up your own mechanism. Theoretically you could add a before insert trigger to the DS_LICENSE hashed file: unfortunately this capability (triggers on hashed files) was added to UniVerse only after the split from DataStage....

Shortly is not now. We're doing some recording the week of June 25-29.

I don't know the answer to your second question, but believe it is yes.