Hi,
Could you try this?
values 80000000000000000002;
we have a table with a field defined numeric(20, 0) and the surprise is that the last digit is converted to zero...
Many thanks
⚠️ REMOVE THIS LINE AND ANY SENSITIVE INFORMATION BELOW! ⚠️
| Context |
Version |
| Code for IBM i version |
2.14.7 |
| Visual Studio Code version |
1.96.4 |
| Operating System |
darwin_arm64 |
Active extensions
CL (vscode-clle): 1.1.7
COBOL (cobol): 25.1.25
Code Spell Checker (code-spell-checker): 4.0.34
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.8.0
Dev Containers (remote-containers): 0.394.0
ESLint (vscode-eslint): 3.0.10
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.23.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.260.0
GitHub Copilot Chat (copilot-chat): 0.23.2
GitHub Pull Requests (vscode-pull-request-github): 0.102.0
GitLab Workflow (gitlab-workflow): 5.36.0
GitLens — Git supercharged (gitlens): 16.2.1
IBM i Debug (ibmidebug): 2.0.2
IBM i Project Explorer (vscode-ibmi-projectexplorer): 2.12.0
JSON Language Features (json-language-features): 1.0.0
Live Share (vsliveshare): 1.0.5948
Markdown All in One (markdown-all-in-one): 3.6.2
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
RPGLE (vscode-rpgle): 0.28.6
Rainbow CSV (rainbow-csv): 3.15.1
Server Ready Action (debug-server-ready): 1.0.0
Simple Browser (simple-browser): 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.0
WSL (remote-wsl): 0.88.5
Remote system
| Setting |
Value |
| IBM i OS |
V7R4M0 |
| Tech Refresh |
10 |
| CCSID Origin |
1144 |
| Runtime CCSID |
280 |
| Default CCSID |
280 |
| SSHD CCSID |
? |
| cqsh |
true |
| SQL |
Enabled |
| Source dates |
Enabled |
Enabled features
| /QOpenSys/pkgs/bin |
/usr/bin |
/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 |
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=AL400MNUV2
CURLIB=AL400MNUV2
HOME=/home/
HOST=directa1.directa.lan
LANG=IT_IT.UTF-8
LS_COLORS=
MAIL=/var/spool/mail/
PATH=/QOpenSys/pkgs/bin:/QOpenSys/pkgs/lib/nodejs18/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PS1=\u@\h@\W$
QIBM_PASE_CCSID=1208
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSL_CERT_FILE=/home/cacert.pem
TZ=<CET>-1<CEST>,M3.5.0,M10.5.0
WORKDIR=/home/
_=/QOpenSys/pkgs/bin/env
Variants
{
"american": "#@$",
"local": "£§$"
} 
Hi,
Could you try this?
values 80000000000000000002;we have a table with a field defined numeric(20, 0) and the surprise is that the last digit is converted to zero...
Many thanks
Active extensions
Remote system
Enabled features
Shell env
Variants
{ "american": "#@$", "local": "£§$" }