User Profile

Collapse

Profile Sidebar

Collapse
Mo Nguyen
Mo Nguyen
Last Activity: Jul 6 '07, 06:20 PM
Joined: Jun 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Mo Nguyen
    replied to Comparison of two rows in a table using SQL ?
    in DB2
    What you need is a query with correlated subquery using Max:

    Select *
    from table1 a
    where IBPQTN =
    (select max(IBPQTN)
    from table1 b
    where a.IBPSUB = b.IBPSUB)
    See more | Go to post

      Leave a comment:

    • Mo Nguyen
      started a topic Declared Global Temporary Table on z/os v7
      in DB2

      Declared Global Temporary Table on z/os v7

      Hi All,

      I'm planning to write a stored procedure which will be executed million times a day by many people, and is planning to use Declared Global Temporary Tables. One of the concern: the static SQL statements that referenced the temp tables are incrementally bound at run time (SQL Reference volume 2). Should one be worried about these incremental bind? Will these binds update DB2 Catalog tables? How long with the bind take place?...
      See more | Go to post
      No activity results to display
      Show More
      Working...