Hi,

I have a query with two inline views which is returning the error:

Error: Cannot obtain or set serial value. (State:S1000, Native Code: FFFFFD8E)

Statement is being run from WinSql client using IBM Informix ODBC driver.

SQL:

select
ACCT_ID,
TOT_DEP,
LIMIT_VALUE
from
TABLE(MULTISET
(select
acct_id,
sum(amount) tot_dep
from
tpmt
where
tpmt.payment_sort='D'
and tpmt.cr_date>={ts '2008-12-21 00:00:00'}
and tpmt.cr_date<={ts '2008-12-21 23:59:59'}
and tpmt.status ="Y"
group by acct_id)) vd,
TABLE(MULTISET
(select
cust_id,
limit_value
from
tcustlimits
where
limit_id in
        (
        select
        max(limit_id)
        from
        tcustlimits
        where
        cust_id = 1179052
        and
        tcustlimits.limit_type='max_dep_day_amt'
        group by
        cust_id
        )
)) vl,
tacct ta
where
vd.acct_id = ta.acct_id
and ta.cust_id = vl.cust_id
and tot_dep > limit_value


Any ideas what this means and how i can overcome it?

Many thanks for your help!