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?
NOTICE: 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.
This topic has been locked.