Archives of the TeradataForum

Message Posted: Fri, 06 Jan 2006 @ 15:37:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Listers:

I'm accessing Teradata from SAS through a "pass-through" facility. ie. the Teradata query is wrapped in SAS code, SAS takes care of shuffling the query to Teradata and dealing with the results. Something like this:

     proc sql;
             connection to teradata(user=blah pass=pswd);
             select * from connection to teradata (
                     select fld1, fld2 from teradata_table where x = 'Y'
             );
     quit;

Works great.

However, when I try to CREATE a SAS table from a Teradata SHOW VIEW, Teradata is returning the results where each line of the SHOW VIEW output is suffixed with only a carriage return, '0D'x. This is causing SAS to see the returned lines as one big line, and it's storing the result in ONE row of the SAS table I'm creating from the Teradata output:

     proc sql;
             connection to teradata(user=blah pass=pswd);
             create table SAS_table as
             select * from connection to teradata (
                     show view teradata_table_nm
             );
     quit;

The resulting SAS table has what you'd get from a concatenation of this nature:

     REPLACE VIEW DDWV01I.INS_TELECOM || '0D'x || (TELECOM_ID , ||
     '0D'x || CAPTR_DT , || '0D'x || AREA_CD , etc...

Question: Is there a Teradata option I can specify ( for example, like mode=ansi / teradata control case sensitivity ) that will instruct Teradata to return '0D0A'x at the end of EACH row in the SHOW TABLE/VIEW command?

Thanks.

	<Prev	Next>		<<First	<Prev	Next>	Last>>