On one IBMi I can't open a source member with '£' in the member's name, but on another one it works #2519

benetti-smeup · 2025-02-18T14:44:22Z

Describe the bug
I can't open members with a name that cointans '£'.
We use the extension on two IBM i systems, and it works correctly on one but not on the other.

To Reproduce
Steps to reproduce the behavior:

Go to Member browser
Click on a member with a name that contains '£'
See error

Expected behavior

Open my source member in the editor

Screenshots

Environment in which the error occurs

Extension version v2.14.5
RPGLE language tools v0.28.6
IBM i OS version 7.4

db2util 1.0.12-1

usrprf
LANGID *SYSVAL
CNTRYID *SYSVAL
CCSID *SYSVAL

wrksysval
QCCSID 1144
QCNTRYID IT
QLANGID ITA
QCHRID 695-1144

WRKENVVAR LEVEL(*SYS)
PASE_LANG 'IT_IT'
QIBM_PASE_CCSID '1208'

Output
/home/BENMAR: /home/BENMAR/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
Call QSYS2.QCMDEXC('CHGJOB CCSID(280)');
CREATE OR REPLACE ALIAS W_BENMARVS.TEMP_14ABC61BA512EA10E29B0B7958C12F89A62DF577 for "W_BENMAR"."SRC"("A£UTX26")
/home/BENMAR: /home/BENMAR/.vscode/cqsh_1
/usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#UTX26.MBR CREATE_TIME MODIFY_TIME DATA_SIZE
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": "attr: 001-2248 Errore rilevato nell'ottenere gli attributi per il file /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#UTX26.MBR. Questo percorso o indirizzario non esiste."
}

Environment in which the extension works

Extension version v2.14.5
RPGLE language tools v0.28.6
IBM i OS version 7.5

db2util 1.0.12-1

usrprf
LANGID *SYSVAL
CNTRYID *SYSVAL
CCSID *SYSVAL

wrksysval
QCCSID 65535
QCNTRYID IT
QLANGID ITA
QCHRID 697-280

WRKENVVAR LEVEL(*SYS)
PASE_LANG 'IT_IT'
QIBM_PASE_CCSID '1208'

Output
/home/BENMAR: /home/BENMAR/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
Call QSYS2.QCMDEXC('CHGJOB CCSID(280)');
CREATE OR REPLACE ALIAS W_BENMARVS.TEMP_220535EAC6C3441BB23B646BF1D2ADF1796AE358 for "W_BENMAR"."SRC"("A£_159_A1")
/home/BENMAR: /home/BENMAR/.vscode/cqsh_1
/usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#_159_A1.MBR CREATE_TIME MODIFY_TIME DATA_SIZE
{
"code": 0,
"signal": null,
"stdout": "DATA_SIZE=48858\nCREATE_TIME=Wed May 1 12:00:10 2024\nMODIFY_TIME=Wed May 1 20:38:30 2024",
"stderr": ""
}

worksofliam · 2025-02-18T14:49:25Z

Thanks for sending the logs. Any chance you can send the entire log after connecting and reloading? (Right click on your server -> connect and reload)

benetti-smeup · 2025-02-18T15:01:58Z

Sure.

complete_log.zip

benetti-smeup · 2025-02-19T09:40:37Z

I have done some tests connected via ssh.

-bash-5.2$ /usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#UTX26.MBR CREATE_TIME MODIFY_TIME DATA_SIZE
attr: 001-2248 Errore rilevato nell'ottenere gli attributi per il file /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#UTX26.MBR. Questo percorso o indirizzario non esiste.

with £ in the member name it works.
-bash-5.2$ /usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A£UTX26.MBR CREATE_TIME MODIFY_TIME DATA_SIZE
DATA_SIZE=25296
CREATE_TIME=Wed Nov 14 16:54:58 2012
MODIFY_TIME=Tue Feb 25 14:22:12 2014

