MQSeries.net :: View topic - Leadng zeroes in file output

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Leadng zeroes in file output

Leadng zeroes in file output

« View previous topic :: View next topic »

Author

Message

petervh1

Posted: Mon Mar 27, 2023 11:44 pm Post subject: Leadng zeroes in file output

Centurion

Joined: 19 Apr 2010
Posts: 122

Hi

Environment ACE 12.0.7

I can't work out why I'm seeing the following behaviour:

My XSD is defined as follows:

Code:

<?xml version="1.0" encoding="UTF-8"?><xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:dfdl="http://www.ogf.org/dfdl/dfdl-1.0/" xmlns:fn="http://www.w3.org/2005/xpath-functions" xmlns:ibmDfdlExtn="http://www.ibm.com/dfdl/extensions" xmlns:ibmSchExtn="http://www.ibm.com/schema/extensions" xmlns:recSepFieldsFmt="http://www.ibm.com/dfdl/RecordSeparatedFieldFormat">
<xsd:import namespace="http://www.ibm.com/dfdl/RecordSeparatedFieldFormat" schemaLocation="IBMdefined/RecordSeparatedFieldFormat.xsd"/>
<xsd:annotation>
   <xsd:appinfo source="http://www.ogf.org/dfdl/">
      <dfdl:format documentFinalTerminatorCanBeMissing="yes" encoding="{$dfdl:encoding}" escapeSchemeRef="" occursCountKind="implicit" ref="recSepFieldsFmt:RecordSeparatedFieldsFormat" separator=""/>
   </xsd:appinfo>
</xsd:annotation>

<xsd:element dfdl:fillByte="" ibmSchExtn:docRoot="true" name="APEX_to_SAP">
   <xsd:complexType>
      <xsd:sequence dfdl:separatorSuppressionPolicy="anyEmpty">

      <xsd:element dfdl:fillByte="" dfdl:terminator="" maxOccurs="1" name="headers">
            <xsd:complexType>

            <xsd:sequence dfdl:outputNewLine="{$dfdl:outputNewLine}" dfdl:separator="" dfdl:terminator="">
                  <xsd:element default="" dfdl:terminator="%#09;" name="header_reference_Ref.Doc" type="xsd:string"/>
                  <xsd:element default="" dfdl:terminator="%#09;" name="currencyDoc_CurrencyLine_Currency" type="xsd:string"/>
                  <xsd:element default="" dfdl:terminator="%#09;" name="profit_center" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="respnoCost_Centre" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="account" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:terminator="%#09;" name="acc_type" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="document_amount_debit" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="document_amount_credit" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:terminator="%#09;" name="line_item" type="xsd:string"/>
                  <xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="tax_indicator" nillable="true" type="xsd:string"/>
                  <xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="assignment_PO_Number" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="company_code_amount_debit" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="company_code_amount_credit" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="group_amount_debit" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="group_amount_credit" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:terminator="%#09;" name="document_date" type="xsd:string"/>
<xsd:element default="" dfdl:terminator="%#09;" name="reference1" type="xsd:string"/>
                  <xsd:element default="" dfdl:terminator="%#09;" name="reference2" type="xsd:string"/>
                  <xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="reference3" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="quantity" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="title" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="name" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="city" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="payment_term" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:nilKind="literalValue" dfdl:nilValue="0" dfdl:outputNewLine="{$dfdl:outputNewLine}" dfdl:terminator="%CR;%LF;" dfdl:useNilForDefault="yes" name="payment_block" nillable="true" type="xsd:string"/>
</xsd:sequence>


            </xsd:complexType>
         </xsd:element>

         <xsd:element dfdl:fillByte="" dfdl:outputNewLine="{$dfdl:outputNewLine}" maxOccurs="unbounded" name="body">
            <xsd:complexType>
               <xsd:sequence dfdl:outputNewLine="{$dfdl:outputNewLine}" dfdl:separator="" dfdl:terminator="">
                  <xsd:element default="" dfdl:escapeSchemeRef="recSepFieldsFmt:RecordEscapeScheme" dfdl:fillByte="" dfdl:terminator="%#09;" dfdl:textStringJustification="left" name="header_reference_Ref.Doc" type="xsd:string"/>
                  <xsd:element default="" dfdl:fillByte="" dfdl:terminator="%#09;" name="currencyDoc_CurrencyLine_Currency" type="xsd:string"/>
                  <xsd:element default="" dfdl:fillByte="" dfdl:terminator="%#09;" name="profit_center" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="respnoCost_Centre" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="account" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:fillByte="" dfdl:terminator="%#09;" name="acc_type" type="xsd:string"/>
<xsd:element default="0.00" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:textNumberPattern="#.##" dfdl:useNilForDefault="yes" ibmDfdlExtn:sampleValue="0.00" name="document_amount_debit" nillable="true" type="xsd:decimal"/>
<xsd:element default="0.00" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:textNumberPattern="#.##" dfdl:useNilForDefault="yes" name="document_amount_credit" nillable="true" type="xsd:decimal"/>
<xsd:element default="" dfdl:fillByte="" dfdl:terminator="%#09;" name="line_item" type="xsd:string"/>
                  <xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="tax_indicator" nillable="true" type="xsd:string"/>
                  <xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="assignment_PO_Number" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="company_code_amount_debit" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="company_code_amount_credit" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="group_amount_debit" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="group_amount_credit" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:fillByte="" dfdl:terminator="%#09;" name="document_date" type="xsd:string"/>
<xsd:element default="" dfdl:fillByte="" dfdl:terminator="%#09;" name="reference1" type="xsd:string"/>
                  <xsd:element default="" dfdl:fillByte="" dfdl:terminator="%#09;" name="reference2" type="xsd:string"/>
                  <xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="reference3" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="quantity" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="title" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="name" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="city" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="payment_term" nillable="true" type="xsd:string"/>
<xsd:element default="" dfdl:emptyValueDelimiterPolicy="terminator" dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:outputNewLine="{$dfdl:outputNewLine}" dfdl:terminator="%#09;" dfdl:useNilForDefault="yes" name="payment_block" nillable="true" type="xsd:string"/>
</xsd:sequence>
            </xsd:complexType>
         </xsd:element>
</xsd:sequence>
   </xsd:complexType>
</xsd:element>

</xsd:schema>

My ESQL has:

Code:

SET OutputRoot.DFDL.APEX_to_SAP.body."header_reference_Ref.Doc" = '123';

The relevant part of my output file has:

Code:

00000000000000000123 8946 G 250 2023-02-17

Why am I seeing the leading zeroes in front of '123'?

TIA

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Leadng zeroes in file output

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP