SQL Console - invalid column name (JDBC-260)

[hans-jgen_forberger]

Hi together,

any ideas to the following problem.

I've created a table while importing csv-File into schema.

Data looks quite good with SQL Console as far as I use

select * from table;

When I try to enhance SQL-Statement by a where clause, i always get the error: invalid column name (SAP DBTech JDBC: [260]). I've tried with different columns but always the same error.

select * from table where column1 = 'XYZ'. Sure, column1 is an existing column of the table.

Kind regards,

Hans

[former_member182302 · Accepted solution]

Hi Hans,

Can you ping the output of the SELECT * FROM TABLE.

Also do check if it is because of Case sensitivity you are facing this issue.

Regards,

Krishna Tangudu

[hans-jgen_forberger · Accepted solution]

Thx Krishna,

I already solved it. Column names in table definition were lower case after import.

OMG, Good old Data Dictionary in SAP, never had to care about these things.

Regards,

Hans

[Former Member · Accepted solution]

Krishna,

I have the same or similar issue.

When I run "select * from table", there is no problem. But, when I run "select C1, Score from table",

I got the following error:

SAP DBTech JDBC: [260] (at 38): invalid column name: SCORE: line 1 col 39 (at pos 38)

I have tried different combination of upper or lower cases of the column names, still get the same error.

It looks like this problem always happens to the LAST column name.

Any idea how can I solve this problem?

Thanks.

Scott

[Former Member]

Krishna,

I have the same or similar issue.

When I run "select * from table", there is no problem. But, when I run "select C1, Score from table",

I got the following error:

SAP DBTech JDBC: [260] (at 38): invalid column name: SCORE: line 1 col 39 (at pos 38)

I have tried different combination of upper or lower cases of the column names, still get the same error.

It looks like this problem always happens to the LAST column name.

Any idea how can I solve this problem?

Thanks.

Scott

[vikas_ohri2]

Use "" quotes to specify the case sensitive column names & specify values according to their  type values.

for example

SET SCHEMA "<Schema name of My_Table>";

UPDATE  <My_Table>  SET "myField1doubleArgs" = 0.3 WHERE "myField2NameString" = 'HANA';

It should work -

cheers,

[Former Member]

thanks for the suggestion of using "" it really works