Archives of the TeradataForum

Message Posted: Thu, 20 Apr 2006 @ 13:29:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If you are loading the data from a mainframe, BTEQ, FastLoad, and MultiLoad will do this conversion automagically. Just define the input data as decimal(13,2) and load it to a decimal(13,2) field.

If this data has somehow found its way to a Unix or Windows machine, you will have to convert it to a double or a printed string before loading it. Perl module Convert::IBM390 can do this. It is easiest if the Unix administrator agrees to install the module, but this is not necessary; "use lib" will allow you to install the module in your own library and load it at run time. You could even steal the packed2num conversion routine from the module.

	<Prev	Next>		<<First	<Prev	Next>	Last>>