you can always install another CSDK in a separate directory and statically
compile, that should work along side the installed versions
Cheers
Paul
> Hi Paul,
>
> Good idea. If Art doesn't see anything in the output I just sent, I may
> try that PREPARE option.
>
> Thanks.
>
>
> Mark
>
> ------------------------------
> Mark Collins
> ------------------------------
> -------------------------------------------
> Original Message:
> Sent: Fri March 20, 2020 10:24 AM
> From: Paul Watson
> Subject: utils2_ak question
>
> 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>>
#Informix