Cannot view Data from DS Designer

abhilashnair · Post by **abhilashnair** » Fri Dec 22, 2006 12:19 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Dec 22, 2006 12:40 am

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).

abhilashnair · Post by **abhilashnair** » Fri Dec 22, 2006 2:44 am

I tried the following

Write Method: Upsert
No effect.

Write Method: Write.
No Effect.

What about the Write Mode? Should that be changed as well?

ray.wurlod · Post by **ray.wurlod** » Fri Dec 22, 2006 3:56 pm

Yes, in fact that's the property I meant. (I don't have access to DS at the moment.)

abhilashnair · Post by **abhilashnair** » Sun Dec 24, 2006 1:23 am

Tried changing the write mode also. Still no effect

us1aslam1us · Post by **us1aslam1us** » Sun Dec 24, 2006 2:05 am

Unless you are using the API stage, you won't be able to perform view-data. I guess you are using the Enterprise stage, which doesn't have that available.

Sam

abhilashnair · Post by **abhilashnair** » Mon Dec 25, 2006 1:18 am

I am using the DB2/UDB stage from the pallete. But the same, I have used in source as well as target. I am able to view data in source. Not in target. Please explain

I_Server_Whale · Post by **I_Server_Whale** » Mon Dec 25, 2006 1:26 pm

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.

us1aslam1us · Post by **us1aslam1us** » Mon Dec 25, 2006 1:41 pm

I suggest you to read Ray's post again. In both Bulk load stage and Enterprise stage, the bulk loader will get invoked and you won't be able to 'View Data' unless you are using API stage.

Sam

abhilashnair · Post by **abhilashnair** » Thu Dec 28, 2006 4:46 am

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.

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.

abhilashnair · Post by **abhilashnair** » Thu Dec 28, 2006 4:46 am

us1aslam1us wrote:I suggest you to read Ray's post again. In both Bulk load stage and Enterprise stage, the bulk loader will get invoked and you won't be able to 'View Data' unless you are using API stage.

Sam

If I use the API stage, I wont get parallel functionality. So I cant use that.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 28, 2006 6:31 am

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.

abhilashnair · Post by **abhilashnair** » Fri Dec 29, 2006 4:49 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?

DSguru2B · Post by **DSguru2B** » Fri Dec 29, 2006 8:29 am

That rest of Rays message said 'End of Story'. If you still dont agree, you will have to take this upto IBM. Nothing we can do. Use your favourite sql tool to view the data.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 29, 2006 3:32 pm

Create another job with an Oracle Enterprise stage and an output link. Use View Data there.