Codespace - Create filter not possible

[Apsoftbe]

Hello, When trying to create filter get following error. CPF2207: Not authorized to use object ILEDITOR in library QSYS type *LIB. CPF3052: Description for file O_RFQAQ4I1 not available. With VS Code local no problem. Can it have something to do with Github & IBMi user being the same but different password. Thanks Peter

[sebjulliand]

I just had the same error with VSCode local, connected to PUB400.

Did you try to connect to PUB400 too? The issue could be an actual authority issue on ILEDITOR library on PUB400.

[Apsoftbe]

Tried this on PUB400. With VS Code local no problem to create filter. Thanks Peter

[sebjulliand]

So, local VSCode connected on PUB400 works for you? Could you share the output of both cases:

• Local VSCode connected to PUB400
• Codespace connected to PUB400

I have this in the output when connected to PUB400 and trying to expand or create a filter:

I still assume this is an authority issue on PUB400 anyway, but let's have a look 🙂

[Apsoftbe]

Result of created filter

[sebjulliand]

Thanks Peter. From you codespace, can you connect to PUB400, try to open a filter, then fo to the Code for IBM i output and paste its entire content here? Thanks!

Also, would you mind opening a 5250 session on PUB400 with the same profile you used in your codespace and run the following command: CHKOBJ OBJ(QSYS/ILEDITOR) OBJTYPE(*LIB) AUT(*USE)

[worksofliam]

I have been able to correct with a brand new user from both local and Codespace with no issue.

For reference, here is out output from the Codespace, which looks right to me:

.: pwd
{
    "code": 0,
    "signal": null,
    "stdout": "/home/BARRYA",
    "stderr": ""
}

/home/BARRYA: /QOpenSys/usr/bin/qsh
liblist
{
    "code": 0,
    "signal": null,
    "stdout": "PUB400SYS   SYS\nQSYS        SYS\nQSYS2       SYS\nQUSRSYS     SYS\nQHLPSYS     SYS\nQSHELL      PRD\nBARRYA1     CUR\nQGPL        USR\nQTEMP       USR\nGAMES400    USR",
    "stderr": ""
}

/home/BARRYA: system "CRTLIB LIB(ILEDITOR) TEXT('Code for i temporary objects. May be cleared.')"
{
    "code": 255,
    "signal": null,
    "stdout": "",
    "stderr": "CPD0032: Not authorized to command CRTLIB in library *LIBL.\nCPF0006: Errors occurred in command."
}

/home/BARRYA: system "CHKOBJ OBJ(QSYS/ILEDITOR) OBJTYPE(*LIB)"
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BARRYA: [ -d "/tmp" ]
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BARRYA: system "CHKOBJ OBJ(QSYS/QCPTOIMPF) OBJTYPE(*DTAARA)"
{
    "code": 255,
    "signal": null,
    "stdout": "",
    "stderr": "CPF9801: Object QCPTOIMPF in library QSYS not found."
}

/home/BARRYA: system "CHKOBJ OBJ(QSYS/QCPFRMIMPF) OBJTYPE(*DTAARA)"
{
    "code": 255,
    "signal": null,
    "stdout": "",
    "stderr": "CPF9801: Object QCPFRMIMPF in library QSYS not found."
}

