DSXchange

Thanks to all,
This issue due to Web services down,
I moved my job to other server its working fine.
Thanks again.

Thanks to all,
This issue due to Web services down,
I moved my job to other server its working fine.
Thanks again.

And it's apparently not an RTI job but one utilizing the Web Services PACK. Thanks Ray/Craig right ,we convert data to XML formate and send it through Web Services,and in response web services send a acknowledgment to data stage in XML formate. So i have thats only information. So the job is simple...

We used WS Transformer stage in our job,
here is the job flow,
we read database table -->Transformer-->XML output-->WSTransformer--->XML input--->Transformer---> DB table.

Thanks.

shilpa79 wrote:can you explain in deatil in which stage ur facing this problem.

i am getting fatal error in log file.
Its not related to any stages.
i am new to RTI.
but i think its web services is down.
but still suggest me.
Thanks.

Hi all, i am running a server job,which having XML output and XML input, i am getting following fatal error, can some one help me to solve it. ----------------------------------------------------------------------- CopyOfJ_NTWX_SEND_FOCN..WS_RESPONSE_BD: <ns1:Fault xmlns:ns1="http://schemas.xml...

Hi all, i am running a server job,which having XML output and XML input, i am getting following fatal error, can some one help me to solve it. ----------------------------------------------------------------------- CopyOfJ_NTWX_SEND_FOCN..WS_RESPONSE_BD: <ns1:Fault xmlns:ns1="http://schemas.xml...

Thanks

But how can I assure that It will do 1st Update and then Insert. I tried by giving link order but somtimes that is not working.

Thanks

You can drop 'sqlcode' column using Modify Stage or Copy Stage ( which is better)

Thanks

Thanks for reply

But In DS 7.5.2 EE : cant have 2 input links towards a single ODBC Enterprise Stage.

Thanks

Hi, I am doing Upsert: Update then Insert to DB2 Table using ODBC Enterprise Stage. I am using Userdefined query. Update working fine but Insert is not working. In log No Error Massage,No warning. Only insert AND only update works fine with same query If any one come across this type of issue then p...

Try this:

Use copy stage and while mapping on out tab you can change column name.

Thanks

Thanks Ray,

I am doing delete thru DB2 control center ( i.e. Command line ) I am also doing commit after delete.


Thanks

Thank for reply My Expectation: I have to have update and insert both after tranformer. Update : update existing rows based on key column. set values which I got from Tranformer ( in Update link). Insert : Insert record. values which I got in Insert link Rerun : After 1st run I got result X but when...

Hello, I have a job in which I am doing update and insert to a target table. I want to have update 1st and then insert which is I am doing thru 2 dufferent link to 2 DB2UDB API Stage from a transformer(link order of executing is setup) Tranformer--------------->DB2UDB Update --------------->DB2UDB I...