DSXchange

Is it possible to have 2 port numbers for the same engine?

Schema file will not be an easy option... Do you know the possible delimiters (in this world) that would come in your file? Is it like 2 or 3 or less than 5?

Atul, try giving like this

I have a scenario where I have to run a job through sequence and the output of the job could be -1 0r 1.I need to abort my job if my job returns a value -1 and run it successfully if it returns 1. What is your job doing after outputting -1 or 1? If -1 or 1 is the output of your job, how can you abo...

You should give "Sort criteria, defining which Input Link's Column Names to sort on."

You are able to login to DataStage designer but getting this error while opening a particular job? Are you able to edit other jobs?

If you answer 'yes' for any of the above questions, you need to contact support.

No harm, if you have DSX of that job, try importing..

Looks like you have tried something. One more try and you will understand. They both will not be same when count of output records is not EQUAL to count of input records

In fact, you can parameterize your word as well so that you don't have to edit your job when that word changes.

Like I am looking for a presence of one word in a primary link rather than exact field match and consider it to be matched. You can, by this method. Suppose your one word is 'dummy'. Search both input and look up key column for this word & if found, populate a new column with value 'dummy'. For...

search for PADCHAR in this forum..

Good one Mike.

You can code in dummy parameter and call it from SP stage (as Craig suggested) or call it from ODBC stage...

Where is your input? from sequential file? what is the delimiter? did you try view data when you read your input?

what about this one?

No server or parallel job going forward, but only server and parallel stages. You will always have one canvas to develop your job with both server and parallel stages.

haha.. This discussion should be a new thread though!! Sorry

Siva,

If you have time, you can try this.

1. Uninstall both clients from your machine.
2. Restart the machine
3. Install 7.5 first and then 8.5. (if needed another restart)
4. Try connecting

karthi_gana wrote:In our company we are using DB2 as the repository. I came to know this from the DSADMIN team.

The way you came to know is the BEST way