DSXchange

You need to specify the reject link from the same transformer which feeds the DB2 stage. The constraint of the reject link will be <<DBLINK>>.REJECTED where DBLINK is the link name going to your DB2 stage. Thanks a lot for the valuable responces... my issue has resolved, as said by guru, given in t...

If you are designing something like this: DB2 >>> Transformer >>> Target V V Reject file On whatever constraints or condition you want to capture the rejected records, define them in the transformer stage for the "reject file" link. hey us1aslam1us thanx for the responce, mu design is lik...

Hi, i have a req like need to collect the reject rows from the DB2 API stage, for this i have learn from the help that need to do the folowing: 1)Set the Parameter Array Size property to 1. 2)Use a Transformer stage to redirect the rejected rows. i have set the parameter array size to 1 in the DB2AP...

DB2 wants dates in internal format, from what I recall. Try just the Iconv part and see how that works. ... what u said is perfect...!! no warnings regarding this kind of. thanks a lot,but there are other kind of warnings again the job has aborted, anyhow am happy that one thing has resolved. thank...

Target database? Stage used? Derivation? Details, man, details! :wink: ... hey chulett...:-D am sorry , my source is seq and target is db2, there is only a transformer between the seq and DB2-api stage. i tried using Oconv(Iconv(T1.CNT_DT,"D-YMD"),"D-YMD[4,2,2]") but did not wor...

Hi , An intial intro to my self : am new to server jobs. jst have a warning which aborts my job, i want to fix that warning,i need ur help. the warning is like this: Transformer_7: At row 1, link "DSLink8", while processing column "CNT_DT" Value treated as NULL Attempt to convert...

ooh again came back to same stuff..... :-( so in server jobs .. we can use the same method..? like caling the routine inthe transformer ? i dont know wether i can use a server job , but i wil try this for a backup . is there any other soution for me..?? where i can use in my paralel , so that i want...

Hi .... :-( i dint get any notification mail..then i checked the job log details..has some warnings ..one onf them reads.... "CopyOfcontrol_report(BASIC_Transformer_169).#0.BASIC_Transformer_169 (DSSetUserStatus): Error reading Job Status record. JobNo = 511 JobName = CopyOfcontrol_report.#0 Wa...

yes, this alowed me to compile. and sequence is finished. but i have given a condition like if the value is >0 then send the mail notification. how can i know what is the value in the userstatus..?? is there any method to see the value. thanks a lot chullet. am happy that am very near to the solution.

Hi Chullet , thnx a lot. i tried giving $UserStatus but dint not worked ,got the same warning. i gave $userstatus because the stage variable name i have given is userstatus. is there any process am missing. how the sequence will identify this userstatus..?? do i need to pass this variable as a param...

ray.wurlod wrote:Now that you know where to find it, don't use it.

If you do, your complaints about performance will fall on deaf ears. ...

Hi ray,
ya now i found that. teh reason am using it because i wud like to use a routine created for userstatus. seems i dont have any other option in the parellel jobs.

Hi chullet, really thanx a lot for ur guidence. as u said , now am having basic transformer. 1) i created a routine(transformer) Rowcount(arg) Call DSSetUserStatus(Arg1) Ans = 0 2) in the Basic transformer used a stage variable 'userstatus' and called the above routine as below. Rowcount(Read1.REJ_R...

balajisr wrote:It is under processing node of the parallel stage type in the customize pallet dialog box

Hi balajisr,
thanks fro the quick reply,
i dint find any such transformer.
i also ..tried..to customise...but i dint find in that list.

HI all,
i herd this basic transformer (which accepts server routines) many times. can any body tell me where do i find this..in my pallete there is no such transformer.

Hi thanx a lot chulett this shud make me close to solution. let me exlain in clear.. am having a job wich retrives some fields from a table in that one is "rowcount" that job will store all the data in to a flat file ,my req is if tht rowcount has 0 no issues if it has >0 then need to have...