Use the TF (Truncate Field) option to truncate fields to their FAP defined field length. Make sure you specify this parameter before FILE option. Here are some examples:
This example will truncate the fields lengths:
;ImportXMLFile;;TF,SCH=1,XML_FILE_NAME 15,55;
These examples truncate fields and suppress pagination:
;ImportXMLFile;;SP,TF,SCH=1,XML_FILE_NAME 15,55;
;ImportXMLFile;;TF,SP,SCH=1,XML_FILE_NAME 15,55;
This example does not truncate fields or suppress pagination:
;ImportXMLFile;;SP
Note | No formatting is allowed on the multiline text field when you include the TF option. |
© Copyright 2013, Oracle and/or its affiliates. All rights reserved. Legal notices.