But if I get the list of the source file content, I get member names with #.
-bash-5.2$ cd /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/
-bash-5.2$ ls
A#UTX26.MBR B#GPE3.MBR B#UT13A.MBR JAHTM_AZA.MBR LOA06_SE.MBR PAGESIZE.MBR TXFOOT.MBR X1GAGE0F.MBR X1TABE_01.MBR XSNDLIB.MBR
AUTLIB.MBR B#LOG4.MBR B#UT20E.MBR JAJ180.MBR LOA15_GF.MBR RESTRS.MBR VERAPG0F_A.MBR X1GAGE0I.MBR X1TASK09.MBR XWF999.MBR
AUTLIB_RO.MBR B#MENU.MBR B#UT99.MBR JAJAT0D.MBR LOA36_SI.MBR RETSQLDATA.MBR WFPROM0OL.MBR X1GRN01.MBR X1TODO1.MBR XWFCTR.MBR
B#DIR4.MBR B#MENU0V.MBR B#UTB2A.MBR JASEP2.MBR LOOPOAV.MBR RSTLIB.MBR X1AG98.MBR X1GRN01_O.MBR X1TODO2.MBR
B#DIR40V.MBR B#OA_AR_HU.MBR C#SUP_01.MBR JASEP20V.MBR LOSUP_Q3.MBR TESTWFD.MBR X1AG98_AS.MBR X1GRN01_O2.MBR X1TODO4.MBR
B#FIND0F.MBR B#OA_H3_02.MBR C#SUP_04.MBR JATRE_01C.MBR MIN_RPG.MBR TSTCUR.MBR X1AG98_ND.MBR X1NTFMSG.MBR X1UT60C.MBR
B#FINDO03T.MBR B#OA_OJ.MBR C5MU2.MBR JATRE_02C.MBR MIN_RPG2.MBR TSTCUR0V.MBR X1AG98_SAV.MBR X1SAVF.MBR X1UTX47.MBR
B#FIND_03T.MBR B#OA_OJ2.MBR CARIDX.MBR JATRE_18C.MBR MUTE10_53.MBR TSTJASX.MBR X1AGEBMA.MBR X1SER_21.MBR X1UTX47CL.MBR
B#G08G.MBR B#SER_43.MBR D5APM2_01.MBR JAUTX03.MBR MUTE10_54.MBR TSTXXX.MBR X1AGHD.MBR X1SER_47.MBR X1VAVA_02.MBR
B#G08G0V.MBR B#SER_82.MBR DECLOG0.MBR LOA03_SE.MBR MUTE10_55.MBR TSTXXX0V.MBR X1FILOCC.MBR X1SHAR0F_A.MBR X1_001.MBR
B#G08_SE.MBR B#SQLD01.MBR EXTMBR.MBR LOA03_SE_2.MBR MUTE10_56.MBR TURNI.MBR X1FOREC.MBR X1SYSSPC.MBR XSNDBMA.MBR

benetti-smeup · 2025-02-19T13:37:20Z

I tried with version 2.13.0 and it works.
I can open members with a name that contains '£'.
There is a problem on the object browser: if a source file name contains '£' i can't list its members.
But if I try with CTR+ALT+P I can open a member in a source file with a name that contains '£'.

worksofliam · 2025-02-19T14:17:31Z

Well the good news is that CCSIDs are working as expected and I know that because of the output in the logs: ✅

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>\nDB20000I  THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\n  ?>\n\nLOCAL \n------\n£§$   \n\n  1 RECORD(S) SELECTED.",
    "stderr": "CPC2206:  È stata modificata la proprietà dell'oggetto QZSHSYSTEM in QTEMP di tipo *USRSPC."
}

And I can see the list is showing the pound sign correctly in the result set: ✅

LIBRARY    RECORD_LENGTH        ASP    SOURCE_FILE  NAME       TYPE       TEXT                                               LINES                CREATED              CHANGED             
---------- -------------------- ------ ------------ ---------- ---------- -------------------------------------------------- -------------------- -------------------- --------------------
W_BENMAR                    112      0 SRC          A£UTX26    SQLRPGLE   UTIL Attivazione requisiti Omnifind                                 248        1352912098000        1393338132000

But it's going wrong when we are fetching the attributes of this file: ❌

