Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    2

    Unanswered: comp-3 hv for count( column fn

    when we use comp-3 as host variable for count(*) it is actually faster & taking less CPU time than COMP & in the manual it is given that the host variable must be INTEGER Can you pls tell us why

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Please post the exact picture clause for COMP-3 and COMP that you used.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2006
    Posts
    2
    It is s9(8) comp Vs s9(11) comp-3

Posting Permissions

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