Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Red face Unanswered: Two Newb questions

    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
    select *
    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.

    Thank you!

  2. #2
    Join Date
    Oct 2002

    Re: Two Newb questions

    Never mind, found it out by random plugging of options.etc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts