Get Link Direction within Job via Routine

nishadkapadia · Post by **nishadkapadia** » Tue Sep 26, 2006 1:13 am

Hi,

I am aware that one can get Link Names attached with the stage. However, how does one get Link Direction.

Seq_1 --> Trfm(Transformer)  --> Seq_2

If one wants to know that transformer has only one o/p link to Seq_2 and one i/p link from Seq_1. How does one find the direction of the link name.
I can find the oppsite stage name at the end of the link.

If i have missed while searching the forum, it would be wonderful if one could post the url.

Thanks in anticipation,

ArndW · Post by **ArndW** » Tue Sep 26, 2006 1:18 am

The link "direction" can be retrieved using the DSGetStageInfo() routine call and using the DSJ.LINKTYPES code.

kduke · Post by **kduke** » Tue Sep 26, 2006 7:43 am

Good luck because I don't think it has been posted. It is very complex to tie the ends together especially if there is no transform in between. You need to know a lot about the repository tables. I don't think there is any API call to get this.

kduke · Post by **kduke** » Tue Sep 26, 2006 7:46 am

By the way the stage types are not very useful either. Does CODBCInput actually help you. The Input means it is output to an ODBC table.

ArndW · Post by **ArndW** » Tue Sep 26, 2006 8:13 am

By using DSGetStageInfo() and DSGetLinkInfo() calls and a bit of programming logic you can get the link "direction" information. As Kim stated it is not straightforward but the information is there using the API calls.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 26, 2006 3:17 pm

You do need to be alert to the fact to which Kim alluded, namely that "Input" and "Output" are stage-centric terms. A stage that reads data from a persistent store will have an output link, whereas a stage that writes data to persistent storage will have an input link.

nishadkapadia · Post by **nishadkapadia** » Tue Oct 03, 2006 12:57 am

Thank you all, will try and post my results here.

nishadkapadia · Post by **nishadkapadia** » Sat Oct 14, 2006 8:46 am

Hi,

One can use LinkTypes as suggested. It does work with Active Stages, however if there is a job with Passive stages only, it is not possible using LinkTypes. That is my understanding.

The other route which i tried was using Oletypes for ObjectNames,
which as everybody had explained how to make meaning of it.

However, if just select name,oletype from ds_jobobjects one could
find the meaning however to relate it all only using that much information
was not possible by me. Maybe i am missing something here also.

I just used LinkTypes which worked fine. However, for jobs with only passive stages (luckily there were only a couple) wrote specifically to handle these.

Thank you all once again.

chulett · Post by **chulett** » Sat Oct 14, 2006 8:52 am

nishadkapadia wrote:I just used LinkTypes which worked fine. However, for jobs with only passive stages (luckily there were only a couple) wrote specifically to handle these.

Add one.