DSXchange

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..

Problem is, that's a 7.x solution for an 8.x problem. With the XMETA repository, I'd imagine you'd need to run some sort of equivalent DML there nowadays. However, not sure if anyone has figured out or posted what that would be yet.

Can anyone know or used the DML statements to update the readonly status on the routines in the Version 8.0. If yes, please shed some light on the DML statements.

I searched the entire documentation and found nothing useful.


I appreciate your help.

Thanks
Mike..

There isn't any. No-one's hacked (or admitted to hacking) the unified metadata repository database yet.

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..

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.

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"

The .dsx file is a text file and can be modified with the editor of your choice.

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.

Thanks..i got it