Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    5

    Unanswered: how to get the quantity from output of sql query command

    I want to know how to get the quantity from output of sql query command

    for example, I could get the container name by below command

    select container_name from sysibmadm.snapcontainer

    get the container number by

    select TBSP_NUM_CONTAINERS from SYSIBMADM.SNAPTBSP_PART

    now I want to get the container number by below command output result
    select container_name from sysibmadm.snapcontainer
    so what more command should I add on above command, I mean I want to get the container number by container name from the output of above command, not by 'join'.
    Thank you in advance.

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    It will help if you show some sample data from the input tables and what you want as the result of the query when exeduted.

Posting Permissions

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