The first thing to check is sequence - there are both one-pass and 2-pass logic for precompiler. Some languages you have an option which one to use. In one-pass logic - If the sql statement is before the variable is defined, then you get the message.
More expertise is available on DB2-L Mike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html