I tried node-jt400 (Environment construction)

What is node-jt400?

A wrapper that uses jt400 in node.js. IBM i (AS400) that can be connected with jt400 seems to work.

Version of the tested environment

IBM i:V5R4 Development PC: Windows10Pro 64bit node.js:6.9.1 npm:3.10.9 java:1.8.0_71 node-jt400:1.4.1

node.js development environment (Windows)

I built it by referring to This procedure. If you don't do these, you'll get a build error with npm install. (In addition, I was able to install npm smoothly on a Mac.)


mkdir myfolder
cd myfolder
npm init -y
npm install node-jt400
npm install express

For reference, it is a module installed by node-jt400.

-- [email protected]
  +-- [email protected]
  +-- [email protected]
  | +-- [email protected]
  | +-- [email protected]
  | | `-- [email protected]
  | +-- [email protected]
  | | +-- [email protected]
  | | +-- [email protected]
  | | | `-- [email protected]
  | | +-- [email protected]
  | | +-- [email protected]
  | | | `-- [email protected]
  | | |   +-- [email protected]
  | | |   `-- [email protected]
  | | +-- [email protected]
  | | `-- [email protected]
  | +-- [email protected]
  | `-- [email protected]
  +-- [email protected]
  | +-- [email protected]
  | `-- [email protected]
  `-- [email protected]

express is only used to make it easier to check the operation, and has nothing to do with the main story. This completes the development environment on the PC side.

Preparation on the IBM i (AS400) side

Physical files and test data used in the test


      *File ID: MEMBER                                  
     A          R MEMBERR                   TEXT('member')          
     A            ID             3S 0       COLHDG(' ID ')            
     A            LNAME         12J         COLHDG('Last name')            
     A            FNAME          6G         COLHDG('name')            
     A            PROF          40O         COLHDG('profile')    
     A            TOKUTEN        7P 3       COLHDG('score')            
INSERT INTO MYLIB.MEMBER VALUES(100,'Chinese characters','Taro','Chinese charactersのみ',1000);
INSERT INTO MYLIB.MEMBER VALUES(101,'Half size','Kana','Ai Woo',50.555);
INSERT INTO MYLIB.MEMBER VALUES(102,'Alphabet','Lowercase','abcDEF!',-100);
INSERT INTO MYLIB.MEMBER VALUES(103,'Special','letter','① Taka Co., Ltd. IV ~',.01);
INSERT INTO MYLIB.MEMBER VALUES(104,'Chinese characters','Mixed','aiu',-15.25);

The CCSID of the IBM i sign-on user is 5035, and the physical file is also created at 5035.


It's quite interesting to be able to connect with a node without introducing Open Source Technologies (5733-OPS).

Recommended Posts

I tried node-jt400 (Environment construction)
I tried node-jt400 (Programs)
I tried node-jt400 (execute)
I tried node-jt400 (Transactions)
I tried node-jt400 (IFS write)
I tried node-jt400 (SQL Update)
I tried node-jt400 (SQL query)
I tried node-jt400 (SQL stream)
I tried node-jt400 (IFS read)
[Java] Environment construction
Java environment construction
I tried Spring.
I tried tomcat
I tried youtubeDataApi.
I tried refactoring ①
[Spring] Environment construction
Docker environment construction
I tried FizzBuzz.
I tried JHipster 5.1
[Environment construction] Eclipse installation
[I tried] Spring tutorial
[Flutter] Ubuntu 20.04 environment construction
[First environment construction] I tried to create a Rails 6 + MySQL 8.0 + Docker environment on Windows 10.
I tried running Autoware
I tried using Gson
Rails Docker environment construction
I tried QUARKUS immediately
I tried using TestNG
I tried Spring Batch
I tried using Galasa
Circle CI environment construction
java development environment construction
I tried to build an environment using Docker (beginner)
Rails6 development environment construction [Mac]
[Spring Boot] Environment construction (macOS)
I tried to create a java8 development environment with Chocolatey
Rails engineer environment construction ruby2.7.1
EC-CUBE4 environment construction (local edition)
I tried DI with Ruby
Rails environment construction Rails5.2.1 ruby2.5.1 Catalina
MySQL 5.7 (Docker) environment construction memo
Introduction to Metabase ~ Environment Construction ~
I tried using azure cloud-init
I tried Spring State machine
I tried Drools (Java, InputStream)
I tried Rails beginner [Chapter 1]
I tried the Docker tutorial!
JavaFX environment construction in Java 13
Redmine (Docker) environment construction memo
[Rails 6.0, Docker] I tried to summarize the Docker environment construction and commands necessary to create a portfolio
I tried using Apache Wicket
I tried the VueJS tutorial!
[Docker] Rails 5.2 environment construction with docker
AtCoder Challenge Environment Construction (Java 8)
I tried to create React.js × TypeScript × Material-UI on docker environment
I tried to build the environment little by little using docker
I tried using Java REPL
I tried to build the environment of WSL2 + Docker + VSCode
I tried source code analysis
I tried the FizzBuzz problem
I tried putting XcodeGen + SwiftPM