Re: Iseries to Biztalk ETL

[John McKee <jmmckee@xxxxxxxxxxxxxx>]

Outfit that the corporate owners of the hospital I work for hired a
company that has lots of data demands like this.  Had to have edited
numeric values and dates.  Sending data back to us, however, is a
different matter.  Most fields will be pipe delimited, except where
two fields are separated by a hyphen.  Their software is incapable of
doing better. And they have other issues with what they will send
back.

Irritating is a word that comes to mind........

Sorry this doesn't help.  Just frustrating.  Thank goodness that BIFs exist.

John McKee
John McKee

On Wed, Jun 27, 2012 at 5:34 PM, Monnier, Gary <Gary.Monnier@xxxxxxxxx> wrote:
> My understanding is connection adapters do such conversions for you, including EDBIC to ASCII conversion.
>
> It sounds like your BizTalk group is trying to get out of doing some work.  Is it possible they just don't know how to handle floating-point and zoned decimal strings?
>
>
> Gary Monnier
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
> Sent: Wednesday, June 27, 2012 2:44 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: Iseries to Biztalk ETL
>
> Biztalk folks tell me that they cant accept zoned or packed data, in addition they want to see numerics as edited character strings; ie "123.45"
>
> I am trying to make the interface file fields refer back to our iseries database files.
>
> For a order detail file with field QTY defined as packed 10.2, can I refer to the original field in my interface file, but add an edit code?  But I am pretty sure that there edit codes are ignored for physical & logical files.
>
> Is it possible to have DB2 utilize the edit codes for a PF?
>
> Is there a better way than moving each numeric field to a work field for the edit to add the decimal point, and then to the interface file?
>
> I am using cobol so would like to do most fields with MOVE CORRESPONDING, but that is secondary.
>
> Primarily I would like DDS to handle the editing.  Is this doable?
>
> Thanks!
>
>
>
> ______________________________________________________________________
> This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
> For more information please visit http://www.symanteccloud.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.