Just started using DB2 to query a DB yesterday, have multi-year experience in SQL, Oracle.
I'm trying to use the Command Center to write a query that will later be used in a web based application. How do I write multi-line queries?
select * from tblName --> Works OK
from tblName ----> returns error The command was processed as an SQL statement because it was not a valid Command Line Processor command
So, how do you continue to the next line? (told u it was a newb question)
Question #2 - the query results don't display in the query results tab even though I've checked 'automatically display query results in the query results page' under the Options.