Error 223 in 9.1D, worked in 8.3 ....

jonasj

New Member
??

/* This works in Progress 8.3, but not in Progress 9.1D */
EXEC SQL DECLARE foo_8_3 CURSOR FOR
SELECT v.idnr, v.vtfid, v.indat, v.inkl, v.utdat, v.utkl, v.avdkod, v.makul, "0", 0
FROM TABLE_V v, TABLE_P p
WHERE v.idnr = p.idnr AND p.pnr = :in_persnr AND p.sekel = :in_sekel

UNION

SELECT o.idnr, o.vtfid, o.datum, o.tidpkt, 11/11/1111, -99, o.mottkod, o.makul, "1", o.avglpnr
FROM TABLE_O o, TABLE_P p
WHERE o.idnr = p.idnr AND p.pnr = :in_persnr AND p.sekel = :in_sekel

UNION

SELECT g.idnr, 0, g.indat, g.inkl, g.utdat, g.utkl, g.avdkod, false, g.gasttyp, 0
FROM TABLE_G g, TABLE_P p
WHERE g.idnr = p.idnr AND p.pnr = :in_persnr AND p.sekel = :in_sekel
ORDER BY 1,2,3,8,4
;

/*
* What should I have instead of XXXXXXXX in select-statement 2 to be able to execute this??
*/
EXEC SQL DECLARE foo_9_1 CURSOR FOR
SELECT v.idnr, v.vtfid, v.indat, v.inkl, v.utdat, v.utkl, v.avdkod, v.makul, "0", 0
FROM TABLE_V v, TABLE_P p
WHERE v.idnr = p.idnr AND p.pnr = :in_persnr AND p.sekel = :in_sekel

UNION

SELECT o.idnr, o.vtfid, o.datum, o.tidpkt, XXXXXXXX, -99, o.mottkod, o.makul, "1", o.avglpnr
FROM TABLE_O o, TABLE_P p
WHERE o.idnr = p.idnr AND p.pnr = :in_persnr AND p.sekel = :in_sekel

UNION

SELECT g.idnr, 0, g.indat, g.inkl, g.utdat, g.utkl, g.avdkod, false, g.gasttyp, 0
FROM TABLE_G g, TABLE_P p
WHERE g.idnr = p.idnr AND p.pnr = :in_persnr AND p.sekel = :in_sekel
ORDER by 1,2,3,8,4
;

When looking at for instance g.utdat (corresponding to XXXXXXXX) with PROGRESS Report, it say that the type is 'date' and the format is '999999'.

When I run this on a Progress 9.1D system (HP-UX 11.11) I get Error 223 from my program.
The code is first preprocessed with sqlcpp, then compiled with cc and linked as a large ESQL client
 
Back
Top