where can i execute these commands

[sudhakar_viswa]

Hack the readonly flag
This method is not recommended by Ascential and is far less robust then the other methods, it involves changing the readonly flag of components on the internal DataStage repository. The flag is set to "RO" for read only or "NRO" for not read only. Here are commands to change components to readonly:
Job designs
Code:
UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE READONLY = 'NRO';

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

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

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

Table Definitions
Code:
Hi,

where can i execute the following commands.And how can i specify these commands should work for specified job




UPDATE DS_METADATA SET READONLY = 'RO' WHERE READONLY = 'NRO';

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


Contributors
Ray Wurlod
Ken Bland
Kim Duke
Craig Hulett
Vincent McBurney



bye,

sudhakar

[ArndW]

sudhakar,

please take a step back and tell us what you want to do and perhaps why you think it needs to be done. The quoted post you included contains the DataStage TCL commands to reset ALL read-only attributes for ALL objects, routines, transforms and data types and is something you should only do if and when you need to (and when you know what the repercussions might be).

[battaliou]

Click on the "Command" option in your project in Administrator.

Making these commands job specific simply requires entering the name of the object you wish to update i.e.

UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE NAME = 'JOBNAME' ;

or

UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' WHERE NAME = 'JOBNAME' ;

(replace 'JOBNAME' with whatever job name you require to update)

[ray.wurlod]

I suspect (from the contributors list) that Sudhakar was trying to post an FAQ.

[chulett]

With a question buried in the middle of it, apparently:

Hi,

where can i execute the following commands.And how can i specify these commands should work for specified job

[kumar_s]

HI Sudhakar,

If you want to mark some text as code, higlight it and then press the button "Code" fromt the list of option avialabe which you post, Just above the message body.
If you want to Quote those information from some other post, you can use Quote button. And not necessarily to give list of posters name.

That was the cause of the confusion .

-Kumar