vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. |
| |||
| -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 http://www.dbforums.com/f8 Posted via http://dbforums.com |
| ||||
| 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$1@news3.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. > > |