Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: db2pd -dynamic: How to get output in single row?

    Hi,
    on DB2 10.1 on Linux I would like to get dynamic statements displayed with command:
    Code:
    db2pd -db <mydb> -dynamic
    I get an output, but in "Dynamic SQL Statements" section I see Text column is braking statements in multiple row:
    Code:
    Dynamic SQL Statements:
    Address            AnchID StmtUID    NumEnv     NumVar     NumRef     NumExe     Text 
    0x000003FDF6D6B300 510    1          1          1          1          1          update admin.test set
        b='jagoda' where a=1
    0x000003FDF71CC9C0 510    2          1          1          1          1          update admin.test2 set
        TEZASAR = TEZASAR + 1000 where sarza = '162822            '
    0x000003FDF6F03C80 513    1          1          1          2          2          SELECT COUNT(*) AS STZAP FROM
        admin.test3 WHERE STSARZE='162822'
    0x000003FDF719C400 518    1          1          1          1          1          update admin.test4 set
        kolicina = kolicina - 1000, koli = koli + 1000 where firma ='02' and kolicina >= 1000
    ... and many many row ..
    Is there any way to get them back to single row? I would like to get result:
    Code:
    Dynamic SQL Statements:
    Address            AnchID StmtUID    NumEnv     NumVar     NumRef     NumExe     Text 
    0x000003FDF6D6B300 510    1          1          1          1          1          update admin.test set    b='jagoda' where a=1
    0x000003FDF71CC9C0 510    2          1          1          1          1          update admin.test2 set     TEZASAR = TEZASAR + 1000 where sarza = '162822            '
    0x000003FDF6F03C80 513    1          1          1          2          2          SELECT COUNT(*) AS STZAP FROM     admin.test3 WHERE STSARZE='162822'
    0x000003FDF719C400 518    1          1          1          1          1          update admin.test4 set     kolicina = kolicina - 1000, koli = koli + 1000 where firma ='02' and kolicina >= 1000
    ... and many many row ..
    How to multiple Text rows in single row?
    Thanks
    Last edited by grofaty; 08-05-13 at 03:23.

Posting Permissions

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