/home/BENMAR: /home/BENMAR/.vscode/cqsh_1
/usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#UTX26.MBR CREATE_TIME MODIFY_TIME DATA_SIZE
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": "attr: 001-2248 Errore rilevato nell'ottenere gli attributi per il file /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#UTX26.MBR.  Questo percorso o indirizzario non esiste."
}

But funnily enough does fetch the member correctly! ✅

/home/BENMAR: /home/BENMAR/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
Call QSYS2.QCMDEXC('CHGJOB CCSID(280)');
CREATE TABLE QTEMP.O_X5QY1 AS (select srcdat, rtrim(translate(srcdta, x'2F', x'25')) as srcdta from W_BENMARVS.TEMP_14ABC61BA512EA10E29B0B7958C12F89A62DF577) WITH DATA;
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QTEMP/O_X5QY1 *FIRST) TOSTMF(''/tmp/vscodetemp-O_rtoMprhZ'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')
{
    "code": 0,
    "signal": null,
    "stdout": "DB2>\nDB20000I  THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\nDB20000I  THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\n  ?>\nDB20000I  THE SQL COMMAND COMPLETED SUCCESSFULLY.",
    "stderr": "CPC2206:  È stata modificata la proprietà dell'oggetto QCPEXTEMPS in QTEMP di tipo *USRSPC.\nCPC2206:  È stata modificata la proprietà dell'oggetto QACP222575 in QTEMP di tipo *USRSPC.\nCPC2206:  È stata modificata la proprietà dell'oggetto QACEXFLD12 in QTEMP di tipo *USRSPC.\nCPC2206:  È stata modificata la proprietà dell'oggetto Q2T1TT02 in QTEMP di tipo *FILE.\nCPC2958:  Tutti i record copiati dal file O_X5QY1 in QTEMP\nCPC2206:  È stata modificata la proprietà dell'oggetto QZSHSYSTEM in QTEMP di tipo *USRSPC."
}

@sebjulliand didn't you make a new change/fix to getAttributes recently? Maybe this has to do with the fact that we're passing in the system variant to cqsh, which in theory handles the variant chars? Any thoughts?

/home/BENMAR: /home/BENMAR/.vscode/cqsh_1
/usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#UTX26.MBR

@benetti-smeup did show the ls result, which has the system variant in it:

-bash-5.2$ cd /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/
-bash-5.2$ ls
A#UTX26.MBR

I am seeing a lot of CPD8C23 and CPF8C87, but this is system specific.

sebjulliand · 2025-02-19T16:07:11Z

@worksofliam that's weird...I can work with members in CCSID 297 with variants without problems.
@benetti-smeup can you try to switch to the pre-release and use "Reload config and connect" when connecting? Just to see if it would make any difference. Thanks

benetti-smeup · 2025-02-19T16:21:14Z

Same problem with the pre-release.
Here the log.

log_prerelease.zip

sebjulliand · 2025-02-19T16:48:26Z

@worksofliam on my CCSID 297 LPAR too, attr receives the american variants:

/home/SJULLIAND: /home/SJULLIAND/.vscode/cqsh_1
/usr/bin/attr -p /QSYS.LIB/@MAZING.LIB/[email protected]/H@L@#@\$.MBR CREATE_TIME MODIFY_TIME DATA_SIZE
{
    "code": 0,
    "signal": null,
    "stdout": "DATA_SIZE=306\nCREATE_TIME=Fri Nov 15 23:46:57 2024\nMODIFY_TIME=Fri Nov 15 23:47:00 2024",
    "stderr": ""
}

The same kind of call on @benetti-smeup's LPAR returns an error

/home/BENMAR: /home/BENMAR/.vscode/cqsh_1
/usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#UTX26.MBR CREATE_TIME MODIFY_TIME DATA_SIZE
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": "attr: 001-2248 Errore rilevato nell'ottenere gli attributi per il file /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#UTX26.MBR.  Questo percorso o indirizzario non esiste."
}

Infact, in the first post, we see calls on both working and not working LPAR are of the same kind.

The only difference is that QCCSID is undefined where it works, and set to 1144 where it doesn't.

