topic Re: while i am pushing data from the oracle to Teradatra issues is that if defined BIG INT data type in SAS Data Management

Pushing BIGINT data from Oracle to Teradata issue

ganeshmule — Mon, 14 Nov 2016 12:58:43 GMT

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.....

Re: while i am pushing data from the oracle to Teradatra issues is that if defined BIG INT data type

Kurt_Bremser — Mon, 14 Nov 2016 12:39:41 GMT

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.

Re: while i am pushing data from the oracle to Teradatra issues is that if defined BIG INT data type

LinusH — Mon, 14 Nov 2016 12:49:42 GMT

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.

Re: Pushing BIGINT data from Oracle to Teradata issue

JBailey — Mon, 14 Nov 2016 15:08:57 GMT

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

Re: while i am pushing data from the oracle to Teradatra issues is that if defined BIG INT data type

ganeshmule — Mon, 14 Nov 2016 15:19:50 GMT

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

Re: while i am pushing data from the oracle to Teradatra issues is that if defined BIG INT data type

Kurt_Bremser — Mon, 14 Nov 2016 16:40:32 GMT

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.