Hash File
Posted: Tue Jun 14, 2005 1:30 pm
I created an exception Hash file.
Loc_cd
Strt_tm
End_tm
I combined two tables, DB2 and hash file using a Loc_cd. During the join, it is possible that some codes on the DB2 table will not match the hash table. If there is no match I would like to pass a default strt_tm and End_tm that isn't in the hash file. Is there a way to do this.
Thanks
Loc_cd
Strt_tm
End_tm
I combined two tables, DB2 and hash file using a Loc_cd. During the join, it is possible that some codes on the DB2 table will not match the hash table. If there is no match I would like to pass a default strt_tm and End_tm that isn't in the hash file. Is there a way to do this.
Thanks