Integer to Charcter data load in DB2

IBM's flagship relational database management system
MFDEV
Posts: 15
Joined: Mon Dec 01, 2014 3:25 pm
Skillset: COBOL,JCL,DB2,CICS,COOLGEN,SELCOPY,INFORMATION EXPERT,QMF,SPUFI etc.,
Referer: I am working on Mainframe Applications

Integer to Charcter data load in DB2

Postby MFDEV » Tue Feb 07, 2017 10:30 pm

Earlier one of column data type is Integer and now it is changed to character(6) .
I want to load all existing data from Integer to new data type character.
How can this be achieve using load utility ? Does this need any conversation before load ?
Please suggest.
Thanks

  • Similar Topics
    Replies
    Views
    Last post