I am using the following where conidion in SQL:
where shiftl$(tdsls040.cbrn) = "600"
I get a compilation error "Unknown column shiftl$".

You could use the following code:

#include <bic_tt>
...
domain tccbrn sel.cbrn
long ret
ret = tt.align.according.domain("600", sel.cbrn, "tccbrn")
...
where tdsls040.cbrn = :sel.cbrn

Thanks a lot. That code worked like a charm.