Try a later CSDK ??? If that is not possible try changing to
prepare/execute statement, that should let the engine prep the SQL and not
the client layer
Cheers
Paul
> I recently downloaded the utils2_ak package and was trying to build it,
> but I hit an error. When compiling dbscript.ec, I got the following:
>
> esqlc: "dbscript.ec", line 454: Error -33051: Syntax error on identifier
> or symbol 'SIBLINGS'.
> 1 error(s) found
>
>
> Looking in the source file at line 454:
>
> EXEC SQL INSERT INTO hierarchy1
> SELECT ctabid, ptabid, tabtype, LEVEL as hlevel
> FROM hierarchy
> START WITH ptabid IS NULL
> CONNECT BY PRIOR ctabid = ptabid
> ORDER SIBLINGS BY ctabid;
> if (sqlca.sqlcode != 0) {
> fprintf( stderr,
> "Error organizing hierarchy map! Error: %d.\n",
> sqlca.sqlcode );
> exit(1);
> }
>
>
> So it's the ORDER SIBLINGS BY that is causing the problem.
>
> We're running 11.50.FC6 on HP-UX 11.31 (PA-RISC). Our CSDK is 3.50.FC6.
> According to the online docs, the ORDER SIBLINGS BY was added in
> 11.50.FC5, so everything should be good, but ... Actually, I tried this
> in Server Studio and it worked. I tried it in dbaccess and it worked.
> It's just when I try to compile that it doesn't work.
>
> Any thoughts on where to look? Or how to work around this? Can I just
> comment out the ORDER SIBLINGS BY and compile? FWIW, we have very few
> constraints in our databases, and this section of logic appears to deal
> primarily with constraints.
>
>
>
>
>
>
>
> ------------------------------
> Mark Collins
> ------------------------------
>
>
> Reply to Sender :
>
https://community.ibm.com/eGroups/PostReply/?GroupId=4147&SenderKey=85dbcc59-d33e-4333-9dbf-481fe76bf230&MID=47302&MDATE=7575458475&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved>
> Reply to Discussion :
>
https://community.ibm.com/eGroups/PostReply/?GroupId=4147&MID=47302&MDATE=7575458475&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved>
>
>
> You are subscribed to "Informix" as
paul@oninit.com. To change your
> subscriptions, go to
>
http://community.ibm.com/community/user/preferences?section=Subscriptions&MDATE=7575458475&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved.> To unsubscribe from this community discussion, go to
>
http://community.ibm.com/HigherLogic/eGroups/Unsubscribe.aspx?UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved&GroupKey=60eb97a2-57c0-4130-9b6d-57174f97d5a8.--
Paul Watson
Tel: +1 913-674-0360
Mob: +1 913-387-7529
Web:
www.oninit.comOninit? is a registered trademark of Oninit LLC
Failure is not as frightening as regret.
If you want to improve, be content to be thought foolish and stupid.
What this country needs are more unemployed politicians
------Original Message------
I recently downloaded the utils2_ak package and was trying to build it, but I hit an error. When compiling dbscript.ec, I got the following:
esqlc: "dbscript.ec", line 454: Error -33051: Syntax error on identifier or symbol 'SIBLINGS'.
1 error(s) found
Looking in the source file at line 454:
EXEC SQL INSERT INTO hierarchy1
SELECT ctabid, ptabid, tabtype, LEVEL as hlevel
FROM hierarchy
START WITH ptabid IS NULL
CONNECT BY PRIOR ctabid = ptabid
ORDER SIBLINGS BY ctabid;
if (sqlca.sqlcode != 0) {
fprintf( stderr,
"Error organizing hierarchy map! Error: %d.\n",
sqlca.sqlcode );
exit(1);
}
So it's the ORDER SIBLINGS BY that is causing the problem.
We're running 11.50.FC6 on HP-UX 11.31 (PA-RISC). Our CSDK is 3.50.FC6. According to the online docs, the ORDER SIBLINGS BY was added in 11.50.FC5, so everything should be good, but ... Actually, I tried this in Server Studio and it worked. I tried it in dbaccess and it worked. It's just when I try to compile that it doesn't work.
Any thoughts on where to look? Or how to work around this? Can I just comment out the ORDER SIBLINGS BY and compile? FWIW, we have very few constraints in our databases, and this section of logic appears to deal primarily with constraints.
------------------------------
Mark Collins
------------------------------
#Informix