DSXchange

What database do you wish to truncate? You can determine a job's status from the previous run at any time prior to submitting the current run request.

Build a Time Dimension table and look up dates against it.

The product itself has a web-based Director client (though this was unpopular and was dropped in version 8.0). You can also obtain DWNav from Kim Duke and there are probably other third-party solutions also.

Use the dsjob command to run the DataStage job. Invoke the stored procedure via whatever command line interface the database you're using happens to have.

I expect you have a single user license for your compiler. Search DSXchange for further clues.

Then you need to add more filtering, as suggested below, or to construct complete metadata for the DS_JOBOBJECTS table so that you can query individual columns therein separately. The vendor has elected not to provide that metadata, so you need to construct the same based on your own researches. Her...

This post explains the DSRID which, although you aren't aware, is what you are asking about.

Unable to connect to admin web console for IIS or WAS. WebSphere Application Server v6 was found not to be started. Started manually but still no connection. The startServer.log shows ************ Start Display Current Environment ************ Host Operating System is Windows XP, version 5.1 Java ve...

Get your network administrator involved. There may be a problem somewhere in the network.

You are already searching for an exact match because '$Table' does not include any wildcard character. LIKE is necessary because you are comparing against the entire DS_JOBOBJECTS record which will never have the value '$Table' alone.

You can ignore this overhead. Environment variables, as the name suggests, become part of the environment, by being loaded into memory. Memory access is pretty much identically costed irrespective of the memory address, and very fast in all cases.

You need to set NLS_LANG, an environment variable that Oracle uses to identify the character set. Search DSXchange for more information.

PLAN AHEA
D

Go back to where you created this unnecessary account (the bin directory) and delete the following:

VOC
VOCLIB
&SAVEDLISTS&
D_VOC
D_VOCLIB
D_&SAVEDLISTS&

Do it sooner rather than later.