Connection to IBM i

[JerryMilesThomas]

---

Context	Version
Code for IBM i version	2.18.0
Bob-IDE version	1.105.1
Operating System	win32_x64

Active extensions

Bob Walkthroughs (bob-walkthroughs): 0.0.1
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.5.0
Configuration Editing (configuration-editing): 1.0.0
Db2 for IBM i (vscode-db2i): 1.15.1
Emmet (emmet): 1.0.0
Git (git): 1.0.0
Git Base (git-base): 1.0.0
GitHub (github): 0.0.1
IBM Bob (bob-code): 3.26.6
JSON Language Features (json-language-features): 1.0.0
Merge Conflict (merge-conflict): 1.0.0
Node Debug Auto-attach (debug-auto-launch): 1.0.0
Python (python): 2025.0.0
Python Config (vscode-python-config): 11.4.0
Python Environments (vscode-python-envs): 1.10.0
Ruff (ruff): 2025.32.0
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0

---

Not connected 🔌

[sebjulliand]

@JerryMilesThomas do you wish to elaborate?

[JerryMilesThomas]

I am getting an error while trying to connect to my ibm I system.

• Not connected to 10.2.240.10: There is no way to run SQL on this system.
• Code for IBM i will not function correctly until the temporary library has been corrected in the settings.

I have my temp library set to ILEEDITOR and it is created on my system, I can also run SQL statements with ACS Run sql script. This was working with VS-CODE before I installed BOB-IDE.

[JerryMilesThomas]

I am getting an error while trying to connect to my ibm I system. - Not connected to 10.2.240.10: There is no way to run SQL on this system. - Code for IBM i will not function correctly until the temporary library has been corrected in the settings. I have my temp library set to ILEEDITOR and it is created on my system, I can also run SQL statements with ACS Run sql script. This was working with VS-CODE before I installed BOB-IDE.

…

