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