JDBC lookup problem while importing view structure as External Definition

[Former Member]

I am trying import the view structure from DB2 database. I am able to import the table structure as external definition. But while trying to import the view structure present in same database schema, I get table not found error.

Is there any extra setting need to be done for importing the view structure or we can import only Table structure and not view as external definition in SAP PI 7.1?

Thanks,

Sandeep

[former_member187339 · Accepted solution]

Hi Sandeep,

In Database views are created with a Query and there no physical existence of it.. But database tables are not like that they have a physical existense.. Hence Views cannot be imported as a External Definition.. Try to create a table which will do the functionality of a view and then import that

Regards

Suraj

[Former Member · Accepted solution]

The database being normalized, it is not possible to have a single table which will hold all the values with same functionality of the view.

To overcome this, we can have a user defined function which can help in reading the view. I am going to try this ...

[Former Member · Accepted solution]

These are the steps-

1. Create the table with same name as of view (view should not be present at the time of creating the table; otherwise it will not allow you to create the table. Field data type and length should be same and the sequence of fields (columns name) should be same as of your view to be.)

2. Import the table structure as a external definition

3. After import, drop the table from database

4. Create the view

Use the imported External definition for JDBC lookup and it will work fine.

Maybe in next coming releases PI can have the view import functionality added.

Thanks

Sandeep Rane

[Former Member · Accepted solution]

Thanks Suraj & Sandeep

[rajasekhar_reddy14]

Hi,

I dont think its possible to import view structure,it supports only table structure.

Regards,

Raj