What is the substitute for update_sql() in D7? I am using update_sql() in hook_update of drupal .install file (D6) ? 

Can update_sql() be used for D7 ?
No, it does not exist any longer. You need to use Schema API function dedicated for what you need to be done. For example to rename field you should use db_change_field.