@benetti-smeup , sorry to ask you to go through all these hoops and loops, but, can you check if it works with 2.13.0 on the LPAR that works with 2.14.5 as well ? Or if it breaks? (like, each LPAR works with a specific version of the extension, but not the same).

benetti-smeup · 2025-02-19T17:08:38Z

@sebjulliand
2.13.0 works on both LPAR (and on both LPAR there is the problem on the object browser with source file with a name that contains '£')
Thanks

sebjulliand · 2025-02-20T10:18:56Z

Which means you can't list these members on either LPAR with 2.13.0?

benetti-smeup · 2025-02-20T10:42:31Z

Precisely.

worksofliam · 2025-02-21T03:01:53Z

@sebjulliand @benetti-smeup I am not 100% following with Macro's responses.

So you can't open the member in either 2.13.0 or 2.14.5?

benetti-smeup · 2025-02-24T09:34:34Z

Using 2.13.0 i can open the member with CTR+ALT+P but i can't list members of a source file with a name that contains '£' using object browser.
Using 2.14.5 i can list members of a source file with a name that contains '£' using object browser but i can't open the members (neither from object browser or with CTR+ALT+P)

benetti-smeup · 2025-02-27T17:39:53Z

Is there any other test I can do to help understand the issue?

benetti-smeup · 2025-03-04T11:18:08Z

I tried with v.2.15.0 and I have the same issue.

worksofliam · 2025-03-04T13:27:03Z

@benetti-smeup There is a chance that #2546 may solve the issue, and a new release will be out with that shortly.

The LC_ALL here was removed around 2.14, and we're adding it back in 2.15.1: https://github.com/codefori/vscode-ibmi/blob/2.13.0/src/api/IBMi.ts#L598

Possibly here where the bug is happening (No LC_ALL): 84d21dd#diff-af91aaa8436f73c4457121b35da47e46d53459b47f044b7dbdb78ea785cb1824R1449

worksofliam · 2025-03-04T13:45:15Z

@benetti-smeup 2.15.1 is out now. Give that a try!

benetti-smeup · 2025-03-04T14:29:32Z

I tried with v.2.15.1 but I have the same issue.
Here the log.

log.zip

worksofliam · 2025-03-05T18:49:30Z

@SanjulaGanepola and I have been looking into this.

Are you able to share the steps of how you created a member with a £? In theory, it's not a valid character for an object, so we're having trouble creating a test case.

Additionally: if they were created in a green screen, what CCSID is the client session setup with?

benetti-smeup · 2025-03-06T11:38:02Z

In a 5250 session (client ccsid 1144, job ccsid 1144, default ccsid 1144)

CRTSRCPF FILE(W_BENMAR/SRCTST1) CCSID(1144)
ADDPFM FILE(W_BENMAR/SRCTST1) MBR(A£002) SRCTYPE(RPGLE)

I can create source files with '£', too
CRTSRCPF FILE(W_BENMAR/X£SRC) CCSID(1144)

worksofliam · 2025-03-06T11:39:48Z

@benetti-smeup Is it still the case that it works on one system and not the other?

benetti-smeup · 2025-03-06T11:42:04Z

Yes.

worksofliam · 2025-03-06T11:59:51Z

@benetti-smeup on the system that does not work, can you try and create a member with the name that works on the other system?

A£_159_A1

benetti-smeup · 2025-03-06T13:19:39Z

Done. Same problem.
Here the log.

log_20250306.zip

worksofliam · 2025-03-06T13:24:30Z

@benetti-smeup What happens if you run the command from a shell manually? Preferably bash.

/usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRCTST1.FILE/A#_159_A1.MBR CREATE_TIME MODIFY_TIME DATA_SIZE

benetti-smeup · 2025-03-06T13:31:40Z

-bash-5.2$ /usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRCTST1.FILE/A#_159_A1.MBR CREATE_TIME MODIFY_TIME DATA_SIZE
attr: 001-2248 Errore rilevato nell'ottenere gli attributi per il file /QSYS.LIB/W_BENMAR.LIB/SRCTST1.FILE/A#_159_A1.MBR. Questo percorso o indirizzario non esiste.

