Read Only Jobs
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
Read Only Jobs
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
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.
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.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
Thanks a lot!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.
Usin the query worked out!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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>>');
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: