DSXchange

Maybe you need the B1 and B2 stage?!!! :lol: (Australian joke) The message suggests that you're trying to delete (or replace, which is delete-then-insert) rows in a table that is referenced by foreign keys in another table. Perhaps you missed disabling the constraints on the referencing table(s)?

When dumping the worksheet into a CSV file, what character mapping (code page) are you specifying?

Where do the "?" characters in the error message come from?

Kartheek wrote:Command failed to execute - e:\apps\ascential\Projects\xxx>More? .
Log file is created which contains this message 'e:\apps\ascential\Projects\xxx>More?'

Use a Job activity upstream of the User Variables activity. In that Job activity run a job to fetch the value from Oracle and park it somewhere, for example in the job's user status area or in a file. The User Variables activity can then assign a value to the variable by accessing that value.

From your description (exact text for description) I'd suggest a simple If..Then..Else construct would suffice.

Basically because the record contains more quote characters in total than the parser expects to find. Can you perhaps read with Quote Character set to None, then trim the end quotes from each string?

The great thing about standards is that there are so many to choose from.

Q: How many Microsoft engineers does it take to change a light bulb?
A: None. They simply define a new standard called "darkness".

Mostly, however, you have to use the function type "Before/After Subroutine". Before you make the change, copy the code at least to your clipboad, because you may lose the code when making the change.

A before/after subroutine has precisely two arguments.

Thank you. It was simple (and presumably helpful) three years ago too.

APT_DISABLE_COMBINATION

DataStage names links Link_n where n is the order that the object was added to the design. You can call links whatever you like, provided that the name begins with a letter and contains only letters and underscore characters. There's probably a name length limit too.

What is the routine type (on its General tab)?

No idea. For diagnostic purposes start by disabling operator combination, to learn which stage is throwing the error. Then it might make more sense.

? is a special character to the DOS shell. Don't use it. The Command stage needs to retain control - starting a background process means that it loses control.

Declare them in a User Variables activity - they remain accessible to any activity downstream (that is, linked via any pathway to the User Variables activity).