Parse SQL text and only format first SELECT statement. Post: 302850347

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Pipe SQL select statement results to script

Hello I would like to perform a select from a oracle table and return those values to my shell script For example: site=head -1 $infile | cut -c1-15 | awk '{printf "s%", $0} sqlplus -s /nolog |& #Open pipe to sql select col1, col2, col3, col4 from oracle_table where col5 =...

2. UNIX and Linux Applications

Oracle Select IN statement

If I recall, when I used informix I could do a sql statement like: SELECT Value from Table WHERE ID in (100,200,300); How do I do this in Oracle? I believe I am using Oracle 10 if that matters. Thanks.

3. Shell Programming and Scripting

using SELECT sql statement in shell script

Hi there I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this SN=123456 n=server1 m=x4140 sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';" echo $sql |/usr/sfw/bin/mysql -h...

4. Shell Programming and Scripting

How can i assign an select statement into a variable?

I am trying to assign an select statement into a variable. Can someone hel me with this. example : a='select * from dual' echo $a should give me select * from dual But this is not working. I trying with \ before * and quotes too.

5. Shell Programming and Scripting

Select variable within a if statement

i want to select a variable created and use it in a if statement, but not getting the desired results LINE='device for 0101a01: lpd://172.25.41.111:515' prt=`echo $LINE | awk '{print $3 }' | cut -c 1-7` echo $prt My if statement to select just what i want.. IFS=$":" while read prt...

6. Shell Programming and Scripting

for each value in an array, execute select statement

Hello All, I am new to shell scripting. I am working on Solaris O/S, bash script and sybase programming. I want to loop through multiple values in an array and for each value, I want to select a row from the database. following is the code written for it. output="loop.csv" ...

7. Shell Programming and Scripting

script to parse text file into sql commands

Hello all, I tried searching for something similiar before posting but couldn't come up with anything that fit what I need. In Linux, I'm trying to parse through a number of files and take the info in them and put it into mysql. My file is a dump from an expect script: ---filename...

8. Shell Programming and Scripting

Problem with select statement

Hi I have run out of ideas as to why this select doesn't work in a script I am writing. The script sources a file of common functions and I am trying to use a select statement within one of the functions - PS3="Try? " select X in CONT EXIT; do if ] ...

9. Shell Programming and Scripting

Help with awk statement to format text file.

Hello, I am fairly new to shellscripting and have written a script to check on messages file and report failed logins: Here is the original file: Jul 17 03:38:07 sfldmilx086 sshd: error: PAM: Authentication failure for houghn97 from 10.135.77.201 Jul 17 03:38:07 sfldmilx086 sshd: error:...

10. Shell Programming and Scripting

SQLPLUS command with more than 1 select statement

Hi all, I'm using below code processId=`sqlplus -s ${sysuser}/${syspwd} <<CHK_PROCESS whenever sqlerror exit sql.sqlcode; set head off feedback off echo off pages 0 SELECT PROCESS_ID FROM LSHADMIN.DATA_DOMAIN WHERE DOMAIN_NAME = '${tabname}' ...

LEARN ABOUT NETBSD

sleep

SLEEP(1)						    BSD General Commands Manual 						  SLEEP(1)

NAME

     sleep -- suspend execution for an interval of time

SYNOPSIS

     sleep seconds

DESCRIPTION

     The sleep utility suspends execution for a minimum of seconds.  It is usually used to schedule the execution of other commands (see EXAMPLES
     below).

     Note: The NetBSD sleep command will accept and honor a non-integer number of specified seconds.  This is a non-portable extension, and its
     use will nearly guarantee that a shell script will not execute properly on another system.

     When the SIGINFO signal is received, the estimate of the amount of seconds left to sleep is printed on the standard output.

EXIT STATUS

     The sleep utility exits with one of the following values:

     0	   On successful completion, or if the signal SIGALRM was received.

     >0    An error occurred.

EXAMPLES

     To schedule the execution of a command for 1800 seconds later:

	   (sleep 1800; sh command_file >& errors)&

     This incantation would wait half an hour before running the script command_file.  (See the at(1) utility.)

     To reiteratively run a command (with csh(1)):

	   while (1)
		   if (! -r zzz.rawdata) then
			   sleep 300
		   else
			   foreach i (*.rawdata)
				   sleep 70
				   awk -f collapse_data $i >> results
			   end
			   break
		   endif
	   end

     The scenario for a script such as this might be: a program currently running is taking longer than expected to process a series of files, and
     it would be nice to have another program start processing the files created by the first program as soon as it is finished (when zzz.rawdata
     is created).  The script checks every five minutes for the file zzz.rawdata, when the file is found, then another portion processing is done
     courteously by sleeping for 70 seconds in between each awk job.

SEE ALSO

     at(1), nanosleep(2), sleep(3)

STANDARDS

     The sleep command is expected to be IEEE Std 1003.2 (``POSIX.2'') compatible.

BSD
								  August 13, 2011							       BSD

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Pipe SQL select statement results to script

Discussion started by: houtakker

2. UNIX and Linux Applications

Oracle Select IN statement

Discussion started by: benefactr

3. Shell Programming and Scripting

using SELECT sql statement in shell script

Discussion started by: hcclnoodles

4. Shell Programming and Scripting

How can i assign an select statement into a variable?

Discussion started by: rdhanek