In a DB2 for i session, type-ahead / code completion is only working when table names have been qualified, even if a schema has been set.
| Context |
Version |
| Code for IBM i version |
3.0.11 |
| IBM Bob version |
1.121.0 |
| Operating System |
win32_x64 |
Active extensions
Bob Cozzi's IBM i RPGLE / RPG IV to RPG Free Format (rpgiv2free): 1.12.44
Bob Walkthroughs (bob-walkthroughs): 0.0.1
CL (vscode-clle): 1.2.6
COBOL (cobol): 26.5.28
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.5.0
Configuration Editing (configuration-editing): 10.0.0
Db2 for IBM i (vscode-db2i): 2.0.1
Emmet (emmet): 10.0.0
Error Lens (errorlens): 3.28.0
Git (git): 10.0.0
Git Base (git-base): 10.0.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
IBM Bob (bob-code): 2.0.1
IBM Bob Premium Package for i (vscode-ibmi-bob): 1.0.0
IBM i Debug (ibmidebug): 3.0.3
IBM i FileSystem (vscode-ibmi-fs): 1.0.6
IBM i Project Explorer (vscode-ibmi-projectexplorer): 2.12.5
IBM i Testing (vscode-ibmi-testing): 1.3.4
IBMi Languages (ibmi-languages): 0.6.25
JSON Language Features (json-language-features): 10.0.0
JavaScript and TypeScript Language Features (typescript-language-features): 10.0.0
Merge Conflict (merge-conflict): 10.0.0
Node Debug Auto-attach (debug-auto-launch): 10.0.0
Open Remote - SSH (open-remote-ssh): 0.1.2
RPG End Code Blocks (rpg-end-code-blocks): 1.0.8
RPGLE (vscode-rpgle): 0.33.8
Remote system
| Setting |
Value |
| IBM i OS |
V7R4M0 |
| Tech Refresh |
n/a |
| CCSID Origin |
37 |
| Runtime CCSID |
37 |
| SQL runner |
Yes |
| SQL |
Enabled |
| Source dates |
Enabled |
Enabled features
| /usr/bin |
/QOpenSys/pkgs/bin |
/QOpenSys/usr/bin |
/QIBM/ProdData/IBMiDebugService/bin |
/QOpenSys/QIBM/ProdData/JavaVM/jdk80 |
/QOpenSys/QIBM/ProdData/JavaVM/jdk11 |
/QOpenSys/QIBM/ProdData/JavaVM/jdk17 |
| attr |
bash |
openssl |
startDebugService.sh |
64bit |
64bit |
64bit |
| iconv |
chsh |
|
|
|
|
|
| setccsid |
ls |
|
|
|
|
|
| tar |
md5sum |
|
|
|
|
|
| uname |
sha256sum |
|
|
|
|
|
|
sort |
|
|
|
|
|
|
stat |
|
|
|
|
|
Shell env
BUILDLIB=QGPL
CURLIB=QGPL
HOME=/home/OCGAR02
HOST=md.cisessentials.net
LIBLS=VCQALIB SDMIMVC SDMIM QTEMP QGPL DATATHREAD COOLSPV6R1 LIBJSON LIBHTTP QATOOLSV3 V37GLDARC V37GLDUSP V37GLDSVO V37GLDSDT V37GLDPNT V37GLDPMT V37GLDOCC V37GLDNWE V37GLDMTR V37GLDMSD V37GLDMSC V37GLDMDS V37GLDLC V37GLDGBL V37GLDFXC V37GLDFTP V37GLDFDM V37GLDEPC V37GLDDBA V37GLDCTM V37GLDCPS V37GLDCOR V37GLDCOL V37GLDCIS V37GLDBIL V37GLDBHC V37GLDAPS V37PTCHT1 V37PTCHDV V37PDVUDPG DFTKEYLIB V37PDVFIL
LOGIN=ocgar02
LOGNAME=ocgar02
MAIL=/var/spool/mail/ocgar02
OLDPWD=/home/OCGAR02
PATH=/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin:/QOpenSys/usr/bin:/usr/bin
PWD=/home/OCGAR02
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSH_CLIENT=10.202.27.79 53125 22
SSH_CONNECTION=10.202.27.79 53125 10.211.18.14 22
TZ=<MST>7<MDT>,M3.2.0,M11.1.0
USER=ocgar02
USERNAME=ocgar02
WORKDIR=/home/OCGAR02
_=/QOpenSys/pkgs/bin/env
Variants
{
"american": "#@$",
"local": "#@$",
"qsysNameRegex": {}
}
In a DB2 for i session, type-ahead / code completion is only working when table names have been qualified, even if a schema has been set.
Active extensions
Remote system
Enabled features
Shell env
Variants
{ "american": "#@$", "local": "#@$", "qsysNameRegex": {} }