SQLTools - DB2
准备
nodejs
python
IBM CLI Driver ntx64_odbc_cli.zip
DB2 驱动的环境变量
- Download IBM CLI Driver manually, and unpackage the content into a folder, e.g.
C:\ibm\db2\clidriver
Set an environment variableIBM_DB_HOME
as the location. - add the bin folder of the IBM CLI Driver folder in the environment variable
PATH
, e.g.C:\ibm\db2\clidriver\bin
测试你的环境变量是否成功
As a test, please try npm install ibm_db in a node project folder. If the following information presents in the output, it means the environment is ready.
我第一次没成功
是因为少了 gyp & python(python的安装就不说了)
npm install -g node-gyp
在vscode中安装你的拓展
在第一次连接db2的时候会自动下载 ibm_db
During this extension is installing ibm_db, please check the output in the output panel of ‘SQLTools Language Server’ for details.
sqltools 与 db2connection的区别
都是对ibm_db做的包装 前者包装优秀方便 后者像是ibm做了一个封装的demo