/home/BARRYA: ls -p /QOpenSys/pkgs/bin/
{
    "code": 0,
    "signal": null,
    "stdout": "2to3\n2to3-3.6\n2to3-3.9\n5250keys\n7z\n7za\n7zr\nR\nRscript\n[\naccessdb\naclocal\naclocal-1.15\nacountry\nactivemq\nactivemq-admin\naddftinfo\naddgnupghome\naddr2line\nadig\nadjust-xcoff-header\nafmtodit\nahost\nalternatives\nambiguous_words\nanacron\nansible\nansible-config\nansible-connection\nansible-console\nansible-doc\nansible-galaxy\nansible-inventory\nansible-playbook\nansible-pull\nansible-test\nansible-vault\nant\nantRun\napplydeltaiso\napplydeltarpm\napplygnupgdefaults\napropos\naria_chk\naria_dump_log\naria_ftdump\naria_pack\naria_read_log\nasn1Coding\nasn1Decoding\nasn1Parser\natob\nautoconf\nautoexpect\nautoheader\nautom4te\nautomake\nautomake-1.15\nautopoint\nautoreconf\nautoscan\nautossh\nautoupdate\nawk\nbase32\nbase64\nbasename\nbash\nbashbug\nbison\nbrotli\nbsdcat\nbsdcpio\nbsdtar\nbsqldb\nbsqlodbc\nbtoa\nbunzip2\nbzcat\nbzcmp\nbzdiff\nbzegrep\nbzfgrep\nbzgrep\nbzip2\nbzip2recover\nbzless\nbzmore\nc++\nc++filt\nc2ph\nc_rehash\ncal\ncaptoinfo\ncat\ncatman\ncc\nccache\nccmake\ncertutil\nchcon\ncheckmk\nchem\nchgrp\nchmod\nchown\nchroot\nchroot_setup\nchsh\ncjpeg\ncksum\nclassifier_tester\nclear\nclusterdb\ncmake\ncmp\ncmsutil\ncntraining\ncol\ncolcrt\ncolrm\ncolumn\ncombine_lang_model\ncombine_tessdata\ncombinedeltarpm\ncomm\nconvertfilestopdf\nconvertfilestops\nconvertformat\nconvertsegfilestopdf\nconvertsegfilestops\nconverttopdf\nconverttops\ncorelist\ncp\ncpack\ncpan\ncpio\ncpp\ncpp-10\ncpp-6\ncpp-6.bin\ncreatedb\ncreaterepo\ncreateuser\ncrlutil\ncrond\ncronnext\ncrontab\ncrtfrmstmf\ncsplit\nctest\ncups-config\ncurl\ncurl-config\ncurve_keygen\ncut\ncwbcopwr\ncwbmedic\ncwbnltbl\ncwbping\ncwbtrc\ncwebp\ncxpm\ndatacopy\ndate\ndawg2wordlist\ndb2util\ndb_archive\ndb_checkpoint\ndb_deadlock\ndb_dump\ndb_hotbackup\ndb_load\ndb_printlog\ndb_recover\ndb_sql\ndb_stat\ndb_upgrade\ndb_verify\ndd\ndebuginfo-install\ndefncopy\nderb\nderdump\ndf\ndiff\ndiff3\ndir\ndircolors\ndirmngr\ndirmngr-client\ndirname\ndislocate\ndjpeg\ndltest\ndos2unix\ndropdb\ndropuser\ndrpmsync\ndu\ndumpsexp\ndvipdf\ndwebp\neasy_install-2.7\necho\necpg\negrep\nelfedit\nenc2xs\nencguess\nenv\nenvsubst\neps2eps\neqn\neqn2graph\nescapesrc\nevent_rpcgen.py\nex\nexpand\nexpect\nexpr\nf2py3.6\nf2py3.9\nf95\nfactor\nfalse\nfax2ps\nfax2tiff\nfc-cache\nfc-cat\nfc-conflist\nfc-list\nfc-match\nfc-pattern\nfc-query\nfc-scan\nfc-validate\nfgrep\nfile\nfileinfo\nfind\nfind-repos-of-install\nfisql\nfix-rpath\nflex\nflex++\nfmt\nfold\nfragiso\nfreebcp\nfunzip\ng++\ng++-10\ng++-6\ng++-6.bin\ngapplication\ngawk\ngcc\ngcc-10\ngcc-6\ngcc-6.bin\ngcc-ar\ngcc-ar-10\ngcc-ar-6\ngcc-ar-6.bin\ngcc-nm\ngcc-nm-10\ngcc-nm-6\ngcc-nm-6.bin\ngcc-ranlib\ngcc-ranlib-10\ngcc-ranlib-6\ngcc-ranlib-6.bin\ngcov\ngcov-10\ngcov-6\ngcov-dump-10\ngcov-tool-10\ngdb\ngdbm_dump\ngdbm_load\ngdbmtool\ngdbus\ngdbus-codegen\ngdiffmk\ngenbrk\ngenccode\ngencfu\ngencmn\ngencnval\ngendict\ngendiff\ngennorm2\ngenrb\ngensprep\ngetopt\ngettext\ngettext.sh\ngettextize\ngfortran\ngfortran-10\ngfortran-6\ngfortran-6.bin\ngif2rgb\ngifbuild\ngifclrmp\ngifecho\ngiffix\ngifinto\ngiftext\ngiftool\ngio\ngio-querymodules\ngit\ngit-cvsserver\ngit-receive-pack\ngit-shell\ngit-upload-archive\ngit-upload-pack\nglib-compile-resources\nglib-compile-schemas\nglib-genmarshal\nglib-gettextize\nglib-mkenums\nglilypond\ngmake\ngnu-ar\ngnu-as\ngnu-ld\ngnu-nm\ngnu-ranlib\ngnu-size\ngnu-strings\ngnu-strip\ngobject-query\ngperf\ngperl\ngpg\ngpg-agent\ngpg-connect-agent\ngpg-error\ngpg-error-config\ngpg-wks-server\ngpgconf\ngpgparsemail\ngpgrt-config\ngpgscm\ngpgsm\ngpgtar\ngpgv\ngpinyin\ngrap2graph\ngrep\ngresource\ngrn\ngrodvi\ngroff\ngroffer\ngrog\ngrolbp\ngrolj4\ngropdf\ngrops\ngrotty\ngroups\ngs\ngsbj\ngsdj\ngsdj500\ngsed\ngsettings\ngslj\ngslp\ngsnd\ngtester\ngtester-report\ngunzip\ngzexe\ngzip\nh2ph\nh2xs\nhardlink\nhb-ot-shape-closure\nhb-shape\nhb-subset\nhb-view\nhead\nhelp2man\nhexdump\nhmac256\nhostid\nhpftodit\niconv\nicu-config\nicuinfo\nicupkg\nid\nidle3\nidle3.6\nidle3.9\nidn2\nifnames\nigawk\nimagetops\nindxbib\ninfo\ninfocmp\ninfotocap\ninitdb\ninnochecksum\ninstall\ninstall-info\ninstmodsh\nipcmk\nisosize\nisql\niusql\njmacs\njoe\njoin\njpegtran\njpico\njq\njson_pp\njstar\nkbxutil\nkill\nksba-config\nlanguage-specific.sh\nld.bfd\nless\nlessecho\nlesskey\nlexgrog\nlftp\nlftpget\nlibassuan-config\nlibgcrypt-config\nlibnetcfg\nlibpng-config\nlibpng16-config\nlibtool\nlibtoolize\nlink\nlistsuites\nlkbib\nln\nlocate\nlogname\nlogrotate\nlook\nlookbib\nlp5250d\nlprsetup.sh\nls\nlstmeval\nlstmtraining\nlua\nluac\nlzcat\nlzcmp\nlzdiff\nlzegrep\nlzfgrep\nlzgrep\nlzip\nlzless\nlzma\nlzmadec\nlzmainfo\nlzmore\nm4\nmac2unix\nmake\nmakeconv\nmakedeltaiso\nmakedeltarpm\nmakei\nmakeinfo\nman\nman-recode\nmandb\nmanpath\nmc\nmcdiff\nmcedit\nmcookie\nmcview\nmd5sum\nmerge_unicharsets\nmergerepo\nmesg\nmftraining\nminisign\nmkdir\nmkfifo\nmknod\nmktemp\nmmroff\nmodifyrepo\nmodutil\nmpicalc\nmsgattrib\nmsgcat\nmsgcmp\nmsgcomm\nmsgconv\nmsgen\nmsgexec\nmsgfilter\nmsgfmt\nmsggrep\nmsginit\nmsgmerge\nmsgunfmt\nmsguniq\nmsql2mysql\nmv\nmvn\nmvnDebug\nmvnyjp\nmy_print_defaults\nmyisam_ftdump\nmyisamchk\nmyisamlog\nmyisampack\nmysql\nmysql_convert_table_format\nmysql_find_rows\nmysql_fix_extensions\nmysql_install_db\nmysql_plugin\nmysql_secure_installation\nmysql_setpermission\nmysql_tzinfo_to_sql\nmysql_upgrade\nmysql_waitpid\nmysqlaccess\nmysqladmin\nmysqlbinlog\nmysqlcheck\nmysqld\nmysqld_multi\nmysqld_safe\nmysqld_safe_helper\nmysqldump\nmysqldumpslow\nmysqlhotcopy\nmysqlimport\nmysqlshow\nmysqlslap\nmytop\nnamei\nnano\nncdu\nncurses6-config\nncursesw6-config\nneeds-restarting\nneqn\nngettext\nnginx\nnice\nninja\nnl\nnode\nnodever\nnohup\nnologin\nnpm\nnproc\nnpth-config\nnpx\nnroff\nnspr-config\nnss-config\nnss-policy-check\nnumfmt\nobjcopy\nobjdump\nocspclnt\nod\nodbc_config\nodbcinst\noid2name\nonig-config\nopenssl\nosql\np11-kit\npackage-cleanup\npal2rgb\npango-view\npaste\npatch\npathchk\npcre-config\npcre2-config\npcre2grep\npcre2test\npcregrep\npcretest\npdf2dsc\npdf2ps\npdfmom\npdfroff\npdftexi2dvi\nperl\nperl5.24.1\nperlbug\nperldoc\nperlivp\nperlthanks\nperror\npf2afm\npfbtopfa\npfbtops\npg_archivecleanup\npg_basebackup\npg_checksums\npg_config\npg_controldata\npg_ctl\npg_dump\npg_dumpall\npg_isready\npg_receivewal\npg_recvlogical\npg_resetwal\npg_restore\npg_standby\npg_test_fsync\npg_test_timing\npg_upgrade\npg_waldump\npgbench\npic\npic2graph\npiconv\npigz\npinentry\npinentry-curses\npinky\npip2\npip2.7\npip3\npip3.6\npip3.9\npk12util\npkg-config\npkgdata\npl2pm\npng-fix-itxt\npngfix\npod2html\npod2man\npod2texi\npod2text\npod2usage\npodchecker\npodselect\npost-grohtml\npostgres\npostmaster\npowerpc-ibm-os400-pkg-config\npp\npphs\nppm2tiff\npr\npre-grohtml\npreconv\nprintafm\nprintenv\nprintf\nprotoc\nprove\nps2ascii\nps2epsi\nps2pdf\nps2pdf12\nps2pdf13\nps2pdf14\nps2pdfwr\nps2ps\nps2ps2\npsql\npstruct\nptar\nptardiff\nptargrep\nptx\npv\npwd\npydoc\npydoc3\npydoc3.6\npydoc3.9\npython\npython2\npython2-config\npython2.7\npython2.7-config\npython3\npython3-config\npython3.6\npython3.6-config\npython3.6m\npython3.6m-config\npython3.9\npython3.9-config\npyvenv-3.6\nqconvex\nqdelaunay\nqhalf\nqhull\nqvoronoi\nraw2tiff\nrbox\nrdjpgcom\nreadelf\nreadlink\nrealpath\nrecode-sr-latin\nredis-benchmark\nredis-check-aof\nredis-check-rdb\nredis-cli\nredis-sentinel\nredis-server\nrefer\nreindexdb\nrename\nrenice\nreplace\nrepo-graph\nrepo-rss\nrepoclosure\nrepodiff\nrepomanage\nrepoquery\nreposync\nrepotrack\nreset\nresolve_stack_dump\nresolveip\nrev\nrftp\nrjoe\nrm\nrmdir\nrnano\nroff2dvi\nroff2html\nroff2pdf\nroff2ps\nroff2text\nroff2x\nrpm\nrpm2archive\nrpm2cpio\nrpmargs\nrpmbuild\nrpmdb\nrpmdev-bumpspec\nrpmdev-checksig\nrpmdev-cksum\nrpmdev-diff\nrpmdev-extract\nrpmdev-md5\nrpmdev-packager\nrpmdev-rmdevelrpms\nrpmdev-setuptree\nrpmdev-sha1\nrpmdev-sha224\nrpmdev-sha256\nrpmdev-sha384\nrpmdev-sha512\nrpmdev-sort\nrpmdev-sum\nrpmdev-vercmp\nrpmdev-wipetree\nrpmdumpheader\nrpmfile\nrpmgraph\nrpmkeys\nrpmls\nrpmpeek\nrpmquery\nrpmsign\nrpmspec\nrpmverify\nrsync\nrsync-ssl\nrun-parts\nrunant.py\nruncon\nruntest\nrview\nrvim\nsc\nsc_install_defaults\nscalar\nscedit\nscinit\nscopenports\nscp\nscs2ascii\nscs2pdf\nscs2ps\nsdiff\nsed\nselfserv\nseq\nset_unicharset_properties\nsetsid\nsftp\nsha1sum\nsha224sum\nsha256sum\nsha384sum\nsha512sum\nshapeclustering\nshasum\nshow-changed-rco\nshow-installed\nshowrgb\nshred\nshuf\nsigntool\nsignver\nsleep\nslencheck\nslsh\nsmtpd.py\nsoelim\nsort\nspectool\nsplain\nsplit\nsqlite3\nsqlite3_analyzer\nssh\nssh-add\nssh-agent\nssh-copy-id\nssh-keygen\nssh-keyscan\nsshd\nsshpass\nssltap\nstat\nstatic-to-shared\nstdbuf\nstrsclnt\nstty\nsum\nsvr4-shrlib\nsxpm\nsymkeyutil\nsync\ntabs\ntac\ntail\ntar\ntbl\ntclsh8.6\ntdspool\ntee\ntesseract\ntesstrain.sh\ntesstrain_utils.sh\ntest\ntexi2any\ntexi2dvi\ntexi2pdf\ntexindex\ntext2image\ntfmtodit\ntic\ntiff2bw\ntiff2pdf\ntiff2ps\ntiff2rgba\ntiffcmp\ntiffcp\ntiffcrop\ntiffdither\ntiffdump\ntiffinfo\ntiffmedian\ntiffset\ntiffsplit\ntimed-read\ntimed-run\ntimeout\ntjbench\ntmux\ntn5250\ntoe\ntouch\ntput\ntr\ntree\ntroff\ntrue\ntruncate\ntrust\ntset\ntsort\ntsql\ntstclnt\ntty\nuconv\nuname\nunbuffer\nuncompress\nunexpand\nunicharset_extractor\nuniq\nunix-lpr.sh\nunix2dos\nunix2mac\nunlink\nunlzma\nunpigz\nunxz\nunzip\nunzipsfx\nunzstd\nupdate-alternatives\nupdate-ca-certificates\nupdatedb\nuptime\nurlgrabber\nusers\nuuidgen\nuuidparse\nvacuumdb\nvacuumlo\nvdir\nverifytree\nvfychain\nvfyserv\nview\nvim\nvimdiff\nvimtutor\nwatchgnupg\nwc\nwget\nwhatis\nwheel\nwhereis\nwho\nwhoami\nwish8.6\nwordlist2dawg\nwrjpgcom\nxargs\nxgettext\nxml2-config\nxmlcatalog\nxmllint\nxmlservice-cli\nxmlwf\nxslt-config\nxsltproc\nxsubpp\nxt5250\nxtractprotos\nxxd\nxz\nxzcat\nxzcmp\nxzdec\nxzdiff\nxzegrep\nxzfgrep\nxzgrep\nxzless\nxzmore\nyacc\nyat2m\nyes\nyum\nyum-builddep\nyum-complete-transaction\nyum-config-manager\nyum-debug-dump\nyum-debug-restore\nyum-groups-manager\nyumdb\nyumdownloader\nzcat\nzcmp\nzdiff\nzegrep\nzfgrep\nzforce\nzgrep\nzip\nzipcloak\nzipcmp\nzipdetails\nzipgrep\nzipinfo\nzipmerge\nzipnote\nzipsplit\nziptool\nzless\nzmore\nznew\nzstd\nzstdcat\nzstdgrep\nzstdless\nzstdmt",
    "stderr": ""
}

