updating DS_ROUTINES custom routine to 'NRO'

garthmac · Post by **garthmac** » Mon Sep 04, 2006 6:42 am

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

kcbland · Post by **kcbland** » Mon Sep 04, 2006 7:16 am

What's the error message?

garthmac · Post by **garthmac** » Mon Sep 04, 2006 7:18 am

Hi Ken

The error I get on importing the routine is "No objects found for import!"

The custom routine is read-only, but I should still be able to import, which will overwrite, just like I can with jobs.

kcbland · Post by **kcbland** » Mon Sep 04, 2006 7:22 am

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?

chulett · Post by **chulett** » Mon Sep 04, 2006 7:23 am

Are you sure you exported it?

You need to explicity include 'read only' objects when doing so.

ArndW · Post by **ArndW** » Mon Sep 04, 2006 7:27 am

Add AND WHERE DSRID = "{your routine}" to the query.

garthmac · Post by **garthmac** » Mon Sep 04, 2006 7:35 am

I definatley exported it, and I included read only objects

Thanks Arnd for the DSRID addition. I've now updated the routine to 'NRO'.