If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Data Manager and database keys

Started by captain karisma, 22 Feb 2009 11:15:48 PM

Previous topic - Next topic

captain karisma

Hey guys,

I've set up data manager and got my jobstream going and designated my keys in the table delivery options.
However after it successfully runs, i open up SQL2005 and everything is successful but the tables haven't assigned the columns as primary keys.

I want this to be assigned so that in Framework Manager, i can use the first option to match keys.

Does anyone know how i can do this?

Thanks in advance

UseCog

The 'key' option is not to create PKs in the target table and it is to define the update and insert methode. Visit 'Primary Key Settings for Update/Insert'  section in DM document.

However, why cant you create PKs at the backend?

Bst regards,
UG