grepping the output of a command in an if statement Post: 302124223

10 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

Want to use the output of Select statement in Unix script

Hi, I have a UNIX script which calls SQL Select statement: Now i want to use the output of that select statement within my UNIX script so as to call different shell script depending upon the output of the select statement. Can anyone help me in this regard. TIA Akhil Goel

2. HP-UX

SQL statement output to Log file-How?

Hi all, I need to bring the message to log file.Teradat/Hp-Ux script: ----- ### Update Log Table bteq <<- EOC .run file ${SRC_DATA}/logon.txt .run file ${SRC_DATA}/dbstagebteq.txt .set format off .set foldline off all .set sidetitles off ...

3. Shell Programming and Scripting

Output of both the echo statement in one line

I have script like echo -n FINISHED FEXP: ${TABLE2EXP} echo $STATUS I want the output of both the echo statement in one line How can i do this

4. UNIX for Dummies Questions & Answers

Command display output on console and simultaneously save the command and its output

Hi folks, Please advise which command/command line shall I run; 1) to display the command and its output on console 2) simultaneous to save the command and its output on a file I tried tee command as follows; $ ps aux | grep mysql | tee /path/to/output.txt It displayed the...

5. Shell Programming and Scripting

Awk output to file in IF statement

Hi all, I currently have the following script in 1) which outputs to a file if the 3rd column is equal to the message_id value. This works. However what I want to do is incorporate an else statement and output to a different file if the 3rd column doesnt equal the message_id values. I tried that...

6. Shell Programming and Scripting

Redirect output of print statement to file

:confused: I have a ksh script which gathers data from a file. I need to find a way to direct the output to a new file. The code looks something like this: DUP_FILE=`touch /export/.../.../dup_social_$1` while (($# > 0 )) do # Make sure the file exists if ] then print "$1: does not...

7. Shell Programming and Scripting

bash case statement output help

greetings, I have a script that is taking input like this: a b c d aa bb aaa bbb ccc ddd and formating it to be like this: a b c d aa bb aaa bbb ccc ddd

8. Shell Programming and Scripting

Unix shell command output to a sql statement

Can i do this Say one command sed 's/:*/ /g' $summf is returning C1234 C2345 C3434 some no of rows, now this ouput i have to insert it into a DB table how do i do this??

9. Shell Programming and Scripting

How to grep the grant statement and output to the different files?

Hi currently I have a list of *.sql files. one of the file, terminal is Prompt Table TERMINAL; CREATE TABLE TERMINAL ( TERMINAL_ID NUMBER(8), EXCEL_TERMINAL_ID NUMBER(8), MERCHANT_ID NUMBER(8), SETTLE_TIME VARCHAR2(4 CHAR) ); COMMENT...

10. Shell Programming and Scripting

Insert title as output of command to appended file if no output from command

I am using UNIX to create a script on our system. I have setup my commands to append their output to an outage file. However, some of the commands return no output and so I would like something to take their place. What I need The following command is placed at the prompt: TICLI...

LEARN ABOUT OSX

execute

EXECUTE(7)                                                         SQL Commands                                                         EXECUTE(7)

NAME

       EXECUTE - execute a prepared statement

SYNOPSIS

       EXECUTE name [ ( parameter [, ...] ) ]

DESCRIPTION

       EXECUTE  is  used  to execute a previously prepared statement. Since prepared statements only exist for the duration of a session, the pre-
       pared statement must have been created by a PREPARE statement executed earlier in the current session.

       If the PREPARE statement that created the statement specified some parameters, a compatible set of parameters must be passed to the EXECUTE
       statement,  or  else an error is raised. Note that (unlike functions) prepared statements are not overloaded based on the type or number of
       their parameters; the name of a prepared statement must be unique within a database session.

       For more information on the creation and usage of prepared statements, see PREPARE [prepare(7)].

PARAMETERS

       name   The name of the prepared statement to execute.

       parameter
              The actual value of a parameter to the prepared statement. This must be an expression yielding a value that is compatible  with  the
              data type of this parameter, as was determined when the prepared statement was created.

OUTPUTS

       The command tag returned by EXECUTE is that of the prepared statement, and not EXECUTE.

EXAMPLES

       Examples are given in the Examples [prepare(7)] section of the PREPARE [prepare(7)] documentation.

COMPATIBILITY

       The  SQL  standard includes an EXECUTE statement, but it is only for use in embedded SQL. This version of the EXECUTE statement also uses a
       somewhat different syntax.

SEE ALSO

       DEALLOCATE [deallocate(7)], PREPARE [prepare(7)]

SQL - Language Statements                                           2010-05-14                                                          EXECUTE(7)

10 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

Want to use the output of Select statement in Unix script

Discussion started by: akhilgoel9

2. HP-UX

SQL statement output to Log file-How?

Discussion started by: vsubbu1000

3. Shell Programming and Scripting

Output of both the echo statement in one line

Discussion started by: scorp_rahul23

4. UNIX for Dummies Questions & Answers

Command display output on console and simultaneously save the command and its output

Discussion started by: satimis