Cannot view Data from DS Designer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
Cannot view Data from DS Designer
I am using a PX job which is populating a DB2 table from source DB2 table. Target is an exact copy of the source except that the target table name is different (thats obvious ).
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When Write Method is "Load" the bulk loader will be invoked. View Data can not "view" the bulk loader, which is why View Data is disabled. Switch the Write Method to "Upsert" and View Data will be enabled (but several of your other stage properties will be invalidated).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Is the 'View Data' button visible or grayed out? If it is visible, then what is the error message that you see when you click on 'View Data'?
FYI: If everything is defined right, then you should be able to view data even if the DB2/UDB stage is used as the target stage. Period.
Whale.
FYI: If everything is defined right, then you should be able to view data even if the DB2/UDB stage is used as the target stage. Period.
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
The View Data button itself is not there in the Properties. Also when I right click the target stage, the View Data item is absent.I_Server_Whale wrote:Is the 'View Data' button visible or grayed out? If it is visible, then what is the error message that you see when you click on 'View Data'?
FYI: If everything is defined right, then you should be able to view data even if the DB2/UDB stage is used as the target stage. Period.
Whale.
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you use a Lookup File Set stage you won't get View Data either. Some stages just don't support it. Any stage that invokes a bulk loader does not support View Data when in bulk loader mode. End of story.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
ray.wurlod wrote:If you use a Lookup File Set stage you won't get View Data either. Some stages just don't support it. Any stage that invokes a bulk loader does not support View Data when in bulk loader mode. End o ...
So if at all I want to view data in the target, what options should I specify in the properties?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: