Table: CI_MR - Meter Read
The data for CLOB field MR_DATA_AREA should be extracted into a secondary file, file name composed as [Table]_CLOB.
CLOB Delimiter: <endclob> followed by newline
Delimiter: ,
Enclosing Character: "
For not-nullable fields with no value, provide a single space enclosed in enclosing character
Fields:
MR_ID - Meter Read ID                                                                               CHAR (12)
MTR_CONFIG_ID - Meter Configuration ID                                                              CHAR (10)
READ_DTTM - Read Date/Time                                                                          DATE (26) 'YYYY-MM-DD HH24:MI:SS'
USE_ON_BILL_SW - Use On Bill                                                                        CHAR (1)
MR_SOURCE_CD - Meter Read Source                                                                    CHAR (12)
MTR_READER_ID - Meter Reader                                                                        VARC (20)
ILM_ARCH_SW - ILM Archive Switch                                                                    CHAR (1) NULLABLE
ILM_DT - ILM Date                                                                                   DATE (10) 'YYYY-MM-DD' NULLABLE
VERSION - Version                                                                                   NUMB (5)