DSXchange

Ray and Craig, Thanks a lot for your valuable time and replies. Currently the input is single column having all the three values in the format "23.765980","47.987650","2101.00000" Craig you are right. All these three values are being extracted from a single input field ...

:D Solution: Tried using DS_NO_PROCESS_METADATA environment variable and set the value to 1. This solves the problem. :D

Thank you all for your valueable time and replies. :D

Great!!!! Its working fine. Thank you all. Thanks a lot. :D

Kind Regards

Hello all, I have a question regarding varchar to decimal conversion I have 3 decimal fields in the target table. I'm extracting all these three decimal values from input VarChar field. Input values: InpCol1 -23.765980 InpCol2 - 47.987650 InpCol3 - 2101.00000 I'm using the following derivations in t...

Dear experts,

Thanks a lot for all your replies and time. I will try this out. Many thanks and sorry for my late response.

Kind Regards.

Hello all, I need to subract 5 minutes from a timestamp field. I tried the option DateData1.TmStpFld - 0.5 hours Where DateData1 is the input link TmStpFld is the Timestamp column This is not working. I'm sure this is not correct. Could you please correct me and help me in this regard. Many Thanks &...

Thanks a lot for your valuable suggestion Ken. This is the issue for which I requested your permission and sent you a detailed mail after your go ahead. Hope you would have received the details. Thanks again for your valuable time and kind help. Yes this is the only table having load issue. I have t...

sima, thanks for your reply. The source DB2 source was set as Cursor Stability. I have changed that to Uncommitted Read. Even then the data is not getting loaded.

Thanks v2kmadhav. The records are around 2000 (we have started with test data to check the load). I tried loading field by field I found a bit improvement meaning the progress percentage got increased to 90%. However, the data is not getting loaded at the backend. I changed the transaction size and ...

Thanks for the replies. There is no trigger being set in any of the tables. Even the target is made very simple without any keys or not null columns for test purpose. We still face this issue. What is your transaction isolation setting in the API stage? Transaction size =1; Array Size=1. Sima sorry ...

Thanks v2kmadhav.

Yes, I can the insert/update the target table successfully through DB2 tool, ie., outside DataStage. This proves that there are no locks in the table. I wonder why we are facing the issue with DataStage.

I'm using DB2 API stage. I tried different array size starting from 1. The performance statistics shows me that 102 records are passing into target. However back-end has no rows. Source and target are different.

Everything seems to be perfect. I wonder where the problem is....

Thanks both of you for your replies.

v2kmadhav I tried this possibility also. However the job is in running state only. Please help.

Initially I searched this forum for a long time and tried all possible suggestions. However, the job is in running state for a very long time. Process percent in log is not proceeding after 40 percent. No error/warning message is found in the log file. Its a simple job that involves two stages only....

I tried different possibilities and finally resolved this issue. Now the job is working fine without any warning message. Practical steps that I followed: (may be useful for anybody who is facing similar warning in future) Step:1 I deleted the missing column (Account_Num) from all the stages from st...