XML Input Stage

[msarkar00]

Hi,

We have created a job with an seq file followed by a xml input stage..then a copy stage and finally the data will be written into a seq file...

the xml structure is
<?xml version="1.0" ?>
- <customers>
- <customer id="55000">
<name>Charter Group</name>
- <address>
<street>100 Main</street>
<city>Kolkata</city>
<state>WB</state>
<zip>700091</zip>
</address>
</customer>
- <customer id="66000">
<name>Tata Group</name>
- <address>
<street>Park Street</street>
<city>Kolkata</city>
<state>WB</state>
<zip>700091</zip>
</address>
</customer>
</customers>

We want to convert this into a seq file. We have loaded the metadata using the xml_data_definations into the seq file and selected id as the key field. The key field is id and it is a decimal.

Now when we run the job we get an error saying:

Sequential_File_34: At field "id": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=10, scale=5, round=trunc_zero, ascii}

Could u Pls help??

[Kirtikumar]

what the message means is you have define some fixed width datatype - may be as char and the data coming has variable length.

What is the datatype for id? If it is char make it varchar and see if it works.