Abnormal behavior SQL in db2 for i

[edoardomessa]

Hi to everyone,

I notice this abnormal behavior of db2 for i.

When i press "Command + R" for run sql statement, vs code open an untitled file with the definition of the table in my select/function.

How can I fix this problem?

Thanks,

Best regards,

Edoardo.

---

⚠️ REMOVE THIS LINE AND ANY SENSITIVE INFORMATION BELOW! ⚠️

Context	Version
Code for IBM i version	2.15.3
Visual Studio Code version	1.100.0
Operating System	darwin_arm64

Active extensions

COBOL (cobol): 25.4.30
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.12.0
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.26.0
Extension Authoring (extension-editing): 1.0.0
Git (git): 1.0.0
Git Base (git-base): 1.0.0
Git Graph (git-graph): 1.30.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
GitHub Copilot (copilot): 1.317.0
GitHub Copilot Chat (copilot-chat): 0.27.0
GitLab Workflow (gitlab-workflow): 6.13.1
GitLens — Git supercharged (gitlens): 17.0.3
IBM i Debug (ibmidebug): 2.0.2
IBM i Notebooks (vscode-ibmi-notebooks): 0.0.6
IBM i Project Explorer (vscode-ibmi-projectexplorer): 2.12.3
JSON Language Features (json-language-features): 1.0.0
Merge Conflict (merge-conflict): 1.0.0
Microsoft Account (microsoft-authentication): 0.0.1
NPM support for VS Code (npm): 1.0.1
Node Debug Auto-attach (debug-auto-launch): 1.0.0
RPGLE (vscode-rpgle): 0.29.2
Rainbow CSV (rainbow-csv): 3.19.0
Server Ready Action (debug-server-ready): 1.0.0
Source Orbit (vscode-sourceorbit): 1.0.2
TODO Highlight (vscode-todo-highlight): 1.0.5
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0
Vue - Official (volar): 2.2.10

---

Remote system

Setting	Value
IBM i OS	V7R4M0
Tech Refresh	11
CCSID Origin	280
Runtime CCSID	280
Default CCSID	280
SSHD CCSID	?
cqsh	true
SQL	Enabled
Source dates	Enabled

Enabled features

/QOpenSys/pkgs/bin	/usr/bin	/QSYS.lib/VSCODE.lib	/QSYS.LIB	/QIBM/ProdData/IBMiDebugService/bin	/QOpenSys/QIBM/ProdData/JavaVM/jdk80	/QOpenSys/QIBM/ProdData/JavaVM/jdk11	/QOpenSys/QIBM/ProdData/JavaVM/jdk17	/QOpensys/pkgs/lib/jvm
bash	attr	GETNEWLIBL.PGM	QZDFMDB2.PGM	startDebugService.sh	64bit	64bit	64bit	openjdk-11
chsh	iconv
find	setccsid
git	uname
grep
ls
md5sum
sort
stat
tar
tn5250

Shell env

BUILDLIB=JDET
CURLIB=JDET
HOME=/home/EMESSA
HOST=directa1.directa.lan
LANG=IT_IT.UTF-8
LIBLS=WEBAPPINT WEBAPPIMI WEBAPP ROBERTO QTEMP QGPL AL400SYS AL400MNUV2 JDET GESTSIMDAT
LOGIN=emessa
LOGNAME=emessa
LS_COLORS=
MAIL=/var/spool/mail/emessa
OLDPWD=/DIRECTA1/home/emessa
PATH=/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PS1=\u@\h@\W$
PWD=/home/EMESSA
QIBM_PASE_CCSID=1208
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSH_CLIENT=192.168.0.109 56684 22
SSH_CONNECTION=192.168.0.109 56684 192.168.0.11 22
SSL_CERT_FILE=/home/cacert.pem
TZ=<CET>-1<CEST>,M3.5.0,M10.5.0
USER=emessa
USERNAME=emessa
WORKDIR=/home/EMESSA
_=/QOpenSys/pkgs/bin/env

Variants

{
  "american": "#@$",
  "local": "£§$"
}