Page 1 of 1

EBCDIC to ASCII conversion using connect:direct

PostPosted: Mon Aug 17, 2009 2:25 pm
by sindhum
Hi All

We have a mainframe file which needs to be sent to windows server in ASCII format using connect:direct script. Can anyone pls help me with the sysopts parameter that need to be coded in the parm.

What is XLATE.TBL used for?

Thanks & Regards
Sindhu

Re: EBCDIC to ASCII conversion using connect:direct

PostPosted: Mon Aug 17, 2009 6:38 pm
by MrSpock
This stuff is covered in the Process coding Guides.

Re: EBCDIC to ASCII conversion using connect:direct

PostPosted: Mon Aug 17, 2009 6:47 pm
by sindhum
Can you pls provide me with the url of the guide you are referring to

Re: EBCDIC to ASCII conversion using connect:direct

PostPosted: Tue Aug 18, 2009 2:45 pm
by sindhum
Hi

I have a parm for NDM where EBCDIC to ASCII conversion is happening.

--------------------------------------------------------------
&SYSOPTS=\':STRIP.BLANKS=NO:XLATE=YES:\ || -
\XLATE.TBL=/opt/cdserver/ndm/xlate/ods_recv.xlt:'\ -
&DSN1='AAA.BBB.CCC(0)' -
&DSN2=\'/opt/informatica/server/PowerCenter/\ || -
\server/infa_shared/SrcFiles/Data/\ || -
\Vp_ODS/ABC_06_B1_MMDDYYYY.DAT'\
--------------------------------------------------------------

Can anyone explain me the purpose of XLATE.TBL and BLANKS=NO?

I have other files to transfer from mainframes to windows server as DAT, is it fine if we just mention XLATE=YES and give DSN1 & DSN2 without XLATE.TBL?
_________________
Thanks & Regards
Sindhu

Re: EBCDIC to ASCII conversion using connect:direct

PostPosted: Tue Aug 18, 2009 10:48 pm
by dick scherrer
Hello,

Suggest you review the product documentation and if there is something in the documentation that is not clear, post it here and your doubt about it. Someone will be able to clarify.