× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. OPENSOURCE
  3. April 2018

Re: [IBMiOSS] Using Nodev6 db2i/itoolkit

That did it! Thanks for the help, not sure how it would have gotten
de-registered, but doing those statements fixed it. Here is the result.

$node cltest.js
============
INPUT XML
============
<?xml version='1.0'?><myscript><sh error='fast'>system -i
DSPSYSSTS</sh></myscript>
============
OUTPUT XML
============
SQLConnect: conn obj [309d2e50] handler [2]
PrepareAsync().
SQLPrepare(0): call QXMLSERV.iPLUG512K(?,?,?,?)
BindParamAsync().
SQLBindParameter [1] = undefined
SQLBindParameter [2] = undefined
SQLBindParameter [3] = <?xml version='1.0'?><myscript><sh
error='fast'>system -i DSPSYSSTS</sh></myscript>
SQLBindParameter [4] =
ExecuteAsync().
SQLExecute(0):
<?xml version='1.0'?><myscript><sh error='fast'>
System Status Information
Page 1
5770SS1 V7R2M0 140418
ECTS8284 04/03/18 12:25:33 CDT
% CPU used . . . . . . . . . . . . . . : .7 System
ASP . . . . . . . . . . . . . . : 1142 G
Elapsed time . . . . . . . . . . . . . : 00:00:01 %
system ASP used . . . . . . . . . . : 35.6591
Jobs in system . . . . . . . . . . . . : 1203 Total
aux stg . . . . . . . . . . . . : 1142 G
% perm addresses . . . . . . . . . . . : .010 Current
temporary used . . . . . . . . : 12749 M
% temp addresses . . . . . . . . . . . : .071 Peak
temporary used . . . . . . . . . : 13418 M
Sys Pool Reserved Max -----DB----- ---Non-DB--- Act- Wait-
Act- Paging
Pool Size M Size M Act Fault Pages Fault Pages Wait Inel
Inel Pool Subsystem Library Option
1 1578.54 803.67 +++++ .0 .0 .0 .0 56.3 .0
.0 *MACHINE *FIXED
2 25485.57 12.45 381 .0 .0 .0 .0 12619 .0
.0 *BASE *FIXED
3 304.63 .00 20 .0 .0 .0 .0 .0 .0
.0 *SPOOL *FIXED
4 3046.36 .00 762 .0 .0 .0 .0 .0 .0
.0 *INTERACT *FIXED
5 23.43 .00 1 .0 .0 .0 .0 .0 .0
.0 2 QBATCHSCH QGPL *FIXED
6 1.00 .00 1 .0 .0 .0 .0 .0 .0
.0 3 QBATCHSCH QGPL *FIXED
7 23.43 .00 1 .0 .0 .0 .0 .0 .0
.0 2 ACCOUNT QGPL *FIXED
8 1.00 .00 1 .0 .0 .0 .0 .0 .0
.0 3 ACCOUNT QGPL *FIXED
* * * * * E N D O F L I S T I
N G * * * * *
</sh>
</myscript>
SQLDisconnect: conn obj [309d2e50] handler [2]

Now on the more learning/testing/etc.

Kev


On Tue, Apr 3, 2018 at 12:24 PM, Aaron Bartell <aaronbartell@xxxxxxxxx>
wrote:

Try running those SQL statements to recreate the procedure, if you haven't
already, and let us know if it resolves the issue.

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


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

​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>*




--
*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.





As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.