Re: [IBMiOSS] Using Nodev6 db2i/itoolkit -- OPENSOURCE

While digging around I found this -
https://bitbucket.org/litmis/nodejs/issues/5/sqlstate-paerr-sqlcode-1

It talks about re-registering iPLUG512K, does that sounds like it might fix
my issue? Not knowing a lot out SQL or what "re-registering" does, I am
hesitant to try it out. And I not real sure how to go about it. I found
this command on the page, but again, don't understand what it does.

CREATE PROCEDURE QXMLSERV.IPLUG512K ( IN IPC CHAR(1024) , IN CTL CHAR(1024)
, IN CI CLOB(524288) , OUT CO CLOB(524288) ) LANGUAGE RPGLE SPECIFIC
QXMLSERV.IPLUG512K NOT DETERMINISTIC MODIFIES SQL DATA CALLED ON NULL INPUT
EXTERNAL NAME 'QXMLSERV/XMLSTOREDP(iPLUG512K)' PARAMETER STYLE GENERAL ;

GRANT EXECUTE
ON SPECIFIC PROCEDURE QXMLSERV.IPLUG512K TO PUBLIC ;

GRANT ALTER , EXECUTE
ON SPECIFIC PROCEDURE QXMLSERV.IPLUG512K TO QSYS ;

Kev

On Tue, Apr 3, 2018 at 8:37 AM, Kevin Nunn <nunn.kevin@xxxxxxxxx> wrote:

Thanks for the reply Aaron! here is the results and it is there.

During my web crawling a saw someone mention changing CCSID to 00037, I
tried changing my user CCSID to that and still got the error.

----------------------------------
Service program . . . . . . . . . . . . : XMLSTOREDP

Library . . . . . . . . . . . . . . . : QXMLSERV

Owner . . . . . . . . . . . . . . . . . : QSYS

Service program attribute . . . . . . . : RPGLE

Detail . . . . . . . . . . . . . . . . . : *PROCEXP

Procedure Exports:

Procedure Name
ARGOPT
iPLUG10M
*NO
iPLUG15M
*NO
iPLUG32K
*NO
iPLUG4K
*NO
iPLUG5M
*NO
iPLUG512K
*NO
iPLUG65K
*NO
BIGASSIST
*NO
BIGCDATA
*NO
BIGDIMATTR
*NO

More...
F3=Exit F12=Cancel F17=Top F18=Bottom

On Tue, Apr 3, 2018 at 8:23 AM, Aaron Bartell <aaronbartell@xxxxxxxxx>
wrote:

Hi Kevin,

XMLSTOREDP is where IPLUG512K should exist. Run this command:

dspsrvpgm qxmlserv/xmlstoredp

Hit <Enter> key until you get to the "Procedure Exports" page and make
sure
IPLUG512K is in that list.

toying around, running "/QOpenSys/usr/bin/system -i dspsyssts" works

fine.

The PASE "system" command isn't part of XMLSERVICE or iToolKit and is
instead part of the base PASE offering.

Aaron Bartell
IBM i hosting, starting at $157/month. litmis.com/spaces

On Tue, Apr 3, 2018 at 7:43 AM, Kevin Nunn <nunn.kevin@xxxxxxxxx> wrote:

Here are the results:

Opt Object Type Library Attribute Text
XMLCGI *PGM QXMLSERV RPGLE
XMLMAIN *PGM QXMLSERV RPGLE
XMLSERVICE *PGM QXMLSERV RPGLE
XMLVER *PGM QXMLSERV RPGLE
XMLSTOREDP *SRVPGM QXMLSERV RPGLE

I assume IPLUG512K should be in there somewhere.

Kev

On Tue, Apr 3, 2018 at 6:59 AM, Aaron Bartell <aaronbartell@xxxxxxxxx>
wrote:

Do you have any idea what we might be missing?

Do a WRKOBJ QXMLSERV/*ALL and paste the results back here.

Aaron Bartell
IBM i hosting, starting at $157/month. litmis.com/spaces

On Mon, Apr 2, 2018 at 5:18 PM, Kevin Nunn <nunn.kevin@xxxxxxxxx>

wrote:

Aaron,

We are trying to figure out what our system is missing that is

causing

this. We didn't have "XML Toolkit" and installed that, but it still

is

not

working. In the job log I noticed it said "ensure that the DB2

Multisystem

product is installed on your system", so our admin is going to check

that

after a client visit in the morning and maybe see if that might be

the

issue.

Do you have any idea what we might be missing? Below is a copy of

the

message in the job log.

From user . . . . . . . . . : KEVIN
From module . . . . . . . . : QSQPROC
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 54610
To module . . . . . . . . . : QSQPROC
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 54610
Message . . . . : IPLUG512K in QXMLSERV type *N not found.
Cause . . . . . : IPLUG512K in QXMLSERV type *N was not found. If

the

member
name is *ALL, the table is not partitioned. If this is an ALTER

TABLE

statement and the type is *N, a constraint or partition was not

found.

If

this is not an ALTER TABLE statement and the type is *N, a function,
procedure, trigger or sequence object was not found. If a function

was

not

found, IPLUG512K is the service program that contains the function.

The

function will not be found unless the external name and usage name

match

exactly. Examine the job log for a message that gives more details

on

which

function name is being searched for and the name that did not match.
Recovery . . . : Change the name and try the request again. If the
object is a node group, ensure that the DB2 Multisystem product is
installed
on your system and create a nodegroup with the CRTNODGRP CL

command. If

an

external function was not found, be sure that the case of the

EXTERNAL

NAME

on the CREATE FUNCTION statement exactly matches the case of the

name

exported by the service program.

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/opensource.

--
*Kevin Nunn <https://about.me/kevinnunn>*
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/opensource.

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/opensource.

--
*Kevin Nunn <https://about.me/kevinnunn>*