DSXchange

Hi All

Sorry for coming back again! The solution was working fine if we have one primary key. But we have some tables with composite key. In that case how can I pass multiple keys to Difference stage ?

Please advice.

Thank you all

Thank you all for your suggestions. It worked as you all suggested, in the Difference stage i have parametrized the key column and i am passing the value from a file through a perl script.

Thanks all again

Thanks for your reply Ray.

Is there any other stage that i can use to escape the key column ?

Thanks again

Hi Everyone We are trying to compare two tables with same structure from different schemas. We have about 300 tables in both schemas. Instead of developing separate jobs, we want to build a single common job with run time column propagation on and loop the table names through the sequencer. I have b...

it takes advantage of having multiple links coming from a Transformer, and wrapping those into a single transaction I was actually going through that in HELP files and I am not sure how to implement that Units Of Work logic. Let me check couple of sample jobs and see if I can get it working. Thanks...

Hi, We are trying to get used to processing messages to/from MQ using WebSphere MQSeries Stage in 7.5 server environment. We are using Destructive read with commit/backout at the end options to make sure we are only deleting messages after everything is processed successfully. Our jobs design involv...

You can install dsjob and its associated liraries wherever you like. Thanks Ray. This is what I want to make sure if I can install just dsjob & corresponding binaries on unix machine. I couldnt find anything specific in this regard in install/upgrade guide. I will ask our datastage admin to giv...

You can call dsjob on server A and tell it to start a job on DataStage Server B. If you can "ping" it and it has DS installed and you have a valid userid/password combination you can issue dsjob commands to your heart's content. I am able to ping B from A. On A we dont have any datastage ...

On A we dont have any datastage components server/client.

ArndW wrote:You can start jobs on UNIX using the "dsjob" command - even remotely.

is that by opening ssh connection from A to B and then issuing the command on B??

Or any other method?

I was wondering if we can install datastage client or atleast the ds command line interface on a unix machine. From the documentation it looks like complete client can only be installed on Windows machines .. But just wanted to make sure that. Our requirement is we have some java scripts on unix-A m...

could it have something to do with unix exit codes, which are in the range of 0-255?

We have a job that is in running state for long time even though it is not processing anything. We have identified the reason as log file becoming huge (more than 2.5gb!!) and it started giving "... computed blink do not match .." error while trying to access director logs. After identifyi...

>>The column b need not be generated Above logic will not generate B .. you can TRY this: stage variables: sv_2old, sv_counter, sv_d, sv_2new in same order sv_2old = sv_2new sv_counter = update if sv_2old and sv_2new are different. sv_d = derive depending upon requirement (first char from B and sv_c...

Hi Prasad, You are right on your point.The problem was very much what you stated.I was able to test the same with the inputs that you gave.Thanx a lot for the valuable help that you have provided. Thanks alot. Good!! If you still want the update happen when c2 matches .. you can update the where cl...

what is the data type of B?? is the length of B alwase fixed?? anyway this is what I would do .. stage variables: sv_1, sv_2, sv_3 sv_1 (counter) if not initialized yet initialize sv_1 else compare with sv_2 if they are different update counter else have same value sv_2 = B sv_3= first char of B : s...