member list not shown when member text contains hebrew characters #2986
Description
👉🏻 with list of members text contains hebrew - members are not shown. Specific customer 7.5 version the member list with text in hebrew breaks the list (i.e the file looks empty ).
I provide out put
- With no members with hebrew - list is shown
- After changing member text to hebrew - list is broken
this does not happen in other sites (other hebrew issues but not this exotic one :))
| Context | Version |
|---|---|
| Code for IBM i version | 2.16.1 |
| Visual Studio Code version | 1.106.2 |
| Operating System | win32_x64 |
Code for IBM i, version 2.16.1
.: 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/GAD",
"stderr": ""
}
/home/GAD: /usr/bin/uname -rv
{
"code": 0,
"signal": null,
"stdout": "5 7",
"stderr": ""
}
/home/GAD: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/GAD/.vscode/",
"stderr": ""
}
/home/GAD: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/GAD/.vscode/",
"stderr": ""
}
/home/GAD: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/GAD/.vscode/",
"stderr": ""
}
/home/GAD: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/GAD/.vscode/",
"stderr": ""
}
/home/GAD: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home/GAD/.vscode/",
"stderr": ""
}
Code for IBM i components:
cqsh (1): Installed
GetNewLibl (1): Installed
GetMemberInfo (2): Installed
CopyToImport (1): Installed
SQLStatementChecker (5): Installed
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.vscode/cqsh_1
liblist
{
"code": 0,
"signal": null,
"stdout": "QSYS SYS\nQSYS2 SYS\nQHLPSYS SYS\nQUSRSYS SYS\nLOGLIBD SYS\nQDEVTOOLS SYS\nQSHELL PRD\nACUMGPL USR\nQGPL USR\nQTEMP USR\nIPILIBD USR\nIPILIB USR\nDCMTLIBD USR\nDCMTLIB USR\nDSTRLIBD USR\nDSTRLIB USR\nACUMLIB USR\nMMSLIBD USR\nMMSLIB USR\nLOGLIB USR\nGVIALIBD USR\nGVIALIB USR\nRTLIBD USR\nRTLIB USR\nPRFLIBD USR\nPRFLIB USR\nSHAKMLCL2 USR\nSHAKMLCL1J USR\nSHAKMLCL1 USR\nDWHD USR\nHULLIBD USR\nCAELIBD USR",
"stderr": ""
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.vscode/cqsh_1
system "CRTLIB LIB(ILEDITOR) TEXT('Code for i temporary objects. May be cleared.')"
/home/GAD: [ -d "/tmp" ]
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": "CPF2111: Library ILEDITOR already exists."
}
/home/GAD: echo $SHELL
{
"code": 0,
"signal": null,
"stdout": "/QOpenSys/usr/bin/bsh",
"stderr": ""
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
values current_server
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\n00001 \n------------------\nACUMTEST \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
CCSID information:
QCCSID: 65535
User Job CCSID: 424
User Default CCSID: 424
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.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": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.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/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.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---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
/home/GAD: test -r /QIBM/ProdData/IBMiDebugService/package.json
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}
/home/GAD: test -r /QIBM/ProdData/IBMiDebugService/package.json
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.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/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.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---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.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": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.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 9\n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
/home/GAD: ls $HOME/.vscode/mapepire-server-2.3.3.jar
{
"code": 0,
"signal": null,
"stdout": "/home/GAD/.vscode/mapepire-server-2.3.3.jar",
"stderr": ""
}
/home/GAD: mkdir -p "/home/GAD/builds/.vscode"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.vscode/cqsh_1
system "CHKOBJ OBJ(QSYS/GAD) OBJTYPE(*LIB) AUT(*NONE)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.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 = 'GAD' 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---------- ---------- ----- ---------- -------------------------------------------------- ----------- -------------- ------------\nGAD QCLSRC *FILE PF 1 120 0\nGAD QCLSRCSCN *FILE PF CL members for Scan utility 1 92 0\nGAD QCMDSRC *FILE PF 1 144 0\nGAD QCMDSRCSCN *FILE PF CMD members for Scan utility 1 92 0\nGAD QCMDSRTST *FILE PF 1 144 0\nGAD QCOPY *FILE PF 1 120 0\nGAD QCSRC *FILE PF C 0 120 1 נסיון\nGAD QDDSSRC *FILE PF \u001a\u001a\u001a\u001a\u001a\u001a \u001a\u001a\u001a\u001a 1 92 0\nGAD QDDSSRCGAD *FILE PF 1 80 0\nGAD QDDSSRCSCN *FILE PF DDS members for Scan utility 1 92 0\nGAD QDDSSRC2 *FILE PF \u001a\u001a\u001a\u001a\u001a\u001a \u001a\u001a\u001a\u001a 1 92 0\nGAD QJCRCMDS *FILE PF Utility tp retrieve CMDs SRC 1 112 0\nGAD QMDLSRC *FILE PF 1 92 0\nGAD QRPGLESRC *FILE PF RPGLE \u001a\u001a\u001a\u001a \u001a\u001a\u001a\u001a\u001a\u001a\u001a 1 120 0\nGAD QRPGLESRCD *FILE PF OAR Handler להדגמת RPGLE 0 120 1 תוכניות מקור\nGAD QRPGSRC *FILE PF R.P.G \u001a\u001a\u001a\u001a \u001a\u001a\u001a\u001a\u001a\u001a\u001a \u001a\u001a\u001a\u001a 1 92 0\nGAD QRPGSRCSCN *FILE PF RPG members for Scan utility 1 92 0\nGAD QSQLDWHSRC *FILE PF Special SQL Source Statememts for DWH Files 1 120 0\nGAD QSQLSRC *FILE PF SQL Source Statememts 1 120 0\nGAD QSRVSRC *FILE PF Service Programs Binder Source 1 120 0\nGAD QS36PRC *FILE PF 1 132 0\nGAD QTXTSRC *FILE PF \u001a\u001a\u001a\"\u001a\u001a\u001a \u001a\u001a\u001a\u001a\u001a\u001a \u001a\u001a\u001a\u001a\u001a\u001a 1 148 0\n\n 22 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nSQL0335: Character conversion resulted in substitution characters.\nSQL0335: Character conversion resulted in substitution characters.\nSQL0335: Character conversion resulted in substitution characters.\nSQL0335: Character conversion resulted in substitution characters.\nSQL0335: Character conversion resulted in substitution characters."
}
/home/GAD: cd "/QSYS.LIB/GAD.LIB/QMDLSRC.FILE" && (ls | wc -l)
{
"code": 0,
"signal": null,
"stdout": "5",
"stderr": ""
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.vscode/cqsh_1
/usr/bin/attr -p /QSYS.LIB/GAD.LIB/QMDLSRC.FILE CCSID
{
"code": 0,
"signal": null,
"stdout": "CCSID=424",
"stderr": ""
}
/home/GAD: cd "/QSYS.LIB/GAD.LIB/QJCRCMDS.FILE" && (ls | wc -l)
{
"code": 0,
"signal": null,
"stdout": "355",
"stderr": ""
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.vscode/cqsh_1
/usr/bin/attr -p /QSYS.LIB/GAD.LIB/QJCRCMDS.FILE CCSID
{
"code": 0,
"signal": null,
"stdout": "CCSID=424",
"stderr": ""
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.vscode/cqsh_1
system "CHKOBJ OBJ(GAD/QCMDSRTST) OBJTYPE(*FILE) AUT(*UPD)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.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 = 'GAD' and SOURCE_FILE = 'QCMDSRTST' 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---------- -------------------- ------ ------------ ---------- ---------- -------------------------------------------------- -------------------- -------------------- --------------------\nGAD 144 0 QCMDSRTST ADDDUR CMD 27 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST ADDDUR_SV CMD 27 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST ADDMBRDBR CMD ADD a MBR to all LFs on a specified PF MBR 25 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST ADDMBRDBRX CMD 23 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST CLCDATDIF CMD Calculate date difference - CLCDATDIF 30 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST CMB CMD chgmsgq qsysopr *break 1 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST CPY2DWHF CMD Create Data Warehouse file and copy data into it 36 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST CRTBNDRPG CMD Create Bound RPG Program 30 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST CRTBNDRPG3 CMD 20 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST CRTRPG2 CMD 14 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST D CMD DP DU DJ 6 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST DLTDBR CMD Delete All LFs of a specified PF 18 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST GETDEVIP CMD 14 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST GETOUTQ CMD 36 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST GET1VALSQL CMD 13 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST LOADDDEX CMD 19 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST LOGSCANSRC CMD SCAN001 - Write PDM scan to database files 23 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST QCMDSRC2 0 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST RMVMBRDBR CMD Delete a MBR from all LFs on a specified PF MBR 25 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST RMVMBRDBRX CMD 23 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST RTVDDSSRC CMD RETRIEVE DDS SOURCE FOR EXISTING FILE 52 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST RTVSQLSRC CMD Retrieve SQL Source for Existing Table 22 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST RTVVARSIZ CMD 10 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST RUNJOBCMD CMD runs arbitrary command in another job 23 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST RUNSQL4XLS CMD 21 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST SNDPGMEML CMD 25 1764081578000 1764081578000\n\n 26 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.vscode/cqsh_1
system "CHKOBJ OBJ(GAD/QCMDSRTST) OBJTYPE(*FILE) AUT(*UPD)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.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 = 'GAD' and SOURCE_FILE = 'QCMDSRTST' and NAME like '%' and TYPE like '%' order by NAME ASC
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n םע תירבע ןויסינ 32 ENGLISH DMC XRBDRBMVMR TSTRSDMCQ 0 441 DAG\n0008751804671 0008751804671 52 RBM FP deificeps a no sFL lla morf RBM a eteleD DMC RBDRBMVMR TSTRSDMCQ 0 441 DAG\n0008751804671 0007751804671 0 2CRSDMCQ TSTRSDMCQ 0 441 DAG\n0008751804671 0008751804671 32 selif esabatad ot nacs MDP etirW - 100NACS DMC CRSNACSGOL TSTRSDMCQ 0 441 DAG\n0008751804671 0008751804671 91 DMC XEDDDAOL TSTRSDMCQ 0 441 DAG\n0008751804671 0008751804671 31 DMC LQSLAV1TEG TSTRSDMCQ 0 441 DAG\n0008751804671 0007751804671 63 DMC QTUOTEG TSTRSDMCQ 0 441 DAG\n0008751804671 0008751804671 41 DMC PIVEDTEG TSTRSDMCQ 0 441 DAG\n0008751804671 0008751804671 81 FP deificeps a fo sFL llA eteleD DMC RBDTLD TSTRSDMCQ 0 441 DAG\n0008751804671 0007751804671 6 JD UD PD DMC D TSTRSDMCQ 0 441 DAG\n0008751804671 0008751804671 41 DMC 2GPRTRC TSTRSDMCQ 0 441 DAG\n0008751804671 0008751804671 02 DMC 3GPRDNBTRC TSTRSDMCQ 0 441 DAG\n0008751804671 0007751804671 03 margorP GPR dnuoB etaerC DMC GPRDNBTRC TSTRSDMCQ 0 441 DAG\n0008751804671 0007751804671 63 ti otni atad ypoc dna elif esuoheraW ataD etaerC DMC FHWD2YPC TSTRSDMCQ 0 441 DAG\n0008751804671 0007751804671 1 kaerb* rposysq qgsmghc DMC BMC TSTRSDMCQ 0 441 DAG\n0008751804671 0007751804671 03 FIDTADCLC - ecnereffid etad etaluclaC DMC FIDTADCLC TSTRSDMCQ 0 441 DAG\n0008751804671 0008751804671 32 DMC XRBDRBMDDA TSTRSDMCQ 0 441 DAG\n0008751804671 0008751804671 52 RBM FP deificeps a no sFL lla ot RBM a DDA DMC RBDRBMDDA TSTRSDMCQ 0 441 DAG\n0008751804671 0007751804671 72 DMC VS_RUDDDA TSTRSDMCQ 0 441 DAG\n0008751804671 0007751804671 72 DMC RUDDDA TSTRSDMCQ 0 441 DAG\n-------------------- -------------------- -------------------- -------------------------------------------------- ---------- ---------- ------------ ------ -------------------- ----------\n DEGNAHC DETAERC SENIL TXET EPYT EMAN ELIF_ECRUOS PSA HTGNEL_DROCER YRARBIL\n 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST RTVDDSSRC CMD RETRIEVE DDS SOURCE FOR EXISTING FILE 52 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST RTVSQLSRC CMD Retrieve SQL Source for Existing Table 22 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST RTVVARSIZ CMD 10 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST RUNJOBCMD CMD runs arbitrary command in another job 23 1764081577000 1764081578000\nGAD 144 0 QCMDSRTST RUNSQL4XLS CMD 21 1764081578000 1764081578000\nGAD 144 0 QCMDSRTST SNDPGMEML CMD 25 1764081578000 1764081578000\n\n 26 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
/home/GAD: LC_ALL=EN_US.UTF-8 /home/GAD/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
SELECT PTF_GROUP_TARGET_RELEASE as OS, PTF_GROUP_LEVEL AS TR FROM QSYS2.GROUP_PTF_INFO WHERE PTF_GROUP_DESCRIPTION = 'TECHNOLOGY REFRESH' AND PTF_GROUP_STATUS = 'INSTALLED' ORDER BY PTF_GROUP_TARGET_RELEASE, PTF_GROUP_LEVEL DESC LIMIT 1
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nOS TR \n------ -----------\nV7R5M0 5\n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8."
}
/home/GAD: BUILDLIB="QGPL" export BUILDLIB && CURLIB="QGPL" export CURLIB && USERNAME="GAD" export USERNAME && HOST="192.168.168.85" export HOST && HOME="/home/GAD" export HOME && WORKDIR="/home/GAD" export WORKDIR && LIBLS="GAD CAELIBD HULLIBD DWHD SHAKMLCL1 SHAKMLCL1J SHAKMLCL2 PRFLIB PRFLIBD RTLIB RTLIBD GVIALIB GVIALIBD LOGLIB MMSLIB MMSLIBD ACUMLIB DSTRLIB DSTRLIBD DCMTLIB DCMTLIBD IPILIB IPILIBD QTEMP QGPL ACUMGPL" export LIBLS && env
{
"code": 0,
"signal": null,
"stdout": "BUILDLIB=QGPL\nCURLIB=QGPL\nHOME=/home/GAD\nHOST=192.168.168.85\nLIBLS=GAD CAELIBD HULLIBD DWHD SHAKMLCL1 SHAKMLCL1J SHAKMLCL2 PRFLIB PRFLIBD RTLIB RTLIBD GVIALIB GVIALIBD LOGLIB MMSLIB MMSLIBD ACUMLIB DSTRLIB DSTRLIBD DCMTLIB DCMTLIBD IPILIB IPILIBD QTEMP QGPL ACUMGPL\nLOGIN=gad\nLOGNAME=gad\nMAIL=/var/spool/mail/gad\nPATH=/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin\nSHELL=/QOpenSys/usr/bin/bsh\nSSH_CLIENT=192.168.168.120 52975 22\nSSH_CONNECTION=192.168.168.120 52975 192.168.168.85 22\nTZ=<ILST>-2<ILDT>,M3.5.5,M10.5.0\nUSER=gad\nUSERNAME=GAD\nWORKDIR=/home/GAD",
"stderr": ""
}