how can I turn off Standard OutPut when I use INSERT INTO command in my application.

M_RAS · #1 (**permalink**) 04-06-06, 16:34

I am working with db2v8.2.2 aix5.2

I my application (perl language) I use db2 "INSERT INTO........."

and I am going to insert 30000 rows and for every row I get message "SUCCESSFULL........" in screen, how can I turnoff that.

Thank you inadvance for your help.

sathyaram_s · #2 (**permalink**) 04-06-06, 17:02

One option is to redirect the output to /dev/null

M_RAS · #3 (**permalink**) 04-07-06, 08:31

Quote:

Originally Posted by sathyaram_s

One option is to redirect the output to /dev/null

Thank you sathyaram_s for your help, is it possible tell me other options?

Thank you again

sathyaram_s · #4 (**permalink**) 04-07-06, 08:44

Well, honestly, I haven't used Perl ... So, am unable to be of much help ...

Do you use DBI module to 'talk' with DB2 or do you do as a command line ?

Can you post an example piece of code you are trying to execute ? It will be useful if you can post a small program that can be run on its own ..

Sathyaram

Internet Services

Web Development

Digital Marketing

Consumer Tech