Unrecognised SQL Stament Error in Teradata API Stage

[kpavan2004]

Hi ,

I am using User Defined SQL while extracting data from Teradata Table . In the sql i am using aggregate funtion max(). When i run the job i am getting the error message "Unrecognised SQL statement" . Can't we use aggregate funtions in Teradata API Stage?. Or Else do we need to use aggregate stage to calculate Max()? The same query is working fine in Teradata SQL Assistant. Could anyone please help on this?

Query:
SELECT MAX(COL1) FROM TABLE

[chulett]

Try:

SELECT MAX(COL1) as COL1 FROM TABLE

And see if that helps. Make sure the "as" column alias matches the name you've given the column in the stage.

[kpavan2004]

Try:

SELECT MAX(COL1) as COL1 FROM TABLE

And see if that helps. Make sure the "as" column alias matches the name you've given the column in the stage.

Thanks very much Chulett. It solved my problem. :D