DSXchange

Hi Ray ,

So do i need to use a routine to get the row count and use that routine in after job subroutine in job properties. Can you what is the after job subroutine type do i need to use as there are different types.

thanks in advance

Hi , I dont have any idea of how to use it after job subroutine.I men how to use that function in after job subroutine and can you please explain me how to use that function in afte job subroutine as do i need to use a routine to use it in after job subroutine. Can anyone please explain me how to us...

Hi ,

i am using within the job giving the stage name , link name and owcount function.

Thanks in advance

Hi , I have to find the row count in my scenario and i am using DSGETLINKINFO and i m giving the stage name, link name and the DSJ.LINKROWCOUNT for row count , but i am getting the ersult with 1 row less. i mean if the row count is 5 , when i use the function , it is giving me 4 i.e. one value less ...

What is the desired format of the target table that receives the rejected records and associated information (in particular, what are you using for its key)? Some more information about the "business ... hi ray, The key for the target table is surrogate id and the rows of the target table is b...

Hi ,

I would like to know whether the above scenario is possible to design a job or it is not possible?

Please anyone suggest me how to solve this issue.

thanks in advance

Hi , I need a scenario where i need to create a job for the rejected data. scenario is If i have a source which has 2 business keys , and if i got 5 rows of reject data then i have to insert the data in a table in such a way that each business key has to have all the 5 rejected records i.e i need to...

Hi craig,

I could solve it as i m taking the time as 900 instead of 0900 so that is creating a space.

thanks for all your support

Hi ,

I see there is no extra space between hash sign or two values but still getting the same issue.

thanks in advance

Because there's a space in the filename. If that is legitimate, you'll need to quote the filename so it doesn't think there are two files to delete. ... But when a file is created , it is creating without any spaces and it is creating only one file and what is the solution to remove the space as i ...

Hi craig , the command o/p is as follows RejectDelete..JobControl (@Execute_Command_3): Executed: del N:\DSLink15\Reject_20110114 83803.txt Reply=0 Output from command ====> Could Not Find N:\DSLink15\Reject_20110114 Could Not Find F:\DSLink23\83803.txt for some easons it is not recognizing as Rejec...

Hi craig, I am trying to delete a file using After-job subroutine where i am using execdos and input value is del#pathname##filename#. And my filename has Date and Time associated and when i run the job, o/p from the command says that couldnt delete as it is trynfg to recognize the filename as FIlen...

Hi ,

Ray : I will definitely obtain the Premium membership.

Craig: i am running my job using a batch file and shoulld i write a script for file delete?

Hi Ray,

I cant see the code as i dont have membership i guess. Can you please post the code again as i am really sorry for not having the premium membership.

thanks in advance

Hi ,

My file is not having a header line and can you please tell me how to create a header line for a file and can you please tell me what is the after-job subroutine that i have to use and how to delete.

Any help o suggestions is really appreciated.

thanks in advance