DSXchange

Something has changed since the job was running successfully.

Your task is to find out what it is. It may be something outside of DataStage, possibly in the operating system, file system or database server.

Please post the COBOL layout and the record schema, which you can copy from the Layout tab of the table definition.

BCI.OpenR suggests ODBC or UniVerse stage. A problem is occurring when trying to "open" (establish a connection) in order to perform a SELECT (or execute a stored procedure that returns rows). Check that the authentication information is correct. The easiest way to do this is to open the stage and c...

Is the MDB file open in MS Access somewhere? The error message suggests that it is. MS Access allows only one user at a time to have the file open for editing. The word "unknown" suggests that you are having some difficulty specifying the actual MDB file name. Can you open it remotely via MS Access?...

Can you execute it from another ODBC client on the same machine?

Can you execute it from the DS_CONNECT test utility in DataStage?

You may have noticed by now that, when I criticize something, I use dark red rather than the default colour. Yes, I was trying to make two points about sloppy use of English - it wouldn't really matter whether the poster was from any English-speaking nation, I would have felt enjoined to make the sa...

It is the input field column name, qualified by the name of the input link.

We could always "pop" the digression off the thread "stack", and return to the original question, which was "Can anybody give me details how Datastage Enterprise connection is made to Database?" Actually, I feel it was answered, but the thread is not shown as being resolved.

Are you happy to write a routine?
You can call it from a Routine activity in the controlling job sequence.
Use DSGetNewestLogId() to get the most recent fatal error, or DSGetLogSummary() to get all of them.
Then use DSSendMail() to send the email.

Don't take vacations. Here is one reason why not.

The maximum length of a parameter name is either 255 characters or 768 characters. I don't think that the length of the parameter name was the problem here. Can you please post the complete error message? I suspect that the problem was the value given to the parameter, or perhaps that the parameter ...

Welcome aboard. :D

The problem here is that every link must connect two stages. There is at least one in your design that does not. That link is probably red. Make sure that both ends of it connect to a stage.

exit is very commonly used. I know Hyderabad is in the southern half of India, but you don't need to adopt a Southern US accent ("all" meaning "y'all"). Do you really want ALL 16000+ participants to reply to your query?!! And "plz" is more likely to be a town in the Balkans than a word in English.

The Modify stage also has a string_trim() function. This may be faster than either the Transformer or the Build stage.

Yeah, but the OP had DECIMAL[38,10], which would only allow 28 digits to the left of the decimal place!