👉🏻 This is a weird one. I have two single-character flag fields in a table. I need to change them and also edit another (longer) field. The first time I run the SQL, the fields appear to be editable, but I can only put new content in the longer field. The two single-character fields will let me blank them, but will not permit entry of a new value. If I then run the SQL again, the new data can be added.
| Context |
Version |
| Code for IBM i version |
2.17.2 |
| Visual Studio Code version |
1.105.1 |
| Operating System |
darwin_x64 |
Active extensions
Bob Cozzi's RPG IV to RPG Free Conversion (rpgiv2free): 1.0.8
COBOL (cobol): 25.10.18
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.15.1
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
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
IBM i Debug (ibmidebug): 3.0.0
IBM i Project Explorer (vscode-ibmi-projectexplorer): 2.12.3
IBM i Testing (vscode-ibmi-testing): 1.2.3
JSON Language Features (json-language-features): 1.0.0
Merge Conflict (merge-conflict): 1.0.0
NPM support for VS Code (npm): 1.0.1
Node Debug Auto-attach (debug-auto-launch): 1.0.0
RPGLE (vscode-rpgle): 0.33.2
Rainbow CSV (rainbow-csv): 3.23.0
Server Ready Action (debug-server-ready): 1.0.0
Source Orbit (vscode-sourceorbit): 1.4.1
TODO Highlight (vscode-todo-highlight): 1.0.5
Terminal Suggest for VS Code (terminal-suggest): 1.0.1
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0
Remote system
| Setting |
Value |
| IBM i OS |
V7R4M0 |
| Tech Refresh |
11 |
| CCSID Origin |
37 |
| Runtime CCSID |
37 |
| Default CCSID |
37 |
| 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 |
/QOpensys/pkgs/lib/jvm |
| bash |
attr |
GETNEWLIBL.PGM |
QZDFMDB2.PGM |
startDebugService.sh |
64bit |
64bit |
openjdk-11 |
| chsh |
iconv |
|
|
|
|
|
|
| git |
setccsid |
|
|
|
|
|
|
| grep |
tar |
|
|
|
|
|
|
| ls |
uname |
|
|
|
|
|
|
| md5sum |
|
|
|
|
|
|
|
| sort |
|
|
|
|
|
|
|
| stat |
|
|
|
|
|
|
|
| tn5250 |
|
|
|
|
|
|
|
Shell env
BUILDLIB=PARTNER400
CURLIB=PARTNER400
HOME=/home/PARIS
HOST=ideveloper
LIBLS=RPGISCOOL2 IPKG NOXDB CODE4ITEST SAMPLE LIBHTTP SIDDBV2 YAJL QTEMP QGPL
LOGIN=paris
LOGNAME=paris
MAIL=/var/spool/mail/paris
OLDPWD=/home/PARIS
PATH=/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PWD=/home/PARIS
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSH_CLIENT=10.29.5.34 54268 22
SSH_CONNECTION=10.29.5.34 54268 172.29.5.35 22
TZ=<EST>5<EDT>,M3.2.0,M11.1.0
USER=paris
USERNAME=paris
WORKDIR=/home/PARIS
_=/QOpenSys/pkgs/bin/env
Variants
{
"american": "#@$",
"local": "#@$",
"qsysNameRegex": {}
} 
