Is FastExport is a viable option when downloading data from Teradata.

Reply
Contributor
Posts: 30

Is FastExport is a viable option when downloading data from Teradata.

select DATEPART(LATEST) format=DATE9.0
          from connection to TERAVW
                  /* dbms=TERADATA, connect options=(USER='1213144@LDAP' PASSWORD=XXXXX TDPID=dwprod2 CONNECTION=GLOBAL
DBSLICEPARM=(ALL,2) MODE=TERADATA) */
                  ( SELECT MAX(SOR_DTM) AS LATEST FROM test1);

Segmentation Violation In Task [ SQL      ]
tryotcv+0x7c
trget+0x260
fetch+0x644
sqxextr_get_next+0x27c
next_common+0x1a0
sqxslct_get_next+0xa8
sqxslct_open+0x2c8
sqxslct_init+0x140
sqxexec+0x510
process_sql+0xa58
sqlloop+0x1dc
sqlloop+0x38 -- bridge stub
sassql+0x188
vvtentr+0xf0
_uc_trampoline

Super User
Super User
Posts: 6,502

Re: Is FastExport is a viable option when downloading data from Teradata.

What makes you think FAST EXPORT is causing that error? Why would SAS even call FAST EXPORT to return a single number?

Ask a Question
Discussion stats
  • 1 reply
  • 172 views
  • 0 likes
  • 2 in conversation