Okay, I surrender. The divot on my desk, matching my forehead, is
getting quite deep from repeated pounding.
I am sure I am missing something very simple here, but for the life of
me I can't figure out what.
Developed a project, on my PC, using Node and using NPM installed
Express, Path, JDBC and it works fine being locally hosted and
accessing data on DB2.
Created a new folder on my IFS, then went to Call QP2Term and
navigated to the folder. NPM INIT worked fine. NPM install of
Express and Path, no issues.
Tried to NPM install JDBC and received a failure, as near as I can
tell, from this: as400 Error:
It seems to be related to a child-process rebuild during the install.
After being unable to resolve this issue, I then found an example
which was using
"var db = require('/QOpenSys/QIBM/ProdData/Node/os400/db2i/lib/db2');
I looked in my IFS and have nothing like that. My Node installation
appears to be here: /QOpenSys/pkgs/lib/nodejs8
I am sure I have gotten myself all twisted up somewhere.
Before trying to resolve all of these issues the question is this -
what is the best/proper way for developing on your PC and Node/Express
application to access DB2 that will work both when hosted with
LocalHost during development and with your IBM i hosting during actual
use? I would prefer not to develop in the IFS, but rather develop
local on my PC and then copy over the files once they are working, or
is that bad practice? Should I just be developing directly within the
As for my software, I have been using JetBrains IntelliJ (my
development and also using Visual Studio Code (to learn something
new). Any recommendation on better or worse on those? Less concerned
with this part and more with my ability to access the DB2 data.
Thanks for any/all the help. First time posting out here on
OpenSource as I am venturing into new arenas of utilization of our IBM
i. Long time RPG and COBOL and Java developer trying to negotiate the
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.