Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Source file defined CCSID 65535 does not show members in the filter #2360

Closed
begwhite opened this issue Nov 20, 2024 · 15 comments
Closed

Source file defined CCSID 65535 does not show members in the filter #2360

begwhite opened this issue Nov 20, 2024 · 15 comments
Labels
discussion For questions, or when something isn't working as expected

Comments

@begwhite
Copy link

Type: Bug

Some source files defined with CCSID 65535 do not show members in the filter. Other source files also defined with CCSID 65535 do show their members as we are using the server Settings Source Code Source file CCSID override set to 37, but some source files in various libraries continue not to show members.

Extension version: 2.13.6
VS Code version: Code 1.95.3 (f1a4fb101478ce6ec82fe9627c43efbf9e98c813, 2024-11-13T14:50:04.152Z)
OS version: Windows_NT x64 10.0.22631
Modes:

System Info
Item Value
CPUs 12th Gen Intel(R) Core(TM) i7-1265U (12 x 2688)
GPU Status 2d_canvas: enabled
canvas_oop_rasterization: enabled_on
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
skia_graphite: disabled_off
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled
webnn: disabled_off
Load (avg) undefined
Memory (System) 31.69GB (15.95GB free)
Process Argv --crash-reporter-id 7563cf75-277c-468d-b1a1-280e8b7281c6
Screen Reader no
VM 0%
A/B Experiments
vsliv368cf:30146710
vspor879:30202332
vspor708:30202333
vspor363:30204092
vscod805cf:30301675
binariesv615:30325510
vsaa593cf:30376535
py29gd2263:31024239
c4g48928:30535728
azure-dev_surveyone:30548225
a9j8j154:30646983
962ge761:30959799
pythonnoceb:30805159
asynctok:30898717
pythonmypyd1:30879173
2e7ec940:31000449
pythontbext0:30879054
cppperfnew:31000557
dsvsc020:30976470
pythonait:31006305
dsvsc021:30996838
bdiig495:31013172
dvdeprecation:31068756
dwnewjupytercf:31046870
nativerepl2:31139839
pythonrstrctxt:31112756
nativeloc1:31134641
cf971741:31144450
iacca1:31171482
notype1cf:31157160
5fd0e150:31155592
dwcopilot:31170013
stablechunks:31184530

@worksofliam
Copy link
Contributor

Please share the contents of your Code for IBM i output channel after the list doesn't appear.

image

@begwhite
Copy link
Author

Output has nothing in it.

image

@worksofliam
Copy link
Contributor

@begwhite

Notice you're on the Service Entry Point menu option. Switch it over to Code for IBM i

@begwhite
Copy link
Author

begwhite commented Nov 20, 2024

Click me
/home/BWHITE1: /QOpenSys/usr/bin/qsh
system  "CHKOBJ OBJ(V841WLXO/QRPGLESRC) OBJTYPE(*FILE) AUT(*UPD)"
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": "CPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
with MEMBERS as (
        select
          rtrim(cast(a.SYSTEM_TABLE_SCHEMA as char(10) for bit data)) as LIBRARY,
          b.AVGROWSIZE as RECORD_LENGTH,
          a.IASP_NUMBER as ASP,
          rtrim(cast(a.SYSTEM_TABLE_NAME as char(10) for bit data)) AS SOURCE_FILE,
          rtrim(cast(b.SYSTEM_TABLE_MEMBER as char(10) for bit data)) as NAME,
          coalesce(rtrim(cast(b.SOURCE_TYPE as varchar(10) for bit data)), '') as TYPE,
          coalesce(rtrim(varchar(b.PARTITION_TEXT)), '') as TEXT,
          b.NUMBER_ROWS as LINES,
          extract(epoch from (b.CREATE_TIMESTAMP))*1000 as CREATED,
          extract(epoch from (b.LAST_SOURCE_UPDATE_TIMESTAMP))*1000 as CHANGED
        from QSYS2.SYSTABLES as a
          join QSYS2.SYSPARTITIONSTAT as b
            on ( b.SYSTEM_TABLE_SCHEMA, b.SYSTEM_TABLE_NAME ) = ( a.SYSTEM_TABLE_SCHEMA, a.SYSTEM_TABLE_NAME )
      )
      select * from MEMBERS
      where LIBRARY = 'V841WLXO'
        and SOURCE_FILE = 'QRPGLESRC'
        and NAME like '%'
        and TYPE like '%'
      order by NAME ASC
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n  ?>\n\nLIBRARY    RECORD_LENGTH        ASP    SOURCE_FILE  NAME       TYPE       TEXT                                               LINES                CREATED              CHANGED             \n---------- -------------------- ------ ------------ ---------- ---------- -------------------------------------------------- -------------------- -------------------- --------------------\nV841WLXO                    112      0 QRPGLESRC    ACP310D1   SQLRPGLE   ACP310D1-Payables Inquiry Program                                 16939        1675920837000        1676275120000\nV841WLXO                    112      0 QRPGLESRC    ACP500D1BW SQLRPGLE   ACP500D1-Invoice Entry List Panel                                  9100        1658839371000        1722569223000\nV841WLXO                    112      0 QRPGLESRC    ACP500D1B2 SQLRPGLE   ACP500D1-Invoice Entry List Panel                                  9100        1658840345000        1610462689000\nV841WLXO                    112      0 QRPGLESRC    ACP500D1B3 SQLRPGLE   ACP500D1-Invoice Entry List Panel                                  9100        1658840369000        1638449172000\nV841WLXO                    112      0 QRPGLESRC    ACP500D2BW SQLRPGLE   ACP500D2-ACP500 Header Validation Panel                           29017        1658839372000        1627969214000\nV841WLXO                    112      0 QRPGLESRC    ACP500D2B2 SQLRPGLE   ACP500D2-ACP500 Header Validation Panel                           29017        1658840345000        1638449186000\nV841WLXO                    112      0 QRPGLESRC    ACP500D2C  SQLRPGLE   ACP500D2-ACP500 Header Validation Panel                           29017        1644828137000        1627969214000\nV841WLXO                    112      0 QRPGLESRC    ACP500D2DM SQLRPGLE   ACP500D2-ACP500 Header Validation Panel-Daniel src                28627        1670192968000        1670215069000\nV841WLXO                    112      0 QRPGLESRC    ACP500D3   SQLRPGLE   ACP500D3-Purchase Order Matching                                  17394        1678253123000        1649818507000\nV841WLXO                    112      0 QRPGLESRC    ACP500D3BW SQLRPGLE   ACP500D3-Purchase Order Matching                                  17374        1658839372000        1596117346000\nV841WLXO                    112      0 QRPGLESRC    ACP500D3B2 SQLRPGLE   ACP500D3-Purchase Order Matching                                  17374        1658840345000        1638449207000\nV841WLXO                    112      0 QRPGLESRC    ACP500D3JP SQLRPGLE   ACP500D3-Purchase Order Matching                                  16104        1634727765000        1634727776000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4BW SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     26646        1658839372000        1634215278000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4B2 SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     26646        1658840345000        1638449222000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4CH SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     25648        1634883920000        1635241876000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4DM SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     25689        1721995557000        1722031132000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4R  SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     25578        1631757272000        1631756763000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4RV SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     25705        1639703951000        1640579987000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4S  SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     26646        1644993498000        1634215278000\nV841WLXO                    112      0 QRPGLESRC    ACP500D41  SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     25708        1634802962000        1634809736000\nV841WLXO                    112      0 QRPGLESRC    ACP500D6BK SQLRPGLE   ACP500D6-Invoice Matching - GRN                                   21331        1632999096000        1633005509000\nV841WLXO                    112      0 QRPGLESRC    ACP500D6BL SQLRPGLE   ACP500D6-Invoice Matching - GRN 30th Nov 22                       20196        1669772638000        1669772389000\nV841WLXO                    112      0 QRPGLESRC    ACP502D_OR SQLRPGLE   ACP502D-One Time Vendor Code Maint.                                4226        1663729336000        1663728625000\nV841WLXO                    112      0 QRPGLESRC    ACP504B.1  SQLRPGLE   ACP504B-ACP504B-Invoice Entry - Actual                            23856        1634880634000        1566459266000\nV841WLXO                    112      0 QRPGLESRC    ACP700D2MY SQLRPGLE   ACP700D2-Manual payments new                                       4923        1622609877000        1622609882000\nV841WLXO                    112      0 QRPGLESRC    ACR300DG   SQLRPGLE   ACR300DG-Customer Aging Inquiry                                    7356        1681741147000        1681741166000\nV841WLXO                    112      0 QRPGLESRC    ACR300DGB1 SQLRPGLE   ACR300DG-Customer Aging Inquiry via OPEN                           7354        1681732976000        1681732979000\nV841WLXO                    112      0 QRPGLESRC    ACR300DGB2 SQLRPGLE   ACR300DG-Customer Aging Inquiry via Cpy src & N2                   7354        1681733090000        1681740586000\nV841WLXO                    112      0 QRPGLESRC    ACR300DGB3 SQLRPGLE   ACR300DG-Customer Aging Inquiry                                    7354        1681740803000        1681740870000\nV841WLXO                    112      0 QRPGLESRC    ACR500B2DM SQLRPGLE   ACR500B2-File Posting and ATP Link                                 6516        1724653011000        1726119068000\nV841WLXO                    112      0 QRPGLESRC    ADDZX3R    SQLRPGLE   TEST                                                                 22        1597420505000        1603724162000\nV841WLXO                    112      0 QRPGLESRC    ADDZX4R    SQLRPGLE   TEST                                                                 21        1603723522000        1597407222000\nV841WLXO                    112      0 QRPGLESRC    ADDZX5R    SQLRPGLE   TEST                                                                 21        1597420506000        1597407209000\nV841WLXO                    112      0 QRPGLESRC    ADDZX6R    SQLRPGLE   TEST                                                                 21        1597420506000        1597407300000\nV841WLXO                    112      0 QRPGLESRC    API500D1   SQLRPGLE   API500D1-Campaign Planning                                         7310        1625775077000        1658392075000\nV841WLXO                    112      0 QRPGLESRC    API500D2   SQLRPGLE   API500D2-Campaign Planning                                        31413        1646132338000        1658392076000\nV841WLXO                    112      0 QRPGLESRC    API820D    SQLRPGLE   API820D-Advanced Process Industries Pa                             4561        1658227378000        1658392076000\nV841WLXO                    112      0 QRPGLESRC    APX645     SQLRPGLE   AB Mauri Incident 16286363                                          101        1650541279000        1658392077000\nV841WLXO                    112      0 QRPGLESRC    APX645B    SQLRPGLE   AB Mauri Incident 16286363                                          101        1657029689000        1658392077000\nV841WLXO                    112      0 QRPGLESRC    APX645BW   SQLRPGLE   AB Mauri Incident 16286363                                          105        1650984468000        1658392077000\nV841WLXO                    112      0 QRPGLESRC    APX645B2   SQLRPGLE   AB Mauri Incident 16286363                                          110        1647873795000        1658392077000\nV841WLXO                    112      0 QRPGLESRC    ARP615BC   SQLRPGLE   ARP615B-Apply Checks to Customer Accts                             6887        1702250301000        1702004831000\nV841WLXO                    112      0 QRPGLESRC    AVP700B    SQLRPGLE   AVP Output Driver Program                                           303        1604929000000        1450399182000\nV841WLXO                    112      0 QRPGLESRC    AVP732B_BK SQLRPGLE   Update Reschedule Dates                                            1501        1612940082000        1613536795000\nV841WLXO                    112      0 QRPGLESRC    BIL501B    SQLRPGLE   BIL501B-Invoice Batch Processing                                   3872        1706567934000        1706567936000\nV841WLXO                    112      0 QRPGLESRC    BIL501D2BK SQLRPGLE   BIL501D2-Customer Document Header Panel                           13271        1602474409000        1602474315000\nV841WLXO                    112      0 QRPGLESRC    BIL501D2B1 SQLRPGLE   BIL501D2-Customer Document Header Panel                           13271        1602214043000        1602148428000\nV841WLXO                    112      0 QRPGLESRC    BIL501D2MA SQLRPGLE   BIL501D2-Customer Document Header Panel                           13567        1602148633000        1602473820000\nV841WLXO                    112      0 QRPGLESRC    BIL501D2NO SQLRPGLE   BIL501D2-Customer Document Header Panel                           13383        1602148421000        1602162352000\nV841WLXO                    112      0 QRPGLESRC    BIL540B_   SQLRPGLE   BIL540B-Invoice Billing Master Update                             19413        1605666757000        1605666663000\nV841WLXO                    112      0 QRPGLESRC    BIL540BBK  SQLRPGLE   BIL540B-Invoice Billing Master Update                             19443        1706136500000        1706519835000\nV841WLXO                    112      0 QRPGLESRC    BIL561BBW  RPGLE      BIL561B-Invoice Reprint Processor                                   607        1640000257000        1640008591000\nV841WLXO                    112      0 QRPGLESRC    BIL605B_   SQLRPGLE   BIL605B-Build Billing Files From ECS                               4926        1625115156000        1625115129000\nV841WLXO                    112      0 QRPGLESRC    BIL606B_   SQLRPGLE   Create/Update Billings Headers                                     3007        1625115164000        1625115133000\nV841WLXO                    112      0 QRPGLESRC    BIL607B_   SQLRPGLE   BIL607B-Select Pick Confirm from Wrkfl                              753        1625634903000        1625634709000\nV841WLXO                    112      0 QRPGLESRC    BIL690BM   SQLRPGLE   BIL690B-Total Order Discount Proration                             1232        1645418044000        1645418045000\nV841WLXO                    112      0 QRPGLESRC    CAP300D    SQLRPGLE   CAP300D-Capacity Requirements Inquiry                             16716        1656081243000        1529510790000\nV841WLXO                    112      0 QRPGLESRC    CEA310D1BW SQLRPGLE   CEA310D1-Journal Inquiry                                          25129        1658839372000        1626272351000\nV841WLXO                    112      0 QRPGLESRC    CEA500B    SQLRPGLE   CEA500B-Engine Control & Event Deter.                              2557        1618443571000        1618918021000\nV841WLXO                    112      0 QRPGLESRC    CEA502B1   SQLRPGLE   CEA502B1-ACP Engine Resolution Pgm                                30655        1687392149000        1687399215000\nV841WLXO                    112      0 QRPGLESRC    CEA502B1MC SQLRPGLE   CEA502B1-ACP Engine Resolution Pgm                                30587        1620300494000        1620300601000\nV841WLXO                    112      0 QRPGLESRC    CEA502B1SP SQLRPGLE   CEA502B1-ACP Engine Resolution Pgm                                30591        1620300475000        1619402718000\nV841WLXO                    112      0 QRPGLESRC    CEA502B1VV SQLRPGLE   CEA502B1-ACP Engine Resolution Pgm                                30583        1620300535000        1620300511000\nV841WLXO                    112      0 QRPGLESRC    CEA502B2SS SQLRPGLE   CEA502B2-ACR Engine Resolution Pgm                                34446        1627050755000        1627049072000\nV841WLXO                    112      0 QRPGLESRC    CEA502B3_  SQLRPGLE   CEA502B3-DST Engine Resolution Pgm                                30802        1608640950000        1608633062000\nV841WLXO                    112      0 QRPGLESRC    CEA502B3__ SQLRPGLE   CEA502B3-DST Engine Resolution Pgm                                30903        1611028245000        1611028212000\nV841WLXO                    112      0 QRPGLESRC    CEA502B329 SQLRPGLE   CEA502B3-DST Engine Resolution Pgm                                30900        1609214049000        1608641581000\nV841WLXO                    112      0 QRPGLESRC    CLD107D1BW SQLRPGLE   CLD107D1-Currency Code Maint. Panel 1                              4705        1658839372000        1618223477000\nV841WLXO                    112      0 QRPGLESRC    CPR004B    RPGLE      CPR004B-TDR API                                                    1970        1635131320000        1502366809000\nV841WLXO                    112      0 QRPGLESRC    CRAP       RPGLE                                                                            1        1729767109000        1729767152000\nV841WLXO                    112      0 QRPGLESRC    CST200D    RPGLE      CST200D-Item Cost Prompt Screen                                    2984        1625775111000        1626273145000\nV841WLXO                    112      0 QRPGLESRC    CST270B_   SQLRPGLE   CST270B-Cost Variance/WIP Analysis                                17801        1644494393000        1644483954000\nV841WLXO                    112      0 QRPGLESRC    CST560BBK  SQLRPGLE   CST560B-Cost change                                                3802        1602299204000        1602716603000\nV841WLXO                    112      0 QRPGLESRC    CST910B_   SQLRPGLE   CST910B-Labor Ticket - ATP                                         3828        1608639841000        1608633050000\nV841WLXO                    112      0 QRPGLESRC    CST920B_V1 SQLRPGLE   CST920B-Cost Transfers                                             1650        1654861518000        1656037365000\nV841WLXO                    112      0 QRPGLESRC    CST940B_V1 SQLRPGLE   CST940B-Inter Facility Cost Transfer - Bkuplatest                  4259        1655374906000        1655373673000\nV841WLXO                    112      0 QRPGLESRC    CST940B_V2 SQLRPGLE   CST940B-Inter Facility Cost Transfer                               4235        1655301721000        1656041585000\nV841WLXO                    112      0 QRPGLESRC    CVTCICDFTR SQLRPGLE   Set default values for CIC                                          870        1592826185000        1595562490000\nV841WLXO                    112      0 QRPGLESRC    DRP550DC   SQLRPGLE   DRP550D-Resupply Order Receipts                                   27150        1728352661000        1728351936000\nV841WLXO                    112      0 QRPGLESRC    ECM526B    SQLRPGLE   ECM526B-Outbound Pick List RSA                                     1412        1606220455000        1452646286000\nV841WLXO                    112      0 QRPGLESRC    ECM605B7   SQLRPGLE   ECM605B7-Inbound Order Post                                       10507        1676524372000        1676524779000\nV841WLXO                    112      0 QRPGLESRC    ECM605B7_C SQLRPGLE   ECM605B7-Inbound Order Post                                       10492        1676522168000        1676522081000\nV841WLXO                    112      0 QRPGLESRC    ECM605D1   SQLRPGLE   ECM605D1-Order Header Maintenance                                 18901        1673509388000        1527893267000\nV841WLXO                    112      0 QRPGLESRC    EXTPRCPH   RPGLE      EXTRTNP1-Stub program for APPVEND exit retun parm                  1407        1679523229000        1670310208000\nV841WLXO                    112      0 QRPGLESRC    EXTPRCPL   RPGLE      EXTRTNP1-Stub program for APPVEND exit retun parm                  1406        1679523229000        1670310214000\nV841WLXO                    112      0 QRPGLESRC    EXTPRCRTAX RPGLE      Exit point trigger program                                         1127        1722841835000        1729565226000\nV841WLXO                    112      0 QRPGLESRC    FIE        SQLRPGLE   Integrate LX security into IDF AutoContent Securit                 1230        1589294228000        1589294228000\nV841WLXO                    112      0 QRPGLESRC    GHH01V_    SQLRPGLE   GHH01V-Journal History Validation Ser                             24288        1608633103000        1608633046000\nV841WLXO                    112      0 QRPGLESRC    ILM503D1_C SQLRPGLE   ILM503D1-Inbound Delivery Lines Select.                           10413        1662348314000        1662107258000\nV841WLXO                    112      0 QRPGLESRC    ILM503D2_C SQLRPGLE   ILM503D2-Inbound Delivery Line Detail                              4809        1662348320000        1662109285000\nV841WLXO                    112      0 QRPGLESRC    ILM600BBK  SQLRPGLE   ILM600B-Post Item IBD Costs                                        5887        1602583177000        1602233700000\nV841WLXO                    112      0 QRPGLESRC    ILM600BBK1 SQLRPGLE   ILM600B-Post Item IBD Costs                                        5914        1602142131000        1602651289000\nV841WLXO                    112      0 QRPGLESRC    INV300DC   SQLRPGLE   INV300D-Material Status Inquiry                                   31191        1700184449000        1700125025000\nV841WLXO                    112      0 QRPGLESRC    INV500B1_  SQLRPGLE   INV500B1-Inventory Transaction Posting                            42023        1646132323000        1646104797000\nV841WLXO                    112      0 QRPGLESRC    INV500B1C  SQLRPGLE   INV500B1-Inventory Transaction Posting                            42053        1704360220000        1704340598000\nV841WLXO                    112      0 QRPGLESRC    INV500B1N  SQLRPGLE   INV500B1-Inventory Transaction Posting                            42117        1730796626000        1730790577000\nV841WLXO                    112      0 QRPGLESRC    INV500D22  SQLRPGLE   INV500D2-Inventory Transaction Posting                            36237        1680770245000        1592481285000\nV841WLXO                    112      0 QRPGLESRC    INV510D_   SQLRPGLE   INV510D-Location Transfers Posting                                21581        1646122209000        1646104805000\nV841WLXO                    112      0 QRPGLESRC    INV510DVC  SQLRPGLE   INV510D-Location Transfers Posting                                21591        1719400015000        1719400019000\nV841WLXO                    112      0 QRPGLESRC    INV510DV1  SQLRPGLE   INV510D-Location Transfers Posting                                21591        1719400187000        1719400019000\nV841WLXO                    112      0 QRPGLESRC    INV511B_   SQLRPGLE   Shipment Components to Vendor - Allocation/Split                   4606        1646122512000        1646104879000\nV841WLXO                    112      0 QRPGLESRC    INV511D_   SQLRPGLE   INV511D-Location Transfers Posting                                27306        1646123334000        1646104887000\nV841WLXO                    112      0 QRPGLESRC    INV530B.1  SQLRPGLE   INV530B-Daily Cycle Count Wrksht(Item)                             6280        1663641179000        1649654404000\nV841WLXO                    112      0 QRPGLESRC    INV530BBK  SQLRPGLE   INV530B-Daily Cycle Count Wrksht(Item)                             6245        1611903254000        1611903134000\nV841WLXO                    112      0 QRPGLESRC    INV531BBK  SQLRPGLE   INV531B-Create Cycle Count Wrksht(Whs)                             5435        1663641179000        1649651703000\nV841WLXO                    112      0 QRPGLESRC    INV532B.1  SQLRPGLE   INV532B-Create Cycle Count Wrksht(Loc)                             5404        1663641179000        1649651768000\nV841WLXO                    112      0 QRPGLESRC    INV650B_   SQLRPGLE   INV650B-Physical Inventory Close - I                               9706        1646123555000        1646104896000\nV841WLXO                    112      0 QRPGLESRC    INV650BBK  SQLRPGLE   INV650B-Physical Inventory Close - I                               9708        1621566456000        1621577265000\nV841WLXO                    112      0 QRPGLESRC    IPB        SQLRPGLE   Edit buffer                                                       19379        1595417312000        1595417332000\nV841WLXO                    112      0 QRPGLESRC    ITMS600    SQLRPGLE   AB Mauri Incident 16286363                                          310        1650620828000        1650625291000\nV841WLXO                    112      0 QRPGLESRC    JIT560B_   SQLRPGLE   JIT560B-JIT Planned Shop Order Release                             9299        1646109131000        1646104513000\nV841WLXO                    112      0 QRPGLESRC    JIT600D5_  SQLRPGLE   JIT600D5-Production Reporting-Backflush                           14398        1646123816000        1646105079000\nV841WLXO                    112      0 QRPGLESRC    LMP500D2   SQLRPGLE   LMP500D2-Cell WorkBench Maintenance 27x132                        12118        1657807489000        1608867071000\nV841WLXO                    112      0 QRPGLESRC    LMP500D2_  QLRPGLE    LMP500D2-Cell WorkBench Maintenance 27x132                        11102        1607080742000        1607080709000\nV841WLXO                    112      0 QRPGLESRC    LTMS600    SQLRPGLE   AB Mauri Incident 16286363                                          242        1648475053000        1648475786000\nV841WLXO                    112      0 QRPGLESRC    MRP140D1_C SQLRPGLE   MRP140D1-Facility Planning List Panel                              4822        1674631663000        1675308352000\nV841WLXO                    112      0 QRPGLESRC    MRP200B    SQLRPGLE   MRP200B-MRP Exception Report                                      30620        1664260171000        1665021612000\nV841WLXO                    112      0 QRPGLESRC    MRP500BB   SQLRPGLE   First Cut Master Scheduling                                       17669        1715069866000        1721986333000\nV841WLXO                    112      0 QRPGLESRC    MRP500BK   SQLRPGLE   First Cut Master Scheduling                                       17636        1613120153000        1613119903000\nV841WLXO                    112      0 QRPGLESRC    MRP500C    SQLRPGLE   First Cut Master Scheduling                                       17652        1713234418000        1713233569000\nV841WLXO                    112      0 QRPGLESRC    MRP500HAR  SQLRPGLE   First Cut Master Scheduling                                       17587        1602248761000        1602248540000\nV841WLXO                    112      0 QRPGLESRC    MRP640_    SQLRPGLE   Finite Forward Scheduling                                         12290        1646110879000        1646104773000\nV841WLXO                    112      0 QRPGLESRC    MRP643B_   SQLRPGLE   MRP643B-Create FMA Records for Orders                              6994        1646125569000        1646105085000\nV841WLXO                    112      0 QRPGLESRC    MRP647_    SQLRPGLE   Routing Selection for Finite Forward Scheduling.                   2435        1646110581000        1646104629000\nV841WLXO                    112      0 QRPGLESRC    MRP785IMC  SQLRPGLE   MRP785I- ATP/CTP Date Web Services                                  978        1653620574000        1653640726000\nV841WLXO                    112      0 QRPGLESRC    MRP785IMC2 SQLRPGLE   MRP785I- ATP/CTP Date Web Services                                  950        1654691690000        1654740416000\nV841WLXO                    112      0 QRPGLESRC    OLM140DBW  SQLRPGLE   OLM140D-Ship To Maint Data Panel-Ship                              4962        1658839372000        1596117604000\nV841WLXO                    112      0 QRPGLESRC    OLM592B1   SQLRPGLE   OLM592B1-Non-Haz BOL Rpt by Tariff Cls                             8021        1657603460000        1644480578000\nV841WLXO                    112      0 QRPGLESRC    OLM596BH   SQLRPGLE   OLM596B-Delivery Note Print                                        8400        1693014772000        1693013358000\nV841WLXO                    112      0 QRPGLESRC    OLM596BR   SQLRPGLE   OLM596B-Delivery Note Print                                        8400        1693012061000        1693010037000\nV841WLXO                    112      0 QRPGLESRC    ORD090B    SQLRPGLE   ESX Language Override Server                                        162        1663070824000        1452646664000\nV841WLXO                    112      0 QRPGLESRC    ORD100D2BW SQLRPGLE   ORD100D2-Customer Address Maintenance                             11980        1658839372000        1628847778000\nV841WLXO                    112      0 QRPGLESRC    ORD300D1BM SQLRPGLE   ORD300D1-Order Select by Order Panel                              11253        1657159860000        1656990004000\nV841WLXO                    112      0 QRPGLESRC    ORD300D1B1 SQLRPGLE   ORD300D1-Order Select by Order Panel                              11013        1645490753000        1645490756000\nV841WLXO                    112      0 QRPGLESRC    ORD300D1B2 SQLRPGLE   ORD300D1-Order Select by Order Panel                              11948        1657797718000        1657251050000\nV841WLXO                    112      0 QRPGLESRC    ORD302D    SQLRPGLE   ORD302D-Order Shipment Info                                        4437        1666362875000        1666362876000\nV841WLXO                    112      0 QRPGLESRC    ORD550B6GS SQLRPGLE   ORD550B6-Over/Short Orders Promotion Audit                         1339        1681893926000        1681893904000\nV841WLXO                    112      0 QRPGLESRC    ORD553BK   SQLRPGLE   'ORD553B-Pick Release Sel-kit                                      4251        1614068954000        1614049924000\nV841WLXO                    112      0 QRPGLESRC    ORD559BGS  SQLRPGLE   ORD559B-Pick Release Updates                                       6757        1681204995000        1681204672000\nV841WLXO                    112      0 QRPGLESRC    ORD577B_   SQLRPGLE   ORD577B-Inventory Updates                                         20007        1605169082000        1605157491000\nV841WLXO                    112      0 QRPGLESRC    ORD577BRS  SQLRPGLE   ORD577B-Inventory Updates                                         20040        1621566488000        1621858609000\nV841WLXO                    112      0 QRPGLESRC    ORD680B    SQLRPGLE   ORD680B-Order Hold Batch Release Process                           2571        1666944836000        1587105318000\nV841WLXO                    112      0 QRPGLESRC    ORD680D    SQLRPGLE   ORD680D-Order Hold Batch Release Promp                             1921        1666944886000        1527897151000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA.1 SQLRPGLE   Fast Line Entry Maintenance-BMR 58702                             25877        1612857298000        1614048351000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA.2 SQLRPGLE   Fast Line Entry Maintenance                                       25714        1647471323000        1648099019000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA.3 SQLRPGLE   Fast Line Entry Maintenance                                       25597        1650428764000        1650428980000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA.4 SQLRPGLE   Fast Line Entry Maintenance                                       25597        1650429446000        1650430180000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA_E SQLRPGLE   Fast Line Entry Maintenance                                       25891        1672792372000        1670907677000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA_R SQLRPGLE   Fast Line Entry Maintenance                                       25890        1673230212000        1673229649000\nV841WLXO                    112      0 QRPGLESRC    ORD700D1BW SQLRPGLE   ORD700D1-Order Entry main Panel                                   25965        1658839372000        1656598700000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2.1 SQLRPGLE   ORD700D2-Order Entry Maintenance-BMR 58702                        32681        1612971427000        1645693319000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2.2 SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32515        1647479992000        1648099041000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2_  SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32795        1676862259000        1676543927000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2_E SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32795        1672792372000        1673228367000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2_R SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32795        1673230212000        1673228848000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2A  SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32530        1612948329000        1612969818000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2BW SQLRPGLE   ORD700D2-Order Entry Maintenance                                  34236        1658839372000        1649745318000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2DM SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32469        1658289028000        1658956782000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2EE SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32796        1673228286000        1670907131000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2GS SQLRPGLE   ORD700D2-Order Entry Maintenance-BMR 58702                        32681        1670284216000        1645693319000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2MC SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32464        1649223277000        1649323617000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2MK SQLRPGLE   ORD700D2-Order Entry Maintenance                                  34251        1654139645000        1654232768000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2M1 SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32437        1653120155000        1653240101000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2M2 SQLRPGLE                                                                     32434        1653241099000        1653241096000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2SS SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32470        1658733203000        1658731303000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2VV SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32953        1681104967000        1680777858000\nV841WLXO                    112      0 QRPGLESRC    ORD700D21  SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32383        1612934560000        1612934569000\nV841WLXO                    112      0 QRPGLESRC    ORD700D3.D SQLRPGLE   ORD700D3-Order Line Detail                                        32905        1721291728000        1722406491000\nV841WLXO                    112      0 QRPGLESRC    ORD700D3_  SQLRPGLE   ORD700D3-Order Line Detail                                        32847        1651726515000        1651726500000\nV841WLXO                    112      0 QRPGLESRC    ORD700D3M  SQLRPGLE   ORD700D3-Order Line Detail                                        34740        1655451905000        1652928622000\nV841WLXO                    112      0 QRPGLESRC    ORD700D3VV SQLRPGLE   ORD700D3-Order Line Detail                                        32860        1651726489000        1651727782000\nV841WLXO                    112      0 QRPGLESRC    ORD700D9.1 SQLRPGLE   ORD700D9-Order Entry Maintenance                                  27546        1666352137000        1666352145000\nV841WLXO                    112      0 QRPGLESRC    ORD700D9.2 SQLRPGLE   ORD700D9-Order Entry Maintenance                                  27546        1702986280000        1702986285000\nV841WLXO                    112      0 QRPGLESRC    ORD701BBK  SQLRPGLE   ORD701B-Order Posting Batch                                       30290        1618870570000        1607328792000\nV841WLXO                    112      0 QRPGLESRC    ORD701BC   SQLRPGLE   ORD701B-Order Posting Batch                                       30398        1690361083000        1690358598000\nV841WLXO                    112      0 QRPGLESRC    ORD701BMAS SQLRPGLE   ORD701B-Order Posting Batch                                       30290        1618870834000        1618870763000\nV841WLXO                    112      0 QRPGLESRC    ORD701BNOT SQLRPGLE   ORD701B-Order Posting Batch                                       30290        1616741257000        1607328792000\nV841WLXO                    112      0 QRPGLESRC    ORD701BPS  SQLRPGLE   ORD701B-Order Posting Batch                                       30293        1616735223000        1616748222000\nV841WLXO                    112      0 QRPGLESRC    ORD701BPSR SQLRPGLE   ORD701B-Order Posting Batch                                       30295        1618870748000        1619160368000\nV841WLXO                    112      0 QRPGLESRC    ORD702B.0  XOLRPGLE   ORD702B-Order Create/Copy Batch                                   30380        1650240707000        1650240718000\nV841WLXO                    112      0 QRPGLESRC    ORD702B_   SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30514        1676861804000        1676628353000\nV841WLXO                    112      0 QRPGLESRC    ORD702B_MK SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30522        1691372735000        1677208196000\nV841WLXO                    112      0 QRPGLESRC    ORD702BBK1 SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30368        1606717205000        1606716386000\nV841WLXO                    112      0 QRPGLESRC    ORD702BMC  SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30398        1651465908000        1651473040000\nV841WLXO                    112      0 QRPGLESRC    ORD702BMC1 SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30466        1655890604000        1656484414000\nV841WLXO                    112      0 QRPGLESRC    ORD702BVA  SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30440        1655435217000        1655706474000\nV841WLXO                    112      0 QRPGLESRC    ORD709B1   SQLRPGLE   Rcv data from CRMi & build URL for Quo/Ord Crt/Cpy                  492        1693482276000        1662107256000\nV841WLXO                    112      0 QRPGLESRC    ORD710BCM  SQLRPGLE   ORD710B-Order Validation Batch                                    30204        1652191227000        1653390675000\nV841WLXO                    112      0 QRPGLESRC    ORD710BMC2 SQLRPGLE   ORD710B-Order Validation Batch                                    30218        1654692795000        1654740976000\n\n **** CLI ERROR *****\n         SQLSTATE: 22007\nNATIVE ERROR CODE: -180\nSYNTAX OF DATE, TIME, OR TIMESTAMP VALUE NOT VALID. \n\n189 RECORD(S) SELECTED.",
    "stderr": ""
}

@worksofliam
Copy link
Contributor

Interesting, because I can see the list in the result set from your log.

Can I ask you to try this on our pre-release version? Go to where you install VS Code in the Extension view, and select 'Switch to pre-release'. Then restart VS Code and give it another go. Please switch back to the standard release when you're done if it doesn't work.

@begwhite
Copy link
Author

begwhite commented Nov 20, 2024

Still not showing in the Filter. Output below:

Click me

Code for IBM i, version 2.13.18

.: echo "This should be the only text!"
{
    "code": 0,
    "signal": null,
    "stdout": "This should be the only text!",
    "stderr": ""
}

.: echo $HOME && cd && test -w $HOME
{
    "code": 0,
    "signal": null,
    "stdout": "/home/BWHITE1",
    "stderr": ""
}

/home/BWHITE1: 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\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/BWHITE1: ls -p /QOpenSys/pkgs/bin/
{
    "code": 0,
    "signal": null,
    "stdout": "2to3\n2to3-3.6\n[\nalternatives\natob\nbase32\nbase64\nbasename\nbash\nbashbug\nbtoa\nc2ph\ncat\ncertutil\nchcon\nchgrp\nchmod\nchown\nchroot\ncksum\ncmsutil\ncomm\ncomposer\ncorelist\ncp\ncpan\ncrlutil\ncsplit\ncurl\ncurl-config\ncut\ndate\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\nderdump\ndf\ndir\ndircolors\ndirname\ndu\necho\negrep\nenc2xs\nencguess\nenv\nexpand\nexpr\nfactor\nfalse\nfgrep\nfind-repos-of-install\nfmt\nfold\nfunzip\ngrep\ngroups\nh2ph\nh2xs\nhead\nhostid\nid\nidle3\nidle3.6\ninstall\ninstmodsh\njoin\njson_pp\nkill\nlibnetcfg\nlibtool\nlibtoolize\nlink\nlistsuites\nln\nlogname\nls\nmd5sum\nmkdir\nmkfifo\nmknod\nmktemp\nmodutil\nmv\nneeds-restarting\nnginx\nnice\nnl\nnohup\nnproc\nnss-policy-check\nnumfmt\nocspclnt\nod\npackage-cleanup\npaste\npathchk\npear\npeardev\npecl\nperl\nperl5.24.1\nperlbug\nperldoc\nperlivp\nperlthanks\nphar\nphar.phar\nphp\nphp-cgi\nphp-config\nphpize\npiconv\npinky\npk12util\npl2pm\npod2html\npod2man\npod2text\npod2usage\npodchecker\npodselect\npp\npr\nprintenv\nprintf\nprove\npstruct\nptar\nptardiff\nptargrep\nptx\npwd\npydoc\npydoc3\npydoc3.6\npython\npython2\npython2.7\npython3\npython3.6\npython3.6m\npyvenv\npyvenv-3.6\nreadlink\nrealpath\nrepo-graph\nrepo-rss\nrepoclosure\nrepodiff\nrepomanage\nrepoquery\nreposync\nrepotrack\nrm\nrmdir\nrpm\nrpm2archive\nrpm2cpio\nrpmdb\nrpmgraph\nrpmkeys\nrpmquery\nrpmsign\nrpmverify\nruncon\nselfserv\nseq\nsha1sum\nsha224sum\nsha256sum\nsha384sum\nsha512sum\nshasum\nshow-changed-rco\nshow-installed\nshred\nshuf\nsigntool\nsignver\nsleep\nsmtpd.py\nsort\nsplain\nsplit\nssltap\nstat\nstdbuf\nstrsclnt\nstty\nsum\nsymkeyutil\nsync\ntac\ntail\ntee\ntest\ntimeout\ntouch\ntr\ntrue\ntruncate\ntrust\ntsort\ntstclnt\ntty\nuname\nunexpand\nuniq\nunlink\nunzip\nunzipsfx\nupdate-alternatives\nupdate-ca-certificates\nuptime\nurlgrabber\nusers\nvdir\nverifytree\nvfychain\nvfyserv\nwc\nwho\nwhoami\nxmlservice-cli\nxsltproc\nxsubpp\nyes\nyum\nyum-builddep\nyum-complete-transaction\nyum-config-manager\nyum-debug-dump\nyum-debug-restore\nyum-groups-manager\nyumdb\nyumdownloader\nzipdetails\nzipgrep\nzipinfo",
    "stderr": ""
}

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

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