/home/BARRYA: ls -p /usr/bin/
{
    "code": 0,
    "signal": null,
    "stdout": "Rfile\najar\nappletviewer\napt\narmsrv\narmsrvconv\nattr\nbasename\nbash\ncat\ncatsplf\nchgrp\nchmod\nchown\nclrtmp\ncmp\ncompress\ncp\ncut\ndataq\ndatarea\ndate\ndb2\ndb2profc\ndb2profc_trace\ndb2profp\nddns-confgen\ndelv\ndfmadmin\ndhcpd\ndhcrelay\ndig\ndirname\ndnssec-dsfromkey\ndnssec-importkey\ndnssec-keyfromlabel\ndnssec-keygen\ndnssec-revoke\ndnssec-settime\ndnssec-signzone\ndnssec-verify\ndspmsg\necho\negrep\nenv\nexpr\nextcheck\nfgrep\nfile\nfind\ngencat\ngetjobid\ngrep\nhead\nhost\nhostname\nhttpapi\nhwkeytool\niconv\nid\nidlj\nikeyman\nipcrm\nipcs\nixlc\njar\njarsigner\njava\njavac\njavadoc\njavah\njavap\njconsole\njdb\njdmpview\njextract\nkdestroy\nkeytab\nkeytool\nkinit\nklist\nkpasswd\nksetup\nldapadd\nldapchangepwd\nldapcompare\nldapdelete\nldapdiff\nldapexop\nldapmodify\nldapmodrdn\nldapsearch\nln\nlocale\nlogger\nlogname\nls\nmkdir\nmkfifo\nmv\nnamed\nnamed-checkconf\nnamed-checkzone\nnamed-compilezone\nnamed-journalprint\nnamed-rrchecker\nnative2ascii\nnohup\nnslookup\nnsupdate\nod\norbd\npack200\npax\npolicytool\npr\nprintenv\nprofconv\nprofdb\nprofp\nps\npwd\npwdx\nqsh\nrexec\nrexx\nrm\nrmdir\nrmic\nrmid\nrmiregistry\nrndc\nrndc-confgen\nschemagen\nsed\nserialver\nservertool\nsetccsid\nsh\nsort\nsplit\nsqlj\nstrEKM\nsystem\nsysval\ntail\ntar\ntee\ntest\ntnameserv\ntouch\ntr\ntsig-keygen\nuname\nuncompress\nuniq\nunpack200\nwc\nwsgen\nwsimport\nxargs\nxjc\nzcat",
    "stderr": ""
}

