Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: ksh script to validate the record count status
Top Forums UNIX for Beginners Questions & Answers ksh script to validate the record count status Post 303045398 by senmng on Thursday 19th of March 2020 12:23:26 PM
Old 03-19-2020
ksh script to validate the record count status
Hi - I have a KSH script to execute a oracle job to generate a data file and then ftp the same file to the downstream application. Here currently we have a validation check that not to send the file to downstream even if there is any partial record rejection with the data file. But i now want to transmit the file to the downstream if it's have single data of record irrespective of n number of rejection of records.Here is the snippet of code-

Code:
     LOG ="/dir/local/xyz`.log"

        TRNSERR=0
        CNT=1

        while [ $CNT -lt 4 ]
        do
                  ftp -nv < /local/cimspapp/CIMSbatch/script/FTP/CLAIMDNLD.ftp >> $sh_Trans

               cat $sh_Trans |grep -v bytes| awk '{print $1}' | egrep -e '530|425 > /dev/null
                # If error number found
                if [ $? -eq 0 ]
                then
                         echo "Error in Transmission" >> $sh_Trans
                         CNT=`expr $CNT + 1`
                        TRNSERR=1
                        
                else
                       grep -i "Not connected" $sh_Trans
                        if [ $? -eq 0 ]
                        then
                                echo "Connection Error" >> $sh_Trans
                                CNT=`expr $CNT + 1`
                                TRNSERR=1
                                sleep 100
                        else
                                TRNSERR=0
                                CNT=4
                        fi
                fi
        done

 

10 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

HELP WITH .ksh script converting the exit status

Hi Can someone help me please? In a standard UNIX .ksh script, if you have the exit status..say 5...what line do you have to enter into the script for this number to be automatically converted to its actual exit reason by looking up the exit status file...wherever that is? thanks angus (1 Reply)
Discussion started by: angusyoung
1 Replies

3. 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

4. Shell Programming and Scripting

Help in writing a KSH script to filter the latest record?

Hi All, I have a text file with the folowing content. BANGALORE|1417|2010-02-04 08:41:04.174|dob|xxx BANGALORE|1416|2010-02-04 08:23:19.566|dob|yyy BANGALORE|1415|2010-02-04 08:20:14.497|dob|aaa BANGALORE|1414|2010-02-04 08:19:40.065|dob|vvv BANGALORE|1413|2010-02-04... (4 Replies)
Discussion started by: Karpak
4 Replies

5. Shell Programming and Scripting

exit status from ksh script exec from java using runtime

how do i get the exit status from a ksh or perl script executed in a java program using Runtime? (1 Reply)
Discussion started by: twk
1 Replies

6. Shell Programming and Scripting

Exit status of the ksh Script

Hi Im trying to write a script that will archive some file using java program.Below is the part of the script that I use and my problem is that the script always return with status 0.Below is part of my script(end part) purge.ksh echo "No of files before tar :... (4 Replies)
Discussion started by: saachinsiva
4 Replies

7. Shell Programming and Scripting

Print record count of a file using shell script

HI, I need to print the record count of a file using shell script. If the record count of a file excluding header and trailer record if greater than zero then print 'Record count of a file is xxxx records'. If the record count is zero print 'zero records' Thanks Mahendra (1 Reply)
Discussion started by: mmeda
1 Replies

8. Shell Programming and Scripting

Validate file count in korn shell script

Hi, I have files in the directory like below which I need to validate if all the required files are present. A_B_001 of 002_time1.txt A_B_002 of 002_time1.txt A_B_001 of 001_time2.txt Scenarios- a)If file with 001 of 002_time1 or 002 of 002_time1 is missing in the folder,script should... (6 Replies)
Discussion started by: aneeta13
6 Replies

9. Shell Programming and Scripting

Any Sample ksh script to validate all the database objects

Hi, I need a sample script to validate all the database objects like 1. table structure(columns, datatypes,key contraints if any) 2. synonyms 3. grants 4. indexes ....etc thank you! (2 Replies)
Discussion started by: srikanth_sagi
2 Replies

10. UNIX for Beginners Questions & Answers

Ssh script to validate ssh connection to multiple serves with status

Hi, I want to validate ssh connection one after one for multiple servers..... password less keys already setup but now i want to validate if ssh is working fine or not... I have .sh script like below and i have servers.txt contains all the list of servers #/bin/bash for host in $(cat... (3 Replies)
Discussion started by: sreeram4
3 Replies

LEARN ABOUT NETBSD

sysinst

SYSINST(8)						    BSD System Manager's Manual 						SYSINST(8)

NAME

     sysinst -- install or upgrade a NetBSD system

SYNOPSIS

     sysinst [-D] [-f deffile] [-r releasename]

DESCRIPTION

     sysinst is a menu-based program that may be used to install or upgrade a NetBSD system.  It is usually invoked automatically when the system
     is booted from appropriate installation media.

     sysinst is usually not present on a NetBSD system that has been fully installed.

OPTIONS

     -D 	     Switch on debugging.

     -r releasename  Set the releasename if it is different to the one compiled.  Currently unused.

     -f deffile      Set a file for definitions other than the defaults.  See DEFINITION FILE for its format.

DEFINITION FILE

     The definition file is used to set several other names and directories to search for.  You can specify any of the options in the file.  They
     are stored as:
	   option = value
     pairs.  In this description, REL and MACH are the release and architecture respectively, determined by the image sysinst is used on.

     option name	 default value		  description
     release		 REL			  Release name (also set by -r releasename).
     machine		 MACH			  Machine architecture
     xfer dir		 /usr/INSTALL		  Transfer dir
     ext dir					  Extract dir (will usually be set later on)
     ftp host		 ftp.NetBSD.org 	  ftp host for fetching files
     ftp dir		 pub/NetBSD/NetBSD-REL	  ftp directory for fetching files
     ftp prefix 	 /MACH/binary/sets	  directory to look for sets. Note that this is used for all kinds of fetching (CDs, local FS,
						  ...), not only ftp.
     ftp user		 ftp			  ftp user for connecting
     ftp pass		 -			  ftp password
     ftp proxy		 -			  ftp proxy
     nfs host		 -			  nfs host for fetching via nfs
     nfs dir		 /bsd/release		  nfs directory for fetching files
     cd dev		 cd0a			  name of the CD device for fetching files
     fd dev		 /dev/fd0a		  name of floppy for fetching files
     local dev		 -			  Other device to be mounted for fetching files
     local fs		 ffs			  FS-type for local dev
     local dir		 release		  Directory to look for in the mounted local fs
     targetroot mount	 /targetroot		  Directory to mount target root dir to
     dist postfix	 .tgz			  Suffix of set files to be extracted
     diskname		 mydisk 		  disktab(5) diskname to use for target disk

SEE ALSO

     release(7), afterboot(8), boot(8), diskless(8)

     <machine>/INSTALL.* files on CD-ROM installation media .../NetBSD-<rel>/<machine>/INSTALL.* files in NetBSD releases or snapshots.

HISTORY

     A sysinst command appeared in NetBSD 1.3.

BSD
								September 17, 2011							       BSD
All times are GMT -4. The time now is 05:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy