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

All,

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

Thanks
Chenni