| View previous topic :: View next topic |
| Author |
Message |
nbdtrjk_1
Beginner
Joined: 14 Jun 2021
Posts: 11
Topics: 4
|
 Posted: Tue Jul 04, 2023 12:42 am Post subject: Connect Direct issue on the Square bracket |
 |
|
All,
I am sending mainframe file to a Windows machine via Connect Direct, the transmission was successful and the file landed at the target system.
but there is an issue on the content, in the mainframe, there is a square bracket "[]," however in the Ascii version, its an unprintable format(see below).
| Code: |
[ is converted to â
[ - X'BA'
â - Ascii is 131
|
Note: other special chars like %, @,( ),$ etc. are transmitted correctly except the square bracket.
any ideas? What's the problem?
Thanks |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12367
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
nbdtrjk_1
Beginner
Joined: 14 Jun 2021
Posts: 11
Topics: 4
|
| Posted: Wed Jul 05, 2023 1:01 am Post subject: |
|
|
Hi,
I used like SYSOPTS="CODEPAGE=(IBM-1047,UTF-8)" but still conversion is not coming properly.
| Code: |
STEP2 COPY FROM (DSN=YOURHLQ1.CODEPAGE.TEST.FILE -
SYSOPTS="CODEPAGE=(IBM-1047,UTF8)" -
DISP=SHR ) -
TO (DSN='C:\CODEPAGE.TEST1.TXT' DISP=RPL -
SYSOPTS="DATATYPE(TEXT) XLATE(NO)" )
|
instead I used CODEPAGE=(37,UTF-8), this resolved the square bracket issue but decimal values not converted properly. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12367
Topics: 75
Location: San Jose
|
| Posted: Wed Jul 05, 2023 10:48 am Post subject: |
|
|
| nbdtrjk_1 wrote: | | this resolved the square bracket issue but decimal values not converted properly. |
nbdtrjk_1,
What do you mean by decimal values? If the data on the mainframe is numeric (Binary, Zoned decimal with sign overpunch or packed decimal) then you need to convert them to readable format, before you can send them to PC side.
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
nbdtrjk_1
Beginner
Joined: 14 Jun 2021
Posts: 11
Topics: 4
|
| Posted: Wed Jul 05, 2023 8:48 pm Post subject: |
|
|
Hi Kolusu,
I have numeric decimal values in the mainframe file like 0000.1234(Readable format only), but the PC file received after transmission has 0000Ý1234, which is incorrect.
however, 'MR.ABC' (named with a dot), which is successfully translated into PC
seems some issue on the '.' conversion logic between numeric & Alpha. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12367
Topics: 75
Location: San Jose
|
| Posted: Thu Jul 06, 2023 10:23 am Post subject: |
|
|
nbdtrjk_1,
what is the HEX value of DOT in the numeric field? It should X'4B'. If it is something different then it explains why you have bad values on PC side?
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
nbdtrjk_1
Beginner
Joined: 14 Jun 2021
Posts: 11
Topics: 4
|
| Posted: Thu Jul 06, 2023 8:32 pm Post subject: |
|
|
Hi,
yes. Its X'4B'.
We reported this issue to C: D team and they did minor change on the Transaction Table and started working now. Thanks for your help Kolusu.
Cheers |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
