Re: node.JS example not working

[Bradley Stone <bvstone@xxxxxxxxx>]

I noticed that if I do a fresh start of the node job and try to run a
command I get the following:

SQL statement : select * from g4gbvs.g4g001pf

CL statement : wrksyssts

============

INPUT XML

============

<?xml version='1.0'?><myscript><sh error='fast'>system -i
wrksyssts</sh></myscript>
============

OUTPUT XML

============

[Error: SQLSTATE=57017 SQLCODE=-332 Character conversion between CCSID 1208
and CCSID 65535 not valid.]

So, I looked and the user id was set to *SYSVAL and the sysval was 65535.

Changed the system value for QCCSID to 37 and things seem to be ok now.

Brad
www.bvstools.com

On Sun, Mar 27, 2016 at 2:54 PM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

> I'm working through the node examples at the following site:
>
> https://www.ibm.com/developerworks/ibmi/library/i-native-js-app-ibmi-with-nodejs/
>
> The SQL statement portion seems to work.  But when I try to run a command
> I get an error.  Here is the debug and messages:
>
> CL statement : WRKSYSSTS
>
> ============
>
> INPUT XML
>
> ============
>
> <?xml version='1.0'?><myscript><sh error='fast'>system -i
> WRKSYSSTS</sh></myscript>
> ============
>
> OUTPUT XML
>
> ============
>
> [Error: SQLSTATE=HY010 SQLCODE=-99999 Error occurred in SQL Call Level
> Interface]
>
> I found a few things using google for HY010 and it seems to be an
> authority issue.  But none were specific to the IBM i.  I'm sure it's
> something simple and it's not the first issue I'll run into, but I'd be
> interested in ideas why this is happening and the "fix".  :)
>
> Brad
> www.bvstools.com