Re: QSH db2 question

Thanks Scott.
Your first example is exactly what I was looking for.
I am using the QSH command in an interactive CL program to run an SQL command.

As always, I appreciate your help.
 
Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3
  
 






________________________________
From: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, April 14, 2009 11:58:57 PM
Subject: Re: QSH db2 question

You aren't very clear on what is meant by "interactive mode".  Do you
mean that you're running something like the following from a CL program
an in interactive job?

STRQSH CMD('db2 something something')

If so, then all you have to do is set QIBM_QSH_CMD_OUTPUT to NONE prior
to the STRQSH.

ADDENVVAR ENVVAR(QIBM_QSH_CMD_OUTPUT) +
          VALUE(NONE) REPLACE(*YES)
STRQSH CMD('db2 something something')

If by "interactive mode" you really mean that the user is running STRQSH
interactively and keying commands into the command-line, then the only
way I know to suppress output is to have the user type the appropriate
commands to redirect the output to /dev/null

If neither of this is what you meant by "interactive mode" then please
clarify what you meant...

Jeff Young wrote:

When using the db2 function to run an sql command from QSH, is there
any way I can suppress the terminal session when in interactive mode?