DSXchange

Hi, In the dataset management utility in the dataset viewer options there is find a radio button for Partion#.When I am trying to type the partion number it is not allowing me to enter. Configration file two nodes. Partition used Hash. Is this option is there to view the data available only in a par...

Hi Ray/Benouche, Thank you very much. I am using a Dataset the source now. I have changed the partition type to Entire for all links(ie the job which generate the lookup fileset).Also I have changed the partition type of the job which uses the lookup fileset as the reference(ie I have changed the pa...

Hi, I am using a lookup fileset as the lookup and sequentila file as the primary. I am having the following warining when i run the job.I have also tried changing the partition of the input file(primary) to entire.I getting the following warning. Lkp: Input Dataset 0 has partitioning other than Enti...

Hi ArndW, Thanks for the reply.If i perform any calculations on the transformer say for example(a+b) or through a routine in a new column then its gets executed for all the rows in the transformer but why its not the case with this routine alone and in this routine also its returining values differe...

Hi, I need to generate 5 rows from a single row changing only 1 field. Eg:-1 A 10--> 1 A 10 1 A 20 1 A 30. I have written the logic in a routine.I passing the arguments through the transformer(say field1 in arg1,field2 in arg2 etc) I am writing it to a another file.The Routine I am passing it in a n...

Hi Kumar,

I am not doing any explicit conversion.I am allowing it to do implicitly.As ray suggested in the document I have checked from string to integ the conver is default but still the warning comes.But any we can demote it using message handler.

Regards,
Bala

Hi Ray, Thank for the reply.I have rectified all the other errors in my previous question.Only one warining keeps popping each time.I want to know is the waring gets automatically generated or if i use manual convert using some functions then this warning will disappear.Please let me know which type...

Hi, I have a varchar(unicode) field with length(eg:0001) in one source(Dataset).In my lookup source(database) the field has got thesame specfication but only 1 has been entered insted of 0001. I am converting the 0001 field to integer datatype so that my primary has got the same length as the lookup...

Thank you very much so the constraints are executed in the rejected row not on the entire record set.

Hello All, I have a doubt.In Transformer I am applying a constraint and getting the rejects.In the rejects I am performing some filter condition.My doubt is the order of execution How is it get executed constraint 1 Rejections constraint 2. What if I give a constraint in the rejects.Is it performing...

Hi Manoj,

What's the problem.My second job is executing fine with the parameters passed from the first job or from a Batch job.Why DSlogInfo.

REgards,
Bala

Hi kumar,

I have tried both ie calling the job from batch job in Job control and also i tried calling a job in the job-control in a 'job" without having any stages.Both worked.I found that i cannot call the parameters of the same job in the job control.

thank you,
Bala

Hi Kumar,

I have done exactly the same thing and achieved what I want.Thank you very much.

Regards,
Bala

Hi Kumar,

In sequence i am not able to edit the job control. so i can't pass the parameters from the sequence, is there any thing i can do about.

Hi mKeevil,

thank you for the suggesions. I'll try it out.


Regards,
Bala

Hi, I am a text file which has the parameters of a job. I am writing a jobControl in the job OPENSEQ 'D:\F2.TXT' TO F5 ELSE ABORT READSEQ R1 FROM F5 ELSE ABORT A :=R1 J1=DSAttachJob(Job1, ErrorMode) Errocode=DSSetParam(J1,"Param1",A). When I run this job its working fine.The parameter for ...