DSXchange

I tried DSLogInfo and I am sure about I am passing correct Parameters, There is one post in DSxchange itself related to my question http://dsxchange.com/viewtopic.php?t=103379&postdays=0&postorder=asc&start=15&sid=de51cbba03c24d5ca7ebf2dd44ea602f . But I am not able to find the solut...

I am calling it in diffrent job ,and there is whole diffrent setup together, I think we are deviating from the Original question ,My question is I am unable to get the row count fron the routine when I call it thru DS Designer(From Job or even when I run it thru Repository browser), but the same rou...

I am calling the routine in a stage variable of a transformer, My arguments are , JobName, SourceStage Name and Source Link Name, and SImilarly Destination stage name and Destination Link Name. This basiacalyy and Audit Routine which capture the status of job after it execution. where I need source ...

#Include DSINCLUDE DSD_STAGE.H #Include DSINCLUDE JOBCONTROL.H #Include DSINCLUDE DSD.H #Include DSINCLUDE DSD_RTSTATUS.H Ans = 0 ERRORCODE = 0 RejEntrWarn = "No error message" RejEntrFatal = "" JOBHANDLE = DSAttachJob(JobName,DSJ.ERRWARN) ErrCode = DSWaitForJob(JOBHANDLE) LastR...

Sorry Kumar ,I am still unable to trace the solutuion, I am unable to find the monitor tab in the DS administrator. Possile reason is as I am using Server edition. I have never worked on PX, so dont have any Idea about it , Will be great full to you if you can explain me the solution.

Hi all , I am getting problem to fetch row count for a given link, I have writen one routine for fetch the row count . I am using DSGetLinkInfo to fetch the row count.Strange thing happeing here is When i run the routine from DS Manager it give me the correct result , but when I am trying to call th...

Done

Genius, You gave me the solution ......
Thanks Kumar

I got one pattern by how the reject file is caputring the rejected row, ITs capturing the multiple of 1000 th rejected record. means if there are 4000 rejected records from database its capturing 1000 th, 2000 th, 3000th and 4000 th record only. Is there any settings I have to change to capture all ...

There is nothing special about the records which are capturing in to reject file , In my job I am passing a primary key column as null in each reocrds, due to which table is rejecting them. One strange thing, Only the particular set of records are capturing in the reject file , How can we find the e...

Kumar,My tables are fact tables, if I will lookup on this even extracting them in to a hash file , it will be a performance issue for us. So is there no other way to get the all rejcted rows thru transformer and any thing else? Why link variables "Rejected" doesn't capture all records?

Hi all, I have a problem while capturing Rejected records from an Oracle stage. I want to capture records which could be rejected from the database due to some constraints on the database table. My problem is when I am trying to capture records in a Sequential file , Its capturing only few rejected ...

Ya thanks Kumar , Now Its working for me too if I give HR>=0 and simillarly for MN and SC . My mistake was, I was giving it as HR >-1 and when I give the input as "/9" its returning succesful, Strange.....,Anyways I got the solution , One again thanks for help.

Thanks Kumar and Ray for your help , But Kumar when I use the other way I stil have one problem , The code is accepting "/9" as valid number which is not correct .

I treid your IsValid function , Its also not giving the valid result. when I pass 25:00:00 its returning 1.