Professional Web Applications Themes

Suppressing return messages - IBM DB2

How can I suppress the messages that return from executing a SQL script like: 1 row(s) affected -- This electronic message may contain confidential or privileged information and is intended for the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please reply to the sender, then delete this e-mail. Thank you....

  1. #1

    Default Suppressing return messages

    How can I suppress the messages that return from executing a SQL script
    like: 1 row(s) affected


    --


    This electronic message may contain confidential or privileged information
    and is intended for the individual or entity named above. If you are not the
    intended recipient, be aware that any disclosure, copying, distribution or
    use of the contents of this information is prohibited. If you have received
    this electronic message in error, please reply to the sender, then delete
    this e-mail. Thank you.


    Byron Barnette Guest

  2. #2

    Default Re: Suppressing return messages


    -x option in the db2 command

    db2 -x "select * from sysibm.sysdummy1"

    Cheers
    Sathyaram

    Originally posted by Byron Barnette
    > How can I suppress the messages that return from executing a
    > SQL script
    > like: 1 row(s) affected
    >
    >
    > --
    >
    >
    > This electronic message may contain confidential or privileged
    > information
    > and is intended for the individual or entity named above. If you
    > are not the
    > intended recipient, be aware that any disclosure, copying,
    > distribution or
    > use of the contents of this information is prohibited. If you have
    > received
    > this electronic message in error, please reply to the sender,
    > then delete
    this e-mail. Thank you.

    --
    DB2 discussion also at [url]http://www.dbforums.com/f8[/url]


    Posted via [url]http://dbforums.com[/url]
    sathyaram_s Guest

  3. #3

    Default Re: Suppressing return messages

    db2 -x "sql statement"

    will remove the 1 rows selected but will also remove the column headings

    HTH

    robs

    "Byron Barnette" <bybarn_lexcominc.net> wrote in message
    news:bdmok6$7fjn$1news3.infoave.net...
    > How can I suppress the messages that return from executing a SQL script
    > like: 1 row(s) affected
    >
    >
    > --
    >
    >
    > This electronic message may contain confidential or privileged information
    > and is intended for the individual or entity named above. If you are not
    the
    > intended recipient, be aware that any disclosure, copying, distribution or
    > use of the contents of this information is prohibited. If you have
    received
    > this electronic message in error, please reply to the sender, then delete
    > this e-mail. Thank you.
    >
    >

    RobS Guest

Similar Threads

  1. Suppressing Windows Messages in full screen mode
    By nomorenicknames in forum Macromedia Flash Ad Development
    Replies: 1
    Last Post: January 13th, 01:18 AM
  2. best way to return error/success messages to client?
    By b in forum ASP.NET Web Services
    Replies: 1
    Last Post: February 14th, 10:15 PM
  3. suppressing header output
    By Alex Meaden in forum PHP Development
    Replies: 2
    Last Post: December 30th, 02:27 AM
  4. Suppressing logon window
    By 1SALz in forum ASP.NET Security
    Replies: 4
    Last Post: November 14th, 07:24 AM
  5. Replies: 3
    Last Post: September 18th, 04:36 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139