I've been reading where SQL Plus allows you to create an interactive WHERE clause to prompt for a value before it executes. Is there a way to do this with DB2? Before I execute for example SELECT PHONE WHERE BUSINESS = 'ABC', I'd like SQL to prompt me for a value to enter for the BUSINESS field. Thanks.

Ultimately, we're testing Oracle Application Server 10g Web Portal to let our users pull data from DB2 and display on the web. It works so far, except for the prompting part.

this should be intercepted by the web page, and have the possibility to accept this field. The sql statement should be translated to add this entered value
native sql / db2 tools do not have this prompting.. you need tools like QMF or other...

Use standart *NIX shell like bash,ch.
Or you cah download MSYS from www.sourceforge.com

here is an example:

#!/bin/bash
echo Enter username: ; read USERNAME;
db2 connect to test user ${USERNAME};
echo Enter tablename: ; read VAR;
db2 "select * from syscat.tables where tabname='${VAR}'"