08-22-2011 11:19 AM
the Oracle tables the SAS access passthrough. The account numbers are
stored in the oracle databases as numeric (19 digits) and so if you
pull it down as normal (or using a libname), the last few digits lose
I tried the following and while the customer_id is character with 19
digits, it also loses precision (seems that the last 2-3 numbers are
connect to oracle as oradb (user=xxxxx password=’xxxxxxx'
create table dat.test as
select * from connection to oradb
SELECT to_char(account_number) as customer_id
from FLOW_RESULT where rownum<15
disconnect from oradb;
Any help woudl be much appreciated!
08-22-2011 12:04 PM
I have tried this. I also tried making it longer than 19 (more 9's) and I still lose precision.
In Teradata, cast works when you set the mode=teradata. But I don't know how to do this in Oracle.
Need further help from the community? Please ask a new question.