select
cast(coalesce(rdb$get_context('USER_TRANSACTION','ACU'), 0) as integer) codcidade,
rdb$set_context('USER_TRANSACTION','ACU',
cast(coalesce(rdb$get_context('USER_TRANSACTION','ACU'), 0) as integer) + 1) acu,
nome,
codmunicipioibge
from (
select
m.nomemunicipio || ' - ' || m.uf as nome,
m.codmunicipioibge
from tbmunicipioibge m
)
