1

While inserting json document in to table facing the mentioned error. Though I created UDF where external name is DSN5JSJb and it's already there in environment. Which will come along with Db2 accessories​ suit.

Community
  • 1
  • 1
Dhinesh Pazanisamy
  • 45
  • 1
  • 6
  • did you following the config steps?: http://www.ibm.com/developerworks/data/library/techarticle/dm-1501sql-json-db2/index.html – SaggingRufus Feb 08 '17 at 15:44
  • based on that error it is definitely something with your config – SaggingRufus Feb 08 '17 at 15:45
  • We followed everything appropriately, but getting sql code - 444. Here json api intended to use. So jdbc driver also there. – Dhinesh Pazanisamy Feb 08 '17 at 16:25
  • you will probably have to talk to the technical staff at your site, the SQL code -444 enforces your question title DSN5JSjb is not found. If you are sure that everything is configured properly, my next question would be is this running in Batch or Online, and if it is running Online, does CICS have access to this module? – SaggingRufus Feb 08 '17 at 17:14
  • Are you sure the module name is in mixed case: `DSN5JSJb`? – mustaccio Feb 08 '17 at 18:25
  • yea, module name is in mixed case only @mustaccio – Dhinesh Pazanisamy Feb 09 '17 at 02:55
  • i trying to to insert nosql document into table by creating UDF functions, it's via spufiin in db2 . just trying to find whether it's inserting , and able to retrieve it back . @SaggingRufus – Dhinesh Pazanisamy Feb 09 '17 at 02:58
  • you are going to have to talk to someone who understands the configuration of this product and the configuration of your site. At this point we are all just guessing. The system usually isn't wrong, so I am thinking the configuration was not done properly. – SaggingRufus Feb 09 '17 at 10:55
  • 1
    Well, `DSN5JSJB` being a system module, I doubt it was created in mixed case in your subsystem, while the rest of the world enjoys all uppercase name. I suggest you try using the uppercase name too in you UDF. – mustaccio Feb 09 '17 at 12:01
  • @SaggingRufus now it's working , technical side they failed to add the module in db2 proc library – Dhinesh Pazanisamy Feb 10 '17 at 04:37
  • The system is usually correct – SaggingRufus Feb 10 '17 at 12:40

0 Answers0