DSXchange

Thanks for your quick reply Ray. I'll investigate what you suggest in that thread.

Garth

We have a job that runs for multiple countries, each having different transformation rules depending on the country that is being processed. Some derivations are becoming overly complex and difficult to maintain (if then else statements etc). We have tried creating a lookup table that contains these...

Add in an extra little part (Iconv(DSLink3.Field001,"MCN"):

Ans = If DSLink3.Field001[1,1]="-" Then "-":Fmt(Iconv(DSLink3.Field001,"MCN"),'18"0"R5') Else Fmt(DSLink3.Field001,'18"0"R5')

I definatley exported it, and I included read only objects

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

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.

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

Thanks for the advice Ken. I didn't know about the co-install on the same server.

Thanks Klaus, The problem I have is that the 7.1 production server cannot be upgraded until 2 weeks time, meanwhile our 7.1 dev server is being decomissioned and all code copied to the new 7.5.1a server. Crazy, I know, so if I have to make any emergency job fixes, these have to be created as 7.5.1a ...

I find myself in an awkward situation that I've never been in, but can't get out of for the next 2 weeks: We are in the process of upgrading to DS 7.5.1a from 7.1. Can I export a job from 7.5.1a and import to 7.1? This is something I would never normally try, but my complex test job ran without any ...

I use the transform srNVL on each input column to set NULLS to empty strings before concatinating.

I know this is an old post, but I came across it after having the same minor problem as Peter. I found I could simply highlight the entry in the host system drop down list, then delete it. It is then permanently removed from the list. Deleting entries from the registry did not work for me.

Hi, I've seen this error message before, ask your DBA to rebind the database. It's been a while since I saw that error, but let me know if it works.

Thanks Ogmios

Your advice on this topic was very helpful. We had the same problem today, and thanks to DSXchange, this is no longer a problem.

Sorry, I don't think I'll be of much help with your setup because our DataStage installation is on Unix. Have you done a search on the internet to help diagnosing your Win32 error?

Yes! I use the DB2 plugin to access DB2 on Unix and AS400.