BizTalk Server General - Can Biztalk Editor handle this ?

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > February 2004 > Can Biztalk Editor handle this ?





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Can Biztalk Editor handle this ?
Anunay

2004-02-24, 6:35 am

The file I'm receiving is outline below. It contains
various sections and sub-sections(nested inside section).
The file is sent as ASCII file with each section
containing multiple fixed length fields. The sections are
seprated by Line feed character.

SectionName Required/Optional Loop Repeat
========================================
===============
SHH01 R 1/1
------------------------------------------------------
SOH01 R 1/*
------------------------------------------------------
SOD01 R 1/*
------------------------------------------------------
SOV01 O 0/*
------------------------------------------------------
SUM01 R 1/1
========================================
================

There will be only one occurrence of the SHH01 Header and
SUM01 footer record for each file. There can be multiple
SOD01, SOV01 records for a SOH01 record.

When I create schema, maintaining the section hierarchy
the BizTalk editor throws error saying that "The parent of
a record cannot be a positional record. Specify a
different parent." I'm unable to create a valid schema.

It seems biztalk editor does not allow hierarchy(i.e,
records containing other records) for positional files.
Can somebody confirm this? Has any one face similar issue
and knows the resolution ? Please help.

Thanks,
Anunay


R.Balaji

2004-02-25, 9:44 am

> It seems biztalk editor does not allow hierarchy(i.e,
> records containing other records) for positional files.

(As for as i know) Yes

In current schema specification, a child record can occur 1 to many within
the parent record.

So it is difficult for biztalk to knows the end of child record within the
parent record.

So hierarchy is not supported for positional files.

Regards,
R.Balaji

"Anunay" <anunay77@_NOSPAM_hotmail.com> wrote in message
news:0bf101c3fb11$6b9839a0$a301280a@phx.gbl...
> The file I'm receiving is outline below. It contains
> various sections and sub-sections(nested inside section).
> The file is sent as ASCII file with each section
> containing multiple fixed length fields. The sections are
> seprated by Line feed character.
>
> SectionName Required/Optional Loop Repeat
> ========================================
===============
> SHH01 R 1/1
> ------------------------------------------------------
> SOH01 R 1/*
> ------------------------------------------------------
> SOD01 R 1/*
> ------------------------------------------------------
> SOV01 O 0/*
> ------------------------------------------------------
> SUM01 R 1/1
> ========================================
================
>
> There will be only one occurrence of the SHH01 Header and
> SUM01 footer record for each file. There can be multiple
> SOD01, SOV01 records for a SOH01 record.
>
> When I create schema, maintaining the section hierarchy
> the BizTalk editor throws error saying that "The parent of
> a record cannot be a positional record. Specify a
> different parent." I'm unable to create a valid schema.
>
> It seems biztalk editor does not allow hierarchy(i.e,
> records containing other records) for positional files.
> Can somebody confirm this? Has any one face similar issue
> and knows the resolution ? Please help.
>
> Thanks,
> Anunay
>
>



Nick Malik

2004-02-25, 10:35 am

I know that I've done this before using Biztalk, so I will follow up to get
my details right before responding. From what I remember, the structure was
listed as delimited, with the delimiter being the line feeds, and then below
that, I had positional records.

I'll see if I can come back later today with a good example.

--- Nick

"Anunay" <anunay77@_NOSPAM_hotmail.com> wrote in message
news:0bf101c3fb11$6b9839a0$a301280a@phx.gbl...
> The file I'm receiving is outline below. It contains
> various sections and sub-sections(nested inside section).
> The file is sent as ASCII file with each section
> containing multiple fixed length fields. The sections are
> seprated by Line feed character.
>
> SectionName Required/Optional Loop Repeat
> ========================================
===============
> SHH01 R 1/1
> ------------------------------------------------------
> SOH01 R 1/*
> ------------------------------------------------------
> SOD01 R 1/*
> ------------------------------------------------------
> SOV01 O 0/*
> ------------------------------------------------------
> SUM01 R 1/1
> ========================================
================
>
> There will be only one occurrence of the SHH01 Header and
> SUM01 footer record for each file. There can be multiple
> SOD01, SOV01 records for a SOH01 record.
>
> When I create schema, maintaining the section hierarchy
> the BizTalk editor throws error saying that "The parent of
> a record cannot be a positional record. Specify a
> different parent." I'm unable to create a valid schema.
>
> It seems biztalk editor does not allow hierarchy(i.e,
> records containing other records) for positional files.
> Can somebody confirm this? Has any one face similar issue
> and knows the resolution ? Please help.
>
> Thanks,
> Anunay
>
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com