but using '£' instead of '#'
-bash-5.2$ /usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRCTST1.FILE/A£ _159_A1.MBR CREATE_TIME MODIFY_TIME DATA_SIZE
DATA_SIZE=10404
CREATE_TIME=Thu Mar 6 14:14:56 2025
MODIFY_TIME=Wed Jan 2 17:19:43 2013

benetti-smeup · 2025-03-06T14:28:24Z

@benetti-smeup Ok, hopefully this will be the last thing:

For the system that does not work, can you please connect and reload and share the entire output?

sure. only connect and realod or try to open the member too?

worksofliam · 2025-03-06T14:28:49Z

@benetti-smeup Just connect and reload should be enough as it will return some information I am looking for.

benetti-smeup · 2025-03-06T14:30:52Z

@worksofliam
connection_output.zip

worksofliam · 2025-03-06T14:33:41Z

@benetti-smeup Sadly that's not quite right. I need the log directly after you connect and reload please. Looks like those logs had some lists in them.

benetti-smeup · 2025-03-06T14:41:50Z

connection_output2.zip

worksofliam · 2025-03-06T14:45:26Z

Alrighty, I think I've come to a conclusion on the issue. Your job CCSID and SSHD CCSID match, so it's likely we don't need to convert in that instance. I will keep you posted.

benetti-smeup · 2025-03-06T14:48:59Z

Thanks!

worksofliam · 2025-03-06T16:00:10Z

@benetti-smeup Please try the build here: #2556

benetti-smeup · 2025-03-06T16:31:04Z

This build works on the system that previously didn't work (ccsid 1144/1144), but doesn't work on the system that previously worked (280/65535).

In the output on system (280/65535) I see

/usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A£_159_02.MBR CREATE_TIME MODIFY_TIME DATA_SIZE
{
    "code": 1,
    "signal": null,
    "stdout": "",
    "stderr": "attr: 001-2248 Errore rilevato nell'ottenere gli attributi per il file /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A£_159_02.MBR.  Questo percorso o indirizzario non esiste."
}

instead of

/usr/bin/attr -p /QSYS.LIB/W_BENMAR.LIB/SRC.FILE/A#_159_02.MBR CREATE_TIME MODIFY_TIME DATA_SIZE

worksofliam · 2025-03-06T16:33:40Z

@benetti-smeup Can you please send the logs after a connect and reload of the system that is not working?

Thanks!

benetti-smeup · 2025-03-06T16:46:32Z

Here the output.
connection_output.zip

worksofliam · 2025-03-06T16:49:39Z

@benetti-smeup A brand new build is available, please try it out:

#2556 (comment)

benetti-smeup · 2025-03-06T17:07:56Z

with this version on the system (280/65535) is much slower listing the members and trying to open a member with '£' it seems to be in a loop.

worksofliam · 2025-03-06T17:12:48Z

@SanjulaGanepola could this be your error ^ appearing again?

SanjulaGanepola · 2025-03-06T17:16:18Z

Yup. Let me put that specific change right now into a branch and if it looks good, maybe merge into main or your branch?

worksofliam · 2025-03-06T17:39:30Z

@benetti-smeup Another new build is ready for you:

#2556 (comment)

benetti-smeup · 2025-03-06T17:51:48Z

Now on the system (1144/1144) I can open members with '£' and members of source files with '£' and I can list members of source files with '£'.
On the system (280/65535) I can open members with '£' but I can't open or list members of source files with '£'. I can list members with '£' of source files without '£'.

worksofliam · 2025-03-06T17:59:36Z

On the system (280/65535) I can open members with '£' but I can't open or list members of source files with '£'. I can list members with '£' of source files without '£'.

Any chance you can explain this a little more? I don't understand. At first you say you can open, and then you can't? Cheers!

benetti-smeup · 2025-03-06T18:08:08Z

On the system (280/65535) i can open W_BENMAR/SRC/A£ _159_A1.RPGLE but I can't open W_BENMAR/£UI_SRC/A£ _159_A1.RPGLE or W_BENMAR/£UI_SRC/AUTLIB.RPGLE.
The problem is with source files with '£'.

