Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: scanning for '0' value in .txt file
Top Forums Shell Programming and Scripting scanning for '0' value in .txt file Post 56694 by google on Friday 8th of October 2004 06:14:49 AM
Old 10-08-2004
You could try something like this, though admittedly, I am not sure if VALUE will actually contain the result you are looking for. In your sql file, you will need to turn headings off (assuming you are using Oracle) and set server output on:

Code:
VALUE=$(sqlplus -s user/password@test_id <<EOF
@my_sql_statement
EOF)

if [ $VALUE -gt 0 ]
 then
   email me
fi

If this didnt work for you, then you could try spooling the value of your sql statement and then parse the spool file for your result. You could do this using an number of tools such as grep, awk, cut, etc. The idea is the same, search for the pattern and evaluate if it is greater than 0.
Last edited by google; 10-08-2004 at 08:27 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to zip a modified file 15 days before but not scanning my sub directory files

I am using zip -m option to zip my files, but i dont want my sub directories files to be zipped (1 Reply)
Discussion started by: skrish70
1 Replies

2. UNIX for Advanced & Expert Users

Scanning file backwards

Is there any way to look for a directory path that is listed any number of lines *before* a keyword in an error message? I have a script that is trying to process different files that are always down a certain portion of a path, and if there is an error, then says there is an error, contact... (2 Replies)
Discussion started by: tekster757
2 Replies

3. UNIX for Dummies Questions & Answers

Binary txt file received when i use uuencode to send txt file as attachment

Hi, I have already read a lot of posts on sending attachments in unix...but none of them were of help for my problem...so here goes.. i wanna attach a text file and send to a mail id..used the following code : uuencode "$File1" "$File1" ;|mail -s "$Mail_sub" abc@abc.com it works... (2 Replies)
Discussion started by: ash22
2 Replies

4. Shell Programming and Scripting

command to list .txt and .TXT file

Hi expersts, in my directory i have *.txt and *.TXT and *.TXT.log, *.txt.log I want list only .txt and .TXT files in one command... how to ?? //purple (1 Reply)
Discussion started by: thepurple
1 Replies

5. UNIX for Dummies Questions & Answers

scanning the file for a particular column

I have a file containing 4 columns. need to scan that file, if all the rows in the column4 have a value ZERO, it should print "everything is fine". And if all are not ZERO , at the first encounter of non ZERO value of 4th column it should print "some problem " may be a silly question, but at... (11 Replies)
Discussion started by: gotam
11 Replies

6. Shell Programming and Scripting

awk append fileA.txt to growing file B.txt

This is appending a column. My question is fairly simple. I have a program generating data in a form like so: 1 20 2 22 3 23 4 12 5 43 For ever iteration I'm generating this data. I have the basic idea with cut -f 2 fileA.txt | paste -d >> FileB.txt ???? I want FileB.txt to grow, and... (4 Replies)
Discussion started by: theawknewbie
4 Replies

7. Shell Programming and Scripting

Need to append the date | abcddate.txt to the first line of my txt file

I want to add/append the info in the following format to my.txt file. 20130702|abcd20130702.txt FN|SN|DOB I tried the below script but it throws me some exceptions. <#!/bin/sh dt = date '+%y%m%d'members; echo $dt+|+members+$dt; /usr/bin/awk -f BEGIN { FS="|"; OFS="|"; } { print... (6 Replies)
Discussion started by: harik1982
6 Replies

8. Shell Programming and Scripting

Reg scanning time based log file

Hi, I have a requirement to scan Oracle's alert log file. This file logs all event for Oracle database and each line will have timestamp followed by messages (which might be one or more lines). Example. Thu Aug 15 17:35:59 2013 VKTM detected a time drift. Please check trace file for more... (1 Reply)
Discussion started by: manickaraja
1 Replies

9. Shell Programming and Scripting

Desired output.txt for reading txt file using awk?

Dear all, I have a huge txt file (DATA.txt) with the following content . From this txt file, I want the following output using some shell script. Any help is greatly appreciated. Greetings, emily DATA.txt (snippet of the huge text file) 407202849... (2 Replies)
Discussion started by: emily
2 Replies

10. Shell Programming and Scripting

Scanning a pdf file in Linux shell

I want to search a keyword in a list of pdf files and when i find a match i want to write the title and author of that pdf file to another file. How will I do this using linux shell script? (7 Replies)
Discussion started by: SK33
7 Replies

LEARN ABOUT REDHAT

nwfstime

NWFSTIME(1)							     nwfstime							       NWFSTIME(1)

NAME

       nwfstime - Display / Set a NetWare server's date and time

SYNOPSIS

       nwfstime [ -h ] [ -S server ] [ -U user name ] [ -P password | -n ] [ -C ] [ -s ]

DESCRIPTION

       nwfstime displays a NetWare server's date and time. You can also set a NetWare server's date and time from the local time.

OPTIONS

       -h
	  With -h nwfstime prints a little help text.

       -S server
	  is the name of the server you want to use.

       -U user
	  user is the user name to use for login. To set the server's time, you need supervisor privileges.

       -P password
	  password  is	the password to use for login. If neither -n nor -P are given, and the user has no open connection to the server, nwfstime
	  prompts for a password.

       -n
	  -n should be given if no password is required for the login. As you need supervisor privileges for  setting  the  date  and  time,  this
	  option is probably not used very often.

       -C
	  By default, passwords are converted to uppercase before they are sent to the server, because most servers require this. You can turn off
	  this conversion by -C.

       -s
	  With -s, nwfstime sets the file server's date and time according to the local date and time.

nwfstime							    12/10/1996							       NWFSTIME(1)
All times are GMT -4. The time now is 08:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy