Re: [IBMiOSS] FW: beginning node.js

Thanks Aaron.

On to the next step now.

-----Original Message-----
From: OpenSource [mailto:opensource-bounces@xxxxxxxxxxxx] On Behalf Of Aaron Bartell
Sent: Wednesday, December 27, 2017 10:02 AM
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Subject: Re: [IBMiOSS] FW: beginning node.js

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-w
ith- 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.

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

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.