Re: Ascii and EBCDIC translation

without asking every entity, can one tell looking at the file attributes?

Jim

On Fri, May 8, 2015 at 2:28 PM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:

> 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.
> >
> >
>
>
> --
> 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.
>
>