Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need help with Isql record count
Top Forums Shell Programming and Scripting Need help with Isql record count Post 302095743 by johnu122 on Thursday 9th of November 2006 08:51:36 PM
Old 11-09-2006
Need help with Isql record count
What I am trying to do is check if the database query returned any records.
If no records returned then output a message else output results to a file.
Right now if I take out the if and else statements the code runs fine and sends the email. If no records returned the email sends the column names. I would like to send a message instead of the column heading.
Here is my code can anyone help?

Code:
#!/bin/ksh
#cd /home/john/

. sybase
. ss_pto.id

echo "****** Please do not reply to this message ******" > ss_pto.status
echo " " >> ss_pto.status
echo New PTO and Special Requests ADDED as of: `date` >> ss_pto.status
echo " " >> ss_pto.status
echo Please add to Outlook calendars: >> ss_pto.status
#export today=`date`


date '+%m %d %Y %H %M %S' | 
{ 
read MONTH DAY YEAR HOUR MINUTE SECOND
DAY=`expr "$DAY" - 1` 
case "$DAY" in 
        0) 
           MONTH=`expr "$MONTH" - 1` 
                case "$MONTH" in 
                        0) 
                           MONTH=12 
                           YEAR=`expr "$YEAR" - 1` 
                        ;; 
                esac 
        DAY=`cal $MONTH $YEAR | grep . | fmt -1 | tail -1` 
esac 
 
} 
tempdate="$YEAR"-"$MONTH"-"$DAY"" ""$HOUR":"$MINUTE":"$SECOND"


isql -U $U -P $P -S $S -w1000 -o tmp_isql.status << label1
 use ptodb_rch01_prod
go
 select RTRIM(usr.fname) "First name", convert(char(20), usr.lname) "Last name", convert(char(15), ind.pto_date, 107) "PTO Date", ind.comments "Comments"
 from ss_pto_user usr, ss_pto_index ind
 where
 	ind.user_id = usr.user_id and ind.request_date >= '$tempdate' and (ind.class_id = 7 and ind.section_id = 5 or ind.class_id = 2 and ind.section_id = 4 ) 
 order by usr.lname asc

go
label1


reccnt=`wc -l tmp_isql.status`
if [reccnt = 0]
message="no records returned"
echo $message>>ss_pto.status
else
cat tmp_isql.status>>ss_pto.status

mailx -s"SS PTO" -senders email reciepents email < ss_pto.status

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to count the record count in an EBCDIC file.

How do I get the record count in an EBCDIC file on a Linux Box. :confused: (1 Reply)
Discussion started by: oracle8
1 Replies

2. Shell Programming and Scripting

record count

i have a file named file_names.dat where there are several files along with their path. exp: /data1/dir1/CTA_ACD_20071208.dat /data1/dir1/CTA_DFG_20071208.dat i want to write a script which will create a csv file with the name of the file and record count of that file the output file... (4 Replies)
Discussion started by: dr46014
4 Replies

3. Shell Programming and Scripting

replaying a record count with another record count

i use unix command to take the record count for a file1 awk 'END{print NR}' filename i already have a file2 which conatin the count like ... .. rec_cnt=100 .. .. I want to replace the record in the file2 using the record i take from file1. suggest me some simple ways of doing it... (2 Replies)
Discussion started by: er_zeeshan05
2 Replies

4. Shell Programming and Scripting

Validate record count

Hi all How to verify the number of records in case of delimited file, If the file has records. And then if it is not equal to mentioned no. of records, email is triggered and file is moved to bad directory path. Example ----- input file = a.txt bad directory path : /usr/bin/bad (6 Replies)
Discussion started by: balaji23_d
6 Replies

5. Shell Programming and Scripting

Character count per record

I have a flat file. How can i retrive the character count per record in whole file. Can anybody assist me on this Cheers (9 Replies)
Discussion started by: subrat
9 Replies

6. Shell Programming and Scripting

How to assign record count output of isql to a shell variable ?

isql select count(*) from Table eof How to assign record count output of isql query to a shell variable ? (4 Replies)
Discussion started by: vikram3.r
4 Replies

7. UNIX for Dummies Questions & Answers

Reduce the count on the 98 record by 2,

recod,amount,noofaccount,count 98,+00000187865779787,00319,000000640/ 99,+00000187865779787,00001,000000642/ thsi is my input file my question is 1) Reduce the count on the 98 record by 2 (6 Replies)
Discussion started by: sgoud
6 Replies

8. Shell Programming and Scripting

Validating the record count

Hi , I am having a text file with several records., it has a header record and trailer record. The header record has the number of rows (records) found in the text file and time-stamp. The footer record has the total number of records ( along with the header and trailer., Suppose: wc -l... (4 Replies)
Discussion started by: cratercrabs
4 Replies

9. Shell Programming and Scripting

count of record in files

Hi all, I have written a scripts which count number of lines in all the files in a directory and write in a text file. I don't know how to format it while writing. OS suns solaris 10 my scripts is as below for i in /ersdg3/ERS/ERS_INPUT_LOGS/RIO/LOGS/RIO_02-Aug-2012/ *.LOG do echo... (11 Replies)
Discussion started by: guddu_12
11 Replies

10. UNIX for Dummies Questions & Answers

Need record count on every 30 minute

We have the below records where we need record count of every 30 minute like 00:01 to 00:30 so in that we will have 48 record count in 24 hrs , and also we need sum of record count from 00:01 to 23:30. Please find sample data as well. 00:01 21 00:02 23 00:03 34 00:04 34 00:05 30... (10 Replies)
Discussion started by: nadeemrafikhan
10 Replies

LEARN ABOUT DEBIAN

btarcmp

BTARCMP(1)						      General Commands Manual							BTARCMP(1)

NAME

       btarcmp - a diff for Barry tar backup files

SYNOPSIS

       btarcmp [-b][-d db][-D db][-h][-I charset][-P][-S][-v] tar0 tar1

DESCRIPTION

       btarcmp	takes  two  Barry  backup  tar	files  on the command line, and displays the differences it finds between them.  If records can be
       parsed, individual field differences are also displayed.  Added and removed records are noted.  Differences in  database  availability  are
       noted as well.  If unable to parse the records, hex dumps are used.

OPTIONS

       -b     Use brief filename markers.  Useful when tar filenames are extremely long.

       -d db  Name  of	database  to compare.  Can be used multiple times to compare multiple databases.  If not specified, all databases are com-
	      pared.

       -D db  Name of database to skip.  Can be used multiple times.  Overrides all other database selection options.

       -h     Show summary of options.

       -I charset
	      Specifies the iconv charset to use for converting international strings.	The Blackberry uses the  WINDOWS-1252  charset,  which	is
	      incompatible with the more common code pages used in Linux.  The most useful charset to use with this option is UTF-8, and is highly
	      recommended.  Any other charset available via 'iconv --list' can be used here too, but may not be successful for some character con-
	      versions.

       -S     Displays list of known database records, which can be parsed.

       -v     Verbose output, which includes record data of added and deleted records in the output.  If used twice, hex data is printed as well.

AUTHOR

       btarcmp is part of the Barry project.

SEE ALSO

       http://www.netdirect.ca/barry

								 January 20, 2010							BTARCMP(1)
All times are GMT -4. The time now is 03:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy