Direct mail bounced...
Sridhar Mahankali writes:
->...
->Could any of you Informix gurus enlighten me as to what this error signifies
->and whether there is any error in the above modification.
->...
At the operating system prompt type: finderr 9004
And you will get:
-9004 The column name is not in the current table, or the user variable
name has not been defined.
The name shown cannot be related to either a column in a database table or
a defined variable. Check its spelling. If you meant it to be a variable,
add it in the DEFINE section. If you meant to name a column in the database,
check to see if the table has been altered or its columns have been renamed.
->modification: if close1a = "X" and update1a = today and level_chng1a != "X" then
Probably one of the variables: close1a, update1a, or level_chng1a
has not been defined.
->Thanks in anticipation,
I hope this helps!
Regards,
- Cathy
--------------------------------------------------------------------------------
Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (303) 491-1294
Colorado State University Veterinary Teaching Hospital Fax: (303) 491-1205
Coming in late summer, from Prentice Hall, my new book:
Programming INFORMIX SQL/4GL: A Step-by-Step Approach (ISBN: 0-13-149394-9)