Rollbase Private Cloud with IBM DB2 - Foreign Key Problem

Posted by tarnold on 15-May-2014 02:54

Hello,

I'm new to Rollbase and currently evaluating the private cloud version. In our company we have existing DB2 Databases and so it would be great to use them in Rollbase.
Unfortunately DB2 is not officially supported.

Nevertheless, i tried to configure Rollbase to work with DB2. It worked quiet well and I created two objects from external database tables.
My Problem comes in the next step. I want to create an External Relationship between those two objects. When I click on New External Relationship I get to the page where I should choose a foreign key. But the page says: 'None of available columns can be used as Foreign Key'. Do I have to configure something on the object or on the field to use it as foreign key or could the problem be the usage of the unsupported DB2?

Would be great if there's someone who can help me!

All Replies

Posted by Santosh Patel on 15-May-2014 03:35

Hi tarnold,

The columns to be used as Foreign/Primary keys should conform to some constraints. Please check documentation.progress.com/.../index.html and confirm that atleast one column in your external table falls under the said categories.

Regards,

Santosh

This thread is closed