Update: Option in DB2 for I with user-defined distinct type (UDT)

[M11VCS]

Update option is not working when primary key is a Custom Type.

I get SQL0432 error message.

update:select *
from mylib.datatemplates;

---

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

Context	Version
Code for IBM i version	2.17.2
Visual Studio Code version	1.106.0
Operating System	darwin_arm64

Active extensions

Atlassian: Jira, Rovo Dev, Bitbucket (atlascode): 4.0.8
Code Coverage for IBM i (code-coverage-ibmi): 0.1.7
Code Runner (code-runner): 0.12.2
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.5.0
Configuration Editing (configuration-editing): 1.0.0
Continue - open-source AI code agent (continue): 1.2.10
Db2 for IBM i (vscode-db2i): 1.15.1
ESLint (vscode-eslint): 3.0.16
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.26.0
Extension Authoring (extension-editing): 1.0.0
GistPad (gistfs): 0.9.5
Git (git): 1.0.0
Git Base (git-base): 1.0.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
GitHub Copilot (copilot): 1.388.0
GitHub Copilot Chat (copilot-chat): 0.33.1
GitLens — Git supercharged (gitlens): 17.7.1
IBM i Debug (ibmidebug): 3.0.0
IBM i Notebooks (vscode-ibmi-notebooks): 0.0.6
IBM i Project Explorer (vscode-ibmi-projectexplorer): 2.12.3
IBM i Testing (vscode-ibmi-testing): 1.2.3
IntelliCode (vscodeintellicode): 1.3.2
JSON Language Features (json-language-features): 1.0.0
Live Server (LiveServer): 5.7.9
Makefile Tools (makefile-tools): 0.12.17
Markdown All in One (markdown-all-in-one): 3.6.3
Markdown Math (markdown-math): 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
Prettier - Code formatter (prettier-vscode): 11.0.0
Pylance (vscode-pylance): 2025.9.1
Python (python): 2025.18.0
Python Environments (vscode-python-envs): 1.12.0
Quarto (quarto): 1.126.0
RPGLE (vscode-rpgle): 0.33.2
Render Line Endings (render-crlf): 1.9.2
Source Orbit (vscode-sourceorbit): 1.4.1
Terminal Suggest for VS Code (terminal-suggest): 1.0.1
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0
YAML (vscode-yaml): 1.19.1

---

Remote system

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

Enabled features

/QOpenSys/pkgs/bin	/usr/bin	/QSYS.lib/ILEDITOR.lib	/QSYS.LIB	/QIBM/ProdData/IBMiDebugService/bin	/QOpenSys/QIBM/ProdData/JavaVM/jdk80	/QOpenSys/QIBM/ProdData/JavaVM/jdk11
bash	attr	GETNEWLIBL.PGM	QZDFMDB2.PGM	startDebugService.sh	64bit	64bit
chsh	iconv
grep	setccsid
ls	tar
md5sum	uname
sort
stat

Shell env

MAIL=/var/spool/mail/hms
OLDPWD=/home/HMS
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/HMS
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSH_CLIENT=192.168.113.2 50431 22
SSH_CONNECTION=192.168.113.2 50431 192.168.0.151 22
TZ=<CET>-1<CEST>,M3.5.0,M10.5.0
_=/QOpenSys/pkgs/bin/env

Variants

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