0

i'm ok with insertion and selecting, but when i'm trying to retrieve particular document from table while using JSON_VAL index, i'm facing error with sql code -440.

Community
  • 1
  • 1
Dhinesh Pazanisamy
  • 45
  • 1
  • 6
  • 2
    Did you obtain and review all the information which is available to you? What conclusions did you draw after that? You also need an actual question (in the body of the question, the title is for a title) and almost certainly an example of the code which is causing you the problem, with the full diagnostic information that is available. – Bill Woodger Feb 10 '17 at 11:59
  • SQL return code -440: NO AUTHORIZED routine-type BY THE NAME routine-name HAVING COMPATIBLE ARGUMENTS WAS FOUND seeing as the last error was that module was not defined, I am guessing the routine you are calling in this instance also is not setup – SaggingRufus Feb 10 '17 at 12:43
  • @SaggingRufus you mean that it also the part of admin work in defining the routine, correct? – Dhinesh Pazanisamy Feb 10 '17 at 13:06
  • Perhaps, I am not familiar with your JSON library, but DB2 is telling you that the routine you are calling is not properly authorized to run. – SaggingRufus Feb 10 '17 at 13:22
  • 1
    If you post the complete error-information and the code you are using to access the DB we could perhaps see if you are calling a procedure the wrong way or if the DB-setup is incorrect. – piet.t Feb 13 '17 at 07:08

0 Answers0