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