DSXchange

You create routines in the Routines branch of the Repository. You can do this from Designer or Manager; either opens the same edit window. You do not include the FUNCTION declaration; this is automatically created for you by the edit window. Similarly you do not include the RETURN function, which is...

I can't agree; the fault was reported from DSD.Update, which is one of "theirs".

Are you trying to stuff too many characters into an output column (for example 14 characters into a CHAR(12), or more than 10 digits into an INTEGER)? Are you trying to update a not null column with NULL ?

Examine your DSX file to see whether the job definitions are there. If they aren't, your only other option is to move (rename) the project and restore the project from system backups. If they are there, then try a "restore selected" import to see whether the job designs appear there. If they don't, ...

Is your warnings limit for the job, or for your rejected rows output link (assuming you have one) set to 1 ?

No.

I want to replicate the universe repository into another Relational DB which can be anything... Oracle, SQL Server etc. Thus to be able to do that i need to read the universe repository tables. Is there any other way in which i can do that? The Documentation Tool (from Manager) will do this for you...

Thanks for posting the solution; if even one person finds it on a search in the future it will have been worth while. Would it be too much to ask you also to post it on the PX forum, in case they only search there?

Please post this on the DataStage forum. This forum is to discuss topics in, or desirable to be in, the FAQ forum. The DataStage forum is where you get help on specific questions.
One you post there we'll answer you there. Not being a moderator I can not transfer your message to the other forum.

That information is the proprietary intellectual property of Ascential Software and is not in the public domain. The repository tables are, mainly, published deliberately without column definitions, being intended only to be accessed programmatically. Where Ascential believes it is suitable that you...

Welcome aboard! :D You have a nightmare situation if either of first or middle name may be omitted. In this case you would have no way to know whether the name that appears is a middle name or a first name. Even QualityStage can not solve this one. You need to establish a business rule. For example:...

There's no log file for that, on either the client or the server.

Output from the compiler on stdout and stderr is redirected to the connection to the client.

Welcome aboard! :D Please elaborate on what you mean by "real time". I note that you have identified your question as relating to server jobs, yet posted it in the Forum for parallel jobs. There is also real time interface (RTI), which is a component that can exposes DataStage jobs as web services.

The following query will identify jobs with no design time information. SELECT NAME FMT '40L' from DS_JOBS where NAME NOT LIKE '\\%' -- exclude category names and control records and not exists (select NAME from DS_JOBOBJECTS where DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO) HEADING "Jobs th...

There is a Tutorial that accompanies DataStage. Use this as a starting point.

Check for clashing port numbers.

Although it's unrelated, my current client had a problem getting RTI to work, until it was discovered that Oracle already had the same port number for its web service. The solution was simply to change one of the products' port number.