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..
Unlocking stage types and table defintions
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Tue Mar 28, 2006 5:59 pm
Re: Unlocking stage types and table defintions
Here the commandskool_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..
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';
Chandra M Yadaraju
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: