Search code examples
db2

Access SAP Tables in DB2

I have a DB2 database, where few of the tablenames are starting with '/'. eg: /dev/r32

How can I query on the above table?

I have tried with the following approaches:

select * from schemaname./dev/r32

select * from schemaname.'/dev/r32'

select * from schemaname."/dev/r32"

But I am getting the following error:

An error occurred when executing the SQL command:
select * from schemaname."/dev/r32"

[SQL0204] /dev/r32 in schemaname type *FILE not found. [SQL State=42704, DB Errorcode=-204]

describe schemaname."/dev/r32" works.

Any help would be appreciated.

Solution

  • The table names are changed and issue is resolved.