topic Xc2j schema file distinguished field values & distinguished field size in Talend Studio

Xc2j schema file distinguished field values & distinguished field size

karthikj18 — Sat, 16 Nov 2024 12:16:05 GMT

Hi,
I am trying to use two different schema in a single xc2j file using the distinguished field values option.
I have an EBCDIC file which has two different schema records based on a condition column it can be splitted.
Here I pasted the xc2j file format
<?xml version="1.0" encoding="UTF-8"?>
<FileFormat ConversionTable="Cp037"
dataFileImplementation="IBM i or z System" distinguishFieldSize="0" newLineSize="0">
<RecordFormat cobolRecordName="FTPDSDITM" distinguishFieldValue="0">
Picture="X(1)" Size="1" Type="X" Value=""/>
<FieldFormat Decimal="0" DependingOn="" Name="DTEFLG" Occurs="1"
Picture="X(1)" Size="1" Type="X" Value=""/>
<FieldFormat Decimal="0" DependingOn="" Name="STRDTE" Occurs="1"
Picture="X(6)" Size="6" Type="X" Value=""/>
<FieldFormat Decimal="0" DependingOn="" Name="STPDTE" Occurs="1"
Picture="X(6)" Size="6" Type="X" Value=""/>
<FieldFormat Decimal="0" DependingOn="" Name="PRFCDE" Occurs="1"
Picture="X(3)" Size="3" Type="X" Value=""/>
<FieldFormat Decimal="0" DependingOn="" ImpliedDecimal="true"
Name="EXCFLG" Occurs="1" Picture="S9(1)V9(0)" Signed="true"
Size="1" Type="3" Value=""/>
<FieldFormat Decimal="0" DependingOn="" Name="UPCITM" Occurs="1"
Picture="X(13)" Size="13" Type="X" Value=""/>
<FieldFormat Decimal="0" DependingOn="" Name="DOLPCT" Occurs="1"
Picture="X(1)" Size="1" Type="X" Value=""/>
<FieldFormat Decimal="3" DependingOn="" ImpliedDecimal="true"
Name="ITMALW" Occurs="1" Picture="S9(2)V9(3)" Signed="true"
Size="5" Type="3" Value=""/>
<FieldFormat Decimal="0" DependingOn="" Name="FILLER" Occurs="1"
Picture="X(44)" Size="44" Type="X" Value=""/>
</RecordFormat>
<RecordFormat cobolRecordName="FTPDSDSTR" distinguishFieldValue="1">
<FieldFormat Decimal="0" DependingOn="" Name="DIVNUM" Occurs="1"
Picture="X(3)" Size="3" Type="X" Value=""/>
<FieldFormat Decimal="0" DependingOn="" Name="RECCDE" Occurs="1"
Picture="X(3)" Size="3" Type="X" Value=""/>
<FieldFormat Decimal="0" DependingOn="" Name="VENNUM" Occurs="1"
Picture="X(9)" Size="9" Type="X" Value=""/>

</RecordFormat>
</FileFormat>
But when I try to use this schema in the component, the tfileinputEBCDIC component gives two schema. I attached two tlogrow components for the two outputs, but no output is coming from the file.
I guess I'm missing something logically in the schema.
Can anybody help how to use this multi-schema x2cj file format and get the two outputs correctly and what is the purpose of distinguished field size?

Re: Xc2j schema file distinguished field values & distinguished field size

Anonymous — Mon, 11 Jun 2012 11:02:33 GMT

Hi
Could you send me an email and attach the job and all files?
Regards,
Pedro

Re: Xc2j schema file distinguished field values & distinguished field size

karthikj18 — Mon, 11 Jun 2012 11:10:39 GMT

Hi Pedro,
Thanks for the reply.
I'm sorry I don't have time to mail the files.
The package consist of only a tfileinputEBCDIC component and two tlogrows.
I have taken the multi-schema xc2j files from the following sourceforge website.
http://sourceforge.net/tracker/?func=detail&aid=3500138&group_id=156330&atid=799353
There is a multi-schema ebcdic file, cobol copybook and the respective xc2j file is available.
Lets consider that as an example.
Could you please help to get the two different schema results from tfileinputEBCDIC component.
Please let me know if you need more details.

Re: Xc2j schema file distinguished field values & distinguished field size

janhess — Mon, 11 Jun 2012 11:50:00 GMT

You get 1 schema per record type. You then need to process them by selecting record type.

Re: Xc2j schema file distinguished field values & distinguished field size

karthikj18 — Mon, 11 Jun 2012 12:07:32 GMT

Hi Janhess,
Thanks for the reply.
Could you please explain it with a short example?

Re: Xc2j schema file distinguished field values & distinguished field size

janhess — Mon, 11 Jun 2012 14:10:35 GMT

Have you read tFileInputEBCDIC in the components documentation? There is an example there.