/home/BARRYA: ls -p /QSYS.LIB/QZDFMDB2.PGM
{
    "code": 0,
    "signal": null,
    "stdout": "/QSYS.LIB/QZDFMDB2.PGM",
    "stderr": ""
}

/home/BARRYA: ls -p /QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh
{
    "code": 0,
    "signal": null,
    "stdout": "/QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh",
    "stderr": ""
}

/home/BARRYA: ls -p /QSYS.lib/ILEDITOR.lib/GENCMDXML.PGM
{
    "code": 2,
    "signal": null,
    "stdout": "",
    "stderr": "/QSYS.lib/ILEDITOR.lib/GENCMDXML.PGM: No permission"
}

/home/BARRYA: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i')"
SELECT * FROM QSYS2.ASP_INFO
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nDEVICE_DESCRIPTION_NAME  ASP_NUMBER  ASP_STATE  ASP_TYPE  RDB_NAME           NUMBER_OF_DISK_UNITS  DISK_UNITS_PRESENT  ENCRYPTED_ASP  TOTAL_CAPACITY       TOTAL_CAPACITY_AVAILABLE  PROTECTED_CAPACITY   PROTECTED_CAPACITY_AVAILABLE  UNPROTECTED_CAPACITY  UNPROTECTED_CAPACITY_AVAILABLE  SYSTEM_STORAGE  OVERFLOW_STORAGE     STORAGE_THRESHOLD_PERCENTAGE  OVERFLOW_RECOVERY_RESULT  ERROR_LOG_SPACE  MACHINE_LOG_SPACE  MACHINE_TRACE_SPACE  MAIN_STORAGE_DUMP_SPACE  MICROCODE_SPACE  END_IMMEDIATE  COMPRESSION_RECOVERY_POLICY  COMPRESSED_DISK_UNITS  CHANGES_WRITTEN_TO_DISK  MULTIPLE_CONNECTION_DISK_UNITS  BALANCE_STATUS  BALANCE_TYPE          BALANCE_DATA_MOVED   BALANCE_DATA_REMAINING  BALANCE_TIMESTAMP   TRACE_STATUS  TRACE_DURATION  TRACE_TIMESTAMP     GEOGRAPHIC_MIRROR_ROLE  GEOGRAPHIC_MIRROR_MODE  GEOGRAPHIC_MIRROR_COPY_STATE  GEOGRAPHIC_MIRROR_DATA_STATE  GEOGRAPHIC_MIRROR_RESUME_PRIORITY  GEOGRAPHIC_MIRROR_SUSPEND_TIMEOUT  GEOGRAPHIC_MIRROR_TRANSMISSION_COMPRESSION  RESOURCE_NAME  PRIMARY_ASP_RESOURCE_NAME \n------------------------ ----------- ---------- --------- ------------------ --------------------- ------------------- -------------- -------------------- ------------------------- -------------------- ----------------------------- --------------------- ------------------------------- --------------- -------------------- ----------------------------- ------------------------- ---------------- ------------------ -------------------- ------------------------ ---------------- -------------- ---------------------------- ---------------------- ------------------------ ------------------------------- --------------- --------------------- -------------------- ----------------------- ------------------- ------------- --------------- ------------------- ----------------------- ----------------------- ----------------------------- ----------------------------- ---------------------------------- ---------------------------------- ------------------------------------------- -------------- --------------------------\n-                                  1 NONE       SYSTEM    PUB400                                13 ALL                 NO                          1302807                    381904                    0                             0               1302807                          381904              62                    0                            90 SUCCESS                                  3               1288                    1                     2156               55 YES            OVERFLOW DELAY               NONE                   YES                      NO                              COMPLETE        NONE                  -                    -                       -                   NONE          -               -                   -                       -                       -                             -                             -                                  -                                  -                                           -              -                         \n\n  1 RECORD(S) SELECTED.",
    "stderr": ""
}

