Awk script to run a sql and print the output to an output file Post: 302653713

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

any possible to run sql result and output to file

Hi, I search all post...and no soluation about..if i would like to run a sql statement and output the result to txt file. for example, i usually run "sql" to logon the database and run select statement. Then I need to copy the output into the result.txt. Can I run the script to do this...

2. UNIX for Dummies Questions & Answers

using awk or sed to print output from one file

dear i have one file regarding >abshabja>sdksjbs>sknakna>snajxcls so i want to be output like >abshabja >sjkabjb >sknakna >snajxcls Any using awk or sed will help thanks

3. Shell Programming and Scripting

Run SQL queries in DB2 and output to file

Hi, I new to Unix and scripting. Following is my requirement. Can someone tell me whether its possible or not. Also please let me know how to proceed further if this is possible. List of queries are stored in a file. For example, I have to run a query like this: Select * from &XYZ where...

4. Shell Programming and Scripting

To parse through the file and print output using awk or sed script

suppose if u have a file like that Hen ABCCSGSGSGJJJJK 15 Cock ABCCSGGGSGIJJJL 15 * * * * * * : * * * . * * * : Hen CFCDFCSDFCDERTF 30 Cock CHCDFCSDHCDEGFI 30 * . * * * * * * * : * * :* : : . The output shud be where there is : and . It shud...

5. Shell Programming and Scripting

SQL Script's output to a CSV file

I need to call and execute an SQL script within a KSH script and get the output/extracted data into a CSV file. Is there any way to get the out put in a CSV file other than spooling ? I tried spooling. Problem is if there is any wrning/comment/Error they all will be spooled into the csv file. I...

6. Shell Programming and Scripting

awk command : To print the output to a file

half of the problem is already solved with the help of bartus11 suggestion I have a txt file having rows and coulmns, i want to perform some operation on a specific coulmn starting from a specific line. 50.000000 1 1 1 1000.00000 1000.00000 ...

7. Shell Programming and Scripting

Run a program-print parameters to output file-replace op file contents with max 4th col

Hi Friends, This is the only solution to my task. So, any help is highly appreciated. I have a file cat input1.bed chr1 100 200 abc chr1 120 300 def chr1 145 226 ghi chr2 567 600 unix Now, I have another file by name input2.bed (This file is a binary file not readable by the...

8. Shell Programming and Scripting

awk script to search output for a value and print

GOODNUMBERS="1 2 3 4 5 6 3 3 34 34 5 66 12" BADNUMBERS="7 3 12 5 66" for eachnum in `echo ${GOODNUMBERS}` do echo ${BADNUMBERS} | gawk -v threshold=${eachnum} '$1 != threshold' done what im trying to do with the above is, i want to print numbers that are in the GOODNUMBERS...

9. Shell Programming and Scripting

awk to print field from lookup file in output

The below awk uses $3 and $4 in search as the min and max, then takes each $2 value in lookup and compares it. If the value in lookupfalls within the range in searchthen it prints the entire line in lookup/ICODE]. What I can't seem to figure out is how to print the matching $5 from search on that...

10. Shell Programming and Scripting

Run sql query in shell script and output data save as delimited text

I want to run sql query in shell script and output data save as delimited text (delimited text would be comma) Code: SPOOL_FILE=/pgedw/dan.txt SQL=/pgedw/dan.sql sqlplus -s username/password@myhost:port/servicename <<EOF set head on set COLSEP , set linesize 32767 SET TRIMSPOOL ON SET...

LEARN ABOUT BSD

nfdump

NFDUMP(8)						      System Manager's Manual							 NFDUMP(8)

NAME

       nfdump, nfload - notesfile dump/load programs

SYNOPSIS

       nfdump notesfile

       nfload [ -Ddirectory ] notesfile

DESCRIPTION

       Nfdump and nfload are used to convert notesfile data base formats.

       Nfdump  converts  the  specified  notesfile  to a portable ASCII format and writes it to standard output.  Some diagnostics are produced on
       stderr.	Nfdump can be run by any user; access to a particular notesfile is governed by that notesfile's access list.

       Nfload is used on the output from nfdump to create a new notesfile.  The -D option specifies an alternate base directory for the notesfile.
       If unspecified, this defaults to ``/usr/spool/notes''.  Nfload reads standard input for the ASCII representation of the notesfile.

       Typical	use  of  these	two programs occurs when converting an existing notesfile data base to a new format.  The nfdump program should be
       compiled with the older structure definitions while nfload is compiled with the newer structures.  The data base can then be converted with
       a shell script of the following nature:

	    mkdir .OLD
	    mv * .OLD
	    for i in `ls .OLD`
	    do
		 echo $i start
		 nfdump $i | nfload -D/usr/spool/newnotes $i
	    done
		 echo $i done
	    echo ALL DONE
	    rm -rf .OLD

       This assumes that the old data base is in ``/usr/spool/notes'' and the new data base is to be placed in ``/usr/spool/newnotes''.  After the
       conversion is complete, one can move the old data base from ``/usr/spool/notes'' to ``/usr/spool/oldformat'' and the  new  data	base  from
       ``/usr/spool/newnotes'' to ``/usr/spool/notes''.

FILES

SEE ALSO

       notes(1),
       The Notesfile Reference Manual

AUTHORS

       Ray Essick (uiucdcs!essick, essick%uiuc@csnet-relay.arpa)
       Department of Computer Science
       University of Illinois at Urbana-Champaign
       Urbana, IL

       Rob Kolstad (kolstad@convex.UUCP)
       CONVEX Computer Corporation
       Richardson, TX

							      University of Illinois							 NFDUMP(8)