Problem with Inline View / TABLE(MULTISET....

[daYorkie]

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!