'Select * from mylib.mytable limit 10' is not showing any data.
'Select mycol1,mycol2,mycol3,mycol4... blah blah(all columns) from mylib.mytable limit 10' is not showing any data.
'Select 1 as Number from mylib.mytable limit 1' shows 10 rows.
'Select mycolumn from mylib.mytable limit 10' is randomly showing data.
I noticed that same table in different libraries , once created via CRTPF and CCSID 280 is not shown , while same table create via CREATE TABLE in a different Library and CCSID 1144 is properly shown.
| Context |
Version |
| Code for IBM i version |
2.17.2 |
| Visual Studio Code version |
1.105.1 |
| Operating System |
darwin_arm64 |
Active extensions
Atlassian: Jira, Rovo Dev, Bitbucket (atlascode): 4.0.4
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.9
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.372.0
GitHub Copilot Chat (copilot-chat): 0.32.1
GitLens — Git supercharged (gitlens): 17.6.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
IntelliCode (vscodeintellicode): 1.3.2
JSON Language Features (json-language-features): 1.0.0
JavaScript Debugger (js-debug): 1.105.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 Language Features (markdown-language-features): 1.0.0
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.8.3
Python (python): 2025.16.0
Python Environments (vscode-python-envs): 1.10.0
Quarto (quarto): 1.126.0
RPGLE (vscode-rpgle): 0.33.2
Render Line Endings (render-crlf): 1.9.2
Server Ready Action (debug-server-ready): 1.0.0
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 |
9 |
| CCSID Origin |
1144 |
| Runtime CCSID |
1144 |
| Default CCSID |
1144 |
| SSHD CCSID |
? |
| cqsh |
true |
| SQL |
Enabled |
| Source dates |
Enabled |
Enabled features
| /QOpenSys/pkgs/bin |
/usr/bin |
/QSYS.lib/ILEDITOR.lib |
/QSYS.LIB |
/QIBM/ProdData/IBMiDebugService/bin |
/QOpenSys/QIBM/ProdData/JavaVM/jdk80 |
| bash |
attr |
GETNEWLIBL.PGM |
QZDFMDB2.PGM |
startDebugService.sh |
64bit |
| chsh |
iconv |
|
|
|
|
| find |
setccsid |
|
|
|
|
| git |
uname |
|
|
|
|
| grep |
|
|
|
|
|
| ls |
|
|
|
|
|
| md5sum |
|
|
|
|
|
| sort |
|
|
|
|
|
| stat |
|
|
|
|
|
| tar |
|
|
|
|
|
| tn5250 |
|
|
|
|
|
Shell env
BUILDLIB=XX
CURLIB=XX
HOME=/home/hm
HOST=xxx.xxx.xxx.xxx
LIBLS=mYLIBLIST
LOGIN=xx
LOGNAME=xx
MAIL=/var/spool/mail/xx
OLDPWD=/home/xx
PATH=/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PWD=/home/xx
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSH_CLIENT=xxx.xxx.xxx.xxx 22
SSH_CONNECTION=xxx.xxx.xxx.xxxxxx.xxx.xxx.xxx 22
TZ=<CET>-1<CEST>,M3.5.0,M10.5.0
USER=xx
USERNAME=xx
WORKDIR=/home/xx
_=/QOpenSys/pkgs/bin/env
Variants
{
"american": "#@$",
"local": "£§$",
"qsysNameRegex": {}
} 
