Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256

    Unanswered: load error SQL0302N

    While loading data through ETL most of the records are rejected with the following error-message:

    Code:
    SQL0302N  The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.  SQLSTATE=22003  sqlstate = 22003
    Can't find anything wrong with the data itself. (fieldlengths etc)
    Anyone any idea?
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  2. #2
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    Ah, forget it, some decimal fields were too small...........
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  3. #3
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    Ah, forget it, some decimal fields were too small...........
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •