The following query prompts twice - once for each parameter marker:

SELECT *
FROM ITEMS
WHERE UNITWEIGHT < ? AND NETWEIGHT < ? * 10

How can I get make the second parameter marker take on the value of the first one so the user is only prompted once? Can I name parameters in DB2 SQL?

How about this?

SELECT *
FROM ITEMS
, (VALUES CAST(? AS INTEGER) ) AS p(p_wt)
WHERE UNITWEIGHT < p_wt AND NETWEIGHT < p_wt * 10