Rodney might be thinking of the "Who'll be a Soldier for Marlborough With Me" song, which originated a lot later than Marlborough in the early 1700s. That was the War of the Spanish Succession, sixty years after the English Civil War.