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 |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
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 |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12369 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
www.linkedin.com/in/kolusu |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
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 |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12369 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
www.linkedin.com/in/kolusu |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
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 |
|
![](templates/subSilver/images/spacer.gif) |
|
|