UDFCALLNAME, date problem

Analytics
Enthusiast

UDFCALLNAME, date problem

Hi, I have a query:
Pseudocode is the following.
select a.*,
b.date
from table a
join table b
on condition

show " Syntax error, expected something like an 'UDFCALLNAME' keyword between '.' and the 'date' keyword "

select date from table b. result show date works as a function instead of a column name.

Anybody knows how to fix it?

2 REPLIES
Teradata Employee

Re: UDFCALLNAME, date problem

Hello,

Try as following:

SELECT "date" FROM Table1;
SELECT a."date" FROM Table1 a;

HTH.

Regards,

Adeel
Enthusiast

Re: UDFCALLNAME, date problem

Yeh! It works. The forum is really useful! Thanks a lot Adeel!!!