Magento : Update stock qty and status for different stores -

right trying update stock status using following query

$sql            = "update " . _gettablename('cataloginventory_stock_item') . " csi,                    " . _gettablename('cataloginventory_stock_status') . " css                    set                    csi.qty = ?,                    csi.is_in_stock = ?,                    css.qty = ?,                    css.stock_status = ?                                       csi.product_id = ?                    , css.website_id = ?                    , csi.product_id = css.product_id"; 

//update ca inventory

 $connection->query($sql, array($newqtyca, $isinstockca, $newqtyca, $stockstatusca, $productid,$website_id_ca)); 

//update usa inventory

$connection->query($sql, array($newqtyus, $isinstockus, $newqtyus, $stockstatusus, $productid,$website_id_us)); 

but query doesn't update stock site appropriately, can let me know how achieve this

by default not possible, stock global not store(_view) based. have add product attribute stocks.