Error: Cannot initiate sort. (State:S1000, Native Code: FFFFFDCA)
--0__=ALGsh827uzC2PUzH06mumFvLSycKiDgXfBY79G12JOQyZTQPAK56FfHl
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline
---------------------- Forwarded by Emmanuel Weyers/IT/Kpn-Orange on 06/14/2000
11:55 AM ---------------------------
(Embedded image moved to file: pic19804.pcx) Emmanuel Weyers
06/09/2000 12:41 PM
To: informix-list@iiug.org
cc:
Subject: Error: Cannot initiate sort. (State:S1000, Native Code: FFFFFDCA)
Hi,
I have an recursive SPL. After a while i got this error: Error: Cannot initiate
sort. (State:S1000, Native Code: FFFFFDCA)
{ TABLE "vantive".ko_vantbl_rel row size = 555 number of columns = 3 index size
= 102 }
create table "vantive".ko_vantbl_rel
(
kochildtaborvw char(30),
kofkey char(495),
koparenttaborvw char(30)
);
revoke all on "vantive".ko_vantbl_rel from "public";
create index "vantive".i1_ko_vantbl_rel on "vantive".ko_vantbl_rel
(kochildtaborvw);
create index "vantive".i3_ko_vantbl_rel on "vantive".ko_vantbl_rel
(koparenttaborvw);
CREATE PROCEDURE kosp_vantblrel2(parent_id varchar(255))
RETURNING varchar(255);DEFINE child_id varchar(255);
DEFINE level SMALLINT;
DEFINE path, path2 varchar(255);
LET child_id = '';
LET level = 0;
LET path = parent_id;
FOREACH SELECT distinct object.kochildtaborvw
INTO child_id
FROM KO_VANTBL_REL object
WHERE object.koparenttaborvw = parent_id
LET path = parent_id || ' -> ';
IF (child_id != '') and (child_id is not NULL) THEN
LET path2 = '';
FOREACH EXECUTE PROCEDURE kosp_vantblrel2(child_id)
INTO path2
RETURN path || path2 WITH RESUME;
LET level = 1;
END FOREACH;
IF level <> 1 THEN
RETURN path || child_id WITH RESUME;
END IF;
LET level = 0;
LET path2 = '';
END IF;
END FOREACH;
END PROCEDURE;
--0__=ALGsh827uzC2PUzH06mumFvLSycKiDgXfBY79G12JOQyZTQPAK56FfHl
Content-type: application/octet-stream;
name="pic19804.pcx"
Content-Disposition: attachment; filename="pic19804.pcx"
Content-transfer-encoding: x-uuencode
begin 644 pic19804.pcx
M"@4!"``````M`#,`````````````````````````````````````````````
M```````````````````````````!+@`!````````````````````````````
M``````````````````````````````````````````````````#8#\\P/Q@_#
M#P_8#\\P/Q@_##P_8#\\P/Q@_##P_8#\\P/Q@_##P_"#PX/#M4/RP_%#\\,/#P\\.
M#PX/#M4/R@_%#\\,/#PX/#@\\.#P[4#\\H/Q0_##P\\/#@\\.#PX/#M0/R@_%#\\(/
M#PX/#@\\.#P[4#\\H/Q0_##P\\/#@\\.#PX/#L@/Q`[.#\\</PP_"#\\(/#@\\.#P[(
M#\\8.S0_'#\\,/P@_##PX/#L@/R`[-#\\8/PP_"#\\X/R`[-#\\8/PP_"#\\X/R`[-
M#\\8/PP_"#\\X/R`[-#\\8/PP_"#\\\\/Q@[-#\\</PP_"#]`/Q`[.#\\</PP_"#]@/
MQ`\\.#`X,R`_$#\\(/V`_##PX,#@P.#,</Q`_"#]@/P@\\.#`X,#@P.#,</PP_"
M#]@/P@\\,#@P.#`X,#L</PP_"#]@/P@\\.#`X,#@P.#,</PP_"#]@/P@\\,#@P.
M#`X,#L</PP_"#]@/PP\\,#@P.#`['#\\0/P@_8#\\0/#`X,#L@/Q`_"#]@/S`_&
M#\\,/#]@/S`_&#\\,/#]@/S`_&#\\,/#]@/S`_&#\\,/#]@/S`_$#,0/P@_8#\\L/
MQ@S##\\(/V`_*#\\<,#,,/#]@/R@_'#`S##P_8#\\H/QPP,PP\\/V`_*#\\<,#,,/
M#]@/RP_&#,,/P@_8#\\P/Q`S$#\\(/V`_,#\\8/PP\\/V`_,#\\8/PP\\/V`_,#\\8/
MPP\\/V`_,#\\8/PP\\/V`_,#\\8/PP\\/V`_,#\\8/PP\\/V`_,#\\8/PP\\/V`_,#\\,/
MQ`3"#P_8#\\P/P@_%!`3"#]@/S`\\/Q03#!`_8#\\P/#\\4$PP0/V`_,#P_%!,,$
M#]@/S`\\/Q03#!`_8#\\P/P@_%!`3"#]@/S`_##\\0$P@\\/#````(````"``("`
M````@(``@`"`@("`@,#`P/\\```#_`/__````__\\`_P#______P``````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
E`````````````````````````````````````````````````!__
`
end
--0__=ALGsh827uzC2PUzH06mumFvLSycKiDgXfBY79G12JOQyZTQPAK56FfHl--