+ Reply to Thread
Results 1 to 10 of 10

Specifying the CLOBs in SQLLOADER control files

  1. Re: Specifying the CLOBs in SQLLOADER control files

    On 12 Aug 2006 22:23:07 -0700, VenkataRamesh.Kommoju@gmail.com wrote:

    >hi,
    >
    >i have a column of length 4211 from the DB2 which is already loaded
    >into the datafile in EBCDIC format.
    >
    >I am loading the data into the oracle tables using the charcter set
    >clause from EBCDIC to ASCII.
    >
    >when i specify a column with CLOB datatype i am getting a syntax error.
    >
    >
    >Please let me know how to load a colunm with CLOB data type in the
    >oracle databaase tabel.
    >
    >thanks
    >Ramesh


    Without
    - the Oracle version
    - the exact control file
    - the exact syntax error

    No one here will be capable to resolve your problem and you'd better
    not posted this three times.

    --
    Sybrand Bakker, Senior Oracle DBA

  2. Re: Specifying the CLOBs in SQLLOADER control files

    On 12 Aug 2006 22:23:07 -0700, VenkataRamesh.Kommoju@gmail.com wrote:

    >hi,
    >
    >i have a column of length 4211 from the DB2 which is already loaded
    >into the datafile in EBCDIC format.
    >
    >I am loading the data into the oracle tables using the charcter set
    >clause from EBCDIC to ASCII.
    >
    >when i specify a column with CLOB datatype i am getting a syntax error.
    >
    >
    >Please let me know how to load a colunm with CLOB data type in the
    >oracle databaase tabel.
    >
    >thanks
    >Ramesh


    Without
    - the Oracle version
    - the exact control file
    - the exact syntax error

    No one here will be capable to resolve your problem and you'd better
    not posted this three times.

    --
    Sybrand Bakker, Senior Oracle DBA

  3. Re: Specifying the CLOBs in SQLLOADER control files

    version is 10g,

    control file is
    LOAD DATA CHARACTERSET WE8EBCDIC1140
    INFILE 'TGEN683.DAT' "FIX 4174"
    INTO TABLE CGEN.TGEN683
    TRUNCATE
    TRAILING NULLCOLS
    (
    ITN_IDN_CDE POSITION( 1 )
    CHAR( 4) ,
    HKP_PCS_CDE POSITION( 5 )
    CHAR( 4) ,
    ETY_IDN_CDE POSITION( 9 )
    CHAR( 4) ,
    HKP_PCS_DTE POSITION( 13 )
    DATE(10) "DD.MM.YYYY" ,
    ETY_FLD_NBR POSITION( 23 )
    SMALLINT ,
    LST_UPD_DTE POSITION( 25 )
    DATE(10) "DD.MM.YYYY" ,
    LST_UPD_TME POSITION( 35 )
    CHAR(8) ,
    LST_UPD_UID POSITION( 43 )
    CHAR( 8) ,
    LST_UPD_NBR POSITION( 51 )
    SMALLINT ,
    ETY_FLD_TXT POSITION( 53 )
    CLOB
    )


    syntax error is
    =============

    SQL*Loader: Release 10.2.0.1.0 - Production on Sat Aug 12 06:39:35 2006

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

    SQL*Loader-350: Syntax error at line 26.
    Expecting valid column specification, "," or ")", found "CLOB".
    CLOB
    ^


    Sybrand Bakker wrote:

    > On 12 Aug 2006 22:23:07 -0700, VenkataRamesh.Kommoju@gmail.com wrote:
    >
    > >hi,
    > >
    > >i have a column of length 4211 from the DB2 which is already loaded
    > >into the datafile in EBCDIC format.
    > >
    > >I am loading the data into the oracle tables using the charcter set
    > >clause from EBCDIC to ASCII.
    > >
    > >when i specify a column with CLOB datatype i am getting a syntax error.
    > >
    > >
    > >Please let me know how to load a colunm with CLOB data type in the
    > >oracle databaase tabel.
    > >
    > >thanks
    > >Ramesh

    >
    > Without
    > - the Oracle version
    > - the exact control file
    > - the exact syntax error
    >
    > No one here will be capable to resolve your problem and you'd better
    > not posted this three times.
    >
    > --
    > Sybrand Bakker, Senior Oracle DBA



  4. Re: Specifying the CLOBs in SQLLOADER control files

    version is 10g,

    control file is
    LOAD DATA CHARACTERSET WE8EBCDIC1140
    INFILE 'TGEN683.DAT' "FIX 4174"
    INTO TABLE CGEN.TGEN683
    TRUNCATE
    TRAILING NULLCOLS
    (
    ITN_IDN_CDE POSITION( 1 )
    CHAR( 4) ,
    HKP_PCS_CDE POSITION( 5 )
    CHAR( 4) ,
    ETY_IDN_CDE POSITION( 9 )
    CHAR( 4) ,
    HKP_PCS_DTE POSITION( 13 )
    DATE(10) "DD.MM.YYYY" ,
    ETY_FLD_NBR POSITION( 23 )
    SMALLINT ,
    LST_UPD_DTE POSITION( 25 )
    DATE(10) "DD.MM.YYYY" ,
    LST_UPD_TME POSITION( 35 )
    CHAR(8) ,
    LST_UPD_UID POSITION( 43 )
    CHAR( 8) ,
    LST_UPD_NBR POSITION( 51 )
    SMALLINT ,
    ETY_FLD_TXT POSITION( 53 )
    CLOB
    )


    syntax error is
    =============

    SQL*Loader: Release 10.2.0.1.0 - Production on Sat Aug 12 06:39:35 2006

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

    SQL*Loader-350: Syntax error at line 26.
    Expecting valid column specification, "," or ")", found "CLOB".
    CLOB
    ^


    Sybrand Bakker wrote:

    > On 12 Aug 2006 22:23:07 -0700, VenkataRamesh.Kommoju@gmail.com wrote:
    >
    > >hi,
    > >
    > >i have a column of length 4211 from the DB2 which is already loaded
    > >into the datafile in EBCDIC format.
    > >
    > >I am loading the data into the oracle tables using the charcter set
    > >clause from EBCDIC to ASCII.
    > >
    > >when i specify a column with CLOB datatype i am getting a syntax error.
    > >
    > >
    > >Please let me know how to load a colunm with CLOB data type in the
    > >oracle databaase tabel.
    > >
    > >thanks
    > >Ramesh

    >
    > Without
    > - the Oracle version
    > - the exact control file
    > - the exact syntax error
    >
    > No one here will be capable to resolve your problem and you'd better
    > not posted this three times.
    >
    > --
    > Sybrand Bakker, Senior Oracle DBA



  5. Re: Specifying the CLOBs in SQLLOADER control files

    On 13 Aug 2006 00:26:56 -0700, "Rams"
    wrote:

    >syntax error is
    >=============
    >
    >SQL*Loader: Release 10.2.0.1.0 - Production on Sat Aug 12 06:39:35 2006
    >
    >Copyright (c) 1982, 2005, Oracle. All rights reserved.
    >
    >SQL*Loader-350: Syntax error at line 26.
    >Expecting valid column specification, "," or ")", found "CLOB".
    >CLOB
    >^


    Please do two things
    1 stop top-posting
    2 refer to the doco at
    http://uk.oracle.com/docs/cd/B10501_...07.htm#1006820

    --
    Sybrand Bakker, Senior Oracle DBA

  6. Re: Specifying the CLOBs in SQLLOADER control files

    On 13 Aug 2006 00:26:56 -0700, "Rams"
    wrote:

    >syntax error is
    >=============
    >
    >SQL*Loader: Release 10.2.0.1.0 - Production on Sat Aug 12 06:39:35 2006
    >
    >Copyright (c) 1982, 2005, Oracle. All rights reserved.
    >
    >SQL*Loader-350: Syntax error at line 26.
    >Expecting valid column specification, "," or ")", found "CLOB".
    >CLOB
    >^


    Please do two things
    1 stop top-posting
    2 refer to the doco at
    http://uk.oracle.com/docs/cd/B10501_...07.htm#1006820

    --
    Sybrand Bakker, Senior Oracle DBA

  7. Specifying the CLOBs in SQLLOADER control files

    hi,

    i have a column of length 4211 from the DB2 which is already loaded
    into the datafile in EBCDIC format.

    I am loading the data into the oracle tables using the charcter set
    clause from EBCDIC to ASCII.

    when i specify a column with CLOB datatype i am getting a syntax error.


    Please let me know how to load a colunm with CLOB data type in the
    oracle databaase tabel.

    thanks
    Ramesh


  8. Re: Specifying the CLOBs in SQLLOADER control files

    On 12 Aug 2006 22:23:07 -0700, VenkataRamesh.Kommoju@gmail.com wrote:

    >hi,
    >
    >i have a column of length 4211 from the DB2 which is already loaded
    >into the datafile in EBCDIC format.
    >
    >I am loading the data into the oracle tables using the charcter set
    >clause from EBCDIC to ASCII.
    >
    >when i specify a column with CLOB datatype i am getting a syntax error.
    >
    >
    >Please let me know how to load a colunm with CLOB data type in the
    >oracle databaase tabel.
    >
    >thanks
    >Ramesh


    Without
    - the Oracle version
    - the exact control file
    - the exact syntax error

    No one here will be capable to resolve your problem and you'd better
    not posted this three times.

    --
    Sybrand Bakker, Senior Oracle DBA

  9. Re: Specifying the CLOBs in SQLLOADER control files

    version is 10g,

    control file is
    LOAD DATA CHARACTERSET WE8EBCDIC1140
    INFILE 'TGEN683.DAT' "FIX 4174"
    INTO TABLE CGEN.TGEN683
    TRUNCATE
    TRAILING NULLCOLS
    (
    ITN_IDN_CDE POSITION( 1 )
    CHAR( 4) ,
    HKP_PCS_CDE POSITION( 5 )
    CHAR( 4) ,
    ETY_IDN_CDE POSITION( 9 )
    CHAR( 4) ,
    HKP_PCS_DTE POSITION( 13 )
    DATE(10) "DD.MM.YYYY" ,
    ETY_FLD_NBR POSITION( 23 )
    SMALLINT ,
    LST_UPD_DTE POSITION( 25 )
    DATE(10) "DD.MM.YYYY" ,
    LST_UPD_TME POSITION( 35 )
    CHAR(8) ,
    LST_UPD_UID POSITION( 43 )
    CHAR( 8) ,
    LST_UPD_NBR POSITION( 51 )
    SMALLINT ,
    ETY_FLD_TXT POSITION( 53 )
    CLOB
    )


    syntax error is
    =============

    SQL*Loader: Release 10.2.0.1.0 - Production on Sat Aug 12 06:39:35 2006

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

    SQL*Loader-350: Syntax error at line 26.
    Expecting valid column specification, "," or ")", found "CLOB".
    CLOB
    ^


    Sybrand Bakker wrote:

    > On 12 Aug 2006 22:23:07 -0700, VenkataRamesh.Kommoju@gmail.com wrote:
    >
    > >hi,
    > >
    > >i have a column of length 4211 from the DB2 which is already loaded
    > >into the datafile in EBCDIC format.
    > >
    > >I am loading the data into the oracle tables using the charcter set
    > >clause from EBCDIC to ASCII.
    > >
    > >when i specify a column with CLOB datatype i am getting a syntax error.
    > >
    > >
    > >Please let me know how to load a colunm with CLOB data type in the
    > >oracle databaase tabel.
    > >
    > >thanks
    > >Ramesh

    >
    > Without
    > - the Oracle version
    > - the exact control file
    > - the exact syntax error
    >
    > No one here will be capable to resolve your problem and you'd better
    > not posted this three times.
    >
    > --
    > Sybrand Bakker, Senior Oracle DBA



  10. Re: Specifying the CLOBs in SQLLOADER control files

    On 13 Aug 2006 00:26:56 -0700, "Rams"
    wrote:

    >syntax error is
    >=============
    >
    >SQL*Loader: Release 10.2.0.1.0 - Production on Sat Aug 12 06:39:35 2006
    >
    >Copyright (c) 1982, 2005, Oracle. All rights reserved.
    >
    >SQL*Loader-350: Syntax error at line 26.
    >Expecting valid column specification, "," or ")", found "CLOB".
    >CLOB
    >^


    Please do two things
    1 stop top-posting
    2 refer to the doco at
    http://uk.oracle.com/docs/cd/B10501_...07.htm#1006820

    --
    Sybrand Bakker, Senior Oracle DBA

+ Reply to Thread