DATA Step, Macro, Functions and more

Query truncation

Posts: 0

Query truncation


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_&" ;
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?
Trusted Advisor
Posts: 2,113

Re: Query truncation

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
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation