Re: [IBMiOSS] FW: beginning node.js

[Aaron Bartell <aaronbartell@xxxxxxxxx>]

Hi Mike,

The first error is because the author is expecting you to use string
interpolation.  That means using back ticks instead of single or double
quotes.  The second error is because you're using single quotes both to
compose the SQL statement and to declare literals inside of the SQL
statement.  Use double quotes for one of them.

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


On Wed, Dec 27, 2017 at 8:56 AM, Smith, Mike <Mike_Smith@xxxxxxxxxxxxxxxx>
wrote:

> I'm now running V6.9.1    I was able to get  the programs at
> https://www.ibm.com/developerworks/ibmi/library/i-native-js-app-ibmi-with-
> nodejs/index.html working with a couple of modifications.
> I had to remove the stmt.close() and dbconn.close() statements.  I'm not
> sure why it doesn't like them though.
>
> Now I'm trying a sample that creates/updates a table, but I'm having a
> couple of issues here as well, that I cannot resolve.
> Code snippet below.
>
> On the create table, the sample originally was create table
> ${schema}.CUSTOMER..........
>
> I get a sqlstate=42601 sqlcode = -104 token{ not valid
>
> So I replaced the statement to directly use tstmis.
>
> I can get the statement to run with this if I only have the create table
> statement.
>
> When I add the insert statement, I get an unexpected identifier pointing
> to the 'Smith' in the values Also, when this statement is added, the table
> is no longer created.
>
> I appreciate any help.
>
>
>
>
>
>
>
> const db = require('/QOpenSys/QIBM/ProdData/OPS/Node6/os400/db2i/
> lib/db2a')
>
> const dbconn = new db.dbconn()
> dbconn.conn("*LOCAL")
> const stmt = new db.dbstmt(dbconn)
>
> const schema = 'TSTMIS'
> let sql =
> 'CREATE TABLE tstmis.CUSTOMER ( \
> CUSNUM NUMERIC(6, 0),            \
> LSTNAM VARCHAR(50),              \
> INIT CHAR(1),                    \
> STREET VARCHAR(100),             \
> CITY VARCHAR(100),               \
> STATE CHAR(2),                   \
> ZIPCOD NUMERIC(5, 0)             \
> )'
>
> stmt.exec(sql, function(result, err)
> {
>         console.log('error:' + err)
>         console.log('result:' + result)
>
>   sql = 'INSERT INTO tstmis.CUSTOMER VALUES (123,'Smith','L','123
> Center','Mankato','MN',56001)'
>   stmt.exec(sql, function(result,err){
>     console.log('error:' + err)
>     console.log('result:' + result)
>
>
>   })
> })
>
> NOTICE: This message, including any attachment, is intended as a
> confidential and privileged communication. If you have received this
> message in error, or are not the named recipient(s), please immediately
> notify the sender and delete this message.
> --
> 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.