IBM BJ0NJML Integration Guide - Page 162
Flat File Formatting, Flat File Properties, HTTP Handler, FILEDIR Property, FLATFILESEP Property
![]() |
View all IBM BJ0NJML manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 162 highlights
Handlers Flat File Formatting If the data in the flat file contains the flat file delimiter character, the data adds the text qualifier, which is " (quotation marks). If the data contains quotation marks, the handler escapes the quotation marks. You cannot use quotation marks as the delimiter character. The following example data uses a comma (,) as a delimiter. The INVOICEDESC value, (Rotating Custom Item, No 71), contains a comma. When the flat file is written, the INVOICEDESC value is enclosed in quotation marks. EXTSYS1,MXINVOICEInterface,Add INVOICENUM,INVOICEDESC,PONUM,VENDOR,CONTACT,PAYMENTTERMS 1071,"Rotating Custom Item, No 71",1000,A0001,, The following example data uses a comma (,) as a delimiter. The INVOICEDESC value (Rotating "Custom" Item No 71) contains double quotation marks. When the flat file is written, double quotation marks in INVOICEDESC data ends with quotation marks, and the entire string is wrapped in quotation marks. EXTSYS1,MXINVOICEInterface,Add INVOICENUM,INVOICEDESC,PONUM,VENDOR,CONTACT,PAYMENTTERMS 1071,"Rotating ""Custom"" Item No 71",1000,A0001,, Flat File Properties FILEDIR Property FLATFILESEP Property HTTP Handler The following example data uses a comma (,) as a delimiter. The INVOICEDESC data (Rotating "Custom" Item, No. 71) contains the delimiter character and double quotation marks. When the flat file is written, the INVOICEDESC value appears in the code. EXTSYS1,MXINVOICEInterface,Add INVOICENUM,INVOICEDESC,PONUM,VENDOR,CONTACT,PAYMENTTERMS 1071,"Rotating ""Custom"" Item, No. 71",1000,A0001,, This handler has the following properties: This required property specifies the location of the flat file. The location must exist on the local server where the application server runs, or on a shared network drive. This property value defaults to the Integration global directory/flatfiles folder when no value is specified. The mxe.int.globaldir value controls the integration global directory value. This required property specifies the character that separates the columns in each row. The HTTP handler is a Java component that consists of properties. The handler delivers data as an XML document to a URL by using HTTP or HTTPS protocols. The HTTP handler also evaluates the response code received from the external system. 148 Integration Guide
![](/manual_guide/products/ibm-bj0njml-integration-guide-77e799f/162.png)