DSGetLinkInfo to get the DSJ.LINKROWCOUNT

turash · Post by **turash** » Tue Oct 23, 2007 8:02 pm

I have server job which extracts rows from Sybase and load to Sequential file.
and it also creates a job report in sequential format.

Job design looks like this

Code: Select all


Source --> Transform1 --> Target
                      |
                      |__ Hash file --> transform2 --> report

I am using following function to get the count for each link

DSGetLinkInfo (DSJ.ME, "Transform1 ", "link1", DSJ.LINKROWCOUNT)
DSGetLinkInfo (DSJ.ME, "Transform1 ", "link2", DSJ.LINKROWCOUNT)

I am putting this into hash file and pass this into sequential file.

Problem : this functions returns 0.

Any help with getting the correct result is appreciated

thanks in advance !

chulett · Post by **chulett** » Tue Oct 23, 2007 8:18 pm

You are calling this where?

Functions of that nature are meant to be used 'after job' or in a separate step in a following job or Sequence activity. Are you doing this inside the running job?

turash · Post by **turash** » Tue Oct 23, 2007 8:42 pm

chulett wrote:You are calling this where?

Functions of that nature are meant to be used 'after job' or in a separate step in a following job or Sequence activity. Are you doing this inside the running job?

I am doing this inside the running job

chulett · Post by **chulett** » Tue Oct 23, 2007 8:57 pm

No can do. Let's approach it from this angle - what are you trying to accomplish?

turash · Post by **turash** » Tue Oct 23, 2007 9:11 pm

Long story short

we have to move data between two transactional database
Source - UDB
Target - Sybase
Work unit to be extracted going to come from MQ series in XML format which will be used as input parameter to extract 50 tables. once the whole sequence of job is completed. I have to create a xml with workunit which got extracted and add job report for each individual job. and if tables have some type of amounts e.g. Premium for a policy. I have to provide the control totals in this case.

chulett wrote:No can do. Let's approach it from this angle - what are you trying to accomplish?

ArndW · Post by **ArndW** » Tue Oct 23, 2007 9:51 pm

The link row counts will work if called from the after-job subroutine.

turash · Post by **turash** » Wed Oct 24, 2007 2:56 pm

ArndW wrote:The link row counts will work if called from the after-job subroutine.

RESOLVED

Code: Select all


Source --> Transform1 --> Target
                      |
                      |__ Hash file --> transform2 --> report

I have moved the function to get out row count to transform2 level
and called
DSGetLinkInfo (DSJ.ME, "Transform1 ", "link2", DSJ.LINKROWCOUNT)

and gives me row count of Transform1

:D