Skip to Content
avatar image
-1
Former Member

hdsql can not select result

Hi Expert:

I have to select some views for results in hana studio , but I excute the same sql in hdsql ,that can not get any result.why is it happened?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 23, 2017 at 05:05 AM

    You wrote that you are using the same user logon.

    Please double check this with

    SELECT current_user from dummy;

    Also, if your view uses TEXTJOINs to generate language dependent text, please check the current session context and compare for both the HANA SQL Studio session and the hdbsql session:

    SELECT * FROM M_SESSION_CONTEXT 
    WHERE connection_id = current_connection;
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Lars:

      The problem had been solved, its reason is that language is inconsistent, so there is default english and has no english descriptions. I have changed the language for hdbsql using to the command '\cl LOCELE=zh;LOCALE_SAP=1'

      And I have found another problem that is the field type of database table in hana if it is Varchar maybe happened some problem,example:

      * -10427: Conversion of parameter/column (3) from data type VARCHAR1 to ASCII failed

      It is caused to conversion field's type, So I changed the field's type from varchar to nvarchar. then it is all ok.

      Thank you very much again.

      vooun.png (35.5 kB)