DSXchange

... please get back to me on this immediately. We're sorry, but Ascential technical support receives money from customers to respond immediately, we don't. We're here as a courtesy in the spirit of sharing knowledge and improving our craft. A job cannot call an after-job routine that resets itself....

If your job takes less than 2 minutes to run, you have a chance of succeeding. But, we cannot even begin to help you past that comment because we don't know what you are trying to do. If you have issue with scheduling a 2 minute repeating task, then use an enterprise scheduler that executes the dsjo...

Use the dsjob command line program to build your job control. Simply use shell commands within your Batch job to execute the dsjob program to do what you need.

I think the issue comes down to one fundamental design choice: Using hash files as temporary, throw-away structures or using them as persistent data stores. When temporary, dynamic hash files with a minimum modulus, created on the fly, wiped out if necessary, are used in a design, you have little ma...

Exports. No question about it. Since everything about job designs, metadata, and functions, are in binary files, the only way to do a "selective" restore is from an export file. A directory copy or backup is simply a bitwise image at that point in time.

What command to be given in DS Admin console to find a job?? The only command you can give is a DS Engine command, and the DS Engine is a code branch of IBM's Universe product, therefore Arnd has pointed you in the right direction. Look here for commentary: m Also, can anyone suggest me a place whe...

FIELD(link.column, ".", 1)

Also look at how all of the aspects of ETL are being positioned to make it a "Universal Data Connector". There's that funny IBM commerical where this massive black box is sitting on a conference table surrounded by senior executives of some nameless software company. The black box has every kind of ...

PX is the future platform, not Server. It's only a matter of time. I sure hope they make it more friendly before they bury Server. The Designer stages are, IMHO, unfriendly and unwieldy. The job designing is arduous, whereas Server is so easy to use. I think once the Windoze version of PX is release...

You have to use the DS Engine command shell. Telnet to the server and go to the DSEngine directory, execute ". ./dsenv", and then either "bin/uvsh" or "bin/dssh" depending on your version of DataStage. You have to connect to your DataStage project using "LOGTO yourprojectname" where yourprojectname ...

The dictionary is a "D_yourhashfilename" file created when a hash file is created. It is what the SELECT command uses to parse the hash file. So, if the hash file has a bad dictionary, it's not used by the hash file stage. But, when you use the SELECT feature with clauses, it DOES use the dictionary...

I do it the same way you did it, it absolutely guarantees that each key is identified and datatyped. The only downside is that this statement must be kept in sync with any file structural changes, such as moving columns around. Other than that, it's a very fast technique to drop to a file prior to a...

Make sure the hash file has been created using the EXACT metadata of the job. If your hash file has a "dictionary" listing other metadata as the primary key because it was created once previously and not removed and recreate under the newer, correct metadata, you will not get the expected results. I...

Do not do a "DEFFUN" statement. Simply put this:


into the top of any function that needs access to job control APIs.

Please post all error messages, a description of the design, as well as any functions you believe are involved.