An American pharmacist has told his parents he was sure he was going to die when a gunman stormed the hospital where he worked in Yemen.