I've stared at this simple select statement until I've gotten a
headache. It must be something simple that I've missed. This is the
temp (balance,cus#) AS
(SELECT field1+field2+field3 AS balance,cus#
The processor doesn't like the '>' but I believe it's actually
pointing to a problem with my mapped field - balance. I've
substituted = for>; it still throws the same error (SQL0104).
However, if I run the script eliminating the WHERE clause in the
full-select, it runs nicely returning both columns as I think they
I hate arguing with script processors. BTW, I'm doing this using
System i Navigator.