Page 1 of 1
Unlocking stage types and table defintions
Posted: Thu Sep 21, 2006 4:40 pm
by 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..
Posted: Thu Sep 21, 2006 5:05 pm
by 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..
Re: Unlocking stage types and table defintions
Posted: Thu Sep 21, 2006 5:08 pm
by chandrayadaraju
kool_cons wrote: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';
Posted: Thu Sep 21, 2006 5:28 pm
by ray.wurlod
You may find it easier to search-and-replace the ReadOnly property in the export file. Change it from 1 to 0.