TCPIP translate tables
Jim McAlpine
after translate tables for code page 285 (UK English) to 1252 (Windows) so
that I can use them for a customized version to include the "correct" square
brackets for FTP translation. Has anyone done this previously that could
supply me with the required source.
Jim McAlpine
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to list...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
Joel C. Ewing
> I'm looking in TCPIP.SEZATCPX but it doesn't contain what I require. I'm
> after translate tables for code page 285 (UK English) to 1252 (Windows) so
> that I can use them for a customized version to include the "correct" square
> brackets for FTP translation. Has anyone done this previously that could
> supply me with the required source.
>
> Jim McAlpine
I would suspect that Unicode Services would already have support for the
code pages in question, in which case creating a translate table would
be totally unnecessary work: just add the appropriate "SBDATACONN
(x,y)" statement to TCPPARMS FTPDATA and/or FTSDATA. Or you can
temporarily override the default by specifying the "sbdataconn"
parameter with "quote site" (from a remote FTP client) or "locsite"
(from FTP client on MVS).
In our environment we set the default to
"SBDATACONN (IBM-1047,ISO8859-1)".
--
Joel C. Ewing, Fort Smith, AR jce...@acm.org
Jim McAlpine
> On 10/05/2010 10:40 AM, Jim McAlpine wrote:
>
>> I'm looking in TCPIP.SEZATCPX but it doesn't contain what I require. I'm
>> after translate tables for code page 285 (UK English) to 1252 (Windows) so
>> that I can use them for a customized version to include the "correct"
>> square
>> brackets for FTP translation. Has anyone done this previously that could
>> supply me with the required source.
>>
>> Jim McAlpine
>>
> ...
> I would suspect that Unicode Services would already have support for the
> code pages in question, in which case creating a translate table would be
> totally unnecessary work: just add the appropriate "SBDATACONN (x,y)"
> statement to TCPPARMS FTPDATA and/or FTSDATA. Or you can temporarily
> override the default by specifying the "sbdataconn" parameter with "quote
> site" (from a remote FTP client) or "locsite" (from FTP client on MVS).
>
> In our environment we set the default to
> "SBDATACONN (IBM-1047,ISO8859-1)".
>
> --
> Joel C. Ewing, Fort Smith, AR jce...@acm.org
>
>
You haven't read my post properly. I want to make a customized version of
285-1252.
Jim McAlpine
Steve Comstock
> I'm looking in TCPIP.SEZATCPX but it doesn't contain what I require. I'm
> after translate tables for code page 285 (UK English) to 1252 (Windows) so
> that I can use them for a customized version to include the "correct" square
> brackets for FTP translation. Has anyone done this previously that could
> supply me with the required source.
>
> Jim McAlpine
Jim,
Well if you simply do binary FTPs, our FileRepackager software
can convert between single byte code pages (as well as change
record format and size and record delimiter). We provide several
translation tables as well as instructions on how to build your
own tables for use with FileRepackager.
Visit http://www.trainersfriend.com/TTFUtils/FRP-home.html
there you will see links to the supporting documentation. Take
a look at the Installation and Customization Guide. Near the
end you will find the instructions for setting up your own
translate tables for use with this software.
--
Kind regards,
-Steve Comstock
The Trainer's Friend, Inc.
303-393-8716
http://www.trainersfriend.com
* To get a good Return on your Investment, first make an investment!
+ Training your people is an excellent investment
Jim McAlpine
> Steve, these are not binary ftp's but ascii to ebcdic and vice-versa.
Anyhow, I think I've got what I want from the DB2 SYSIBM.SYSSTRINGS table,
but thanks anyway.
Jim McAlpine
McKown, John
I've done a fast "iconv -l" and it lists both 285 (UK English) and 1252 (Windows). So IBM obviously has this available via Unicode services. But, as I understand it, you need to modify or create a new translate table. I think that you need to read up on Unicode Conversion Services. I'd start here:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IEA2UNA0/3.4
I did a quick try with the following JCL and got some output to start a new conversion table with:
//STEP1 EXEC PGM=CUNMITG1,PARM=(285,1252,R)
//SYSPRINT DD SYSOUT=*
//TABIN DD DISP=SHR,DSN=SYS1.SCUNTBL
// DD DISP=SHR,DSN=SYS3.LI.SCUNTBL <- USER LIBRARY
//CHAROUT DD SYSOUT=*
Take the ouput in CHAROUT and put it in a dataset. Modify it with your changes. JCL similar to the following will then create a new member in a SCUNTBL type dataset. Use an installation DSN, not SYS1.SCUNTBL, for the output.
//STEP1 EXEC PGM=CUNMITG2,PARM=(285,1252,0)
//SYSPRINT DD SYSOUT=*
//TABOUT DD DISP=OLD,DSN=SYS3.LI.SCUNTBL <- USER LIBRARY
//CHARIN DD *
% Character map created on 10/06/2010 at 08:45:04
% by CUNMITG1 Version V1R10
%
...
/*
Now run some JCL similar to:
//CUNMIUTL EXEC PGM=CUNMIUTL,TIME=NOLIMIT
//SYSPRINT DD SYSOUT=*
//TABIN DD DSN=SYS1.SCUNTBL,DISP=SHR
// DD DSN=SYS3.LI.SCUNTBL,DISP=SHR <- USER LIBRARY
//SYSIMG DD DSN=hlq.unicode.images.fb80(CUNIMGnn),DISP=SHR
//SYSIN DD *
/********************************************
* INPUT STATEMENTS FOR THE IMAGE GENERATOR *
********************************************/
NORMALIZE; /* ENABLE NORMALIZATION */
COLLATE; /* ENABLE COLATION */
CASE NORMAL; /* ENABLE TOUPPER AND TOLOWER */
CASE LOCALE; /* ENABLE LOCALE */
CASE SPECIAL; /* ENABLE SPECIAL */
CONVERSION 1047,850; /* EBCDIC -> ASCII */
CONVERSION 850,1047; /* ASCII -> EBCDIC */
CONVERSION 1047,1202;
CONVERSION 1202,1047;
CONVERSION 037,1202;
CONVERSION 1202,037;
CONVERSION 037,850;
CONVERSION 850,037;
CONVERSION 1047,1200;
CONVERSION 1200,1047;
CONVERSION 037,1200;
CONVERSION 1200,037;
CONVERSION 1047,1208;
CONVERSION 1208,1047;
CONVERSION 037,1208;
CONVERSION 1208,037;
CONVERSION 285,1252;
CONVERSION 1252,285;
CONVERSION 285,1252,0; /* my 285 to 1252 table! */
/*
Copy the CUNIMGnn member into your proper system Unicode library (which needs to be part of the system PARMLIB concatenation), update the CUNUNInn member of PARMLIB, then T UNI=nn to load in the image. Now you should be ready, finally, to use this in your FTP job.
//FTP EXEC PGM=FTP,PARM='/(EXIT'
//OUTPUT DD SYSOUT=*
//INPUT DD *
windows-server
userid
password
LOCSITE SDB=(285,1252)
put something
...
quit
/*
//CEEOPTS DD *
ENVAR('_ICONV_TECHNIQUE=0LMREC,_ICONV_MODE=C')
/*
//
PLEASE NOTE THE CEEOPTS. If it is not included, you will only get the standard 285->1252 translation. Note that the 0 in the _ICONV_TECHNIQUE=0LMREC must be the same number you used when you generated the Unicode image with the CUNMITG2 program.
--
John McKown
Systems Engineer IV
IT
Administrative Services Group
HealthMarkets(r)
9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-691-6183 cell
john....@healthmarkets.com * www.HealthMarkets.com
Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM
Jim McAlpine
<John....@healthmarkets.com>wrote:
> I know the OP got another solution. But I wanted to see how to use Unicode
> services with FTP. And since it was definately a learning experience for me,
> I decided to share. If somebody wants to put this information on their z/OS
> web site, that would be nice. I don't have a web site. Now, can this somehow
> also be used for other TCPIP work? Like say with the LPD processor? I don't
> know.
>
> --
> John McKown
> Systems Engineer IV
> IT
>
> Administrative Services Group
>
> HealthMarkets(r)
>
> 9151 Boulevard 26 * N. Richland Hills * TX 76010
> (817) 255-3225 phone * (817)-691-6183 cell
> john....@healthmarkets.com * www.HealthMarkets.com<http://www.healthmarkets.com/>
>
>
Did you test this with the FTP server, or just that client ?
Jim McAlpine
McKown, John
--
John McKown
Systems Engineer IV
IT
Administrative Services Group
HealthMarkets(r)
9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-691-6183 cell
john....@healthmarkets.com * www.HealthMarkets.com
Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM