DSXchange

Hi,

My project is not read-only (i.e it is unprotected)
and still a job is read-only.

Plz explain how to remove this read-only option.

Thx,
Asit

Protected and Readonly are different parameters.
If you have promoted your jobs form Version control as Readonly mode you might get this effect. You can reimport with Non readonly mode.
Alternativly you can execute the follwing command in the Command option available in Datastage administrator .
Or you can find a flag in exported .dsx file called READONLY ='1' change it to 0.

kumar_s wrote:Protected and Readonly are different parameters.
If you have promoted your jobs form Version control as Readonly mode you might get this effect. You can reimport with Non readonly mode.
Alternativly you can execute the follwing command in the Command option available in Datastage administrator

Code: Select all

UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' WHERE READONLY = 'RO'

.
Or you can find a flag in exported .dsx file called READONLY ='1' change it to 0.

Thanks a lot!
Usin the query worked out!

Is'nt that query going to make all read only jobs as !readonly

Everything in there is now NRO.

Everything except the example job supplied by the vendor, which uses a different value to mark it as read-only. This may be a desirable result for jobs - after all, they're all designed in-house, and can be switched back to read-only if desired using a similar UPDATE statement.

Are there any example job available in each project? Or is it refering to built in routines etc.

There is one example job, if I recall correctly. At least in version 7.5x2.