After some research I was able to get record count with the UFT GUI script. The variable 'ra' is the record count and you can use that value to validate that there was rows deleted..

Below is the script we used:

Dim con
Dim ra

Set con=CreateObject(''ADODB.Connection'')

con.ConnectionString= ''<>''
con.Open

con.Execute ''exec <>'',ra
msgbox ra

con.Close
Set con=nothing