DSXchange

Hi,
I set the designer run limit option (Job run options, limits tab) to limit it to one row. Once I have this working fine, i had planned to use job control api to set the row limit to one row.

--Raghu

ketfos wrote:Hi,
How are you limiting your job to terminate after one row?
Ketfos

Hi Ketfos,
I could use it, and have modified my job to make sure it works fine.

ketfos wrote:Hi,
I ahve not understood why
"Insert new or Update exisitng rows"
option is not being used here?

Ketfos

The only source is the reference input stage.

amsh76 wrote:Is there any source in your job, or its just starts from TX ?

Hi Ketfos, Thank you for your suggestion. The test for IsNull() is fully functional and is working fine. I did try replacing the IsNull with your suggestion, but that did not work. It may be the way I have the constraints setup. In the Transformer stage, I execute the following: If IsNull(RefStream....

Hi Experts, Please shed some light on the runaway process I am encountering. The job I am designing is trying to accomplish the following: The job has to insert a new record in the table if no record exists with the given key (collectionName). If the record exists, then it just has to update a singl...

Hi John, Thank you for responding. Let me eloborate on my setup here. I have the DataStage server running on my desktop and the designer is installed on the same machine too. I had added the path information for the 'plink' in the user PATH settings. I was also connecting to the DataStage server wit...

Hi All, This is my first post. I searched the forum and did not find any earlier post to help me with this one. The DSExecute statement in my server routine fails to execute the command passed to it, even with the correct path settings. The error message returned is: 'plink' is not recognized as an ...