Hello Friends I need to write a funcation or Stroedprocedure in DB2 to do some types of calculations
here is my question:
I have table in DB2 from that table I need to pass two colums values to the Funcation ..
in this table One coulmn have four fields
ex: State is the Clumn name in that state there may be one city or more than one city my friends are staying.. so If my friends are statying in more then one state I need to take the Money value from State--->City($34) // this is the one column value I need to pass to the funcation Second colum is I need to take the intrestt rate ($3) So funcation needs to do some thing like sthis
city1 * Intrest2 + city2 * intrest2 + city3 * intrste3 this value I need to put in other column other table Thanks