topic Re: How to use Talend Keyword in select Query in Talend Studio

How to use Talend Keyword in select Query

Anonymous — Sat, 16 Nov 2024 04:33:20 GMT

Hello All,

Hope you are doing good,

I have been facing some problem while querying my table from tDBInput component,

Actually my table has the Column name as "DATETIME" when i try to query (Select DATETIME from tablename) the table, i was getting the error like java.sql.SQLSyntaxErrorException: ORA-00936: missing expression. Is there any possibilities to escape the/use talend keyword in query?

"SELECT
"+context.DB_Schema+".MYTABLE.\"DATETIME \"
FROM "+context.DB_Schema+".MYTABLE"

then I tried below( this also getting error)

"SELECT
"+"\"DATETIME\""+" FROM MYTABLE"

Re: How to use Talend Keyword in select Query

TRF — Thu, 26 Sep 2019 14:57:55 GMT

I'm afraid that DATETIME is an Oracle SQL reserved word.

Re: How to use Talend Keyword in select Query

Anonymous — Thu, 26 Sep 2019 18:02:32 GMT

Hi,

I agree with TRF. DATETIME is a reserved keyword and ideally we should not use these keywords while creating column names. Please refer the Oracle documentation below.

https://docs.oracle.com/cd/E17952_01/mysql-5.1-en/datetime.html#targetText=The%20supported%20range%20is%20'1000,23%3A59%3A59'%20.

The right approach will be to choose another name for your column which will not conflict with keyword settings.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: How to use Talend Keyword in select Query

Anonymous — Thu, 26 Sep 2019 18:32:42 GMT

Thank you,

Without changing the column name in the table(Should not change), Need to handle this inside the tDbInput component. Can anybody help on this.

Re: How to use Talend Keyword in select Query

Anonymous — Thu, 26 Sep 2019 18:42:02 GMT

Hi Vignesh,

Its an Oracle DB error. Could you please check whether the query is working from SQL Prompt or Oracle SQL Assistant?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: How to use Talend Keyword in select Query

Anonymous — Fri, 27 Sep 2019 06:11:22 GMT

yes the query is perfectly working sql prompt.

Select DATETIME from tablename;

listing the result correctly.