MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Connect Direct issue on the Square bracket

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Other Technical Topics
View previous topic :: View next topic  
Author Message
nbdtrjk_1
Beginner


Joined: 14 Jun 2021
Posts: 11
Topics: 4

PostPosted: Tue Jul 04, 2023 12:42 am    Post subject: Connect Direct issue on the Square bracket Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12354
Topics: 75
Location: San Jose

PostPosted: Tue Jul 04, 2023 9:58 am    Post subject: Reply with quote

nbdtrjk_1,

Check this link

https://www.ibm.com/support/pages/how-use-codepage-function-when-sending-data-connectdirect-zos-connectdirect-windows

You need to use IBM-1047 for the mainframe side and UTF8 for windows side

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
nbdtrjk_1
Beginner


Joined: 14 Jun 2021
Posts: 11
Topics: 4

PostPosted: Wed Jul 05, 2023 1:01 am    Post subject: Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12354
Topics: 75
Location: San Jose

PostPosted: Wed Jul 05, 2023 10:48 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
nbdtrjk_1
Beginner


Joined: 14 Jun 2021
Posts: 11
Topics: 4

PostPosted: Wed Jul 05, 2023 8:48 pm    Post subject: Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12354
Topics: 75
Location: San Jose

PostPosted: Thu Jul 06, 2023 10:23 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
nbdtrjk_1
Beginner


Joined: 14 Jun 2021
Posts: 11
Topics: 4

PostPosted: Thu Jul 06, 2023 8:32 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Other Technical Topics All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group