OPTIONS(DIRECT=FALSE,PARALLEL=TRUE,ROWS=30000,BINDSIZE=20970000)
LOAD DATA
LENGTH SEMANTICS CHARACTER
APPEND
INTO TABLE AR_DISE_LN
TRAILING NULLCOLS
(  
  unix_filename   		CONSTANT 'UNIXFILENAME',
  unix_fileid          	CONSTANT 'FILEIDFIC',
  fic_recnum      		recnum,
  USER_ID                   POSITION(1:10),
  TRANSACTION_NUMBER        CHAR(22),
  DOCUMENT_CIE              CHAR(5),
  DOCUMENT_TYPE             CHAR(2),
  DOCUMENT_NUMBER           CHAR(8),
  LINE_NUMBER               CHAR(7),
  ACCOUNTING_CODE           CHAR(29),
  COMPANY                   CHAR(3),
  FARE_CODE                 CHAR(6),
  SERVICE                   CHAR(6),
  SERVICE_CODE              CHAR(1),
  PARENT_SERVICE            CHAR(6),
  DISCOUNT_PLAN             CHAR(6),
  CURRENCY_CODE             CHAR(3),
  AMOUNT_SIGN               CHAR(1),
  AMOUNT                    CHAR(15),
  EXP_NAME                  CHAR(30),
  EXP_REMARK                CHAR(30),
  ADDRESS_NUMBER            CHAR(8),
  GL_DATE                   DATE   "YYYYMMDD",
  BATCH_SYSDATE             DATE   "YYYYMMDD",
  SERVICE_DATE              DATE   "YYYYMMDD",
  SUBLEDGER                 CHAR(8),
  SUBLEDGER_TYPE            CHAR(1),
  BATCH_NUMBER              CHAR(15),
  DUE_DATE                  DATE   "YYYYMMDD",
  PAYMENT_ITEM              CHAR(3),
  TAX_RATE_CODE             CHAR(10),
  GROSS_AMOUNT_SIGN         CHAR(1),
  GROSS_AMOUNT              CHAR(15),
  TAX_AMOUNT_SIGN           CHAR(1),
  TAX_AMOUNT                CHAR(15),
  VAT_AMOUNT_SIGN           CHAR(1),
  VAT_AMOUNT                CHAR(15),
  REMARK               	CHAR(30),
  STATEMENT_NUMBER          CHAR(13),
  PAYMENT_METHOD            CHAR(1),
  RCE_IDENTIFIER            CHAR(8),
  reject_key        		POSITION(*+1) char(61) TERMINATED BY "|",       -- +1 to avoid the |
  reject_comment    		POSITION(*) CHAR(600)  TERMINATED BY "|",
  reject_comment2   		POSITION(*) CHAR(600)  TERMINATED BY "|",
  reject_comment3   		POSITION(*) CHAR(600)  TERMINATED BY "|",
  reject_comment4   		POSITION(*) CHAR(600)  TERMINATED BY "|",
  reject_comment5   		POSITION(*) CHAR(600)  TERMINATED BY "|",
  reject_comment6   		POSITION(*) CHAR(600)  TERMINATED BY "|",
  reject_comment7   		POSITION(*) CHAR(600)  TERMINATED BY "|",
  reject_comment8   		POSITION(*) CHAR(600)  TERMINATED BY "|",
  reject_comment9   		POSITION(*) CHAR(600)  TERMINATED BY "|",
  reject_comment10  		POSITION(*) CHAR(600)  TERMINATED BY "|"
)