Read Only Jobs

[asitagrawal]

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

[kumar_s]

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.

[asitagrawal]

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!

[DSguru2B]

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

[chulett]

Everything in there is now NRO.

[ray.wurlod]

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.

Code: Select all

UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job Name>>');

[kumar_s]

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

[ray.wurlod]

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