Hi,
I want to read all records from tcibd001 for a given
project. Since Item has a segmented domain, how do I acheive
it? I thought of the following idea.
I am assuming there is a better way.
Please advice.
Thanks,
BigJohn



item.f = hold.cprj & " "
item.t = hold.cprj & "ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ"

select tciibd01.*
from tcibd001
where cibd001._index1 inrange {:item.f} and {:item.t}

That looks pretty much like what you need. Depending on your collating sequence the ZZZZZZ... may need to be lowercase.