Pushing BIGINT data from Oracle to Teradata issue

[ganeshmule]

While reading and pushing BIGINT data type in teradata i am facing problem..if i create the table in teradara with one of the column defined data type IS BIGINT but it will not appear in sas di what i do......thanks in advance.....

[Kurt_Bremser]

In a standard SAS data step, there is no BIGINT data type. SAS only knows 8-byte real numeric data.

Either use a direct connection from one DB to the other, or take a look at PROC DS2, which has more datatypes, including BIGINT.

[LinusH]

There have been several threads on the communities dealing with this issue.

A quick search will hopefully give you some insight and alternatives how to proceed.

[ganeshmule]

Hi,
I have predefined library of Teradata which is has target blank tabkes only
definition is there and I have another source library of Oracle in that
table there is column xyz and that defined in Teradata xyz with bigint data
type ...when using sas di studio i am connecting to Oracle to Teradata
table that time Teradata table columns which is created in Teradata with
data type BIGINT NOT SHOW why is it happening only for BIGINT DATA TYPE
DEFINED NOT VISIBLE IN SAS DI STUDIO...so how I can achieve it

[Kurt_Bremser · Accepted solution]

DI Studio uses Base SAS and is therefore bound to its limitations.
Use a direct connection between the databases, or program it manually, using proc ds2.

[JBailey]

Hi @ganeshmule,

Check out...

Problem Note 39831: Problem occurs with BIGINT data types within SAS 9.2 (pay special attention to the environment variable at the bottom)

Usage Note 31560: Choosing your degree of numeric precision

Best wishes,

Jeff