Skip to Content
author's profile photo Former Member
Former Member

Problems with the syntax in DML statements

Hi All

I am facing a problem with the syntax of the sql statement Select.Each time upon using the complete hierarchical level of accessing fields, the output is getting displayed, otherwise its ending up with the errors:-

Upon using the Normal Syntax :-

select * from "ID "."CASE" where Name like 'GEORGE%' :-

Do I need to adjust some settings??

HanaSyntaxOp.png (6.9 kB)
hanaerror.png (5.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 14, 2016 at 01:10 PM

    Hi,

    In HANA, Table Column Names are case sensitive.

    In your Table, Column Name --> Name have been created in small letters.


    If you execute this SQL (without double quotes --> Name),

    select * from "ID "."CASE" where Name like 'GEORGE%'

    It will consider as "NAME". So It throw Invalid Column name error.


    So execute this SQL (with double quotes --> "Name")

    select * from "ID "."CASE" where "Name" like 'GEORGE%'

    It will be executed successfully.


    Regards,

    Muthuram

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.