/home/BWHITE1: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
    "code": 0,
    "signal": null,
    "stdout": "/QSYS.lib/ILEDITOR.lib/GENCMD2.PGM\n/QSYS.lib/ILEDITOR.lib/GETNEWLIBL.PGM",
    "stderr": ""
}

/home/BWHITE1: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit/bin/java
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk11/64bit/bin/java
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: test -x /QOpensys/pkgs/lib/jvm/openjdk-11/bin/java
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk17/64bit/bin/java
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: echo "$HOME/.vscode/"
{
    "code": 0,
    "signal": null,
    "stdout": "/home/BWHITE1/.vscode/",
    "stderr": ""
}

/home/BWHITE1: test -x /home/BWHITE1/.vscode/cqsh_1
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: chmod +x /home/BWHITE1/.vscode/cqsh_1
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1
echo "Hello world"
{
    "code": 0,
    "signal": null,
    "stdout": "Hello world",
    "stderr": ""
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
select LONG_COMMENT from qsys2.sysroutines where routine_schema = 'ILEDITOR' and routine_name = 'GETMBRINFO'
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nLONG_COMMENT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    \n--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n1 - Validate member information                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 \n\n  1 RECORD(S) SELECTED.",
    "stderr": "CPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}


Code for IBM i components:
	cqsh (1): Installed
	GetNewLibl (1): Installed
	GetMemberInfo (1): Installed
	CopyToImport (1): Installed

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1
liblist
{
    "code": 0,
    "signal": null,
    "stdout": "QSYS        SYS\nQSYS2       SYS\nQHLPSYS     SYS\nQUSRSYS     SYS\nSSAUTL      SYS\nQSHELL      PRD\nQTEMP       USR\nAULSYS3     USR\nQGPL        USR",
    "stderr": ""
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1
system "CRTLIB LIB(ILEDITOR) TEXT('Code for i temporary objects. May be cleared.')"
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": "CPF2111:  LIBRARY ILEDITOR ALREADY EXISTS.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

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

/home/BWHITE1: echo $SHELL
{
    "code": 0,
    "signal": null,
    "stdout": "/QOpenSys/pkgs/bin/bash",
    "stderr": ""
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1
system "CHKOBJ OBJ(QSYS/QCPTOIMPF) OBJTYPE(*DTAARA)"
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": "CPF9801:  OBJECT QCPTOIMPF IN LIBRARY QSYS NOT FOUND.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1
system "CHKOBJ OBJ(QSYS/QCPFRMIMPF) OBJTYPE(*DTAARA)"
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": "CPF9801:  OBJECT QCPFRMIMPF IN LIBRARY QSYS NOT FOUND.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1
liblist -d QTEMP AULSYS3 QGPL; liblist -a V842WLXO; liblist -a V842TLXO; liblist -a V842RLXO; liblist -a V842RLXS; liblist -a V842TLXEC; liblist -a V842TDBAF; liblist -a V8420LXO; liblist -a V8410LXO; liblist -a V8420LXS; liblist -a V8410LXS; liblist -a V842DEVF; liblist -a V8400LXO; liblist -a V8400LXS; liblist -a DBU11; liblist -a V842AMLIB; liblist -a W3TOOLS460; liblist -a QTEMP; liblist -a AULSYS3; liblist -a QGPL; liblist -a INFORLIC84; liblist -a AULWFF3842
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
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  ACCESS_PATH_TARGET_RECOVERY_TIME  ACCESS_PATH_ESTIMATED_RECOVERY_TIME  SMAPP_DISK_STORAGE_USED \n------------------------ ----------- ---------- --------- ------------------ --------------------- ------------------- -------------- -------------------- ------------------------- -------------------- ----------------------------- --------------------- ------------------------------- --------------- -------------------- ----------------------------- ------------------------- ---------------- ------------------ -------------------- ------------------------ ---------------- -------------- ---------------------------- ---------------------- ------------------------ ------------------------------- --------------- --------------------- -------------------- ----------------------- ------------------- ------------- --------------- ------------------- ----------------------- ----------------------- ----------------------------- ----------------------------- ---------------------------------- ---------------------------------- ------------------------------------------- -------------- -------------------------- --------------------------------- ------------------------------------ ------------------------\n-                                  1 NONE       SYSTEM    USALID29                              16 ALL                 NO                          2290650                    722361                    0                             0               2290650                          722361             199                    0                            90 SUCCESS                                 36               1288                    1                     2156              101 NO             OVERFLOW DELAY               NONE                   YES                      NO                              NONE            NONE                  -                    -                       -                   COMPLETE 2                  0 -                   -                       -                       -                             -                             -                                  -                                  -                                           -              -                          *NONE                                                               21                        6\n\n  1 RECORD(S) SELECTED.",
    "stderr": "CPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
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                                 37\n\n  1 RECORD(S) SELECTED.",
    "stderr": "CPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
select CHARACTER_CODE_SET_ID from table( QSYS2.QSYUSRINFO( USERNAME => upper('bwhite1') ) )
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nCHARACTER_CODE_SET_ID \n----------------------\n                    37\n\n  1 RECORD(S) SELECTED.",
    "stderr": "CPC2206:  OWNERSHIP OF OBJECT QSQUS00001 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT QZLSCKSVR IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
Select DEFAULT_CCSID From Table(QSYS2.ACTIVE_JOB_INFO( JOB_NAME_FILTER => '*', DETAILED_INFO => 'ALL' ))
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nDEFAULT_CCSID \n--------------\n            37\n\n  1 RECORD(S) SELECTED.",
    "stderr": "CPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}


CCSID information:
	QCCSID: 37
	User Job CCSID: 37
	User Default CCSID: 37
/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
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": "CPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
select job_name, local_port from qsys2.netstat_job_info where cast(local_port_name as VarChar(14) CCSID 37) = 'is-debug-ile' fetch first row only
/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nJOB_NAME                     LOCAL_PORT \n---------------------------- -----------\n790965/BPCSUPGRAD/QB5ROUTER         3825\n\n  1 RECORD(S) SELECTED.",
    "stderr": "CPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: test -r /QIBM/ProdData/IBMiDebugService/package.json
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nJOB_NAME                     LOCAL_PORT \n---------------------------- -----------\n791191/BPCSUPGRAD/QP0ZSPWP          8005\n791191/BPCSUPGRAD/QP0ZSPWP          8008\n791191/BPCSUPGRAD/QP0ZSPWP          8001\n\n  3 RECORD(S) SELECTED.",
    "stderr": "CPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: test -r /QIBM/ProdData/IBMiDebugService/package.json
/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
select job_name, local_port from qsys2.netstat_job_info where cast(local_port_name as VarChar(14) CCSID 37) = 'is-debug-ile' fetch first row only
/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nJOB_NAME                     LOCAL_PORT \n---------------------------- -----------\n790965/BPCSUPGRAD/QB5ROUTER         3825\n\n  1 RECORD(S) SELECTED.",
    "stderr": "CPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nJOB_NAME                     LOCAL_PORT \n---------------------------- -----------\n791191/BPCSUPGRAD/QP0ZSPWP          8005\n791191/BPCSUPGRAD/QP0ZSPWP          8008\n791191/BPCSUPGRAD/QP0ZSPWP          8001\n\n  3 RECORD(S) SELECTED.",
    "stderr": "CPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
select OS_VERSION concat '.' concat OS_RELEASE as VERSION from sysibmadm.env_sys_info
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nVERSION                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n7.5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              \n\n  1 RECORD(S) SELECTED.",
    "stderr": "CPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPC2206:  OWNERSHIP OF OBJECT GPTFLST IN QTEMP TYPE *USRSPC CHANGED.\nCPF427D:  SUBSTITUTION CHARACTERS MAY BE USED IN DATA CONVERSION.\nCPF427D:  SUBSTITUTION CHARACTERS MAY BE USED IN DATA CONVERSION.\nCPF427D:  SUBSTITUTION CHARACTERS MAY BE USED IN DATA CONVERSION.\nCPF427D:  SUBSTITUTION CHARACTERS MAY BE USED IN DATA CONVERSION.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
select max(ptf_group_level) as HIGHEST_DB2_PTF_GROUP_LEVEL from qsys2.group_ptf_info where PTF_GROUP_DESCRIPTION like 'DB2 FOR IBM I%' and ptf_group_status = 'INSTALLED'
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nHIGHEST_DB2_PTF_GROUP_LEVEL \n----------------------------\n                           7\n\n  1 RECORD(S) SELECTED.",
    "stderr": "CPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPC2206:  OWNERSHIP OF OBJECT GPTFLST IN QTEMP TYPE *USRSPC CHANGED.\nCPF427D:  SUBSTITUTION CHARACTERS MAY BE USED IN DATA CONVERSION.\nCPF427D:  SUBSTITUTION CHARACTERS MAY BE USED IN DATA CONVERSION.\nCPF427D:  SUBSTITUTION CHARACTERS MAY BE USED IN DATA CONVERSION.\nCPF427D:  SUBSTITUTION CHARACTERS MAY BE USED IN DATA CONVERSION.\nCPF427D:  SUBSTITUTION CHARACTERS MAY BE USED IN DATA CONVERSION.\nCPF427D:  SUBSTITUTION CHARACTERS MAY BE USED IN DATA CONVERSION.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: ls $HOME/.vscode/mapepire-server-2.1.4.jar
/home/BWHITE1: test -f /QIBM/UserData/IBMiDebugService/certs/debug_service.pfx
/home/BWHITE1: test -r /QIBM/ProdData/IBMiDebugService/package.json
{
    "code": 0,
    "signal": null,
    "stdout": "/home/BWHITE1/.vscode/mapepire-server-2.1.4.jar",
    "stderr": ""
}

/home/BWHITE1: echo $SHELL
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: test -f /QIBM/UserData/IBMiDebugService/certs/debug_service.crt
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

{
    "code": 0,
    "signal": null,
    "stdout": "/QOpenSys/pkgs/bin/bash",
    "stderr": ""
}

{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: test -f /QIBM/UserData/IBMiDebugService/.code4i.debug
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: test -f /QIBM/ProdData/IBMiDebugService/bin/certs/debug_service.pfx
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": ""
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
SELECT JOB_NAME FROM TABLE(QSYS2.ACTIVE_JOB_INFO(SUBSYSTEM_LIST_FILTER => 'QSYSWRK', CURRENT_USER_LIST_FILTER => 'BWHITE1')) X where JOB_STATUS = 'MSGW'
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nJOB_NAME                    \n----------------------------\n\n  0 RECORD(S) SELECTED.",
    "stderr": "CPC2206:  OWNERSHIP OF OBJECT SQUS000000 IN QTEMP TYPE *USRSPC CHANGED.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1
system "CHKOBJ OBJ(QSYS/V841WLXO) OBJTYPE(*LIB) AUT(*NONE)"
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": "CPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
with SRCFILES as (   select      rtrim(cast(t.SYSTEM_TABLE_SCHEMA as char(10) for bit data)) as LIBRARY,     rtrim(cast(t.SYSTEM_TABLE_NAME as char(10) for bit data)) as NAME,     '*FILE'             as TYPE,     'PF'                as ATTRIBUTE,     t.TABLE_TEXT        as TEXT,     1                   as IS_SOURCE,     t.ROW_LENGTH        as SOURCE_LENGTH,     t.IASP_NUMBER       as IASP_NUMBER   from QSYS2.SYSTABLES as t   where t.FILE_TYPE = 'S' ) SELECT * FROM SRCFILES as f where f.LIBRARY = 'V841WLXO' and f.NAME  like  'Q%'
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nLIBRARY    NAME       TYPE  ATTRIBUTE  TEXT                                               IS_SOURCE   SOURCE_LENGTH  IASP_NUMBER \n---------- ---------- ----- ---------- -------------------------------------------------- ----------- -------------- ------------\nV841WLXO   QCLSRC     *FILE PF         CL source members                                            1             92            0\nV841WLXO   QCMDSRC    *FILE PF                                                                      1             92            0\nV841WLXO   QCPYLESRC  *FILE PF                                                                      1            112            0\nV841WLXO   QCSRC      *FILE PF         C Source Members                                             1            240            0\nV841WLXO   QDDSSRC    *FILE PF                                                                      1             92            0\nV841WLXO   QDDSSRC1   *FILE PF         C Source Members                                             1            240            0\nV841WLXO   QPNLSRC    *FILE PF                                                                      1             92            0\nV841WLXO   QRPGLESRC  *FILE PF                                                                      1            112            0\nV841WLXO   QRPGLESRC1 *FILE PF                                                                      1            112            0\nV841WLXO   QSQLSRC    *FILE PF         SQL Source                                                   1             92            0\nV841WLXO   QSQLTEMP1  *FILE PF         Set Object Primary Group from SSAOVR                         1            112            0\nV841WLXO   QSRVSRC    *FILE PF                                                                      1             92            0\nV841WLXO   QSTDSRC    *FILE PF                                                                      1             92            0\nV841WLXO   QTSTSRC    *FILE PF         For testing GENCMPALL                                        1            112            0\nV841WLXO   QTXTSRC    *FILE PF                                                                      1             92            0\n\n 15 RECORD(S) SELECTED.",
    "stderr": "CPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: cd "/QSYS.LIB/V841WLXO.LIB/QCSRC.FILE" && (ls | wc -l)
{
    "code": 0,
    "signal": null,
    "stdout": "3",
    "stderr": ""
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1
/usr/bin/attr -p /QSYS.LIB/V841WLXO.LIB/QCSRC.FILE CCSID
/home/BWHITE1: cd "/QSYS.LIB/V841WLXO.LIB/QSTDSRC.FILE" && (ls | wc -l)
{
    "code": 0,
    "signal": null,
    "stdout": "CCSID=37",
    "stderr": ""
}

{
    "code": 0,
    "signal": null,
    "stdout": "0",
    "stderr": ""
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1
/usr/bin/attr -p /QSYS.LIB/V841WLXO.LIB/QSTDSRC.FILE CCSID
{
    "code": 0,
    "signal": null,
    "stdout": "CCSID=37",
    "stderr": ""
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1
system "CHKOBJ OBJ(V841WLXO/QRPGLESRC) OBJTYPE(*FILE) AUT(*UPD)"
{
    "code": 0,
    "signal": null,
    "stdout": "",
    "stderr": "CPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

/home/BWHITE1: /home/BWHITE1/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
with MEMBERS as (         select           rtrim(cast(a.SYSTEM_TABLE_SCHEMA as char(10) for bit data)) as LIBRARY,           b.AVGROWSIZE as RECORD_LENGTH,           a.IASP_NUMBER as ASP,           rtrim(cast(a.SYSTEM_TABLE_NAME as char(10) for bit data)) AS SOURCE_FILE,           rtrim(cast(b.SYSTEM_TABLE_MEMBER as char(10) for bit data)) as NAME,           coalesce(rtrim(cast(b.SOURCE_TYPE as varchar(10) for bit data)), '') as TYPE,           coalesce(rtrim(varchar(b.PARTITION_TEXT)), '') as TEXT,           b.NUMBER_ROWS as LINES,           extract(epoch from (b.CREATE_TIMESTAMP))*1000 as CREATED,           extract(epoch from (b.LAST_SOURCE_UPDATE_TIMESTAMP))*1000 as CHANGED         from QSYS2.SYSTABLES as a           join QSYS2.SYSPARTITIONSTAT as b             on ( b.SYSTEM_TABLE_SCHEMA, b.SYSTEM_TABLE_NAME ) = ( a.SYSTEM_TABLE_SCHEMA, a.SYSTEM_TABLE_NAME )       )       select * from MEMBERS       where LIBRARY = 'V841WLXO'         and SOURCE_FILE = 'QRPGLESRC'         and NAME like '%'         and TYPE like '%'       order by NAME ASC
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\n  ?>\n\nLIBRARY    RECORD_LENGTH        ASP    SOURCE_FILE  NAME       TYPE       TEXT                                               LINES                CREATED              CHANGED             \n---------- -------------------- ------ ------------ ---------- ---------- -------------------------------------------------- -------------------- -------------------- --------------------\nV841WLXO                    112      0 QRPGLESRC    ACP310D1   SQLRPGLE   ACP310D1-Payables Inquiry Program                                 16939        1675920837000        1676275120000\nV841WLXO                    112      0 QRPGLESRC    ACP500D1BW SQLRPGLE   ACP500D1-Invoice Entry List Panel                                  9100        1658839371000        1722569223000\nV841WLXO                    112      0 QRPGLESRC    ACP500D1B2 SQLRPGLE   ACP500D1-Invoice Entry List Panel                                  9100        1658840345000        1610462689000\nV841WLXO                    112      0 QRPGLESRC    ACP500D1B3 SQLRPGLE   ACP500D1-Invoice Entry List Panel                                  9100        1658840369000        1638449172000\nV841WLXO                    112      0 QRPGLESRC    ACP500D2BW SQLRPGLE   ACP500D2-ACP500 Header Validation Panel                           29017        1658839372000        1627969214000\nV841WLXO                    112      0 QRPGLESRC    ACP500D2B2 SQLRPGLE   ACP500D2-ACP500 Header Validation Panel                           29017        1658840345000        1638449186000\nV841WLXO                    112      0 QRPGLESRC    ACP500D2C  SQLRPGLE   ACP500D2-ACP500 Header Validation Panel                           29017        1644828137000        1627969214000\nV841WLXO                    112      0 QRPGLESRC    ACP500D2DM SQLRPGLE   ACP500D2-ACP500 Header Validation Panel-Daniel src                28627        1670192968000        1670215069000\nV841WLXO                    112      0 QRPGLESRC    ACP500D3   SQLRPGLE   ACP500D3-Purchase Order Matching                                  17394        1678253123000        1649818507000\nV841WLXO                    112      0 QRPGLESRC    ACP500D3BW SQLRPGLE   ACP500D3-Purchase Order Matching                                  17374        1658839372000        1596117346000\nV841WLXO                    112      0 QRPGLESRC    ACP500D3B2 SQLRPGLE   ACP500D3-Purchase Order Matching                                  17374        1658840345000        1638449207000\nV841WLXO                    112      0 QRPGLESRC    ACP500D3JP SQLRPGLE   ACP500D3-Purchase Order Matching                                  16104        1634727765000        1634727776000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4BW SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     26646        1658839372000        1634215278000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4B2 SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     26646        1658840345000        1638449222000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4CH SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     25648        1634883920000        1635241876000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4DM SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     25689        1721995557000        1722031132000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4R  SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     25578        1631757272000        1631756763000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4RV SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     25705        1639703951000        1640579987000\nV841WLXO                    112      0 QRPGLESRC    ACP500D4S  SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     26646        1644993498000        1634215278000\nV841WLXO                    112      0 QRPGLESRC    ACP500D41  SQLRPGLE   ACP500D4-AP Invoice Entry Distribution 27x132                     25708        1634802962000        1634809736000\nV841WLXO                    112      0 QRPGLESRC    ACP500D6BK SQLRPGLE   ACP500D6-Invoice Matching - GRN                                   21331        1632999096000        1633005509000\nV841WLXO                    112      0 QRPGLESRC    ACP500D6BL SQLRPGLE   ACP500D6-Invoice Matching - GRN 30th Nov 22                       20196        1669772638000        1669772389000\nV841WLXO                    112      0 QRPGLESRC    ACP502D_OR SQLRPGLE   ACP502D-One Time Vendor Code Maint.                                4226        1663729336000        1663728625000\nV841WLXO                    112      0 QRPGLESRC    ACP504B.1  SQLRPGLE   ACP504B-ACP504B-Invoice Entry - Actual                            23856        1634880634000        1566459266000\nV841WLXO                    112      0 QRPGLESRC    ACP700D2MY SQLRPGLE   ACP700D2-Manual payments new                                       4923        1622609877000        1622609882000\nV841WLXO                    112      0 QRPGLESRC    ACR300DG   SQLRPGLE   ACR300DG-Customer Aging Inquiry                                    7356        1681741147000        1681741166000\nV841WLXO                    112      0 QRPGLESRC    ACR300DGB1 SQLRPGLE   ACR300DG-Customer Aging Inquiry via OPEN                           7354        1681732976000        1681732979000\nV841WLXO                    112      0 QRPGLESRC    ACR300DGB2 SQLRPGLE   ACR300DG-Customer Aging Inquiry via Cpy src & N2                   7354        1681733090000        1681740586000\nV841WLXO                    112      0 QRPGLESRC    ACR300DGB3 SQLRPGLE   ACR300DG-Customer Aging Inquiry                                    7354        1681740803000        1681740870000\nV841WLXO                    112      0 QRPGLESRC    ACR500B2DM SQLRPGLE   ACR500B2-File Posting and ATP Link                                 6516        1724653011000        1726119068000\nV841WLXO                    112      0 QRPGLESRC    ADDZX3R    SQLRPGLE   TEST                                                                 22        1597420505000        1603724162000\nV841WLXO                    112      0 QRPGLESRC    ADDZX4R    SQLRPGLE   TEST                                                                 21        1603723522000        1597407222000\nV841WLXO                    112      0 QRPGLESRC    ADDZX5R    SQLRPGLE   TEST                                                                 21        1597420506000        1597407209000\nV841WLXO                    112      0 QRPGLESRC    ADDZX6R    SQLRPGLE   TEST                                                                 21        1597420506000        1597407300000\nV841WLXO                    112      0 QRPGLESRC    API500D1   SQLRPGLE   API500D1-Campaign Planning                                         7310        1625775077000        1658392075000\nV841WLXO                    112      0 QRPGLESRC    API500D2   SQLRPGLE   API500D2-Campaign Planning                                        31413        1646132338000        1658392076000\nV841WLXO                    112      0 QRPGLESRC    API820D    SQLRPGLE   API820D-Advanced Process Industries Pa                             4561        1658227378000        1658392076000\nV841WLXO                    112      0 QRPGLESRC    APX645     SQLRPGLE   AB Mauri Incident 16286363                                          101        1650541279000        1658392077000\nV841WLXO                    112      0 QRPGLESRC    APX645B    SQLRPGLE   AB Mauri Incident 16286363                                          101        1657029689000        1658392077000\nV841WLXO                    112      0 QRPGLESRC    APX645BW   SQLRPGLE   AB Mauri Incident 16286363                                          105        1650984468000        1658392077000\nV841WLXO                    112      0 QRPGLESRC    APX645B2   SQLRPGLE   AB Mauri Incident 16286363                                          110        1647873795000        1658392077000\nV841WLXO                    112      0 QRPGLESRC    ARP615BC   SQLRPGLE   ARP615B-Apply Checks to Customer Accts                             6887        1702250301000        1702004831000\nV841WLXO                    112      0 QRPGLESRC    AVP700B    SQLRPGLE   AVP Output Driver Program                                           303        1604929000000        1450399182000\nV841WLXO                    112      0 QRPGLESRC    AVP732B_BK SQLRPGLE   Update Reschedule Dates                                            1501        1612940082000        1613536795000\nV841WLXO                    112      0 QRPGLESRC    BIL501B    SQLRPGLE   BIL501B-Invoice Batch Processing                                   3872        1706567934000        1706567936000\nV841WLXO                    112      0 QRPGLESRC    BIL501D2BK SQLRPGLE   BIL501D2-Customer Document Header Panel                           13271        1602474409000        1602474315000\nV841WLXO                    112      0 QRPGLESRC    BIL501D2B1 SQLRPGLE   BIL501D2-Customer Document Header Panel                           13271        1602214043000        1602148428000\nV841WLXO                    112      0 QRPGLESRC    BIL501D2MA SQLRPGLE   BIL501D2-Customer Document Header Panel                           13567        1602148633000        1602473820000\nV841WLXO                    112      0 QRPGLESRC    BIL501D2NO SQLRPGLE   BIL501D2-Customer Document Header Panel                           13383        1602148421000        1602162352000\nV841WLXO                    112      0 QRPGLESRC    BIL540B_   SQLRPGLE   BIL540B-Invoice Billing Master Update                             19413        1605666757000        1605666663000\nV841WLXO                    112      0 QRPGLESRC    BIL540BBK  SQLRPGLE   BIL540B-Invoice Billing Master Update                             19443        1706136500000        1706519835000\nV841WLXO                    112      0 QRPGLESRC    BIL561BBW  RPGLE      BIL561B-Invoice Reprint Processor                                   607        1640000257000        1640008591000\nV841WLXO                    112      0 QRPGLESRC    BIL605B_   SQLRPGLE   BIL605B-Build Billing Files From ECS                               4926        1625115156000        1625115129000\nV841WLXO                    112      0 QRPGLESRC    BIL606B_   SQLRPGLE   Create/Update Billings Headers                                     3007        1625115164000        1625115133000\nV841WLXO                    112      0 QRPGLESRC    BIL607B_   SQLRPGLE   BIL607B-Select Pick Confirm from Wrkfl                              753        1625634903000        1625634709000\nV841WLXO                    112      0 QRPGLESRC    BIL690BM   SQLRPGLE   BIL690B-Total Order Discount Proration                             1232        1645418044000        1645418045000\nV841WLXO                    112      0 QRPGLESRC    CAP300D    SQLRPGLE   CAP300D-Capacity Requirements Inquiry                             16716        1656081243000        1529510790000\nV841WLXO                    112      0 QRPGLESRC    CEA310D1BW SQLRPGLE   CEA310D1-Journal Inquiry                                          25129        1658839372000        1626272351000\nV841WLXO                    112      0 QRPGLESRC    CEA500B    SQLRPGLE   CEA500B-Engine Control & Event Deter.                              2557        1618443571000        1618918021000\nV841WLXO                    112      0 QRPGLESRC    CEA502B1   SQLRPGLE   CEA502B1-ACP Engine Resolution Pgm                                30655        1687392149000        1687399215000\nV841WLXO                    112      0 QRPGLESRC    CEA502B1MC SQLRPGLE   CEA502B1-ACP Engine Resolution Pgm                                30587        1620300494000        1620300601000\nV841WLXO                    112      0 QRPGLESRC    CEA502B1SP SQLRPGLE   CEA502B1-ACP Engine Resolution Pgm                                30591        1620300475000        1619402718000\nV841WLXO                    112      0 QRPGLESRC    CEA502B1VV SQLRPGLE   CEA502B1-ACP Engine Resolution Pgm                                30583        1620300535000        1620300511000\nV841WLXO                    112      0 QRPGLESRC    CEA502B2SS SQLRPGLE   CEA502B2-ACR Engine Resolution Pgm                                34446        1627050755000        1627049072000\nV841WLXO                    112      0 QRPGLESRC    CEA502B3_  SQLRPGLE   CEA502B3-DST Engine Resolution Pgm                                30802        1608640950000        1608633062000\nV841WLXO                    112      0 QRPGLESRC    CEA502B3__ SQLRPGLE   CEA502B3-DST Engine Resolution Pgm                                30903        1611028245000        1611028212000\nV841WLXO                    112      0 QRPGLESRC    CEA502B329 SQLRPGLE   CEA502B3-DST Engine Resolution Pgm                                30900        1609214049000        1608641581000\nV841WLXO                    112      0 QRPGLESRC    CLD107D1BW SQLRPGLE   CLD107D1-Currency Code Maint. Panel 1                              4705        1658839372000        1618223477000\nV841WLXO                    112      0 QRPGLESRC    CPR004B    RPGLE      CPR004B-TDR API                                                    1970        1635131320000        1502366809000\nV841WLXO                    112      0 QRPGLESRC    CRAP       RPGLE                                                                            1        1729767109000        1729767152000\nV841WLXO                    112      0 QRPGLESRC    CST200D    RPGLE      CST200D-Item Cost Prompt Screen                                    2984        1625775111000        1626273145000\nV841WLXO                    112      0 QRPGLESRC    CST270B_   SQLRPGLE   CST270B-Cost Variance/WIP Analysis                                17801        1644494393000        1644483954000\nV841WLXO                    112      0 QRPGLESRC    CST560BBK  SQLRPGLE   CST560B-Cost change                                                3802        1602299204000        1602716603000\nV841WLXO                    112      0 QRPGLESRC    CST910B_   SQLRPGLE   CST910B-Labor Ticket - ATP                                         3828        1608639841000        1608633050000\nV841WLXO                    112      0 QRPGLESRC    CST920B_V1 SQLRPGLE   CST920B-Cost Transfers                                             1650        1654861518000        1656037365000\nV841WLXO                    112      0 QRPGLESRC    CST940B_V1 SQLRPGLE   CST940B-Inter Facility Cost Transfer - Bkuplatest                  4259        1655374906000        1655373673000\nV841WLXO                    112      0 QRPGLESRC    CST940B_V2 SQLRPGLE   CST940B-Inter Facility Cost Transfer                               4235        1655301721000        1656041585000\nV841WLXO                    112      0 QRPGLESRC    CVTCICDFTR SQLRPGLE   Set default values for CIC                                          870        1592826185000        1595562490000\nV841WLXO                    112      0 QRPGLESRC    DRP550DC   SQLRPGLE   DRP550D-Resupply Order Receipts                                   27150        1728352661000        1728351936000\nV841WLXO                    112      0 QRPGLESRC    ECM526B    SQLRPGLE   ECM526B-Outbound Pick List RSA                                     1412        1606220455000        1452646286000\nV841WLXO                    112      0 QRPGLESRC    ECM605B7   SQLRPGLE   ECM605B7-Inbound Order Post                                       10507        1676524372000        1676524779000\nV841WLXO                    112      0 QRPGLESRC    ECM605B7_C SQLRPGLE   ECM605B7-Inbound Order Post                                       10492        1676522168000        1676522081000\nV841WLXO                    112      0 QRPGLESRC    ECM605D1   SQLRPGLE   ECM605D1-Order Header Maintenance                                 18901        1673509388000        1527893267000\nV841WLXO                    112      0 QRPGLESRC    EXTPRCPH   RPGLE      EXTRTNP1-Stub program for APPVEND exit retun parm                  1407        1679523229000        1670310208000\nV841WLXO                    112      0 QRPGLESRC    EXTPRCPL   RPGLE      EXTRTNP1-Stub program for APPVEND exit retun parm                  1406        1679523229000        1670310214000\nV841WLXO                    112      0 QRPGLESRC    EXTPRCRTAX RPGLE      Exit point trigger program                                         1127        1722841835000        1729565226000\nV841WLXO                    112      0 QRPGLESRC    FIE        SQLRPGLE   Integrate LX security into IDF AutoContent Securit                 1230        1589294228000        1589294228000\nV841WLXO                    112      0 QRPGLESRC    GHH01V_    SQLRPGLE   GHH01V-Journal History Validation Ser                             24288        1608633103000        1608633046000\nV841WLXO                    112      0 QRPGLESRC    ILM503D1_C SQLRPGLE   ILM503D1-Inbound Delivery Lines Select.                           10413        1662348314000        1662107258000\nV841WLXO                    112      0 QRPGLESRC    ILM503D2_C SQLRPGLE   ILM503D2-Inbound Delivery Line Detail                              4809        1662348320000        1662109285000\nV841WLXO                    112      0 QRPGLESRC    ILM600BBK  SQLRPGLE   ILM600B-Post Item IBD Costs                                        5887        1602583177000        1602233700000\nV841WLXO                    112      0 QRPGLESRC    ILM600BBK1 SQLRPGLE   ILM600B-Post Item IBD Costs                                        5914        1602142131000        1602651289000\nV841WLXO                    112      0 QRPGLESRC    INV300DC   SQLRPGLE   INV300D-Material Status Inquiry                                   31191        1700184449000        1700125025000\nV841WLXO                    112      0 QRPGLESRC    INV500B1_  SQLRPGLE   INV500B1-Inventory Transaction Posting                            42023        1646132323000        1646104797000\nV841WLXO                    112      0 QRPGLESRC    INV500B1C  SQLRPGLE   INV500B1-Inventory Transaction Posting                            42053        1704360220000        1704340598000\nV841WLXO                    112      0 QRPGLESRC    INV500B1N  SQLRPGLE   INV500B1-Inventory Transaction Posting                            42117        1730796626000        1730790577000\nV841WLXO                    112      0 QRPGLESRC    INV500D22  SQLRPGLE   INV500D2-Inventory Transaction Posting                            36237        1680770245000        1592481285000\nV841WLXO                    112      0 QRPGLESRC    INV510D_   SQLRPGLE   INV510D-Location Transfers Posting                                21581        1646122209000        1646104805000\nV841WLXO                    112      0 QRPGLESRC    INV510DVC  SQLRPGLE   INV510D-Location Transfers Posting                                21591        1719400015000        1719400019000\nV841WLXO                    112      0 QRPGLESRC    INV510DV1  SQLRPGLE   INV510D-Location Transfers Posting                                21591        1719400187000        1719400019000\nV841WLXO                    112      0 QRPGLESRC    INV511B_   SQLRPGLE   Shipment Components to Vendor - Allocation/Split                   4606        1646122512000        1646104879000\nV841WLXO                    112      0 QRPGLESRC    INV511D_   SQLRPGLE   INV511D-Location Transfers Posting                                27306        1646123334000        1646104887000\nV841WLXO                    112      0 QRPGLESRC    INV530B.1  SQLRPGLE   INV530B-Daily Cycle Count Wrksht(Item)                             6280        1663641179000        1649654404000\nV841WLXO                    112      0 QRPGLESRC    INV530BBK  SQLRPGLE   INV530B-Daily Cycle Count Wrksht(Item)                             6245        1611903254000        1611903134000\nV841WLXO                    112      0 QRPGLESRC    INV531BBK  SQLRPGLE   INV531B-Create Cycle Count Wrksht(Whs)                             5435        1663641179000        1649651703000\nV841WLXO                    112      0 QRPGLESRC    INV532B.1  SQLRPGLE   INV532B-Create Cycle Count Wrksht(Loc)                             5404        1663641179000        1649651768000\nV841WLXO                    112      0 QRPGLESRC    INV650B_   SQLRPGLE   INV650B-Physical Inventory Close - I                               9706        1646123555000        1646104896000\nV841WLXO                    112      0 QRPGLESRC    INV650BBK  SQLRPGLE   INV650B-Physical Inventory Close - I                               9708        1621566456000        1621577265000\nV841WLXO                    112      0 QRPGLESRC    IPB        SQLRPGLE   Edit buffer                                                       19379        1595417312000        1595417332000\nV841WLXO                    112      0 QRPGLESRC    ITMS600    SQLRPGLE   AB Mauri Incident 16286363                                          310        1650620828000        1650625291000\nV841WLXO                    112      0 QRPGLESRC    JIT560B_   SQLRPGLE   JIT560B-JIT Planned Shop Order Release                             9299        1646109131000        1646104513000\nV841WLXO                    112      0 QRPGLESRC    JIT600D5_  SQLRPGLE   JIT600D5-Production Reporting-Backflush                           14398        1646123816000        1646105079000\nV841WLXO                    112      0 QRPGLESRC    LMP500D2   SQLRPGLE   LMP500D2-Cell WorkBench Maintenance 27x132                        12118        1657807489000        1608867071000\nV841WLXO                    112      0 QRPGLESRC    LMP500D2_  QLRPGLE    LMP500D2-Cell WorkBench Maintenance 27x132                        11102        1607080742000        1607080709000\nV841WLXO                    112      0 QRPGLESRC    LTMS600    SQLRPGLE   AB Mauri Incident 16286363                                          242        1648475053000        1648475786000\nV841WLXO                    112      0 QRPGLESRC    MRP140D1_C SQLRPGLE   MRP140D1-Facility Planning List Panel                              4822        1674631663000        1675308352000\nV841WLXO                    112      0 QRPGLESRC    MRP200B    SQLRPGLE   MRP200B-MRP Exception Report                                      30620        1664260171000        1665021612000\nV841WLXO                    112      0 QRPGLESRC    MRP500BB   SQLRPGLE   First Cut Master Scheduling                                       17669        1715069866000        1721986333000\nV841WLXO                    112      0 QRPGLESRC    MRP500BK   SQLRPGLE   First Cut Master Scheduling                                       17636        1613120153000        1613119903000\nV841WLXO                    112      0 QRPGLESRC    MRP500C    SQLRPGLE   First Cut Master Scheduling                                       17652        1713234418000        1713233569000\nV841WLXO                    112      0 QRPGLESRC    MRP500HAR  SQLRPGLE   First Cut Master Scheduling                                       17587        1602248761000        1602248540000\nV841WLXO                    112      0 QRPGLESRC    MRP640_    SQLRPGLE   Finite Forward Scheduling                                         12290        1646110879000        1646104773000\nV841WLXO                    112      0 QRPGLESRC    MRP643B_   SQLRPGLE   MRP643B-Create FMA Records for Orders                              6994        1646125569000        1646105085000\nV841WLXO                    112      0 QRPGLESRC    MRP647_    SQLRPGLE   Routing Selection for Finite Forward Scheduling.                   2435        1646110581000        1646104629000\nV841WLXO                    112      0 QRPGLESRC    MRP785IMC  SQLRPGLE   MRP785I- ATP/CTP Date Web Services                                  978        1653620574000        1653640726000\nV841WLXO                    112      0 QRPGLESRC    MRP785IMC2 SQLRPGLE   MRP785I- ATP/CTP Date Web Services                                  950        1654691690000        1654740416000\nV841WLXO                    112      0 QRPGLESRC    OLM140DBW  SQLRPGLE   OLM140D-Ship To Maint Data Panel-Ship                              4962        1658839372000        1596117604000\nV841WLXO                    112      0 QRPGLESRC    OLM592B1   SQLRPGLE   OLM592B1-Non-Haz BOL Rpt by Tariff Cls                             8021        1657603460000        1644480578000\nV841WLXO                    112      0 QRPGLESRC    OLM596BH   SQLRPGLE   OLM596B-Delivery Note Print                                        8400        1693014772000        1693013358000\nV841WLXO                    112      0 QRPGLESRC    OLM596BR   SQLRPGLE   OLM596B-Delivery Note Print                                        8400        1693012061000        1693010037000\nV841WLXO                    112      0 QRPGLESRC    ORD090B    SQLRPGLE   ESX Language Override Server                                        162        1663070824000        1452646664000\nV841WLXO                    112      0 QRPGLESRC    ORD100D2BW SQLRPGLE   ORD100D2-Customer Address Maintenance                             11980        1658839372000        1628847778000\nV841WLXO                    112      0 QRPGLESRC    ORD300D1BM SQLRPGLE   ORD300D1-Order Select by Order Panel                              11253        1657159860000        1656990004000\nV841WLXO                    112      0 QRPGLESRC    ORD300D1B1 SQLRPGLE   ORD300D1-Order Select by Order Panel                              11013        1645490753000        1645490756000\nV841WLXO                    112      0 QRPGLESRC    ORD300D1B2 SQLRPGLE   ORD300D1-Order Select by Order Panel                              11948        1657797718000        1657251050000\nV841WLXO                    112      0 QRPGLESRC    ORD302D    SQLRPGLE   ORD302D-Order Shipment Info                                        4437        1666362875000        1666362876000\nV841WLXO                    112      0 QRPGLESRC    ORD550B6GS SQLRPGLE   ORD550B6-Over/Short Orders Promotion Audit                         1339        1681893926000        1681893904000\nV841WLXO                    112      0 QRPGLESRC    ORD553BK   SQLRPGLE   'ORD553B-Pick Release Sel-kit                                      4251        1614068954000        1614049924000\nV841WLXO                    112      0 QRPGLESRC    ORD559BGS  SQLRPGLE   ORD559B-Pick Release Updates                                       6757        1681204995000        1681204672000\nV841WLXO                    112      0 QRPGLESRC    ORD577B_   SQLRPGLE   ORD577B-Inventory Updates                                         20007        1605169082000        1605157491000\nV841WLXO                    112      0 QRPGLESRC    ORD577BRS  SQLRPGLE   ORD577B-Inventory Updates                                         20040        1621566488000        1621858609000\nV841WLXO                    112      0 QRPGLESRC    ORD680B    SQLRPGLE   ORD680B-Order Hold Batch Release Process                           2571        1666944836000        1587105318000\nV841WLXO                    112      0 QRPGLESRC    ORD680D    SQLRPGLE   ORD680D-Order Hold Batch Release Promp                             1921        1666944886000        1527897151000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA.1 SQLRPGLE   Fast Line Entry Maintenance-BMR 58702                             25877        1612857298000        1614048351000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA.2 SQLRPGLE   Fast Line Entry Maintenance                                       25714        1647471323000        1648099019000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA.3 SQLRPGLE   Fast Line Entry Maintenance                                       25597        1650428764000        1650428980000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA.4 SQLRPGLE   Fast Line Entry Maintenance                                       25597        1650429446000        1650430180000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA_E SQLRPGLE   Fast Line Entry Maintenance                                       25891        1672792372000        1670907677000\nV841WLXO                    112      0 QRPGLESRC    ORD700DA_R SQLRPGLE   Fast Line Entry Maintenance                                       25890        1673230212000        1673229649000\nV841WLXO                    112      0 QRPGLESRC    ORD700D1BW SQLRPGLE   ORD700D1-Order Entry main Panel                                   25965        1658839372000        1656598700000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2.1 SQLRPGLE   ORD700D2-Order Entry Maintenance-BMR 58702                        32681        1612971427000        1645693319000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2.2 SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32515        1647479992000        1648099041000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2_  SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32795        1676862259000        1676543927000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2_E SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32795        1672792372000        1673228367000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2_R SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32795        1673230212000        1673228848000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2A  SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32530        1612948329000        1612969818000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2BW SQLRPGLE   ORD700D2-Order Entry Maintenance                                  34236        1658839372000        1649745318000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2DM SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32469        1658289028000        1658956782000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2EE SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32796        1673228286000        1670907131000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2GS SQLRPGLE   ORD700D2-Order Entry Maintenance-BMR 58702                        32681        1670284216000        1645693319000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2MC SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32464        1649223277000        1649323617000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2MK SQLRPGLE   ORD700D2-Order Entry Maintenance                                  34251        1654139645000        1654232768000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2M1 SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32437        1653120155000        1653240101000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2M2 SQLRPGLE                                                                     32434        1653241099000        1653241096000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2SS SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32470        1658733203000        1658731303000\nV841WLXO                    112      0 QRPGLESRC    ORD700D2VV SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32953        1681104967000        1680777858000\nV841WLXO                    112      0 QRPGLESRC    ORD700D21  SQLRPGLE   ORD700D2-Order Entry Maintenance                                  32383        1612934560000        1612934569000\nV841WLXO                    112      0 QRPGLESRC    ORD700D3.D SQLRPGLE   ORD700D3-Order Line Detail                                        32905        1721291728000        1722406491000\nV841WLXO                    112      0 QRPGLESRC    ORD700D3_  SQLRPGLE   ORD700D3-Order Line Detail                                        32847        1651726515000        1651726500000\nV841WLXO                    112      0 QRPGLESRC    ORD700D3M  SQLRPGLE   ORD700D3-Order Line Detail                                        34740        1655451905000        1652928622000\nV841WLXO                    112      0 QRPGLESRC    ORD700D3VV SQLRPGLE   ORD700D3-Order Line Detail                                        32860        1651726489000        1651727782000\nV841WLXO                    112      0 QRPGLESRC    ORD700D9.1 SQLRPGLE   ORD700D9-Order Entry Maintenance                                  27546        1666352137000        1666352145000\nV841WLXO                    112      0 QRPGLESRC    ORD700D9.2 SQLRPGLE   ORD700D9-Order Entry Maintenance                                  27546        1702986280000        1702986285000\nV841WLXO                    112      0 QRPGLESRC    ORD701BBK  SQLRPGLE   ORD701B-Order Posting Batch                                       30290        1618870570000        1607328792000\nV841WLXO                    112      0 QRPGLESRC    ORD701BC   SQLRPGLE   ORD701B-Order Posting Batch                                       30398        1690361083000        1690358598000\nV841WLXO                    112      0 QRPGLESRC    ORD701BMAS SQLRPGLE   ORD701B-Order Posting Batch                                       30290        1618870834000        1618870763000\nV841WLXO                    112      0 QRPGLESRC    ORD701BNOT SQLRPGLE   ORD701B-Order Posting Batch                                       30290        1616741257000        1607328792000\nV841WLXO                    112      0 QRPGLESRC    ORD701BPS  SQLRPGLE   ORD701B-Order Posting Batch                                       30293        1616735223000        1616748222000\nV841WLXO                    112      0 QRPGLESRC    ORD701BPSR SQLRPGLE   ORD701B-Order Posting Batch                                       30295        1618870748000        1619160368000\nV841WLXO                    112      0 QRPGLESRC    ORD702B.0  XOLRPGLE   ORD702B-Order Create/Copy Batch                                   30380        1650240707000        1650240718000\nV841WLXO                    112      0 QRPGLESRC    ORD702B_   SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30514        1676861804000        1676628353000\nV841WLXO                    112      0 QRPGLESRC    ORD702B_MK SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30522        1691372735000        1677208196000\nV841WLXO                    112      0 QRPGLESRC    ORD702BBK1 SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30368        1606717205000        1606716386000\nV841WLXO                    112      0 QRPGLESRC    ORD702BMC  SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30398        1651465908000        1651473040000\nV841WLXO                    112      0 QRPGLESRC    ORD702BMC1 SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30466        1655890604000        1656484414000\nV841WLXO                    112      0 QRPGLESRC    ORD702BVA  SQLRPGLE   ORD702B-Order Create/Copy Batch                                   30440        1655435217000        1655706474000\nV841WLXO                    112      0 QRPGLESRC    ORD709B1   SQLRPGLE   Rcv data from CRMi & build URL for Quo/Ord Crt/Cpy                  492        1693482276000        1662107256000\nV841WLXO                    112      0 QRPGLESRC    ORD710BCM  SQLRPGLE   ORD710B-Order Validation Batch                                    30204        1652191227000        1653390675000\nV841WLXO                    112      0 QRPGLESRC    ORD710BMC2 SQLRPGLE   ORD710B-Order Validation Batch                                    30218        1654692795000        1654740976000\n\n **** CLI ERROR *****\n         SQLSTATE: 22007\nNATIVE ERROR CODE: -180\nSYNTAX OF DATE, TIME, OR TIMESTAMP VALUE NOT VALID. \n\n189 RECORD(S) SELECTED.",
    "stderr": "CPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPI431B:  SUBSTITUTION CHARACTERS MAY BE USED FOR FIELD.\nCPF5035:  DATA MAPPING ERROR ON MEMBER SYSTABLES.\nCPF5029:  DATA MAPPING ERROR ON MEMBER SYSTABLES.\nCPF5029:  DATA MAPPING ERROR ON MEMBER SYSTABLES.\nSQL0180:  SYNTAX OF DATE, TIME, OR TIMESTAMP VALUE NOT VALID.\nCPC2206:  OWNERSHIP OF OBJECT QZSHSYSTEM IN QTEMP TYPE *USRSPC CHANGED."
}

@worksofliam
Copy link
Contributor

@begwhite Are you able to open the dev console and see if there are any errors appearing after you try and load the list?

Help -> Toggle Developer Tools -> Console

@begwhite
Copy link
Author

2console.ts:137 [Extension Host] [Code for IBM i] Deprecation warning: you are using Instance::onEvent which is deprecated and will be removed in v3.0.0. Please use Instance::subscribe instead.
uGi @ console.ts:137
console.ts:137 [Extension Host]% Object
log.ts:439 ERR EQARD1024E Debug Adapter Protocol request "threads" is not supported.: CodeExpectedError: EQARD1024E Debug Adapter Protocol request "threads" is not supported.
at AXe.Q (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:2159:15459)
at vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:2159:15037
at async NXe.cb (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:2159:30513)
at async vZ.value (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:2159:31054)
log.ts:439 ERR Invalid debug adapter: Error: Invalid debug adapter
at b4t.p (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:615:95)
at b4t.$acceptDAExit (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:615:35)
at Pht.S (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:3124:41686)
at Pht.Q (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:3124:41464)
at Pht.M (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:3124:40552)
at Pht.L (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:3124:39789)
at vZ.value (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:3124:38450)
at x.B (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:30:747)
at x.fire (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:30:965)
at D6.fire (vscode-file://vscode-app/c:/Users/bwhite1/AppData/Local/Programs/Microsoft%20VS%20Code/resources/app/out/vs/workbench/workbench.desktop.main.js:630:10348)
console.ts:137 [Extension Host] Error: SYNTAX OF DATE, TIME, OR TIMESTAMP VALUE NOT VALID. (22007)
at c:\Users\bwhite1.vscode\extensions\halcyontechltd.code-for-ibmi-2.13.6\dist\extension.js:2:731874
at Array.forEach ()
at e.db2Parse (c:\Users\bwhite1.vscode\extensions\halcyontechltd.code-for-ibmi-2.13.6\dist\extension.js:2:731055)
at gr. (c:\Users\bwhite1.vscode\extensions\halcyontechltd.code-for-ibmi-2.13.6\dist\extension.js:2:940086)
at Generator.next ()
at o (c:\Users\bwhite1.vscode\extensions\halcyontechltd.code-for-ibmi-2.13.6\dist\extension.js:2:912727)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
log.ts:429 WARN Settings pattern "application.*" doesn't match any settings

@worksofliam
Copy link
Contributor

worksofliam commented Nov 20, 2024

@begwhite What version of the OS is this? Are you also on the latest Db2 PTF?

@begwhite
Copy link
Author

V7R5M0

5770999
TL24151 TEMPORARILY APPLIED
TL23306 SUPERSEDED
TL23110 SUPERSEDED
TL22321 PERMANENTLY APPLIED
TL22104 SUPERSEDED
RE24122 PERMANENTLY APPLIED
RE23277 PERMANENTLY APPLIED

@begwhite
Copy link
Author

5770SS1

TC24151 TEMPORARILY APPLIED
TC23306 SUPERSEDED
TC23110 SUPERSEDED
TC22321 PERMANENTLY APPLIED
TC22104 SUPERSEDED
TA24151 TEMPORARILY APPLIED
TA23306 SUPERSEDED

@worksofliam
Copy link
Contributor

@begwhite I've seen this problem before and I don't think it's got anything to do with CCSID.

I can see the result set back with this statement:

with MEMBERS as ( select rtrim(cast(a.SYSTEM_TABLE_SCHEMA as char(10) for bit data)) as LIBRARY, b.AVGROWSIZE as RECORD_LENGTH, a.IASP_NUMBER as ASP, rtrim(cast(a.SYSTEM_TABLE_NAME as char(10) for bit data)) AS SOURCE_FILE, rtrim(cast(b.SYSTEM_TABLE_MEMBER as char(10) for bit data)) as NAME, coalesce(rtrim(cast(b.SOURCE_TYPE as varchar(10) for bit data)), '') as TYPE, coalesce(rtrim(varchar(b.PARTITION_TEXT)), '') as TEXT, b.NUMBER_ROWS as LINES, extract(epoch from (b.CREATE_TIMESTAMP))*1000 as CREATED, extract(epoch from (b.LAST_SOURCE_UPDATE_TIMESTAMP))*1000 as CHANGED from QSYS2.SYSTABLES as a join QSYS2.SYSPARTITIONSTAT as b on ( b.SYSTEM_TABLE_SCHEMA, b.SYSTEM_TABLE_NAME ) = ( a.SYSTEM_TABLE_SCHEMA, a.SYSTEM_TABLE_NAME ) ) select * from MEMBERS where LIBRARY = 'V841WLXO' and SOURCE_FILE = 'QRPGLESRC' and NAME like '%' and TYPE like '%' order by NAME ASC

But after the result, it's throwing this error:

 **** CLI ERROR *****
 SQLSTATE: 22007
NATIVE ERROR CODE: -180
SYNTAX OF DATE, TIME, OR TIMESTAMP VALUE NOT VALID. 

189 RECORD(S) SELECTED.

I found a couple of other issues where this has come up and this comment sums it up best. If you run that statement in ACS, do you also find that some of the timestamp columns are messed up?

@worksofliam worksofliam added the discussion For questions, or when something isn't working as expected label Nov 21, 2024
@begwhite
Copy link
Author

There are several strange results in the created and changed columns. The returned result is very large and I've not seen values from the library and file the filter is built over.

image

@worksofliam
Copy link
Contributor

@begwhite I am going to close the issue as I can see the data messed up in your result set and there isn't much we/Code for IBM i can do about that right now (though I did here maybe some is working on a PR to solve it).

I would recommend following through with what the other comment said

But I copied those members to brand new ones, deleted the ones with missing creation date, renamed the new members to the original name, and now the list is correctly displayed.

@begwhite
Copy link
Author

I found the member with the bad creation date and copied it to a new member and deleted the old member and the filter now displays the members. The SQL I used was as follows:

    select
      rtrim(cast(a.SYSTEM_TABLE_SCHEMA as char(10) for bit data)) as LIBRARY,
      b.AVGROWSIZE as RECORD_LENGTH,
      a.IASP_NUMBER as ASP,
      rtrim(cast(a.SYSTEM_TABLE_NAME as char(10) for bit data)) AS SOURCE_FILE,
      rtrim(cast(b.SYSTEM_TABLE_MEMBER as char(10) for bit data)) as NAME,
      coalesce(rtrim(cast(b.SOURCE_TYPE as varchar(10) for bit data)), '') as TYPE,
      coalesce(rtrim(varchar(b.PARTITION_TEXT)), '') as TEXT,
      b.NUMBER_ROWS as LINES,
      extract(epoch from (b.CREATE_TIMESTAMP))*1000 as CREATED,
      extract(epoch from (b.LAST_SOURCE_UPDATE_TIMESTAMP))*1000 as CHANGED
    from QSYS2.SYSTABLES as a
      join QSYS2.SYSPARTITIONSTAT as b
        on ( b.SYSTEM_TABLE_SCHEMA, b.SYSTEM_TABLE_NAME ) = ( a.SYSTEM_TABLE_SCHEMA, a.SYSTEM_TABLE_NAME )
    where a.SYSTEM_TABLE_SCHEMA = 'V841WLXO'   and  a.SYSTEM_TABLE_NAME = 'QRPGLESRC'  ;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
discussion For questions, or when something isn't working as expected
Projects
None yet
Development

No branches or pull requests

2 participants