Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    11

    Unanswered: Data conversion: CHAR(4) to SMALLINT

    All,

    OS: AIX 5.2
    UDB: V8.1
    FIXPAK: 4

    I am trying to load four byte char data into smallint field using LOAD utility, is there any option in the load syntax that can be used to do the data conversion before the load.

    On the mainframe, I've used DECIMAL EXTERNAL(4,0) to do the data conversion.

    Your help and suggestion will be greatly appreciated.

    TIA
    Chenni

  2. #2
    Join Date
    Oct 2003
    Posts
    11

    Re: Data conversion: CHAR(4) to SMALLINT

    All,

    UDB is doing the data conversion internally from char to smallint, so pLease ignore my earlier post.

    Thanks
    Chenni
    Originally posted by db2db2
    All,

    OS: AIX 5.2
    UDB: V8.1
    FIXPAK: 4

    I am trying to load four byte char data into smallint field using LOAD utility, is there any option in the load syntax that can be used to do the data conversion before the load.

    On the mainframe, I've used DECIMAL EXTERNAL(4,0) to do the data conversion.

    Your help and suggestion will be greatly appreciated.

    TIA
    Chenni

Posting Permissions

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