How to make the DataStage jobs Read only.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Wed Sep 28, 2005 9:24 am
How to make the DataStage jobs Read only.
Hello Guys
Could any one explain me about how to make a DataStage jobs Read only?
Thanks in Advance
Viny
Could any one explain me about how to make a DataStage jobs Read only?
Thanks in Advance
Viny
Thanks and Regards
Vin
Vin
Hi Viny,
Sevaral option available.
You can change your whole project as Protected using administrator. By making this, only autorised user can access and modify the jobs.
Or while you export using version control you can make your jobs as read only.
Or at you risk you can change the UV files directly.
Sevaral option available.
You can change your whole project as Protected using administrator. By making this, only autorised user can access and modify the jobs.
Or while you export using version control you can make your jobs as read only.
Or at you risk you can change the UV files directly.
Code: Select all
UPDATE DS_JOBOBJECTS SET READONLY = 'RO' NAME LIKE 'job name'
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Three problems with that solution.
1. There's no WHERE in the SQL statement (its location should be obvious).
2. There's no column called NAME in the DS_JOBOBJECTS table.
3. It's more appropriate to change the setting on the DS_JOBS table, which does have a NAME column.
Beware that DataStage SQL is case-sensitive.
1. There's no WHERE in the SQL statement (its location should be obvious).
2. There's no column called NAME in the DS_JOBOBJECTS table.
3. It's more appropriate to change the setting on the DS_JOBS table, which does have a NAME column.
Code: Select all
UPDATE DS_JOBS SET READONLY = 'RO' WHERE NAME = '<<JobName>>';
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.
But actually it does.ray.wurlod wrote:Three problems with that solution.
2. There's no column called NAME in the DS_JOBOBJECTS table.
3. It's more appropriate to change the setting on the DS_JOBS table, which does have a NAME column.Beware that DataStage SQL is case-sensitive.Code: Select all
UPDATE DS_JOBS SET READONLY = 'RO' WHERE NAME = '<<JobName>>';
![Shocked :shock:](./images/smilies/icon_eek.gif)
Though it wont show you while you do a Select * from .....
It will show you if you perform LSIT DICT...
And UPDATE DS_JOBOBJECTS also works.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: