Update a READONLY routine
Moderators: chulett, rschirm, roy
Update a READONLY routine
Hello All,
I have created a routine and made it a readonly by exporting the routine and replacing the READONLY from "0" to "1" in DSX file. I imported that routine into another project and trying to change the READONLY status to Not Read Only by executing the below command in Administrator.
UPDATE DS_ROUTINES SET READONLY ='NRO' WHERE DSRID ='myroutinename';
But the above command does not seem to work as I am getting the message "DataStage/SQL: 0 records updated."
Can anyone please help me with this.
Thanks in advance..
mike..
I have created a routine and made it a readonly by exporting the routine and replacing the READONLY from "0" to "1" in DSX file. I imported that routine into another project and trying to change the READONLY status to Not Read Only by executing the below command in Administrator.
UPDATE DS_ROUTINES SET READONLY ='NRO' WHERE DSRID ='myroutinename';
But the above command does not seem to work as I am getting the message "DataStage/SQL: 0 records updated."
Can anyone please help me with this.
Thanks in advance..
mike..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Update a READONLY routine
With 8.1 version, export your routine and change your dsx with 0. Then delete your routine in your project in the developer, you need to be administrator, and import it again.rbpty wrote:Hello All,
I have created a routine and made it a readonly by exporting the routine and replacing the READONLY from "0" to "1" in DSX file. I imported that routine into another project and trying to change the READONLY status to Not Read Only by executing the below command in Administrator.
UPDATE DS_ROUTINES SET READONLY ='NRO' WHERE DSRID ='myroutinename';
But the above command does not seem to work as I am getting the message "DataStage/SQL: 0 records updated."
Can anyone please help me with this.
Thanks in advance..
mike..
Re: Update a READONLY routine
Mike,
I am new to DataStage with just one year experience.
can you please tell me how can we replace the READONLY from "0" to "1" in DSX file. Can we open .dsx file on a windows machine to change from "0" to "1"
I am new to DataStage with just one year experience.
can you please tell me how can we replace the READONLY from "0" to "1" in DSX file. Can we open .dsx file on a windows machine to change from "0" to "1"
The .dsx file is a text file and can be modified with the editor of your choice.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Exactly, Just open it in any editor look for that routine name (Identifier) and then look for Readonly "1" change it to Readonly "0".
Save it and then delete the orignal routine from repository and import it from the modified dsx file.
Save it and then delete the orignal routine from repository and import it from the modified dsx file.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.