10 Replies Latest reply: Jan 7, 2010 11:55 AM by 690317 RSS

    sqlldr control file with to_date fails

    690317
      I have a one line data file which I want to get working before I populate fully. However I am stumped as to what could be the problem ( see bottome of this rambling). Before posting I asked DBA multiple times but we couldn't come up with a working solution. Thank You

      VERSION:
      Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi

      DESCRIBE TABLE:
      TRANSACTION_ID NOT NULL VARCHAR2(200)
      EXECUTION_DATE NOT NULL TIMESTAMP(6)
      SERVER_NAME VARCHAR2(10)
      SERVER_PROXY VARCHAR2(50)
      CALLING_APPLICATION_NAME VARCHAR2(50)
      CALLING_SERVICE_NAME VARCHAR2(150)
      CALLED_SERVICE_NAME VARCHAR2(150)
      CALLED_METHOD_NAME VARCHAR2(50)
      RESPONSE_TIME NUMBER
      TRANSACTION_SEQUENCE_NUMBER NUMBER
      VERSION VARCHAR2(15)
      USER_ID VARCHAR2(15)
      VPAR VARCHAR2(11)
      LNIATA VARCHAR2(18)

      14 rows selected



      CONTROL FILE NAME:
      ETicketing.ctl

      CONTROL FILE CONTENTS:
      load data
      infile '/tmp/x7065/ETicketing_oneline'
      into TABLE CEBSLOG_ADMIN.ETICKETING
      fields terminated by "," TRAILING NULLCOLS
      ( TRANSACTION_ID, EXECUTION_DATE "TO_DATE(:EXECUTION_DATE, 'YYYY-MM-DD HH24:MI:SS.FF')", SERVER_NAME, SERVER_PROXY, CALLING_APPLICATION_NAME, CALLING_SERVICE_NAME, CALLED_SERVICE_NAME, CALLED_METHOD_NAME, RESPONSE_TIME, TRANSACTION_SEQUENCE_NUMBER, VERSION, USER_ID, VPAR, LNIATA )

      DATA FILE NAME:
      ETicketing_oneline.dat

      DATA FILE CONTENTS:
      '[somedate.com.x.yyyyyyyyyyyyyy.zzzzzzzzzzzzzzz-2009-12-15-02-00-14-202-(POOL)', '2009-12-15 02:00:14.641',  'servername',  'proxyname', 'CEBS_ReservationRetrieval',  , 'ETicketing', 'retrieveMOREdata', 245, 120, , ,  'WN1', 

      *COMMAND LINE:*
      sqlldr control=/tmp/x7065/ETicketing.ctl userid=me_USER/me_USER99@myserver.com -data=/tmp/x7065/ETicketing

      *STDOUT RESULTS:*

      SQL*Loader: Release 10.2.0.2.0 - Production on Wed Jan 6 17:18:30 2010

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

      Commit point reached - logical record count 1

      *LOG FILE RESULTS:*
      cat sqlldr.log

      SQL*Loader: Release 10.2.0.2.0 - Production on Wed Jan 6 17:18:30 2010

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

      Control File:   /tmp/x7065/ETicketing.ctl
      Data File:      /tmp/x7065/ETicketing_oneline.dat
        Bad File:     /tmp/x7065/ETicketing_oneline.bad
        Discard File:  none specified

      (Allow all discards)

      Number to load: ALL
      Number to skip: 0
      Errors allowed: 50
      Bind array:     64 rows, maximum of 256000 bytes
      Continuation:    none specified
      Path used:      Conventional

      Table CEBSLOG_ADMIN.ETICKETING, loaded from every logical record.
      Insert option in effect for this table: INSERT
      TRAILING NULLCOLS option in effect

         Column Name                  Position   Len  Term Encl Datatype
      ------------------------------ ---------- ----- ---- ---- ---------------------
      TRANSACTION_ID                      FIRST     *   ,       CHARACTER
      EXECUTION_DATE                       NEXT     *   ,       CHARACTER
          SQL string for column : "TO_DATE(:EXECUTION_DATE, 'YYYY-MM-DD HH24:MI:SS.FF')"
      SERVER_NAME                          NEXT     *   ,       CHARACTER
      SERVER_PROXY                         NEXT     *   ,       CHARACTER
      CALLING_APPLICATION_NAME             NEXT     *   ,       CHARACTER
      CALLING_SERVICE_NAME                 NEXT     *   ,       CHARACTER
      CALLED_SERVICE_NAME                  NEXT     *   ,       CHARACTER
      CALLED_METHOD_NAME                   NEXT     *   ,       CHARACTER
      RESPONSE_TIME                        NEXT     *   ,       CHARACTER
      TRANSACTION_SEQUENCE_NUMBER          NEXT     *   ,       CHARACTER
      VERSION                              NEXT     *   ,       CHARACTER
      USER_ID                              NEXT     *   ,       CHARACTER
      VPAR                                 NEXT     *   ,       CHARACTER
      LNIATA                               NEXT     *   ,       CHARACTER

      Record 1: Rejected - Error on table CEBSLOG_ADMIN.ETICKETING, column EXECUTION_DATE.
      ORA-01821: date format not recognized


      Table CEBSLOG_ADMIN.ETICKETING:
        0 Rows successfully loaded.
        1 Row not loaded due to data errors.
        0 Rows not loaded because all WHEN clauses were failed.
        0 Rows not loaded because all fields were null.


      Space allocated for bind array:                 231168 bytes(64 rows)
      Read   buffer bytes: 1048576

      Total logical records skipped:          0
      Total logical records read:             1
      Total logical records rejected:         1
      Total logical records discarded:        0

      Run began on Wed Jan 06 17:18:30 2010
      Run ended on Wed Jan 06 17:18:31 2010

      Elapsed time was:     00:00:00.41
      CPU time was:         00:00:00.02                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
        • 1. Re: sqlldr control file with to_date fails
          Rajesh Chamarthi
          Hi,

          Instead of formatting as a date (which has precision only till a second, try formatting it with to_timestamp.
          More importantly, if you need the precision for milliseconds, your table column should also be TIMESTAMP and not date.

          From the Oracle documentation....at http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/datatype.htm#CNCPT413

          >
          The DATE datatype stores point-in-time values (dates and times) in a table. The DATE datatype stores the year (including the century), the month, the day, the hours, the minutes, and the seconds (after midnight).
          >


          Haven't tried the complete load.. but the insert below works...
          create table t (
            execution_date date
          );
          
          sql> insert into t
            2  select to_date('2009-12-15 02:00:14.641','YYYY-MM-DD HH24:MI:SS.FF3') from dual;
          select to_date('2009-12-15 02:00:14.641','YYYY-MM-DD HH24:MI:SS.FF3') from dual
                                                   *
          ERROR at line 2:
          ORA-01821: date format not recognized
          
          sql> insert into t
            2  select to_timestamp('2009-12-15 02:00:14.641','YYYY-MM-DD HH24:MI:SS.FF3')  from dual
            3  /
          
          1 row created.
          Hope this helps,
          Rajesh.

          Edited by: Rajesh Chamarthi on Jan 6, 2010 7:01 PM (added link)
          • 2. Re: sqlldr control file with to_date fails
            690317
            Thank You,

            From above, table is timestamp:
            EXECUTION_DATE NOT NULL TIMESTAMP(6)

            The insert with TO_DATE works in my perl script to insert row by row. The issue is when i use sqlldr. I plan to benchmark the 2 loads perl vs sqlldr.


            with TO_TIMESTAMP:
            Column Name Position Len Term Encl Datatype
            ------------------------------ ---------- ----- ---- ---- ---------------------
            TRANSACTION_ID FIRST * , CHARACTER
            EXECUTION_DATE NEXT * , CHARACTER
            SQL string for column : "TO_TIMESTAMP(:EXECUTION_DATE, 'YYYY-MM-DD HH24:MI:SS.FF')"
            SERVER_NAME NEXT * , CHARACTER
            SERVER_PROXY NEXT * , CHARACTER
            CALLING_APPLICATION_NAME NEXT * , CHARACTER
            CALLING_SERVICE_NAME NEXT * , CHARACTER
            CALLED_SERVICE_NAME NEXT * , CHARACTER
            CALLED_METHOD_NAME NEXT * , CHARACTER
            RESPONSE_TIME NEXT * , CHARACTER
            TRANSACTION_SEQUENCE_NUMBER NEXT * , CHARACTER
            VERSION NEXT * , CHARACTER
            USER_ID NEXT * , CHARACTER
            VPAR NEXT * , CHARACTER
            LNIATA NEXT * , CHARACTER

            Record 1: Rejected - Error on table CEBSLOG_ADMIN.ETICKETING, column EXECUTION_DATE.
            ORA-01841: (full) year must be between -4713 and +9999, and not be 0
            • 3. Re: sqlldr control file with to_date fails
              Rajesh Chamarthi
              >
              EXECUTION_DATE NOT NULL TIMESTAMP(6)
              >

              Sorry.... Didn't see the table definition..

              Since the datatype is timestamp and you have data with millisecond precision, why not do a to_timestamp which is the logical thing to do?

              >
              The insert with TO_DATE works in my perl script to insert row by row. The issue is when i use sqlldr
              >

              Haven't really worked a lot with perl scripting.. but I wonder how this works from perl when it fails at sqlplus!
              One more thing to consider.. even if it works... you are losing the millisecond precision when you typecase it to date.. So you should still make the change to use to_timestmap instead of to_date.

              In case you figure out why it works in perl, post the reason here..too :)

              Thanks,
              Rajesh.
              • 4. Re: sqlldr control file with to_date fails
                690317
                Sorry for confusion, I have TO_TIMESTAMP in PERL Script.

                Back to sqlldr:
                I have tried both TO_DATE and TO_TIMESTAMP both of which do not work

                ( TRANSACTION_ID, EXECUTION_DATE "TO_TIMESTAMP(:EXECUTION_DATE, 'YYYY-MM-DD HH24:MI:SS.FF')", SERVER_NAME, SERVER_PROXY, CALLING_APPLICATION_NAME, CALLING_SERVICE_NAME, CALLED_SERVICE_NAME, CALLED_METHOD_NAME, RESPONSE_TIME, TRANSACTION_SEQUENCE_NUMBER, VERSION, USER_ID, VPAR, LNIATA )

                Thank You,
                -David
                • 5. Re: sqlldr control file with to_date fails
                  Rajesh Chamarthi
                  David,

                  There are two diffferent errors in your posts.

                  >
                  Record 1: Rejected - Error on table CEBSLOG_ADMIN.ETICKETING, column EXECUTION_DATE.
                  ORA-01821: date format not recognized
                  >

                  This can be fixed by using the to_timestamp format ..the reason is date in oracle has precision only till seconds.

                  >
                  Record 1: Rejected - Error on table CEBSLOG_ADMIN.ETICKETING, column EXECUTION_DATE.
                  ORA-01841: (full) year must be between -4713 and +9999, and not be 0
                  >

                  This, I believe, is an issue with the data. Can you show me the record that is causing this.
                  Just isolate this issue and see if it is becuase of date format... I believe it is a different error this time...
                  The correct year is not being read.. .??

                  Check this code and data ... This seems to be working on my database (10g R2 Enterprise edition).
                  sql> create table t(
                    2     execution_date timestamp);
                  
                  Table created.
                  
                  *TEST.CTL (Control file..)*
                  load data
                  infile *
                  into table T
                  TRUNCATE
                  fields terminated by ',' optionally enclosed by '"'
                  (
                  EXECUTION_DATE "TO_TIMESTAMP(:EXECUTION_DATE,'YYYY-MM-DD HH24:MI:SS.FF')"
                  )
                  BEGINDATA
                  2009-12-15 02:00:14.641
                  
                  [dev01@machine1]  sqlldr scott/tiger@orcl control=test.ctl
                  
                  SQL*Loader: Release 10.2.0.4.0 - Production on Thu Jan 7 15:27:01 2010
                  
                  Copyright (c) 1982, 2007, Oracle.  All rights reserved.
                  
                  Commit point reached - logical record count 1
                  
                  
                  sql> select execution_date from t;
                  
                  EXECUTION_DATE
                  ----------------------------------
                  15-DEC-09 02.00.14.641000 AM
                  
                  
                  {code}
                  
                  Hope this helps....
                  
                  -Rajesh.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                  • 6. Re: sqlldr control file with to_date fails
                    690317
                    Rajesh,

                    Thank you for your explanation, I understand. The current attempt I used TO_TIMESTAMP.

                    control file:
                    load data
                    infile '/tmp/x7065/ETicketing_oneline'
                    into TABLE CEBSLOG_ADMIN.ETICKETING
                    fields terminated by "," TRAILING NULLCOLS
                    ( TRANSACTION_ID, EXECUTION_DATE "TO_TIMESTAMP(:EXECUTION_DATE, 'YYYY-MM-DD HH24:MI:SS.FF')", SERVER_NAME, SERVER_PROXY, CALLING_APPLICATION_NAME, CALLING_SERVICE_NAME, CALLED_SERVICE_NAME, CALLED_METHOD_NAME, RESPONSE_TIME, TRANSACTION_SEQUENCE_NUMBER, VERSION, USER_ID, VPAR, LNIATA )

                    DATA FILE:
                    '[TechnoStormITConsulting.com.retrieveReservation-2009-12-15-02-00-14-202-(POOL)', '2009-12-15 02:00:14.641',  'server07',  'ServerProxy', 'ResRet',  , 'ETick', 'retrieveETickPNR', 245, 120, , ,  'WN1', 

                    Error LOG:

                      Column Name                  Position   Len  Term Encl Datatype
                    ------------------------------ ---------- ----- ---- ---- ---------------------
                    TRANSACTION_ID                      FIRST     *   ,       CHARACTER
                    EXECUTION_DATE                       NEXT     *   ,       CHARACTER
                        SQL string for column : "TO_TIMESTAMP(:EXECUTION_DATE, 'YYYY-MM-DD HH24:MI:SS.FF')"
                    SERVER_NAME                          NEXT     *   ,       CHARACTER
                    SERVER_PROXY                         NEXT     *   ,       CHARACTER
                    CALLING_APPLICATION_NAME             NEXT     *   ,       CHARACTER
                    CALLING_SERVICE_NAME                 NEXT     *   ,       CHARACTER
                    CALLED_SERVICE_NAME                  NEXT     *   ,       CHARACTER
                    CALLED_METHOD_NAME                   NEXT     *   ,       CHARACTER
                    RESPONSE_TIME                        NEXT     *   ,       CHARACTER
                    TRANSACTION_SEQUENCE_NUMBER          NEXT     *   ,       CHARACTER
                    VERSION                              NEXT     *   ,       CHARACTER
                    USER_ID                              NEXT     *   ,       CHARACTER
                    VPAR                                 NEXT     *   ,       CHARACTER
                    LNIATA                               NEXT     *   ,       CHARACTER

                    Record 1: Rejected - Error on table CEBSLOG_ADMIN.ETICKETING, column EXECUTION_DATE.
                    ORA-01841: (full) year must be between -4713 and +9999, and not be 0


                    Table CEBSLOG_ADMIN.ETICKETING:
                      0 Rows successfully loaded.
                      1 Row not loaded due to data errors.
                      0 Rows not loaded because all WHEN clauses were failed.
                      0 Rows not loaded because all fields were null.


                    Space allocated for bind array:                 231168 bytes(64 rows)
                    Read   buffer bytes: 1048576

                    Total logical records skipped:          0
                    Total logical records read:             1
                    Total logical records rejected:         1
                    Total logical records discarded:        0

                    Run began on Thu Jan 07 09:55:48 2010
                    Run ended on Thu Jan 07 09:55:48 2010

                    Elapsed time was:     00:00:00.17
                    CPU time was:         00:00:00.02                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                    • 7. Re: sqlldr control file with to_date fails
                      Rajesh Chamarthi
                      David..

                      I was able to reproduce the error and I figured it out.. :)

                      It was an issue because of the contol file's optionally enclosed by " cluase...
                      In that clause , you have double quotes. so if your fields satrt with double quotes, they are silently ommitted..and are not considered part ofthe data.

                      However, since your fields are enclosed in single quotes...to sqlloader, comma is included in the field it is trying to typecast to timestamp

                      {code}
                      '2009-12-15 02:00:14.641
                      {code}

                      The quote is causing the error..

                      {code}
                      sql> ed
                      Wrote file afiedt.buf

                      1 with temp_table as (
                      2 select '''2009-12-15 02:00:14.641' execution_date from dual)
                      3* select execution_date from temp_table
                      sql> /

                      EXECUTION_DATE
                      ------------------------
                      '2009-12-15 02:00:14.641

                      sql> ed
                      Wrote file afiedt.buf

                      1 with temp_table as (
                      2 select '''2009-12-15 02:00:14.641' execution_date from dual)
                      3* select to_timestamp(execution_date,'YYYY-MM-DD HH24:MI:SS.FF3') from temp_table
                      sql> /
                      select to_timestamp(execution_date,'YYYY-MM-DD HH24:MI:SS.FF3') from temp_table
                      *
                      ERROR at line 3:
                      ORA-01841: (full) year must be between -4713 and +9999, and not be 0
                      {code}

                      If you expect your data to be enclosed in single quotes... change the clause to



                      --fields terminated by "'" (double quote followed by single quote followed by double quote)--

                      {code}
                      fields terminated by ',' optionally enclosed by "'"
                      {code}

                      Hope this helps,
                      Rajesh.

                      Edited on Jan 7, 2010 12:23 PM (corrected the fields terminaated by clause and added optionally enclosed)
                      • 8. Re: sqlldr control file with to_date fails
                        690317
                        I changed my control file to:
                        load data
                        infile '/tmp/x7065/ETicketing_oneline'
                        into TABLE CEBSLOG_ADMIN.ETICKETING
                        fields terminated by "'" TRAILING NULLCOLS
                        ( TRANSACTION_ID, EXECUTION_DATE "TO_TIMESTAMP(:EXECUTION_DATE, 'YYYY-MM-DD HH24:MI:SS.FF')", SERVER_NAME, SERVER_PROXY, CALLING_APPLICATION_NAME, CALLING_SERVICE_NAME, CALLED_SERVICE_NAME, CALLED_METHOD_NAME, RESPONSE_TIME, TRANSACTION_SEQUENCE_NUMBER, VERSION, USER_ID, VPAR, LNIATA )

                        ERROR LOG:
                        Insert option in effect for this table: INSERT
                        TRAILING NULLCOLS option in effect

                        Column Name Position Len Term Encl Datatype
                        ------------------------------ ---------- ----- ---- ---- ---------------------
                        TRANSACTION_ID FIRST * ' CHARACTER
                        EXECUTION_DATE NEXT * ' CHARACTER
                        SQL string for column : "TO_TIMESTAMP(:EXECUTION_DATE, 'YYYY-MM-DD HH24:MI:SS.FF')"
                        SERVER_NAME NEXT * ' CHARACTER
                        SERVER_PROXY NEXT * ' CHARACTER
                        CALLING_APPLICATION_NAME NEXT * ' CHARACTER
                        CALLING_SERVICE_NAME NEXT * ' CHARACTER
                        CALLED_SERVICE_NAME NEXT * ' CHARACTER
                        CALLED_METHOD_NAME NEXT * ' CHARACTER
                        RESPONSE_TIME NEXT * ' CHARACTER
                        TRANSACTION_SEQUENCE_NUMBER NEXT * ' CHARACTER
                        VERSION NEXT * ' CHARACTER
                        USER_ID NEXT * ' CHARACTER
                        VPAR NEXT * ' CHARACTER
                        LNIATA NEXT * ' CHARACTER

                        Record 1: Rejected - Error on table CEBSLOG_ADMIN.ETICKETING, column EXECUTION_DATE.
                        ORA-01841: (full) year must be between -4713 and +9999, and not be 0


                        Table CEBSLOG_ADMIN.ETICKETING:
                        0 Rows successfully loaded.
                        1 Row not loaded due to data errors.
                        0 Rows not loaded because all WHEN clauses were failed.
                        0 Rows not loaded because all fields were null.


                        Space allocated for bind array: 231168 bytes(64 rows)
                        Read buffer bytes: 1048576

                        Total logical records skipped: 0
                        Total logical records read: 1
                        Total logical records rejected: 1
                        Total logical records discarded: 0

                        Run began on Thu Jan 07 10:59:10 2010
                        Run ended on Thu Jan 07 10:59:10 2010

                        Elapsed time was: 00:00:00.09
                        CPU time was: 00:00:00.02
                        /export/home/x7065/Perl/Oracle $
                        • 9. Re: sqlldr control file with to_date fails
                          Rajesh Chamarthi
                          I am sorry...You need to change the optionally enclosed clause and not the fields terminated by clause...
                          All the other explanation holds good...the clause should be ....
                          fields terminated by ',' optionally enclosed by "'"
                          Correctd my earlier post too.


                          Hope this helps,
                          Rajesh.
                          • 10. Re: sqlldr control file with to_date fails
                            690317
                            Thank You Rajesh - It is now working with:
                            load data
                            infile '/tmp/x7065/ETicketing_oneline'
                            into TABLE CEBSLOG_ADMIN.ETICKETING
                            fields terminated by "," optionally enclosed by "'" TRAILING NULLCOLS

                            ( TRANSACTION_ID, EXECUTION_DATE "TO_TIMESTAMP(:EXECUTION_DATE, 'YYYY-MM-DD HH24:MI:SS.FF')", SERVER_NAME, SERVER_PROXY, CALLING_APPLICATION_NAME, CALLING_SERVICE_NAME, CALLED_SERVICE_NAME, CALLED_METHOD_NAME, RESPONSE_TIME, TRANSACTION_SEQUENCE_NUMBER, VERSION, USER_ID, VPAR, LNIATA )