Re: node.js xmlservice issue

I now have Node v4 installed on a v7.2 server and the error remains. Here
is a modified example: https://bitbucket.org/snippets/aaronbartell/Myjdx
(note the paths for db adapter and toolkit changed)

Further, I also made sure my DB2 PTFs were up to date

SELECT * FROM SYSTOOLS.GROUP_PTF_CURRENCY ORDER BY
ptf_group_level_available - ptf_group_level_installed desc

-------Results------
PTF_GROUP_CURRENCY PTF_GROUP_ID
PTF_GROUP_TITLE


UPDATE AVAILABLE SF99715 720 Backup
Recovery Solutions
UPDATE AVAILABLE SF99775 720 Hardware
and Related PTFs
UPDATE AVAILABLE SF99719 720 Group
Hiper
UPDATE AVAILABLE SF99713 720 IBM HTTP
Server for i
UPDATE AVAILABLE SF99747 720 DB2 Web
Query for i V2.1.0
INSTALLED LEVEL IS CURRENT SF99702 720 DB2 for
IBM i <-----------------
INSTALLED LEVEL IS CURRENT SF99716 720 Java

INSTALLED LEVEL IS CURRENT SF99717 720
Technology Refresh
INSTALLED LEVEL IS CURRENT SF99718 720 Group
Security
INSTALLED LEVEL IS CURRENT SF99720 Current
Cumulative PTF Media Documentation

It's possible I need the Hiper (haven't looked at it).

I will see if IBM can take a peek at it.


Aaron Bartell
litmis.com - Services for open source on IBM i


On Tue, May 10, 2016 at 8:31 AM, Brian Garland <brian.garland@xxxxxxxxxx>
wrote:

Here is a test program that demonstrates the error. With the db.conn
statement in there you will get the HY010 error. If you comment out the
db.conn it will work.



var db = require('/QOpenSys/QIBM/ProdData/Node/os400/db2i/lib/db2')
var xt =
require('/QOpenSys/QIBM/ProdData/Node/os400/xstoolkit/lib/itoolkit')
var conn = new xt.iConn("*LOCAL")

db.init()
db.conn("*LOCAL")

// set the user and password to test
// the console will show "success:false" or "success:true"
validateUser("username","password")

function validateUser(userName, password){
var pgm = new xt.iPgm("QSYGETPH",{"lib":"QSYS","error":"on"})
var x

pgm.addParam(userName.toUpperCase(), "10A")
pgm.addParam(password.toUpperCase(), "10A")
pgm.addParam(" ", "12A", {"io":"out", "hex":"on"})
pgm.addParam([
[0,"10i0"],
[0,"10i0"],
[" ", "7A"],
[" ", "1A"],
[" ", "256A"]
])
pgm.addParam(10, "10i0")
pgm.addParam(-1, "10i0")
conn.add(pgm.toXML())
conn.debug(true)
function my_call_back(str) {
var results = xt.xmlToJson(str)
console.log(str)
if(results.length == 0){
console.log("success:true")
x = true
} else {
results.forEach(function(result,index){
if(result.hasOwnProperty('success')){
console.log("success:" + result.success)
x = result.success
} else {
console.log("success:true")
x = true
}
})
}
}
conn.run(my_call_back)
return x
}






On Mon, 9 May at 2:53 PM, Aaron Bartell <aaronbartell@xxxxxxxxx>
wrote:

Do you have a small/generic example for us to test?

Aaron Bartell
litmis.com - Services for open source on IBM i


On Mon, May 9, 2016 at 2:50 PM, Brian Garland <brian.garland@xxxxxxxxxx>
wrote:

I have a node.js program that is using itoolkit/xmlservice to call an

IBM i

api.

If I add the db2 library anda db2 connection to the program the itoolkit
connection will fail with [Error: SQLSTATE=HY010 SQLCODE=-99999 Error
occured in SQL Call Level Interface].

Any idea how to do program calls and have a DB2 connection at the same
time?


--
Brian J. Garland
Vermont Information Processing, Inc.
brian.garland@xxxxxxxxxx

--
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or company to whom they are addressed.
Do not disclose, distribute, or copy this email to others outside your
company. If you have received this email in error, please notify the sender
immediately and delete this email from your system.
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.