Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: Equvalent of oracle dual in db2

    hi,

    I am looking for the equivalent sql statement: select * from dual to db2. What I basically need is a general sql statement to run after connecting to the db via connection pools to validate that the connection is working.

    thanks
    ayman

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Equvalent of oracle dual in db2

    Not sure why you want to validate that the connection is working ...

    But anyway, for current timestamp:


    values(current timestamp)

    or

    select current timestamp from sysibm.sysdummy1 ;

    Cheers

    Sathyaram


    Originally posted by ayman
    hi,

    I am looking for the equivalent sql statement: select * from dual to db2. What I basically need is a general sql statement to run after connecting to the db via connection pools to validate that the connection is working.

    thanks
    ayman
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2003
    Posts
    2

    thanks

    hey,

    when i tried that command, i got the following error:
    SQL0204 - SYSDUMMY1 in SYSIBM type *FILE not found.

    thanks
    ayman

Posting Permissions

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