I think he should see his doctor,who will know if his impotence could be related to his illness,and may refer him to see a urologist for further investigation to his problem.
The fact he recognises the problem is a major step in the right direction,and various means of treatment are available ie: vacuum pump,injections that will help sustain an erection for 30mins or so,last but not least viagra