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

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

```bash
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=-1,M3.5.0,M10.5.0
_=/QOpenSys/pkgs/bin/env
```

Variants

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