codefori / codefori/vscode-db2i

DB2 for i Code Completion / Type-ahead is not working as anticipated

Open
#561 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
76
Forks
54
Avg merge
17m
Merged PRs (30d)
1

Description

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.

Image


|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

```bash
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=7,M3.2.0,M11.1.0
USER=ocgar02
USERNAME=ocgar02
WORKDIR=/home/OCGAR02
_=/QOpenSys/pkgs/bin/env
```

Variants

```json
{
"american": "#@$",
"local": "#@$",
"qsysNameRegex": {}
}
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the behavior in a DB2 for i session in VS Code, comparing qualified and unqualified table names after setting a schema. Then trace the completion behavior in this vscode-db2i repository; the issue is done when schema-qualified context is no longer required for table-name suggestions.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript, vscode
Domain
databases, tooling
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.