Query truncation

deleted_user — Wed, 11 Aug 2010 21:41:46 GMT

Hi!

I created a SAS file on the server but now when I am trying to run this SAS file , it says the query is truncated.
However, if I see the actual SAS file the query is not truncated and looks perfect . Any suggestions to fix this? Given below is the job log
35 rsubmit SAS1;
NOTE: Remote submit to SAS1 commencing.
293 %dbcon(teradata);

DBCON - teradata macrovariable resolves to:
teradata as teradata (user=XXXX password="XXXXXXXX" tdpid=grp2 mode='teradata' )

294 option nosgen nomlogic nosource2 compress=yes;
295 %inc "server name/test.sa_&dt..sas" ;
NOTE: SQL Statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: SQL Statement used (Total process time):
real time 0.43 seconds
cpu time 0.01 seconds

WARNING: Truncated record.
ERROR: Teradata prepare: Syntax error, expected something like an 'ON' keyword between the word 'c'
and ';'. SQL statement was: SELECT A.* FROM USER_WORK.table1 A INNER JOIN USER_work.table2 B ON A.ID = B.ID AND INNER JOIN
user_wrk.table 3 c.

My SAS file has the entire query in a single line? Will this cause truncation?

Re: Query truncation

Doc_Duke — Thu, 12 Aug 2010 02:31:59 GMT

Generally yes. We can't tell without the code, but it looks like it might be a pass-through query. In that case the line size limit of teradata is likely to come into play.

You should check the teradata companion for SAS. Message was edited by: Doc@Duke

topic Query truncation in SAS Programming

Query truncation

Re: Query truncation