search

sitemule / noxDB

Not only XML. SQL,JSON and XML made easy for IBM i
MIT License
41 stars 20 forks source link

ODBC errror code 10 #19

Closed kganczuk closed 5 years ago

kganczuk commented 5 years ago

Hello,

I've tried to run one program from examples (A.rpgle) and I got following error:

Message ID . . . . . . : SQ99999 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 27/06/19 Time sent . . . . . . : 11:35:30

Message . . . . : Error occurred in SQL Call Level Interface
Cause . . . . . : A procedure call encountered an error. The error code is

  1. Error codes are:
    10 -- Function sequence error.
    Recovery . . . : Refer to the DB2 for i SQL Call Level Interface (ODBC)
    topic collection in the Database category in the IBM i Information Center book for a complete description of the error. Specifically, look at the
    procedure that sent the error.

It happens after this statement: pRows = json_sqlResultSet(sql:start:limit:JSON_META+JSON_FIELDS);

NielsLiisberg commented 5 years ago

Typical this happens when you debug and stop and the restart all over. or you reclaim rout resources with out a json_sqldisconnect();

If not run from within ILEastic or other multithreaded environment, then use a construction like below to ensure the sequense of statements are :

json_sqlConnect(...); pRows = json_sqlResultSet(sql:start:limit:JSON_META+JSON_FIELDS); json_sqlDisconnect(...);

In your current setup you can do either:

Signoff and on

Or do

RCLACTGRP QILE RCLACTGRP QSQCLI

On Thu, Jun 27, 2019 at 1:11 PM kganczuk notifications@github.com wrote:

Hello,

I've tried to run one program from examples (A.rpgle) and I got following error:

Message ID . . . . . . : SQ99999 Severity . . . . . . . : 30 Message type . . . . . : Diagnostic Date sent . . . . . . : 27/06/19 Time sent . . . . . . : 11:35:30

Message . . . . : Error occurred in SQL Call Level Interface Cause . . . . . : A procedure call encountered an error. The error code is

  1. Error codes are: 10 -- Function sequence error. Recovery . . . : Refer to the DB2 for i SQL Call Level Interface (ODBC) topic collection in the Database category in the IBM i Information Center book for a complete description of the error. Specifically, look at the procedure that sent the error.

It happens after this statement: pRows = json_sqlResultSet(sql:start:limit:JSON_META+JSON_FIELDS);

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/sitemule/noxDB/issues/19?email_source=notifications&email_token=AAVIPHQ7DMDGC5XQ45MFV4LP4SN6TA5CNFSM4H323VI2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4G4BN7YA, or mute the thread https://github.com/notifications/unsubscribe-auth/AAVIPHQ2OKTBQY2NXLQ43ETP4SN6TANCNFSM4H323VIQ .

kganczuk commented 5 years ago

json_sqlConnect helped, thanks 👍