Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SystemAdmin
SystemAdmin
6968 Posts
ACCEPTED ANSWER

Pinned topic Double Quotations for Objects.

‏2013-01-15T04:56:07Z |
My question is why there is case when you need to double quote object such as name of tables of fields.

When I refer to STAFF table in SAMPLE database, for example, SQL statement, db2 => select name from staff where dept = '20' , works but I need to double quote fields and tables for a table I created under the same schema in SAMPLE database.

Can anyone give me keyword that I can search and learn more about these differences?