Re: SQL7908 error when trying to acces DB2 from node

[Henrik Rützou <hr@xxxxxxxxxxxx>]

it's node version 6.9.1

On Sat, Feb 11, 2017 at 12:11 AM, Kevin Turner <kevin.turner@xxxxxxxxxxxxxx>
wrote:

> What node version?
>
> [https://www.netcracker.com/assets/img/netcracker-social-final.png] ƕ
> -----Original Message-----
> From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Henrik
> Rützou
> Sent: 10 February 2017 23:03
> To: Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
> Subject: [WEB400] SQL7908 error when trying to acces DB2 from node
>
> Hi, I'm getting the following error when trying to run the above code in
> node.js
>
> SEV  DATE      TIME             FROM PGM     LIBRARY     INST     TO PGM
>   LIBRARY
> 00   10-02-17  23:40:46,758703  QSQROUTS     QSYS        *STMT    QSQCLI
>   QSYS
>  From module . . . . . . . . :   QSQSRVRC
>
>  From procedure  . . . . . . :   SQSERVER
>
>  Statement . . . . . . . . . :   8224
>
>  To module . . . . . . . . . :   SQLCON
>
>  To procedure  . . . . . . . :   SQLConnect
>
>  Statement . . . . . . . . . :   13395
>
>  Message . . . . :   Job 005884/QUSER/QSQSRVR used for SQL server mode
>
>    processing.
>
>  Årsag . . . . . :  A Structured Query Language (SQL) statement was
> executed
>    while running in SQL server mode.  SQL statements for this connection or
>    thread will be processed in job 005884/QUSER/QSQSRVR. Teknisk
> beskrivelse .
>    . . . . . . . :   SQL server mode was requested by either setting the
> SQL
>    server mode job attribute, or by setting the server mode environment
>
>    attribute via the SQL Call Level Interface.  When running in this mode,
> SQL
>   statements are processed by a separate job, which runs under the user
>
>   profile specified for the connection. The thread identifier is 2 and the
>
>   connection is to Relational Database C602082A.  If the Relational
> Database
>   name is *N, this means that all connections for the thread will use the
> same
>   job.
>
>
> The node.js server i started by a submittet job and tries to run this code:
>
> // Input from DB2
> var db = require('/QOpenSys/QIBM/ProdData/OPS/Node6/os400/db2i/lib/db2a');
>
> var sql = "SELECT STATE,LSTNAM FROM QIWS.QCUSTCDT";
>
> var dbconn = new db.dbconn();   // Create a connection object.
> dbconn.conn("*LOCAL");   // Connect to a database.
> var stmt = new db.dbstmt(dbconn);   // Create a statement object of the
> connection.
> stmt.exec(sql, function(result) {
>
> console.log("Result: %s", JSON.stringify(result)); var fieldNum =
> stmt.numFields(); console.log("There are %d fields in each row.",
> fieldNum); console.log("Name | Length | Type | Precise | Scale | Null");
> for(var i = 0; i < fieldNum; i++) { console.log("%s | %d | %d | %d | %d |
> %d", stmt.fieldName(i), stmt.fieldWidth(i), stmt.fieldType(i),
> stmt.fieldPrecise(i), stmt.fieldScale(i), stmt.fieldNullable(i)); };
>
> delete stmt;   // Clean up the statement object.
> dbconn.disconn();   // Disconnect from the database.
> delete dbconn;   // Clean up the connection object.
> });
>
> Any guess?
>
> --
> Regards,
> Henrik Rützou
>
> http://powerEXT.com <http://powerext.com/>
> --
> 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.
>
>
>
>
> ________________________________
> The information transmitted herein is intended only for the person or
> entity to which it is addressed and may contain confidential, proprietary
> and/or privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this information by
> persons or entities other than the intended recipient is prohibited. If you
> received this in error, please contact the sender and delete the material
> from any computer.
> --
> 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.