/home/BARRYA: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i')"
select CHARACTER_CODE_SET_ID from table( QSYS2.QSYUSRINFO( USERNAME => upper('BARRYA') ) )
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nCHARACTER_CODE_SET_ID \n----------------------\n                    -2\n\n  1 RECORD(S) SELECTED.",
    "stderr": ""
}

/home/BARRYA: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i')"
select SYSTEM_VALUE_NAME, CURRENT_NUMERIC_VALUE from QSYS2.SYSTEM_VALUE_INFO where SYSTEM_VALUE_NAME = 'QCCSID'
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nSYSTEM_VALUE_NAME  CURRENT_NUMERIC_VALUE \n------------------ ----------------------\nQCCSID                                273\n\n  1 RECORD(S) SELECTED.",
    "stderr": ""
}

/home/BARRYA: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i')"
with VARIANTS ( HASH, AT, DOLLARSIGN ) as (  values ( cast( x'7B' as varchar(1) )         , cast( x'7C' as varchar(1) )         , cast( x'5B' as varchar(1) ) ))select HASH concat AT concat DOLLARSIGN as LOCAL  from VARIANTS; 
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nLOCAL \n------\n#§$   \n\n  1 RECORD(S) SELECTED.",
    "stderr": ""
}

/home/BARRYA: ls -p /QIBM/ProdData/IBMiDebugService/bin/certs/debug_service.pfx
{
    "code": 2,
    "signal": null,
    "stdout": "",
    "stderr": "/QIBM/ProdData/IBMiDebugService/bin/certs/debug_service.pfx not found"
}

