var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: cursors in dbaccess
Hi all, im new to informix and dont know how to create cursors in the dbaccess env. It seems that they only get running in a 4gl env.
Im tring to create a query that looks like this but dbaccess sends me and error with the first 1, and I think the cursors will handle the query.
SELECT distinct a.clich_nss, a.clide_sumsal
FROM dwhafore@desatcpdwh:tt_af_clivip as a,
dwhafore:te_af_notafore as b
WHERE a.clich_nss = b.notch_nss AND
b.notin_fecna > 19531101 into temp t101;
SELECT first 1 notch_regpat, notch_nss
WHERE notch_nss in (
SELECT clich_nss as nss
FROM t101) into temp t102;
It seems database server version you are using does not support this particular syntax. I think the FIRST keyword specification in SQL was introduced from the version 7.3 onwards.
SELECT FIRST 1 * FROM systables ;
SELECT FIRST 1 partnum,tabid,rowsize FROM systables ;
are valid SQL statements under v7.3x onwards.
Hi thank your for your answer. I think the problem is when i try to use the limit syntax as part of a subquery.
The server im using is a 9. version