DSXchange

ray.wurlod wrote:DSGetLinkInfo() is a transform function, not a before/after subroutine. You will need to write an interlude before/after subroutine that invokes DSGetLinkInfo().

Thanks Ray! That explained a lot. I will build a customized subroutine for this.

ds_developer wrote:Before/After subroutines don't show up until they are compiled - I just tested it in 7.5.2. Can you see the routine in DS Manager and is its Type Before/After Subroutine?

John

That's exactly what happened. After I compiled the customized subroutine, it shows up in drop down list. Thank you John!

I need to get rowcount of both insert and update to a target table in the job. The best way I found after searching the forum seems using DSGetLinkInfo() in after-job subroutine. My problem is after opening job properties, in after-job subroutine drop down list, I can only see those built-in Before/...

Got a workaround for now: our DBA went to each stored procedure and grant exec permissions

Could you not do your grants and import in another environment where that is less of an issue, development for example? Everything I am trying now is in Dev environment. I can' see these stored procedures in Dev either. Now we need to find out what kind of permission should be to let DataStage see ...

When I try to import the stored procedures the only ones that are listed are ones named dt_**** which are all for version control. These are installed at run time. No other user created procedure names are returned. I did a research on this issue and the only post came up is from 3 years ago: http:/...

If you have any of the UNIX utilities installed you could try doing a "fuser -fux" on the file to identify what processes have a file open. I don't think that the normal Windows utilities let you do that. Thanks for your suggestion. There isn't any UNIX utilities installed on the server, ...

First thank DataStage gurus here, helped me resovled a lot of issues, I am totally new to DataStage. This is my first post here. Please help. What happened was after I stopeed a job, I couldn't open a sequential file in target, here was what I did: I stopped my job by clicking on stop button in Dire...