On Tue, Dec 16, 2025 at 12:00 PM Sébastien Julliand < ***@***.***> wrote: *sebjulliand* left a comment (codefori/vscode-ibmi#3008) <#3008 (comment)> @JerryMilesThomas <https://github.com/JerryMilesThomas> do you wish to elaborate? — Reply to this email directly, view it on GitHub <#3008 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BAFHY3LAD5FQNRFHCJWZ6Y34CBCEBAVCNFSM6AAAAACPHAEFRKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTMNRRG42TOMJWHE> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[sebjulliand]

Try this option when connecting:

If it still fails, send here what's in the Code for IBM i output after it fails to connect.

[JerryMilesThomas]

here is the output from the Connect and Reload test..... I probably have something wrong with my .bashrc or .profile
Just not sure what it would be...

Code for IBM i, version 2.18.0

.: echo "This should be the only text!"
{
"code": 0,
"signal": null,
"stdout": "This should be the only text!",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

.: echo $HOME && cd && test -w $HOME
{
"code": 0,
"signal": null,
"stdout": "/home/jerry",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: ls -p /usr/bin/
{
"code": 0,
"signal": null,
"stdout": "Rfile\najar\nappletviewer\napt\narmsrv\narmsrvconv\nattr\nbasename\nbash\ncat\ncatsplf\nchgrp\nchmod\nchown\nclrtmp\ncmp\ncompress\ncp\ncut\ndataq\ndatarea\ndate\ndb2\ndb2profc\ndb2profc_trace\ndb2profp\nddns-confgen\ndelv\ndfmadmin\ndhcpd\ndhcrelay\ndig\ndirname\ndnssec-dsfromkey\ndnssec-importkey\ndnssec-keyfromlabel\ndnssec-keygen\ndnssec-revoke\ndnssec-settime\ndnssec-signzone\ndnssec-verify\ndspmsg\necho\negrep\nenv\nexpr\nextcheck\nfgrep\nfile\nfind\ngencat\ngetjobid\ngrep\nhead\nhost\nhostname\niconv\nid\nidlj\nikeyman\nipcrm\nipcs\nixlc\njar\njarsigner\njava\njavac\njavadoc\njavah\njavap\njconsole\njdb\njdmpview\njextract\nkdestroy\nkeytab\nkeytool\nkinit\nklist\nkpasswd\nksetup\nldapadd\nldapchangepwd\nldapcompare\nldapdelete\nldapdiff\nldapexop\nldapmodify\nldapmodrdn\nldapsearch\nln\nlocale\nlogger\nlogname\nls\nmkdir\nmkfifo\nmv\nnamed\nnamed-checkconf\nnamed-checkzone\nnamed-compilezone\nnamed-journalprint\nnamed-rrchecker\nnative2ascii\nnohup\nnslookup\nnsupdate\nod\norbd\npack200\npax\npolicytool\npr\nprintenv\nprofconv\nprofdb\nprofp\nps\npwd\npwdx\nqsh\nrexec\nrexx\nrm\nrmdir\nrmic\nrmid\nrmiregistry\nrndc\nrndc-confgen\nschemagen\nsed\nserialver\nservertool\nsetccsid\nsh\nsort\nsplit\nsqlj\nstrEKM\nsystem\nsysval\ntail\ntar\ntee\ntest\ntnameserv\ntouch\ntr\ntsig-keygen\nuname\nuncompress\nuniq\nunpack200\nwc\nwsgen\nwsimport\nxargs\nxjc\nzcat",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: ls -p /QOpenSys/pkgs/bin/
{
"code": 0,
"signal": null,
"stdout": "2to3\n2to3-3.6\n2to3-3.9\n[\n__pycache__/\nalternatives\natob\nawk\nb2sum\nbase32\nbase64\nbasename\nbasenc\nbash\nbashbug\nbtoa\nc2ph\ncat\ncertutil\nchcon\nchgrp\nchmod\nchown\nchroot\nchsh\ncksum\ncmsutil\ncomm\ncorelist\ncp\ncpan\ncrlutil\ncrtfrmstmf\ncsplit\ncurl\ncut\ncwbcopwr\ncwbmedic\ncwbnltbl\ncwbping\ncwbtrc\ndate\ndd\ndebuginfo-install\nderdump\ndf\ndir\ndircolors\ndirname\ndltest\ndotenv\ndu\necho\negrep\nenc2xs\nencguess\nenv\nexpand\nexpr\nfactor\nfalse\nfgrep\nfind\nfind-repos-of-install\nflask\nfmt\nfold\ngawk\ngit\ngit-cvsserver\ngit-receive-pack\ngit-shell\ngit-upload-archive\ngit-upload-pack\ngmake\ngrep\ngroups\ngsed\nh2ph\nh2xs\nhead\nhostid\nibmi-dotfiles\nid\nidle3\nidle3.13\nidle3.6\nidle3.9\nigawk\ninstall\ninstmodsh\nisql\niusql\njoin\njp.py\njson_pp\nkill\nless\nlessecho\nlesskey\nlibnetcfg\nlibtool\nlibtoolize\nlink\nlistsuites\nln\nlocate\nlogname\nls\nmake\nmakei\nmd5sum\nmkdir\nmkfifo\nmknod\nmktemp\nmodutil\nmv\nnano\nneeds-restarting\nnice\nnl\nnohup\nnproc\nnss-policy-check\nnumfmt\nocspclnt\nod\nodbc_config\nodbcinst\nosshealth\npackage-cleanup\npaste\npathchk\nperl\nperl5.24.1\nperlbug\nperldoc\nperlivp\nperlthanks\npiconv\npinky\npip\npip3\npip3.13\npip3.6\npip3.9\npk12util\npl2pm\npod2html\npod2man\npod2text\npod2usage\npodchecker\npodselect\npp\npr\nprintenv\nprintf\nprove\npstruct\nptar\nptardiff\nptargrep\nptx\npwd\npy.test\npydoc\npydoc3\npydoc3.13\npydoc3.6\npydoc3.9\npyrsa-decrypt\npyrsa-encrypt\npyrsa-keygen\npyrsa-priv2pub\npyrsa-sign\npyrsa-verify\npytest\npython\npython2\npython2.7\npython3\npython3.13\npython3.6\npython3.6m\npython3.9\npyvenv\npyvenv-3.6\nreadlink\nrealpath\nrepo-graph\nrepo-rss\nrepoclosure\nrepodiff\nrepomanage\nrepoquery\nreposync\nrepotrack\nrm\nrmdir\nrnano\nrpm\nrpm2archive\nrpm2cpio\nrpmdb\nrpmgraph\nrpmkeys\nrpmquery\nrpmsign\nrpmverify\nrst2html.py\nrst2html4.py\nrst2html5.py\nrst2latex.py\nrst2man.py\nrst2odt.py\nrst2odt_prepstyles.py\nrst2pseudoxml.py\nrst2s5.py\nrst2xetex.py\nrst2xml.py\nrstpep2html.py\nruncon\ns3cmd\nscalar\nsed\nselfserv\nseq\nsha1sum\nsha224sum\nsha256sum\nsha384sum\nsha512sum\nshasum\nshow-changed-rco\nshow-installed\nshred\nshuf\nsigntool\nsignver\nsleep\nslencheck\nsmtpd.py\nsort\nsplain\nsplit\nssltap\nstat\nstdbuf\nstrsclnt\nstty\nsum\nsymkeyutil\nsync\ntac\ntail\ntee\ntest\ntimeout\ntouch\ntr\ntrue\ntruncate\ntrust\ntsort\ntstclnt\ntty\nuname\nunexpand\nuniq\nunlink\nupdate-alternatives\nupdate-ca-certificates\nupdatedb\nuptime\nurlgrabber\nusers\nvdir\nverifytree\nvfychain\nvfyserv\nwaitress-serve\nwc\nwheel\nwho\nwhoami\nxargs\nxsubpp\nyes\nyum\nyum-builddep\nyum-complete-transaction\nyum-config-manager\nyum-debug-dump\nyum-debug-restore\nyum-groups-manager\nyumdb\nyumdownloader\nzipdetails",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: ls -p /QSYS.LIB/QZDFMDB2.PGM
{
"code": 0,
"signal": null,
"stdout": "/QSYS.LIB/QZDFMDB2.PGM",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: ls -p /QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh
{
"code": 0,
"signal": null,
"stdout": "/QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 0,
"signal": null,
"stdout": "/QSYS.lib/ILEDITOR.lib/GENCMD2.PGM\n/QSYS.lib/ILEDITOR.lib/GETNEWLIBL.PGM",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit/bin/java
/home/jerry: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk11/64bit/bin/java
/home/jerry: test -x /QOpensys/pkgs/lib/jvm/openjdk-11/bin/java
/home/jerry: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk17/64bit/bin/java
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

{
"code": 0,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

{
"code": 1,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

{
"code": 1,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

IBM i components:
git: /QOpenSys/pkgs/bin/git
grep: /QOpenSys/pkgs/bin/grep
pfgrep: undefined
tn5250: undefined
setccsid: /usr/bin/setccsid
md5sum: /QOpenSys/pkgs/bin/md5sum
bash: /QOpenSys/pkgs/bin/bash
chsh: /QOpenSys/pkgs/bin/chsh
stat: /QOpenSys/pkgs/bin/stat
sort: /QOpenSys/pkgs/bin/sort
GETNEWLIBL.PGM: /QSYS.lib/ILEDITOR.lib/GETNEWLIBL.PGM
GETMBRINFO.SQL: undefined
QZDFMDB2.PGM: /QSYS.LIB/QZDFMDB2.PGM
startDebugService.sh: /QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh
attr: /usr/bin/attr
iconv: /usr/bin/iconv
tar: /usr/bin/tar
ls: /QOpenSys/pkgs/bin/ls
find: /QOpenSys/pkgs/bin/find
jdk80: /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit
jdk11: /QOpenSys/QIBM/ProdData/JavaVM/jdk11/64bit
jdk17: undefined
openjdk11: undefined
uname: /usr/bin/uname

/home/jerry: /usr/bin/uname -rv
{
"code": 0,
"signal": null,
"stdout": "5 7",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/jerry/.vscode/",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: test -x /home/jerry/.vscode/cqsh_1
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: /home/jerry/.vscode/cqsh_1
echo "Hello world"
{
"code": 0,
"signal": null,
"stdout": "Hello world",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/jerry/.vscode/",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select cast(LONG_COMMENT as VarChar(200)) LONG_COMMENT from qsys2.sysprocs where routine_schema = 'ILEDITOR' and routine_name = 'GETNEWLIBL'
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier\nqsh: 001-0019 Error found searching for command system. No such path or directory."
}

/home/jerry: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/jerry/.vscode/",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select cast(LONG_COMMENT as VarChar(200)) LONG_COMMENT from qsys2.sysroutines where routine_schema = 'ILEDITOR' and routine_name = 'GETMBRINFO'
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier\nqsh: 001-0019 Error found searching for command system. No such path or directory."
}

/home/jerry: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/jerry/.vscode/",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/jerry/.vscode/",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select cast(LONG_COMMENT as VarChar(200)) LONG_COMMENT from qsys2.sysroutines where routine_schema = 'ILEDITOR' and routine_name = 'CHECKSTMTWRAPPED'
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier\nqsh: 001-0019 Error found searching for command system. No such path or directory."
}

Code for IBM i components:
cqsh (1): Installed
GetNewLibl (1): Error
GetMemberInfo (3): Error
CopyToImport (1): Installed
SQLStatementChecker (5): Error

/home/jerry: test -r /etc/vscode/settings.json
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

settings config state: {"server":"no_exist"}
/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1
liblist
{
"code": 0,
"signal": null,
"stdout": "QSYS SYS\nQSYS2 SYS\nQHLPSYS SYS\nQUSRSYS SYS\nQSHELL PRD\nQGPL USR\nQTEMP USR",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1
system "CRTLIB LIB(ILEDITOR) TEXT('Code for i temporary objects. May be cleared.')"
/home/jerry: [ -d "/tmp" ]
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier\nqsh: 001-0019 Error found searching for command system. No such path or directory."
}

{
"code": 0,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: echo $SHELL
{
"code": 0,
"signal": null,
"stdout": "/QOpenSys/pkgs/bin/bash",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1
system "CHKOBJ OBJ(QSYS/QCPTOIMPF) OBJTYPE(*DTAARA)"
/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1
system "CHKOBJ OBJ(QSYS/QCPFRMIMPF) OBJTYPE(*DTAARA)"
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier\nqsh: 001-0019 Error found searching for command system. No such path or directory."
}

{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier\nqsh: 001-0019 Error found searching for command system. No such path or directory."
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1
liblist -d QGPL QTEMP; liblist -a QGPL; liblist -a QTEMP
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: /QOpenSys/usr/bin/expr /QOpenSys/usr/bin/getconf ARG_MAX - env|wc -c - env|wc -l * 4 - 2048
{
"code": 0,
"signal": null,
"stdout": "4191783",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier"
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
SELECT * FROM QSYS2.ASP_INFO
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier\nqsh: 001-0019 Error found searching for command system. No such path or directory."
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
values current_server
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "/home/jerry/.bashrc: line 2: export: `/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin': not a valid identifier\nqsh: 001-0019 Error found searching for command system. No such path or directory."
}

{}

Error: There is no way to run SQL on this system.
at e. (c:\Users\jerry.bobide\extensions\halcyontechltd.code-for-ibmi-2.18.0-universal\dist\extension.js:2:841196)
at Generator.next ()
at o (c:\Users\jerry.bobide\extensions\halcyontechltd.code-for-ibmi-2.18.0-universal\dist\extension.js:2:816400)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)

[sebjulliand]

Can you share your .bashrc then? 😅

[JerryMilesThomas]

i have cleaned up the .bashrc and i only have the one line to set my path...

.bashrc
PATH=/QOpenSys/pkgs/bin:$PATH

.profile
PATH=/QOpenSys/pkgs/bin:$PATH
export PATH
PS1="\h-$PWD:>"

i have tried to reconnect and here is my new output log... still geting the same two orginal messages.

Code for IBM i, version 2.18.0

.: echo "This should be the only text!"
{
"code": 0,
"signal": null,
"stdout": "This should be the only text!",
"stderr": ""
}

.: echo $HOME && cd && test -w $HOME
{
"code": 0,
"signal": null,
"stdout": "/home/jerry",
"stderr": ""
}

/home/jerry: ls -p /usr/bin/
{
"code": 0,
"signal": null,
"stdout": "Rfile\najar\nappletviewer\napt\narmsrv\narmsrvconv\nattr\nbasename\nbash\ncat\ncatsplf\nchgrp\nchmod\nchown\nclrtmp\ncmp\ncompress\ncp\ncut\ndataq\ndatarea\ndate\ndb2\ndb2profc\ndb2profc_trace\ndb2profp\nddns-confgen\ndelv\ndfmadmin\ndhcpd\ndhcrelay\ndig\ndirname\ndnssec-dsfromkey\ndnssec-importkey\ndnssec-keyfromlabel\ndnssec-keygen\ndnssec-revoke\ndnssec-settime\ndnssec-signzone\ndnssec-verify\ndspmsg\necho\negrep\nenv\nexpr\nextcheck\nfgrep\nfile\nfind\ngencat\ngetjobid\ngrep\nhead\nhost\nhostname\niconv\nid\nidlj\nikeyman\nipcrm\nipcs\nixlc\njar\njarsigner\njava\njavac\njavadoc\njavah\njavap\njconsole\njdb\njdmpview\njextract\nkdestroy\nkeytab\nkeytool\nkinit\nklist\nkpasswd\nksetup\nldapadd\nldapchangepwd\nldapcompare\nldapdelete\nldapdiff\nldapexop\nldapmodify\nldapmodrdn\nldapsearch\nln\nlocale\nlogger\nlogname\nls\nmkdir\nmkfifo\nmv\nnamed\nnamed-checkconf\nnamed-checkzone\nnamed-compilezone\nnamed-journalprint\nnamed-rrchecker\nnative2ascii\nnohup\nnslookup\nnsupdate\nod\norbd\npack200\npax\npolicytool\npr\nprintenv\nprofconv\nprofdb\nprofp\nps\npwd\npwdx\nqsh\nrexec\nrexx\nrm\nrmdir\nrmic\nrmid\nrmiregistry\nrndc\nrndc-confgen\nschemagen\nsed\nserialver\nservertool\nsetccsid\nsh\nsort\nsplit\nsqlj\nstrEKM\nsystem\nsysval\ntail\ntar\ntee\ntest\ntnameserv\ntouch\ntr\ntsig-keygen\nuname\nuncompress\nuniq\nunpack200\nwc\nwsgen\nwsimport\nxargs\nxjc\nzcat",
"stderr": ""
}

/home/jerry: ls -p /QOpenSys/pkgs/bin/
{
"code": 0,
"signal": null,
"stdout": "2to3\n2to3-3.6\n2to3-3.9\n[\n__pycache__/\nalternatives\natob\nawk\nb2sum\nbase32\nbase64\nbasename\nbasenc\nbash\nbashbug\nbtoa\nc2ph\ncat\ncertutil\nchcon\nchgrp\nchmod\nchown\nchroot\nchsh\ncksum\ncmsutil\ncomm\ncorelist\ncp\ncpan\ncrlutil\ncrtfrmstmf\ncsplit\ncurl\ncut\ncwbcopwr\ncwbmedic\ncwbnltbl\ncwbping\ncwbtrc\ndate\ndd\ndebuginfo-install\nderdump\ndf\ndir\ndircolors\ndirname\ndltest\ndotenv\ndu\necho\negrep\nenc2xs\nencguess\nenv\nexpand\nexpr\nfactor\nfalse\nfgrep\nfind\nfind-repos-of-install\nflask\nfmt\nfold\ngawk\ngit\ngit-cvsserver\ngit-receive-pack\ngit-shell\ngit-upload-archive\ngit-upload-pack\ngmake\ngrep\ngroups\ngsed\nh2ph\nh2xs\nhead\nhostid\nibmi-dotfiles\nid\nidle3\nidle3.13\nidle3.6\nidle3.9\nigawk\ninstall\ninstmodsh\nisql\niusql\njoin\njp.py\njson_pp\nkill\nless\nlessecho\nlesskey\nlibnetcfg\nlibtool\nlibtoolize\nlink\nlistsuites\nln\nlocate\nlogname\nls\nmake\nmakei\nmd5sum\nmkdir\nmkfifo\nmknod\nmktemp\nmodutil\nmv\nnano\nneeds-restarting\nnice\nnl\nnohup\nnproc\nnss-policy-check\nnumfmt\nocspclnt\nod\nodbc_config\nodbcinst\nosshealth\npackage-cleanup\npaste\npathchk\nperl\nperl5.24.1\nperlbug\nperldoc\nperlivp\nperlthanks\npiconv\npinky\npip\npip3\npip3.13\npip3.6\npip3.9\npk12util\npl2pm\npod2html\npod2man\npod2text\npod2usage\npodchecker\npodselect\npp\npr\nprintenv\nprintf\nprove\npstruct\nptar\nptardiff\nptargrep\nptx\npwd\npy.test\npydoc\npydoc3\npydoc3.13\npydoc3.6\npydoc3.9\npyrsa-decrypt\npyrsa-encrypt\npyrsa-keygen\npyrsa-priv2pub\npyrsa-sign\npyrsa-verify\npytest\npython\npython2\npython2.7\npython3\npython3.13\npython3.6\npython3.6m\npython3.9\npyvenv\npyvenv-3.6\nreadlink\nrealpath\nrepo-graph\nrepo-rss\nrepoclosure\nrepodiff\nrepomanage\nrepoquery\nreposync\nrepotrack\nrm\nrmdir\nrnano\nrpm\nrpm2archive\nrpm2cpio\nrpmdb\nrpmgraph\nrpmkeys\nrpmquery\nrpmsign\nrpmverify\nrst2html.py\nrst2html4.py\nrst2html5.py\nrst2latex.py\nrst2man.py\nrst2odt.py\nrst2odt_prepstyles.py\nrst2pseudoxml.py\nrst2s5.py\nrst2xetex.py\nrst2xml.py\nrstpep2html.py\nruncon\ns3cmd\nscalar\nsed\nselfserv\nseq\nsha1sum\nsha224sum\nsha256sum\nsha384sum\nsha512sum\nshasum\nshow-changed-rco\nshow-installed\nshred\nshuf\nsigntool\nsignver\nsleep\nslencheck\nsmtpd.py\nsort\nsplain\nsplit\nssltap\nstat\nstdbuf\nstrsclnt\nstty\nsum\nsymkeyutil\nsync\ntac\ntail\ntee\ntest\ntimeout\ntouch\ntr\ntrue\ntruncate\ntrust\ntsort\ntstclnt\ntty\nuname\nunexpand\nuniq\nunlink\nupdate-alternatives\nupdate-ca-certificates\nupdatedb\nuptime\nurlgrabber\nusers\nvdir\nverifytree\nvfychain\nvfyserv\nwaitress-serve\nwc\nwheel\nwho\nwhoami\nxargs\nxsubpp\nyes\nyum\nyum-builddep\nyum-complete-transaction\nyum-config-manager\nyum-debug-dump\nyum-debug-restore\nyum-groups-manager\nyumdb\nyumdownloader\nzipdetails",
"stderr": ""
}

/home/jerry: ls -p /QSYS.LIB/QZDFMDB2.PGM
{
"code": 0,
"signal": null,
"stdout": "/QSYS.LIB/QZDFMDB2.PGM",
"stderr": ""
}

/home/jerry: ls -p /QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh
{
"code": 0,
"signal": null,
"stdout": "/QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh",
"stderr": ""
}

/home/jerry: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 0,
"signal": null,
"stdout": "/QSYS.lib/ILEDITOR.lib/GENCMD2.PGM\n/QSYS.lib/ILEDITOR.lib/GETNEWLIBL.PGM",
"stderr": ""
}

/home/jerry: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 0,
"signal": null,
"stdout": "/QSYS.lib/ILEDITOR.lib/GENCMD2.PGM\n/QSYS.lib/ILEDITOR.lib/GETNEWLIBL.PGM",
"stderr": ""
}

/home/jerry: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 0,
"signal": null,
"stdout": "/QSYS.lib/ILEDITOR.lib/GENCMD2.PGM\n/QSYS.lib/ILEDITOR.lib/GETNEWLIBL.PGM",
"stderr": ""
}

/home/jerry: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit/bin/java
/home/jerry: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk11/64bit/bin/java
/home/jerry: test -x /QOpensys/pkgs/lib/jvm/openjdk-11/bin/java
/home/jerry: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk17/64bit/bin/java
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

IBM i components:
git: /QOpenSys/pkgs/bin/git
grep: /QOpenSys/pkgs/bin/grep
pfgrep: undefined
tn5250: undefined
setccsid: /usr/bin/setccsid
md5sum: /QOpenSys/pkgs/bin/md5sum
bash: /QOpenSys/pkgs/bin/bash
chsh: /QOpenSys/pkgs/bin/chsh
stat: /QOpenSys/pkgs/bin/stat
sort: /QOpenSys/pkgs/bin/sort
GETNEWLIBL.PGM: /QSYS.lib/ILEDITOR.lib/GETNEWLIBL.PGM
GETMBRINFO.SQL: undefined
QZDFMDB2.PGM: /QSYS.LIB/QZDFMDB2.PGM
startDebugService.sh: /QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh
attr: /usr/bin/attr
iconv: /usr/bin/iconv
tar: /usr/bin/tar
ls: /QOpenSys/pkgs/bin/ls
find: /QOpenSys/pkgs/bin/find
jdk80: /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit
jdk11: /QOpenSys/QIBM/ProdData/JavaVM/jdk11/64bit
jdk17: undefined
openjdk11: undefined
uname: /usr/bin/uname

/home/jerry: /usr/bin/uname -rv
{
"code": 0,
"signal": null,
"stdout": "5 7",
"stderr": ""
}

/home/jerry: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/jerry/.vscode/",
"stderr": ""
}

/home/jerry: test -x /home/jerry/.vscode/cqsh_1
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/jerry: /home/jerry/.vscode/cqsh_1
echo "Hello world"
{
"code": 0,
"signal": null,
"stdout": "Hello world",
"stderr": ""
}

/home/jerry: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/jerry/.vscode/",
"stderr": ""
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select cast(LONG_COMMENT as VarChar(200)) LONG_COMMENT from qsys2.sysprocs where routine_schema = 'ILEDITOR' and routine_name = 'GETNEWLIBL'
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "qsh: 001-0019 Error found searching for command system. No such path or directory."
}

/home/jerry: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/jerry/.vscode/",
"stderr": ""
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select cast(LONG_COMMENT as VarChar(200)) LONG_COMMENT from qsys2.sysroutines where routine_schema = 'ILEDITOR' and routine_name = 'GETMBRINFO'
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "qsh: 001-0019 Error found searching for command system. No such path or directory."
}

/home/jerry: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/jerry/.vscode/",
"stderr": ""
}

/home/jerry: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/jerry/.vscode/",
"stderr": ""
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select cast(LONG_COMMENT as VarChar(200)) LONG_COMMENT from qsys2.sysroutines where routine_schema = 'ILEDITOR' and routine_name = 'CHECKSTMTWRAPPED'
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "qsh: 001-0019 Error found searching for command system. No such path or directory."
}

Code for IBM i components:
cqsh (1): Installed
GetNewLibl (1): Error
GetMemberInfo (3): Error
CopyToImport (1): Installed
SQLStatementChecker (5): Error

/home/jerry: test -r /etc/vscode/settings.json
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

settings config state: {"server":"no_exist"}
/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1
liblist
{
"code": 0,
"signal": null,
"stdout": "QSYS SYS\nQSYS2 SYS\nQHLPSYS SYS\nQUSRSYS SYS\nQSHELL PRD\nQGPL USR\nQTEMP USR",
"stderr": ""
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1
system "CRTLIB LIB(ILEDITOR) TEXT('Code for i temporary objects. May be cleared.')"
/home/jerry: [ -d "/tmp" ]
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "qsh: 001-0019 Error found searching for command system. No such path or directory."
}

{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/jerry: echo $SHELL
{
"code": 0,
"signal": null,
"stdout": "/QOpenSys/pkgs/bin/bash",
"stderr": ""
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1
system "CHKOBJ OBJ(QSYS/QCPTOIMPF) OBJTYPE(*DTAARA)"
/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1
system "CHKOBJ OBJ(QSYS/QCPFRMIMPF) OBJTYPE(*DTAARA)"
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "qsh: 001-0019 Error found searching for command system. No such path or directory."
}

{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "qsh: 001-0019 Error found searching for command system. No such path or directory."
}

/home/jerry: echo $PATH
{
"code": 0,
"signal": null,
"stdout": "/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin",
"stderr": ""
}

/home/jerry: test -e /home/jerry/.bashrc
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1
liblist -d QGPL QTEMP; liblist -a QGPL; liblist -a QTEMP
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/jerry: /QOpenSys/usr/bin/expr /QOpenSys/usr/bin/getconf ARG_MAX - env|wc -c - env|wc -l * 4 - 2048
{
"code": 0,
"signal": null,
"stdout": "4191783",
"stderr": ""
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
SELECT * FROM QSYS2.ASP_INFO
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "qsh: 001-0019 Error found searching for command system. No such path or directory."
}

/home/jerry: LC_ALL=EN_US.UTF-8 /home/jerry/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
values current_server
{
"code": 127,
"signal": null,
"stdout": "",
"stderr": "qsh: 001-0019 Error found searching for command system. No such path or directory."
}

{}

Error: There is no way to run SQL on this system.
at e. (c:\Users\jerry.bobide\extensions\halcyontechltd.code-for-ibmi-2.18.0-universal\dist\extension.js:2:841196)
at Generator.next ()
at o (c:\Users\jerry.bobide\extensions\halcyontechltd.code-for-ibmi-2.18.0-universal\dist\extension.js:2:816400)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)

[sebjulliand]

"stderr": "qsh: 001-0019 Error found searching for command system. No such path or directory."

This seems to indicate that your $PATH is not set correctly in .bashrc. Try adding export in front of your path declaration and see how it goes:

export PATH=/QOpenSys/pkgs/bin:$PATH

Also, make sure line endings in .bashrc are LF and not CRLF.

[JerryMilesThomas]

I have check the .bashrc file and it on has the LF and not CRLF

here is my ENV once logged in thru putty to my ibm i.
My PATH looks ok.. it has the /usr/bin which is where the system command is or at lease the symlink to it.

SHELL=/QOpenSys/pkgs/bin/bash
PWD=/home/jerry
LOGNAME=jerry
TZ=6,M3.2.0,M11.1.0
HOME=/home/jerry
SSH_CONNECTION=192.168.113.4 62369 10.2.240.10 22
TERM=xterm
USER=jerry
LOGIN=jerry
SHLVL=2
PASE_USRGRP_LIMITED=N
SSH_CLIENT=192.168.113.4 62369 22
PATH=/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin:/QOpenSys/pkgs/bin
MAIL=/var/spool/mail/jerry
SSH_TTY=/dev/pts/0
_=/QOpenSys/pkgs/bin/env
OLDPWD=/home

My next step is to just uninstall Project BOB and VS Code and try again.

[sebjulliand]

Did you add the export in .bashrc? .profile is used in an interactive session and .bashrc in non-interactive (i.e. from Code for i).

That's the only difference I can spot between your profile and bashrc file.

[JerryMilesThomas]

i did, here is my .bashrc

export PATH=/QOpenSys/pkgs/bin:$PATH

export PATH PASE_PATH