Hi
I'm trying to update a specific custom routine in DS_ROUTINES but I'm not sure of the exact statement. To update all I would use:
UPDATE DS_ROUTINES SET READONLY = 'RO' WHERE READONLY = 'NRO';
My project is not protected, and I can't import a custome routine over an existing one. I hear that there may be a patch for this - I'm waiting for IBM support to get back to me, but I've not heard from them. I haven't been able to use version control while we have two different DataStage server versions installed. Any help would be greatly appreciated.
We're using DS 7.5.1A on AIX 5.3
updating DS_ROUTINES custom routine to 'NRO'
Moderators: chulett, rschirm, roy
You can't import over read-only objects. So I guess you're setting them to read and then trying the import. I've never done this, so I can't help much other than to say make sure your dsx file also shows them as read. Are they even in your dsx file?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Add AND WHERE DSRID = "{your routine}" to the query.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>