urgent ..........need help

welcome27

谁会code this..... in db2 sql
---> if i enter a then the sql will list all author name which contain 'a'
for example in java....
system.out.print("enter which author u want to view: ";
String name = input.nextLine();
if(name = 'something')
then print something......

how to code in db2 sql statement
ACCEPT ....... FORMAT A50 PROMPT 'ENTER A AUTHOR NAME : '
SELECT .......
WHERE ....LIKE ......

need help......................