![Smile :)](./images/smilies/icon_smile.gif)
The structure of the job is like this:
Source DB2 Stage------------>Transformer------------->Target DB2 Stage
Target Properties:
Write Method : Load
Write Mode : Append
The job is running fine with no warnings and the data is getting populated in target. But I am not able to view the target data using the "View Data" option in Designer. I can view this data externally by using SQL commands.
When I checked the properties of the DB2 target stage, I was amazed to find that the "View Data" button on the top right corner of
Input ->Properties Tab is missing. There is only the "Columns" button.
Also on right clicking on the target DB2 stage there is no option for viewing data. Can anyone explain this? Thanks in advance
![Smile :)](./images/smilies/icon_smile.gif)