Doubt in Hash file
Posted: Fri Feb 17, 2006 1:57 pm
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......................YYYYYY......................uuuuu
XXXX......................YYYYYY........................''
XXXX......................YYYYYY.......................wwww
RRRR......................yyyyyy.........................wwww
I think I can achieve my output if it is like the one above in DB2 table.Then I can write all records in hash file is it write
If I have like this
Material................Mandt.......................Variant as keys
XXXXX...............YYYYY.........................uuuuuu
XXXXX...............YYYYY.........................uuuuuu
SSSSS...............TTTTT.........................RRRRRR
SSSSS...............TTTTT.........................RRRRRR
Then I can have only one record from Db2 table in to hash file because of key. Please correct me if Iam wrong
Thanks,
Somaraju.
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......................YYYYYY......................uuuuu
XXXX......................YYYYYY........................''
XXXX......................YYYYYY.......................wwww
RRRR......................yyyyyy.........................wwww
I think I can achieve my output if it is like the one above in DB2 table.Then I can write all records in hash file is it write
If I have like this
Material................Mandt.......................Variant as keys
XXXXX...............YYYYY.........................uuuuuu
XXXXX...............YYYYY.........................uuuuuu
SSSSS...............TTTTT.........................RRRRRR
SSSSS...............TTTTT.........................RRRRRR
Then I can have only one record from Db2 table in to hash file because of key. Please correct me if Iam wrong
Thanks,
Somaraju.