DSXchange

Hi, Iam facing a error when Iam using a hash file. I used hash file as look up and Iam writing 9023435 from db2 table to hash file but Iam getting a job abort message after writing 8367235 records.Iam using type (30) with default values is there anything I have to change in options then default valu...

Hi, Please help me to over come this problem. Iam using Hash file (Type 30) as look up to db2 table and Iam getting this error there are 9096946 records in DB2 tables when Iam writing this records to a hash file after 8367235 records the job is aborting saying this error Error : Insert_In2_Product_A...

Hi, Please help me to over come this problem. Iam using Hash file (Type 30) as look up to db2 table and Iam getting this error there are 9096946 records in DB2 tables when Iam writing this records to a hash file after 8367235 records the job is aborting saying this error Error : Insert_In2_Product_A...

Hi,


I want to run dsjob -run command . In which path I have to run this command under my project path . Please tell me where to run dsjob commads




Thanks,
Somaraju

Hi Arvind,


Can you explain me how to make a parameter the value and how to pass that parameter when Iam running the same job again.

Can any one tell me is there any other way than this.



Thanks,
Somaraju

Hi , Iam using a hash file in job for looking in to DB2 table. I read that hash file removes duplicates. I want to know will that effect my job by using hash file for ex: I had material,mandt,variant as keys in hash file. Material ..................mandt....................variant as keys XXXX.........

Hi Kumar, I selected Enter custom sql in DB2 stage and I provided sql as select Distinct xxx, uuu,yyy,zzzz fom ttttttttt where xxx= '230' . But Iam getting the same warning as I mentioned above. duplicate entry warning. You siad allow duplicate in look up stage .How to do that please guide me. Iam g...

Hi Nagesh, Thanks for reply, My problem was solved . I gave input to aggregate stage as decimal (12,2) and output to aggregate stage as decimal (12,2) and I selected decimal output in aggregate stage instead of (8,2 default) I gave as (12,2). Now Iam getting my value as I required Like this 12345678...

Hi ray,


Thanks for the solution. My problem was solved . I made nullable to yes in both input and output of aggregate stage. Thanks for solving my problem.









Thanks,
Somaraju

Hi,

Iam aggregating records and getting output from aggregator as 1.988855e07. I want answer as decimal like this 19888555.00. since aggregator . I gave input to aggregator as double 30,2 and output as double 30,2.


Thanks,
Somaraju.

Hi, Now I connected Aggregator to the source transformer. Now Iam getting a warning saying Aggregator_sum: When checking operator: When binding output interface field "TotalAmount" to field "TotalAmount": Converting a nullable source to a non-nullable result; a fatal runtime erro...

Hi Ray,


Iam inputing Sum(price) char(15) it contains numerical value where as my output columm name contain TotalAmount$. Do you think because of this Iam facing a problem.I checked by removing $ but Iam getting same problem. I checked input file there are no values with $



Thanks,
Somaraju

Hi Meena, My design is in this format seqfile.................lookup (db2table)..............transformer..........seqfile1 ...............................................................................................seqfile2 Price(char15)...............................................................

Hi Please help me to over come this problem. I have job which is using aggregate stage . I have transformer connected to aggregator. my job design is transformer......................................aggregator..........................dataset inputcolumm of TX................................input co...

Hi , I have created a output columm with Dummy and sql as integer and length =1 and I gave value as 1. This dummy is given as input to aggregator to count number of records and Its metadata in ouptut is decimal 8,2. But Iam getting an error saying main_program: Syntax error: Error in "group&quo...