[chrjorgensen]

I have the same issue with a local VS Code connection to PUB400:

[worksofliam]

Ok, me too.

Seems to be related to when SQL is disabled, though contradictory to that error:

/home/BARRYA: system "CHKOBJ OBJ(QSYS/BARRY1) OBJTYPE(*LIB)"
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

CHGOBJ does not complain 😓

[worksofliam]

There is code in the connection process which is supposed to set the temp library to the users current library if CHKOBJ fails, which obviously it is not.

[worksofliam]

@Apsoftbe Setting the temp library in the connection settings to a library you have access to will solve the problem.

[sebjulliand]

There is code in the connection process which is supposed to set the temp library to the users current library if CHKOBJ fails, which obviously it is not.

@worksofliam I think CHKOBJ as it is doesn't complain because the library exists. It doesn't check if we can use it. However, when checking the *USE authority, it fails as expected: CHKOBJ OBJ(QSYS/ILEDITOR) OBJTYPE(*LIB) AUT(*USE). So maybe we should add the AUT(*USE) in the command used in the connection process.

[Apsoftbe]

@worksofliam thanks for the info.

My local settings were indeed different from the one on Codespace. Sorry for not taking a better look.

Other error i get when trying to open source from QGPL, just to inform.

Great job Thanks Peter

[worksofliam]

@Apsoftbe this second issue is out of our control, but you can set a default file CCSID to get around that issue also in the connection settings.

Thanks!

[Apsoftbe]

@worksofliam Ok after setting CCSID it works. Again a lot of thanks for you and the other contributors for creating and giving this great tool.