DSXchange

HI chulett, I AM GETTING THE FOLLOWING ERROR. DataStage Job 7887 Phantom 28820 Program "JOB.406432813.DT.1473864463.TRANS3": Line 238, Nonnumeric data when numeric required. Zero used. Hi Satya, Please crosscheck metadata of stage across TABLE metadata. If both are in sync, then in that c...

HI chulett, I AM GETTING THE FOLLOWING ERROR. DataStage Job 7887 Phantom 28820 Program "JOB.406432813.DT.1473864463.TRANS3": Line 238, Nonnumeric data when numeric required. Zero used. Hi Satya, Please crosscheck metadata of stage across TABLE metadata. If both are in sync, then in that c...

hi, i am getting the following error,"a non-numeric character was found where a numeric was expected" . after 5 million data i am getting this error. please help me ASAP. Yes as Narasimha said, check source data, am sharing similar exp in this regard, target column is Decimal and from sou...

Hi, I am working with Datastage7.1 server edition, we have done a similar multi processing technique using MULTIPLE INSTANCE option available in JOB PROPERTIES, and we utilise 4 CPU's at around 80-90%. But for implementing the technique, we need to partition the source data as Mr.Rubu has said.There...

Your file is not sorted as you have asserted on the input of your Aggregator stage or, perhaps, the first line of your file is column headings and you have not asserted in the Sequential File stage th ... Hi Ray, Thank you for your inputs, yes i resolved by myself, what you have mentioned was corre...

Hi, I got abnormal abort before Aggregator stage in a particular job The Job does as mentioned below Input is a sorted flat file, an aggregator stage follows which does Sum(Values) and then writes to output file. The abort is happening in the input link to Aggregator stage and error is line is out o...

Hi, I am just giving my suggestion, u can restrict the matching records using constraint and write rest unmatch records to work file and then write to the same hash file, clear before writing regards Murugan Hi, Lookup data (Hashed File) 123456@10@b 123456@00@c Source data ( Hashed file) 123456@00@c...

Hi, I am using an aggregator stage, in which there is sort of ascending for first 2 fields and am grouping all fields in input for 3 key fields while passing on to a transformer. Here i am facing a "Line out of Sequence" error, Can anyone please let me know what can be the cause for this? ...

chulett wrote:What version of DataStage do you have? What I posted worked fine in the 7.5.x version.

i am using 7.1 version. May be 7.5 supports differently.
Thanks for response.

Joshy & Craig Thank you for your responses I tried both ways as suggested, I used #PARA_NAME#1, #PARA_NAME#2. as well as tried as Joshy suggested, But it dint work out. i got this error Compiling: Source = 'RT_BP1338/JOB.1270435759.DT.1446754774', Object = 'RT_BP1338.O/JOB.1270435759.DT.1446754...

Thank you Joshy & Craig for your response, i shall try it out and get back...Thanks once again....

What exactly is PARM1 and PARM2? :? Hi, Thanks for your response, as i said earlier, a parameter PARM is passed through sequencer and i have to use these in invocation id expression. For each parameter, there are 8 instances, and these 8 instances are triggered simultaneously. So when you execute i...

Hi, I have a sequencer in Multiple instance, sequencer is triggered in 8 instances, based on parameter i pass from main sequencer the sub sequencer should trigger into 16 instances. For ex Main Seq 1 -> PARM1 -> Instance Seq (PARM1.1,PARM1.2....PARM1.8. ) Main Seq 2 -> PARM2 -> Instance Seq (PARM2.1...

Hi,

I have two jobs which are corrupt in my project, i am not able to delete it, when i try to open it or delete, it shows RTCONFIG729 error. How can we remove such jobs.


regards
Murugan

You have filled up your T30FILES descriptors with all of the hashed files you have opened. Look at your uvconfig file settings; you can increase the value to accomodate all these concurrently opened type 30 files, or you can make these files static and thus use other descriptors. The best solution ...