[EDI-L Mailing List Archive Home] [Message List] [Reply To This Message]

Re: <TECH> Mercator Help

From: "Michael Mattias" <michael.mattias@...>
Date: Wed Jan 29, 2003  1:28 pm
Subject: Re: [EDI-L] <TECH> Mercator Help
> did anyone think of adjusting the type tree to read the correct data
> format? all this work around to handle a non-issue that mercator
> handles all the time. [ COBOL-created signed numeric data with 'overpunched'
digits].

Just one word of caution... the characters which represent the sign-overpunched
digits may vary if the data have been though an
EBCDIC to ASCII conversion.. i.e., the data have been downloaded from an EBCDIC
machine (MVS or OS/390 et al, AS/400) with "convert
to ASCII" specified as a parameter to the file transfer software:

ASCII CHARACTERS (digits 0-9 = x'30'- x'39')

0-9 positive, sign ASCII: 0,1,2,3,4,5,6,7,8,9
0-9 positive, sign EBCDIC (converted) {, A, B, C, D, E, F, G, H, I
0-9 negative, sign ASCII p,q,r,s,t,u,v,w,x,y
0-9 negative, sign EBCDIC: }, J,K,L,M,N,O,P,Q,R

But to get back on point... I do not believe Mercator will handle "CHARSET
ASCII, SIGN EBCDIC" numeric data via standard data types
available to the type tree. It WILL handle either CHARSET ASCII/SIGN ASCII or
CHARSET EBCDIC/SIGN EBCDIC (ie.e, "raw" EBCDIC data
downloaded from an EBCDIC machine WITHOUT 'convert to ASCII' parameter).

More (FREE) info on this topic:

Tutorial on COBOL datatypes: http://www.flexus.com/download.html, get file
COBDATA.ZIP. Includes text and demo software (included
software is an MS-DOS program, and yes I know I need to create a Windows
version).

Tutorial on general rules applying to using COBOL-created data with non-COBOL
software, including EBCDIC-ASCII conversion
considerations:
http://www.providerpaymentpartner.com/tsihome_html/downloads/C2IEEE.htm


Michael Mattias
Tal Systems, Inc.
Racine WI
www.talsystems.com
Author/contributor of both tutorials





 
EDI to XML Mapping for EDIFACT/X12 Convert EDIFACT/X12 Schemas to XML Schema Legacy Data Conversion Tools Access Relational Data as XML Visual XSLT and XQuery Mapping Tools Simplify EDI Data Integration with Stylus Studio XML Enterprise Suite - Free Download!
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.