Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2002 @ 12:02:26 GMT

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

Bill:

the DBTYPE_VARNUMERIC data type is not supported in TDATA and therefore, you need to cast it to character. One way to do this is from the command prompt (change the mode from 'Selection' to 'Command' in OLE Load), specify all the fields that you want to select from ORACLE. This is where you need to convert your data type and the ORACLE command is some thing like this: TO_CHAR( filedx , '0009') "new_data_field"

So your SQL from the command prompt would look some thing like this :

SELECT FIELD1, FIELD2, TO_CHAR( filedx , '0009') "new_data_field"
    FROM YOUR_ORACLE.TABLE;

Now, after saving your .amj go to the selection mode on OLE LOAD and you will see that youe fieldx is now a character field. Select it like any other fields and you are ready to go!

Hope this helps! Please let me know if you have any more questions.

Thanks --Mohommod

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