topic Is FastExport is a viable option when downloading data from Teradata. in SAS Programming https://communities.sas.com/t5/SAS-Programming/Is-FastExport-is-a-viable-option-when-downloading-data-from/m-p/131029#M260622 <HTML><HEAD></HEAD><BODY><P>select DATEPART(LATEST) format=DATE9.0<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from connection to TERAVW <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* dbms=TERADATA, connect options=(<A href="mailto:USER='1213144@LDAP'">USER='1213144@LDAP'</A> PASSWORD=XXXXX TDPID=dwprod2 CONNECTION=GLOBAL <BR />DBSLICEPARM=(ALL,2) MODE=TERADATA) */ <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ( SELECT MAX(SOR_DTM) AS LATEST FROM test1);</P><P><SPAN style="color: #ff0000;">Segmentation Violation In Task</SPAN> [ SQL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ]<BR />tryotcv+0x7c<BR />trget+0x260<BR />fetch+0x644<BR />sqxextr_get_next+0x27c<BR />next_common+0x1a0<BR />sqxslct_get_next+0xa8<BR />sqxslct_open+0x2c8<BR />sqxslct_init+0x140<BR />sqxexec+0x510<BR />process_sql+0xa58<BR />sqlloop+0x1dc<BR />sqlloop+0x38 -- bridge stub<BR />sassql+0x188<BR />vvtentr+0xf0<BR />_uc_trampoline</P></BODY></HTML> Fri, 08 Mar 2013 11:42:22 GMT HashimBasheer 2013-03-08T11:42:22Z Is FastExport is a viable option when downloading data from Teradata. https://communities.sas.com/t5/SAS-Programming/Is-FastExport-is-a-viable-option-when-downloading-data-from/m-p/131029#M260622 <HTML><HEAD></HEAD><BODY><P>select DATEPART(LATEST) format=DATE9.0<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from connection to TERAVW <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* dbms=TERADATA, connect options=(<A href="mailto:USER='1213144@LDAP'">USER='1213144@LDAP'</A> PASSWORD=XXXXX TDPID=dwprod2 CONNECTION=GLOBAL <BR />DBSLICEPARM=(ALL,2) MODE=TERADATA) */ <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ( SELECT MAX(SOR_DTM) AS LATEST FROM test1);</P><P><SPAN style="color: #ff0000;">Segmentation Violation In Task</SPAN> [ SQL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ]<BR />tryotcv+0x7c<BR />trget+0x260<BR />fetch+0x644<BR />sqxextr_get_next+0x27c<BR />next_common+0x1a0<BR />sqxslct_get_next+0xa8<BR />sqxslct_open+0x2c8<BR />sqxslct_init+0x140<BR />sqxexec+0x510<BR />process_sql+0xa58<BR />sqlloop+0x1dc<BR />sqlloop+0x38 -- bridge stub<BR />sassql+0x188<BR />vvtentr+0xf0<BR />_uc_trampoline</P></BODY></HTML> Fri, 08 Mar 2013 11:42:22 GMT https://communities.sas.com/t5/SAS-Programming/Is-FastExport-is-a-viable-option-when-downloading-data-from/m-p/131029#M260622 HashimBasheer 2013-03-08T11:42:22Z Re: Is FastExport is a viable option when downloading data from Teradata. https://communities.sas.com/t5/SAS-Programming/Is-FastExport-is-a-viable-option-when-downloading-data-from/m-p/131030#M260623 <HTML><HEAD></HEAD><BODY><P>What makes you think FAST EXPORT is causing that error? Why would SAS even call FAST EXPORT to return a single number?</P></BODY></HTML> Fri, 08 Mar 2013 18:59:39 GMT https://communities.sas.com/t5/SAS-Programming/Is-FastExport-is-a-viable-option-when-downloading-data-from/m-p/131030#M260623 Tom 2013-03-08T18:59:39Z