Re: Ascii and EBCDIC translation

Jim

even if the files you receive is in CSSID 819/1252 are you sure that they
isn't
UTF-8 files?


On Fri, May 8, 2015 at 8:25 PM, Jim Franz <franz9000@xxxxxxxxx> wrote:

> EBCDIC CCSID = 37
> Most file imports are via ftp - ccsid 1252, occasionally burned dvd for new
> customer startup of history.
> Some trading partners are mainframe, some unix/Linux, some Win, all US
> based entities, but we think some servers are overseas (we see time
> differences).
>
> When we write ascii text, usually 819
>
> what hurts us most is screen input (web interface to SQL Server then to
> Power i) where user cuts & pastes paragraphs of text from their source
> systems (thousands of different customers).
> Jim
>
>
>
>
> On Fri, May 8, 2015 at 2:07 PM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:
>
> > Jim
> >
> > what is the EBCDIC CSSid on your machine and how do you recieve files?
> >
> > On Fri, May 8, 2015 at 8:00 PM, Jim Franz <franz9000@xxxxxxxxx> wrote:
> >
> > > We do a lot of import and export of data, plus have both PC client
> (local
> > > and web) input as well at PC5250.
> > > Had a recent thread involving cut and paste data (ebcdic x'3F') that
> > caused
> > > an issue.
> > > We use CCSID 37 and ascii 819.
> > >
> > > There are more EBCDIC characters than what we see on the US Keyboard.
> > Some
> > > we need, such as copyright symbol, cents sign, etc, but many
> > >
> > > We are wanting to take steps to clean the data on input, whether from
> > ascii
> > > or ebcdic side. We have some input already cleansed, but only at screen
> > > program level.
> > >
> > > Couple questions:
> > > 1. Just replacing all below ebcdic x'40'  leaves a lot of strange
> > > characters like x'8C' (sort of a moon with a hat..). One thought is to
> > > identify all the characters we need and replace the rest. No need to
> keep
> > > line and page formatting stuff.
> > > Is this a good idea?
> > >
> > > 2. Thinking that since a multitude of entry/update points, db triggers
> > are
> > > best? Am wondering about apps that write the data, and now after write,
> > the
> > > screen column data is different than column data in file (trigger pgm
> > > cleaned the data - hoping to avoid opening up all the apps.
> > >
> > > 3. How far do people with heavy edi take this? Am I leaving some
> > something
> > > out with the keyboard characters plus a few more? These are names,
> > > addresses, notes (which are sometimes pages of notes).
> > >
> > > Jim Franz
> > > --
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> > >
> > >
> >
> >
> > --
> > Regards,
> > Henrik Rützou
> >
> >  http://powerEXT.com <http://powerext.com/>
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>