worksofliam · 2025-03-06T18:16:50Z

@benetti-smeup Can you please share the output logs of those happening? Thanks!!

worksofliam · 2025-03-06T20:01:09Z

@benetti-smeup Yet another new build is ready for you to try: #2556 (comment)

Thanks!

benetti-smeup · 2025-03-06T20:04:37Z

@benetti-smeup Can you please share the output logs of those happening? Thanks!!

/home/BENMAR: LC_ALL=EN_US.UTF-8 /home/BENMAR/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
Call QSYS2.QCMDEXC('CHGJOB CCSID(280)');
CREATE TABLE QTEMP.O_SF8IG AS (select cast( SYSTEM_SCHEMA_NAME as char( 10 ) ) as SYSTEM_SCHEMA_NAME , ifnull( cast( SCHEMA_TEXT as char( 50 ) ), '' ) as SCHEMA_TEXT from QSYS2.SYSSCHEMAS order by 1) WITH DATA;
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QTEMP/O_SF8IG *FIRST) TOSTMF(''/tmp/vscodetemp-O_NT1iGVx7'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')
{
"code": 0,
"signal": null,
"stdout": "DB2>\nDB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\nDB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\n ?>\nDB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.",
"stderr": "CPFA0A9: L'oggetto non è stato trovato. L'oggetto è EN_US.UTF-8.\nCPC2206: È stata modificata la proprietà dell'oggetto QCPEXTEMPS in QTEMP di tipo *USRSPC.\nCPC2206: È stata modificata la proprietà dell'oggetto QACP928053 in QTEMP di tipo *USRSPC.\nCPC2206: È stata modificata la proprietà dell'oggetto QACEXFLD12 in QTEMP di tipo *USRSPC.\nCPC2206: È stata modificata la proprietà dell'oggetto Q0T136 in QTEMP di tipo *FILE.\nCPC2958: Tutti i record copiati dal file O_SF8IG in QTEMP\nCPC2206: È stata modificata la proprietà dell'oggetto QZSHSYSTEM in QTEMP di tipo *USRSPC."
}

/home/BENMAR: LC_ALL=EN_US.UTF-8 /home/BENMAR/.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
Call QSYS2.QCMDEXC('CHGJOB CCSID(280)');
CREATE TABLE QTEMP.O_UCWGD AS (select * from table(W_BENMARVS.GETMBRINFO('W_BENMAR', '#UI_SRC', 'A#_159_A1'))) WITH DATA;
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QTEMP/O_UCWGD *FIRST) TOSTMF(''/tmp/vscodetemp-O_fBfHM9u9'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')
/home/BENMAR: rm -rf "/tmp/vscodetemp-O_NT1iGVx7"
{
"code": 0,
"signal": null,
"stdout": "DB2>\nDB20000I THE SQL COMMAND COMPLETED SUCCESSFULLY.\nDB2>\n\n **** CLI ERROR *****\n SQLSTATE: 38501\nNATIVE ERROR CODE: -443\n \nDB2>\n ?>\n\n **** CLI ERROR *****\n SQLSTATE: 38501\nNATIVE ERROR CODE: -443\nIl comando di copia si è interrotto a causa di un errore.",
"stderr": "CPFA0A9: L'oggetto non è stato trovato. L'oggetto è EN_US.UTF-8.\nCPF9812: Non trovato il file #UI_SRC nella libreria W_BENMAR.\nSQL0443: Il programma trigger o una routine esterna ha rilevato un errore.\nCPF503E: Errore di funzione definita dall'utente sul membro QSQPTABL.\nCPF503E: Errore di funzione definita dall'utente sul membro QSQPTABL.\nSQL0443: Il programma trigger o una routine esterna ha rilevato un errore.\nSQL0443: Il programma trigger o una routine esterna ha rilevato un errore.\nCPC2206: È stata modificata la proprietà dell'oggetto QCPEXTEMPS in QTEMP di tipo *USRSPC.\nCPF5715: Non trovato il file O_UCWGD nella libreria QTEMP.\nCPF2817: Il comando di copia si è interrotto a causa di un errore.\nSQL0443: Il programma trigger o una routine esterna ha rilevato un errore.\nSQL0443: Il programma trigger o una routine esterna ha rilevato un errore.\nCPC2206: È stata modificata la proprietà dell'oggetto QZSHSYSTEM in QTEMP di tipo *USRSPC."
}

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

benetti-smeup · 2025-03-06T20:10:22Z

@benetti-smeup Yet another new build is ready for you to try: #2556 (comment)

Thanks!

Same issue.

worksofliam · 2025-03-06T20:19:14Z

@benetti-smeup I will need more logs please for the errors. Your last comment didn't have any.

benetti-smeup · 2025-03-07T08:26:47Z

Here the log.
log20250307.zip

worksofliam · 2025-03-07T15:16:57Z

@benetti-smeup A new build is available for you here: #2556 (comment)

benetti-smeup · 2025-03-07T16:13:09Z

@worksofliam
Same issue.
Is there a way to export all the logs? The output panel is not complete as logs get overwritten.

worksofliam · 2025-03-07T16:35:07Z

@benetti-smeup no, sadly we have to clear them oversize VS Code slows down.

I'm actually leaving after today for a week holiday, so hopefully someone else can step up in my absence, though no promises.

There are two options for this issue:

Debug the issue yourself in my absence, or
When I get back, we'll have to jump on a teams call or something because there is no way we can keep debugging like this.

worksofliam added the needs-investigation The team should look into this label Feb 18, 2025

wimjongman mentioned this issue Mar 3, 2025

Mass source download fails on zero record members #2513 #2526

Merged

worksofliam mentioned this issue Mar 4, 2025

Set locale via LC_ALL when using cqsh or qsh #2546

Merged

1 task

SanjulaGanepola mentioned this issue Mar 6, 2025

Fix quoted name and variant character support #2555

Closed

18 tasks

worksofliam linked a pull request Mar 6, 2025 that will close this issue

Convert input handling based on CCSID scenarios #2556

Open

worksofliam added the bug A confirmed issue when something isn't working as intended label Mar 7, 2025

On one IBMi I can't open a source member with '£' in the member's name, but on another one it works #2519

On one IBMi I can't open a source member with '£' in the member's name, but on another one it works #2519

Comments

benetti-smeup commented Feb 18, 2025

worksofliam commented Feb 18, 2025

benetti-smeup commented Feb 18, 2025

benetti-smeup commented Feb 19, 2025 • edited Loading

benetti-smeup commented Feb 19, 2025

worksofliam commented Feb 19, 2025

sebjulliand commented Feb 19, 2025

benetti-smeup commented Feb 19, 2025

sebjulliand commented Feb 19, 2025

benetti-smeup commented Feb 19, 2025

sebjulliand commented Feb 20, 2025

benetti-smeup commented Feb 20, 2025

worksofliam commented Feb 21, 2025

benetti-smeup commented Feb 24, 2025

benetti-smeup commented Feb 27, 2025

benetti-smeup commented Mar 4, 2025

worksofliam commented Mar 4, 2025 • edited Loading

worksofliam commented Mar 4, 2025

benetti-smeup commented Mar 4, 2025

worksofliam commented Mar 5, 2025 • edited Loading

benetti-smeup commented Mar 6, 2025 • edited Loading

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025 • edited Loading

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

SanjulaGanepola commented Mar 6, 2025

worksofliam commented Mar 6, 2025 • edited Loading

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

benetti-smeup commented Mar 6, 2025

worksofliam commented Mar 6, 2025

benetti-smeup commented Mar 7, 2025

worksofliam commented Mar 7, 2025

benetti-smeup commented Mar 7, 2025

worksofliam commented Mar 7, 2025

benetti-smeup commented Feb 19, 2025 •

edited

Loading

worksofliam commented Mar 4, 2025 •

edited

Loading

worksofliam commented Mar 5, 2025 •

edited

Loading

benetti-smeup commented Mar 6, 2025 •

edited

Loading

worksofliam commented Mar 6, 2025 •

edited

Loading

worksofliam commented Mar 6, 2025 •

edited

Loading