Unlocking stage types and table defintions

[kool_cons]

Hi,

we are exported all the routines,stage type and table definitions as read only to new project. we want to make non-read only. I know there is a command to make non-read onlyfor jobs not for others(routines,table definitions). If you guys know the command to make it non-read only, please help me..

[meena]

Hi
You can do this in Administrator/Project/Properties/ProtectProject.Need more help do a search in the Forum.

I know there is a command to make non-read onlyfor jobs not for others(routines,table definitions). If you guys know the command to make it non-read only, please help me..

[chandrayadaraju]

Hi,

we are exported all the routines,stage type and table definitions as read only to new project. we want to make non-read only. I know there is a command to make non-read onlyfor jobs not for others(routines,table definitions). If you guys know the command to make it non-read only, please help me..

Here the commands

Job designs
Code:
UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' WHERE READONLY = 'RO';

Routines Code:
UPDATE DS_ROUTINES SET READONLY = 'NRO' WHERE READONLY = 'RO';

Transforms
Code:
UPDATE DS_TRANSFORMS SET READONLY = 'NRO' WHERE READONLY = 'RO';

Data Elements
Code:
UPDATE DS_DATATYPES SET READONLY = 'NRO' WHERE READONLY = 'RO';

Table Definitions
Code:
UPDATE DS_METADATA SET READONLY = 'NRO' WHERE READONLY = 'RO';

Shared Containers
Code:
UPDATE DS_CONTAINERS SET READONLY = 'NRO' WHERE READONLY = 'RO';

[ray.wurlod]

You may find it easier to search-and-replace the ReadOnly property in the export file. Change it from 1 to 0.