Can anybody help me to resolve the following warning?
Syntax error: expected something between the beginning of the request and the end of the request.
My job has a Teradata API Stage as target in which I am running user-defined SQL to insert records into a Teradata table.
The SQL contains Teradata specific functions (which are not supported by ANSI).
When I execute this job, all the records are getting populated correctly but with the above warning.
Is it because I am using the Teradata specific SQL syntax? If yes, why is it so?
Please suggest.
Teradata API Stage Warning
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 47
- Joined: Fri Mar 18, 2005 5:59 am
Re: Teradata API Stage Warning
Has been posted in the forum quite a few times - Teradata API supports ANSI SQL. This error is seen to occur also if there are any charachters [ e.g, char(10), char(13) etc ]
Re: Teradata API Stage Warning
As there was no syntax error in my SQL following thing workednishadkapadia wrote:Has been posted in the forum quite a few times - Teradata API supports ANSI SQL. This error is seen to occur also if there are any charachters [ e.g, char(10), char(13) etc ]
Deleted complete After SQL, ran the job.
Pasted the SQL and then ran the Job